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-21T03:09:54.871544+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:00b5722deadfb491","evidence_event_ids":["evt_f95c55a921d1"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/ethena-usde","as_of":"2026-04-21T03:09:54.871544+00:00","canonical_url":"https://www.coingecko.com/en/coins/ethena-usde","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/ethena-usde","article_chars":289,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_33437436744976dc","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/ethena-usde","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:08:52.070350+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest Ethena USDe price, market cap, trading volume, news and more with CoinGecko's live USDE/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Ethena USDe Price: USDE/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/ethena-usde","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/ethena-usde","source_event_id":"evt_f95c55a921d1","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"c176565eb49feeea","kind":"crypto_extremes","published_at":"2026-04-21T03:09:59.439155+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.52,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Ethena USDe","relevance":"high","symbol":"USDE","type":"crypto_asset"},{"asset_class":"information_source","name":"CoinGecko","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The text does not provide the current price level, price change, or direction of the trend\u2014only the method of calculation and the signal summary metrics (market cap rank 23, trend score 9).","The text does not define how 'trend score 9' is computed.","No timestamp for the 'real-time' calculation or the rank/score values is provided."],"key_facts":["CoinGecko says the price of Ethena USDe (USDE) is calculated in real time.","The calculation aggregates the latest data across 68 exchanges and 158 markets.","CoinGecko uses a global volume-weighted average formula for the price calculation.","The provided signal also mentions: market cap rank 23 and trend score 9 (from the source summary)."],"numeric_claims":[{"label":"market_cap_rank","value":"23"},{"label":"trend_score","value":"9"},{"label":"exchanges_aggregated","value":"68"},{"label":"markets_aggregated","value":"158"}],"primary_claim":"Ethena USDe (USDE) price is calculated in real time by aggregating data across 68 exchanges and 158 markets using a global volume-weighted average formula.","relevance_score":0.45,"sentiment":"neutral","source_quality":"low","summary":"CoinGecko states that Ethena USDe (USDE) pricing is calculated in real time by aggregating the latest data across 68 exchanges and 158 markets using a global volume-weighted average method.","topics":["crypto price calculation","volume-weighted average","market data aggregation","USDE"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 23, trend score 9","tickers":["USDE","USDEUSD"],"title":"Trending: Ethena USDe (USDE)","url":"https://www.coingecko.com/en/coins/ethena-usde"}}

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