SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/3-brilliant-high-yield-stocks-buy-now-and-hold-long-term","as_of":"2026-04-10T03:04:31.796915+00:00","canonical_url":"https://www.fool.com/investing/2025/04/30/3-brilliant-high-yield-stocks-to-buy-now-and-hold/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-brilliant-high-yield-stocks-buy-now-and-hold-long-term","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_152352ec7f040cb3","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2025/04/30/3-brilliant-high-yield-stocks-to-buy-now-and-hold/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T03:40:23.070124+00:00","extraction_method":"heuristic","fetched_description":"If you are a dividend investor looking for high yields today, you may want to consider companies that provide energy in some form. Modern society can't exist without reliable sources of energy and, thus, energy companies are providing a basic necessity. That said, there are diffe","fetched_title":"3 Brilliant High-Yield Stocks to Buy Now and Hold for the Long Term | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-brilliant-high-yield-stocks-buy-now-and-hold-long-term","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-brilliant-high-yield-stocks-buy-now-and-hold-long-term","source_event_id":"evt_cd28123fcee3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1385d40ac13cbcf8","kind":"unusual_volume","published_at":"2026-04-10T02:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 30, 2025"],"entities":[{"asset_class":"equity","name":"Black Hills","relevance":"high","symbol":"BKH","type":"company"},{"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":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No unusual trading volume data is provided (no volume ratio vs average, no baseline volume, no direction, and no ticker-specific volume metrics).","The signal type indicates unusual volume delta, but the article text shown is a dividend-stock recommendation and does not mention volume changes or a catalyst tied to trading activity.","No explicit catalyst hypothesis is stated in the provided text; only general business/dividend rationale is given."],"key_facts":["Black Hills (BKH) is described as having a 4.5% dividend yield and increasing its dividend annually for 55 consecutive years.","Black Hills is described as serving roughly 1.35 million customers across multiple states.","The article states Black Hills customer growth is expanding at nearly three times U.S. population growth.","The article states Black Hills has a $4.7 billion capital investment budget and management expects earnings to increase around 4% to 6% year over year.","Chevron (CVX) is described as having a 4.9% dividend yield and increasing its dividend annually for 38 consecutive years.","The article states Chevron\u2019s average energy stock yield is about 3.1% (contextual comparison).","The article states Chevron\u2019s debt-to-equity ratio was about 0.15% at the end of 2024.","Enterprise Products Partners (EPD) is described as having a 6.8% distribution yield and increasing its distribution annually for 26 consecutive years.","The article states Enterprise\u2019s distributable cash flow covered the distribution by 1.7 times in 2024.","The article states Enterprise has a $7.6 billion capital investment plan."],"numeric_claims":[{"label":"Black Hills dividend yield","value":"4.5%"},{"label":"Black Hills dividend increase streak","value":"55 consecutive years"},{"label":"Black Hills customers","value":"~1.35 million"},{"label":"Black Hills capital investment budget","value":"$4.7 billion"},{"label":"Black Hills expected earnings growth","value":"~4% to 6% YoY"},{"label":"Chevron dividend yield","value":"4.9%"},{"label":"Chevron dividend increase streak","value":"38 consecutive years"},{"label":"Average energy stock yield (comparison)","value":"~3.1%"},{"label":"Chevron debt-to-equity (end of 2024)","value":"~0.15%"},{"label":"Enterprise Products Partners distribution yield","value":"6.8%"},{"label":"Enterprise distribution increase streak","value":"26 consecutive years"},{"label":"Enterprise capital investment plan","value":"$7.6 billion"},{"label":"Enterprise distribution coverage (2024)","value":"1.7x"}],"primary_claim":"The article lists Black Hills (BKH), Chevron (CVX), and Enterprise Products Partners (EPD) as \u201c3 brilliant high-yield stocks\u201d with long dividend-increase histories.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article recommends three energy-related high-yield stocks (Black Hills, Chevron, and Enterprise Products Partners) for long-term dividend investors. The provided text does not include any unusual trading volume metrics or a specific volume-vs-average ratio for any ticker.","topics":["dividends","high-yield stocks","energy sector","utilities","oil and gas","midstream/MLP"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsFederal Realty is a relatively small REIT, but it has an incredible dividend record.","tickers":[],"title":"3 Brilliant High-Yield Stocks to Buy Now and Hold for the Long Term","url":"https://www.fool.com/investing/2025/04/30/3-brilliant-high-yield-stocks-to-buy-now-and-hold/"}

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_f42dd09e23ac in signals