SQLite Web: event_store.db

Update row 232873 in events

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-18T20:18:18.677149+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:a7b0fc8f50978ce0","evidence_event_ids":["evt_6e547fa035da"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/amazon-vs-walmart-isnt-even-close","as_of":"2026-04-18T20:18:18.677149+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/amazon-vs-walmart-this-isnt-even-close/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/amazon-vs-walmart-isnt-even-close","article_chars":4573,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_eb25f72f4fd664c1","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/amazon-vs-walmart-this-isnt-even-close/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T20:48:44.024297+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsAmazon has a higher long-term revenue compound annual growth rate than Walmart.","fetched_title":"Amazon vs. Walmart: This Isn't Even Close | Nasdaq","final_url":"https://www.nasdaq.com/articles/amazon-vs-walmart-isnt-even-close","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/amazon-vs-walmart-isnt-even-close","source_event_id":"evt_6e547fa035da","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b061f3b02f12f2ff","kind":"unusual_volume","published_at":"2026-04-18T18:22:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Jan. 31","April 18, 2026"],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Walmart","relevance":"high","symbol":"WMT","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company_mentioned"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company_mentioned"}],"event_type":"price_action","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the text does not include any unusual volume metrics (e.g., volume ratio vs average), baseline volume, or direction (up/down).","No explicit catalyst is tied to the unusual volume; the article\u2019s catalysts are general (AWS/online advertising/AI chips and valuation/margins), not confirmed as the reason for any volume spike.","No confirmation is provided that the volume change is news-driven; the article content is a comparative investment thesis rather than a market-volume event report."],"key_facts":["Amazon\u2019s revenue compound annual growth rate (CAGR) over the past three years is stated as 12.7%, versus Walmart\u2019s 5.1%.","The article states Amazon leads in revenue CAGRs across 5-year, 10-year, 15-year, and 20-year periods.","Amazon\u2019s Q4 results are described as 14% year-over-year revenue growth, with more than 20% growth in AWS and online advertising segments.","The article states Amazon\u2019s custom AI chips produce more than $10 billion in annual revenue (as of the article\u2019s timeframe).","Amazon total company sales are stated as $213.4 billion in the fourth quarter.","Walmart\u2019s Q4 is described as 5.6% year-over-year revenue growth for fiscal 2026, ended Jan. 31 (as stated).","The article states Amazon has a lower P/E ratio than Walmart: 34.7 vs 45.3.","The article claims Amazon has better profit margins than Walmart, attributing Walmart\u2019s margin limitations to its physical-location revenue base.","The article notes Walmart pays a dividend with a yield below 1% (stated as not a game changer).","The article states Walmart has outperformed Amazon over the past five years by a wide margin, but suggests a reversal seems in order."],"numeric_claims":[{"label":"Amazon revenue CAGR (past three years)","value":"12.7%"},{"label":"Walmart revenue CAGR (past three years)","value":"5.1%"},{"label":"Amazon Q4 YoY revenue growth","value":"14%"},{"label":"Amazon AWS and online advertising growth","value":"more than 20%"},{"label":"Amazon custom AI chips annual revenue","value":"more than $10 billion"},{"label":"Amazon Q4 total company sales","value":"$213.4 billion"},{"label":"Walmart Q4 YoY revenue growth (fiscal 2026 ended Jan. 31)","value":"5.6%"},{"label":"Amazon P/E","value":"34.7"},{"label":"Walmart P/E","value":"45.3"},{"label":"Walmart dividend yield","value":"below 1%"}],"primary_claim":"Amazon has higher long-term revenue growth (12.7% CAGR over the past three years) than Walmart (5.1% CAGR), and the article concludes Amazon is the winner based on growth, margins, and valuation.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article argues Amazon (AMZN) is the stronger long-term investment versus Walmart (WMT), citing higher revenue growth, stronger profit margins, and a lower valuation. It also references recent quarter performance showing faster growth in Amazon\u2019s AWS and online advertising segments.","topics":["equity comparison","revenue growth","valuation (P/E)","profit margins","AWS","online advertising","AI chips","retail business model"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAmazon has a higher long-term revenue compound annual growth rate than Walmart.","tickers":[],"title":"Amazon vs. Walmart: This Isn't Even Close","url":"https://www.fool.com/investing/2026/04/18/amazon-vs-walmart-this-isnt-even-close/"}}

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')

Cancel