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:43619d913b51690f","evidence_event_ids":["evt_2e7c98b01cba"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","as_of":"2026-04-22T14:13:37.135360+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":177,"article_truncated":false,"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-22T14:17:53.902480+00:00","extraction_method":"trafilatura","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_2e7c98b01cba","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"c431ef186537cf91","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.72,"dates_mentioned":["1 day ago"],"entities":[{"asset_class":"crypto","name":"Pudgy Penguins","relevance":"high","symbol":"PENGU","type":"crypto_asset"},{"asset_class":"crypto","name":"Bitcoin","relevance":"low","symbol":"BTC","type":"reference_asset"}],"event_type":"price_action","information_gaps":["The source quality hint is empty; no additional verification details are provided.","The meaning of the displayed '0.061096 BTC' value is not explained (e.g., whether it is price in BTC or another metric).","No timeframe definition for 'trend score 5' is provided in the cleaned text.","No market cap value, volume, or liquidity metrics are included\u2014only rank is shown."],"key_facts":["PENGU price shown as $0.008661.","PENGU market cap rank shown as #99.","PENGU is shown with a 24h range of $0.007468 to $0.008971.","Pudgy Penguins is described as rising 6.3%.","The text states the NFT sector is leading a crypto market rebound.","A BTC-related value is shown as 0.061096 BTC (context not fully explained in the provided text)."],"numeric_claims":[{"label":"Price (USD)","value":"0.008661"},{"label":"Market cap rank","value":"99"},{"label":"24h range (USD low)","value":"0.007468"},{"label":"24h range (USD high)","value":"0.008971"},{"label":"1-day rise (%)","value":"6.3"},{"label":"BTC value shown","value":"0.061096"}],"primary_claim":"Pudgy Penguins (PENGU) rose 6.3% and is trading at about $0.008661 with a 24h range of $0.007468\u2013$0.008971 and market cap rank #99.","relevance_score":0.55,"sentiment":"positive","source_quality":"unknown","summary":"Pudgy Penguins (PENGU) is trading around $0.008661 and is ranked #99 by market cap. The token rose 6.3% and is leading a broader crypto rebound tied to the NFT sector.","topics":["crypto market rebound","NFT sector","Pudgy Penguins","PENGU price","market cap rank"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 99, trend score 5","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 482104 in events