{"key":"historical-derivatives-data","generated_at":1789504876.3374224,"calculated_at":1789504876.3374224,"updated":1789504508.2293527,"source_observed_at":1789504508.2293527,"observation_start":1788930000.0,"observation_end":1789504200.0,"temporal_start":1788930000.0,"temporal_end":1789504200.0,"source_interval":"historical","calculation_refresh_seconds":21600,"source_refresh_seconds":21600,"refresh_seconds":21600,"stale":false,"source":"CoinNudge read-only archive catalog","window":"Actual stored derivatives coverage since September 2026","limitation":"Collection begins in September 2026 and venue/contract windows differ. Expected rows are calculated separately inside each contract's own first-to-last 15-minute range; this does not prove pre-listing or delisted periods should exist. Funding nulls remain null. Hyperliquid five-minute OI is shown separately because its changing universe lacks one stable denominator.","calculation_version":"coinnudge-derivatives-coverage-2.0","evidence_columns":[["dataset","Dataset family"],["venue","Venue"],["interval","Interval"],["coverage_basis","Coverage basis"],["symbols","Symbols"],["contracts","Contracts"],["observed_rows","Observed rows"],["expected_rows_within_each_contract_range","Expected rows in each contract range"],["missing_intervals","Missing intervals"],["interval_coverage_pct","Interval coverage %"],["funding_null_rows","Funding null rows"],["oi_null_rows","OI null rows"],["first_event","First event UTC"],["last_event","Last event UTC"],["fields","Fields and boundary"]],"metric_cards":[["339,671","normalized 15m rows"],["4","15m venues"],["224,280","separate 5m OI rows"],["Since Sep 2026","actual collection era"]],"summary":{"answer":"CoinNudge currently stores 339,671 normalized 15-minute derivative observations across 4 venues, plus a separately counted Hyperliquid five-minute OI archive. Research snapshots, signal outcomes and liquidation events are not added to this total because they are different units of observation."},"items":[{"dataset":"derivative_market_history","venue":"Coinbase International","interval":"15m","coverage_basis":"immutable Parquet archive","symbols":77,"contracts":77,"observed_rows":41212,"expected_rows_within_each_contract_range":43227,"missing_intervals":2015,"interval_coverage_pct":95.33856154718116,"funding_null_rows":0,"oi_null_rows":0,"first_event":1788930000.0,"last_event":1789497900.0,"fields":"funding_hourly_pct, oi_usd, price, volume_24h_usd","calculation_version":"coinnudge-derivatives-coverage-2.0"},{"dataset":"derivative_market_history","venue":"Hyperliquid","interval":"15m","coverage_basis":"immutable Parquet archive","symbols":178,"contracts":178,"observed_rows":112496,"expected_rows_within_each_contract_range":112496,"missing_intervals":0,"interval_coverage_pct":100.0,"funding_null_rows":0,"oi_null_rows":0,"first_event":1788930000.0,"last_event":1789497900.0,"fields":"funding_hourly_pct, oi_usd, price, volume_24h_usd","calculation_version":"coinnudge-derivatives-coverage-2.0"},{"dataset":"derivative_market_history","venue":"MEXC","interval":"15m","coverage_basis":"immutable Parquet archive","symbols":242,"contracts":295,"observed_rows":121028,"expected_rows_within_each_contract_range":137459,"missing_intervals":16431,"interval_coverage_pct":88.04661753686554,"funding_null_rows":108393,"oi_null_rows":0,"first_event":1788930000.0,"last_event":1789497900.0,"fields":"funding_hourly_pct, oi_usd, price, volume_24h_usd","calculation_version":"coinnudge-derivatives-coverage-2.0"},{"dataset":"derivative_market_history","venue":"OKX","interval":"15m","coverage_basis":"immutable Parquet archive","symbols":157,"contracts":157,"observed_rows":64935,"expected_rows_within_each_contract_range":74253,"missing_intervals":9318,"interval_coverage_pct":87.45101208031998,"funding_null_rows":54823,"oi_null_rows":0,"first_event":1788930000.0,"last_event":1789497900.0,"fields":"funding_hourly_pct, oi_usd, price, volume_24h_usd","calculation_version":"coinnudge-derivatives-coverage-2.0"},{"dataset":"oi_5m","venue":"Hyperliquid","interval":"5m","symbols":null,"contracts":null,"coverage_basis":"immutable Parquet archive catalog","observed_rows":224280,"expected_rows_within_each_contract_range":null,"missing_intervals":null,"interval_coverage_pct":null,"funding_null_rows":null,"oi_null_rows":null,"first_event":1789126500.0,"last_event":1789504200.0,"fields":"observed five-minute OI buckets; gap denominator not published across a changing universe","calculation_version":"coinnudge-derivatives-coverage-2.0"}],"observations":[{"venue":"Coinbase International","record_key":"Coinbase International:1000BONK-PERP:1789497900","symbol":"BONK","event_time":1789497900.0,"observed_at":1789498895.5597045,"ingested_at":1789498895.5597045,"contract":"1000BONK-PERP","funding_hourly_pct":0.0009,"oi_usd":71475.52740400001,"price":0.002609,"volume_24h_usd":24906.500872,"calculation_version":"coinnudge-derivatives-coverage-2.0"},{"venue":"Hyperliquid","record_key":"Hyperliquid:0G-PERP:1789497900","symbol":"0G","event_time":1789497900.0,"observed_at":1789498895.559256,"ingested_at":1789498895.559256,"contract":"0G-PERP","funding_hourly_pct":0.00125,"oi_usd":821508.3919680001,"price":0.187484,"volume_24h_usd":264750.1583699998,"calculation_version":"coinnudge-derivatives-coverage-2.0"},{"venue":"MEXC","record_key":"MEXC:0G_USDT:1789497900","symbol":"0G","event_time":1789497900.0,"observed_at":1789498895.557676,"ingested_at":1789498895.557676,"contract":"0G_USDT","funding_hourly_pct":null,"oi_usd":1784095.9744000002,"price":0.1874,"volume_24h_usd":268219.9972,"calculation_version":"coinnudge-derivatives-coverage-2.0"},{"venue":"OKX","record_key":"OKX:0G-USDT-SWAP:1789497900","symbol":"0G","event_time":1789497900.0,"observed_at":1789498895.5558927,"ingested_at":1789498895.5558927,"contract":"0G-USDT-SWAP","funding_hourly_pct":null,"oi_usd":695077.5,"price":0.1875,"volume_24h_usd":1849768.3125,"calculation_version":"coinnudge-derivatives-coverage-2.0"}],"health":[]}