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-21T16:48:38.963204+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:9d947296385bdee6","evidence_event_ids":["evt_70b5092e6792"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","as_of":"2026-04-21T16:48:38.963204+00:00","canonical_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","article_chars":1258,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_243aa3477c39157a","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:12:37.529188+00:00","extraction_method":"trafilatura","fetched_description":"Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the Roundhill Magnificent Seven ETF (Symbol: MAGS) where we have detected an approximate $196.1 million dollar inflow -- that's a 16.6% increase week ove","fetched_title":"MAGS: ETF Inflow Alert | Nasdaq","final_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert","source_event_id":"evt_70b5092e6792","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3f64515707c98eb","kind":"sector_rotation","published_at":"2026-04-21T14:50:40+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"ETF","name":"MAGS ETF","relevance":"high","symbol":"MAGS","type":"etf"}],"event_type":"listing","information_gaps":["No sector-level breakdown is provided (no explicit sectors gaining vs losing).","No macro driver is stated in the provided text.","The signal does not indicate whether this is a regime shift versus short-term rebalancing beyond describing it as a week-over-week inflow.","The article text is truncated around 'outstanding un', so the exact phrasing/metric (shares vs units) is partially unclear.","No time/date for the 'today' reference or the specific week-over-week period is provided."],"key_facts":["The article monitors week-over-week changes in ETF shares outstanding to detect notable inflows (new units created) or outflows (old units destroyed).","MAGS ETF (MAGS) is identified as having an approximate $310.4 million inflow.","The inflow is described as a 7.4% increase week over week in outstanding shares/units (text truncated after 'outstanding un').","MAGS 52-week low is $32.03 per share and 52-week high is $57.245 per share.","Last trade is $56.76 per share.","The article mentions comparing the most recent share price to the 200-day moving average as a technical analysis technique (no specific result provided)."],"numeric_claims":[{"label":"inflow_amount_usd","value":"310.4 million"},{"label":"inflow_percent_wow","value":"7.4%"},{"label":"52_week_low_usd","value":"32.03"},{"label":"52_week_high_usd","value":"57.245"},{"label":"last_trade_usd","value":"56.76"}],"primary_claim":"MAGS ETF (MAGS) shows an approximate $310.4 million inflow, about a 7.4% week-over-week increase in outstanding shares/units.","relevance_score":0.45,"sentiment":"positive","source_quality":"medium","summary":"The signal identifies the MAGS ETF as experiencing a notable week-over-week increase in shares outstanding, consistent with an ETF inflow. The provided text does not specify other sectors gaining/losing or any macro driver.","topics":["ETF inflow","shares outstanding change","MAGS","ETF units 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 MAGS ETF (Symbol: MAGS) where we have detected an approximate $310.4 million dollar inflow -- that's a 7.4% increase week over week in outstanding un","tickers":[],"title":"MAGS: ETF Inflow Alert","url":"https://www.nasdaq.com/articles/mags-etf-inflow-alert"}}

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 475527 in events