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-09T16:35:58.987693+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:7dd2c230ed454298","evidence_event_ids":["evt_7f6ee14f8538"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","article_chars":3319,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_57af4c5778f6f35a","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:19:36.353862+00:00","extraction_method":"heuristic","fetched_description":"Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the iShares U.S. Financials ETF (Symbol: IYF) where we have detected an approximate $189.7 million dollar outflow -- that's a 5.3% decrease week over we","fetched_title":"IYF, C, SCHW, CB: Large Outflows Detected at ETF | Nasdaq","final_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-etf","source_event_id":"evt_7f6ee14f8538","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"81dd066cff059b59","kind":"sector_rotation","published_at":"2026-04-09T15:00:13+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 09, 2026","11:00 am EDT"],"entities":[{"asset_class":"ETF","name":"iShares U.S. Financials ETF","relevance":"high","symbol":"IYF","type":"ETF"},{"asset_class":"Equity","name":"Citigroup Inc","relevance":"medium","symbol":"C","type":"Equity (component)"},{"asset_class":"Equity","name":"Charles Schwab Corporation","relevance":"medium","symbol":"SCHW","type":"Equity (component)"},{"asset_class":"Equity","name":"Chubb Ltd","relevance":"medium","symbol":"CB","type":"Equity (component)"}],"event_type":"supply_disruption","information_gaps":["The article does not name any other sectors/ETFs that are gaining or losing beyond referencing that \u201c9 other ETFs experienced notable outflows,\u201d without listing them in the provided text.","No explicit macro driver is stated in the provided text.","The article does not characterize the move as a regime shift versus short-term rebalancing; it only reports observed ETF outflows and related component price moves.","The provided text does not include the full list of IYF holdings or quantify how much each component is affected by the outflow."],"key_facts":["Week-over-week shares outstanding changes were monitored across ETFs covered by ETF Channel.","IYF had an approximate $189.7 million outflow.","IYF shares outstanding decreased about 5.3% week over week, from 29,200,000 to 27,650,000.","Among IYF\u2019s largest underlying components mentioned: Citigroup (C) was down about 0.4% on the day.","Charles Schwab (SCHW) was down about 0.1% on the day.","Chubb (CB) was up about 0.5% on the day.","The article explains that ETF unit creation implies underlying purchases, while unit destruction implies underlying selling, so large flows can affect components."],"numeric_claims":[{"label":"IYF outflow (approx.)","value":"$189.7 million"},{"label":"IYF week-over-week shares outstanding change","value":"-5.3%"},{"label":"IYF shares outstanding (start)","value":"29,200,000"},{"label":"IYF shares outstanding (end)","value":"27,650,000"},{"label":"C daily move (approx.)","value":"-0.4%"},{"label":"SCHW daily move (approx.)","value":"-0.1%"},{"label":"CB daily move (approx.)","value":"+0.5%"}],"primary_claim":"IYF experienced an approximate $189.7 million outflow, corresponding to a 5.3% week-over-week decrease in shares outstanding (29.2M to 27.65M).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article reports large week-over-week outflows from the iShares U.S. Financials ETF (IYF), with shares outstanding falling about 5.3% (from 29.2M to 27.65M units). It notes component moves for Citigroup (C), Charles Schwab (SCHW), and Chubb (CB) on the day of the report, but does not identify other sectors gaining or losing.","topics":["ETF flows","shares outstanding changes","financials sector exposure","component stock price moves","week-over-week ETF unit creation/destruction"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the iShares U.S. Financials ETF (Symbol: IYF) where we have detected an approximate $189.7 million dollar outflow -- that's a 5.3% decrease week over we","tickers":[],"title":"IYF, C, SCHW, CB: Large Outflows Detected at ETF","url":"https://www.nasdaq.com/articles/iyf-c-schw-cb-large-outflows-detected-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 12035 in events