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/CBMioAFBVV95cUxOcFMzUTNTZEgxWFFsSzBJcmlxcVl4d0k3LVM2Q1A0OTJzRkRuSFZ5VURzQUlzOFFWMFBobWtxSmM3SVAtUW1ndnNwaDBObGo4S1hCaTd3c19FT2lDaEwyQ3JYNWYtUWNVdTFZa2liWHA1amI1dVI3aWhENnkwTk50czRDUlRVTkEzb0NCRjY0LTdIaVRzTXRKZ0lFSlFQdHhN?oc=5","as_of":"2026-04-13T14:49:37.217753+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOcFMzUTNTZEgxWFFsSzBJcmlxcVl4d0k3LVM2Q1A0OTJzRkRuSFZ5VURzQUlzOFFWMFBobWtxSmM3SVAtUW1ndnNwaDBObGo4S1hCaTd3c19FT2lDaEwyQ3JYNWYtUWNVdTFZa2liWHA1amI1dVI3aWhENnkwTk50czRDUlRVTkEzb0NCRjY0LTdIaVRzTXRKZ0lFSlFQdHhN?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_90d63223eb704f58","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T22:04:12.165250+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOcFMzUTNTZEgxWFFsSzBJcmlxcVl4d0k3LVM2Q1A0OTJzRkRuSFZ5VURzQUlzOFFWMFBobWtxSmM3SVAtUW1ndnNwaDBObGo4S1hCaTd3c19FT2lDaEwyQ3JYNWYtUWNVdTFZa2liWHA1amI1dVI3aWhENnkwTk50czRDUlRVTkEzb0NCRjY0LTdIaVRzTXRKZ0lFSlFQdHhN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOcFMzUTNTZEgxWFFsSzBJcmlxcVl4d0k3LVM2Q1A0OTJzRkRuSFZ5VURzQUlzOFFWMFBobWtxSmM3SVAtUW1ndnNwaDBObGo4S1hCaTd3c19FT2lDaEwyQ3JYNWYtUWNVdTFZa2liWHA1amI1dVI3aWhENnkwTk50czRDUlRVTkEzb0NCRjY0LTdIaVRzTXRKZ0lFSlFQdHhN?oc=5","source_event_id":"evt_2299ef24d23d","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"4a8aa1d707a06012","published_at":"2026-04-13T13:10:54+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Yahoo Finance","relevance":"source of the headline","symbol":"","type":"publisher"},{"asset_class":"equity_index","name":"US stocks","relevance":"described as selling off","symbol":"","type":"market"}],"event_type":"price_action","information_gaps":["The two ETF names/tickers are not provided.","No details on the rationale, risk factors, or performance metrics are provided.","No timing/catalyst window is provided beyond the general phrase \u201cas US stocks sell off.\u201d","No information on which US stocks or indices are selling off is provided.","No article body text is available to confirm the exact recommendations."],"key_facts":["Headline references \u201c2 International ETFs to Buy.\u201d","Headline references \u201cUS Stocks Sell Off.\u201d","Source provided is Yahoo Finance (finance.yahoo.com)."],"numeric_claims":[],"primary_claim":"Yahoo Finance published a piece titled \u201c2 International ETFs to Buy as US Stocks Sell Off,\u201d implying two international ETFs are recommended for purchase amid a US stock sell-off.","relevance_score":0.35,"sentiment":"mixed","source_quality":"unknown","summary":"The Yahoo Finance headline indicates an article recommending two international ETFs to buy during a US stock sell-off. No ETF tickers, country/sector focus, or timing details are provided in the supplied text.","topics":["international ETFs","US stock sell-off","investment recommendations"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"2 International ETFs to Buy as US Stocks Sell Off Yahoo Finance","title":"2 International ETFs to Buy as US Stocks Sell Off - Yahoo Finance","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_7c5fbe82f9b7 in signals