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-19T15:45:47.773233+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:2336322a348534cb","evidence_event_ids":["evt_f32dbb8c02bb"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-vanguard-short-term-bond-etf-bsv-or-vgsh","as_of":"2026-04-19T15:45:47.773233+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/19/which-is-the-better-vanguard-short-term-bond-etf-bsv-or-vgsh/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-vanguard-short-term-bond-etf-bsv-or-vgsh","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9ec9ea7d90eef869","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/19/which-is-the-better-vanguard-short-term-bond-etf-bsv-or-vgsh/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T17:11:18.011588+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsBoth funds charge the same very low expense ratio and offer identical 3.9% yields as of mid-April 2026.","fetched_title":"Which Is the Better Vanguard Short-Term Bond ETF, BSV or VGSH? | Nasdaq","final_url":"https://www.nasdaq.com/articles/which-better-vanguard-short-term-bond-etf-bsv-or-vgsh","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/which-better-vanguard-short-term-bond-etf-bsv-or-vgsh","source_event_id":"evt_f32dbb8c02bb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa9eec88468d4ff8","kind":"unusual_volume","published_at":"2026-04-19T13:56:01+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["mid-April 2026","April 19, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"ETF (short-term Treasuries)","name":"Vanguard Short-Term Treasury ETF","relevance":"high","symbol":"VGSH","type":"fund"},{"asset_class":"ETF (short-term bonds incl. Treasuries + corporate/international)","name":"Vanguard Short-Term Bond ETF","relevance":"high","symbol":"BSV","type":"fund"},{"asset_class":"asset manager","name":"Vanguard","relevance":"medium","symbol":"","type":"issuer"}],"event_type":"other","information_gaps":["No volume ratio vs average is provided in the supplied text.","No baseline volume, current volume, or direction (up/down) for any ticker is provided.","No explicit catalyst for unusual volume is mentioned; the content is a fund comparison rather than a trading-volume event.","The signal type 'discovery_unusual_volume_delta' is not supported by the provided article text."],"key_facts":["Both funds charge the same expense ratio of 0.03%.","Both funds currently yield 3.9% as of mid-April 2026.","BSV is larger and holds fewer bonds than VGSH (article states BSV holds about 30 bonds; VGSH has 93 holdings).","BSV has outperformed VGSH over the past year.","BSV has a deeper historical maximum drawdown than VGSH, implying somewhat greater risk/volatility.","VGSH invests primarily/solely in U.S. Treasuries with 93 holdings concentrated in one- to three-year maturities.","BSV holds a mix of U.S. government, investment-grade corporate, and international dollar-denominated debt.","The article cites BSV\u2019s top holdings as U.S. Treasury Note/Bond 3.88% 03/31/2031 and U.S. Dollar and U.S. Treasury Note/Bond 3.50% 01/31/2028.","The article cites VGSH\u2019s top holdings as U.S. Treasury Note/Bond 3.50% 01/31/2028, U.S. Treasury Note/Bond 3.88% 07/31/2027, and U.S. Treasury Note/Bond 4.25% 02/28/2029."],"numeric_claims":[{"label":"expense_ratio","value":"0.03% (both)"},{"label":"yield","value":"3.9% (as of mid-April 2026)"},{"label":"BSV_holdings","value":"~30 bonds"},{"label":"VGSH_holdings","value":"93 holdings"}],"primary_claim":"BSV and VGSH have identical expense ratios (0.03%) and identical yields (3.9% as of mid-April 2026), but BSV\u2019s broader bond mix has produced higher recent returns with a deeper maximum drawdown than VGSH.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article compares Vanguard\u2019s short-term bond ETFs VGSH (Treasuries-only) and BSV (broader mix including corporate and international bonds), noting identical fees and yields but different risk/return profiles. It does not provide any unusual trading volume metrics or a volume ratio vs average.","topics":["ETF comparison","expense ratio","yield","short-term bonds","U.S. Treasuries vs diversified bond mix","risk/maximum drawdown","portfolio construction"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBoth funds charge the same very low expense ratio and offer identical 3.9% yields as of mid-April 2026.","tickers":[],"title":"Which Is the Better Vanguard Short-Term Bond ETF, BSV or VGSH?","url":"https://www.fool.com/coverage/etfs/2026/04/19/which-is-the-better-vanguard-short-term-bond-etf-bsv-or-vgsh/"}}

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