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/starknet","as_of":"2026-04-09T12:08:05.625638+00:00","canonical_url":"https://www.coingecko.com/en/coins/starknet","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/starknet","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c80a45bb575981c2","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/starknet","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:32:29.278076+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Starknet price, market cap, trading volume, news and more with CoinGecko's live STRK/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Starknet Price: STRK/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/starknet","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/starknet","source_event_id":"evt_855052266277","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6904f510e7456f05","kind":"crypto_extremes","published_at":"2026-04-09T12:08:12.133134+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Starknet","relevance":"high","symbol":"STRK","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not include Starknet\u2019s live price, 24h volume, or 24h price change for STRK.","The text does not define how \u201ctrend score\u201d is calculated.","No timestamp is provided for when the \u201cTrending\u201d metrics were observed."],"key_facts":["Source indicates Starknet (STRK) is trending.","Starknet\u2019s market cap rank is 173.","Starknet\u2019s trend score is 10."],"numeric_claims":[{"label":"market_cap_rank","value":"173"},{"label":"trend_score","value":"10"}],"primary_claim":"Starknet (STRK) is listed as trending with market cap rank 173 and trend score 10.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section shows Starknet (STRK) with a market cap rank of 173 and a trend score of 10.","topics":["crypto trending","Starknet","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 173, trend score 10","tickers":["STRK","STRKUSD"],"title":"Trending: Starknet (STRK)","url":"https://www.coingecko.com/en/coins/starknet"}

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