ODCS v3.2.0Draft · 0.1.0licensed-dataoptions-on-futurescme-grouptick

US Future Options Trade Only

Tick-level trades for CME-listed options on futures, built by filtering the quote events out of the TAQ feed; each row has price, quantity, aggressor side and flags for trade and trade-adjacent statistic events.

16 columns in delivery order · file or table name fut_opt_trades. 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 as HHMMSSmmm (ms). In this sample leading zeros are dropped (100461 = 00:01:00.461); left-pad to 9 digits.

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 · RequiredOption ticker: futures-style code (base symbol + month code + year digit), a space, then C/P and strike, e.g. 'ESU3 P4450'. Max 20 chars.

Source: vendor guide and sample

CallPutstring · enum (2)Option type, C (call) or P (put). Guide: available only in the Future Options dataset.

Source: vendor guide and sample

2 allowed values
C
Call
P
Put
Strikeintegeri64Option strike: fixed price for buying or selling the underlying outright future, in the future's price units (e.g. 4450).

Source: vendor guide and sample

Monthstring · enum (12)single-letter CME month codeOption expiration month as a single-letter code (CME month codes, per the cmegroup.com table the guide links).

Source: vendor guide and sample

12 allowed values
F
January
G
February
H
March
J
April
K
May
M
June
N
July
Q
August
U
September
V
October
X
November
Z
December
ExpirationYearintegeri64Option expiration year as a four-digit number (e.g. 2023).

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 (12)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

12 allowed values
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 or settlement price by event type, 6-decimal string; 0.000000 on trade-volume and empty-book rows (sample).

Source: vendor guide and sample

Quantityintegeri64Key 6 · RequiredContracts traded at this price. 0 on SH/SL marker rows; SETTLEMENT PRICE carries the referenced trade date (yyyymmdd); TRADE VOLUME/OPEN INTEREST carry the count.

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.