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/CBMid0FVX3lxTE1KQ2d5cS16UEJlNDh5Y1RyWG5VOXFDWWp5aUtPM2hDOGM0RTd5R3JudlN3TVVjakFER0hveFpFMmhjWlFaejFoXzZ2LVNaLTJKTW1ZbFpqdHliQnJHSWdFemRsREt5U0hYdUVZLW1LaWpsU0Q3TWZJ?oc=5","as_of":"2026-04-14T21:04:45.137293+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1KQ2d5cS16UEJlNDh5Y1RyWG5VOXFDWWp5aUtPM2hDOGM0RTd5R3JudlN3TVVjakFER0hveFpFMmhjWlFaejFoXzZ2LVNaLTJKTW1ZbFpqdHliQnJHSWdFemRsREt5U0hYdUVZLW1LaWpsU0Q3TWZJ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1b347651c57777ce","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T21:46:26.362375+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1KQ2d5cS16UEJlNDh5Y1RyWG5VOXFDWWp5aUtPM2hDOGM0RTd5R3JudlN3TVVjakFER0hveFpFMmhjWlFaejFoXzZ2LVNaLTJKTW1ZbFpqdHliQnJHSWdFemRsREt5U0hYdUVZLW1LaWpsU0Q3TWZJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE1KQ2d5cS16UEJlNDh5Y1RyWG5VOXFDWWp5aUtPM2hDOGM0RTd5R3JudlN3TVVjakFER0hveFpFMmhjWlFaejFoXzZ2LVNaLTJKTW1ZbFpqdHliQnJHSWdFemRsREt5U0hYdUVZLW1LaWpsU0Q3TWZJ?oc=5","source_event_id":"evt_cb09ad3ae1c2","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"bdd61017e74d0e1a","published_at":"2026-04-14T20:20:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Energy stocks (unspecified)","relevance":"high","symbol":"","type":"market_segment"}],"event_type":"price_action","information_gaps":["No specific tickers or company names are provided for the energy stocks that could still rise.","No timeframe, catalysts, or reasons for the loss of momentum are included in the provided text.","No market data (e.g., index levels, percentage moves) is provided.","No details on whether the claim is based on earnings, macro factors, or technical levels are available."],"key_facts":["Barron's headline states that energy stocks have lost steam.","Barron's headline suggests that some energy stocks could still rise."],"numeric_claims":[],"primary_claim":"Energy stocks have lost steam, though some could still rise, according to Barron's.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"Barron's headline indicates that energy stocks have recently lost momentum, but some energy stocks may still have upside potential.","topics":["energy sector","stock momentum","equity price outlook"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"Energy Stocks Have Lost Steam. These Could Still Rise. Barron's","title":"Energy Stocks Have Lost Steam. These Could Still Rise. - Barron's","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_33a827a23a9b in signals