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/CBMingFBVV95cUxPSFZvemhGZ2tnNTlGRWJvWG12MmVWUXBOeHRIazYyWW9sLTZjZW85V0k2Q3QxczBFX1o2cnpXVDJxTUhKMzRHTTYtNTRfWXpnNjFtUmJxM3BqT1lqcnE5S0d5Z3I5YUhBaVpGNnBCRTd2b2pVZENQWXpSc3ZwM0NUSlhxWmN4eEVYbDZJaEFpR08xcTZmOFc2eUVkTDV3UQ?oc=5","as_of":"2026-04-10T18:45:21.228370+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/CBMingFBVV95cUxPSFZvemhGZ2tnNTlGRWJvWG12MmVWUXBOeHRIazYyWW9sLTZjZW85V0k2Q3QxczBFX1o2cnpXVDJxTUhKMzRHTTYtNTRfWXpnNjFtUmJxM3BqT1lqcnE5S0d5Z3I5YUhBaVpGNnBCRTd2b2pVZENQWXpSc3ZwM0NUSlhxWmN4eEVYbDZJaEFpR08xcTZmOFc2eUVkTDV3UQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0b4f074c068b5476","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-10T18:48:04.731162+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxPSFZvemhGZ2tnNTlGRWJvWG12MmVWUXBOeHRIazYyWW9sLTZjZW85V0k2Q3QxczBFX1o2cnpXVDJxTUhKMzRHTTYtNTRfWXpnNjFtUmJxM3BqT1lqcnE5S0d5Z3I5YUhBaVpGNnBCRTd2b2pVZENQWXpSc3ZwM0NUSlhxWmN4eEVYbDZJaEFpR08xcTZmOFc2eUVkTDV3UQ?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/CBMingFBVV95cUxPSFZvemhGZ2tnNTlGRWJvWG12MmVWUXBOeHRIazYyWW9sLTZjZW85V0k2Q3QxczBFX1o2cnpXVDJxTUhKMzRHTTYtNTRfWXpnNjFtUmJxM3BqT1lqcnE5S0d5Z3I5YUhBaVpGNnBCRTd2b2pVZENQWXpSc3ZwM0NUSlhxWmN4eEVYbDZJaEFpR08xcTZmOFc2eUVkTDV3UQ?oc=5","source_event_id":"evt_ba9781a5c1a1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3231df2f24c8c8fa","published_at":"2026-04-10T13:50:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Yahoo Finance","relevance":"source of the headline/article","symbol":"","type":"publisher"},{"asset_class":"equities","name":"\u201cMagnificent Seven\u201d","relevance":"benchmark referenced in the headline","symbol":"","type":"market_basket"}],"event_type":"other","information_gaps":["The two specific stocks (company names and ticker symbols) are not included in the provided text.","No rationale/metrics (e.g., valuation, earnings, growth, risk) are included in the provided text.","No timing/catalyst information is provided beyond the existence of the article.","No market reaction, price action, or trading guidance is included in the provided text."],"key_facts":["Headline: \u201c2 Stocks That Are Better Buys Than the \u2018Magnificent Seven\u2019 - Yahoo Finance.\u201d","Source summary repeats the same claim: \u201c2 Stocks That Are Better Buys Than the \u2018Magnificent Seven\u2019.\u201d","No stock tickers or company names for the \u201c2 Stocks\u201d are present in the provided text."],"numeric_claims":[],"primary_claim":"The Yahoo Finance article states that two stocks are better buys than the \u201cMagnificent Seven.\u201d","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"Yahoo Finance published an article claiming there are two stocks that are better buys than the \u201cMagnificent Seven.\u201d The provided text does not include the names of the two stocks or any supporting details.","topics":["stock picking","equity investing","valuation/relative attractiveness"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"2 Stocks That Are Better Buys Than the \"Magnificent Seven\" Yahoo Finance","title":"2 Stocks That Are Better Buys Than the \"Magnificent Seven\" - 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_64621d60d33d in signals