Crypto Tool
Binance Historical Data Formatter & Candle Synthesizer
The file is read in this browser and is not uploaded. Turn a public Binance 11-column kline file into M1, M5, M15, M30, or H1, and preview the candles.
A worksheet for public klines. Not a broker. The file is not uploaded and the page does not connect to an exchange.
Replay Binance USD-M bars on this PC
Put the cleaned CSV in the BarionQuant Desktop data folder on this PC. Free is the latest published BTC/ETH month on H1 and D1. One-minute history is Pro. SOL and older months are Standard or Pro. After sign-in, replay can stay on this PC for up to 72 hours. Playback follows the bars. No exchange API key.
Frequently Asked Questions About Binance Historical Data Formatting
Parsing, column stripping, resampling, and offline replay capabilities.
What is the 11-column Binance Vision data format?▾
Binance official public archives (data.binance.vision) export candlestick rows with 11 to 12 fields: open_time, open, high, low, close, volume, close_time, quote_asset_volume, number_of_trades, taker_buy_base_volume, taker_buy_quote_volume, and ignore. This tool strips away non-essential telemetry and extracts clean standard OHLCV.
Are my uploaded crypto historical files sent to your servers?▾
No. The file is read, unpacked, and calculated in this browser. It is not uploaded.
How does this tool resample 1-minute (1m) data into higher timeframes?▾
Inside each bucket, open is the first bar's open, high is the highest high, low is the lowest low, close is the last bar's close, and volume is the sum.
Can I use this cleaned CSV with TradingView or Python backtesting frameworks?▾
The columns are UTC time, open, high, low, close, and volume. Whether another program accepts the file depends on that program's CSV rules.
How do I load this formatted data into BarionQuant Desktop?▾
Download the CSV and put it in the desktop data folder on this PC. Playback follows the bars in the file. Free is the latest published BTC/ETH month on H1 and D1. One-minute history is Pro.
Does Binance historical data include funding rates or liquidation events?▾
A kline file has price and volume. Funding is estimated on the separate calculator from the rate you type. Desktop replay does not deduct funding on the chart and does not simulate slippage.
Why practice crypto replay offline instead of watching live charts?▾
Recorded bars can be replayed. This page does not say the free plan includes a year of one-minute data, and it does not say replay can leave this PC indefinitely. After sign-in, replay can stay on this PC for up to 72 hours.