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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:d9661d13fe756548","evidence_event_ids":["evt_5ac16205dd3a"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","enrichment":{"aggregator_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","article_chars":1633,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f35179979b41673a","canonical_host":"cryptoslate.com","canonical_is_aggregator":false,"canonical_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:54:58.360473+00:00","extraction_method":"heuristic","fetched_description":"XRP holders are locking in millions of losses daily while Bitcoin\u2019s risk off drop keeps crushing fragile setups.","fetched_title":"XRP\u2019s $2 buyers are realizing up to $110M a day in losses","final_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","html_truncated":true,"paywall_likely":false,"publisher_domain":"cryptoslate.com","publisher_resolution":"canonical_url","requested_url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/","source_event_id":"evt_5ac16205dd3a","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"0061762ef598589c","kind":"crypto_extremes","published_at":"2026-04-07T16:05:41+00:00","publisher_domain":"cryptoslate.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.15,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"XRP","relevance":"mentioned in headline/source summary but not present in provided article text","symbol":"XRP","type":"cryptocurrency"}],"event_type":"other","information_gaps":["The provided article text does not include the Glassnode data or the stated realized-loss range ($20 million to $110 million a day).","No timestamps, price levels, or cohort definitions (e.g., \u201clong-term holders who bought above $2 over the past year\u201d) are present in the supplied article text.","The headline/source summary claims cannot be verified against the provided cleaned article text, which appears to be unrelated promotional content."],"key_facts":[],"numeric_claims":[],"primary_claim":"The supplied \u201cArticle Text\u201d contains no XRP-specific or Glassnode-specific factual content; it is composed of generic promotional sections about market making, crypto-as-a-service, and token listing playbooks.","relevance_score":0.2,"sentiment":"neutral","source_quality":"medium","summary":"The provided text does not contain the XRP/Glassnode claims from the headline/source summary; instead it shows unrelated promotional content. Therefore, no grounded facts about XRP price action or realized losses can be extracted from the article text supplied.","topics":["crypto","XRP","price action","on-chain realized losses","market making","crypto-as-a-service","token listing playbook"]},"source":"CryptoSlate RSS","source_domain":"cryptoslate.com","summary":"XRP\u2019s recent price struggles is starting to look less like routine underperformance and more like capitulation as long-term holders who bought above $2 over the past year are now realizing millions in losses. Data from Glassnode shows that this cohort has been realizing losses at roughly $20 million to $110 million a day amid the [\u2026] The post XRP losses are forcing late buyers out, turning every bounce into a new sell zone appeared first on CryptoSlate .","tickers":[],"title":"XRP losses are forcing late buyers out, turning every bounce into a new sell zone","url":"https://cryptoslate.com/xrp-losses-trapped-buyers-sell-rebounds/"}}

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