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/drift-protocol","as_of":"2026-04-08T02:28:02.401723+00:00","canonical_url":"https://www.coingecko.com/en/coins/drift-protocol","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/drift-protocol","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cdb5e2e88dc5609d","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/drift-protocol","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:55:57.439395+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Drift Protocol price, market cap, trading volume, news and more with CoinGecko's live DRIFT/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Drift Protocol Price: DRIFT/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/drift-protocol","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/drift-protocol","source_event_id":"evt_c37b3ad4bddb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bfb7a2dd3a987485","kind":"crypto_extremes","published_at":"2026-04-08T02:28:09.461248+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Drift Protocol","relevance":"high","symbol":"DRIFT","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The cleaned article text does not include the specific DRIFT/USD live price value.","The cleaned article text does not include DRIFT\u2019s 24h volume, dominance, or 24h price change.","The provided text includes global market stats (e.g., total market cap, BTC dominance) but does not state they are specific to DRIFT.","No timestamp for the market cap rank/trend score is provided in the extracted text."],"key_facts":["Signal indicates CoinGecko data for Drift Protocol (DRIFT).","Market cap rank: 607.","Trend score: 10."],"numeric_claims":[{"label":"market_cap_rank","value":"607"},{"label":"trend_score","value":"10"}],"primary_claim":"Drift Protocol (DRIFT) has a market cap rank of 607 and a trend score of 10 on CoinGecko.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s page for Drift Protocol (DRIFT) shows a market-cap rank of 607 and a trend score of 10. The provided text does not include the DRIFT price or 24h change values.","topics":["crypto","CoinGecko","Drift Protocol","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 607, trend score 10","tickers":["DRIFT","DRIFTUSD"],"title":"Trending: Drift Protocol (DRIFT)","url":"https://www.coingecko.com/en/coins/drift-protocol"}

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_7c8408851f24 in signals