Create
Query
event_store.db
—
signals
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 sig_6d6260bea741 in signals
id
sig_6d6260bea741
Primary key.
TEXT
event_id
475845
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/trump-says-he-expects-resume-bombing-iran-heres-what-means-oil-prices","as_of":"2026-04-21T21:31:18.735453+00:00","canonical_url":"https://www.fool.com/investing/2026/04/21/trump-says-he-expects-to-resume-bombing-iran-heres/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/trump-says-he-expects-resume-bombing-iran-heres-what-means-oil-prices","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_129e01ab1d2a8ce3","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/21/trump-says-he-expects-to-resume-bombing-iran-heres/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:32:01.588384+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe ceasefire between the U.S. and Iran ends this week.","fetched_title":"Trump Says He Expects to Resume Bombing Iran. Here's What That Means for Oil Prices. | Nasdaq","final_url":"https://www.nasdaq.com/articles/trump-says-he-expects-resume-bombing-iran-heres-what-means-oil-prices","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/trump-says-he-expects-resume-bombing-iran-heres-what-means-oil-prices","source_event_id":"evt_0f7c4c2243ac","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ea1c60a3eb25c01b","kind":"unusual_volume","published_at":"2026-04-21T21:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["this week","two-week ceasefire","next three years","second half of this year","2026"],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"person","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"commodity","name":"Brent oil","relevance":"medium","symbol":"Brent","type":"commodity benchmark"},{"asset_class":"commodity","name":"WTI","relevance":"medium","symbol":"WTI","type":"commodity benchmark"},{"asset_class":"equity","name":"ConocoPhillips","relevance":"medium","symbol":"COP","type":"company"},{"asset_class":"equity","name":"Occidental Petroleum","relevance":"medium","symbol":"OXY","type":"company"}],"event_type":"geopolitical_risk","information_gaps":["This signal type is 'discovery_unusual_volume_delta', but the provided text contains no ticker-specific trading volume ratio, baseline volume, or confirmation of unusual volume.","The article discusses oil price moves and stock impacts, but it does not provide any explicit volume-delta metrics tied to a specific ticker.","The catalyst hypothesis is inferred from the article\u2019s narrative (ceasefire expiration and bombing risk), not from any explicit volume/market microstructure data in the provided text."],"key_facts":["The article states the U.S.-Iran ceasefire ends this week.","The article says Trump plans to resume bombing Iran if there is no peace deal by the ceasefire expiration.","The article claims oil prices were rising due to concerns peace talks could collapse.","The article says Brent rose from below $95/barrel to nearly $100 and settled around $97.","The article says WTI rose from the high $80s to the low $90s and topped out just below $95 at one point.","The article states that if war resumes, the Strait of Hormuz would remain effectively closed longer.","The article claims the Strait closure impacts 20% of global oil and LNG supplies.","The article says emergency stockpiles and bypass pipelines can\u2019t fully offset a long-term Strait closure.","The article says renewed fighting could risk additional chokepoint closures such as Bab el-Mandeb, which would nullify the impact of Saudi Arabia\u2019s expanded East-West bypass pipeline.","The article says bombing Iran could lead to retaliation against additional energy infrastructure in the Persian Gulf.","The article states Iran has already damaged some LNG facilities in Qatar, knocking out 17% of capacity for at least the next three years.","The article says the U.S. could attack Iranian oil infrastructure such as Kharg Island.","The article claims damage to these facilities could take years to repair.","The article states oil prices could eclipse a prior war-fueled peak of $119/barrel if the war resumes.","The article says ConocoPhillips (COP) expected an additional $1 billion of free cash flow this year from cost-saving initiatives and produced $7.3 billion last year when Brent averaged $69 and WTI was just below $65.","The article says ConocoPhillips may not fully capitalize on higher prices due to war impact on its Qatar LNG investments, including inability to export LNG due to Strait closure and potential delays to two LNG trains under construction.","The article says Occidental (OXY) expected over $1.2 billion of additional free cash flow this year from cost-savings initiatives and that it may not fully capitalize on higher prices due to war impact on operations in Oman and the UAE."],"numeric_claims":[{"label":"Brent price move (approx.)","value":"below $95 -> nearly $100; settled around $97"},{"label":"WTI price move (approx.)","value":"high $80s -> low $90s; topped just below $95"},{"label":"Strait of Hormuz impact","value":"20% of global oil and LNG supplies"},{"label":"Qatar LNG capacity knocked out","value":"17% for at least the next three years"},{"label":"Prior war-fueled oil peak","value":"$119/barrel"},{"label":"ConocoPhillips additional free cash flow (expected)","value":"$1 billion this year"},{"label":"ConocoPhillips last year free cash flow","value":"$7.3 billion"},{"label":"Brent average used for COP example","value":"$69/barrel"},{"label":"WTI level used for COP example","value":"just below $65"},{"label":"ConocoPhillips LNG train timing (expected)","value":"first one in second half of this year"},{"label":"Occidental additional free cash flow (expected)","value":"over $1.2 billion this year"}],"primary_claim":"If the U.S. resumes bombing Iran after the ceasefire expires without a peace deal, oil prices would likely rise sharply and remain elevated longer.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The article says the U.S.-Iran ceasefire ends this week and Trump expects to resume bombing Iran if no peace deal is reached, which the piece argues would likely push oil prices higher. It also notes that higher prices may not benefit all oil stocks equally, citing risks to Middle East LNG and energy infrastructure.","topics":["U.S.-Iran ceasefire","Trump statements","oil price outlook","Strait of Hormuz","energy infrastructure risk","LNG capacity disruption","oil stock impact"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe ceasefire between the U.S. and Iran ends this week.","tickers":[],"title":"Trump Says He Expects to Resume Bombing Iran. Here's What That Means for Oil Prices.","url":"https://www.fool.com/investing/2026/04/21/trump-says-he-expects-to-resume-bombing-iran-heres/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_0f7c4c2243ac"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:e3b9448223b95b0a
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-21T21:31:18.735453+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel