SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","enrichment":{"aggregator_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","article_chars":4967,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6beb01c1a3e0665e","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:55:26.719329+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin and Ethereum are trading higher as open interest rises, providing some optimism about investors' risk-on appetite.","fetched_title":"Bitcoin and Ethereum Open Interest Rises, Signaling Renewed Risk Appetite: CryptoQuant - Decrypt","final_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite","source_event_id":"evt_1d4193de9982","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"87cf613f9b1e7a5c","kind":"crypto_extremes","published_at":"2026-04-09T20:12:48+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"high","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"unknown","name":"CryptoQuant","relevance":"high","symbol":"","type":"data_provider"}],"event_type":"price_action","information_gaps":["The article text provided does not include the specific open interest figures (e.g., magnitude, timeframe, or percentage change) for BTC and ETH.","No explicit timeframe for the open interest rise is included in the provided text.","The exact wording/metrics from CryptoQuant beyond the provided summary are not present in the cleaned article text."],"key_facts":["BTC is trading at $72,292.00, up 2.16%.","ETH is trading at $2,200.60, up 1.19%.","The signal states that Bitcoin and Ethereum open interest is rising.","The signal attributes the interpretation (renewed risk appetite) to CryptoQuant."],"numeric_claims":[{"label":"BTC price change","value":"2.16%"},{"label":"BTC price","value":"$72,292.00"},{"label":"ETH price change","value":"1.19%"},{"label":"ETH price","value":"$2,200.60"}],"primary_claim":"CryptoQuant says rising Bitcoin and Ethereum open interest is signaling renewed risk appetite as BTC and ETH trade higher.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Bitcoin and Ethereum prices are higher while CryptoQuant reports that their open interest is rising, which it interprets as renewed risk appetite.","topics":["open interest","risk appetite","Bitcoin","Ethereum","crypto derivatives"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Bitcoin and Ethereum are trading higher as open interest rises, providing some optimism about investors' risk-on appetite.","tickers":[],"title":"Bitcoin and Ethereum Open Interest Rises, Signaling Renewed Risk Appetite: CryptoQuant","url":"https://decrypt.co/363865/bitcoin-ethereum-open-interest-rises-renewed-risk-appetite"}

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