Cboe BXE (BATS Europe) Schemas#

Cboe BXE, formerly BATS Europe, is a pan-European MTF offering trading in equities, ETFs, and other securities across multiple European markets.

BXE#

Database includes the following Tables:

DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
IND - Indicative pricing, e.g. indicative auction prices and imbalance
MKT - Market phase / instrument status information
QTE - Best bid / offer quotes
STAT - Static data, e.g. ISIN, description, security type
TRD - Trades

BXE - DAY#

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

BXE - 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)
CURRENCY	string[3]	Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal).
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
VOLUME	long	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
TRADE_COUNT	long	Number of trades on the current trading day
TURNOVER	double	Total monetary value traded on the current trading day. Note: The value will typically be rounded to the nearest integer.
VWAP	double	Volume-weighted average price
VOLUME_LIT	long	Volume traded in a lit orderbook
VOLUME_DARK	long	Volume traded in a dark orderbook
OFF_BOOK_VOLUME	long	Total volume traded off-book
VOLUME_RFQ	long	Volume traded through an RFQ / RFC (Request for Quote / Request for Cross) process
VOLUME_CONTINUOUS	long	Volume traded in the main orderbook during continuous trading
VOLUME_AUCTION	long	Volume traded during auctions. Includes all auction types.
VOLUME_OPENING_AUCTION	long	Volume of the Opening Auction
VOLUME_CLOSING_AUCTION	long	Volume of the Closing Auction
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.

BXE - IND#

Indicative pricing, e.g. indicative auction prices and imbalance

BXE - IND 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
SIZE	long	TRD: Trade size, IND: Indicative size, PRL: Size at the relevant price point, PRL_FULL: Order size, RFQ: Size associated with a Request for Quote, RFC: Size associated with a Request for Cross
AUCTION_PRICE_TYPE	string[5]	Type of auction price.
AUCTION_TYPE	string[1]	Type of auction from which an indicative auction price / auction imbalance originates.
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.

BXE - MKT#

Market phase / instrument status information

BXE - MKT 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
MKT_PHASE	string[4]	Indicates the instrument’s current market phase, as specified by the trading venue
OMD_STATUS	string[1]	Indicates an instrument’s current trading status. Values are normalized across all DBs.
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.

BXE - QTE#

Best bid / offer quotes

BXE - 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)
BID_SIZE	long	Best bid size
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)
ASK_SIZE	long	Best ask size
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.

BXE - STAT#

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

BXE - 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[40]	Ticker symbol specified by the exchange
RTS_SYMBOL	string[32]	Ticker symbol used by ICE Data Services
BBG_TICKER	string[32]	Bloomberg ticker symbol
FIGI	string[12]	Financial Instrument Global Identifier, identifying an individual instrument traded on a specific venue
COMPOSITE_FIGI	string[12]	Country-composite FIGI, identifying a security across all venues in a particular country
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
PRIMARY_MIC	string[4]	MIC of the instrument’s primary listing market, or the reference market for instruments traded on an MTF
MKT_SEGMENT	string[30]	Market segment on which the instrument is traded
SEC_TYPE	string[25]	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).
LOT_SIZE	double	All standard order sizes must be an integer multiple of the Lot Size
TICK_SIZE_TYPE	string[8]	Indicates the type of tick size carried by TICK_SIZE. Values are Static or Variable.
TICK_SIZE	string[200]	Tick size / minimum price increment. All order prices must be a multiple of the tick size.
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.

BXE - TRD#

Trades

BXE - TRD 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
SIZE	long	TRD: Trade size, IND: Indicative size, PRL: Size at the relevant price point, PRL_FULL: Order size, RFQ: Size associated with a Request for Quote, RFC: Size associated with a Request for Cross
TRADE_TYPE	string[6]	Type of trade
AGGRESSOR_SIDE	string[1]	Indicates whether a trade resulted from an incoming buy or sell order.
TRADE_VENUE	string[4]	Identifies the venue where a trade was executed. Typically a MIC, with the special values XOFF for off-exchange and SINT for Systematic Internaliser trades.
LATE_REPORTED	string[1]	Indicates whether a trade was reported late and/or outside normal trading hours
TRADE_CURRENCY	string[3]	Currency in which a trade was executed.
TRADE_PERIOD	string[1]	Market period during which a trade was executed.
BOOK_TYPE	string[1]	Type of order book or trading mechanism through which a trade was executed.
MMT_MKT_MECH	string[1]	Market mechanism through which a trade was executed.
MMT_TRD_MODE	string[1]	Trading period during which an on-book trade was executed, or origin of an off-book trade report (on-exchange / off-exchange / SI).
MMT_TRANS_CAT	string[1]	Identifies various special categories of trade.
MMT_NEGOTIATED_IND	string[1]	Indicates privately negotiated trades, or Systematic Internaliser trades exempt from pre-trade transparency.
MMT_CROSS_IND	string[1]	Identifies agency cross trades, where a broker crossed two client orders outside the order book.
MMT_MOD_IND	string[1]	Identifies trade cancellations, or amendments of a previous trade.
MMT_BENCHMARK_IND	string[1]	Identifies whether a trade was priced according to a defined benchmark (e.g. VWAP) or reference price (e.g. midpoint of the primary market BBO), or whether it was part of a trade in multiple instruments (contingent trade or portfolio trade).
MMT_DIVIDEND_IND	string[1]	Identifies whether a trade includes special dividend arrangements, e.g. a trade sold cum-dividend during an ex-dividend period.
MMT_OFF_BOOK_AUTO_IND	string[1]	Identifies whether an off-book trade report was executed via a manual or automated process.
MMT_PRICE_FORMING_IND	string[1]	Identifies whether a trade is price-forming, or contributes to the price discovery process.
MMT_ALGO_IND	string[1]	Identifies whether a trade involved an algorithmic order.
MMT_PUB_MODE	string[1]	Identifies whether a trade was subject to delayed publication, and the reason for the deferral.
MMT_DEFERRAL_TYPE	string[1]	Type of publication deferral or subsequent enrichment applied to a trade report.
MMT_DUP_IND	string[1]	Identifies trades reported to more than one Approved Publication Arrangement.
TRADE_ID	string[52]	Trade identifier, generally the ID assigned by the matching engine
DELETED_TIME	msectime	Internal OneTick field. Usually null unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
TICK_STATUS	int	Internal OneTick field. Always 0 unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
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.

BXE_BARS#

Database includes the following Tables:

DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
MKT - Market phase / instrument status information
QTE_1M - 1-minute quote bars
TRD_1D - Daily trade bars
TRD_1M - 1-minute trade bars
VWAP_1H - 1-hour VWAP bars

BXE_BARS - DAY#

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

BXE_BARS - 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)
CURRENCY	string[3]	Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal).
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
VOLUME	long	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
TRADE_COUNT	long	Number of trades on the current trading day
TURNOVER	double	Total monetary value traded on the current trading day. Note: The value will typically be rounded to the nearest integer.
VWAP	double	Volume-weighted average price
VOLUME_LIT	long	Volume traded in a lit orderbook
VOLUME_DARK	long	Volume traded in a dark orderbook
OFF_BOOK_VOLUME	long	Total volume traded off-book
VOLUME_RFQ	long	Volume traded through an RFQ / RFC (Request for Quote / Request for Cross) process
VOLUME_CONTINUOUS	long	Volume traded in the main orderbook during continuous trading
VOLUME_AUCTION	long	Volume traded during auctions. Includes all auction types.
VOLUME_OPENING_AUCTION	long	Volume of the Opening Auction
VOLUME_CLOSING_AUCTION	long	Volume of the Closing Auction
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.

BXE_BARS - MKT#

Market phase / instrument status information

BXE_BARS - MKT 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)
OMD_STATUS	string[64]	Indicates an instrument’s current trading status. Values are normalized across all DBs.
EXCH_TIME	nsectime	Event timestamp, as provided by the exchange. For electronic trading this refers to the matching engine timestamp
MKT_PHASE	string[4]	Indicates the instrument’s current market phase, as specified by the trading venue
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.

BXE_BARS - QTE_1M#

1-minute quote bars

BXE_BARS - QTE_1M 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)
FIRST_BID_TIME	nsectime	Time of the first best bid update in the current bar interval
FIRST_BID_PRICE	double	Price of the first best bid update in the current bar interval
FIRST_BID_SIZE	long	Size of the first best bid update in the current bar interval
FIRST_ASK_TIME	nsectime	Time of the first best ask update in the current bar interval
FIRST_ASK_PRICE	double	Price of the first best ask update in the current bar interval
FIRST_ASK_SIZE	long	Size of the first best ask update in the current bar interval
HIGH_BID_TIME	nsectime	Time of the bid quote that set HIGH_BID. If there are multiple quotes at that price, the first one is used.
HIGH_BID	double	Highest bid price in the current bar interval
HIGH_BID_SIZE	long	Size of the bid quote that set HIGH_BID. If there are multiple quotes at that price, the first one is used.
ASK_PRICE_AT_HIGH_BID	double	Ask price of the quote that set HIGH_BID. If there are multiple bid quotes at HIGH_BID, the first one is used.
ASK_SIZE_AT_HIGH_BID	long	Ask size of the quote that set HIGH_BID. If there are multiple bid quotes at HIGH_BID, the first one is used.
LOW_ASK_TIME	nsectime	Time of the bid quote that set LOW_ASK. If there are multiple quotes at that price, the first one is used.
LOW_ASK	double	Lowest ask price in the current bar interval
LOW_ASK_SIZE	long	Size of the ask quote that set LOW_ASK. If there are multiple quotes at that price, the first one is used.
BID_PRICE_AT_LOW_ASK	double	Bid price of the quote that set LOW_ASK. If there are multiple ask quotes at LOW_ASK, the first one is used.
BID_SIZE_LOW_ASK	long	Bid size of the quote that set LOW_ASK. If there are multiple ask quotes at LOW_ASK, the first one is used.
LAST_BID_TIME	nsectime	Time of the last best bid update in the current bar interval
LAST_BID_PRICE	double	Price of the last best bid update in the current bar interval
LAST_BID_SIZE	long	Size of the last best bid update in the current bar interval
LAST_ASK_TIME	nsectime	Time of the last best ask update in the current bar interval
LAST_ASK_PRICE	double	Price of the last best ask update in the current bar interval
LAST_ASK_SIZE	long	Size of the last best ask update in the current bar interval
MID_TWAP	double	Time-weighted average of the midpoint of the best bid/ask over the current bar interval. [Note: One-sided or empty quotes are excluded from the calculation]
MID_MEDIAN	double	Median of the midpoint of the best bid/ask quotes over the current bar interval. [Note: One-sided or empty quotes are excluded from the calculation]
MID_LAST	double	Midpoint of the last best bid/ask in the current bar interval. [Note: One-sided or empty quotes are excluded from the calculation]
SPREAD_MIN	double	Narrowest bid/ask spread, i.e. the lowest value of (best ask price - best bid price) over the current bar interval. [Note: May be zero or negative if the book was locked/crossed. One-sided or empty quotes are excluded from the calculation]
SPREAD_MAX	double	Widest bid/ask spread, i.e. the highest value of (best ask price - best bid price) over the current bar interval. [Note: May be zero or negative if the book was locked/crossed. One-sided or empty quotes are excluded from the calculation]
SPREAD_TWAP	double	Time-weighted average of (best ask price - best bid price) over the current bar interval. [Note: May be zero or negative if the book was locked/crossed. One-sided or empty quotes are excluded from the calculation]
SPREAD_MEDIAN	double	Median value of (best ask price - best bid price) over the current bar interval. [Note: May be zero or negative if the book was locked/crossed. One-sided or empty quotes are excluded from the calculation]
SPREAD_LAST	double	Last value of (best ask price - best bid price) over the current bar interval. [Note: May be zero or negative if the book was locked/crossed. One-sided or empty quotes are excluded from the calculation]
QUOTE_CURRENCY	string[3]	Currency in which a quote price is expressed.
QUOTE_TICK_COUNT	long	Number of BBO quotes in the current bar interval
CLOUD_DB	string[32]	In composite DBs: Identifies the source database for each tick. In bars DBs: Identifies the database containing the tick data used to calculate the bars.
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.

BXE_BARS - TRD_1D#

Daily trade bars

BXE_BARS - TRD_1D 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)
FIRST_TIME	nsectime	Timestamp of the first eligible trade in the current bar interval
FIRST	double	Price of the first eligible trade in the current bar interval
FIRST_SIZE	long	Size of the first eligible trade in the current bar interval
HIGH_TIME	nsectime	Timestamp of the highest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
HIGH	double	DAY: High price for the current trading day TRD_1M: Price of the highest-priced eligible trade in the current bar interval
HIGH_SIZE	long	Size of the highest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LOW_TIME	nsectime	Timestamp of the lowest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LOW	double	DAY: Low price for the current trading day. TRD_1M: Price of the lowest-priced eligible trade in the current bar interval
LOW_SIZE	long	Size of the lowest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LAST_TIME	nsectime	Timestamp of the last eligible trade in the current bar interval
LAST	double	Price of the last eligible trade in the current bar interval
LAST_SIZE	long	Size of the last eligible trade in the current bar interval
VWAP	double	Volume-weighted average price
TWAP	double	TIme-weighted average price
VOLUME	long	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
BUY_VOLUME	long	Traded volume originating from incoming buy orders. Excludes trades involving hidden orders, as well as off-book trades and auction trades, for the which the side of the aggressive order is undefined or unknown.
SELL_VOLUME	long	Traded volume originating from incoming sell orders. Excludes trades involving hidden orders, as well as off-book trades and auction trades, for the which the side of the aggressive order is undefined or unknown.
TRADE_CURRENCY	string[3]	Currency in which a trade was executed.
TRADE_TICK_COUNT	long	Number of eligible trades in the current bar interval
CLOUD_DB	string[32]	In composite DBs: Identifies the source database for each tick. In bars DBs: Identifies the database containing the tick data used to calculate the bars.
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.

BXE_BARS - TRD_1M#

1-minute trade bars

BXE_BARS - TRD_1M 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)
FIRST_TIME	nsectime	Timestamp of the first eligible trade in the current bar interval
FIRST	double	Price of the first eligible trade in the current bar interval
FIRST_SIZE	long	Size of the first eligible trade in the current bar interval
HIGH_TIME	nsectime	Timestamp of the highest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
HIGH	double	DAY: High price for the current trading day TRD_1M: Price of the highest-priced eligible trade in the current bar interval
HIGH_SIZE	long	Size of the highest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LOW_TIME	nsectime	Timestamp of the lowest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LOW	double	DAY: Low price for the current trading day. TRD_1M: Price of the lowest-priced eligible trade in the current bar interval
LOW_SIZE	long	Size of the lowest-priced eligible trade in the current bar interval. If there are multiple eligible trades at that price, the first one is used.
LAST_TIME	nsectime	Timestamp of the last eligible trade in the current bar interval
LAST	double	Price of the last eligible trade in the current bar interval
LAST_SIZE	long	Size of the last eligible trade in the current bar interval
VWAP	double	Volume-weighted average price
TWAP	double	TIme-weighted average price
VOLUME	long	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
BUY_VOLUME	long	Traded volume originating from incoming buy orders. Excludes trades involving hidden orders, as well as off-book trades and auction trades, for the which the side of the aggressive order is undefined or unknown.
SELL_VOLUME	long	Traded volume originating from incoming sell orders. Excludes trades involving hidden orders, as well as off-book trades and auction trades, for the which the side of the aggressive order is undefined or unknown.
TRADE_CURRENCY	string[3]	Currency in which a trade was executed.
TRADE_TICK_COUNT	long	Number of eligible trades in the current bar interval
CLOUD_DB	string[32]	In composite DBs: Identifies the source database for each tick. In bars DBs: Identifies the database containing the tick data used to calculate the bars.
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.

BXE_BARS - VWAP_1H#

1-hour VWAP bars

BXE_BARS - VWAP_1H 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)
VWAP	double	Volume-weighted average price
TWAP	double	TIme-weighted average price
VOLUME	double	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
CURRENCY	string[64]	Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal).
CLOUD_DB	string[32]	In composite DBs: Identifies the source database for each tick. In bars DBs: Identifies the database containing the tick data used to calculate the bars.
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.

BXE_DAILY#

Database includes the following Tables:

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

BXE_DAILY - DAY#

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

BXE_DAILY - 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)
CURRENCY	string[3]	Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal).
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
VOLUME	long	DAY: Total volume traded on the current trading day TRD_1M, VWAP_1H: Total volume of eligible trades in the current bar interval
TRADE_COUNT	long	Number of trades on the current trading day
TURNOVER	double	Total monetary value traded on the current trading day. Note: The value will typically be rounded to the nearest integer.
VWAP	double	Volume-weighted average price
VOLUME_LIT	long	Volume traded in a lit orderbook
VOLUME_DARK	long	Volume traded in a dark orderbook
OFF_BOOK_VOLUME	long	Total volume traded off-book
VOLUME_RFQ	long	Volume traded through an RFQ / RFC (Request for Quote / Request for Cross) process
VOLUME_CONTINUOUS	long	Volume traded in the main orderbook during continuous trading
VOLUME_AUCTION	long	Volume traded during auctions. Includes all auction types.
VOLUME_OPENING_AUCTION	long	Volume of the Opening Auction
VOLUME_CLOSING_AUCTION	long	Volume of the Closing Auction
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.

BXE_DAILY - STAT#

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

BXE_DAILY - 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[40]	Ticker symbol specified by the exchange
RTS_SYMBOL	string[32]	Ticker symbol used by ICE Data Services
BBG_TICKER	string[32]	Bloomberg ticker symbol
FIGI	string[12]	Financial Instrument Global Identifier, identifying an individual instrument traded on a specific venue
COMPOSITE_FIGI	string[12]	Country-composite FIGI, identifying a security across all venues in a particular country
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
PRIMARY_MIC	string[4]	MIC of the instrument’s primary listing market, or the reference market for instruments traded on an MTF
MKT_SEGMENT	string[30]	Market segment on which the instrument is traded
SEC_TYPE	string[25]	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).
LOT_SIZE	double	All standard order sizes must be an integer multiple of the Lot Size
TICK_SIZE_TYPE	string[8]	Indicates the type of tick size carried by TICK_SIZE. Values are Static or Variable.
TICK_SIZE	string[200]	Tick size / minimum price increment. All order prices must be a multiple of the tick size.
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.