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:5026ea32ae9b2b09","evidence_event_ids":["evt_42c67388df5b"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-ishares-short-term-bond-etf-igsb-or-istb","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-ishares-short-term-bond-etf-igsb-or-istb/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-ishares-short-term-bond-etf-igsb-or-istb","article_chars":4966,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ffce4892672d3d85","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/19/which-is-the-better-ishares-short-term-bond-etf-igsb-or-istb/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T16:15:49.984309+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsIGSB charges a slightly lower expense ratio and offers a modestly higher yield than ISTB.","fetched_title":"Which Is the Better iShares Short-Term Bond ETF, IGSB or ISTB? | Nasdaq","final_url":"https://www.nasdaq.com/articles/which-better-ishares-short-term-bond-etf-igsb-or-istb","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/which-better-ishares-short-term-bond-etf-igsb-or-istb","source_event_id":"evt_42c67388df5b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b2fca343ee23d7bf","kind":"unusual_volume","published_at":"2026-04-19T14:45:01+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 19, 2026","December 17, 2004","April 15, 2005"],"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":"iShares Core 1-5 Year USD Bond ETF","relevance":"high","symbol":"ISTB","type":"ETF"},{"asset_class":"unknown","name":"iShares Trust","relevance":"medium","symbol":"","type":"issuer/brand reference"}],"event_type":"other","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text contains no volume data, no volume ratio vs average, and no mention of unusual trading volume for IGSB or ISTB.","No explicit catalyst for any volume change is described; the article is a comparative analysis of fund characteristics and performance.","Exact expense ratio and yield figures are not provided\u2014only relative statements ('slightly lower', 'modestly higher').","The article mentions 'max drawdown over the last five years' but does not provide the numeric drawdown value."],"key_facts":["IGSB has a slightly lower expense ratio than ISTB.","IGSB offers a modestly higher yield than ISTB.","IGSB has delivered stronger 1-year and 5-year total returns than ISTB.","IGSB exhibits marginally higher drawdown risk than ISTB.","IGSB holds 4,582 investment-grade U.S. corporate bonds and focuses exclusively on investment-grade corporates.","ISTB holds 7,037 holdings spanning investment-grade and high-yield bonds and includes U.S. Treasuries.","The article states U.S. Treasuries are 52.4% of ISTB holdings.","The article states top ISTB allocations include Fannie Mae (1.6%), Freddie Mac (1.1%), and JP Morgan Chase (0.6%).","The article states IGSB does not include U.S. Treasuries, which it links to greater risk."],"numeric_claims":[{"label":"IGSB expense ratio (relative)","value":"slightly lower than ISTB (exact value not provided)"},{"label":"IGSB yield (relative)","value":"modestly higher than ISTB (exact value not provided)"},{"label":"IGSB holdings count","value":"4,582"},{"label":"ISTB holdings count","value":"7,037"},{"label":"ISTB U.S. Treasuries weight","value":"52.4%"},{"label":"ISTB top allocation - Fannie Mae","value":"1.6%"},{"label":"ISTB top allocation - Freddie Mac","value":"1.1%"},{"label":"ISTB top allocation - JP Morgan Chase","value":"0.6%"}],"primary_claim":"IGSB charges a slightly lower expense ratio and offers a modestly higher yield than ISTB, with stronger 1-year and 5-year total returns but marginally higher drawdown risk.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article compares two short-term bond ETFs, iShares IGSB and ISTB, concluding IGSB is cheaper and has slightly higher yield and stronger 1- and 5-year total returns, while ISTB is more diversified and shows lower max drawdown over five years.","topics":["ETF comparison","expense ratio","yield","total return","drawdown risk","portfolio composition","investment-grade corporates","U.S. Treasuries","short-duration bonds"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsIGSB charges a slightly lower expense ratio and offers a modestly higher yield than ISTB.","tickers":[],"title":"Which Is the Better iShares Short-Term Bond ETF, IGSB or ISTB?","url":"https://www.fool.com/coverage/etfs/2026/04/19/which-is-the-better-ishares-short-term-bond-etf-igsb-or-istb/"}}

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