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-08T03:28:49.431348+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:ac0e9ef1dc18e2d3","evidence_event_ids":["evt_8a2c722fceb7"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/hedera-hashgraph","as_of":"2026-04-08T03:28:49.431348+00:00","canonical_url":"https://www.coingecko.com/en/coins/hedera","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/hedera-hashgraph","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e93ad03daa6f8ca6","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/hedera","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:58:36.684619+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Hedera price, market cap, trading volume, news and more with CoinGecko's live HBAR/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Hedera Price: HBAR/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/hedera","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/hedera-hashgraph","source_event_id":"evt_8a2c722fceb7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"21bee092d7781cf5","kind":"crypto_extremes","published_at":"2026-04-08T03:28:54.606773+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["24h"],"entities":[{"asset_class":"crypto","name":"Hedera","relevance":"primary","symbol":"HBAR","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No absolute HBAR price level is provided in the extracted text (only the 24h percentage change and market cap).","No timeframe end timestamp (e.g., exact hour) is provided beyond \u201c24h\u201d.","The cleaned article text appears to include general CoinGecko page content but does not explicitly show the HBAR +7.53% figure; the numeric claims are grounded in the provided signal headline/source summary."],"key_facts":["HBAR 24h change: +7.53% (as stated in the signal headline/source summary).","HBAR market cap: $4,047,510,745 (as stated in the signal/source summary)."],"numeric_claims":[{"label":"HBAR 24h change","value":"+7.53%"},{"label":"HBAR market cap","value":"$4,047,510,745"}],"primary_claim":"HBAR moved up 7.53% in the past 24 hours (HBAR/USD, per CoinGecko).","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"CoinGecko reports Hedera (HBAR) rose 7.53% over the last 24 hours. The same signal lists its market cap as $4,047,510,745.","topics":["crypto price move","24h performance","HBAR","market cap"]},"source":"CoinGecko Movers","source_domain":"coingecko.com","summary":"24h change 7.53% \u00b7 mcap 4047510745","tickers":["HBAR","HBARUSD"],"title":"Hedera (HBAR) moved 7.53% (24h)","url":"https://www.coingecko.com/en/coins/hedera"}}

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