Market data · deployment planning

Market Data Backfill

Backfill restores a missing range in an existing dataset; it needs a precise boundary and a reconciliation policy.

Define the missing interval

Record the last accepted event identifier or timestamp and the point where live processing resumed. Overlap the boundary deliberately when necessary, then remove duplicates using an agreed event key rather than price equality.

Reconcile before publishing

Compare source, symbol mapping and schema versions across the live and recovered data. If bars were built while events were missing, regenerate affected intervals and expose revisions to downstream chart or research consumers.

Requirements to confirm

  • Gap start and end markers
  • Stable event deduplication key
  • Mapping and schema versions
  • Affected bar revision plan

Bring the proposed instrument list, source documentation and consumer workflow to a technical discussion. The agreed integration specification defines coverage, fields, usage permissions and acceptance tests.

Integration brief

Market Data Backfill: what to agree before connecting

Dataset definitionConfirm raw ticks, bid/ask events, trades or OHLC bars and the source instrument.
Time and orderingDefine UTC boundaries, timestamp precision, sequence ordering and duplicate policy.
Quality and gapsDocument missing intervals, corrections and any backfill or normalization applied.
Export and retentionAgree format, pagination, permitted storage and the consumers allowed to use the dataset.

Keep history traceable to its source

Historical data for your instrument universe needs an instrument definition and provenance. Tick history, aggregated bars and replay events are different outputs. Record which prices form each bar, how gaps are represented and whether corrections can change an earlier result.

What to test

  • Replay a known interval and compare event order and instrument identity.
  • Inspect a quiet interval and a deliberately missing interval separately.
  • Verify candle boundaries or replay timing against the documented rule.

Related archive workflows

Review event storage, bar construction and recovery of historical ranges.

Find your market-data solution