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-20T13:10:00.946643+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:986351a6289041d3","evidence_event_ids":["evt_f5f2235d570f"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/prediction-cryptocurrency-xrp-will-be-worth-less-1-5-years","as_of":"2026-04-20T13:10:00.946643+00:00","canonical_url":"https://www.fool.com/investing/2026/04/20/xrp-price-prediction-why-it-could-fall-below-1/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/prediction-cryptocurrency-xrp-will-be-worth-less-1-5-years","article_chars":4177,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fdb489d3813d1cc5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/20/xrp-price-prediction-why-it-could-fall-below-1/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T13:13:20.324014+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsXRP is down more than 60% from its July high.","fetched_title":"Prediction: The Cryptocurrency XRP Will Be Worth Less Than $1 in 5 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/prediction-cryptocurrency-xrp-will-be-worth-less-1-5-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/prediction-cryptocurrency-xrp-will-be-worth-less-1-5-years","source_event_id":"evt_f5f2235d570f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4401bbe93ae8f36d","kind":"unusual_volume","published_at":"2026-04-20T12:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["July","five years from now","December 17, 2004","April 15, 2005","April 20, 2026"],"entities":[{"asset_class":"cryptocurrency","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"equity","name":"Ripple","relevance":"high","symbol":"","type":"company"},{"asset_class":"cryptocurrency","name":"RLUSD","relevance":"high","symbol":"","type":"stablecoin"},{"asset_class":"fund","name":"Canary Capital Spot XRP ETF","relevance":"medium","symbol":"","type":"ETF"}],"event_type":"price_action","information_gaps":["No explicit volume ratio vs average is provided in the text (unusual_volume.baseline_volume and volume_ratio are not available).","The signal type mentions unusual volume delta, but the article text provided does not include any volume statistics or confirmation of unusual trading volume.","The article does not provide a specific, evidence-backed catalyst tied to volume changes; it provides a general catalyst hypothesis (weaker bank demand and RLUSD preference) for price direction rather than volume behavior.","unusual_volume_delta_confirmed_by_news_or_unexplained_not_applicable: The provided text does not discuss volume confirmation or whether any volume spike is unexplained.","catalyst_hypothesis_captured_only_from_text: The most likely catalyst hypothesis stated is that RLUSD reduces demand for XRP as the bridge asset, weakening the bank-adoption thesis."],"key_facts":["The article states XRP is down more than 60% from its July high.","The article says the long-promised demand from banks using XRP for cross-border payments has not materialized.","The article claims Ripple\u2019s stablecoin RLUSD offers a more attractive bridge asset for banks.","The article states the SEC dropped its long-running lawsuit against Ripple.","The article states spot XRP exchange-traded funds (ETFs) launched (seven of them) and that total investment initially surged to $1.6 billion, then returned to around $1 billion.","The article states XRP is around $1.30 and well below $2, which it says XRP traded at before the SEC dropped its suit.","The article predicts XRP will be trading below $1 five years from now."],"numeric_claims":[{"label":"XRP decline from July high","value":"more than 60%"},{"label":"Initial total investment in spot XRP ETFs","value":"$1.6 billion"},{"label":"Total investment in spot XRP ETFs (later)","value":"around $1 billion"},{"label":"XRP price mentioned","value":"around $1.30"},{"label":"XRP price before SEC suit dropped","value":"more than $2"},{"label":"Predicted XRP price in five years","value":"below $1"}],"primary_claim":"XRP is down more than 60% from its July high, and the article predicts XRP will be below $1 in five years due to weaker-than-expected bank demand and RLUSD undercutting XRP as the bridge asset.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article argues XRP has fallen over 60% from its July high and suggests its main bank-adoption demand thesis is weakening because banks may prefer Ripple\u2019s RLUSD stablecoin as a bridge asset. It predicts XRP will trade below $1 five years from now.","topics":["XRP price decline","bank cross-border payments thesis","Ripple stablecoin RLUSD","SEC lawsuit dismissal","spot XRP ETFs","five-year price prediction"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsXRP is down more than 60% from its July high.","tickers":[],"title":"Prediction: The Cryptocurrency XRP Will Be Worth Less Than $1 in 5 Years","url":"https://www.fool.com/investing/2026/04/20/xrp-price-prediction-why-it-could-fall-below-1/"}}

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 438689 in events