SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.coingecko.com/en/coins/solana","as_of":"2026-04-08T19:57:42.365437+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-09T23:03:14.310151+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_38aaf59d4d1e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2abe7a1160ae2a8b","kind":"crypto_extremes","published_at":"2026-04-08T19:57:58.888098+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 text does not include the exact SOL price, 24h change, or the time window for the \u201ctrend score.\u201d","The excerpt does not show the full context of how CoinGecko computes \u201ctrend score.\u201d","No additional measurable extremes (e.g., highest/lowest delta) are present in the provided text beyond the trending rank/score."],"key_facts":["CoinGecko lists Solana (SOL) as trending.","Solana\u2019s market cap rank is 7.","Solana\u2019s trend score is 6."],"numeric_claims":[{"label":"market_cap_rank","value":"7"},{"label":"trend_score","value":"6"}],"primary_claim":"Solana (SOL) is trending with market cap rank 7 and trend score 6 (per CoinGecko).","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section shows Solana (SOL) with market cap rank 7 and a trend score of 6.","topics":["crypto trending","Solana","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 7, trend score 6","tickers":["SOL","SOLUSD"],"title":"Trending: Solana (SOL)","url":"https://www.coingecko.com/en/coins/solana"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_c804e54843f9 in signals