Tick Data

Tick data records every round-lot trade in consecutive order, exactly as it happened. Each line is one trade of 100 shares or more, with its real price and volume, alongside the prevailing National Best Bid and Offer (the bid and ask) at the moment the trade was reported. For US stocks and ETFs, Kibot tick data is available since September 2009. This article describes the standard six-field layout and how the bid/ask quotes are sourced.

Field Definitions

Each line in a tick file is a comma-separated record of six fields:

Field # Name Format Description
1 Date MM/DD/YYYY Trade date
2 Time HH:MM:SS Timestamp, to the second
3 Last Price Decimal Price at which the trade executed
4 Bid Price Decimal NBBO bid price at time of trade
5 Ask Price Decimal NBBO ask price at time of trade
6 Last Size Integer Number of shares or contracts traded

A sample row (IVE):

08/31/2026,09:30:00,235.77,235.69,235.77,10807

The Bid and Ask fields reflect the National Best Bid and Offer (NBBO), the highest bid and lowest ask across all US exchanges at the moment the trade was reported. Under SEC Regulation NMS, brokers must execute customer orders at or better than the NBBO. These consolidated quotes are disseminated through the Securities Information Processor (SIP), which aggregates quote data from all participating exchanges into a single national best bid and offer. The values stored in Kibot files come directly from that consolidated stream.

Availability

Standard tick data is available for US stocks and ETFs since September 2009. Files are updated daily and reflect every round-lot trade (100 shares or more) reported through the consolidated tape, in consecutive order, with the NBBO bid and ask attached to each print.

Key Takeaways

  • Standard tick data is the default tick format: every round-lot trade in consecutive order, with real price and volume.
  • Each row is six comma-separated fields: date, time (HH:MM:SS, to the second), price, bid, ask, volume.
  • The bid and ask are the NBBO, the consolidated national best bid and offer at the moment the trade was reported.
  • Available for US stocks and ETFs since September 2009, updated daily.
  • An experimental millisecond-timestamp variant exists for stocks, ETFs and futures; it is not officially supported. For most work the standard format is the right choice.

Millisecond timestamps (experimental)

This is an experimental feature and is not officially supported. Kibot offers a variant of tick data with millisecond-precision timestamps. Use it with caution: it is not a recommended upgrade.

What it changes: the layout is the same as standard tick data, and only the time field changes, to HH:MM:SS.mmm instead of HH:MM:SS. The millisecond set also includes odd lots (trades under 100 shares), so it contains more trades than standard tick data.

Coverage and freshness: the millisecond set is available for US stocks and ETFs since September 2014, compared with September 2009 for standard tick data. Fewer servers are assigned to it, so it is updated less promptly than standard tick data and may have gaps or be less complete.

Futures: millisecond timestamps are also available for futures, but they are not meaningful there. The CME does not provide true millisecond execution times, so the fractional part of the timestamp is only the time the message was received from the exchange, not the time the trade actually executed. Relying on it as an execution time would be inaccurate. Standard and "millisecond" futures data therefore show effectively the same values, and the standard format is the one to use.

For most work, including any analysis that depends on accurate timestamps, the standard tick format described above is the recommended default.

  • Data format reference: full field layouts for every Kibot product, including standard tick
  • Data completeness: how missing bars, halts, and shortened sessions manifest in tick data
  • Adjusted vs unadjusted data: stock and ETF tick data is adjusted for splits and dividends by default, like minute and daily data; unadjusted and split-only versions are available
  • Trading hours: regular session boundaries for US equities and futures