EBS on RDW
Comprehensive product and instrument reference data for EBS is available on the Reference Data Warehouse in the following tables:
v_product_ebs - all product reference data
v_instrument_ebs - all instrument reference data
Contents
Schemas
Product Schema
Field Name | Type | Mode | Description | v_product_ebs | v_instrument_ebs |
|---|---|---|---|---|---|
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 |
|
trade_close_offset | STRING | NULLABLE | Fixing close offsets - Time duration before scheduled fixing time of the eFix Matching Service instrument. | x |
|
settle_mthd | STRING | NULLABLE | Settlement Method. Indicates if product is financially or physically settled. | x |
|
settle_locale | STRING | NULLABLE | Settlement Location. | x |
|
settle_ccy | STRING | NULLABLE | The base currency for the settlement price when different from local currency. The local currency price can be found in the settlePxCcy field. | 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 |
|
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_precision | NUMERIC | NULLABLE | Specifies the price decimal precision for EBS instruments: | 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 |
on_sef_ind | STRING | NULLABLE | Indicates if the instrument is SEF regulated. | x |
|
on_mtf_ind | STRING | NULLABLE | Indicates if the instrument is MTF regulated. | x |
|
negative_px_elig_ind | STRING | NULLABLE | Indicates if product may use negative book and trade prices. | 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 |
|
market_json_data | JSON | REPEATED | Json repeating group of Market Data Platform channel(s) | 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 | x |
ilink_elig_ind | STRING | NULLABLE | iLink Mass Quote eligible products. | x |
|
good_for_session_ind | STRING | NULLABLE | Indicates GFS (Good For Session) TimeInForce eligibility on CME Globex. | x | 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 |
|
fractional_px_ind | STRING | NULLABLE | Indicates if product price should be displayed in fractional or decimal notation. | x |
|
fixing_time_zone | STRING | NULLABLE | The region/time zone associated with the fixing time. | x |
|
fixing_src | STRING | NULLABLE | Fixing rate source. Only used for eFix products and instruments. | 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 |
efix_prod_ind | STRING | NULLABLE | Indicates if product is traded on the CME Globex eFix matching service. | 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 |