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-22T09:08:08.862046+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:5de4078d7844da1e","evidence_event_ids":["evt_72a442c49593"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/aptos","as_of":"2026-04-22T09:08:08.862046+00:00","canonical_url":"https://www.coingecko.com/en/coins/aptos","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/aptos","article_chars":161,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_348468e505d8f77a","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/aptos","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T09:11:46.587846+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest Aptos price, market cap, trading volume, news and more with CoinGecko's live APT/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Aptos Price: APT/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/aptos","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/aptos","source_event_id":"evt_72a442c49593","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"c5ee5e8cea2ccc58","kind":"crypto_extremes","published_at":"2026-04-22T09:08:15.780838+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["24h"],"entities":[{"asset_class":"crypto","name":"Aptos","relevance":"high","symbol":"APT","type":"cryptocurrency"},{"asset_class":"crypto","name":"Bitcoin","relevance":"low","symbol":"BTC","type":"reference_asset"}],"event_type":"price_action","information_gaps":["No timestamp/date for the 24h measurement is provided beyond '24h'.","The text does not specify the exact market-cap unit (e.g., USD) for 785771186.","The 'Coinbase highlights its Quantum Threat Preparedness' statement is mentioned but not explained; no measurable details are included.","No volume, order-book, or on-chain metrics are provided in the text."],"key_facts":["APT price is shown as $0.9753.","The signal states a 24h change of +4.22%.","A 24h range is shown as $0.9195 to $0.9754 (as presented in the cleaned text).","A market cap value is provided as 785,771,186.","The cleaned text includes a reference to Coinbase highlighting quantum threat preparedness (no further details provided)."],"numeric_claims":[{"label":"24h change (%)","value":"4.22%"},{"label":"Price (USD)","value":"0.9753"},{"label":"24h range low (USD)","value":"0.9195"},{"label":"24h range high (USD)","value":"0.9754"},{"label":"Market cap","value":"785771186"}],"primary_claim":"Aptos (APT) moved up 4.22% over 24 hours to around $0.9753, with a reported market cap of 785,771,186.","relevance_score":0.62,"sentiment":"positive","source_quality":"unknown","summary":"Aptos (APT) price moved up 4.22% over the last 24 hours, reaching about $0.9753. The provided text also references a 24h range and a market-cap figure, but does not include further details.","topics":["Aptos","APT price move","24h range","market capitalization","Coinbase quantum threat preparedness (mentioned)"]},"source":"CoinGecko Movers","source_domain":"coingecko.com","summary":"24h change 4.22% \u00b7 mcap 785771186","tickers":["APT","APTUSD"],"title":"Aptos (APT) moved 4.22% (24h)","url":"https://www.coingecko.com/en/coins/aptos"}}

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