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 definition
Confirm raw ticks, bid/ask events, trades or OHLC bars and the source instrument.
Time and ordering
Define UTC boundaries, timestamp precision, sequence ordering and duplicate policy.
Quality and gaps
Document missing intervals, corrections and any backfill or normalization applied.
Export and retention
Agree 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.