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/chip-2","as_of":"2026-04-21T13:49:56.265209+00:00","canonical_url":"https://www.coingecko.com/en/coins/chip","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/chip-2","article_chars":230,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c55414a4fc8024ea","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/chip","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:49:55.260002+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest CHIP price, market cap, trading volume, news and more with CoinGecko's live CHIP/USD price chart and popular cryptocurrency price tracker.","fetched_title":"CHIP Price: CHIP/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/chip","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/chip-2","source_event_id":"evt_ee859f9360d0","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"b8f0fcbfe3246fd1","kind":"crypto_extremes","published_at":"2026-04-21T13:50:03.065021+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.68,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"CHIP","relevance":"primary subject of the signal","symbol":"CHIP","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not include the meaning of the 'trend score 0' or any timeframe for it.","No specific price level, percentage change, or directionality for CHIP is provided in the cleaned article text.","The signal mentions 'Market cap rank 260' but the cleaned article text does not include this detail; it is only present in the signal metadata."],"key_facts":["CoinGecko calculates CHIP (CHIP) price in real time.","The calculation aggregates the latest data across 25 exchanges and 93 markets.","A global volume-weighted average formula is used for the price calculation."],"numeric_claims":[{"label":"exchanges_aggregated","value":"25"},{"label":"markets_aggregated","value":"93"}],"primary_claim":"CHIP (CHIP) price is calculated in real time by aggregating the latest data across 25 exchanges and 93 markets using a global volume-weighted average formula.","relevance_score":0.35,"sentiment":"neutral","source_quality":"low","summary":"CoinGecko states that CHIP (CHIP) price is calculated in real time using data aggregated across 25 exchanges and 93 markets via a global volume-weighted average method.","topics":["crypto price calculation","CoinGecko methodology","CHIP"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 260, trend score 0","tickers":["CHIP","CHIPUSD"],"title":"Trending: CHIP (CHIP)","url":"https://www.coingecko.com/en/coins/chip"}

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