SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","as_of":"2026-04-08T19:57:42.365437+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-09T23:02:08.508406+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_5bb30fe34e5c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fde63558dd3bfc3","kind":"crypto_extremes","published_at":"2026-04-08T19:57:58.888098+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Pudgy Penguins","relevance":"primary","symbol":"PENGU","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No PENGU live price value is shown in the provided cleaned text.","No PENGU 24h change, volume, or market cap figures specific to PENGU are present in the provided text.","The cleaned text includes global CoinGecko market stats (e.g., total market cap, BTC dominance), but these are not explicitly tied to PENGU.","The \u201carticle\u201d content appears to be mostly page chrome/navigation; PENGU-specific chart/news details are not included in the provided excerpt."],"key_facts":["Headline indicates \u201cTrending: Pudgy Penguins (PENGU)\u201d.","Source summary states market cap rank is 106.","Source summary states trend score is 2.","Article text provided is largely CoinGecko site navigation and global market stats; no additional PENGU-specific numeric metrics are visible in the cleaned text."],"numeric_claims":[{"label":"market_cap_rank","value":"106"},{"label":"trend_score","value":"2"}],"primary_claim":"Pudgy Penguins (PENGU) has CoinGecko market cap rank 106 and a trend score of 2 in the \u201cTrending\u201d section.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko is showing Pudgy Penguins (PENGU) as a trending crypto asset with market cap rank 106 and a trend score of 2. The provided page text does not include additional PENGU-specific price or performance metrics beyond these ranking/trend indicators.","topics":["crypto trending","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 106, trend score 2","tickers":["PENGU","PENGUUSD"],"title":"Trending: Pudgy Penguins (PENGU)","url":"https://www.coingecko.com/en/coins/pudgy-penguins"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_588dc188eafd in signals