SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-19T18:44:42.562027+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:9d1f5dd5bb165e3a","evidence_event_ids":["evt_c73c45cee559"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/crypto-markets-fear-index-flashing-red-heres-what-smart-investors-are-doing-about-it","as_of":"2026-04-19T18:44:42.562027+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/the-crypto-markets-fear-index-is-flashing-red-here/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/crypto-markets-fear-index-flashing-red-heres-what-smart-investors-are-doing-about-it","article_chars":4734,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fbe489da4bea37b6","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/the-crypto-markets-fear-index-is-flashing-red-here/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T19:14:41.872057+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsSentiment about crypto is very poor right now.","fetched_title":"The Crypto Market's Fear Index Is Flashing Red. Here's What Smart Investors Are Doing About It. | Nasdaq","final_url":"https://www.nasdaq.com/articles/crypto-markets-fear-index-flashing-red-heres-what-smart-investors-are-doing-about-it","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/crypto-markets-fear-index-flashing-red-heres-what-smart-investors-are-doing-about-it","source_event_id":"evt_c73c45cee559","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e6501c3b70046082","kind":"unusual_volume","published_at":"2026-04-19T18:08:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["mid-April","April 10","April 6","two months ago","April 19, 2026","April 15, 2005","December 17, 2004"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Solana","relevance":"medium","symbol":"SOL","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"XRP","relevance":"medium","symbol":"XRP","type":"crypto_asset"},{"asset_class":"etf","name":"U.S. spot Bitcoin ETFs","relevance":"high","symbol":"","type":"financial_product"}],"event_type":"other","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no ticker-specific unusual volume ratio vs average, no baseline volume, and no direction (e.g., above/below average volume).","No explicit confirmation is provided that any unusual volume event occurred; the article focuses on sentiment (Fear & Greed Index) and ETF inflows rather than trading volume deltas.","No catalyst is explicitly tied to an unusual volume spike; the closest discussed catalysts are macro/geopolitical uncertainty (Strait of Hormuz/oil; Iran conflict) and continued institutional ETF inflows."],"key_facts":["Crypto Fear & Greed Index is at 45 in mid-April (between 0=maximum fear and 100=maximum greed).","The index was at an all-time low of 5 about two months earlier when Bitcoin briefly cratered below $61,000.","The article states U.S. spot Bitcoin ETFs attracted $257 million in inflows on April 10.","The article states U.S. spot Bitcoin ETFs marked $471 million in inflows on April 6.","The article mentions a Strait of Hormuz crisis pushing oil past $100 a barrel and threatening a global energy crisis and recession.","The article mentions a U.S. president threatened to destroy every bridge and power plant in Iran on April 6."],"numeric_claims":[{"label":"Fear & Greed Index (mid-April)","value":"45"},{"label":"Fear & Greed Index (all-time low)","value":"5"},{"label":"Bitcoin price level mentioned","value":"below $61,000"},{"label":"Bitcoin ETF inflows (April 10)","value":"$257 million"},{"label":"Bitcoin ETF inflows (April 6)","value":"$471 million"},{"label":"Oil price mentioned","value":"past $100 a barrel"}],"primary_claim":"Crypto Fear & Greed Index is at 45 in mid-April (fear zone) and U.S. spot Bitcoin ETFs reportedly saw $257M inflows on April 10 and $471M inflows on April 6 amid rising uncertainty.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues crypto sentiment is in a fear zone (Crypto Fear & Greed Index at 45 in mid-April, previously 5 at an all-time low) and claims institutional flows into U.S. spot Bitcoin ETFs continue despite uncertainty. It does not provide any specific unusual trading volume ratio data for a ticker.","topics":["crypto sentiment","fear and greed index","institutional flows","Bitcoin ETFs","geopolitical risk (Iran/Strait of Hormuz)","dollar-cost averaging"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSentiment about crypto is very poor right now.","tickers":[],"title":"The Crypto Market's Fear Index Is Flashing Red. Here's What Smart Investors Are Doing About It.","url":"https://www.fool.com/investing/2026/04/19/the-crypto-markets-fear-index-is-flashing-red-here/"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 332724 in events