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/CBMimwFBVV95cUxNelJkSThkalpQSDlXajV2dEJBNHZ2UnFCTlVCM3dhZ1ZCMHlJczM3cVFuZ2h1OVc4N3VBMjFTc0lZbnJxcVYtTHdDVFdqbVFmam1iR2dBNkxYUG4xR01tWjlXbXZmN21WeEh1blBxNzh1dFhjeDQyN085Vm1sRjhNdjludlVBMmo4M1JmVW13ZnpleW45eldZYnJOWQ?oc=5","as_of":"2026-04-08T19:57:42.365437+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/CBMimwFBVV95cUxNelJkSThkalpQSDlXajV2dEJBNHZ2UnFCTlVCM3dhZ1ZCMHlJczM3cVFuZ2h1OVc4N3VBMjFTc0lZbnJxcVYtTHdDVFdqbVFmam1iR2dBNkxYUG4xR01tWjlXbXZmN21WeEh1blBxNzh1dFhjeDQyN085Vm1sRjhNdjludlVBMmo4M1JmVW13ZnpleW45eldZYnJOWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5e0aa6492cbaa1e5","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-09T22:39:16.873892+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNelJkSThkalpQSDlXajV2dEJBNHZ2UnFCTlVCM3dhZ1ZCMHlJczM3cVFuZ2h1OVc4N3VBMjFTc0lZbnJxcVYtTHdDVFdqbVFmam1iR2dBNkxYUG4xR01tWjlXbXZmN21WeEh1blBxNzh1dFhjeDQyN085Vm1sRjhNdjludlVBMmo4M1JmVW13ZnpleW45eldZYnJOWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNelJkSThkalpQSDlXajV2dEJBNHZ2UnFCTlVCM3dhZ1ZCMHlJczM3cVFuZ2h1OVc4N3VBMjFTc0lZbnJxcVYtTHdDVFdqbVFmam1iR2dBNkxYUG4xR01tWjlXbXZmN21WeEh1blBxNzh1dFhjeDQyN085Vm1sRjhNdjludlVBMmo4M1JmVW13ZnpleW45eldZYnJOWQ?oc=5","source_event_id":"evt_93f684457236","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cf50cfb44841c109","kind":"sector_rotation","published_at":"2026-04-08T09:03:53+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"Magnolia Oil Gas Corporation","relevance":"high","symbol":"","type":"company"}],"event_type":"other","information_gaps":["Which sectors are gaining and which are losing is not stated in the provided text.","The macro driver behind the sector rotation is not described in the provided text.","Whether the move is a regime shift vs short-term rebalancing is not stated.","No performance metrics, rankings, or quantified deltas are provided in the provided text.","The cleaned article content appears to be mostly HTML/CSS and does not include the substantive article body."],"key_facts":["Headline states: \u201cWill Magnolia Oil Gas Corporation benefit from sector rotation\u201d.","No additional sector rotation information (gaining/losing sectors, macro driver, or time horizon) is present in the provided cleaned article text."],"numeric_claims":[],"primary_claim":"The headline suggests a discussion about whether Magnolia Oil Gas Corporation may benefit from sector rotation, but the provided article text contains no supporting sector-rotation specifics.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided signal text does not contain any actual sector-rotation details (no sectors gaining/losing, macro driver, or regime-shift indicators). It only references a generic question about whether Magnolia Oil Gas Corporation could benefit from sector rotation.","topics":["sector rotation","US stocks recap","post-earnings","trading tips"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"US Stocks Recap: Will Magnolia Oil Gas Corporation benefit from sector rotation - 2026 PostEarnings & Daily Profit Maximizing Trade Tips baoquankhu1.vn","tickers":[],"title":"US Stocks Recap: Will Magnolia Oil Gas Corporation benefit from sector rotation - 2026 PostEarnings & Daily Profit Maximizing Trade Tips - baoquankhu1.vn","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_f4615c60a26a in signals