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/bargain-magnificent-seven-stock-buy-todays-market-1-metric-answers-question","as_of":"2026-04-18T09:10:19.576061+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/is-this-bargain-magnificent-seven-stock-a-buy-in-t/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bargain-magnificent-seven-stock-buy-todays-market-1-metric-answers-question","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f174278654cb56dc","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/is-this-bargain-magnificent-seven-stock-a-buy-in-t/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T09:11:47.263824+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThis tech powerhouse generates billions of dollars in earnings from its core business.","fetched_title":"Is This Bargain Magnificent Seven Stock a Buy in Today's Market? This 1 Metric Answers the Question. | Nasdaq","final_url":"https://www.nasdaq.com/articles/bargain-magnificent-seven-stock-buy-todays-market-1-metric-answers-question","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bargain-magnificent-seven-stock-buy-todays-market-1-metric-answers-question","source_event_id":"evt_5b3e21574747","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9c5a216afa11ae55","kind":"unusual_volume","published_at":"2026-04-18T08:27:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2024","earlier this month"],"entities":[{"asset_class":"equity","name":"Meta Platforms","relevance":"high","symbol":"META","type":"company"},{"asset_class":"other","name":"Facebook","relevance":"medium","symbol":"","type":"product"},{"asset_class":"other","name":"Messenger","relevance":"medium","symbol":"","type":"product"},{"asset_class":"other","name":"Instagram","relevance":"medium","symbol":"","type":"product"},{"asset_class":"other","name":"WhatsApp","relevance":"medium","symbol":"","type":"product"},{"asset_class":"other","name":"Mark Zuckerberg","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Alexandr Wang","relevance":"low","symbol":"","type":"person"},{"asset_class":"other","name":"Scale AI","relevance":"low","symbol":"","type":"company"},{"asset_class":"other","name":"Muse Spark","relevance":"medium","symbol":"","type":"product"},{"asset_class":"other","name":"S&P 500","relevance":"low","symbol":"","type":"index"}],"event_type":"price_action","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the text contains no volume ratio, baseline volume, or any discussion of unusual trading volume.","No ticker-level volume delta confirmation is provided (no explicit mention of volume spikes or whether it is confirmed by news).","The article does not identify a specific catalyst tied to unusual volume; it discusses AI investment and valuation/ROIC as general reasons to buy."],"key_facts":["The article states Meta Platforms (NASDAQ: META) is the cheapest Magnificent Seven stock today, trading at 21x forward earnings estimates.","The article says Meta generates most revenue from advertising across its social media apps (Facebook, Messenger, Instagram, WhatsApp).","The article states Meta has focused on AI, including building data centers, developing its own large language model, and creating a superintelligence lab.","The article says Meta recruited AI experts last year, including Alexandr Wang of Scale AI, and that Meta unveiled its first big AI model, Muse Spark, earlier this month.","The article claims Meta could monetize AI via improved ad performance and by offering third-party developers paid access to Muse Spark technology in the future.","The article quotes Mark Zuckerberg (2024 earnings call) saying Meta has historically seen stock volatility during product investment phases before monetization, and that AI involves a multi-year investment cycle.","The article claims that Meta\u2019s ROIC and stock performance have historically moved together: when ROIC troughs occur, the stock slips; when ROIC climbs, the stock advances.","The article concludes that the ROIC metric suggests it is a \u201cfantastic time\u201d to buy Meta and hold as AI investment benefits materialize."],"numeric_claims":[{"label":"forward earnings multiple","value":"21x"},{"label":"users mentioned","value":"3.5 billion individuals worldwide"}],"primary_claim":"Meta Platforms is described as the cheapest Magnificent Seven stock today, trading at 21x forward earnings estimates, and the article claims ROIC trends suggest a favorable time to buy as AI investments mature.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article argues that Meta Platforms (META) is the cheapest \u201cMagnificent Seven\u201d stock on a forward-earnings basis and may be a buy due to its AI investment cycle and historical relationship between ROIC and stock performance.","topics":["Magnificent Seven","valuation (forward earnings)","AI investment","ROIC","advertising monetization","stock volatility","Motley Fool Stock Advisor"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThis tech powerhouse generates billions of dollars in earnings from its core business.","tickers":[],"title":"Is This Bargain Magnificent Seven Stock a Buy in Today's Market? This 1 Metric Answers the Question.","url":"https://www.fool.com/investing/2026/04/18/is-this-bargain-magnificent-seven-stock-a-buy-in-t/"}

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