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/CBMi2gFBVV95cUxPTkhkN1c0SEVCVklPazhlWUJrVWlkWXo3bzFTQVJQQzhXVms0dkJHQXQ5azZ3bGMxcGNZbGcwV18xSDFyUHloVlVVcllHLUttMGpENzVwbFNYd0l3RUVzelk2TEJNcUoycnE4RXRLLVV0endTa3FMVUMza1ZTWXRidW1veERWN3hMRE9zZ1pQclMxdzJWRFpjTXlUSzdFanRCMXJCUHJ4M2JjR0dnZkMwSUVYamFBM1NKa0lGaHVxTEJiUFVPX0RMOVBWelMyS1M4Q09OM1k5RWk4dw?oc=5","as_of":"2026-04-09T22:44:28.307431+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/CBMi2gFBVV95cUxPTkhkN1c0SEVCVklPazhlWUJrVWlkWXo3bzFTQVJQQzhXVms0dkJHQXQ5azZ3bGMxcGNZbGcwV18xSDFyUHloVlVVcllHLUttMGpENzVwbFNYd0l3RUVzelk2TEJNcUoycnE4RXRLLVV0endTa3FMVUMza1ZTWXRidW1veERWN3hMRE9zZ1pQclMxdzJWRFpjTXlUSzdFanRCMXJCUHJ4M2JjR0dnZkMwSUVYamFBM1NKa0lGaHVxTEJiUFVPX0RMOVBWelMyS1M4Q09OM1k5RWk4dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0b6ba77916e6c0be","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-10T00:45:20.910521+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxPTkhkN1c0SEVCVklPazhlWUJrVWlkWXo3bzFTQVJQQzhXVms0dkJHQXQ5azZ3bGMxcGNZbGcwV18xSDFyUHloVlVVcllHLUttMGpENzVwbFNYd0l3RUVzelk2TEJNcUoycnE4RXRLLVV0endTa3FMVUMza1ZTWXRidW1veERWN3hMRE9zZ1pQclMxdzJWRFpjTXlUSzdFanRCMXJCUHJ4M2JjR0dnZkMwSUVYamFBM1NKa0lGaHVxTEJiUFVPX0RMOVBWelMyS1M4Q09OM1k5RWk4dw?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/CBMi2gFBVV95cUxPTkhkN1c0SEVCVklPazhlWUJrVWlkWXo3bzFTQVJQQzhXVms0dkJHQXQ5azZ3bGMxcGNZbGcwV18xSDFyUHloVlVVcllHLUttMGpENzVwbFNYd0l3RUVzelk2TEJNcUoycnE4RXRLLVV0endTa3FMVUMza1ZTWXRidW1veERWN3hMRE9zZ1pQclMxdzJWRFpjTXlUSzdFanRCMXJCUHJ4M2JjR0dnZkMwSUVYamFBM1NKa0lGaHVxTEJiUFVPX0RMOVBWelMyS1M4Q09OM1k5RWk4dw?oc=5","source_event_id":"evt_daa419ce16b8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8a5076b64d5bd185","published_at":"2026-04-09T21:53:32+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["Apr. 9"],"entities":[{"asset_class":"equity","name":"Nio","relevance":"high","symbol":"NIO","type":"company"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond the headline and metadata, so the magnitude of the move, timing, and market context are unknown.","The year for \u201cApr. 9\u201d is not explicitly stated in the provided text.","No additional tickers, indices, or quantitative performance metrics are included in the provided text."],"key_facts":["Headline states that Nio erased early gains.","Headline links the move to a \u201cnew electric SUV launch.\u201d","The report is dated Apr. 9 (year not specified in provided text)."],"numeric_claims":[],"primary_claim":"Nio erased early gains following the launch of a new electric SUV.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool reports that Nio\u2019s stock gave up early gains after launching a new electric SUV.","topics":["stock market today","Nio","electric SUV launch","intraday price movement","early gains erased"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today, Apr. 9: Nio Erases Early Gains Following New Electric SUV Launch - 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_59bf760d9c3f in signals