HistData CSV Formatter & Candle Synthesizer
Files stay in your browser. Pure client-side streaming engine aggregates raw ticks and resamples M1 bars into M1, M5, M15, M30, or H1 candles with instant chart preview.
Select target candle resolution. Raw tick or M1 data will be aggregated into your chosen timeframe.
The file you choose must be 50 MB or less. Text inside a ZIP is checked after unpacking, and that text must also be 50 MB or less. Tick files stop at 500,000 ticks.
HistData ASCII, MT, and tick times are EST without DST (UTC−5) and are converted to UTC. Ticker OHLC times are kept as written and labeled UTC.
How Pure Client-Side Tick-to-Candle Synthesis Works
Parsing, a fixed +5 hour shift to UTC, and candle aggregation run in the browser. The file is not uploaded.
Decompresses multi-megabyte ZIP archives directly in client memory via fast deflate streaming, bypassing backend upload queues.
Adds 5 hours. HistData ASCII timestamps are US Eastern Standard Time all year, with no daylight-saving switch to 4 hours.
Buckets ticks by floor(T_utc / ΔT) * ΔT, computing Open (first tick), High (max Bid), Low (min Bid), Close (last tick), and Volume.
Detects chronologically reversed timestamps, purges duplicate minutes, drops corrupted rows, and flags weekend/holiday liquidity gaps.
Financial Tick & Bar Data Format Compatibility Matrix
Cross-platform data format specifications supported by BarionQuant, MetaTrader, and Python.
| Target Platform / Framework | Required Timezone | Delimiter | Standard Header Format | Typical Ingestion Feeds | Timeframe Aggregation | Offline Practice Replay |
|---|---|---|---|---|---|---|
| BarionQuant Desktop | UTC (Auto-aligned) | Comma (,) | time,open,high,low,close,volume | 1-Minute M1, Tick CSV, Zip | M1, M5, M15, M30, H1 | ✅ Direct Local Data Center |
| MetaTrader 4 / MT5 | Server Broker Time | Comma (,) | Date,Time,Open,High,Low,Close,Vol | HST, FXT, History Center CSV | Period Conversion Scripts | ⚠️ Broker Connected Only |
| Python / Backtrader | UTC / Timestamp | Comma (,) | datetime,open,high,low,close,volume | Pandas DataFrame CSV | df.resample() | ❌ Code script execution only |
| HistData Raw Source | US Eastern Standard Time, +5h, no DST | Semicolon (;) | None (Raw text rows) | Raw tick/M1 archive files | Raw ticks or M1 only | ❌ Incompatible without formatter |
Frequently Asked Questions About HistData Formatting
Parsing, the fixed +5 hour UTC shift, and what stays in the browser.
What timezone does this page use for HistData timestamps?▾
Does this page delete weekend rows?▾
Are my uploaded tick or M1 historical files sent to your servers?▾
Can I use the formatted CSV with MetaTrader 4 / MetaTrader 5 History Center?▾
How do I import this formatted CSV into BarionQuant Desktop?▾
How does tick-to-candle synthesis calculate Open, High, Low, Close, and Volume?▾
Can I convert 1-minute (M1) historical data into M5, M15, M30, or H1 candles?▾
Related Professional Trader Tools
Explore quantitative calculators to manage position risk, drawdown recovery, and market liquidity.
Prop Firm Challenge Risk & Drawdown Calculator
Estimate the daily loss buffer, overall floor, and lot size from the percentages you enter. Presets are starting points, not a live copy of any firm's rulebook.
Position Size Calculator
Calculate exact lot sizes, risk in cash, and pip values based on your account size and stop loss.
Drawdown & Recovery Calculator
Calculate the asymmetric gain required to recover from losses, R-multiples needed, and mathematical risk of ruin.
Trading Session Overlap Clock
Visual 24-hour timeline of Sydney, Tokyo, London, and New York market hours. Pinpoint peak volatility overlap windows.
Pip Value Calculator
See what one pip is worth in your account currency before you size a practice ticket.
Practice P/L Calculator
Cash result for the entry, exit, and size you type. Not a broker fill and not a live quote.
Binance Historical Data Formatter & Candle Synthesizer
Clean Binance Vision 11-column klines into M1, M5, M15, M30, or H1 in the browser. The file is not uploaded.
Crypto Liquidation Price & Margin Calculator
Estimate a Binance USD-M isolated liquidation price for BTC, ETH, and SOL from a built-in bracket table. Not a live exchange quote.
Binance funding-rate worksheet
Multiply the 8-hour rate you type by the days you type. Simple annualization. Not the live exchange rate.
Trader hindsight self-check
Ten self-report questions and a peeking index from your answers. Not a forecast of live results.
Replay Rubric Generator
Write the three public rubric lines after a sitting and copy them as Markdown.
Calculated your position risk?
Put your rules to the test in BarionQuant Desktop. Rehearse entries, stop loss execution, and position management on local EURUSD & XAUUSD chart replays without risking real capital.
The rule behind this number Import one practice session