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/scho-large-outflows-detected-etf","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.nasdaq.com/articles/scho-large-outflows-detected-etf","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/scho-large-outflows-detected-etf","article_chars":2945,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_01d43b7fd7c95af1","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/scho-large-outflows-detected-etf","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:20:15.115431+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 Schwab Short-Term U.S. Treasury ETF (Symbol: SCHO) where we have detected an approximate $171.9 million dollar outflow -- that's a 1.5% decrease wee","fetched_title":"SCHO: Large Outflows Detected at ETF | Nasdaq","final_url":"https://www.nasdaq.com/articles/scho-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/scho-large-outflows-detected-etf","source_event_id":"evt_643f3a0ede88","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"09f2b1042835a26c","kind":"sector_rotation","published_at":"2026-04-09T14:59:42+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["June 10, 2025","10:49 am EDT"],"entities":[{"asset_class":"ETF","name":"Schwab Short-Term U.S. Treasury ETF","relevance":"high","symbol":"SCHO","type":"etf"}],"event_type":"supply_disruption","information_gaps":["The signal type asks for which sectors are gaining and losing, but the provided text only reports flows for SCHO and does not list other sectors/ETFs as gainers/losers.","No macro driver is explicitly stated in the provided text.","The article does not characterize the move as a regime shift versus short-term rebalancing; it only reports the outflow and the monitoring methodology.","A discrepancy exists between the headline/source summary ($360.9 million outflow, 2.9% decrease) and the cleaned article text ($171.9 million outflow, 1.5% decrease); the provided text contains the $171.9 million figure, but the mismatch is unresolved."],"key_facts":["The article is dated June 10, 2025 (10:49 am EDT).","It monitors week-over-week changes in ETF shares outstanding to identify notable inflows/outflows.","For SCHO, the article detects an approximate $171.9 million outflow week-over-week.","SCHO shares outstanding decreased from 460,800,000 to 453,700,000.","The decrease is described as about a 1.5% week-over-week decline.","The article states that ETF unit creation requires underlying holdings to be purchased, and unit destruction involves selling underlying holdings, so large flows can impact ETF components.","The article includes SCHO\u2019s 52-week low ($23.95) and 52-week high ($24.535), and notes a last trade of $24.21.","The article references comparing the most recent share price to the 200-day moving average, but does not provide a specific numeric deviation."],"numeric_claims":[{"label":"SCHO outflow (approx., week-over-week)","value":"$171.9 million"},{"label":"SCHO shares outstanding (start)","value":"460,800,000"},{"label":"SCHO shares outstanding (end)","value":"453,700,000"},{"label":"SCHO shares outstanding change (percent)","value":"-1.5%"},{"label":"SCHO 52-week low (per share)","value":"$23.95"},{"label":"SCHO 52-week high (per share)","value":"$24.535"},{"label":"SCHO last trade (per share)","value":"$24.21"}],"primary_claim":"SCHO experienced an approximate $171.9 million outflow week-over-week, with shares outstanding falling from 460,800,000 to 453,700,000 (about a 1.5% decrease).","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"The article reports notable week-over-week outflows from the Schwab Short-Term U.S. Treasury ETF (SCHO), based on a decline in shares outstanding. It provides the magnitude of the outflow and related unit/share mechanics but does not identify other gaining/losing sectors beyond SCHO.","topics":["ETF flows","shares outstanding","outflows","short-term U.S. Treasury exposure","ETF unit creation/redemption mechanics"]},"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 Schwab Short-Term U.S. Treasury ETF (Symbol: SCHO) where we have detected an approximate $360.9 million dollar outflow -- that's a 2.9% decrease wee","tickers":[],"title":"SCHO: Large Outflows Detected at ETF","url":"https://www.nasdaq.com/articles/scho-large-outflows-detected-etf"}

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