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/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR0gF8QVVfeXFMT3NYaXJ2SWwwU3ZMS3I0X242Z2ZuWTRiRDF0ckMtZUVJUkxQNzBEanYtOGtRNWxxTDM2ek1ReHBuSWV6ZXlDbkdlSHNhbXB1Q1VzcjFjSnNwZmp2TndDOWM4Z1VBcnkwdEcxTlZEbmoxTnczNTMtMXg2b1dkZQ?oc=5","as_of":"2026-04-10T05:02:39.525956+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/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR0gF8QVVfeXFMT3NYaXJ2SWwwU3ZMS3I0X242Z2ZuWTRiRDF0ckMtZUVJUkxQNzBEanYtOGtRNWxxTDM2ek1ReHBuSWV6ZXlDbkdlSHNhbXB1Q1VzcjFjSnNwZmp2TndDOWM4Z1VBcnkwdEcxTlZEbmoxTnczNTMtMXg2b1dkZQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9ab2780e46c2e9cc","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-10T05:03:12.407181+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR0gF8QVVfeXFMT3NYaXJ2SWwwU3ZMS3I0X242Z2ZuWTRiRDF0ckMtZUVJUkxQNzBEanYtOGtRNWxxTDM2ek1ReHBuSWV6ZXlDbkdlSHNhbXB1Q1VzcjFjSnNwZmp2TndDOWM4Z1VBcnkwdEcxTlZEbmoxTnczNTMtMXg2b1dkZQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR0gF8QVVfeXFMT3NYaXJ2SWwwU3ZMS3I0X242Z2ZuWTRiRDF0ckMtZUVJUkxQNzBEanYtOGtRNWxxTDM2ek1ReHBuSWV6ZXlDbkdlSHNhbXB1Q1VzcjFjSnNwZmp2TndDOWM4Z1VBcnkwdEcxTlZEbmoxTnczNTMtMXg2b1dkZQ?oc=5","source_event_id":"evt_d621d776167e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba58368de897faa3","published_at":"2026-04-10T04:13:00+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["April 9, 2026"],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"energy_infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic chokepoint"},{"asset_class":"equities","name":"U.S. stock index futures (Dow, S&P 500, Nasdaq)","relevance":"high","symbol":"","type":"market index futures"},{"asset_class":"commodity","name":"Oil","relevance":"medium","symbol":"","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["Exact magnitude/direction of each index future move (e.g., points or percent) is not provided in the excerpt.","Whether the ceasefire was newly announced vs. ongoing is not specified.","No specific timing for peace talks (date/time) is included in the provided text.","Oil price level/percentage change and which benchmark (WTI/Brent) are not specified in the excerpt.","The reason for the Strait of Hormuz closure (e.g., security/operational status) is not detailed."],"key_facts":["CNBC headline indicates U.S. stock futures were little changed while traders monitored a fragile U.S.\u2013Iran ceasefire (live updates).","Other provided summaries indicate U.S. index futures were inching down or stocks rose modestly while oil trimmed early gains on ceasefire optimism.","The Strait of Hormuz was reported as remaining closed ahead of peace talks, implying continued supply/transport risk.","Near-term catalyst is the ongoing ceasefire/peace-talk developments being monitored in live updates (timing not specified in the provided text)."],"numeric_claims":[],"primary_claim":"Stock futures were little changed as traders monitored a fragile U.S.\u2013Iran ceasefire, with oil gains trimmed on ceasefire optimism.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"U.S. stock futures were largely flat as traders watched a fragile U.S.\u2013Iran ceasefire and related peace-talk developments. Oil\u2019s early gains were pared amid hopes for the ceasefire, while the Strait of Hormuz remained closed, adding uncertainty to near-term risk sentiment.","topics":["U.S.\u2013Iran ceasefire","peace talks","stock futures","oil prices","Strait of Hormuz closure","risk sentiment"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Stock futures little changed as traders monitor fragile ceasefire between U.S. and Iran: Live updates CNBC Stock Market News, April 9, 2026: Dow Turns Higher, Oil Pares Early Gains WSJ US stocks rise and oil prices trim their gains on hopes for the ceasefire with Iran AP News Stock market today: Dow, S&P 500, Nasdaq futures inch down as Strait of Hormuz remains closed ahead of peace talks Yahoo Finance Markets News, April 9, 2026: U.S. Indexes End Higher, Oil Pares Gains on Iran Ceasefire Optimism; Dow Turns Positive for Year Investopedia","title":"Stock futures little changed as traders monitor fragile ceasefire between U.S. and Iran: Live updates - CNBC","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_af5d8d2d0a7c in signals