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/CBMikgFBVV95cUxPa3IwWGJMOHo1eDJJSVFWaTQtYTZtbkZCSEY2N3c1eFZXblFWaGpSZXUxVklXdE04RHJwOUVsM05FcHZYaTQ5R1ZsZkVpNzZPWUJfVmNnVVhtaVRjVGVHdl9aWFJfeWx1a2ZURTdkRzhpYjRTeHBEeWtxSGhqaWpxQzlObUZMcnBuZm1yUmVXRUNWUQ?oc=5","as_of":"2026-04-09T16:31:19.530613+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/CBMikgFBVV95cUxPa3IwWGJMOHo1eDJJSVFWaTQtYTZtbkZCSEY2N3c1eFZXblFWaGpSZXUxVklXdE04RHJwOUVsM05FcHZYaTQ5R1ZsZkVpNzZPWUJfVmNnVVhtaVRjVGVHdl9aWFJfeWx1a2ZURTdkRzhpYjRTeHBEeWtxSGhqaWpxQzlObUZMcnBuZm1yUmVXRUNWUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9fed502d7b0d01b8","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-09T23:56:50.298142+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPa3IwWGJMOHo1eDJJSVFWaTQtYTZtbkZCSEY2N3c1eFZXblFWaGpSZXUxVklXdE04RHJwOUVsM05FcHZYaTQ5R1ZsZkVpNzZPWUJfVmNnVVhtaVRjVGVHdl9aWFJfeWx1a2ZURTdkRzhpYjRTeHBEeWtxSGhqaWpxQzlObUZMcnBuZm1yUmVXRUNWUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxPa3IwWGJMOHo1eDJJSVFWaTQtYTZtbkZCSEY2N3c1eFZXblFWaGpSZXUxVklXdE04RHJwOUVsM05FcHZYaTQ5R1ZsZkVpNzZPWUJfVmNnVVhtaVRjVGVHdl9aWFJfeWx1a2ZURTdkRzhpYjRTeHBEeWtxSGhqaWpxQzlObUZMcnBuZm1yUmVXRUNWUQ?oc=5","source_event_id":"evt_97ab736064aa","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"be33008cfe87e6fa","published_at":"2026-04-09T16:14:43+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"\u201cMagnificent Seven\u201d stocks","relevance":"high","symbol":"","type":"equity_group"},{"asset_class":"investors","name":"Billionaire investors","relevance":"medium","symbol":"","type":"investor_group"},{"asset_class":"macro/market","name":"The Great Rotation","relevance":"high","symbol":"","type":"market_theme"}],"event_type":"price_action","information_gaps":["No specific company names or stock tickers are provided for the \u201cMagnificent Seven.\u201d","No evidence, figures, or descriptions of what \u201cloading up\u201d means (e.g., purchases, filings, amounts) are included in the provided text.","No timeframe for when the \u201cGreat Rotation\u201d impact occurred or when billionaire buying is expected is provided.","No market mechanism details (rates, sector rotation, fund flows) are included in the provided text.","No confirmation that the article contains verifiable data beyond the headline is available from the provided content (the supplied article text appears to be non-informative HTML/CSS)."],"key_facts":["Source is The Motley Fool.","Headline states that the \u201cGreat Rotation\u201d crushed \u201cMagnificent Seven\u201d stocks.","Headline states that billionaire investors are \u201cloading up\u201d (buying) the same stocks."],"numeric_claims":[],"primary_claim":"The \u201cGreat Rotation\u201d has crushed the \u201cMagnificent Seven\u201d stocks, and billionaire investors are loading up on them.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool headline claims that the \u201cGreat Rotation\u201d has hurt the \u201cMagnificent Seven\u201d stocks, while billionaire investors are allegedly buying more. The signal provides no specific tickers, dates, or quantified flows.","topics":["market rotation","equity performance","\u201cMagnificent Seven\u201d","billionaire buying","sentiment/positioning"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"The Great Rotation Crushed These \"Magnificent Seven\" Stocks. Billionaire Investors Are Loading Up. The Motley Fool","title":"The Great Rotation Crushed These \"Magnificent Seven\" Stocks. Billionaire Investors Are Loading Up. - The Motley Fool","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_a1a3b27de450 in signals