Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
attention_candidates
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
intel_narrative_members
intel_narratives
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 475500 in events
seq
Primary key.
INTEGER
id
evt_d8abc0699ec3
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-21T23:10:55.372393+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-21T16:48:38.963204+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:1664d82df46c2a29","evidence_event_ids":["evt_bd75a77d1fa2"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","as_of":"2026-04-21T16:48:38.963204+00:00","canonical_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","article_chars":1566,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_45efe50186edcb4e","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:10:55.372311+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 ProShares Short S&P500 (Symbol: SH) where we have detected an approximate $77.1 million dollar outflow -- that's a 5.9% decrease week over week","fetched_title":"ProShares Short S&P500 Experiences Big Outflow | Nasdaq","final_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow","source_event_id":"evt_bd75a77d1fa2","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"8b4e70071ce05f3b","kind":"sector_rotation","published_at":"2026-04-21T15:07:40+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity_etf","name":"ProShares Short S&P500","relevance":"high","symbol":"SH","type":"ETF"}],"event_type":"price_action","information_gaps":["No sector-level winners/losers are provided in the text.","No macro driver is specified.","No explicit conclusion is given about regime shift vs short-term rebalancing.","The signal type guidance mentions sector rotation, but the article excerpt only reports flows for SH and does not map flows to sectors."],"key_facts":["SH (ProShares Short S&P500) had an approximate $77.1 million outflow (stated as a 5.9% decrease week over week).","Shares outstanding for SH decreased from 95,755,830 to 90,080,830 week over week.","The text also mentions a one-year price performance chart and compares SH\u2019s 52-week low ($13.50) and high ($18.41) to a last trade of $13.59.","The article describes that ETF unit creation/destruction can affect underlying holdings (creation implies underlying purchases; destruction implies underlying sales)."],"numeric_claims":[{"label":"outflow_amount_usd","value":"~$77.1 million"},{"label":"outflow_percent_week_over_week","value":"~5.9% decrease"},{"label":"shares_outstanding_from","value":"95,755,830"},{"label":"shares_outstanding_to","value":"90,080,830"},{"label":"52_week_low_usd","value":"$13.50"},{"label":"52_week_high_usd","value":"$18.41"},{"label":"last_trade_usd","value":"$13.59"}],"primary_claim":"ProShares Short S&P500 (SH) experienced an approximate $77.1 million outflow (about a 5.9% decrease week over week) with shares outstanding falling from 95,755,830 to 90,080,830.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"ProShares Short S&P500 (SH) saw a notable week-over-week outflow in ETF units/shares outstanding, indicating investors reduced exposure to the short S&P 500 position. The provided text does not identify which other sectors/ETFs gained or lost, nor does it specify a macro driver or whether this reflects a regime shift versus short-term rebalancing.","topics":["ETF flows","week-over-week shares outstanding change","ProShares Short S&P500","outflows","units created/destroyed"]},"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 ProShares Short S&P500 (Symbol: SH) where we have detected an approximate $152.6 million dollar outflow -- that's a 12.1% decrease week over wee","tickers":[],"title":"ProShares Short S&P500 Experiences Big Outflow","url":"https://www.nasdaq.com/articles/proshares-short-sp500-experiences-big-outflow"}}
TEXT NOT NULL
source_ref
candidate:sc_45efe50186edcb4e
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_sector_rotation_delta:1664d82df46c2a29
TEXT
episode_id
NULL
TEXT
created_at
2026-04-21T23:10:55.372478+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel