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
| Table filter |
|---|
| fixedCols | 1 |
|---|
| totalrow | ,,,,,,,,,,, |
|---|
| hidelabels | false |
|---|
| ddSeparator | |
|---|
| sparkName | Sparkline |
|---|
| hidePane | true |
|---|
| limitHeight | 1 |
|---|
| sparkline | false |
|---|
| default | x,Description&&Field Name&&Mode&&Type |
|---|
| isFirstTimeEnter | false |
|---|
| cell-width | 250,250 |
|---|
| hideColumns | true |
|---|
| totalRowName | |
|---|
| totalColName | |
|---|
| disabled | false |
|---|
| enabledInEditor | false |
|---|
| globalFilter | false |
|---|
| id | 1686672403963_2023870844 |
|---|
| iconfilter | |
|---|
| order | 0,1 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | v_product_btec |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_product_btec‚Hide columns |
|---|
| thousandSeparator | |
|---|
| ignoreFirstNrows | |
|---|
| ddOperator | OR |
|---|
| userfilter | |
|---|
| datepattern | dd M yy |
|---|
| numberfilter | |
|---|
| heightValue | |
|---|
| updateSelectOptions | false |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| isOR | AND |
|---|
| showNRowsifNotFiltered | |
|---|
|
| Table excerpt include |
|---|
| name | compRDWdatasets |
|---|
| merge-tables | true |
|---|
| page | Comprehensive RDW Datasets |
|---|
| type | page |
|---|
|
|
Instrument Schema
| Table filter |
|---|
| fixedCols | 1 |
|---|
| totalrow | ,,,,,,,,,,, |
|---|
| hidelabels | false |
|---|
| ddSeparator | |
|---|
| sparkName | Sparkline |
|---|
| hidePane | true |
|---|
| limitHeight | 1 |
|---|
| sparkline | false |
|---|
| default | x,Description&&Field Name&&Mode&&Type |
|---|
| isFirstTimeEnter | false |
|---|
| cell-width | 250,250 |
|---|
| hideColumns | true |
|---|
| totalRowName | |
|---|
| totalColName | |
|---|
| disabled | false |
|---|
| enabledInEditor | false |
|---|
| globalFilter | false |
|---|
| id | 1686673452411_-98923182 |
|---|
| iconfilter | |
|---|
| order | 1,0 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_instrument_btec‚Hide columns |
|---|
| thousandSeparator | |
|---|
| ignoreFirstNrows | |
|---|
| ddOperator | |
|---|
| userfilter | v_instrument_btec |
|---|
| datepattern | dd M yy |
|---|
| numberfilter | |
|---|
| heightValue | |
|---|
| updateSelectOptions | false |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| isOR | AND |
|---|
| showNRowsifNotFiltered | |
|---|
|
| Table excerpt include |
|---|
| name | compRDWdatasets |
|---|
| merge-tables | true |
|---|
| page | Comprehensive RDW Datasets |
|---|
| type | page |
|---|
|
|
Sample Queries
Query Products By Exchange ID
| Code Block |
|---|
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
| Code Block |
|---|
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" |