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:5021af6343e1f718","evidence_event_ids":["evt_cd8b037daa1d"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/render-token","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/render","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/render-token","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8c36d501a9008abf","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/render","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:59.280591+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Render price, market cap, trading volume, news and more with CoinGecko's live RENDER/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Render Price: RENDER/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/render","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/render-token","source_event_id":"evt_cd8b037daa1d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c4f5ed6c4bd8831f","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.78,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Render","relevance":"high","symbol":"RENDER","type":"crypto_asset"},{"asset_class":"website","name":"CoinGecko","relevance":"high","symbol":"","type":"source"}],"event_type":"price_action","information_gaps":["The cleaned text does not include the exact current price level for RENDER/USD, only the 24h change and market cap.","No timestamp for when the 24h window is measured is explicitly provided in the extracted text.","No additional context (e.g., volume, catalysts, news) about the move is present in the provided text."],"key_facts":["Render (RENDER) 24h change: +11.68%","Render market cap: $1,075,202,717","Data shown as Render Price: RENDER/USD Live Price Chart, Market Cap & News Today (CoinGecko)"],"numeric_claims":[{"label":"RENDER 24h change","value":"11.68%"},{"label":"Render market cap","value":"1075202717"}],"primary_claim":"RENDER moved up 11.68% in the past 24 hours (RENDER/USD, per CoinGecko).","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"CoinGecko shows Render (RENDER) increased by 11.68% over the last 24 hours. The signal also lists Render\u2019s market cap as $1,075,202,717.","topics":["cryptocurrency","price change","24h performance","market cap"]},"source":"CoinGecko Movers","source_domain":"coingecko.com","summary":"24h change 11.68% \u00b7 mcap 1075202717","tickers":["RENDER","RENDERUSD"],"title":"Render (RENDER) moved 11.68% (24h)","url":"https://www.coingecko.com/en/coins/render"}}

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