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 26732 in events
seq
Primary key.
INTEGER
id
evt_9f8f35ba9368
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-12T00:43:29.154099+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-12T00:38:28.481951+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:4cb198858f206312","evidence_event_ids":["evt_101daeccf01a"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/iran-war-ceasefire-3-stocks-buy-now","as_of":"2026-04-12T00:38:28.481951+00:00","canonical_url":"https://www.fool.com/investing/2026/04/11/iran-war-ceasefire-3-stocks-to-buy-now/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/iran-war-ceasefire-3-stocks-buy-now","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_928ec174ae5a360e","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/11/iran-war-ceasefire-3-stocks-to-buy-now/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T00:43:29.154063+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe ceasefire between the U.S. and Iran has been very fragile, as of this writing.","fetched_title":"Iran War Ceasefire: 3 Stocks to Buy Now | Nasdaq","final_url":"https://www.nasdaq.com/articles/iran-war-ceasefire-3-stocks-buy-now","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/iran-war-ceasefire-3-stocks-buy-now","source_event_id":"evt_101daeccf01a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e6433d2486d14ddf","kind":"unusual_volume","published_at":"2026-04-12T00:09:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 9"],"entities":[{"asset_class":"equity","name":"Delta Air Lines","relevance":"high","symbol":"DAL","type":"company"},{"asset_class":"equity","name":"Microsoft","relevance":"high","symbol":"MSFT","type":"company"},{"asset_class":"equity","name":"ExxonMobil","relevance":"high","symbol":"XOM","type":"company"},{"asset_class":"other","name":"U.S.","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["This signal type is discovery_unusual_volume_delta, but the provided text contains no volume data (no baseline volume, no current volume, and no volume ratio vs average) for any ticker.","The article is framed as investment recommendations; it does not explicitly confirm any unusual trading volume with news or provide an explanation tied to volume spikes.","No explicit catalyst is stated in terms of unusual volume; the only catalyst discussed is the ceasefire announcement and related expectations for oil prices and risk sentiment."],"key_facts":["The article states the U.S. and Iran have come to a two-week ceasefire announced around April 9.","The article characterizes the ceasefire as fragile, with \u201cseveral parties accusing one another of violating the agreement.\u201d","Delta Air Lines (DAL) is presented as potentially benefiting from lower jet fuel prices if the ceasefire holds and a broader agreement is reached.","The article says Delta\u2019s CEO Ed Bastian expected fuel costs to be $2 billion higher in the current quarter due to the oil surge.","The article states Delta is forecasting all-in fuel costs of $4.30 per gallon in the second quarter.","The article says Delta beat first-quarter earnings and revenue estimates and is still guiding for $1 billion of pre-tax earnings in the current quarter.","The article says Microsoft (MSFT) closed out its worst quarter since 2008 and that the stock is down 20% this year.","The article attributes Microsoft\u2019s risk-off pressure to concerns about potential attacks on Middle East data centers and higher costs from supply chain disruptions tied to the Strait of Hormuz closure.","The article states Microsoft trades at about 23.5 times trailing earnings and that earnings are expected to keep growing.","The article recommends ExxonMobil (XOM) as oil exposure in case tensions re-escalate.","The article says Exxon\u2019s stock dropped following the ceasefire announcement amid lower oil futures, but is still up 26% this year.","The article states Exxon carries a dividend yielding 2.67%.","The article states Exxon has lowered expenses and improved its balance sheet by lowering total debt."],"numeric_claims":[{"label":"ceasefire duration","value":"two-week"},{"label":"as-of date mentioned","value":"April 9"},{"label":"Delta expected fuel cost impact","value":"$2 billion higher in the current quarter"},{"label":"Delta forecast all-in fuel costs (Q2)","value":"$4.30 per gallon"},{"label":"Delta guidance (pre-tax earnings)","value":"$1 billion in the current quarter"},{"label":"Microsoft worst quarter since","value":"2008"},{"label":"Microsoft stock down this year","value":"20%"},{"label":"Microsoft valuation multiple","value":"~23.5x trailing earnings"},{"label":"Exxon stock up this year","value":"26%"},{"label":"Exxon dividend yield","value":"2.67%"}],"primary_claim":"As of April 9, the U.S. and Iran have announced a two-week ceasefire, described as fragile, and the article recommends buying Delta (DAL), Microsoft (MSFT), and ExxonMobil (XOM) in that context.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"The article discusses a fragile two-week U.S.-Iran ceasefire announced around April 9 and argues that three stocks\u2014Delta Air Lines, Microsoft, and ExxonMobil\u2014could benefit depending on whether tensions ease or re-escalate.","topics":["U.S.-Iran ceasefire","Middle East tensions","airline fuel costs","Microsoft risk-off sentiment","oil exposure and dividends","market reaction to ceasefire announcement"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe ceasefire between the U.S. and Iran has been very fragile, as of this writing.","tickers":[],"title":"Iran War Ceasefire: 3 Stocks to Buy Now","url":"https://www.fool.com/investing/2026/04/11/iran-war-ceasefire-3-stocks-to-buy-now/"}}
TEXT NOT NULL
source_ref
candidate:sc_928ec174ae5a360e
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:4cb198858f206312
TEXT
episode_id
NULL
TEXT
created_at
2026-04-12T00:43:29.154154+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel