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/should-investors-buy-amazon-stock-instead-walmart-stock","as_of":"2026-04-10T00:01:31.055484+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/should-investors-buy-amazon-stock-instead-of-walma/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/should-investors-buy-amazon-stock-instead-walmart-stock","article_chars":3355,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c2a1cee270d82632","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/should-investors-buy-amazon-stock-instead-of-walma/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:01:19.529821+00:00","extraction_method":"heuristic","fetched_description":"Amazon (NASDAQ: AMZN) and Walmart (NASDAQ: WMT) are two of the largest companies in the world, measured by revenue.","fetched_title":"Should Investors Buy Amazon Stock Instead of Walmart Stock? | Nasdaq","final_url":"https://www.nasdaq.com/articles/should-investors-buy-amazon-stock-instead-walmart-stock","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/should-investors-buy-amazon-stock-instead-walmart-stock","source_event_id":"evt_1f594ecfb361","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a712b3977405b5c1","kind":"unusual_volume","published_at":"2026-04-09T23:29:12+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["April 09, 2026","April 7, 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":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Unusual volume delta details are missing: no volume ratio vs average, no baseline volume, no direction (e.g., above/below average), and no ticker-specific volume data.","No explicit catalyst hypothesis is provided in the provided text; the content is primarily a stock comparison and promotional material.","No confirmation mechanism is described (e.g., whether unusual volume is tied to specific news); the provided text contains no such linkage."],"key_facts":["Headline: \"Should Investors Buy Amazon Stock Instead of Walmart Stock?\"","Article date/time shown as April 09, 2026 \u2014 07:29 pm EDT.","Text states Amazon (NASDAQ: AMZN) and Walmart (NASDAQ: WMT) are two of the largest companies in the world, measured by revenue.","The article includes promotional/marketing content for Stock Advisor and \"Double Down\" alerts.","The provided text does not include any trading volume figures or volume-vs-average data."],"numeric_claims":[],"primary_claim":"The article asks whether investors should buy Amazon stock instead of Walmart stock, noting both are among the largest companies by revenue.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The Motley Fool article compares Amazon (AMZN) and Walmart (WMT) as large revenue-based companies and frames the question of whether investors should prefer Amazon over Walmart. The provided text does not include any unusual trading volume metrics.","topics":["stock comparison","investment recommendation framing","markets"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Amazon (NASDAQ: AMZN) and Walmart (NASDAQ: WMT) are two of the largest companies in the world, measured by revenue.","tickers":[],"title":"Should Investors Buy Amazon Stock Instead of Walmart Stock?","url":"https://www.fool.com/investing/2026/04/09/should-investors-buy-amazon-stock-instead-of-walma/"}

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