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/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR?oc=5","as_of":"2026-04-10T04:47:24.599020+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/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b109e5bd8aba6783","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-10T04:47:48.011375+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR?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/CBMid0FVX3lxTE1NS1pmWU1UMG9sb3J4ME8tWmZJdVF5YzI5M0RyS2ZESklwNmJuQXR5T2YwWTdUMmFwUDhCejVXZUczbHB4aFhCaUVEVl9Uczh6MmlEVjRIYVhrYlRnQ1hVUnRCbkE5eDVUeUwzcGFFOUdSMk5JUWpR?oc=5","source_event_id":"evt_add4be5fcf91","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8c48c38fe93e9788","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":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"media","name":"CNBC","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"equity_index_derivative","name":"S&P 500 futures","relevance":"high","symbol":"^GSPC (context)","type":"index_derivative"},{"asset_class":"equity_index_derivative","name":"Nasdaq futures","relevance":"high","symbol":"^IXIC (context)","type":"index_derivative"},{"asset_class":"equity_index_derivative","name":"Dow futures","relevance":"medium","symbol":"^DJI (context)","type":"index_derivative"},{"asset_class":"commodity","name":"Oil","relevance":"medium","symbol":"WTI/Brent (unspecified)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly page styling/HTML and does not contain the substantive live-update content; only the headline and the provided source summary were usable.","No specific time of day, magnitude of futures moves, or which exact ceasefire breach report is referenced in the provided text.","No specific companies/sectors are identified as beneficiaries or losers; only broad index futures and oil are mentioned.","The directionality is inferred from 'little changed' and 'hopes' language, but exact market direction at the time of the CNBC update is not fully specified in the provided content."],"key_facts":["CNBC headline states stock futures were little changed as traders monitored a fragile ceasefire between the U.S. and Iran (live updates).","Source summary indicates the ceasefire was described as fragile and that there were reports it may have been broken, affecting market sentiment.","Source summary also indicates U.S. stocks rose and oil gains trimmed on hopes for the ceasefire (implying a link between ceasefire expectations and risk/energy pricing)."],"numeric_claims":[],"primary_claim":"Stock futures were little changed while traders monitored a fragile U.S.\u2013Iran ceasefire, including reports that it may have been broken.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"U.S. stock futures were largely flat as traders closely watched a fragile U.S.\u2013Iran ceasefire, with market sentiment tied to whether the ceasefire holds. The near-term catalyst is continued ceasefire monitoring and any reported breaches.","topics":["stock futures","ceasefire monitoring","U.S.-Iran geopolitical risk","market sentiment","oil price reaction"]},"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 today: Dow, S&P 500, Nasdaq futures pause rally after Iran says ceasefire has been broken Yahoo Finance US stocks rise and oil prices trim their gains on hopes for the ceasefire with Iran AP News S&P 500, Nasdaq Extend Win Streaks Amid Ceasefire Hopes; 3 New Breakouts To Watch Investor's Business Daily Wall Street\u2019s Eyes on the Strait New York Magazine","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_c35caa83c03c in signals