ThetaData v3
Search K

Appearance

V3_OPTION_HISTORY_QUOTE() ​

ValueStandardPro
  • Returns every NBBO quote reported by OPRA.
  • If the interval parameter is specified, the quote for each interval represents the last quote at the interval's timestamp.
  • Multi-day requests are limited to 1 month of data, and must specify an expiration.

Example ​

=THETADATA.V3_OPTION_HISTORY_QUOTE("AAPL", "", "20241108", "220.000", "call", "09:30:00", "16:00:00", "1m", "", "", "20241104", "20241111")

Parameters ​

symbolRequired  -

The stock or index symbol, or underlying symbol for options.

Type: string
Behavior: Required.
date  -

The date to fetch data for. If present, this overrides start_date and end_date.

Type: string
Behavior: Optional.
expiration  -

The expiration of the contract in YYYY-MM-DD or YYYYMMDD format, or * for all expirations.

Type: string
Behavior: Optional - leave blank for all expirations.
strike  -

The strike price of the contract in dollars (ie 100.00 for $100.00), or * for all strikes.

Type: string
Behavior: Optional (default: *).
right  -

The right (call or put) of the contract.

Type: string
Behavior: Optional (default: both).
Enumcall, put, both
start_time  -

The start time (inclusive) in the specified day (format 24-hour HH:MM:SS.SSS).

Type: string
Behavior: Optional (default: 09:30:00).
end_time  -

The end time (inclusive) in the specified day (format 24-hour HH:MM:SS.SSS).

Type: string
Behavior: Optional (default: 16:00:00).
interval  -

The size of the time interval must be one of the available options listed below. Intervals less than 1m are available only for single-day requests.

Type: string
Behavior: Optional (default: 1s).
Enumtick, 10ms, 100ms, 500ms, 1s, 5s, 10s, 15s, 30s, 1m, 5m, 10m, 15m, 30m, 1h
max_dte  -

If specified, only contracts with a full calendar day 'Days to Expiration' (DTE) less than or equal to this number will be returned.

Type: string
Behavior: Optional.
strike_range  -

Limits the number of contracts returned relative to the underlying's spot price. For a specified value 'n', this returns 'n' strikes above and 'n' strikes below the spot price, plus one at-the-money (ATM) strike (where spot price = strike price), if available. This results in a maximum of 2n + 1 strikes.

Type: string
Behavior: Optional.
start_date  -

The start date (inclusive).

Type: string
Behavior: Optional.
end_date  -

The end date (inclusive).

Type: string
Behavior: Optional.

Returns ​

A grid (string[][]) - a header row followed by one row per result. See the REST API reference for the full response schema.