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/CBMiV0FVX3lxTE56Mzd2MVlvaDAwaThXeFlSdDBmUWNaaDRmLW9jdHN1RDV5ZW9DZjFIc2NBYnRoYkZYci1aSDBGeElRaW1Ic2FHNW0xUnNTQWhpUEZ4a1JnVQ?oc=5","as_of":"2026-04-08T11:20:01.592346+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiV0FVX3lxTE56Mzd2MVlvaDAwaThXeFlSdDBmUWNaaDRmLW9jdHN1RDV5ZW9DZjFIc2NBYnRoYkZYci1aSDBGeElRaW1Ic2FHNW0xUnNTQWhpUEZ4a1JnVQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_468acae6278dd1c7","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T11:20:30.870715+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiV0FVX3lxTE56Mzd2MVlvaDAwaThXeFlSdDBmUWNaaDRmLW9jdHN1RDV5ZW9DZjFIc2NBYnRoYkZYci1aSDBGeElRaW1Ic2FHNW0xUnNTQWhpUEZ4a1JnVQ?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/CBMiV0FVX3lxTE56Mzd2MVlvaDAwaThXeFlSdDBmUWNaaDRmLW9jdHN1RDV5ZW9DZjFIc2NBYnRoYkZYci1aSDBGeElRaW1Ic2FHNW0xUnNTQWhpUEZ4a1JnVQ?oc=5","source_event_id":"evt_703592bcdce4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7adbf867d72d0381","published_at":"2026-04-08T09:45:11+00:00","publisher_domain":"sg.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Wheaton Precious Metals Corp.","relevance":"high","symbol":"WPM","type":"company"}],"event_type":"other","information_gaps":["No actual article headlines or summaries are present beyond the page title.","No information about price action, earnings, guidance, corporate actions, or catalysts is included.","The cleaned article text appears to be mostly CSS/HTML boilerplate and does not contain extractable news content."],"key_facts":["Headline text references \u201cWheaton Precious Metals Corp. (WPM) latest stock news and headlines - Yahoo Finance Singapore.\u201d"],"numeric_claims":[],"primary_claim":"The signal indicates that Yahoo Finance Singapore has \u201clatest stock news and headlines\u201d for Wheaton Precious Metals Corp. (WPM).","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided signal contains only a Yahoo Finance Singapore page title referencing Wheaton Precious Metals Corp. (WPM) stock news. No specific market-moving headline, price move, or article content is included in the text provided.","topics":["market headlines","stock news","Yahoo Finance Singapore"]},"source":"Yahoo Finance Singapore","source_domain":"sg.finance.yahoo.com","source_url":"https://sg.finance.yahoo.com","summary":"","tickers":[],"title":"Wheaton Precious Metals Corp. (WPM) latest stock news and headlines - Yahoo Finance Singapore","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_9b3e5afaabea in signals