Create
Query
event_store.db
—
signals
actions
approvals
artifacts
commitments
constraints
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 sig_9226a5ed7999 in signals
id
sig_9226a5ed7999
Primary key.
TEXT
event_id
5693
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/worried-about-stock-market-crash-buy-low-risk-high-yield-index-fund","as_of":"2026-04-08T09:32:58.864102+00:00","canonical_url":"https://www.fool.com/investing/2026/04/08/market-crash-buy-low-risk-high-yield-index-fund/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/worried-about-stock-market-crash-buy-low-risk-high-yield-index-fund","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8fff86da238d925d","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/08/market-crash-buy-low-risk-high-yield-index-fund/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T09:35:06.572503+00:00","extraction_method":"heuristic","fetched_description":"Key PointsThe S&P 500 is down 5% from its high, but the index could fall further if the Iran conflict keeps oil prices elevated for a prolonged period.","fetched_title":"Worried About a Stock Market Crash? Buy This Low-Risk, High-Yield Index Fund. | Nasdaq","final_url":"https://www.nasdaq.com/articles/worried-about-stock-market-crash-buy-low-risk-high-yield-index-fund","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/worried-about-stock-market-crash-buy-low-risk-high-yield-index-fund","source_event_id":"evt_938625a7771c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ff9bedb0dbca97a8","kind":"unusual_volume","published_at":"2026-04-08T08:28:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 08, 2026","March (year not specified)","2020 (inception)","December 17, 2004 (example)","April 15, 2005 (example)"],"entities":[{"asset_class":"etf","name":"iShares 0-3 Month Treasury Bond ETF","relevance":"high","symbol":"SGOV","type":"etf"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"financials","name":"JPMorgan Chase","relevance":"medium","symbol":"","type":"company"},{"asset_class":"financials","name":"Goldman Sachs","relevance":"medium","symbol":"","type":"company"},{"asset_class":"macro","name":"Federal Reserve","relevance":"medium","symbol":"","type":"institution"}],"event_type":"price_action","information_gaps":["No explicit unusual volume delta data is provided (no baseline volume, no current volume, no volume ratio, and no direction).","No specific ticker is tied to an unusual volume event; the article content is primarily macro/market commentary and an ETF recommendation.","The catalyst hypothesis for the volume signal cannot be determined from the provided text because the text does not describe volume changes."],"key_facts":["The S&P 500 is described as being down 5% from its high.","The article states the S&P 500 could fall further if the Iran conflict keeps oil prices elevated for a prolonged period.","It cites JPMorgan Chase analysts warning the S&P 500 could drop as much as 15% if oil prices stay above $90 per barrel for an extended period.","It cites Goldman Sachs warning the index could fall more than 20% in a severe scenario.","The recommended fund is the iShares 0-3 Month Treasury Bond ETF (NYSE: SGOV).","The article says SGOV holds T-bills maturing in no more than three months.","It claims SGOV is far less sensitive to interest rates than longer-maturity bond funds.","The article states SGOV has never fallen more than 0.7% since its inception in 2020.","It states SGOV currently pays 3.55% annually (SEC yield) split into monthly distributions.","The article says SGOV\u2019s yield would decrease if the Federal Reserve cut interest rates and increase if policymakers raised interest rates."],"numeric_claims":[{"label":"S&P 500 drawdown from high","value":"5% down"},{"label":"Oil price threshold (JPMorgan scenario)","value":"$90 per barrel"},{"label":"Potential S&P 500 drop (JPMorgan scenario)","value":"up to 15%"},{"label":"Potential S&P 500 drop (Goldman severe scenario)","value":"more than 20%"},{"label":"SGOV SEC yield","value":"3.55% annually"},{"label":"SGOV max historical drawdown since inception","value":"0.7%"}],"primary_claim":"SGOV is presented as a low-risk, stable fund for investors concerned about a potential further S&P 500 decline tied to elevated oil prices from the Iran conflict.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues that if the Iran conflict keeps oil prices elevated, the S&P 500 could fall further, and it recommends a low-volatility alternative: the iShares 0-3 Month Treasury Bond ETF (SGOV). It does not provide any explicit \u201cunusual volume delta\u201d metrics for a specific ticker.","topics":["market crash concerns","S&P 500 downside scenario","Iran conflict and oil prices","Treasury bills / T-bills","short-duration ETF stability","dividend yield","interest-rate sensitivity"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe S&P 500 is down 5% from its high, but the index could fall further if the Iran conflict keeps oil prices elevated for a prolonged period.","tickers":[],"title":"Worried About a Stock Market Crash? Buy This Low-Risk, High-Yield Index Fund.","url":"https://www.fool.com/investing/2026/04/08/market-crash-buy-low-risk-high-yield-index-fund/"}
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_938625a7771c"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:67ba399021b0ab27
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-08T09:32:58.864102+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel