SQLite Web: event_store.db

Update row 482110 in events

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-22T14:13:37.135360+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:efff69a6bf7ff884","evidence_event_ids":["evt_28855d7304f4"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/global_charts","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.coingecko.com/en/charts","enrichment":{"aggregator_url":"https://www.coingecko.com/en/global_charts","article_chars":807,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cf5111319bf8c808","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/charts","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:18:08.606758+00:00","extraction_method":"trafilatura","fetched_description":"View the global cryptocurrency market cap charts, Bitcoin dominance, DeFi, Stablecoin, Altcoin market capitalization charts and more.","fetched_title":"Crypto Market Cap Charts | CoinGecko","final_url":"https://www.coingecko.com/en/charts","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/global_charts","source_event_id":"evt_28855d7304f4","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"9c49ef63292620a6","kind":"crypto_extremes","published_at":"2026-04-22T14:13:46.185501+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"crypto_market","name":"Global Cryptocurrency Market","relevance":"high","symbol":"","type":"market"},{"asset_class":"crypto","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"crypto","name":"Stablecoins","relevance":"medium","symbol":"","type":"asset_category"},{"asset_class":"crypto","name":"Altcoins","relevance":"medium","symbol":"","type":"asset_category"}],"event_type":"price_action","information_gaps":["The time window for the market cap figure beyond \u201c24h\u201d is not specified in the provided text.","No specific values are provided for BTC dominance, DeFi market cap, stablecoin market cap, or altcoin market cap\u2014only that charts exist.","No directional details are provided for DeFi/stablecoin/altcoin segments beyond the existence of charts.","The signal type mentions \u201cextremes_delta,\u201d but the provided text does not include any explicit \u201cextremes\u201d or delta beyond the single 24h change figure."],"key_facts":["Total crypto market cap is $2724476878958.3237.","24h change is +3.465039260057358%.","The charts are based on 16,517 cryptocurrencies tracked.","The charts are based on 1,474 exchanges tracked.","The dataset tracks 693 total categories.","Crypto-backed tokens such as wrapped, bridged, and staked tokens are excluded from global market cap to avoid double-counting of value.","Bitcoin (BTC) dominance is shown as a percentage compared to Ethereum, stablecoins, and other cryptocurrencies.","Altcoins are defined as all cryptocurrencies other than Bitcoin (BTC)."],"numeric_claims":[{"label":"total_market_cap_usd","value":"2724476878958.3237"},{"label":"24h_change_percent","value":"3.465039260057358"}],"primary_claim":"Total global crypto market cap is $2,724,476,878,958.3237 with a 24h change of +3.465039260057358%.","relevance_score":0.62,"sentiment":"positive","source_quality":"medium","summary":"The global cryptocurrency market data indicates a total crypto market cap of about $2.724T and a 24-hour change of +3.465%. The dataset tracks 16,517 cryptocurrencies across 1,474 exchanges, with crypto-backed tokens excluded from global market cap to avoid double-counting.","topics":["global crypto market cap","24h market change","market cap charts","BTC dominance","DeFi market cap","stablecoin market cap","altcoin market cap","data methodology"]},"source":"CoinGecko Global","source_domain":"coingecko.com","summary":"Market cap $2724476878958.3237 \u00b7 24h 3.465039260057358%","tickers":[],"title":"Global crypto market","url":"https://www.coingecko.com/en/charts"}}

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')

Cancel