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-20T22:38:30.834831+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:8e410a4408c7dfd0","evidence_event_ids":["evt_f1272ecb987b"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/the-innovation-game","as_of":"2026-04-20T22:38:30.834831+00:00","canonical_url":"https://www.coingecko.com/en/coins/the-innovation-game","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/the-innovation-game","article_chars":592,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_8257d3c0152b7ebf","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/the-innovation-game","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T21:15:29.758385+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest The Innovation Game price, market cap, trading volume, news and more with CoinGecko's live TIG/USD price chart and popular cryptocurrency price tracker.","fetched_title":"The Innovation Game Price: TIG/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/the-innovation-game","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/the-innovation-game","source_event_id":"evt_f1272ecb987b","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"0102ab90b70a564a","kind":"crypto_extremes","published_at":"2026-04-20T22:38:40.770110+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.56,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"The Innovation Game (TIG)","relevance":"high","symbol":"TIG","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"reference_asset"},{"asset_class":"unknown","name":"GoPlus","relevance":"medium","symbol":"","type":"data_provider"},{"asset_class":"platform","name":"CoinGecko","relevance":"high","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The text does not provide the full 24h range endpoints (only \u201c24h Range $1.37\u201d is shown).","The signal header mentions \u201cMarket cap rank 719\u201d and \u201ctrend score 9,\u201d but these values are not present in the cleaned article text provided.","No explicit current market cap, volume, or percentage change is included beyond the displayed price/range snippet.","The specific GoPlus contract-change capabilities are listed as examples, but the text does not confirm which capabilities are currently enabled for TIG."],"key_facts":["CoinGecko states that TIG price is calculated in real time by aggregating the latest data across 7 exchanges and 9 markets.","The aggregation uses a global volume-weighted average formula (as described in the text).","The text shows a value of 0.00001696 BTC and $0.8947, and mentions a 24h range of $1.37 (as displayed).","The text says, according to GoPlus, the contract creator can make changes to the token contract such as disabling sells, changing fees, minting, and transferring tokens.","The text includes a cautionary note: \u201cExercise caution.\u201d"],"numeric_claims":[{"label":"TIG price (USD, shown)","value":"0.8947"},{"label":"TIG price (BTC, shown)","value":"0.00001696"},{"label":"24h range (USD, shown)","value":"1.37"}],"primary_claim":"CoinGecko calculates The Innovation Game (TIG) price in real time by aggregating the latest data across 7 exchanges and 9 markets using a global volume-weighted average formula.","relevance_score":0.62,"sentiment":"mixed","source_quality":"low","summary":"The Innovation Game (TIG) price is reported as calculated in real time by aggregating data across 7 exchanges and 9 markets using a global volume-weighted average method. The text also notes a GoPlus warning that the contract creator may be able to change token contract settings such as disabling sells or changing fees.","topics":["crypto price calculation","CoinGecko methodology","token contract risk","GoPlus contract creator capabilities","TIG market/tracking"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 719, trend score 9","tickers":["TIG","TIGUSD"],"title":"Trending: The Innovation Game (TIG)","url":"https://www.coingecko.com/en/coins/the-innovation-game"}}

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