SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOb1BwckNENmpzYmExQzZTOXNGZWdvdkdfT3k2Q0IwVmNFUGRZekdab09BVGxLUFhrWjBoclRGUVFJVHRuRmpIR3BndjEycnBlYk5nSHZVYnpNODNXRDZXYzRCVVJTR2NLREFOUFVJX0hMTkNzdE8xcnVYdlpqSU15VFo0cXBHSW9ZeFA3N2JxQzRmQmRhQ3hobUZn?oc=5","as_of":"2026-04-11T03:04:51.757709+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOb1BwckNENmpzYmExQzZTOXNGZWdvdkdfT3k2Q0IwVmNFUGRZekdab09BVGxLUFhrWjBoclRGUVFJVHRuRmpIR3BndjEycnBlYk5nSHZVYnpNODNXRDZXYzRCVVJTR2NLREFOUFVJX0hMTkNzdE8xcnVYdlpqSU15VFo0cXBHSW9ZeFA3N2JxQzRmQmRhQ3hobUZn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d139d69e24650565","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T10:35:33.897045+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOb1BwckNENmpzYmExQzZTOXNGZWdvdkdfT3k2Q0IwVmNFUGRZekdab09BVGxLUFhrWjBoclRGUVFJVHRuRmpIR3BndjEycnBlYk5nSHZVYnpNODNXRDZXYzRCVVJTR2NLREFOUFVJX0hMTkNzdE8xcnVYdlpqSU15VFo0cXBHSW9ZeFA3N2JxQzRmQmRhQ3hobUZn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOb1BwckNENmpzYmExQzZTOXNGZWdvdkdfT3k2Q0IwVmNFUGRZekdab09BVGxLUFhrWjBoclRGUVFJVHRuRmpIR3BndjEycnBlYk5nSHZVYnpNODNXRDZXYzRCVVJTR2NLREFOUFVJX0hMTkNzdE8xcnVYdlpqSU15VFo0cXBHSW9ZeFA3N2JxQzRmQmRhQ3hobUZn?oc=5","source_event_id":"evt_3718c0859399","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"615518885348ac7a","published_at":"2026-04-10T19:00:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["April"],"entities":[{"asset_class":"equity","name":"Micron","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"2 More Momentum Stocks","relevance":"medium","symbol":"","type":"unspecified_companies"}],"event_type":"other","information_gaps":["The two additional stock names are not provided.","Micron\u2019s ticker symbol is not provided in the available text.","No near-term catalyst timing beyond \u201cThis April\u201d is specified.","No performance metrics, valuation, or fundamental/technical rationale is included in the provided text.","No confirmation of whether this is a new development vs. a general editorial list."],"key_facts":["Source is Yahoo Finance (finance.yahoo.com).","Headline mentions \u201cMicron\u201d and \u201c2 More Momentum Stocks\u201d to watch \u201cThis April.\u201d","No article body text is available, so the identities of the \u201c2 more\u201d stocks and any specific catalysts are not provided."],"numeric_claims":[],"primary_claim":"Yahoo Finance highlights Micron and two other momentum stocks for April.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"The Yahoo Finance headline promotes Micron and two other \u201cmomentum\u201d stocks to watch in April. No additional concrete details (prices, earnings, catalysts, or company actions) are provided in the available text.","topics":["stock picking","momentum investing","April watchlist"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"Micron & 2 More Momentum Stocks You Shouldn't Miss This April Yahoo Finance","title":"Micron & 2 More Momentum Stocks You Shouldn't Miss This April - Yahoo Finance","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

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_4e22c65d088e in signals