ThetaData

Appearance

Bulk OHLC ​

ValueStandardPro

REQUIRED

The Theta Terminal must be running to access data.

Behavior

Returns the data for all contracts that share the same provided root and expiration. Aggregated OHLC bars that use SIP rules
for each bar. Time timestamp of the bar represents the opening time of the bar. For a
trade to be part of the bar: bar timestamp <= trade time < bar timestamp + ivl, where ivl is the
specified interval size in milliseconds.

Sample URL & Code

Paste the URL below into your browser while the Theta Terminal is running.
You can use the "request sample" box to the right of this box obtain sample
code in any programming language.

http://127.0.0.1:25510/v2/bulk_hist/option/ohlc?root=AAPL&exp=20231103&start_date=20231103&end_date=20231103&ivl=900000

Parameters ​

Query Parameters

expRequired  -

The expiration date of the option contract formatted as YYYYMMDD.

Type: integer (Default: 20231103)
start_dateRequired  -

The start date (inclusive) of the request formatted as YYYYMMDD.

Type: integer (Default: 20230915)
end_dateRequired  -

The end date (inclusive) of the request formatted as YYYYMMDD.

Type: integer (Default: 20230915)
use_csvRequired  -

Uses CSV if true, legacy JSON if false.

Type: boolean (Default: false)
rootRequired  -

The symbol of the security. Option underlyings for indices might have special tickers.

Type: string (Default: SPX)
ivlRequired  -

The interval size in milliseconds. 1 minute intervals is 60000. Omitting this value or setting it to 0will provide tick-level data instead of aggregated / intervalized data.

Type: integer (Default: 900000)
start_time  -

If specified, the response will include all ticks on or after this number of milliseconds since midnight ET.

Type: string
end_time  -

If specified, the response will include all ticks on or before this number of milliseconds since midnight ET.

Type: string

Responses ​

OK
JSON
{
"header": {
"id": 0,
"latency_ms": 0,
"error_type": "string",
"error_msg": "string",
"next_page": null,
"format": [
"ms_of_day",
"open",
"high",
"low",
"close",
"volume",
"count",
"date"
]
},
"response": [
{
"ticks": [
[
34200000,
14.3,
14.8,
13.5,
14.3,
50,
18,
20231103
],
[
35100000,
15.5,
15.61,
15.38,
15.51,
26,
10,
20231103
]
],
"contract": {
"root": "AAPL",
"expiration": 20231103,
"strike": 160000,
"right": "C"
}
},
{
"ticks": [
[
34200000,
0.01,
0.15,
0.01,
0.01,
718,
113,
20231103
],
[
35100000,
0.01,
0.01,
0.01,
0.01,
232,
30,
20231103
]
],
"contract": {
"root": "AAPL",
"expiration": 20231103,
"strike": 160000,
"right": "P"
}
}
]
}

Sample Code

py