SQLite Web: event_store.db

Update row 5235 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-08T07:31:44.637479+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:a6a93e418635a321","evidence_event_ids":["evt_88d82514ea1f"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/3-growth-stocks-hold-next-20-years","as_of":"2026-04-08T07:31:44.637479+00:00","canonical_url":"https://www.fool.com/investing/2026/04/08/3-growth-stocks-to-hold-for-the-next-20-years/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-growth-stocks-hold-next-20-years","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3b47f6ea8cf3ae61","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/08/3-growth-stocks-to-hold-for-the-next-20-years/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T07:32:44.631450+00:00","extraction_method":"heuristic","fetched_description":"Key PointsApple has one of the best business models on the planet.","fetched_title":"3 Growth Stocks to Hold for the Next 20 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-growth-stocks-hold-next-20-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-growth-stocks-hold-next-20-years","source_event_id":"evt_88d82514ea1f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e01c0aece6913d7d","kind":"unusual_volume","published_at":"2026-04-08T06:40:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["April 08, 2026"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Dutch Bros","relevance":"high","symbol":"BROS","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"low","symbol":"GOOG","type":"company"}],"event_type":"other","information_gaps":["No ticker-specific unusual volume ratio vs average is provided.","No baseline volume, volume ratio, or direction (e.g., above/below average) is stated.","No confirmation source for any volume anomaly is provided; the text appears to be a stock recommendation article rather than a market-volume report.","The signal type (discovery_unusual_volume_delta) is not evidenced by the provided article text."],"key_facts":["The article is dated April 08, 2026 and is written by Geoffrey Seiler for The Motley Fool.","It recommends three stocks to buy for the long haul: Apple (AAPL), Amazon (AMZN), and Dutch Bros (BROS).","For Apple, the article states it has a strong business model, an ecosystem that is difficult to switch from, and services/payments that provide recurring high-margin revenue.","For Amazon, the article states it has invested in fulfillment/logistics and cloud computing, and it is using AI/automation to streamline e-commerce; it also mentions partnerships with Anthropic and OpenAI and a data center dedicated to Anthropic powered by custom AI chips.","For Dutch Bros, the article describes a regional-to-national expansion story, mentions plans to grow to 7,000 U.S. shops, and states it had fewer than 1,150 shops at the end of last year.","The article states Dutch Bros has an average unit volume (AUV) of $2.1 million."],"numeric_claims":[{"label":"Dutch Bros shops (end of last year)","value":"fewer than 1,150"},{"label":"Dutch Bros planned U.S. shops","value":"7,000"},{"label":"Dutch Bros average unit volume (AUV)","value":"$2.1 million"}],"primary_claim":"The article lists Apple (AAPL), Amazon (AMZN), and Dutch Bros (BROS) as stocks to hold for the next 20 years.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article (Apr 8, 2026) recommends three long-term growth stocks: Apple, Amazon, and Dutch Bros, citing business model strength, innovation, and expansion opportunities. No unusual trading volume information is provided in the text.","topics":["long-term investing","stock recommendations","Apple business model","Amazon innovation and cloud","Dutch Bros expansion","Motley Fool Stock Advisor"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsApple has one of the best business models on the planet.","tickers":[],"title":"3 Growth Stocks to Hold for the Next 20 Years","url":"https://www.fool.com/investing/2026/04/08/3-growth-stocks-to-hold-for-the-next-20-years/"}}

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