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_c3ddbe63cb23 in signals
id
sig_c3ddbe63cb23
Primary key.
TEXT
event_id
326840
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-vanguard-sp-500-etf-stock-market-fresh-record-high-answer-might-surprise","as_of":"2026-04-19T17:15:33.112665+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/buy-vanguard-sp-500-etf-stock-market-record-high/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-vanguard-sp-500-etf-stock-market-fresh-record-high-answer-might-surprise","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e9f00d15dfbfa21c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/buy-vanguard-sp-500-etf-stock-market-record-high/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T17:45:53.210572+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe S&P 500 was recently down by as much as 9% from its peak because of the war between the U.S. and Iran, but it rocketed to a new record high on Wednesday, April 15.","fetched_title":"Should You Buy the Vanguard S&P 500 ETF With the Stock Market At a Fresh Record High? The Answer Might Surprise You. | Nasdaq","final_url":"https://www.nasdaq.com/articles/should-you-buy-vanguard-sp-500-etf-stock-market-fresh-record-high-answer-might-surprise","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/should-you-buy-vanguard-sp-500-etf-stock-market-fresh-record-high-answer-might-surprise","source_event_id":"evt_928ca51377ee","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f096b52d04e47b75","kind":"unusual_volume","published_at":"2026-04-19T16:04:53+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 15","April 8","this weekend","26 years","1957","2000","2008","2020","2022"],"entities":[{"asset_class":"ETF","name":"Vanguard S&P 500 ETF","relevance":"high","symbol":"VOO","type":"asset"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"ETF","name":"Vanguard S&P 500 ETF (NYSEMKT)","relevance":"medium","symbol":"VOO","type":"listing"},{"asset_class":"geopolitical actor","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"geopolitical actor","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"geographic chokepoint","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["No explicit 'unusual volume delta' metrics are provided in the supplied text (baseline volume, current volume, or volume ratio are not stated).","The signal type suggests unusual volume, but the article content provided focuses on index level/valuation and geopolitical developments rather than trading-volume anomalies.","The most likely catalyst hypothesis for unusual volume cannot be grounded from the provided excerpt; only a general catalyst (U.S.-Iran ceasefire/renewed Strait of Hormuz restrictions) is discussed for market moves."],"key_facts":["The S&P 500 reached a fresh record high on Wednesday, April 15.","The article attributes a prior ~9% peak-to-trough decline to the U.S.-Iran war.","The article says investor sentiment improved after a U.S.-Iran ceasefire agreement on April 8.","The article claims the Strait of Hormuz handles 25% of the world's seaborne oil supply per day.","The article says Iran restricted commercial vessel transits again over the weekend, pending further negotiations.","The article states the Vanguard S&P 500 ETF (VOO) tracks the S&P 500 by holding the same stocks with similar weightings.","The article states VOO\u2019s expense ratio is 0.03%."],"numeric_claims":[{"label":"peak-to-trough decline","value":"~9%"},{"label":"Strait of Hormuz share of seaborne oil supply","value":"25% per day"},{"label":"VOO expense ratio","value":"0.03%"},{"label":"S&P 500 forward earnings multiple","value":">20x (forward earnings; article cut off after 'according t' )"}],"primary_claim":"The S&P 500 reached a new record high on Wednesday, April 15, following a ceasefire agreement on April 8, but renewed Iran restrictions on Strait of Hormuz transit create uncertainty about whether the highs will hold.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article says the S&P 500 hit a fresh record high on April 15 after a ceasefire-related reopening of the Strait of Hormuz, but warns the rally may be unstable due to renewed Iran restrictions on commercial vessels. It discusses buying the Vanguard S&P 500 ETF (VOO) in this context, but does not provide any explicit unusual trading-volume ratio data.","topics":["S&P 500 record high","U.S.-Iran ceasefire and tensions","Strait of Hormuz shipping restrictions","Oil price risk","ETF investing (VOO)","Market valuation/earnings multiple (mentioned partially)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe S&P 500 was recently down by as much as 9% from its peak because of the war between the U.S. and Iran, but it rocketed to a new record high on Wednesday, April 15.","tickers":[],"title":"Should You Buy the Vanguard S&P 500 ETF With the Stock Market At a Fresh Record High? The Answer Might Surprise You.","url":"https://www.fool.com/investing/2026/04/19/buy-vanguard-sp-500-etf-stock-market-record-high/"}
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_928ca51377ee"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:324ce0a251d71b89
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-19T17:15:33.112665+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel