ODCS v3.2.0Draft · 0.1.0licensed-datafuturescme-grouptick

US Futures Trade and Quote

Tick-level trades and best bid/ask quote updates for CME-listed futures, with UTC and Chicago timestamps, an aggressor-side event type and flags; used for microstructure, execution research and backtesting.

12 columns in delivery order · file or table name fut_taq. Types are ODCS logical types; the format line shows how values are written.

Schema columns with type, key role and description
ColumnTypeKeyDescription
UTCDatedateyyyymmddKey 1 · Partition · RequiredUTC calendar date of the event; the daily file is one UTC day (00:00-24:00). Guide wording: trading date (UTC).

Source: vendor guide and sample

UTCTimetimeHHMMSSmmmKey 2 · RequiredEvent time in UTC, 9 digits HHMMSSmmm with no separators (ms precision in samples), e.g. 220000003 = 22:00:00.003.

Unit: ms · Source: vendor guide and sample

LocalDatedateyyyymmddChicago (CT) calendar date of the event; can differ from UTCDate and does not roll at the 17:00 CT session start.

Source: vendor guide and sample

LocalTimetimeHHMMSSmmmEvent time in Chicago local time (UTC-6 winter, UTC-5 during DST), same 9-digit HHMMSSmmm layout.

Unit: ms · Source: vendor guide and sample

TickerstringKey 3 · Partition · RequiredContract ticker, max 20 chars: base symbol + month code + last digit of expiry year (e.g. ESZ3); spreads use a LEG-LEG form.

Source: vendor guide and sample

SecurityIDstringnumeric stringInstrument identifier. Guide calls it an internal algoseek security ID (the Multiple Depth guide calls it a CME ID). Sample values: 3445, 314863, 634394.

Source: vendor guide and sample

TypeMaskintegeri64Key 4 · RequiredEvent type as an 8-bit mask: bits 0-4 message type, bit 5 final, bit 6 sell/offer side, bit 7 buy/bid side. Guide's field table says 'Not in use' but Appendix A defines it.

Source: vendor guide and sample

Typestring · enum (14)Event type label: quote side, trade with aggressor side, or statistic (opening/settlement/volume/open interest/empty book). Any label may carry an IMPLIED prefix.

Source: vendor guide and sample

14 allowed values
QUOTE BID
Exchange's best bid quote
QUOTE SELL
Exchange's best sell (ask) quote
TRADE AGRESSOR ON BUY
Trade whose initiator was on the buy side
TRADE AGRESSOR ON SELL
Trade whose initiator was on the sell side
TRADE
Trade with unknown initiator (side cannot be determined)
OPENING PRICE
First trade for the opening or re-opening of the instrument
FIXING PRICE
Volume-weighted average price for the nearby (front month) contract
TRADE VOLUME
Contracts traded in the instrument for the trading session
SETTLEMENT PRICE
Official price set at a point in the trading day; Quantity carries the referenced trade date (yyyymmdd)
OPEN INTEREST
Contracts not yet offset/fulfilled as of the previous trading day; sent before session start
EMPTY BOOK
No current bid or ask (feed reset, maintenance or halt)
EMPTY BOOK BID
Empty-book variant named in the guide
EMPTY BOOK FINAL
Empty-book variant named in the guide; the label seen in samples
EMPTY BOOK BID FINAL
Empty-book variant named in the guide
PricenumberKey 5 · RequiredOpening, trade, bid/ask or settlement price by event type, 6-decimal string; 0.000000 on empty-book, trade-volume and open-interest rows (sample).

Source: vendor guide and sample

Quantityintegeri64Key 6 · RequiredContracts traded or quoted at this price. SETTLEMENT PRICE rows carry the referenced trade date (yyyymmdd); TRADE VOLUME and OPEN INTEREST rows carry the count (sample).

Unit: contracts · Source: vendor guide and sample

Ordersintegeri64Key 7 · RequiredCustomer orders at the price level. Guide says to ignore it for trades (zero before 2015-11-22, when the feed moved from FAST/FIX to MDP).

Unit: count · Source: vendor guide and sample

Flagsinteger · enum (6)i64Key 8 · RequiredCondition flag for the event. 2 and 4 mark session high/low rows (Quantity 0 in samples); 8 = calculated price with no contracts; 1 = implied; 16 = opening.

Source: vendor guide and sample

6 allowed values
0
Regular
1
Implied (derived from spread/other relationships, not an outright event)
2
SHFlag - marks the session high price
4
SLFlag - marks the session low price
8
CalculatedPrice - calculated price with no contracts actually traded; exclude from bars/backtests
16
Opening

Contracts follow the Open Data Contract Standard (Bitol, LF AI & Data).

Vendor names are trademarks of their owners.