SQLite Web: event

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-20T13:10:00.946643+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:6f53b805e1872e7d","evidence_event_ids":["evt_0aa4958576f0"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/warren-buffetts-favorite-index-fund-and-it-could-turn-200-month-1-million","as_of":"2026-04-20T13:10:00.946643+00:00","canonical_url":"https://www.fool.com/investing/2026/04/20/this-is-warren-buffetts-favorite-index-fund-and-it/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/warren-buffetts-favorite-index-fund-and-it-could-turn-200-month-1-million","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ca9e509d4c180645","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/20/this-is-warren-buffetts-favorite-index-fund-and-it/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T13:12:48.687838+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsFor years, Warren Buffett has highly recommended investing in an S&P 500 index fund.","fetched_title":"This Is Warren Buffett's Favorite Index Fund, and It Could Turn $200 per Month Into $1 Million | Nasdaq","final_url":"https://www.nasdaq.com/articles/warren-buffetts-favorite-index-fund-and-it-could-turn-200-month-1-million","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/warren-buffetts-favorite-index-fund-and-it-could-turn-200-month-1-million","source_event_id":"evt_0aa4958576f0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bff9eca26983f1ae","kind":"unusual_volume","published_at":"2026-04-20T12:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2008","2020","10 years"],"entities":[{"asset_class":"equity","name":"Warren Buffett","relevance":"high","symbol":"","type":"person"},{"asset_class":"equity","name":"Berkshire Hathaway","relevance":"medium","symbol":"BRK","type":"company"},{"asset_class":"index_fund","name":"S&P 500 index fund","relevance":"high","symbol":"^GSPC","type":"asset"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"research","name":"Crestmont Research","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["No unusual trading volume data (volume ratio vs average, direction, or ticker) is provided in the supplied text, so the discovery_unusual_volume_delta fields cannot be grounded.","The article does not specify which exact S&P 500 index fund/ticker is being referenced.","The article does not provide the actual calculation steps or time horizon needed to reach $1 million in the $200/month example.","No explicit statement is made about whether any volume change is confirmed by news or is unexplained; the provided text contains no volume discussion."],"key_facts":["The article states Buffett highly recommends investing in an S&P 500 index fund.","It claims Buffett said at Berkshire Hathaway\u2019s 2020 shareholder meeting that it\u2019s \u201cthe best thing\u201d for most investors.","It states Buffett backed the advice in 2008 with a $1 million bet that an S&P 500 index fund could outperform five actively managed hedge funds.","The article claims that after 10 years, the S&P 500 index fund earned total returns of around 126%, while the five hedge funds averaged around 36% and the highest earned around 88%.","The article says an S&P 500 index fund holds around 500 stocks across every sector for diversification.","It claims Crestmont Research analysis found every 20-year period in the S&P 500\u2019s history ended in positive total returns.","The article states the S&P 500 has earned an average rate of return of around 10% per year historically.","It provides a scenario that investing $200 per month could compound over time to reach $1 million or more, depending on whether returns are around 10% or 12% per year.","The article notes a drawback: an S&P 500 index fund aims to track the market rather than beat it."],"numeric_claims":[{"label":"S&P 500 index fund total returns after 10 years (Buffett bet)","value":"~126%"},{"label":"Average hedge fund total returns after 10 years (Buffett bet)","value":"~36%"},{"label":"Highest hedge fund total returns after 10 years (Buffett bet)","value":"~88%"},{"label":"S&P 500 average annual return (historical, per article)","value":"~10% per year"},{"label":"Alternative annual return scenario (per article)","value":"~12% per year"},{"label":"Monthly investment example","value":"$200 per month"},{"label":"Target value","value":"$1,000,000+ (over time)"}],"primary_claim":"Warren Buffett has highly recommended buying an S&P 500 index fund as a \u201cbest thing\u201d for most investors, and the article claims $200 per month could compound to over $1 million given long-term returns.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article argues that Warren Buffett repeatedly recommends investing in an S&P 500 index fund, citing historical performance and compounding to illustrate how $200/month could reach $1 million or more over time.","topics":["Buffett advice","S&P 500 index funds","long-term investing","index fund diversification","compounding returns","historical performance vs active management"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsFor years, Warren Buffett has highly recommended investing in an S&P 500 index fund.","tickers":[],"title":"This Is Warren Buffett's Favorite Index Fund, and It Could Turn $200 per Month Into $1 Million","url":"https://www.fool.com/investing/2026/04/20/this-is-warren-buffetts-favorite-index-fund-and-it/"}}

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

event_store.db — events

Update row 438683 in events