BrokerTec on RDW
Comprehensive product and instrument reference data for BrokerTec is available on the Reference Data Warehouse in the following tables:
v_product_btec - all product reference data
v_instrument_btec - all instrument reference data
Contents
Schemas
Product Schema
Field Name | Type | Mode | Description | v_product_btec | v_instrument_btec |
|---|---|---|---|---|---|
variable_qty_ind | STRING | NULLABLE | Indicates if product is subject to Variable Quantity processing. | x |
|
valuation_mthd | STRING | NULLABLE | Type of valuation method used FUT - Futures Style FWD - Forward BILL - Bills BOND - Cash Notes and bonds IRS - Interest Rate Swap SPOT - Spot RPO - Repo Specific | x | x |
unit_of_measure_qty | NUMERIC | NULLABLE | Unit of measure quantity for the product. | x |
|
unit_of_measure | STRING | NULLABLE | Unit of measure for the product. | x |
|
settle_mthd | STRING | NULLABLE | Settlement Method. Indicates if product is financially or physically settled. | x |
|
sec_type | STRING | NULLABLE | Type of derivative, e.g. FUT for outright future. | x | x |
sec_sub_type | STRING | NULLABLE | Instrument sub type | x | x |
run_date | DATE | NULLABLE | Date when record was captured. | x | x |
rfq_cross_elig_ind | STRING | NULLABLE | Indicates if product is Cross eligible on CME Globex and requires an RFQ prior to Cross submission. | x |
|
repo_year_days | NUMERIC | NULLABLE | The number of days in year used in REPO consideration calculations. | x |
|
rbt_elig_ind | STRING | NULLABLE | Relationship Based Trading Eligibility Indicator. | x | x |
px_unit_of_measure_unit | STRING | NULLABLE | Defines the unit of measure of the price if different from the product. | x |
|
px_unit_of_measure_qty | NUMERIC | NULLABLE | Defines the unit of measure quantity of the price if different from the product. | x |
|
px_quote_mthd | STRING | NULLABLE | Defines the method for price quotes. | x |
|
px_quote_ccy | STRING | NULLABLE | The currency for the trade price. | x |
|
px_mult | NUMERIC | NULLABLE | Multiplier to convert price to actual economic value. | x |
|
px_band | STRING | NULLABLE | Differential value for price bands on CME Globex. | x |
|
prod_guid_int | NUMERIC | NULLABLE | Historically unique product identifier in integer format. | x | x |
prod_guid | STRING | NULLABLE | Historically unique product identifier | x | x |
par_or_money_ind | STRING | NULLABLE | Collateral is valued with, or without, accrued interest, when being allocated. | x |
|
negative_px_elig_ind | STRING | NULLABLE | Indicates if product may use negative book and trade prices. | x |
|
min_days_to_mat | NUMERIC | NULLABLE | The minimum number of days remaining on an allocated collateral before it must be substituted. | x |
|
md_channel_id | STRING | NULLABLE | Market Data Platform channel for CME Globex order book and trades. | x |
|
master_sym | STRING | NULLABLE | This code is only used to associate outright instruments (futures and options) with the product-level spreads/combos. It is not a meaningful attribute of the product itself. | x |
|
mass_quote_elig_ind | STRING | NULLABLE | Indicates if product is eligible for Mass Quote messages on CME Globex. | x |
|
market_segment_id | NUMERIC | NULLABLE | Numeric value for CME Globex Market Segment on which the product is traded. | x |
|
last_updated_ts | TIMESTAMP | NULLABLE | Timestamp reflecting the last time the record was updated in the source system. | x | x |
inc_order_min_qty | NUMERIC | NULLABLE | Minimum incremental order quantity. | x |
|
ilink_elig_ind | STRING | NULLABLE | iLink Mass Quote eligible products. | x |
|
glbx_sym | STRING | NULLABLE | CME Globex Product Code (MDP 3.0 tag 6937-Asset) | x | x |
glbx_ord_min_qty | STRING | NULLABLE | Minimum order or quote size required on CME Globex. | x | x |
glbx_ord_max_qty | STRING | NULLABLE | Maximum value allowed for a single quote or order on CME Globex. | x | x |
glbx_match_algo | STRING | NULLABLE | Match algorithm indicator for CME Globex markets. | x |
|
glbx_group_id | STRING | NULLABLE | CME Globex uses this group code to identify logical groupings of products. | x | x |
glbx_group_desc | STRING | NULLABLE | This describes the CME Globex Group Code. | x |
|
glbx_elig_ind | STRING | NULLABLE | Indicates if product is eligible to be traded on CME Globex. | x |
|
gc_basket_identifier | STRING | NULLABLE | CUSIP or ISIN of Repo Basket | x |
|
fractional_px_ind | STRING | NULLABLE | Indicates if product price should be displayed in fractional or decimal notation. | x |
|
exch_mic | STRING | NULLABLE | Market Identifier Code (MIC) as defined by the ISO. For inter-exchange spreads, this field contains the hybrid value displayed in the Market Data Platform Security Definition (tag 35=d) message tag 207-SecurityExchange. | x | x |
exch_id | STRING | NULLABLE | Exchange identifier used in the CME Group Post Trade applications. | x | x |
dirty_px_tick | NUMERIC | NULLABLE | This is the tick for the dirty price (price + accrued interest). Dirty price is used to value repo collateral. | x |
|
dirty_px_rounding | NUMERIC | NULLABLE | Numerical codes to indicate rounding type. | x |
|
contract_notional_amt | NUMERIC | NULLABLE | Notional amount per contract. | x |
|
clr_sym | STRING | NULLABLE | The product code used in CME Clearing for clearing reports like the Trade Register. | x | x |
clr_org_id | STRING | NULLABLE | The entity where the trade will be cleared. Values include: | x |
|
asset_sub_sector | STRING | NULLABLE | Sub-sector associated with product. | x |
|
asset_sub_class | STRING | NULLABLE | Sub class within asset class (for example: Credit, Foreign Exchange). | x |
|
asset_sector | STRING | NULLABLE | Sector associated with product. | x |
|
asset_class | STRING | NULLABLE | Underlying asset type. |