Resources for your own records

OHLCV Timestamp, Gap and Duplicate Resources

Find duplicate times, missing intervals and inconsistent candles before analysis.

An indicator can look precise even when its candle file contains repeated or impossible rows. This validator audits timestamps, OHLC relationships and volume, while checking gaps on unique valid times. It preserves the original row order and identifies data issues instead of manufacturing replacement candles.

Calculate and inspect

OHLCV Timestamp, Gap and Duplicate Validator

Flag repeated timestamps, missing fixed intervals and inconsistent candle rows without inventing bars.

The hypothetical file contains times 00:00, 00:01, a repeated 00:01 and 00:03 UTC at a one-minute interval. It has one duplicate timestamp and one missing interval. Its last row also has high 99 while open and close are 100, so one OHLC row is invalid. Four input rows remain visible in the audit.

Open the worksheet

Choose references

10 Services for Checking OHLCV Data

Candle-quality review starts with schema and timestamp semantics. Chart exports, exchange developer documents and libraries describe different coverage and data behavior; each needs to be understood before a raw file becomes an analytical series.

Compare documented roles using open-time identifiers, unfinished latest bars, time-zone semantics, missing-period meaning, volume units. The Telegram channel we promote is disclosed in the first entry.

Read the comparison

Prepare useful inputs

Paste open-time timestamps with explicit UTC offsets, positive OHLC prices and nonnegative volume. Specify the expected interval in minutes and whether the final bar is open, closed or unknown. Know what the source's volume field measures; the worksheet does not guess its denomination.

Read results in their proper scope

A missing interval identifies a gap in this file, not its cause. No-trade periods, extraction limits and provider behavior need separate investigation. An open or unknown latest-bar state is flagged; structural checks cannot prove that the final bar is complete or that the history is exhaustive.

The worked example and method can be read without JavaScript. Running the calculator requires JavaScript; its form values remain in the browser, with no account connection or quote lookup for calculation.

Official sources and scope

The sources document formats, mechanisms or record workflows. The arithmetic and editorial comparison on this page use the supplied worksheet definitions.

CCXT official manual
OHLCV gaps can mean no trades rather than erroneous data; developer library and schema reference.
Reference checked 2026-10-01. Consult the source for current product rules.
Binance official kline schema
Klines have open-time identifiers, intervals and explicit time-zone semantics.
Reference checked 2026-10-01. Consult the source for current product rules.
Kraken OHLC schema
Latest record is an unfinished timeframe; endpoint history is limited.
Reference checked 2026-10-01. Consult the source for current product rules.
Coinbase candles schema
Product candle records grouped into time buckets; developer documentation.
Reference checked 2026-10-01. Consult the source for current product rules.
OKX API schemas
Order-book quantities, instrument units and candle completion states; developer documentation.
Reference checked 2026-10-01. Consult the source for current product rules.
TradingView chart CSV
Export loaded chart data to CSV; not all historical data are automatically included.
Reference checked 2026-10-01. Consult the source for current product rules.