US Options Trade Only

GET https://api.devalgoseek.com/api/v1/data/us-equity-opt/opt-trades/:trade_date/:ticker#

The U.S. Options Trade-Only dataset provides tick-level executed options trades derived from the consolidated Options Price Reporting Authority (OPRA) feed, with trade-anchored market context captured at the time of each execution. Each record includes the executed trade price, size, timestamp, originating exchange, and trade condition codes, along with the prevailing National Best Bid and Offer (NBBO), including bid/ask price, size, and condition, as observed at the moment of the trade. This enables accurate analysis of execution quality, trade aggressiveness, and market state at execution time, without the overhead of a full quote stream. To support option-to-underlying relationship analysis, the dataset also includes underlying asset reference data (bid, ask, and last trade price, size, and timestamp) aligned to the option trade event. Coverage spans all U.S. equity options exchanges reporting via OPRA.

For more details, please refer to the dataset documentation: US Options Trade Only Guide.

Advanced Filtering

You can provide one or multiple filter expressions based on the dataset's columns to narrow down the results. For example, StartDate.gt=2023-01-01&StartDate.lt=2023-12-31, Ticker=AAPL.

Please refer to the Advanced Filtering Guide for the extensive reference.

Request#

Path Parameters#

trade_date Trade Daterequired

Trading date in YYYY-MM-DD format

Example: 2024-01-15

ticker Tickerrequired

Dataset's security identifier

Example: AAPL

Query Parameters#

sort Sort

Sorting criteria for the results. Provide a column name with optional prefix '+' for ascending order, or prefix with '-' for descending order. Multiple sorting fields may be supported depending on the dataset. If sort prefix is not provided, the ascending order is applied.

columns Columns

A comma-separated list of columns to include in the response. Use this parameter to select only specific fields from the dataset. If not provided, all available columns will be returned.

offset Offset

Possible values: >= 0

Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.

Default value: 0

Example: 100

limit Limit

Possible values: >= 0 and <= 100000

Maximum number of records to return. Used to control response size and pagination. If not provided, a default limit is applied by the server.

Default value: 10000

Example: 100

response_format ResponseFormat

Possible values: [json, csv, csv_gzip]

The type of the data to return

Default value: json

Examples:

JSON
CSV Gzip

JSON format (default)

Example: json

Compressed CSV format

Example: csv_gzip

Responses#

JSON, CSV file, or gzip-compressed CSV file, depending on the value of response_format query parameter

application/json
text/csv
application/gzip

Schema
Example (auto)

Schema

data object[]required

Array [

TradeDatedate

The trading day

Example: 2023-08-02

EventDateTimedate-time

Event timestamp (EST) with a millisecond resolution

Example: 2023-08-02 09:32:26.228000000

Tickerstring

Symbol name

Example: AAPL

CallPutstring

Option contract class: C for Call or P for Put

Example: C

Strikenumber

Option contract strike price

Example: 50

ExpirationDatedate

Expiration date of the option contract

Example: 2023-08-04

EventTypeinteger

Byte code applicable to the event. It is translated into text in the Action column

Example: 33

Actionstring

EventType and Side as text

Example: T

Sidestring

B (Buy) or S (Sell) side of the book. Empty field for trade events

Example:

Pricenumber

Option contract pricing

Example: 144.7

Quantityinteger

Underlying asset quantity

Example: 1

Exchangestring

Exchange Acronymn, eg BATS

Example: CB

Conditionsstring

Single letter for Trade or Quote Condition

Example: I

LastBidTimedate-time

Time of the last option NBBO bid

Example: 2023-08-02 09:32:26.228000000

LastBidPricenumber

Price of the last option NBBO bid

Example: 144.25

LastBidSizeinteger

Size of the last option NBBO bid

Example: 5

LastBidConditionstring

Last option NBBO bid condition

Example: *

LastAskTimedate-time

Time of the last option NBBO ask

Example: 2023-08-02 09:32:26.228000000

LastAskPricenumber

Price of the last option NBBO ask

Example: 144.85

LastAskSizeinteger

Size of the last option NBBO ask

Example: 1

LastAskConditionstring

Last option NBBO ask condition

Example: *

UnderBidPricenumber

Underlying Ticker NBBO Bid price at time of the event

Example: 194.69

UnderAskPricenumber

Underlying Ticker NBBO Ask price at time of the event

Example: 194.71

UnderLastTradeTimedate-time

Time of the trade price of the underlying security

Example: 2023-08-02 09:32:26.223301282

UnderLastTradePricenumber

The trade price of the underlying security

Example: 194.7

UnderLastTradeSizeinteger

Size of the trade price of the underlying security

Example: 100

]

pagination objectrequired

offsetinteger

The number of records skipped to fetch the current page

Default value: 0

limitintegerrequired

The maximum number of records in the current page

next_offsetinteger

The number of records to skip to fetch the next page

{
  "data": [
    {
      "TradeDate": "2023-08-02",
      "EventDateTime": "2023-08-02 09:32:26.228000000",
      "Ticker": "AAPL",
      "CallPut": "C",
      "Strike": 50,
      "ExpirationDate": "2023-08-04",
      "EventType": 33,
      "Action": "T",
      "Side": "",
      "Price": 144.7,
      "Quantity": 1,
      "Exchange": "CB",
      "Conditions": "I",
      "LastBidTime": "2023-08-02 09:32:26.228000000",
      "LastBidPrice": 144.25,
      "LastBidSize": 5,
      "LastBidCondition": "*",
      "LastAskTime": "2023-08-02 09:32:26.228000000",
      "LastAskPrice": 144.85,
      "LastAskSize": 1,
      "LastAskCondition": "*",
      "UnderBidPrice": 194.69,
      "UnderAskPrice": 194.71,
      "UnderLastTradeTime": "2023-08-02 09:32:26.223301282",
      "UnderLastTradePrice": 194.7,
      "UnderLastTradeSize": 100
    }
  ],
  "pagination": {
    "limit": 1000,
    "next_offset": 2000,
    "offset": 1000
  }
}

Schema
Example (auto)

Schema

stringbinary

"string"

Schema
Example (auto)

Schema

stringbinary

"string"

Validation Error

application/json

Schema
Example (auto)

Schema

detail object[]

Array [

loc object[]required

Array [

anyOf

string
integer

string

]

msgstringrequired

typestringrequired

inputInput

ctxobject

]

{
  "detail": [
    {
      "loc": [
        "string",
        0
      ],
      "msg": "string",
      "type": "string",
      "ctx": {}
    }
  ]
}

Authorization: X-API-KEY#

name: X-API-KEYtype: apiKeyin: header

HTTPCLIENT
RESTSHARP

var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Get, "https://api.devalgoseek.com/api/v1/data/us-equity-opt/opt-trades/:trade_date/:ticker");
request.Headers.Add("Accept", "application/json");
request.Headers.Add("X-API-KEY", "<X-API-KEY>");
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

Response

Click the Send API Request button above and see the response here!

← Previous

List api keys

Equity Options Tick