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-21T01:39:14.218814+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:9ee571c3d073b4b2","evidence_event_ids":["evt_948d69f779df"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/zksync","as_of":"2026-04-21T01:39:14.218814+00:00","canonical_url":"https://www.coingecko.com/en/coins/zksync","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/zksync","article_chars":231,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9273659d80aaa2dc","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/zksync","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:07:20.126652+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest ZKsync price, market cap, trading volume, news and more with CoinGecko's live ZK/USD price chart and popular cryptocurrency price tracker.","fetched_title":"ZKsync Price: ZK/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/zksync","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/zksync","source_event_id":"evt_948d69f779df","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"e40491ca8c9925cf","kind":"crypto_extremes","published_at":"2026-04-21T01:39:19.899993+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"ZKsync","relevance":"high","symbol":"ZK","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not include the meaning of 'Trending: ZKsync (ZK)' beyond the separate signal metadata.","The provided text does not specify the current price, price change, or the 'trend score 11' value in the article body.","No timeframe for 'real-time' calculation is explicitly stated in the text beyond the phrase 'in real-time'."],"key_facts":["CoinGecko calculates the price of ZKsync (ZK) in real time.","The calculation aggregates the latest data across 73 exchanges and 108 markets.","The method uses a global volume-weighted average formula.","The article references CoinGecko\u2019s explanation of how crypto prices are calculated."],"numeric_claims":[{"label":"exchanges_aggregated","value":"73"},{"label":"markets_aggregated","value":"108"}],"primary_claim":"ZKsync (ZK) price is calculated in real time by aggregating the latest data across 73 exchanges and 108 markets using a global volume-weighted average formula.","relevance_score":0.35,"sentiment":"neutral","source_quality":"low","summary":"CoinGecko states that ZKsync (ZK) price is calculated in real time using data aggregated across 73 exchanges and 108 markets via a global volume-weighted average method.","topics":["crypto price calculation","CoinGecko methodology","ZKsync (ZK)"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 206, trend score 11","tickers":["ZK","ZKUSD"],"title":"Trending: ZKsync (ZK)","url":"https://www.coingecko.com/en/coins/zksync"}}

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