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/CBMiekFVX3lxTE9pU1JGd3NxOVQtVUl2bVpjZENyR1N3YWdLcDlMVUZwS3FQcy15Rm5LcG1iNkstYUVmcTRWME9pczRxa2g1T0Y0ZHRYbmltZjFOVG1lR28xOElFZDhqSGRJNXRiY21tTVlBMElCX1hYSEpSNDQxUVpiUFVR?oc=5","as_of":"2026-04-12T10:44:03.648048+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/CBMiekFVX3lxTE9pU1JGd3NxOVQtVUl2bVpjZENyR1N3YWdLcDlMVUZwS3FQcy15Rm5LcG1iNkstYUVmcTRWME9pczRxa2g1T0Y0ZHRYbmltZjFOVG1lR28xOElFZDhqSGRJNXRiY21tTVlBMElCX1hYSEpSNDQxUVpiUFVR?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4437cfe8685dc93a","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-12T10:45:35.009991+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE9pU1JGd3NxOVQtVUl2bVpjZENyR1N3YWdLcDlMVUZwS3FQcy15Rm5LcG1iNkstYUVmcTRWME9pczRxa2g1T0Y0ZHRYbmltZjFOVG1lR28xOElFZDhqSGRJNXRiY21tTVlBMElCX1hYSEpSNDQxUVpiUFVR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sg.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE9pU1JGd3NxOVQtVUl2bVpjZENyR1N3YWdLcDlMVUZwS3FQcy15Rm5LcG1iNkstYUVmcTRWME9pczRxa2g1T0Y0ZHRYbmltZjFOVG1lR28xOElFZDhqSGRJNXRiY21tTVlBMElCX1hYSEpSNDQxUVpiUFVR?oc=5","source_event_id":"evt_c7d622d32687","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"9578531ba4cc2a87","published_at":"2026-04-12T10:36:04+00:00","publisher_domain":"sg.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Alaska Air","relevance":"high","symbol":"ALK","type":"company"},{"asset_class":"commodity","name":"Oil prices","relevance":"medium","symbol":"","type":"commodity"}],"event_type":"price_action","information_gaps":["No article text is available, so the specific \u201c10 stocks\u201d list, the methodology, and any supporting data are unknown.","No explicit oil price level, timeframe, or mechanism is provided in the available text.","No confirmation is available on whether the claim is an analyst forecast, screen result, or opinion piece."],"key_facts":["Headline is from Yahoo Finance Singapore (sg.finance.yahoo.com).","It names Alaska Air (ALK) and frames it as one of \u201c10 stocks\u201d that would \u201cskyrocket\u201d if oil prices fall."],"numeric_claims":[],"primary_claim":"Alaska Air (ALK) is presented as one of the 10 stocks that could skyrocket when oil prices fall.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The Yahoo Finance Singapore headline suggests Alaska Air (ALK) may be among 10 stocks expected to rise if oil prices fall. No article details are provided to confirm the list or rationale.","topics":["oil prices","stock performance","equities","market outlook"]},"source":"Yahoo Finance Singapore","source_domain":"sg.finance.yahoo.com","source_url":"https://sg.finance.yahoo.com","summary":"","tickers":[],"title":"Is Alaska Air (ALK) One Of The 10 Stocks That Will Skyrocket When Oil Prices Fall? - Yahoo Finance Singapore","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_11dfee8082df in signals