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:128efad49d67f24c","evidence_event_ids":["evt_33a6bb72a1c2"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/solana","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/solana","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/solana","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_93e05f4be2c235ba","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/solana","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:44.853472+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Solana price, market cap, trading volume, news and more with CoinGecko's live SOL/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Solana Price: SOL/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/solana","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/solana","source_event_id":"evt_33a6bb72a1c2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fd10b550094d77da","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.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Solana","relevance":"high","symbol":"SOL","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided article text does not include the specific \u201cTrending: Solana (SOL)\u201d line or the exact market cap rank/trend score values; they are only present in the user-provided Source Summary.","No SOL price level, 24h change, or other performance metrics for Solana are shown in the cleaned article text excerpt.","No timeframe definition for \u201ctrend score\u201d is provided in the excerpt."],"key_facts":["CoinGecko source summary indicates Solana (SOL) is trending.","Market cap rank for Solana is 7.","Trend score for Solana is 8."],"numeric_claims":[{"label":"market_cap_rank","value":"7"},{"label":"trend_score","value":"8"}],"primary_claim":"Solana (SOL) is trending with market cap rank 7 and trend score 8 (per CoinGecko).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d signal lists Solana (SOL) with market cap rank 7 and a trend score of 8.","topics":["crypto","trending","Solana","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 7, trend score 8","tickers":["SOL","SOLUSD"],"title":"Trending: Solana (SOL)","url":"https://www.coingecko.com/en/coins/solana"}}

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