SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-03T11:12:58.166696+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:3a5dbc36a128a29c","evidence_event_ids":["evt_d2b261bed4bf"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/2-energy-stocks-worth-buying-now-and-holding-through-whatever-comes-next","as_of":"2026-04-03T11:12:58.166696+00:00","canonical_url":"https://www.fool.com/investing/2026/04/03/3-energy-stocks-worth-buying-now-and-holding-throu/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/2-energy-stocks-worth-buying-now-and-holding-through-whatever-comes-next","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b2b6339e25705682","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/03/3-energy-stocks-worth-buying-now-and-holding-throu/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T22:38:10.522120+00:00","extraction_method":"heuristic","fetched_description":"Key PointsChevron can deliver attractive total returns regardless of how geopolitical events unfold.","fetched_title":"2 Energy Stocks Worth Buying Now and Holding Through Whatever Comes Next | Nasdaq","final_url":"https://www.nasdaq.com/articles/2-energy-stocks-worth-buying-now-and-holding-through-whatever-comes-next","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/2-energy-stocks-worth-buying-now-and-holding-through-whatever-comes-next","source_event_id":"evt_d2b261bed4bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f6002bc848bfe473","kind":"unusual_volume","published_at":"2026-04-03T09:04:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 03, 2026"],"entities":[{"asset_class":"equity","name":"Chevron","relevance":"high","symbol":"CVX","type":"company"},{"asset_class":"equity","name":"Enterprise Products Partners","relevance":"high","symbol":"EPD","type":"company"}],"event_type":"other","information_gaps":["No specific volume ratio or unusual volume data provided."],"key_facts":["Chevron can maintain dividends even if oil prices drop below $50 per barrel.","Enterprise Products Partners has increased its distribution for 27 consecutive years."],"numeric_claims":[{"label":"Chevron dividend yield","value":"3.6%"},{"label":"Enterprise distribution yield","value":"5.9%"}],"primary_claim":"Chevron is well-positioned to deliver attractive total returns regardless of geopolitical events.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"Chevron and Enterprise Products Partners are highlighted as strong energy stocks to buy and hold amid geopolitical uncertainties, with Chevron benefiting from low costs and strong demand for natural gas.","topics":["energy stocks","Chevron","Enterprise Products Partners","geopolitical risk"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsChevron can deliver attractive total returns regardless of how geopolitical events unfold.","tickers":[],"title":"2 Energy Stocks Worth Buying Now and Holding Through Whatever Comes Next","url":"https://www.fool.com/investing/2026/04/03/3-energy-stocks-worth-buying-now-and-holding-throu/"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 6495 in events