Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
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 12394 in events
seq
Primary key.
INTEGER
id
evt_46f8f19e5afa
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T01:50:18.822854+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-09T21:31:27.529333+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:4cc944bd46825203","evidence_event_ids":["evt_e4c43f81c367"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/xrp-has-outperformed-bitcoin-over-past-5-years-heres-why-thats-surprising","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/xrp-has-outperformed-bitcoin-over-the-past-5-years/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/xrp-has-outperformed-bitcoin-over-past-5-years-heres-why-thats-surprising","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b1d7c956e90644c7","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/xrp-has-outperformed-bitcoin-over-the-past-5-years/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:50:18.822799+00:00","extraction_method":"heuristic","fetched_description":"Key PointsOver the past five years, XRP is up a head-spinning 117%, while Bitcoin has been up only a modest 17%.","fetched_title":"XRP Has Outperformed Bitcoin Over the Past 5 Years -- Here's Why That's Surprising | Nasdaq","final_url":"https://www.nasdaq.com/articles/xrp-has-outperformed-bitcoin-over-past-5-years-heres-why-thats-surprising","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/xrp-has-outperformed-bitcoin-over-past-5-years-heres-why-thats-surprising","source_event_id":"evt_e4c43f81c367","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d34dc08d5fbcbcb4","kind":"unusual_volume","published_at":"2026-04-09T20:55:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 1, 2021","November 2024","January 2025","April 9, 2026","April 15, 2005","December 17, 2004","2014","2018","2022","2014, 2018, and 2022 (as examples of declines)"],"entities":[{"asset_class":"crypto","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"other","name":"Trump administration","relevance":"medium","symbol":"","type":"government"}],"event_type":"other","information_gaps":["No data is provided for \u201cunusual volume delta,\u201d including any volume ratio vs average, baseline volume, or direction of volume change.","The signal type suggests volume anomaly detection, but the article content provided focuses on price performance and catalysts rather than trading volume.","No explicit confirmation is provided that the described catalyst (Trump administration/pro-regulatory clarity) caused a volume spike; it is presented as a price-driven explanation."],"key_facts":["XRP was trading at $0.57 on April 1, 2021 and at $1.32 at the time of the article, described as ~118% return over five years.","Bitcoin was trading at $59,095 on April 1, 2021 and at $68,860 at the time of the article, described as ~16.7% return over five years.","The article states XRP\u2019s outperformance was generated largely during a three-month period in late 2024 and early 2025.","The article claims XRP rose from about $0.50 in November 2024 to about $3.40 in January 2025.","The article attributes the XRP rally to \u201cpro-crypto hype coming out of the Trump administration\u201d and \u201cthe prospect of greater regulatory clarity for XRP.\u201d","The article attributes Bitcoin\u2019s underperformance to its cyclical boom/bust behavior lasting about four years, and says Bitcoin is near the end of the latest cycle."],"numeric_claims":[{"label":"XRP price (Apr 1, 2021)","value":"$0.57"},{"label":"XRP price (article time)","value":"$1.32"},{"label":"XRP return over ~5 years","value":"~118% (stated as 118% / 117% in different places)"},{"label":"Bitcoin price (Apr 1, 2021)","value":"$59,095"},{"label":"Bitcoin price (article time)","value":"$68,860"},{"label":"Bitcoin return over ~5 years","value":"~16.7% (stated as 17% / 16.7%)"},{"label":"XRP price (Nov 2024)","value":"~$0.50"},{"label":"XRP price (Jan 2025)","value":"~$3.40"},{"label":"XRP decline (this year)","value":"down nearly 30% (stated qualitatively)"}],"primary_claim":"XRP\u2019s five-year return (~118%) exceeded Bitcoin\u2019s (~16.7%), largely due to a three-month rally in late 2024/early 2025 tied to pro-crypto hype and expectations of regulatory clarity for XRP.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues that XRP has outperformed Bitcoin over the past five years, attributing the gap mainly to a late-2024/early-2025 surge in XRP and Bitcoin\u2019s four-year boom/bust cycle. It does not provide any unusual trading-volume delta data for XRP or BTC.","topics":["cryptocurrency performance","XRP vs Bitcoin","price returns","regulatory clarity","market cycles"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsOver the past five years, XRP is up a head-spinning 117%, while Bitcoin has been up only a modest 17%.","tickers":[],"title":"XRP Has Outperformed Bitcoin Over the Past 5 Years -- Here's Why That's Surprising","url":"https://www.fool.com/investing/2026/04/09/xrp-has-outperformed-bitcoin-over-the-past-5-years/"}}
TEXT NOT NULL
source_ref
candidate:sc_b1d7c956e90644c7
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:4cc944bd46825203
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T01:50:18.822903+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel