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/best-high-yield-stocks-buy-2000-right-now","as_of":"2026-04-14T01:03:16.561735+00:00","canonical_url":"https://www.fool.com/investing/2026/04/13/the-best-high-yield-stocks-to-buy-with-2000-right/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/best-high-yield-stocks-buy-2000-right-now","article_chars":4634,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_abc1f3529997f50d","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/13/the-best-high-yield-stocks-to-buy-with-2000-right/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T01:06:34.765387+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe geopolitical conflict in the Middle East has increased the market's volatility, but the S&P 500 is still near all-time highs.","fetched_title":"The Best High-Yield Stocks to Buy With $2,000 Right Now | Nasdaq","final_url":"https://www.nasdaq.com/articles/best-high-yield-stocks-buy-2000-right-now","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/best-high-yield-stocks-buy-2000-right-now","source_event_id":"evt_849ba7881713","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"35798f8f30218118","kind":"unusual_volume","published_at":"2026-04-14T00:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["December 17, 2004","April 15, 2005","April 13, 2026"],"entities":[{"asset_class":"equity","name":"Federal Realty Investment Trust","relevance":"high","symbol":"FRT","type":"company"},{"asset_class":"equity","name":"Realty Income Corporation","relevance":"high","symbol":"O","type":"company"},{"asset_class":"index","name":"S&P 500 Index","relevance":"medium","symbol":"^GSPC","type":"index"}],"event_type":"other","information_gaps":["No unusual trading volume information is provided (no volume ratio vs average, no baseline volume, no direction, and no confirmation details).","The signal type suggests a volume anomaly, but the article content is a general investment pitch and does not mention volume spikes or catalysts tied to unusual volume.","No specific catalyst is stated that would explain any volume change; the only contextual factor mentioned is geopolitical conflict increasing market volatility."],"key_facts":["The article states that geopolitical conflict in the Middle East has increased market volatility.","The article states the S&P 500 is still near all-time highs and mentions a historically tiny yield of roughly 1.1%.","The article claims Federal Realty offers a dividend yield of about 4.1%.","The article claims Realty Income offers a dividend yield of about 5%.","The article states Federal Realty has 58 annual dividend increases and is described as a Dividend King.","The article states Realty Income has increased its dividend annually for 31 years.","The article states Realty Income is the largest net-lease REIT with over 15,500 properties.","The article states Realty Income occupancy did not fall below 96% even during the Great Recession."],"numeric_claims":[{"label":"S&P 500 yield (roughly)","value":"1.1%"},{"label":"Federal Realty dividend yield (about)","value":"4.1%"},{"label":"Realty Income dividend yield (about)","value":"5%"},{"label":"Federal Realty annual dividend increases","value":"58"},{"label":"Realty Income annual dividend increases","value":"31"},{"label":"Realty Income properties (over)","value":"15,500"},{"label":"Realty Income occupancy floor during Great Recession (did not fall below)","value":"96%"}],"primary_claim":"Federal Realty (FRT) and Realty Income (O) are presented as high-yield dividend stocks with yields of about 4.1% and 5%, respectively, even as geopolitical conflict increases market volatility.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article argues that despite Middle East geopolitical conflict increasing market volatility, S&P 500 remains near highs and highlights Federal Realty (FRT) and Realty Income (O) as high-yield dividend stocks. It does not provide any unusual trading volume data or a volume-vs-average ratio.","topics":["dividend investing","REITs","market volatility","geopolitical conflict","high-yield stocks"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe geopolitical conflict in the Middle East has increased the market's volatility, but the S&P 500 is still near all-time highs.","tickers":[],"title":"The Best High-Yield Stocks to Buy With $2,000 Right Now","url":"https://www.fool.com/investing/2026/04/13/the-best-high-yield-stocks-to-buy-with-2000-right/"}

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