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-12T13:46:53.258496+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:8ca50c1f4098c76c","evidence_event_ids":["evt_76bc8aceb051"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/comparing-bond-etfs-vanguards-bsv-vs-ishares-igsb","as_of":"2026-04-12T13:46:53.258496+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/12/comparing-bond-etfs-vanguard-s-bsv-vs-ishares-igsb/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/comparing-bond-etfs-vanguards-bsv-vs-ishares-igsb","article_chars":4755,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ffcd4ea240a2a508","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/12/comparing-bond-etfs-vanguard-s-bsv-vs-ishares-igsb/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T13:47:47.496952+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsIGSB has delivered a higher 1-year total return and yield compared to BSV.","fetched_title":"Comparing Bond ETFs: Vanguard's BSV vs. iShares' IGSB | Nasdaq","final_url":"https://www.nasdaq.com/articles/comparing-bond-etfs-vanguards-bsv-vs-ishares-igsb","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/comparing-bond-etfs-vanguards-bsv-vs-ishares-igsb","source_event_id":"evt_76bc8aceb051","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8fd68f4408b2f448","kind":"unusual_volume","published_at":"2026-04-12T13:26:03+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 12, 2026"],"entities":[{"asset_class":"bond_etf","name":"iShares 1-5 Year Investment Grade Corporate Bond ETF","relevance":"high","symbol":"IGSB","type":"etf"},{"asset_class":"bond_etf","name":"Vanguard Short-Term Bond ETF","relevance":"high","symbol":"BSV","type":"etf"},{"asset_class":"index","name":"S&P 500","relevance":"low","symbol":"SPX","type":"benchmark"}],"event_type":"other","information_gaps":["No unusual trading volume data is provided (baseline volume, current volume, volume ratio vs average, or direction are not stated).","No explicit catalyst for unusual volume is mentioned; the article is a performance/risk comparison rather than a volume event.","No specific volume confirmation by news is included in the provided text."],"key_facts":["The article states IGSB has delivered a higher 1-year total return and yield compared to BSV.","BSV is described as holding a much smaller number of bonds, while having about three times the assets under management of IGSB.","The article says both funds show similar low price volatility and minimal trading friction.","The article states IGSB experienced a slightly deeper maximum drawdown.","BSV is described as tracking a broad short-term bond index with 30 holdings and being heavily weighted toward U.S. Treasury bonds.","BSV is described as having 19 years old and $70.0 billion in assets under management.","IGSB is described as spreading $21.9 billion in assets under management across more than 4,500 investment-grade corporate bonds with maturities between one and five years.","The article states BSV is slightly more affordable on expenses, while IGSB offers a higher dividend yield.","The article states BSV focuses on government bonds and provides greater liquidity due to nearly $70 billion in assets under management.","The article states IGSB provides stronger one-year performance and a higher yield but with slightly greater risk and expense ratio."],"numeric_claims":[{"label":"BSV assets under management (USD)","value":"$70.0 billion"},{"label":"IGSB assets under management (USD)","value":"$21.9 billion"},{"label":"BSV bond holdings count","value":"30"},{"label":"IGSB bond holdings count","value":"more than 4,500"},{"label":"BSV vs IGSB assets under management relationship","value":"BSV has about three times the assets under management"}],"primary_claim":"IGSB delivered a higher 1-year total return and yield than BSV, while BSV is more focused on U.S. government debt and is described as more affordable.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article compares iShares IGSB and Vanguard BSV, stating IGSB has higher 1-year total return and yield, while BSV is more focused on U.S. Treasuries and is described as more affordable and safer. It does not provide any unusual trading-volume metrics or a volume-vs-average ratio.","topics":["ETF comparison","bond yield","1-year total return","investment-grade corporate bonds","U.S. Treasury exposure","portfolio diversification","risk metrics"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsIGSB has delivered a higher 1-year total return and yield compared to BSV.","tickers":[],"title":"Comparing Bond ETFs: Vanguard's BSV vs. iShares' IGSB","url":"https://www.fool.com/coverage/etfs/2026/04/12/comparing-bond-etfs-vanguard-s-bsv-vs-ishares-igsb/"}}

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