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:3fdfb07b5d41726a","evidence_event_ids":["evt_b487398911c3"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/unifai-network","as_of":"2026-04-21T01:39:14.218814+00:00","canonical_url":"https://www.coingecko.com/en/coins/unifai-network","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/unifai-network","article_chars":292,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_26efe451ce9eeeb0","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/unifai-network","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:07:14.036884+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest UnifAI Network price, market cap, trading volume, news and more with CoinGecko's live UAI/USD price chart and popular cryptocurrency price tracker.","fetched_title":"UnifAI Network Price: UAI/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/unifai-network","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/unifai-network","source_event_id":"evt_b487398911c3","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"3ec6a843600c7455","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.68,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"UnifAI Network","relevance":"high","symbol":"UAI","type":"crypto_asset"}],"event_type":"other","information_gaps":["No specific price level, price change, or trend direction for UAI is provided in the cleaned article text.","The signal metadata mentions 'Market cap rank 359' and 'trend score 10', but these values are not present in the provided article text.","No timeframe for 'real-time' calculation is specified beyond the phrase 'in real-time'."],"key_facts":["The price of UnifAI Network (UAI) is calculated in real time.","CoinGecko aggregates the latest data across 15 exchanges and 16 markets.","The aggregation uses a global volume-weighted average formula.","The text references CoinGecko\u2019s explanation of how crypto prices are calculated."],"numeric_claims":[{"label":"exchanges_aggregated","value":"15"},{"label":"markets_aggregated","value":"16"}],"primary_claim":"UnifAI Network (UAI) price is calculated by aggregating latest data across 15 exchanges and 16 markets using a global volume-weighted average formula.","relevance_score":0.35,"sentiment":"neutral","source_quality":"low","summary":"CoinGecko states that UnifAI Network (UAI) price is calculated in real time by aggregating the latest data across 15 exchanges and 16 markets using a global volume-weighted average method.","topics":["crypto price calculation","CoinGecko methodology","volume-weighted average","exchanges","markets"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 359, trend score 10","tickers":["UAI","UAIUSD"],"title":"Trending: UnifAI Network (UAI)","url":"https://www.coingecko.com/en/coins/unifai-network"}}

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