SavantCapital/binance-futures-ohlcv-2018-2026

# 1. 解压并恢复 schema
zstd -d schema_*.sql.zst -c | psql -h localhost -p 5433 -U postgres -d market_data

# 2. 恢复 K线数据
zstd -d candles_1m_main4_*.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.candles_1m FROM STDIN WITH (FORMAT binary)"

# 3. 恢复期货指标
zstd -d futures_metrics_main4_*.bin.zst -c | psql -h localhost -p 5433 -U postgres -d market_data \
    -c "COPY market_data.binance_futures_metrics_5m FROM STDIN WITH (FORMAT binary)"

chmod +x restore_main4_*.sh
./restore_main4_*.sh

-- 查看 BTC 最近数据
SELECT * FROM market_data.candles_1m 
WHERE symbol = 'BTCUSDT' 
ORDER BY bucket_ts DESC 
LIMIT 10;

-- 统计各币种数据量
SELECT symbol, COUNT(*), MIN(bucket_ts), MAX(bucket_ts)
FROM market_data.candles_1m 
GROUP BY symbol;

-- BTC 日K聚合
SELECT 
    time_bucket('1 day', bucket_ts) AS day,
    FIRST(open, bucket_ts) AS open,
    MAX(high) AS high,
    MIN(low) AS low,
    LAST(close, bucket_ts) AS close,
    SUM(volume) AS volume
FROM market_data.candles_1m
WHERE symbol = 'BTCUSDT'
GROUP BY day
ORDER BY day DESC;