Binance Spot OHLCV: Null vs Zero - Handle Missing Fields Correctly
Binance spot klines carry twelve fields, including trade count and taker-buy volume. Know which ones can legitimately be zero and how missing intervals appear.
Short answer
Binance's spot klines endpoint returns 12-element arrays: open time, open, high, low, close, volume, close time, quote asset volume, number of trades, taker buy base volume, taker buy quote volume and an ignore field; klines are identified by open time, and a timeZone parameter changes interval boundaries (startTime and endTime stay UTC). The documentation reviewed does not state whether intervals with no trades are returned or omitted, so check your data: if consecutive open times skip, treat skipped intervals as missing; if a kline has number of trades 0, treat it as a measured no-trade interval.
Fields and what missing values mean
| Field | Null / absent means | Zero / empty means |
|---|---|---|
| Skipped open time | Interval missing from response | — |
| Volume / quote volume | — | Zero: no volume |
| Number of trades | — | Zero: no trades |
| Taker buy volume | — | Zero: no taker buys |
| timeZone | Default UTC (0) | — |
Review Binance Spot OHLCV with bar replay before using it live.
Open ChartsPod replayHandling policy
Illustrative: a dataset built with timeZone '8' and merged with one built in UTC produced daily candles that didn't line up. Recording the parameter with each file avoided the confusion on the next rebuild.
Conclusion
Related: Crypto OHLCV Timestamps: Candle Open Time vs Close Time, Crypto Backtesting With Missing Candles: Reject or Repair the Dataset?.
Binance's spot klines endpoint returns 12-element arrays: open time, open, high, low, close, volume, close time, quote asset volume, number of trades, taker buy base volume, taker buy quote volume and an ignore field; klines are identified by open time, and a timeZone parameter changes interval boundaries (startTime and endTime stay UTC). The documentation reviewed does not state whether intervals with no trades are returned or omitted, so check your data: if consecutive open times skip, treat skipped intervals as missing; if a kline has number of trades 0, treat it as a measured no-trade interval.
Put Binance Spot OHLCV next to price, flow and positioning in one workspace.
Open a ChartsPod workspaceQuestions readers ask
How are Binance klines identified?
By open time.
What does number of trades 0 mean?
No trades in that interval.
Does timeZone change startTime?
No; startTime and endTime are always UTC.
Sources and methodology
Field definitions come from DEX Screener's API reference, CoinGecko's onchain API documentation and Binance's Spot API documentation, read 17 October 2026. Where a schema was not visible in the documentation, this guide says so and describes defensive handling rather than asserting field behaviour.
- Binance Spot API: market data endpoints (klines) — 12-field klines, open-time identity, timeZone parameter.
This article explains research tools and workflows. It is not financial advice, does not recommend buying or selling any asset and does not predict prices. Crypto derivatives carry a risk of rapid and total loss of margin.
CHARTSPOD EDITORIAL EDITION · RESEARCH AND EDUCATION ONLY · NOT FINANCIAL ADVICE.