Create
Query
event_store.db
—
events
actions
agent_runs
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
intel_memory
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 90190 in events
seq
Primary key.
INTEGER
id
evt_0ef374b0b446
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-17T21:46:37.732181+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-17T03:42:58.209772+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:d17e8575b8b9cab5","evidence_event_ids":["evt_59ac095fb5ff"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/three-etfs-will-be-impacted-closure-strait-hormuz-should-you-buy","as_of":"2026-04-17T03:42:58.209772+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/three-etfs-that-will-be-impacted-by-the-closure-of/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/three-etfs-will-be-impacted-closure-strait-hormuz-should-you-buy","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4009c52611e9996f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/three-etfs-that-will-be-impacted-by-the-closure-of/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T21:46:37.732155+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsVanguard Energy ETF will benefit, at least temporarily, from high oil prices.","fetched_title":"Three ETFs that will be impacted by the closure of the Strait of Hormuz. Should you buy? | Nasdaq","final_url":"https://www.nasdaq.com/articles/three-etfs-will-be-impacted-closure-strait-hormuz-should-you-buy","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/three-etfs-will-be-impacted-closure-strait-hormuz-should-you-buy","source_event_id":"evt_59ac095fb5ff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba3645d93208a697","kind":"unusual_volume","published_at":"2026-04-17T02:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2026","March"],"entities":[{"asset_class":"equity_etf","name":"Vanguard Energy ETF","relevance":"high","symbol":"VDE","type":"etf"},{"asset_class":"equity_etf","name":"Vanguard Consumer Staples ETF","relevance":"high","symbol":"VDC","type":"etf"},{"asset_class":"equity_etf","name":"Vanguard Consumer Discretionary ETF","relevance":"high","symbol":"VCR","type":"etf"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["No unusual trading volume ratio vs average is provided in the text (baseline volume, volume ratio, and direction are not stated).","The signal type mentions unusual volume delta, but the article content provided does not confirm any volume spike or quantify it.","The article does not provide a specific, data-backed catalyst timing beyond the general expectation tied to the Strait of Hormuz closure.","No explicit confirmation from independent news sources is included in the provided text; it is presented as an outlook/opinion piece."],"key_facts":["The article states that oil and natural gas producers are the \u201cobvious winner\u201d from the Middle East conflict/Strait of Hormuz closure.","It identifies Vanguard Energy ETF (NYSEMKT: VDE) as the energy beneficiary and says it has an expense ratio of 0.09%, yield roughly 2.2%, and about $13 billion in assets.","The article claims that the shutdown has limited supply of both oil and oil products, and that refining companies are seeing strong results despite high oil costs.","It states that Vanguard Energy ETF has \u201calready moved materially higher so far in 2026.\u201d","It identifies Vanguard Consumer Staples ETF (NYSEMKT: VDC) as likely to suffer due to reduced fertilizer availability and higher shipping/production costs; it has expense ratio 0.09%, yield roughly 2.1%, and about $9 billion in assets.","It states Vanguard Consumer Staples ETF has been trending lower since March and that margins could contract leading to weak earnings.","It identifies Vanguard Consumer Discretionary ETF (NYSEMKT: VCR) as likely to pose the most risk if the conflict pushes the global economy into recession; it has expense ratio 0.09%, yield roughly 0.8%, and around $6 billion in assets.","The article\u2019s catalyst framing is the geopolitical conflict/Strait of Hormuz closure affecting global energy markets and downstream costs."],"numeric_claims":[{"label":"VDE expense ratio","value":"0.09%"},{"label":"VDE yield (roughly)","value":"2.2%"},{"label":"VDE assets (approx.)","value":"$13 billion"},{"label":"VDE integrated energy share (approx.)","value":"39% of assets"},{"label":"VDE oil & gas exploration share (approx.)","value":"nearly 23% of assets"},{"label":"VDC expense ratio","value":"0.09%"},{"label":"VDC yield (roughly)","value":"2.1%"},{"label":"VDC assets (approx.)","value":"$9 billion"},{"label":"VCR expense ratio","value":"0.09%"},{"label":"VCR yield (roughly)","value":"0.8%"},{"label":"VCR assets (approx.)","value":"around $6 billion"}],"primary_claim":"Closure of the Strait of Hormuz is expected to drive high oil prices that benefit Vanguard Energy ETF (VDE) at least temporarily, while hurting VDC and potentially VCR.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article argues that the closure of the Strait of Hormuz would likely raise oil prices, benefiting Vanguard Energy ETF (VDE) in the near term, while pressuring Vanguard Consumer Staples (VDC) and Vanguard Consumer Discretionary (VCR) via higher costs and recession risk.","topics":["Strait of Hormuz closure","oil prices","energy sector beneficiaries","consumer staples margins","consumer discretionary recession risk","ETF performance outlook"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsVanguard Energy ETF will benefit, at least temporarily, from high oil prices.","tickers":[],"title":"Three ETFs that will be impacted by the closure of the Strait of Hormuz. Should you buy?","url":"https://www.fool.com/investing/2026/04/16/three-etfs-that-will-be-impacted-by-the-closure-of/"}}
TEXT NOT NULL
source_ref
candidate:sc_4009c52611e9996f
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:d17e8575b8b9cab5
TEXT
episode_id
NULL
TEXT
created_at
2026-04-17T21:46:37.732217+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel