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-05T18:32:13.390712+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:7e368e0b62171e35","evidence_event_ids":["evt_b147aee36117"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/most-investors-build-their-portfolio-backwards-heres-right-order","as_of":"2026-04-05T18:32:13.390712+00:00","canonical_url":"https://www.fool.com/investing/2026/04/05/most-investors-build-their-portfolio-backwards/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/most-investors-build-their-portfolio-backwards-heres-right-order","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a8bb37a1c8d1a87d","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/05/most-investors-build-their-portfolio-backwards/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-05T19:02:30.679748+00:00","extraction_method":"heuristic","fetched_description":"Key PointsA well-constructed portfolio shouldn't just consist of the stocks or funds that have performed well in the past.","fetched_title":"Most Investors Build Their Portfolio Backwards. Here's the Right Order. | Nasdaq","final_url":"https://www.nasdaq.com/articles/most-investors-build-their-portfolio-backwards-heres-right-order","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/most-investors-build-their-portfolio-backwards-heres-right-order","source_event_id":"evt_b147aee36117","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f612e242faeaee8","kind":"unusual_volume","published_at":"2026-04-05T16:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 05, 2026"],"entities":[{"asset_class":"ETF","name":"Vanguard Total Stock Market ETF","relevance":"core portfolio component","symbol":"VTI","type":"fund"},{"asset_class":"ETF","name":"Vanguard S&P 500 ETF","relevance":"alternative core portfolio component","symbol":"VOO","type":"fund"},{"asset_class":"ETF","name":"Vanguard Total International Stock ETF","relevance":"diversification component","symbol":"VXUS","type":"fund"},{"asset_class":"ETF","name":"Vanguard Dividend Appreciation ETF","relevance":"income generation component","symbol":"VIG","type":"fund"},{"asset_class":"ETF","name":"Vanguard Total Bond Market ETF","relevance":"stability component","symbol":"","type":"fund"}],"event_type":"other","information_gaps":["No specific unusual volume data provided.","No confirmed news or catalyst for unusual volume mentioned."],"key_facts":["A well-constructed portfolio should start with a foundational position in a total U.S. stock market fund.","Investors often build portfolios based on past performance rather than a structured strategy."],"numeric_claims":[],"primary_claim":"Investors should construct their portfolios starting with a core position in a total U.S. stock market fund.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"The article discusses the importance of building a well-structured investment portfolio, emphasizing a foundational approach starting with a total U.S. stock market fund.","topics":["portfolio construction","investment strategy","ETFs"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsA well-constructed portfolio shouldn't just consist of the stocks or funds that have performed well in the past.","tickers":[],"title":"Most Investors Build Their Portfolio Backwards. Here's the Right Order.","url":"https://www.fool.com/investing/2026/04/05/most-investors-build-their-portfolio-backwards/"}}

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 23224 in events