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-19T14:16:02.066097+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:40ccdb5ac4fe2763","evidence_event_ids":["evt_c3d5f123b358"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/1-reason-id-buy-realty-income-stock-and-never-sell-its-monthly-dividend-stream","as_of":"2026-04-19T14:16:02.066097+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/1-reason-id-buy-realty-income-stock-and-never-sell/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-reason-id-buy-realty-income-stock-and-never-sell-its-monthly-dividend-stream","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_74f9715e4dad733a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/1-reason-id-buy-realty-income-stock-and-never-sell/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T15:41:18.428118+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsRealty Income pays a very bankable monthly dividend.","fetched_title":"1 Reason I'd Buy Realty Income Stock and Never Sell Its Monthly Dividend Stream. | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-reason-id-buy-realty-income-stock-and-never-sell-its-monthly-dividend-stream","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-reason-id-buy-realty-income-stock-and-never-sell-its-monthly-dividend-stream","source_event_id":"evt_c3d5f123b358","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dde4e1be01d2b17c","kind":"unusual_volume","published_at":"2026-04-19T12:50: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 19, 2026"],"entities":[{"asset_class":"equity (REIT)","name":"Realty Income","relevance":"high","symbol":"O","type":"company"}],"event_type":"other","information_gaps":["No unusual trading volume data is provided (no baseline volume, no current volume, and no volume ratio vs average).","No explicit catalyst for unusual volume is mentioned; the article is a general investment thesis rather than a volume/market-microstructure event.","The signal type 'discovery_unusual_volume_delta' is not supported by the provided text."],"key_facts":["Realty Income pays monthly dividends.","The article states Realty Income has paid 669 consecutive monthly dividends since its founding over 50 years ago.","The article states Realty Income has historically offered a dividend yield of around 5.7%.","The article states Realty Income increased earnings (AFFO) in all but one year since going public in 1994.","The article states Realty Income has increased its dividend every single year (31 years in a row and 114 consecutive quarters).","The article states Realty Income has delivered a positive operational total return every year, typically in the range of 8% to 12%.","The article states Realty Income owns a diversified portfolio of over 15,500 properties across retail, industrial, gaming, and other categories secured by net leases.","The article states Realty Income expects to invest $8 billion into new properties this year.","The article states Realty Income pays about 75% of its AFFO in dividends and reinvests the remainder (retains cash).","The article states Realty Income had over $925 million in adjusted free cash flow last year.","The article states Realty Income has investment-grade balance sheet with A3/A- credit ratings and a low leverage ratio."],"numeric_claims":[{"label":"consecutive monthly dividends","value":"669"},{"label":"dividend yield (historical)","value":"~5.7%"},{"label":"years with earnings growth since 1994","value":"all but one year"},{"label":"years of dividend increases","value":"31 years in a row"},{"label":"consecutive quarters dividend increases","value":"114"},{"label":"typical positive operational total return range","value":"8% to 12%"},{"label":"properties in portfolio","value":"over 15,500"},{"label":"dividend payout as % of AFFO","value":"about 75%"},{"label":"adjusted free cash flow last year","value":"over $925 million"},{"label":"expected investment into new properties this year","value":"$8 billion"},{"label":"credit ratings","value":"A3/A-"}],"primary_claim":"Realty Income has paid 669 consecutive monthly dividends and has increased earnings (AFFO) in all but one year since going public in 1994, while increasing its dividend every year (31 years in a row and 114 consecutive quarters).","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article is a bullish, long-term buy thesis for Realty Income (NYSE: O), emphasizing its monthly dividend reliability and consistent earnings/AFFO and dividend growth. It does not provide any information about unusual trading volume or a volume ratio versus average.","topics":["monthly dividend","REIT earnings growth","AFFO","dividend streak","portfolio diversification","net lease real estate","credit ratings","capital allocation","investment outlook"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsRealty Income pays a very bankable monthly dividend.","tickers":[],"title":"1 Reason I'd Buy Realty Income Stock and Never Sell Its Monthly Dividend Stream.","url":"https://www.fool.com/investing/2026/04/19/1-reason-id-buy-realty-income-stock-and-never-sell/"}}

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