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-12T13:46:53.258496+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:e81cf18b8d3cc2a3","evidence_event_ids":["evt_a8f026f0222a"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-2","as_of":"2026-04-12T13:46:53.258496+00:00","canonical_url":"https://www.fool.com/investing/2026/04/12/where-will-the-cryptocurrency-xrp-be-in-5-years/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-2","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_035ccaa21b9be3aa","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/12/where-will-the-cryptocurrency-xrp-be-in-5-years/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T13:48:24.265447+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsCryptocurrency prices have been falling over the last 12 months, despite an improving regulatory landscape.","fetched_title":"Where Will the Cryptocurrency XRP Be in 5 Years? | Nasdaq","final_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-2","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-2","source_event_id":"evt_a8f026f0222a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c281eb4d65d084a7","kind":"unusual_volume","published_at":"2026-04-12T13:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["last 12 months","December"],"entities":[{"asset_class":"cryptocurrency","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"company","name":"Ripple Labs","relevance":"high","symbol":"","type":"company"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"person","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"regulation","name":"GENIUS Act","relevance":"medium","symbol":"","type":"legislation"},{"asset_class":"regulation","name":"Clarity Act","relevance":"low","symbol":"","type":"legislation"},{"asset_class":"company","name":"Ripple National Trust Bank","relevance":"medium","symbol":"","type":"entity"}],"event_type":"other","information_gaps":["The signal type requested unusual volume delta, but the provided text contains no volume ratio, baseline volume, or any volume-change metrics.","No explicit confirmation is provided that the described price/market moves are tied to a specific volume spike or news event beyond general regulatory and ecosystem developments.","The headline asks a 5-year outlook, but the extracted text focuses on near-term challenges and long-term positioning rather than a quantified 5-year forecast."],"key_facts":["The article states cryptocurrency prices have been falling over the last 12 months despite an improving regulatory landscape.","The article states XRP is down 39% over the last 12 months.","The article states Bitcoin is down 20% over the last 12 months.","The article attributes a perceived regulatory boost to Donald Trump\u2019s presidential election victory and describes a \u201csofter regulatory approach.\u201d","The article mentions legislation including the GENIUS Act, described as designed to integrate stablecoins.","The article states Ripple Labs is working to integrate XRP-related platforms into mainstream finance.","The article states Ripple created a dollar-pegged stablecoin called RippleUSD that shares the same blockchain as XRP.","The article states Ripple Labs spent $4 billion in recent months to purchase financial services companies (brokerages, clearinghouses, fintech software).","The article states Ripple Labs received conditional approval for a bank charter in December for an entity called Ripple National Trust Bank.","The article states the Clarity Act is being awaited but that it is unclear when or if it will proceed.","The article states geopolitical uncertainty related to the war in Iran and rising energy costs could drag down performance this year.","The article states the Federal Reserve keeping interest rates higher than expected could be a headwind.","The article states XRP is expected to benefit from low interest rates and positive market sentiment, which the article says is not currently the case."],"numeric_claims":[{"label":"XRP performance (12 months)","value":"down 39%"},{"label":"Bitcoin performance (12 months)","value":"down 20%"},{"label":"Ripple Labs acquisition spend (recent months)","value":"$4 billion"},{"label":"XRP market cap valuation","value":"$81 billion"},{"label":"XRP rank by market cap","value":"fifth-largest"}],"primary_claim":"XRP is down 39% over the last 12 months even as regulatory conditions for digital assets have been improving.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The article argues that XRP has declined over the past 12 months despite a more favorable regulatory environment for crypto, and it frames XRP\u2019s long-term outlook as potentially improving due to Ripple\u2019s ecosystem and institutional-adoption efforts.","topics":["cryptocurrency price performance","regulatory landscape","Ripple ecosystem","stablecoins","institutional adoption","bank charter application","macro/interest rates","geopolitical risk"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsCryptocurrency prices have been falling over the last 12 months, despite an improving regulatory landscape.","tickers":[],"title":"Where Will the Cryptocurrency XRP Be in 5 Years?","url":"https://www.fool.com/investing/2026/04/12/where-will-the-cryptocurrency-xrp-be-in-5-years/"}}

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