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-14T12:12:32.185628+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:3c6d78a6fe15c0e6","evidence_event_ids":["evt_d060b35fdde4"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/opportunity-beckons-vanguard-value-etf-and-its-not-one-youre-thinking","as_of":"2026-04-14T12:12:32.185628+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/opportunity-vanguard-value-etf-voe-mid-cap/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/opportunity-beckons-vanguard-value-etf-and-its-not-one-youre-thinking","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5a44dc2c0aa87902","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/opportunity-vanguard-value-etf-voe-mid-cap/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T12:13:43.071844+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsWith value stocks on the mend, the Vanguard Mid-Cap Value ETF should be turning more heads.","fetched_title":"Opportunity Beckons With This Vanguard Value ETF and It's Not The One You're Thinking Of | Nasdaq","final_url":"https://www.nasdaq.com/articles/opportunity-beckons-vanguard-value-etf-and-its-not-one-youre-thinking","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/opportunity-beckons-vanguard-value-etf-and-its-not-one-youre-thinking","source_event_id":"evt_d060b35fdde4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e4b553e385437455","kind":"unusual_volume","published_at":"2026-04-14T11:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["August","March","nearly two years (relative timeframe)","December 17, 2004","April 15, 2005","April 14, 2026"],"entities":[{"asset_class":"ETF","name":"Vanguard Mid-Cap Value ETF","relevance":"high","symbol":"VOE","type":"etf"},{"asset_class":"ETF","name":"Vanguard large- and small-cap stablemates","relevance":"medium","symbol":"","type":"peer_group"},{"asset_class":"macro","name":"Consumer Price Index (CPI)","relevance":"medium","symbol":"","type":"economic_indicator"}],"event_type":"price_action","information_gaps":["The signal type is \"discovery_unusual_volume_delta,\" but the provided text does not include any volume ratio vs average, baseline volume, or direction of volume change.","The article does not explicitly confirm whether any unusual volume is confirmed by news; it provides no trading-volume discussion.","A catalyst hypothesis for unusual volume is not stated; the article instead discusses performance drivers (value stocks, inflation, sector allocations).","The article does not provide a specific catalyst date/time that would align with a volume spike."],"key_facts":["The article states VOE is the Vanguard Mid-Cap Value ETF (NYSEMKT: VOE).","It claims VOE has beaten Vanguard large- and small-cap stablemates since the start of the year.","It says VOE turns 20 years old in August and has $22.3 billion in assets under management.","It states VOE allocates 10.8% of its portfolio to the energy sector.","It states VOE allocates 9% to the technology sector.","It states VOE charges 0.05% per year (\"$5 on a $10,000 position\").","It states VOE has 178 holdings and none exceed 2.43% of the portfolio.","It references CPI: \"March reading of the Consumer Price Index to 3.3%, the highest level in nearly two years\" and suggests mid-caps have a reputation as inflation fighters."],"numeric_claims":[{"label":"AUM","value":"$22.3 billion"},{"label":"Energy sector allocation","value":"10.8%"},{"label":"Technology sector allocation","value":"9%"},{"label":"Expense ratio","value":"0.05% per year"},{"label":"Number of holdings","value":"178"},{"label":"Max single holding weight","value":"2.43%"},{"label":"CPI (March)","value":"3.3%"}],"primary_claim":"The Vanguard Mid-Cap Value ETF (NYSEMKT: VOE) has beaten Vanguard\u2019s large- and small-cap stablemates since the start of the year and may benefit from value/inflation conditions.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article promotes the Vanguard Mid-Cap Value ETF (VOE), arguing it has outperformed Vanguard\u2019s large- and small-cap counterparts this year and may benefit from value/inflation dynamics. No specific unusual trading volume ratio is provided in the text.","topics":["ETF performance","value stocks","mid-cap stocks","inflation/CPI","sector allocation","expense ratio"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsWith value stocks on the mend, the Vanguard Mid-Cap Value ETF should be turning more heads.","tickers":[],"title":"Opportunity Beckons With This Vanguard Value ETF and It's Not The One You're Thinking Of","url":"https://www.fool.com/investing/2026/04/14/opportunity-vanguard-value-etf-voe-mid-cap/"}}

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