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/openvpp-2","as_of":"2026-04-08T09:32:58.864102+00:00","canonical_url":"https://www.coingecko.com/en/coins/openvpp","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/openvpp-2","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_26697aef8fb970a7","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/openvpp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T09:36:25.836024+00:00","extraction_method":"heuristic","fetched_description":"Track the latest OpenVPP price, market cap, trading volume, news and more with CoinGecko's live OVPP/USD price chart and popular cryptocurrency price tracker.","fetched_title":"OpenVPP Price: OVPP/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/openvpp","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/openvpp-2","source_event_id":"evt_2e180e3400ec","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f3807168d70cf52","kind":"crypto_extremes","published_at":"2026-04-08T09:33:04.824741+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"OpenVPP","relevance":"high","symbol":"OVPP","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The snippet does not explicitly state the 24h price change percentage for USD specifically (only many other currencies are shown).","No timestamp for the \u201cTrending\u201d status or the live price is provided in the extracted text.","No additional fundamentals/news about OpenVPP are included beyond the trending/price fields."],"key_facts":["CoinGecko trending item: OpenVPP (symbol: OVPP)","Market cap rank: 974","Trend score: 0","CoinGecko provides a live price for OVPP/USD: 0.014534699894613817 (USD)","CoinGecko shows OVPP 24h price change percentage in multiple currencies; the USD value is not explicitly shown in the provided text snippet","The page includes a CoinGecko site-wide market overview (e.g., total market cap and BTC/ETH dominance), but these are not stated as OVPP-specific"],"numeric_claims":[{"label":"market_cap_rank","value":"974"},{"label":"trend_score","value":"0"},{"label":"price_USD","value":"0.014534699894613817"},{"label":"price_btc","value":"0.0000002024341734481892"},{"label":"24h_price_change_percentage_example_AED","value":"26.48861555065728"}],"primary_claim":"OpenVPP (OVPP) is trending on CoinGecko with market cap rank 974 and trend score 0.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section lists OpenVPP (OVPP) with market cap rank 974 and a trend score of 0. The page also shows OVPP\u2019s live price and its 24h price change percentage across currencies.","topics":["crypto trending","OpenVPP","OVPP price","market cap rank","24h price change"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 974, trend score 0","tickers":["OVPP","OVPPUSD"],"title":"Trending: OpenVPP (OVPP)","url":"https://www.coingecko.com/en/coins/openvpp"}

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