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-21T19:57:20.275338+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:d3e28144e6eb8e0e","evidence_event_ids":["evt_f05dffbf82b5"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/small-caps-big-possibilities-cheap-schwab-etf","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://www.fool.com/investing/2026/04/21/small-caps-big-possibilities-with-this-schwab-etf/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/small-caps-big-possibilities-cheap-schwab-etf","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4788e78673504b3a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/21/small-caps-big-possibilities-with-this-schwab-etf/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:21:12.627531+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe Schwab International Small-Cap Equity ETF makes it easy for investors to access smaller stocks from outside the U.S.","fetched_title":"Small Caps, Big Possibilities With This Cheap Schwab ETF | Nasdaq","final_url":"https://www.nasdaq.com/articles/small-caps-big-possibilities-cheap-schwab-etf","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/small-caps-big-possibilities-cheap-schwab-etf","source_event_id":"evt_f05dffbf82b5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8a8ff69ada127e65","kind":"unusual_volume","published_at":"2026-04-21T19:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["January","April 16","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"ETF","name":"Schwab International Small-Cap Equity ETF","relevance":"high","symbol":"SCHC","type":"fund"},{"asset_class":"index","name":"MSCI EAFE","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"Russell 2000","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"S&P SmallCap600","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"FTSE Developed Small Cap ex US Liquid index","relevance":"medium","symbol":"","type":"index"},{"asset_class":"exchange","name":"NYSEMKT","relevance":"low","symbol":"","type":"exchange"}],"event_type":"other","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text contains no volume data, no baseline volume, and no volume ratio vs average.","No explicit catalyst for unusual volume is described; the article is promotional and does not mention trading activity changes.","It is unclear whether any volume anomaly exists because the text does not confirm or quantify it."],"key_facts":["The article states SCHC tracks the FTSE Developed Small Cap ex US Liquid index.","The article claims that for the three years ended April 16, MSCI EAFE had slightly less annualized volatility than the S&P 500 and a maximum drawdown of 14.1% versus 18.8% for the S&P 500.","The article states SCHC delivered significantly less yearly volatility than the Russell 2000 and the S&P SmallCap600 over the past three years.","The article states SCHC turned 16 years old in January and has $5.57 billion in assets under management.","The article states SCHC holds 2,262 stocks.","The article states SCHC charges an expense ratio of 0.08% per year (described as $8 on a $10,000 position).","The article states SCHC allocates 34% of its portfolio to industrial and financial services sectors.","The article states international small caps offer diversification by not moving in lockstep with the S&P 500."],"numeric_claims":[{"label":"expense_ratio_percent","value":"0.08%"},{"label":"assets_under_management_usd_billion","value":"5.57"},{"label":"number_of_stocks","value":"2,262"},{"label":"industrial_and_financial_services_allocation_percent","value":"34%"},{"label":"msci_eafe_max_drawdown_percent","value":"14.1%"},{"label":"sp_500_max_drawdown_percent","value":"18.8%"},{"label":"three_years_end_date","value":"April 16"}],"primary_claim":"SCHC (Schwab International Small-Cap Equity ETF) has delivered lower volatility than the Russell 2000 and the S&P SmallCap600 over the past three years and charges a 0.08% expense ratio.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article promotes the Schwab International Small-Cap Equity ETF (SCHC), arguing it offers lower volatility and diversification versus major U.S. small-cap benchmarks, with a low expense ratio. No unusual trading volume or volume-vs-average ratio is provided in the text.","topics":["ETF promotion","international small caps","volatility comparison","expense ratio","diversification","index tracking","sector allocation"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe Schwab International Small-Cap Equity ETF makes it easy for investors to access smaller stocks from outside the U.S.","tickers":[],"title":"Small Caps, Big Possibilities With This Cheap Schwab ETF","url":"https://www.fool.com/investing/2026/04/21/small-caps-big-possibilities-with-this-schwab-etf/"}}

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