Create
Query
event_store.db
—
signals
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 sig_5a30a301b077 in signals
id
sig_5a30a301b077
Primary key.
TEXT
event_id
12546
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-1","as_of":"2026-04-10T00:01:31.055484+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/xrp-price-prediction-where-in-5-years/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/where-will-cryptocurrency-xrp-be-5-years-1","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_452a9d0d8aad1343","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/xrp-price-prediction-where-in-5-years/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:00:01.712234+00:00","extraction_method":"heuristic","fetched_description":"Key PointsXRP has dropped over 60% from its July peak despite major catalysts like the SEC settlement and spot ETF launches finally materializing.","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-1","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-1","source_event_id":"evt_99da8ce4a98a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ae6019d5314e6d3e","kind":"unusual_volume","published_at":"2026-04-09T23:39:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["July (year not specified)","April 09, 2026"],"entities":[{"asset_class":"cryptocurrency","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"equities/issuer","name":"Ripple","relevance":"high","symbol":"","type":"company"},{"asset_class":"regulation","name":"SEC (Securities and Exchange Commission)","relevance":"medium","symbol":"","type":"regulator"},{"asset_class":"fund","name":"Bitwise XRP ETF","relevance":"medium","symbol":"","type":"ETF"}],"event_type":"other","information_gaps":["The signal type requests unusual volume delta (volume ratio vs average), but the provided text contains no volume metrics, baseline volume, or volume ratio for XRP.","The article provides price and business-model arguments but does not explicitly confirm any volume spike with news or quantify it.","The catalyst hypothesis is inferred from the article\u2019s narrative (SEC settlement/spot ETFs already occurred; RLUSD replacing XRP use case), not from any stated volume-change event."],"key_facts":["The article states XRP peaked near $3.65 last July and is down over 60% since then.","The article states XRP is trading around $1.30.","The article states the SEC settled its case against Ripple and that spot XRP ETFs (including the Bitwise XRP ETF) launched in the U.S.","The article claims Ripple\u2019s core banking settlement messaging system does not involve XRP.","The article states Ripple\u2019s stablecoin RLUSD can play the same role as XRP in cross-border transactions.","The article argues that Ripple\u2019s success as a payments company does not necessarily translate to gains for XRP holders because Ripple is diversifying away from XRP dependency."],"numeric_claims":[{"label":"XRP peak price (July)","value":"~$3.65"},{"label":"XRP current price (article)","value":"~$1.30"},{"label":"XRP drawdown since July peak","value":"over 60%"}],"primary_claim":"XRP is down more than 60% since peaking near $3.65 last July and is trading around ~$1.30 even after the SEC settlement and spot XRP ETF launches, because Ripple\u2019s core business doesn\u2019t require XRP and RLUSD can replace XRP for cross-border transactions.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"The article argues XRP has fallen over 60% from its July peak and is trading around ~$1.30 despite catalysts such as the SEC settlement and the launch of U.S. spot XRP ETFs. It attributes the disconnect to Ripple\u2019s business using messaging that doesn\u2019t require XRP and to Ripple\u2019s stablecoin RLUSD potentially replacing XRP in cross-border transactions.","topics":["XRP price performance","SEC settlement","spot XRP ETFs","Ripple business model","RLUSD stablecoin","cross-border payments","token utility vs business adoption"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsXRP has dropped over 60% from its July peak despite major catalysts like the SEC settlement and spot ETF launches finally materializing.","tickers":[],"title":"Where Will the Cryptocurrency XRP Be in 5 Years?","url":"https://www.fool.com/investing/2026/04/09/xrp-price-prediction-where-in-5-years/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_99da8ce4a98a"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:26d7d85d4e715e32
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-10T00:01:31.055484+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel