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/leo-token","as_of":"2026-04-21T03:09:54.871544+00:00","canonical_url":"https://www.coingecko.com/en/coins/leo-token","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/leo-token","article_chars":550,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3d4188d591228ba6","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/leo-token","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:09:22.432938+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest LEO Token price, market cap, trading volume, news and more with CoinGecko's live LEO/USD price chart and popular cryptocurrency price tracker.","fetched_title":"LEO Token Price: LEO/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/leo-token","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/leo-token","source_event_id":"evt_34d3252c09ed","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"41316d0972d11745","kind":"crypto_extremes","published_at":"2026-04-21T03:09:59.439155+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.64,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"LEO Token","relevance":"high","symbol":"LEO","type":"cryptocurrency_token"},{"asset_class":"platform","name":"CoinGecko","relevance":"medium","symbol":"","type":"data_provider"},{"asset_class":"web_resource","name":"LEO Transparency Dashboard","relevance":"medium","symbol":"","type":"dashboard"},{"asset_class":"exchange","name":"Bitfinex","relevance":"medium","symbol":"","type":"exchange"}],"event_type":"price_action","information_gaps":["The article text does not specify the exact timestamp/time window for the 24h change beyond \u201c24h.\u201d","The article text does not provide the currency context for the mcap value (e.g., USD) beyond what is implied.","No explicit confirmation is provided that the 24h range corresponds exactly to the same 24h period as the 1.94% change.","The text mentions BTC/ETH equivalents (0.0001373 BTC, 0.004486 ETH) but does not state whether these correspond to the current price or another point in time within the snippet."],"key_facts":["LEO Token (LEO) 24h change is stated as 1.94%.","A 24h range is shown as $10.29 to $10.39.","The price is described as calculated in real-time by aggregating latest data across 15 exchanges and 21 markets using a global volume-weighted average formula.","The text states a \u201cLEO Transparency Dashboard\u201d provides token holders verifiable insights into the token buyback process.","A link is provided: https://leo.bitfinex.com/."],"numeric_claims":[{"label":"LEO 24h change","value":"1.94%"},{"label":"LEO 24h range (low)","value":"$10.29"},{"label":"LEO 24h range (high)","value":"$10.39"},{"label":"mcap","value":"9515711009"}],"primary_claim":"LEO Token (LEO) increased by 1.94% over the past 24 hours, with a 24h price range of $10.29 to $10.39.","relevance_score":0.62,"sentiment":"positive","source_quality":"low","summary":"LEO Token (LEO) price moved up 1.94% over the last 24 hours, with a stated 24h range around $10.29\u2013$10.39. The text also references CoinGecko\u2019s price calculation method and a LEO Transparency Dashboard related to a token buyback process.","topics":["crypto price change","24h range","price calculation methodology","token buyback transparency dashboard"]},"source":"CoinGecko Movers","source_domain":"coingecko.com","summary":"24h change 1.94% \u00b7 mcap 9515711009","tickers":["LEO","LEOUSD"],"title":"LEO Token (LEO) moved 1.94% (24h)","url":"https://www.coingecko.com/en/coins/leo-token"}

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