SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","as_of":"2026-04-10T15:51:15.884890+00:00","canonical_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","article_chars":3149,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b37c3334011646a0","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T18:49:20.972459+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 Core S&P Mid-Cap ETF (Symbol: IJH) where we have detected an approximate $194.7 million dollar inflow -- that's a 0.3% increase week ove","fetched_title":"iShares Core S&P Mid-Cap ETF Experiences Big Inflow | Nasdaq","final_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow","source_event_id":"evt_4a2ba9bd9f11","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9b0b79924afb4bf3","kind":"sector_rotation","published_at":"2026-04-10T15:02:38+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["January 14, 2022"],"entities":[{"asset_class":"ETF","name":"iShares Core S&P Mid-Cap ETF","relevance":"high","symbol":"IJH","type":"ETF"},{"asset_class":"equity","name":"Molina Healthcare Inc","relevance":"medium","symbol":"MOH","type":"equity_component"},{"asset_class":"equity","name":"Camden Property Trust","relevance":"medium","symbol":"CPT","type":"equity_component"},{"asset_class":"equity","name":"Cognex Corp","relevance":"medium","symbol":"CGNX","type":"equity_component"}],"event_type":"listing","information_gaps":["No sector-level breakdown is provided (no explicit sectors gaining/losing).","The macro driver for any sector rotation is not discussed.","The article does not characterize the move as a regime shift versus short-term rebalancing; it only describes monitoring for notable ETF inflows/outflows.","The headline mentions a $321.5 million inflow, but the article text states approximately $194.7 million; the discrepancy is not explained in the provided text."],"key_facts":["The article reports IJH had an approximate $194.7 million inflow.","IJH outstanding units increased by about 0.3% week over week.","Outstanding units increased from 241,400,000 to 242,100,000.","Among IJH\u2019s largest underlying components mentioned: MOH is up about 0.1%, CPT is off about 0.5%, and CGNX is lower by about 0.8%.","The article explains that ETF unit creation/destruction can lead to buying/selling underlying holdings to meet investor demand."],"numeric_claims":[{"label":"inflow_amount_usd","value":"~$194.7 million"},{"label":"inflow_percent_week_over_week","value":"0.3%"},{"label":"units_outstanding_start","value":"241,400,000"},{"label":"units_outstanding_end","value":"242,100,000"},{"label":"MOH_move","value":"~+0.1%"},{"label":"CPT_move","value":"~-0.5%"},{"label":"CGNX_move","value":"~-0.8%"}],"primary_claim":"IJH experienced an approximate $194.7 million inflow, a 0.3% week-over-week increase in outstanding units (from 241,400,000 to 242,100,000).","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The iShares Core S&P Mid-Cap ETF (IJH) saw a notable week-over-week inflow, evidenced by an increase in shares/units outstanding. The article does not provide a sector-by-sector rotation map, but it notes small component-level moves among IJH holdings.","topics":["ETF flows","shares/units outstanding","IJH inflow","ETF components","week-over-week ETF monitoring"]},"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 Core S&P Mid-Cap ETF (Symbol: IJH) where we have detected an approximate $321.5 million dollar inflow -- that's a 0.3% increase week over","tickers":[],"title":"iShares Core S&P Mid-Cap ETF Experiences Big Inflow","url":"https://www.nasdaq.com/articles/ishares-core-sp-mid-cap-etf-experiences-big-inflow"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_a5567208e07a in signals