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-22T12:11:11.616908+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:b68b0a4bf26eae19","evidence_event_ids":["evt_72514e696777"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/ranking-magnificent-seven-most-least-attractive-based-future-cash-flow","as_of":"2026-04-22T12:11:11.616908+00:00","canonical_url":"https://www.fool.com/investing/2026/04/22/ranking-magnificent-seven-most-to-least-attractive/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ranking-magnificent-seven-most-least-attractive-based-future-cash-flow","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_77f2cf542ce2e295","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/22/ranking-magnificent-seven-most-to-least-attractive/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T12:12:34.633238+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe Magnificent Seven have put Wall Street on their proverbial backs and lifted the major stock indexes to new heights.","fetched_title":"Ranking the \"Magnificent Seven\" From Most to Least Attractive, Based on Future Cash Flow | Nasdaq","final_url":"https://www.nasdaq.com/articles/ranking-magnificent-seven-most-least-attractive-based-future-cash-flow","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ranking-magnificent-seven-most-least-attractive-based-future-cash-flow","source_event_id":"evt_72514e696777","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9d64297b89e9a753","kind":"unusual_volume","published_at":"2026-04-22T11:26:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["December","fourth quarter","2027","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Meta Platforms","relevance":"high","symbol":"META","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Microsoft","relevance":"medium","symbol":"MSFT","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"medium","symbol":"GOOGL/GOOG","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Apple","relevance":"medium","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Tesla","relevance":"high","symbol":"TSLA","type":"company"},{"asset_class":"other","name":"Motley Fool Stock Advisor","relevance":"low","symbol":"","type":"publication/service"}],"event_type":"other","information_gaps":["No unusual trading volume data is provided (no ticker-specific volume ratio vs average, no baseline volume, and no direction).","No explicit catalyst for unusual volume is stated; the article is a valuation/ranking piece rather than a market-microstructure event.","The signal type suggests volume anomaly, but the provided text contains only fundamental/valuation discussion."],"key_facts":["The article ranks Magnificent Seven stocks from cheapest to priciest based on Wall Street consensus estimated forward-year cash flow per share multiples.","Meta Platforms: 10.81x estimated forward-year cash flow per share.","Amazon: 11.7x estimated forward-year cash flow per share.","Microsoft: 15.54x estimated forward-year cash flow per share.","Alphabet: 17.36x estimated forward-year cash flow per share.","Nvidia: 18.53x estimated forward-year cash flow per share.","Apple: 25.59x estimated forward-year cash flow per share.","Tesla: 84.7x estimated forward-year cash flow per share.","The article characterizes Meta and Amazon as \u201cscreaming bargains\u201d and Tesla as \u201cnightmare fuel.\u201d","Meta is described as generating close to 98% of revenue from advertising and investing in AI infrastructure.","The article states Meta\u2019s social media apps attracted an average of 3.58 billion people daily in December (as described in the text).","The article attributes Amazon\u2019s reaccelerated sales growth to 24% in the fourth quarter to generative AI and large language model capabilities integrated into AWS.","The article states Tesla\u2019s vehicle margin is constrained by weaker global EV demand and multiple EV price reductions over the last three years.","The article states Tesla is trading at a premium to projected 2027 cash flow per share and is only expected to grow sales by 8% this year."],"numeric_claims":[{"label":"Meta forward-year cash flow multiple (x)","value":"10.81"},{"label":"Amazon forward-year cash flow multiple (x)","value":"11.7"},{"label":"Microsoft forward-year cash flow multiple (x)","value":"15.54"},{"label":"Alphabet forward-year cash flow multiple (x)","value":"17.36"},{"label":"Nvidia forward-year cash flow multiple (x)","value":"18.53"},{"label":"Apple forward-year cash flow multiple (x)","value":"25.59"},{"label":"Tesla forward-year cash flow multiple (x)","value":"84.7"},{"label":"Meta revenue from advertising (% of revenue)","value":"98"},{"label":"Meta daily average people (billions)","value":"3.58"},{"label":"AWS-related sales growth reaccelerated to (% in Q4)","value":"24"},{"label":"Tesla expected sales growth this year (%)","value":"8"}],"primary_claim":"Meta Platforms and Amazon are the cheapest among the Magnificent Seven based on estimated forward-year cash flow per share, while Tesla is the most expensive (highest multiple).","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article ranks the Magnificent Seven by forward-year cash flow per share, arguing Meta and Amazon look cheapest while Tesla looks most overvalued. It does not provide any unusual trading-volume figures or a volume-vs-average ratio.","topics":["Magnificent Seven","valuation","forward cash flow per share","AI infrastructure","AWS","EV demand","advertising revenue","stock picking"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe Magnificent Seven have put Wall Street on their proverbial backs and lifted the major stock indexes to new heights.","tickers":[],"title":"Ranking the \"Magnificent Seven\" From Most to Least Attractive, Based on Future Cash Flow","url":"https://www.fool.com/investing/2026/04/22/ranking-magnificent-seven-most-to-least-attractive/"}}

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