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-21T12:20:48.730501+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:00d42569a0a5d52b","evidence_event_ids":["evt_0383f4fcd9d5"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/buy-these-3-high-yield-energy-stocks-now-and-let-dividends-compound-forever","as_of":"2026-04-21T12:20:48.730501+00:00","canonical_url":"https://www.fool.com/investing/2026/04/21/buy-these-3-high-yield-energy-stocks-now-and-let-t/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/buy-these-3-high-yield-energy-stocks-now-and-let-dividends-compound-forever","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3c5daca227962af1","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/21/buy-these-3-high-yield-energy-stocks-now-and-let-t/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:33:53.406668+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsChevron is built to survive through the entire energy cycle.","fetched_title":"Buy These 3 High-Yield Energy Stocks Now and Let the Dividends Compound Forever | Nasdaq","final_url":"https://www.nasdaq.com/articles/buy-these-3-high-yield-energy-stocks-now-and-let-dividends-compound-forever","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/buy-these-3-high-yield-energy-stocks-now-and-let-dividends-compound-forever","source_event_id":"evt_0383f4fcd9d5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6ded3f33773a0823","kind":"unusual_volume","published_at":"2026-04-21T11:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"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"},{"asset_class":"equity","name":"Brookfield Renewable Partners","relevance":"high","symbol":"BEP","type":"company"},{"asset_class":"other","name":"Middle East conflict","relevance":"medium","symbol":"","type":"geopolitical_factor"}],"event_type":"other","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the article text contains no trading-volume data, no volume ratio vs average, and no confirmation/unexplained classification tied to unusual volume.","No specific ticker is linked to any unusual volume event; the article discusses three tickers only in the context of dividend recommendations.","No catalyst is explicitly tied to unusual volume; the only catalyst-like discussion is general geopolitical volatility and investor emotions, not a volume spike."],"key_facts":["Chevron is described as diversified across the energy value chain (production, transportation, refining, chemicals) and geographically diverse.","The article claims Chevron has a strong balance sheet that allows it to take on debt during bad energy markets to support its business and dividend.","The article states Chevron has increased its dividend annually for more than 25 years and cites a dividend yield of 3.8% \u201ctoday.\u201d","Enterprise Products Partners is described as focused on midstream infrastructure, charging fees for using assets; the article claims volumes are more important than commodity prices.","The article states Enterprise has a 5.9% distribution yield and increased its distribution annually for 27 years.","Brookfield Renewable Partners is described as owning/operating clean energy assets (hydro, solar, wind, storage, nuclear) with a 4.5% distribution yield.","The article states Brookfield Renewable has plans to invest up to $10 billion over the next five years, with a significant portion expected to be covered by asset sales.","The article attributes market swings to investor emotions amid changing Middle East conflict conditions."],"numeric_claims":[{"label":"Chevron dividend yield (today)","value":"3.8%"},{"label":"Enterprise distribution yield","value":"5.9%"},{"label":"Enterprise distribution increase duration","value":"27 years"},{"label":"Brookfield Renewable distribution yield","value":"4.5%"},{"label":"Brookfield Renewable planned investment","value":"up to $10 billion"},{"label":"Brookfield Renewable investment horizon","value":"next five years"},{"label":"Chevron dividend increase duration","value":"more than 25 years"}],"primary_claim":"The article states that Chevron (CVX), Enterprise Products Partners (EPD), and Brookfield Renewable Partners (BEP) are high-yield energy stocks suitable for holding through difficult periods, citing their business models and dividend/distribution yields.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article recommends three high-yield energy/dividend stocks\u2014Chevron (CVX), Enterprise Products Partners (EPD), and Brookfield Renewable Partners (BEP)\u2014framing them as resilient through energy-cycle and geopolitical volatility. It does not provide any specific unusual trading-volume figures or a volume-ratio vs average for the signal.","topics":["high-yield dividend stocks","energy sector resilience","midstream infrastructure","clean energy investments","geopolitical volatility","dividend/distribution yields"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsChevron is built to survive through the entire energy cycle.","tickers":[],"title":"Buy These 3 High-Yield Energy Stocks Now and Let the Dividends Compound Forever","url":"https://www.fool.com/investing/2026/04/21/buy-these-3-high-yield-energy-stocks-now-and-let-t/"}}

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 474396 in events