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/CBMiaEFVX3lxTFBHN0FvNVMwNzhYNWZISDVSYi0zN3F1UUFzSzlERWg2MzdldGpfVnFjR0FQNmpLZlR1WlUyZGh4TGo2eTRFaGkyRFFpVGFZLXpzS19UN2dOZUZWWVo5RVpuZnU5ZGVXMXVm?oc=5","as_of":"2026-04-12T14:39:46.288429+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/CBMiaEFVX3lxTFBHN0FvNVMwNzhYNWZISDVSYi0zN3F1UUFzSzlERWg2MzdldGpfVnFjR0FQNmpLZlR1WlUyZGh4TGo2eTRFaGkyRFFpVGFZLXpzS19UN2dOZUZWWVo5RVpuZnU5ZGVXMXVm?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7201e0ce10c2face","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-12T14:40:01.720368+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiaEFVX3lxTFBHN0FvNVMwNzhYNWZISDVSYi0zN3F1UUFzSzlERWg2MzdldGpfVnFjR0FQNmpLZlR1WlUyZGh4TGo2eTRFaGkyRFFpVGFZLXpzS19UN2dOZUZWWVo5RVpuZnU5ZGVXMXVm?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mshale.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiaEFVX3lxTFBHN0FvNVMwNzhYNWZISDVSYi0zN3F1UUFzSzlERWg2MzdldGpfVnFjR0FQNmpLZlR1WlUyZGh4TGo2eTRFaGkyRFFpVGFZLXpzS19UN2dOZUZWWVo5RVpuZnU5ZGVXMXVm?oc=5","source_event_id":"evt_8c1d3c169436","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"178e8caf2cb4cabf","published_at":"2026-04-12T12:45:58+00:00","publisher_domain":"mshale.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"unknown","name":"Gap (IWoek4rVad) - Mshale","relevance":"high","symbol":"","type":"chart_or_series"}],"event_type":"other","information_gaps":["No underlying asset/ticker is mentioned.","No chart direction, price levels, timeframe, or indicators are provided.","No source summary or article text is available to verify what \u201cGap (IWoek4rVad)\u201d refers to.","No evidence of trend continuation vs reversal is provided beyond the generic emphasis in the headline."],"key_facts":["Headline states: \u201cTHE MOST IMPORTANT CHART IN THE ENTIRE STOCK MARKET RIGHT NOW!\u201d","Headline includes the text \u201cGap (IWoek4rVad) - Mshale\u201d.","No article text or additional market metrics are provided in the input."],"numeric_claims":[],"primary_claim":"The headline claims that a chart labeled \u201cGap (IWoek4rVad) - Mshale\u201d is the most important chart in the entire stock market right now.","relevance_score":0.2,"sentiment":"neutral","source_quality":"unknown","summary":"The provided headline is a promotional-style statement claiming a specific chart is the most important in the stock market right now, but it provides no actionable market data or asset details.","topics":["market commentary","chart emphasis"]},"source":"Mshale","source_domain":"mshale.com","source_url":"https://mshale.com","summary":"","tickers":[],"title":"THE MOST IMPORTANT CHART IN THE ENTIRE STOCK MARKET RIGHT NOW! Gap (IWoek4rVad) - Mshale","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_17b22b2065e5 in signals