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-16T22:10:50.304260+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:16ac3c5482be399b","evidence_event_ids":["evt_dd8956f032c9"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","as_of":"2026-04-16T22:10:50.304260+00:00","canonical_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","article_chars":2434,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5c1f8a0e250f29ba","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T15:22:24.919971+00:00","extraction_method":"trafilatura","fetched_description":"In the past few weeks, as the conflict in Iran started, data shows retail trading has fallen significantly. Interestingly, so did the price of gold.","fetched_title":"Retail Traders Retreat Amid Iran Conflict | Nasdaq","final_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict","source_event_id":"evt_dd8956f032c9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"febde54bd0a28204","kind":"sector_rotation","published_at":"2026-04-16T21:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["late 2024","end of last year","past few weeks (relative to Iran conflict start)","April 8","first quarter of 2026","March","2020","2021","2022","2023","2019"],"entities":[{"asset_class":"equities","name":"Retail traders","relevance":"high","symbol":"","type":"market_participant"},{"asset_class":"commodity","name":"Gold","relevance":"medium","symbol":"XAU","type":"commodity"},{"asset_class":"fund","name":"Exchange-traded funds (ETFs)","relevance":"high","symbol":"","type":"instrument"},{"asset_class":"equities","name":"NVIDIA","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"equities","name":"Tesla","relevance":"low","symbol":"TSLA","type":"company"}],"event_type":"conflict","information_gaps":["The text does not specify which named sectors are gaining vs losing; it only states that net flows across all sectors turned negative.","No explicit sector-level winners/losers are enumerated; only leadership changes at the single-stock level (e.g., NVIDIA vs Tesla) are described.","The macro driver is described as the Iran conflict, but the mechanism linking it to retail behavior (beyond ETF being a natural way to play a macro event) is not quantified.","Gold\u2019s price change magnitude is not provided (only that it \u201cso did the price of gold\u201d).","No explicit classification of the move as a regime shift vs short-term rebalancing is stated; the article implies a \u201cfirst significant reduction\u201d since 2021 and notes a rebound after April 8, but does not label it definitively."],"key_facts":["Retail trading reached about $70 billion per day in late 2024 as markets rotated out of crypto and software stocks into value stocks.","In the past few weeks after the Iran conflict started, retail trading fell significantly.","Retail ETF activity fell by around $5 billion per day during the conflict period.","Single-stock retail trading dropped to below $35 billion per day.","After a ceasefire was put in place on April 8, stock flows rebounded above $40 billion per day.","Retail remained net-buyers of ETFs throughout Q1 2026, buying more than $19 billion in ETFs in March and over $70 billion in ETFs during Q1.","Retail were sellers of single stocks every day in March, resulting in net selling of over $15 billion in March (a record for the periods with data).","As the conflict continued, net flows across all sectors turned negative, and buying/selling in NVIDIA fell to roughly balanced."],"numeric_claims":[{"label":"Retail trading level (late 2024)","value":"$70 billion/day"},{"label":"Retail ETF activity decline","value":"~$5 billion/day"},{"label":"Single-stock retail trading level during conflict","value":"below $35 billion/day"},{"label":"Stock flows after April 8 ceasefire","value":"above $40 billion/day"},{"label":"Retail ETF buying in March (net)","value":"more than $19 billion"},{"label":"Retail ETF buying in Q1 2026 (net)","value":"over $70 billion"},{"label":"Retail net selling of single stocks in March","value":"over $15 billion"},{"label":"NVIDIA buying/selling during conflict","value":"roughly balanced"}],"primary_claim":"In the past few weeks as the Iran conflict started, retail trading fell significantly, with retail ETF activity down by about $5 billion per day and single-stock retail trading dropping below $35 billion per day.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"During the Iran conflict, retail trading activity fell sharply, with reduced retail ETF activity and persistent net selling of single stocks. After a ceasefire on April 8, stock flows rebounded, suggesting a short-term rebalancing rather than a fully sustained regime change.","topics":["retail trading","Iran conflict","ETF flows","single-stock flows","sector/leadership rotation","gold price reaction","ceasefire rebound"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"In the past few weeks, as the conflict in Iran started, data shows retail trading has fallen significantly. Interestingly, so did the price of gold.","tickers":[],"title":"Retail Traders Retreat Amid Iran Conflict","url":"https://www.nasdaq.com/articles/retail-traders-retreat-amid-iran-conflict"}}

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