Skip to content

Trade Quote

FreeValueStandardPro

Fetch combined trade + quote ticks for an option contract.

  • Returns every trade reported by OPRA paired with the last NBBO quote reported by OPRA at the time of trade.
  • A quote is matched with a trade if its timestamp <= the trade timestamp.
  • To match trades with quotes timestamps that are < the trade timestamp, specify the exclusiveparameter to true. After thorough testing, we have determined that using exclusive=true might yield better results for various applications.
  • Multi-day requests are limited to 1 month of data, and must specify an expiration.
SPY · 20250321
Client
Auth
Style
from thetadatadx import Client

client = Client.from_env()

rows = client.market_data.option_history_trade_quote(
    "SPY", "20250321",
    strike="570", right="C",
)
for t in rows:
    print(t.ms_of_day, t.price, t.bid, t.ask)
Sample response · JSON
[
  {
    "ask": 4.05,
    "ask_condition": 50,
    "ask_exchange": 47,
    "ask_size": 14,
    "bid": 3.9,
    "bid_condition": 50,
    "bid_exchange": 47,
    "bid_size": 14,
    "condition": 130,
    "exchange": 22,
    "ext_condition1": 255,
    "ext_condition2": 255,
    "ext_condition3": 255,
    "ext_condition4": 255,
    "price": 3.9,
    "quote_timestamp": "2024-11-04T09:30:00.396",
    "sequence": 18902138,
    "size": 2,
    "trade_timestamp": "2024-11-04T09:30:00.471"
  },
  {
    "ask": 4.3,
    "ask_condition": 50,
    "ask_exchange": 73,
    "ask_size": 35,
    "bid": 4.15,
    "bid_condition": 50,
    "bid_exchange": 76,
    "bid_size": 93,
    "condition": 130,
    "exchange": 6,
    "ext_condition1": 255,
    "ext_condition2": 255,
    "ext_condition3": 255,
    "ext_condition4": 255,
    "price": 4.25,
    "quote_timestamp": "2024-11-04T09:30:01.594",
    "sequence": 19368856,
    "size": 1,
    "trade_timestamp": "2024-11-04T09:30:01.626"
  },
  {
    "ask": 4.3,
    "ask_condition": 50,
    "ask_exchange": 69,
    "ask_size": 59,
    "bid": 4.15,
    "bid_condition": 50,
    "bid_exchange": 69,
    "bid_size": 59,
    "condition": 130,
    "exchange": 6,
    "ext_condition1": 255,
    "ext_condition2": 255,
    "ext_condition3": 255,
    "ext_condition4": 255,
    "price": 4.22,
    "quote_timestamp": "2024-11-04T09:30:01.643",
    "sequence": 19403970,
    "size": 1,
    "trade_timestamp": "2024-11-04T09:30:01.698"
  }
]

Parameters

NameTypeRequiredDefaultDescription
symbolstringyesTicker symbol (e.g. AAPL)
expirationdateyesExpiration date YYYYMMDD. Pass * to select all expirations for the underlying (chain-wide; query one date at a time).
strikestringno*Strike price in dollars as a string (e.g. 500 or 17.5). Use * for wildcard selection.
rightstringnobothOption side. Use both or * (alias) for calls and puts. Accepted values: call, put, both, *.
datedatenoSingle date YYYYMMDD. Supply this for a single-day pull, or supply start_date/end_date for a range. When present, date takes precedence over the range.
start_timestringno09:30:00Start time filter
end_timestringno16:00:00End time filter
exclusiveboolnofalseWhen true, quotes whose timestamp equals the trade timestamp are excluded; only quotes strictly before the trade are paired.
max_dteintnoMaximum days to expiration
strike_rangeintnoStrike range filter
start_datedatenoStart date YYYYMMDD
end_datedatenoEnd date YYYYMMDD
timeout_msintnoPer-request deadline in milliseconds. 0 means no deadline.

Response

Rows of TradeQuoteTick:

FieldTypeDescription
ms_of_dayi32Milliseconds since midnight Eastern Time.
sequencei32Exchange-assigned trade sequence number.
ext_condition1i32Additional trade condition code.
ext_condition2i32Additional trade condition code.
ext_condition3i32Additional trade condition code.
ext_condition4i32Additional trade condition code.
conditioni32Trade condition code.
sizei32Number of contracts or shares traded.
exchangei32Exchange code where the trade executed.
pricef64Trade price.
condition_flagsi32Trade condition flags bitmap.
price_flagsi32Trade price flags bitmap.
volume_typei32Volume reporting mode: 0 = incremental, 1 = cumulative.
records_backi32Offset of this record behind the most recent record.
quote_ms_of_dayi32Timestamp of the paired quote, milliseconds since midnight ET.
bid_sizei32Last NBBO bid size.
bid_exchangei32Exchange code of the NBBO bid.
bidf64NBBO bid at the time of the trade.
bid_conditioni32Quote condition code on the bid side.
ask_sizei32Last NBBO ask size.
ask_exchangei32Exchange code of the NBBO ask.
askf64NBBO ask at the time of the trade.
ask_conditioni32Quote condition code on the ask side.
datei32Trading date as a YYYYMMDD integer.

Wildcard requests additionally populate expiration (YYYYMMDD), strike (dollars), and right ("C" / "P") on every row to identify the contract; on single-contract requests these are absent (None / null / undefined; the Rust and C rows carry the documented 0 / 0.0 / '\0' fills).

Released under the Apache-2.0 License.