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/CBMiswFBVV95cUxOZkVsdGpMY0FnSmpQMEVHZ1B6Q0VZaUhmWW9fREt5RURjbk9sSXR3TWcweW8wYXI2VWFIbW9Eck55X094Q2xxOUo2T21qWDZyUlU5M0oyc1ZFVTVNRDQxNFgtcjVKTnVqYVF6c0xuNmYwTmtqdVBicUxrX0RHV2U4VHE5MGN5MU56M2RHY3lpNFlFUDJNMmw0WktFT0dqUzYtSl9DQ2d6WTFHMlJHWDdQNkZPWQ?oc=5","as_of":"2026-04-09T18:00:21.914951+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/CBMiswFBVV95cUxOZkVsdGpMY0FnSmpQMEVHZ1B6Q0VZaUhmWW9fREt5RURjbk9sSXR3TWcweW8wYXI2VWFIbW9Eck55X094Q2xxOUo2T21qWDZyUlU5M0oyc1ZFVTVNRDQxNFgtcjVKTnVqYVF6c0xuNmYwTmtqdVBicUxrX0RHV2U4VHE5MGN5MU56M2RHY3lpNFlFUDJNMmw0WktFT0dqUzYtSl9DQ2d6WTFHMlJHWDdQNkZPWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_32d58e595c10993f","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:11:10.663655+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxOZkVsdGpMY0FnSmpQMEVHZ1B6Q0VZaUhmWW9fREt5RURjbk9sSXR3TWcweW8wYXI2VWFIbW9Eck55X094Q2xxOUo2T21qWDZyUlU5M0oyc1ZFVTVNRDQxNFgtcjVKTnVqYVF6c0xuNmYwTmtqdVBicUxrX0RHV2U4VHE5MGN5MU56M2RHY3lpNFlFUDJNMmw0WktFT0dqUzYtSl9DQ2d6WTFHMlJHWDdQNkZPWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"morningstar.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxOZkVsdGpMY0FnSmpQMEVHZ1B6Q0VZaUhmWW9fREt5RURjbk9sSXR3TWcweW8wYXI2VWFIbW9Eck55X094Q2xxOUo2T21qWDZyUlU5M0oyc1ZFVTVNRDQxNFgtcjVKTnVqYVF6c0xuNmYwTmtqdVBicUxrX0RHV2U4VHE5MGN5MU56M2RHY3lpNFlFUDJNMmw0WktFT0dqUzYtSl9DQ2d6WTFHMlJHWDdQNkZPWQ?oc=5","source_event_id":"evt_7f851c787383","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3c5a4dd936c0c0dd","published_at":"2026-04-09T17:44:38+00:00","publisher_domain":"morningstar.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"triggering party in the ceasefire context","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"triggering party in the ceasefire context","symbol":"","type":"country"},{"asset_class":"","name":"Morningstar","relevance":"source of the headline and framing","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided about the ceasefire date/time, duration, or terms.","No specific market index, sector, or magnitude of the rally is stated in the provided text.","No specific portfolio/asset classes or strategies are mentioned beyond the general question about volatility.","The article\u2019s additional supporting evidence (e.g., which stocks moved, by how much, and when) is not present in the provided content."],"key_facts":["The headline states that stocks rallied after the US\u2013Iran ceasefire.","The headline asks whether a portfolio is positioned for volatility following the rally.","The source is Morningstar (morningstar.com)."],"numeric_claims":[],"primary_claim":"Stocks rallied after the US\u2013Iran ceasefire, according to Morningstar.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Morningstar reports that stocks rallied following a US\u2013Iran ceasefire and frames this as a setup for potential portfolio volatility.","topics":["US\u2013Iran ceasefire","stock market rally","portfolio positioning","volatility"]},"source":"Morningstar","source_domain":"morningstar.com","source_url":"https://www.morningstar.com","summary":"Stocks Rallied After the US\u2013Iran Ceasefire. Is Your Portfolio Positioned for the Volatility? Morningstar","title":"Stocks Rallied After the US\u2013Iran Ceasefire. Is Your Portfolio Positioned for the Volatility? - Morningstar","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_a312cbf359de in signals