SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T18:49:35.325186+00:00","dedupe_key":"signal_enriched:market_headline_delta:de38771e67da379c","evidence_event_ids":["evt_6f6933921d40"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","as_of":"2026-04-09T18:49:35.325186+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/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e9fe76c1417e0340","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-10T00:13:45.704140+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","source_event_id":"evt_6f6933921d40","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"289430414e3a3edf","published_at":"2026-04-09T18:07:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Alcoa","relevance":"high","symbol":"AA","type":"company"},{"asset_class":"equity_sector","name":"Aluminum stocks","relevance":"high","symbol":"","type":"sector"},{"asset_class":"macro_geopolitical","name":"Iran war","relevance":"medium","symbol":"","type":"geopolitical_event"}],"event_type":"price_action","information_gaps":["No tickers for the broader aluminum stocks are provided in the provided text.","No details are given on the magnitude of the breakout, which specific aluminum stocks are included, or the timeframe.","No earnings date/time for Alcoa is provided in the provided text.","No causal mechanism is described for how the Iran war relates to aluminum stock price action in the provided text."],"key_facts":["Investor's Business Daily headline states: \"Aluminum Stocks Extend Breakouts Amid Iran War.\"","Headline also states: \"Alcoa Earnings Due.\"","The phrasing \"Extend Breakouts\" indicates continuation of an existing upward move (directional implication), not a reversal."],"numeric_claims":[],"primary_claim":"Aluminum stocks are extending breakouts amid the Iran war, with Alcoa earnings due.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"The headline says aluminum stocks are extending breakouts amid the Iran war, and notes that Alcoa earnings are due. It implies bullish continuation in aluminum equities while a specific catalyst (Alcoa earnings) is upcoming.","topics":["aluminum equities","breakouts","earnings catalyst","geopolitical risk (Iran war)"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"","tickers":[],"title":"Aluminum Stocks Extend Breakouts Amid Iran War. Alcoa Earnings Due. - Investor's Business Daily","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 10979 in events