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/2-smart-buys-scary-market-growth-stocks-worth-holding-decades","as_of":"2026-04-14T08:09:17.081021+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/2-smart-buys-for-a-scary-market-growth-stocks-wort/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/2-smart-buys-scary-market-growth-stocks-worth-holding-decades","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bd2f697e704f78aa","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/2-smart-buys-for-a-scary-market-growth-stocks-wort/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T08:10:06.851822+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsAmazon has continued to innovate and evolve behind the scenes, making it a stock to own for years.","fetched_title":"2 Smart Buys for a Scary Market: Growth Stocks Worth Holding for Decades | Nasdaq","final_url":"https://www.nasdaq.com/articles/2-smart-buys-scary-market-growth-stocks-worth-holding-decades","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/2-smart-buys-scary-market-growth-stocks-worth-holding-decades","source_event_id":"evt_e13a3fdbd934","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d48efb9e247958d9","kind":"unusual_volume","published_at":"2026-04-14T06:45:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["early February","April","first-quarter earnings","later in the month (war with Iran)"],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"},{"asset_class":"equity","name":"Walmart","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Costco","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"low","symbol":"GOOGL/GOOG","type":"company"}],"event_type":"other","information_gaps":["No unusual volume ratio vs average is provided in the provided text (baseline volume, volume ratio, and direction are all missing).","No explicit statement links the volume change to a specific catalyst; the article is a general long-term stock recommendation.","The signal type suggests unusual volume, but the excerpt contains no trading-volume data or confirmation details."],"key_facts":["The article says the market trended down in early February due to fears about AI infrastructure spending sustainability and AI\u2019s impact on industries/jobs.","The article says the market rebounded in April ahead of first-quarter earnings, with hope that the war may soon end and signals the economy remains strong despite high gasoline prices.","Amazon is described as a leader in e-commerce and cloud computing (AWS), with AWS described as most profitable and fastest-growing.","The article claims Amazon has custom AI accelerators and custom CPUs and says it recently stated that selling chips to third parties would be a $50 billion business (as described in the text).","The article says Amazon is investing in satellite internet and drones.","The article says Amazon\u2019s stock is trading at a \u201cbig discount\u201d to slower-growing brick-and-mortar peers like Walmart and Costco (no numeric discount provided).","Apple is described as a compounding business and as having a walled-garden ecosystem that increases switching costs.","The article states Apple Pay charges a 0.15% fee on every transaction (as stated in the text).","The article states Apple receives billions of dollars in profit from a revenue-sharing deal with Alphabet for Google to be the default search engine on Apple devices."],"numeric_claims":[{"label":"Apple Pay fee","value":"0.15% per transaction"},{"label":"Implied chip business size if sold to third parties","value":"$50 billion"}],"primary_claim":"The article states that Amazon (AMZN) and Apple (AAPL) are worth holding long term due to their business strengths and compounding models.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article recommends long-term \u201ccore holdings\u201d in Amazon (AMZN) and Apple (AAPL), framing the current market as scary but arguing both companies have durable growth drivers. No specific unusual trading volume metrics are provided in the text.","topics":["long-term investing","growth stocks","market uncertainty","AI infrastructure","AWS","digital advertising","custom chips","Apple ecosystem","subscriptions and services","Apple Pay","app store","default search revenue share"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAmazon has continued to innovate and evolve behind the scenes, making it a stock to own for years.","tickers":[],"title":"2 Smart Buys for a Scary Market: Growth Stocks Worth Holding for Decades","url":"https://www.fool.com/investing/2026/04/14/2-smart-buys-for-a-scary-market-growth-stocks-wort/"}

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