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/vanguard-etf-could-set-you-life-if-you-buy-it-april","as_of":"2026-04-12T05:42:08.708244+00:00","canonical_url":"https://www.fool.com/investing/2026/04/12/vanguard-etf-that-could-set-you-up-for-life/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/vanguard-etf-could-set-you-life-if-you-buy-it-april","article_chars":4966,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_71bb01ec36b2fff7","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/12/vanguard-etf-that-could-set-you-up-for-life/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T05:42:56.500641+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsIt's usually the simplest buy-and-hold strategies that do the best job of creating long-term wealth.","fetched_title":"The Vanguard ETF That Could Set You Up for Life if You Buy It in April | Nasdaq","final_url":"https://www.nasdaq.com/articles/vanguard-etf-could-set-you-life-if-you-buy-it-april","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/vanguard-etf-could-set-you-life-if-you-buy-it-april","source_event_id":"evt_c679017f1b48","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"61115bb958906753","kind":"unusual_volume","published_at":"2026-04-12T04:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["December 17, 2004","April 15, 2005","April 12, 2026"],"entities":[{"asset_class":"ETF","name":"Vanguard S&P 500 ETF","relevance":"high","symbol":"VOO","type":"fund"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"","type":"index"},{"asset_class":"ETF","name":"Vanguard Growth ETF","relevance":"medium","symbol":"VUG","type":"fund"},{"asset_class":"research","name":"Motley Fool Stock Advisor","relevance":"low","symbol":"","type":"service"}],"event_type":"other","information_gaps":["No unusual volume information is provided (baseline volume, current volume, volume ratio vs average, or direction are missing).","No explicit catalyst for unusual volume is mentioned; the article is not about volume changes.","The signal type (discovery_unusual_volume_delta) is not supported by the provided text."],"key_facts":["The article states the Vanguard S&P 500 ETF (VOO) has an expense ratio of 0.03%.","The article describes investing in the S&P 500 as investing in the largest and most successful U.S. companies and as buying the entire U.S. economy via diversification.","The article states bear-market pullbacks can result in drawdowns of 30% or more.","The article says the S&P 500 has roughly one-third of its index in tech stocks right now.","The article compares VOO to the Vanguard Growth ETF (VUG), stating VUG has higher volatility, higher return potential, and higher drawdown risk.","The article includes a note that Stock Advisor identified 10 best stocks and that VOO was not one of them."],"numeric_claims":[{"label":"VOO expense ratio","value":"0.03%"},{"label":"Potential bear-market drawdown","value":"30% or more"},{"label":"Tech allocation in S&P 500","value":"roughly one-third"}],"primary_claim":"The Vanguard S&P 500 ETF (VOO) is presented as a smart long-term buy-and-hold investment for broad exposure to the S&P 500 at a 0.03% expense ratio.","relevance_score":0.15,"sentiment":"positive","source_quality":"high","summary":"The article is a long-term investing pitch for the Vanguard S&P 500 ETF (VOO), emphasizing buy-and-hold and low expense costs. It does not provide any data about unusual trading volume or a volume-vs-average ratio.","topics":["long-term investing","S&P 500 exposure","ETF expense ratio","buy-and-hold strategy","VOO vs VUG comparison","market volatility and drawdowns"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsIt's usually the simplest buy-and-hold strategies that do the best job of creating long-term wealth.","tickers":[],"title":"The Vanguard ETF That Could Set You Up for Life if You Buy It in April","url":"https://www.fool.com/investing/2026/04/12/vanguard-etf-that-could-set-you-up-for-life/"}

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