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-sp-100-etf-experiences-big-outflow-1","as_of":"2026-04-10T15:51:15.884890+00:00","canonical_url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1","article_chars":3155,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5b7f330b598ba62d","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T18:50:06.273100+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 S&P 100 ETF (Symbol: OEF) where we have detected an approximate $117.7 million dollar outflow -- that's a 1.1% decrease week over week (","fetched_title":"iShares S&P 100 ETF Experiences Big Outflow | Nasdaq","final_url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1","source_event_id":"evt_9e35821e7bd2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3db674434d7362ba","kind":"sector_rotation","published_at":"2026-04-10T15:02:10+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["February 21, 2024"],"entities":[{"asset_class":"equity_etf","name":"iShares S&P 100 ETF","relevance":"high","symbol":"OEF","type":"ETF"},{"asset_class":"equities","name":"Merck & Co Inc","relevance":"medium","symbol":"MRK","type":"equity_component"},{"asset_class":"equities","name":"AbbVie Inc","relevance":"medium","symbol":"ABBV","type":"equity_component"},{"asset_class":"equities","name":"Walmart Inc","relevance":"medium","symbol":"WMT","type":"equity_component"}],"event_type":"price_action","information_gaps":["No sector-level rotation (which sectors are gaining/losing) is explicitly identified in the provided text.","No macro driver is specified (e.g., rates, inflation, earnings, risk-off) beyond the general statement that ETF flows can affect holdings.","The article does not characterize the move as a regime shift versus short-term rebalancing; it only reports week-over-week outflow and intraday component moves.","The article mentions a chart and a 200-day moving average comparison, but provides limited quantified technical details beyond 52-week levels and last trade.","The headline/source summary contains a different outflow figure ($183.1M) than the cleaned article text ($117.7M); the discrepancy is not resolved in the provided text."],"key_facts":["OEF (iShares S&P 100 ETF) had an approximate $117.7 million outflow week-over-week.","OEF shares outstanding decreased week-over-week from 47,400,000 to 46,900,000 (about a 1.1% decrease).","The article states that ETF unit creation/destruction can drive underlying holdings purchases/sales.","Among OEF\u2019s largest underlying components mentioned, MRK was off about 0.2% on the day, ABBV was off about 0.1% on the day, and WMT was lower by about 0.9% on the day.","The article includes a reference to OEF\u2019s 52-week low ($172.04) and high ($239.74) and a last trade of $234.89, and compares price to its 200-day moving average (details not quantified beyond the last trade/levels)."],"numeric_claims":[{"label":"OEF outflow (approx.)","value":"$117.7 million"},{"label":"OEF shares outstanding (week-over-week)","value":"47,400,000 to 46,900,000"},{"label":"OEF shares outstanding change (week-over-week)","value":"-1.1%"},{"label":"MRK move (on the day)","value":"-0.2%"},{"label":"ABBV move (on the day)","value":"-0.1%"},{"label":"WMT move (on the day)","value":"-0.9%"},{"label":"OEF 52-week low","value":"$172.04"},{"label":"OEF 52-week high","value":"$239.74"},{"label":"OEF last trade","value":"$234.89"}],"primary_claim":"OEF experienced an approximate $117.7 million outflow week-over-week, with shares outstanding falling from 47,400,000 to 46,900,000 (about a 1.1% decrease).","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"The iShares S&P 100 ETF (OEF) saw a notable week-over-week outflow, with shares outstanding decreasing by about $117.7M (1.1%). The article notes that some large OEF components were down on the day, but it does not identify sector-level winners/losers or a macro driver.","topics":["ETF flows","OEF outflow","shares outstanding change","ETF unit creation/destruction","component performance (intraday)"]},"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 S&P 100 ETF (Symbol: OEF) where we have detected an approximate $183.1 million dollar outflow -- that's a 1.0% decrease week over week (","tickers":[],"title":"iShares S&P 100 ETF Experiences Big Outflow","url":"https://www.nasdaq.com/articles/ishares-sp-100-etf-experiences-big-outflow-1"}

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