Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 12055 in events
seq
Primary key.
INTEGER
id
evt_47ed32bd79f8
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T01:21:15.095621+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-09T16:35:58.987693+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:e6a23eda638945f5","evidence_event_ids":["evt_b2453e740355"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","article_chars":3414,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b5427b74a8857511","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:21:15.095589+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 Small-Cap 600 Value ETF (Symbol: IJS) where we have detected an approximate $526.1 million dollar outflow -- that's a 6.6% decrease","fetched_title":"IJS, EMN, MTCH, LKQ: ETF Outflow Alert | Nasdaq","final_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert","source_event_id":"evt_b2453e740355","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2d3e7e93f4d4b2ed","kind":"sector_rotation","published_at":"2026-04-09T14:59:16+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 09, 2026","10:59 am EDT"],"entities":[{"asset_class":"equity_etf","name":"iShares S&P Small-Cap 600 Value ETF","relevance":"high","symbol":"IJS","type":"etf"},{"asset_class":"equity","name":"Eastman Chemical Co","relevance":"medium","symbol":"EMN","type":"equity_component"},{"asset_class":"equity","name":"Match Group Inc","relevance":"medium","symbol":"MTCH","type":"equity_component"},{"asset_class":"equity","name":"LKQ Corp","relevance":"medium","symbol":"LKQ","type":"equity_component"}],"event_type":"price_action","information_gaps":["The article does not provide a full list of gaining vs losing sectors; it only discusses an ETF (IJS) and a few underlying components (EMN, MTCH, LKQ).","No explicit macro driver is stated in the provided text.","The signal type asks about sector rotation/regime shift, but the provided text does not identify sectors gaining/losing or characterize the move as a regime shift vs short-term rebalancing.","The article mentions a chart and 52-week/200-day moving average context, but no sector-level conclusions are drawn from it in the provided excerpt."],"key_facts":["The article reports an approximate $526.1 million outflow for IJS week-over-week.","IJS shares outstanding are stated to have decreased by 6.6% week-over-week, from 64,900,000 to 60,600,000.","The article states that among IJS\u2019s largest underlying components on the day of writing, EMN is down about 1.5%.","The article states that among IJS\u2019s largest underlying components on the day of writing, MTCH is down about 0.6%.","The article states that among IJS\u2019s largest underlying components on the day of writing, LKQ is relatively unchanged.","The article explains that ETF unit creation/destruction can require buying/selling underlying holdings and that large flows can impact components."],"numeric_claims":[{"label":"IJS outflow (approx.)","value":"$526.1 million"},{"label":"IJS outflow percent (shares outstanding)","value":"6.6% decrease"},{"label":"IJS shares outstanding (prior)","value":"64,900,000"},{"label":"IJS shares outstanding (current)","value":"60,600,000"},{"label":"EMN move","value":"-1.5% (about)"},{"label":"MTCH move","value":"-0.6% (about)"}],"primary_claim":"IJS experienced an approximate $526.1 million outflow week-over-week, corresponding to a 6.6% decrease in shares outstanding (from 64,900,000 to 60,600,000).","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The article flags an ETF outflow in the iShares S&P Small-Cap 600 Value ETF (IJS), with week-over-week shares outstanding decreasing by about $526.1 million (6.6%). It notes that among IJS\u2019s largest components, EMN and MTCH are down while LKQ is roughly unchanged.","topics":["ETF outflow alert","shares outstanding changes","IJS","small-cap value","ETF unit creation/destruction mechanics","component stock moves"]},"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 Small-Cap 600 Value ETF (Symbol: IJS) where we have detected an approximate $526.1 million dollar outflow -- that's a 6.6% decrease","tickers":[],"title":"IJS, EMN, MTCH, LKQ: ETF Outflow Alert","url":"https://www.nasdaq.com/articles/ijs-emn-mtch-lkq-etf-outflow-alert"}}
TEXT NOT NULL
source_ref
candidate:sc_b5427b74a8857511
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_sector_rotation_delta:e6a23eda638945f5
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T01:21:15.095671+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel