SQLite Web: event_store.db

Update row sig_d9cda440f4bd in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/1-cryptocurrency-buy-while-its-under-80000","as_of":"2026-04-19T09:46:35.333003+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/1-cryptocurrency-to-buy-while-its-under-80000/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-cryptocurrency-buy-while-its-under-80000","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9616eac047df1c3e","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/1-cryptocurrency-to-buy-while-its-under-80000/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T10:15:59.757434+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsInvestor pessimism toward the digital asset market has driven this top cryptocurrency 40% off its record high from last October.","fetched_title":"1 Cryptocurrency to Buy While It's Under $80,000 | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-cryptocurrency-buy-while-its-under-80000","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-cryptocurrency-buy-while-its-under-80000","source_event_id":"evt_b66a708caba2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"326ea0000a1a820a","kind":"unusual_volume","published_at":"2026-04-19T08:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["October (year not specified)","April 17"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"currency","name":"U.S. dollar","relevance":"medium","symbol":"","type":"fiat currency"},{"asset_class":"index","name":"S&P 500","relevance":"low","symbol":"^GSPC","type":"equity index"}],"event_type":"price_action","information_gaps":["No explicit unusual trading-volume delta (volume ratio vs average) is provided in the text.","No ticker-specific volume metrics are stated beyond the mention of Bitcoin (BTC).","The article does not confirm the volume anomaly with any news event; it only provides a price/market narrative (investor pessimism).","A concrete catalyst hypothesis for unusual volume is not explicitly stated; only a general catalyst narrative (investor pessimism and fiat-collapse/store-of-value thesis) is provided."],"key_facts":["The article states Bitcoin is trading under $80,000.","The article states Bitcoin is about 40% off its record high from last October.","The article attributes the decline to investor pessimism toward the digital asset market.","The article states total crypto market valuation peaked at $4.4 trillion in October and was $2.6 trillion as of April 17 (per the article).","The article states the S&P 500 climbed 5% during the same period (per the article).","The article states Bitcoin has a hard supply cap of 21 million units (per the article)."],"numeric_claims":[{"label":"Bitcoin drawdown from record high","value":"40% off its record high (from last October)"},{"label":"Bitcoin current price threshold","value":"under $80,000"},{"label":"Crypto market valuation peak","value":"$4.4 trillion (October, per article)"},{"label":"Crypto market valuation current","value":"$2.6 trillion (as of April 17, per article)"},{"label":"S&P 500 change","value":"+5% (same time period, per article)"},{"label":"Bitcoin supply cap","value":"21 million units"}],"primary_claim":"Bitcoin (BTC) is trading under $80,000 and is about 40% off its record high from last October due to investor pessimism toward cryptocurrencies.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues that investor pessimism has pushed Bitcoin about 40% below its October record high, and claims it is trading under $80,000, making it a buying opportunity. It does not provide any explicit unusual trading-volume ratio versus average in the text.","topics":["Bitcoin","cryptocurrency market drawdown","investor pessimism","fiat currency risk","store of value narrative","price under $80,000"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsInvestor pessimism toward the digital asset market has driven this top cryptocurrency 40% off its record high from last October.","tickers":[],"title":"1 Cryptocurrency to Buy While It's Under $80,000","url":"https://www.fool.com/investing/2026/04/19/1-cryptocurrency-to-buy-while-its-under-80000/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

Cancel