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-10T12:11:33.277556+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:8ec8fe6882b88d45","evidence_event_ids":["evt_9f61ef195338"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/new-investing-heres-why-amazon-stock-great-first-buy","as_of":"2026-04-10T12:11:33.277556+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/new-to-investing-heres-why-amazon-stock-is-a-great/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/new-investing-heres-why-amazon-stock-great-first-buy","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0feb4d340016e509","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/new-to-investing-heres-why-amazon-stock-is-a-great/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T12:12:39.863674+00:00","extraction_method":"heuristic","fetched_description":"Key PointsAmazon stock is simple enough for beginners to understand.","fetched_title":"New to Investing? Here's Why Amazon Stock Is a Great First Buy. | Nasdaq","final_url":"https://www.nasdaq.com/articles/new-investing-heres-why-amazon-stock-great-first-buy","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/new-investing-heres-why-amazon-stock-great-first-buy","source_event_id":"evt_9f61ef195338","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6d52251b678110a4","kind":"unusual_volume","published_at":"2026-04-10T11:45:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 10, 2026","07:45 am EDT"],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"other","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no trading volume information (no volume ratio vs average, no baseline volume, no direction, and no confirmation/unexplained context).","No explicit catalyst tied to unusual volume is described; the article\u2019s catalysts are general long-term growth drivers (e-commerce, cloud/AI, digital advertising) rather than a volume event.","No confirmation is provided via market/news data; the piece is primarily promotional/educational rather than reporting a specific volume anomaly."],"key_facts":["The article is dated April 10, 2026 and written by Lawrence Nga for The Motley Fool.","It states Amazon is familiar to everyday consumers and operates through online retail, cloud computing, and digital advertising.","It claims Amazon benefits from long-term trends: global e-commerce expansion, increased cloud adoption accelerated by AI, and advertising shifting to digital platforms.","It suggests investors can use earnings reports and new AI-related product launches/services to track Amazon\u2019s progress.","It frames Amazon as a practical learning tool for new investors and suggests starting with $500 or $1,000."],"numeric_claims":[{"label":"Suggested starting amount","value":"$500 or $1,000"},{"label":"Article time","value":"07:45 am EDT"},{"label":"Article date","value":"April 10, 2026"}],"primary_claim":"Amazon stock is presented as a compelling first investment for beginners because it is easy to understand and has durable long-term growth drivers.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article argues that Amazon (AMZN) is a good first stock for beginners due to its understandable business model and multiple long-term growth drivers. It does not provide any data about unusual trading volume or a volume-vs-average ratio.","topics":["beginner investing","Amazon business model","e-commerce","cloud computing","digital advertising","long-term growth","learning platform"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAmazon stock is simple enough for beginners to understand.","tickers":[],"title":"New to Investing? Here's Why Amazon Stock Is a Great First Buy.","url":"https://www.fool.com/investing/2026/04/10/new-to-investing-heres-why-amazon-stock-is-a-great/"}}

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