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-22T14:13:37.135360+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:2cb433119dbfd801","evidence_event_ids":["evt_c7c2187e4d5a"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/ethereum","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.coingecko.com/en/coins/ethereum","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/ethereum","article_chars":169,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c9f5270b740f3a51","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/ethereum","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:18:02.896917+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest Ethereum price, market cap, trading volume, news and more with CoinGecko's live ETH/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Ethereum Price: ETH/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/ethereum","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/ethereum","source_event_id":"evt_c7c2187e4d5a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"cf333088090adbfb","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":["2 hours ago"],"entities":[{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"high","symbol":"ETH","type":"asset"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"reference_asset"},{"asset_class":"exchange_traded_fund","name":"Spot ETFs","relevance":"medium","symbol":"","type":"financial_product"}],"event_type":"price_action","information_gaps":["No ETF fund names, jurisdictions, or inflow amounts are provided\u2014only that inflows occurred for a ninth consecutive day.","The article does not specify whether the 3.3% gain is measured over the last 24 hours or another interval.","No methodology for \"trend score 10\" is provided.","The source quality hint is empty, so reliability of the figures cannot be independently assessed from the provided text."],"key_facts":["ETH price is shown as $2,419.11.","ETH is ranked #2 by market cap (as stated).","A trend score of 10 is mentioned.","ETH is up 3.3%.","ETH 24h range is $2,292.92 to $2,420.19.","ETH is shown as 0.03060 BTC.","Spot ETFs are reported to have seen a ninth consecutive day of inflows.","Timing mentioned: \"2 hours ago\"."],"numeric_claims":[{"label":"ETH price (USD)","value":"2419.11"},{"label":"ETH gain (%)","value":"3.3"},{"label":"24h range low (USD)","value":"2292.92"},{"label":"24h range high (USD)","value":"2420.19"},{"label":"ETH price in BTC","value":"0.03060"},{"label":"Market cap rank","value":"2"},{"label":"Trend score","value":"10"}],"primary_claim":"ETH is gaining 3.3% to about $2,419.11, with a 24-hour range of $2,292.92\u2013$2,420.19, as spot ETFs see a ninth consecutive day of inflows.","relevance_score":0.62,"sentiment":"positive","source_quality":"unknown","summary":"Ethereum (ETH) is trading around $2,419.11 and is up 3.3% with a 24-hour range of $2,292.92 to $2,420.19. The article attributes the move to spot ETF inflows, citing a ninth consecutive day of inflows.","topics":["Ethereum price","24h range","spot ETF inflows","market trend","BTC reference price"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 2, trend score 10","tickers":["ETH","ETHUSD"],"title":"Trending: Ethereum (ETH)","url":"https://www.coingecko.com/en/coins/ethereum"}}

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