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

Instrument Schema

Sample Queries

Query Products By Exchange ID

SELECT * /*add specific fields or use star for all*/ FROM `/*insert project name */.cmeg_refdata_btec.v_product_btec` WHERE exch_id="BTEU" AND run_date="2023-06-05" /* add query terms and run_date value to limit results */

Query All Instruments Listed for 2 Year Note Product

SELECT a.long_name, a.sec_type, a.glbx_sym, a.glbx_security_id, b.prod_guid /* For convenience, the Instruments table is referred to as "a" and the Products table is referred to as "b". */ FROM `/*insert project name */.cmeg_refdata_btec.v_instrument_btec` a INNER JOIN `/*insert project name */.cmeg_refdata_btec.v_product_btec` b ON a.prod_guid=b.prod_guid WHERE a.prod_guid_int=/* integer value for 2 Year Note product */ AND a.run_date="2023-06-05" AND b.run_date="2023-06-05"






How was your Client Systems Wiki Experience? Submit Feedback

Copyright © 2024 CME Group Inc. All rights reserved.