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:259189090db35ba9","evidence_event_ids":["evt_887895673bf8"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/monad","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/monad","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/monad","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8d49879ecc42e0bb","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/monad","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:19.607882+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Monad price, market cap, trading volume, news and more with CoinGecko's live MON/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Monad Price: MON/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/monad","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/monad","source_event_id":"evt_887895673bf8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"afb4b28498780aed","kind":"crypto_extremes","published_at":"2026-04-07T23:23:59.708482+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Monad","relevance":"primary","symbol":"MON","type":"cryptocurrency"},{"asset_class":"platform","name":"CoinGecko","relevance":"context","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No MON price, 24h change, volume, or market cap value is provided in the cleaned article text.","The cleaned article text appears to include general CoinGecko site navigation and global market stats, but not the specific MON metrics beyond the signal headline/summary.","No timestamp for when the \u201ctrending\u201d metrics were observed is included."],"key_facts":["Signal headline: \u201cTrending: Monad (MON)\u201d.","Source summary states: \u201cMarket cap rank 128, trend score 4\u201d.","Source quality hint indicates high quality and paywall likely false."],"numeric_claims":[{"label":"market_cap_rank","value":"128"},{"label":"trend_score","value":"4"}],"primary_claim":"Monad (MON) is trending on CoinGecko with market cap rank 128 and trend score 4.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section lists Monad (MON) with a market cap rank of 128 and a trend score of 4.","topics":["crypto trending","market cap ranking","trend score","Monad (MON)"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 128, trend score 4","tickers":["MON","MONUSD"],"title":"Trending: Monad (MON)","url":"https://www.coingecko.com/en/coins/monad"}}

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