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 10030 in events
seq
Primary key.
INTEGER
id
evt_cf14e8469b16
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-09T23:27:51.288837+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-08T22:43:46.053448+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:6d96b966a199f6a0","evidence_event_ids":["evt_145d03873c31"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-iran-ceasefire","as_of":"2026-04-08T22:43:46.053448+00:00","canonical_url":"https://www.fool.com/coverage/stock-market-today/2026/04/08/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-on-iran-ceasefire/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-iran-ceasefire","article_chars":4284,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f440e01cc3114254","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/stock-market-today/2026/04/08/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-on-iran-ceasefire/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:27:51.288783+00:00","extraction_method":"heuristic","fetched_description":"The S&P 500 (SNPINDEX:^GSPC) climbed 2.51% to 6,782.81, the Nasdaq Composite (NASDAQINDEX:^IXIC) advanced 2.80% to 22,634.99, and the Dow Jones Industrial Average (DJINDICES:^DJI) jumped 2.85% to 47,909.92 as stocks rebounded on news of an U.S.\u2013Iran ceasefire.","fetched_title":"Stock Market Today, April 8: Oil Prices Plunge and Markets Rally on Iran Ceasefire | Nasdaq","final_url":"https://www.nasdaq.com/articles/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-iran-ceasefire","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-iran-ceasefire","source_event_id":"evt_145d03873c31","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0ebfdf4fa61f36b2","kind":"unusual_volume","published_at":"2026-04-08T21:28:40+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 8, 2026"],"entities":[{"asset_class":"equity_index","name":"S&P 500 Index","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq Composite","relevance":"high","symbol":"^IXIC","type":"index"},{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"high","symbol":"^DJI","type":"index"},{"asset_class":"stock","name":"Meta Platforms","relevance":"medium","symbol":"META","type":"equity"},{"asset_class":"stock","name":"ASML","relevance":"medium","symbol":"ASML","type":"equity"},{"asset_class":"stock","name":"Exxon Mobil","relevance":"medium","symbol":"XOM","type":"equity"},{"asset_class":"stock","name":"Chevron","relevance":"medium","symbol":"CVX","type":"equity"},{"asset_class":"stock","name":"Delta Air Lines","relevance":"low","symbol":"DAL","type":"equity"},{"asset_class":"stock","name":"United Airlines","relevance":"low","symbol":"UAL","type":"equity"}],"event_type":"geopolitical_risk","information_gaps":["This signal type is 'discovery_unusual_volume_delta', but the provided text contains no per-ticker volume ratio vs average, no baseline volume, and no confirmation of unusual trading volume.","No specific ticker is identified for unusual volume; the article discusses index moves and selected stock price moves only.","The article does not provide any explicit catalyst hypothesis tied to unusual volume; it only provides macro/geopolitical and sector/stock-specific drivers for price action."],"key_facts":["S&P 500 climbed 2.51% to 6,782.81.","Nasdaq Composite advanced 2.80% to 22,634.99.","Dow Jones Industrial Average jumped 2.85% to 47,909.92.","The rally was described as rebounding on news of a U.S.\u2013Iran ceasefire.","WTI Crude fell 15% to about $96 per barrel.","The article states parties agreed to reopen the Strait of Hormuz for the first time since the war began over five weeks prior.","The article says falling oil prices eased energy-driven inflation fears and markets reassessed the possibility of a rate cut this year.","The article characterizes the ceasefire as only the start of negotiations and notes normalization of energy disruptions will take time."],"numeric_claims":[{"label":"S&P 500 move (%)","value":"+2.51%"},{"label":"S&P 500 level","value":"6,782.81"},{"label":"Nasdaq move (%)","value":"+2.80%"},{"label":"Nasdaq level","value":"22,634.99"},{"label":"Dow move (%)","value":"+2.85%"},{"label":"Dow level","value":"47,909.92"},{"label":"Meta Platforms move (%)","value":"+6.5%"},{"label":"Meta Platforms price","value":"$612.42"},{"label":"WTI move (%)","value":"-15%"},{"label":"WTI price","value":"$96 per barrel"}],"primary_claim":"U.S. equities rallied on April 8, 2026 as markets rebounded on news of a U.S.\u2013Iran ceasefire, while WTI crude fell 15% to about $96/bbl.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"On April 8, 2026, major U.S. equity indexes rose sharply after news of a U.S.\u2013Iran ceasefire, alongside a steep drop in WTI crude. The article attributes the rally to easing oil-driven inflation fears and renewed expectations around potential rate cuts.","topics":["U.S.\u2013Iran ceasefire","oil prices (WTI)","equity market rally","rate cut expectations","inflation fears","Strait of Hormuz reopening"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"The S&P 500 (SNPINDEX:^GSPC) climbed 2.51% to 6,782.81, the Nasdaq Composite (NASDAQINDEX:^IXIC) advanced 2.80% to 22,634.99, and the Dow Jones Industrial Average (DJINDICES:^DJI) jumped 2.85% to 47,909.92 as stocks rebounded on news of an U.S.\u2013Iran ceasefire.","tickers":[],"title":"Stock Market Today, April 8: Oil Prices Plunge and Markets Rally on Iran Ceasefire","url":"https://www.fool.com/coverage/stock-market-today/2026/04/08/stock-market-today-april-8-oil-prices-plunge-and-markets-rally-on-iran-ceasefire/"}}
TEXT NOT NULL
source_ref
candidate:sc_f440e01cc3114254
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:6d96b966a199f6a0
TEXT
episode_id
NULL
TEXT
created_at
2026-04-09T23:27:51.288896+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel