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/iwn-sats-ttmi-cde-etf-outflow-alert","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert","article_chars":3400,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9a2322b84a7bf055","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:37:21.350167+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 Russell 2000 Value ETF (Symbol: IWN) where we have detected an approximate $299.9 million dollar outflow -- that's a 2.4% decrease week over","fetched_title":"IWN, SATS, TTMI, CDE: ETF Outflow Alert | Nasdaq","final_url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert","source_event_id":"evt_b838aa770164","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9476b37833222f76","kind":"sector_rotation","published_at":"2026-04-08T14:52:29+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 08, 2026"],"entities":[{"asset_class":"equity_etf","name":"iShares Russell 2000 Value ETF","relevance":"high","symbol":"IWN","type":"etf"},{"asset_class":"stock","name":"EchoStar Corp","relevance":"medium","symbol":"SATS","type":"equity"},{"asset_class":"stock","name":"TTM Technologies Inc","relevance":"medium","symbol":"TTMI","type":"equity"},{"asset_class":"stock","name":"Coeur Mining Inc","relevance":"medium","symbol":"CDE","type":"equity"}],"event_type":"price_action","information_gaps":["The article does not provide which other sectors (or ETFs) are gaining vs. losing beyond mentioning that other ETFs experienced notable outflows via a link (not included in the text).","No explicit macro driver is stated in the provided text.","The text does not determine whether this is a regime shift versus short-term rebalancing; it only describes a week-over-week outflow and the ETF unit mechanism."],"key_facts":["IWN shares outstanding decreased week-over-week from 65,950,000 to 64,400,000.","The article estimates this corresponds to an approximate $299.9 million outflow for IWN.","The decrease is described as 2.4% week-over-week.","On the day referenced, SATS was off about 0.1% (as an IWN component).","On the day referenced, TTMI was up about 2.6% (as an IWN component).","On the day referenced, CDE was higher by about 6% (as an IWN component).","The article explains that ETF unit creation can require buying underlying holdings, while unit destruction can involve selling underlying holdings."],"numeric_claims":[{"label":"IWN outflow (approx.)","value":"$299.9 million"},{"label":"IWN shares outstanding (week-over-week)","value":"65,950,000 -> 64,400,000"},{"label":"IWN percent change (week-over-week)","value":"-2.4%"}],"primary_claim":"IWN experienced an approximate $299.9 million outflow week-over-week, corresponding to a 2.4% decrease in shares outstanding (from 65,950,000 to 64,400,000).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article reports an ETF outflow in the iShares Russell 2000 Value ETF (IWN), with week-over-week shares outstanding decreasing by about $299.9M (2.4%). It also notes relative moves in three large IWN components (SATS, TTMI, CDE) on the day of the report.","topics":["ETF flows","shares outstanding","unit creation/destruction","IWN holdings","week-over-week ETF outflow alert"]},"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 Russell 2000 Value ETF (Symbol: IWN) where we have detected an approximate $299.9 million dollar outflow -- that's a 2.4% decrease week over","tickers":[],"title":"IWN, SATS, TTMI, CDE: ETF Outflow Alert","url":"https://www.nasdaq.com/articles/iwn-sats-ttmi-cde-etf-outflow-alert"}

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_5884cdcc2b9f in signals