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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:43619d913b51690f","evidence_event_ids":["evt_f69aaea209f6"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/pudgy-penguins","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f787b97406a60ca5","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/pudgy-penguins","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:13.495592+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Pudgy Penguins price, market cap, trading volume, news and more with CoinGecko's live PENGU/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Pudgy Penguins Price: PENGU/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/pudgy-penguins","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/pudgy-penguins","source_event_id":"evt_f69aaea209f6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3bdc52b34f9a9e79","kind":"crypto_extremes","published_at":"2026-04-07T23:23:59.708482+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Pudgy Penguins","relevance":"high","symbol":"PENGU","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not explicitly label which currency the 24h change percentage corresponds to as \u201cUSD\u201d; it shows many currencies under price_change_percentage_24h, including a value 7.627096058888013 under the key \u201caed\u201d.","The signal type is \u201cdiscovery_crypto_extremes_delta\u201d, but the provided text does not include any explicit \u201cextremes\u201d or \u201cdelta\u201d metrics beyond the trend score and ranking.","No timestamp for the live price or the trend score is included in the provided excerpt."],"key_facts":["CoinGecko lists Pudgy Penguins (PENGU) as trending.","Market cap rank for Pudgy Penguins is 105.","Trend score is 2 (as provided in the signal metadata).","The CoinGecko snippet includes a live price for PENGU/USD: 0.006762372670577617 USD.","The snippet includes a 24h price change percentage for PENGU in USD: 7.627096058888013% (from the price_change_percentage_24h.aed field shown; USD field is not explicitly labeled in the provided text)."],"numeric_claims":[{"label":"market_cap_rank","value":"105"},{"label":"trend_score","value":"2"},{"label":"price_usd","value":"0.006762372670577617"},{"label":"24h_change_percentage_(shown_value)","value":"7.627096058888013"}],"primary_claim":"Pudgy Penguins (PENGU) is trending on CoinGecko with market cap rank 105 and trend score 2.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending NFTs\u201d section lists Pudgy Penguins (PENGU) with a market cap rank of 105 and a trend score of 2. The page also shows PENGU\u2019s live price and a 24h price change percentage (USD).","topics":["crypto trending","Pudgy Penguins","market cap rank","price and 24h change","CoinGecko"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 105, trend score 2","tickers":["PENGU","PENGUUSD"],"title":"Trending: Pudgy Penguins (PENGU)","url":"https://www.coingecko.com/en/coins/pudgy-penguins"}}

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