Cboe Indices Schemas#

Cboe Indices are a series of market indices provided by Cboe Global Markets, including the Cboe Volatility Index (VIX).



CBOE_IDX#

Database includes the following Tables:

  • IDX - Index values

  • QTE - Best bid / offer quotes

  • STAT - Static data, e.g. ISIN, description, security type


CBOE_IDX - IDX#

Index values

CBOE_IDX - IDX Table Schema#

Field

Data Type

Description

SYMBOL_NAME

string

Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate)

TIMESTAMP

nsectime

Event Timestamp (typically at a nano-second resolution)

EXCH_TIME

nsectime

Event timestamp, as provided by the exchange. For electronic trading this refers to the matching engine timestamp

PRICE

double

TRD: Trade price, IDX: Index value, IND: Indicative price, PRL: Price point to which the depth entry relates, PRL_FULL: Order price, FIXING: Fixing price, RFC: Price associated with a Request for Cross

OMDSEQ

uint

Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first.

CBOE_IDX - QTE#

Best bid / offer quotes

CBOE_IDX - QTE Table Schema#

Field

Data Type

Description

SYMBOL_NAME

string

Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate)

TIMESTAMP

nsectime

Event Timestamp (typically at a nano-second resolution)

EXCH_TIME

nsectime

Event timestamp, as provided by the exchange. For electronic trading this refers to the matching engine timestamp

BID_PRICE

double

Best bid price. A null value is used if the bid side is empty, or if the best bid is set by unpriced orders (e.g. market orders)

ASK_PRICE

double

Best ask price. A null value is used if the ask side is empty, or if the best ask is set by unpriced orders (e.g. market orders)

OMDSEQ

uint

Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first.

CBOE_IDX - STAT#

Static data, e.g. ISIN, description, security type

CBOE_IDX - STAT Table Schema#

Field

Data Type

Description

SYMBOL_NAME

string

Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate)

TIMESTAMP

nsectime

Event Timestamp (typically at a nano-second resolution)

NAME

string[120]

Description of the instrument

ISIN

string[12]

ISIN code

SEDOL

string[7]

SEDOL code

EXCH_SYMBOL

string[25]

Ticker symbol specified by the exchange

RTS_SYMBOL

string[32]

Ticker symbol used by ICE Data Services

BBG_TICKER

string[40]

Bloomberg ticker symbol

FIGI

string[12]

Financial Instrument Global Identifier, identifying an individual instrument traded on a specific venue

MIC

string[4]

Market Identifier Code (MIC, ISO 10383) identifying the market on which the instrument is traded

OPERATING_MIC

string[4]

Market Identifier Code (MIC, ISO 10383) of the exchange that operates the market on which the instrument is traded

SEC_TYPE

string[20]

Security type, e.g. Equity, ETF, Future

CURRENCY

string[3]

Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal).

OMDSEQ

uint

Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first.