SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","as_of":"2026-04-07T11:22:47.255035+00:00","canonical_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0a3c2f6b8a41b15e","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T11:52:14.299861+00:00","extraction_method":"heuristic","fetched_description":"With extremely defensible technologies, Lam Research is among the leading semiconductor stocks in the market today.","fetched_title":"Bull of the Day: Lam Research (LRCX) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0","source_event_id":"evt_6d39702782dc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f0aeec175112e713","kind":"options_flow","published_at":"2026-04-07T08:30:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 07, 2026"],"entities":[{"asset_class":"equity","name":"Lam Research","relevance":"primary","symbol":"LRCX","type":"company"}],"event_type":"other","information_gaps":["No specific options flow data provided (direction, size, expiry, etc.).","No details on current options market activity for LRCX."],"key_facts":["Lam Research holds a near-duopoly in etch and deposition equipment for semiconductors.","Earnings are projected to rise 26.6% this year and 27% next year.","The stock has compounded at 39% annually over the past decade."],"numeric_claims":[{"label":"Projected earnings growth this year","value":"26.6%"},{"label":"Projected earnings growth next year","value":"27%"},{"label":"Forward P/E ratio","value":"41.7x"}],"primary_claim":"Lam Research is well positioned to benefit from the growing demand for advanced semiconductors, with earnings projected to rise significantly.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Lam Research (LRCX) is highlighted as a leading semiconductor stock with strong growth prospects, particularly in etch and deposition technologies, despite its elevated valuation.","topics":["semiconductors","earnings growth","investment opportunity"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"With extremely defensible technologies, Lam Research is among the leading semiconductor stocks in the market today.","tickers":["LRCX"],"title":"Bull of the Day: Lam Research (LRCX)","url":"https://www.nasdaq.com/articles/bull-day-lam-research-lrcx-0"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_7739e78d3d30 in signals