Binance Historical Data Export & Format Guide
Transform raw Binance historical dumps into clean, local offline replay sessions in seconds.
#01Raw Platform Data Specifications
#02How to Export Historical Data from Binance (USD-M & Spot)
Visit data.binance.vision in your browser without logging in.
Navigate to 'data' → 'futures' → 'um' (USD-M) → 'monthly' → 'klines' → select your symbol (e.g. BTCUSDT) → '1m'.
Download the required monthly ZIP archives directly (e.g. BTCUSDT-1m-2025-01.zip).
Unzip the CSV file to your local drive.
#03Raw Header vs Standardized Header Mapping
| Raw Platform Column | Target Standard Column | Conversion Notes |
|---|---|---|
| open_time (1672531200000) | time (2025-01-01 00:00:00) | Binance uses 13-digit millisecond epoch timestamps; convert to ISO or standard UTC strings. |
| open, high, low, close | open, high, low, close | Standard floating-point prices; ensure proper decimal point format without thousands separators. |
| volume | volume | Base-asset volume on the candle. This is not an order-book ladder. |
#04Common Import Pitfalls & File Glitches
Headerless CSVs: Official Binance Vision dumps often omit column header rows; first row begins directly with numerical data.
13-digit Millisecond Epoch: Older chart software expects 10-digit seconds or readable datetime strings, causing missing-bar crashes.
Unsorted Daily Files: Merging multiple daily files from Binance can lead to out-of-order timestamps; sorting is mandatory.
#05Frequently Asked Questions
Do I need a Binance API key to get historical data?+
No! Official Binance Vision archives (data.binance.vision) are completely public and free to download without API keys or account registration.
How does BarionQuant solve Binance headerless CSV issues?+
Our free built-in Binance CSV Formatter tool automatically detects headerless formats and generates standardized OHLCV files ready for 1-click desktop import.