IBEX Indices Schemas#

The IBEX Indices are a series of stock market indices for the Spanish stock market, including the IBEX 35.

IBEX_IDX#

Database includes the following Tables:

DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
IDX - Index values
STAT - Static data, e.g. ISIN, description, security type

Daily price and statistical data, e.g. closing price, settlement price, open interest

IBEX_IDX - DAY 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)
OPEN	double	Open price for the current trading day
HIGH	double	DAY: High price for the current trading day TRD_1M: Price of the highest-priced eligible trade in the current bar interval
LOW	double	DAY: Low price for the current trading day. TRD_1M: Price of the lowest-priced eligible trade in the current bar interval
CLOSE	double	Closing price
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.

Index values

IBEX_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.

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

IBEX_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[100]	Description of the instrument
ISIN	string[12]	ISIN code
EXCH_SYMBOL	string[20]	Ticker symbol specified by the exchange
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[40]	Security type, e.g. Equity, ETF, Future
CFI_CODE	string[6]	Classification of Financial Instruments code (ISO 10962), indicating the type of security
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.