EBS on RDW

Owned by CME Group

Apr 26, 2024

1 min read

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

1 Schemas
- 1.1 Product Schema
- 1.2 Instrument Schema
2 Sample Queries
- 2.1 Query For ON-SEF Products
- 2.2 Query For All eFIX Instruments Using BFIX Fixings

Schemas

Product Schema

Instrument Schema

Sample Queries

Query For ON-SEF Products

SELECT * /*add specific fields or use star for all*/
FROM `/*insert project name */.cmeg_refdata_ebs.v_product_ebs`
WHERE on_sef_ind="Y" and run_date="2023-06-12" /* add query terms and run_date value to limit results */

Query For All eFIX Instruments Using BFIX Fixings

SELECT * /*add specific fields or use star for all*/
FROM `/*insert project name */.cmeg_refdata_ebs.v_instrument_ebs`
WHERE fixing_name LIKE "BFIX%" and run_date="2023-06-12"

How was your Client Systems Wiki Experience? Submit Feedback

Copyright © 2024 CME Group Inc. All rights reserved.