SQLite Web: event_store.db

Update row sig_501b70454beb 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/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

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