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/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","as_of":"2026-04-08T08:10:14.036703+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/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3112a2dfdce13c5b","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-08T08:10:29.967188+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?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/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","source_event_id":"evt_359765330ee8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a03cf73080c9594c","published_at":"2026-04-08T05:06:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Colgate-Palmolive","relevance":"high","symbol":"CL","type":"company"}],"event_type":"other","information_gaps":["The provided article text does not include the actual list, ranking criteria, or any supporting fundamentals/metrics.","No information is provided about what \"low volatility\" refers to (time window, volatility measure) or whether the recommendation is based on valuation, earnings, or risk metrics.","No market price action, performance, or timing details (e.g., date of publication) are included in the provided text."],"key_facts":["Headline: \"Colgate-Palmolive (CL) \u2013 One of the 15 Best Low Volatility Blue Chip Stocks to Buy Now\"","Publisher domain indicated as finance.yahoo.com","No source summary or substantive article text was provided beyond page styling/HTML fragments"],"numeric_claims":[{"label":"list_size","value":"15"}],"primary_claim":"Colgate-Palmolive (CL) is included in a Yahoo Finance list of the 15 best low-volatility blue-chip stocks to buy now.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"Yahoo Finance headline states that Colgate-Palmolive (CL) is listed as one of the 15 best low-volatility blue-chip stocks to buy now. No additional article details are present in the provided text.","topics":["stock-picking","low volatility","blue-chip","investment recommendation","Yahoo Finance list"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"Colgate-Palmolive (CL) \u2013 One of the 15 Best Low Volatility Blue Chip Stocks to Buy Now - Yahoo Finance","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_b7e91a2872a1 in signals