SQLite Web: event_store.db

Update row sig_58948dd50c1c in signals

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/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

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

Cancel