Comprehensive product and instrument reference data for exchange-defined Futures, Options on Futures, and Combos is available on the Reference Data Warehouse in the following tables:
v_product_fno - all product reference data
v_instrument_fno - all instrument reference data
v_option_series_fno - Option series referential data, with attributes defined at the option series level
v_product_spec_fno - JSON attributes used to populate the product specification pages on cmegroup.com
| Info |
|---|
User-defined instruments and combinations are not currently supported on RDW. |
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 | 1686677354436_-1042742519 |
|---|
| iconfilter | |
|---|
| order | 1,0 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | v_product_fno |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_product_fno‚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 | 1686677376226_1913242889 |
|---|
| iconfilter | |
|---|
| order | 1,0 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | v_instrument_fno |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_instrument_fno‚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 |
|---|
|
|
Option Series 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 | 1686677389118_-562406423 |
|---|
| iconfilter | |
|---|
| order | 1,0 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | v_option_series_fno |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_option_series_fno‚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 |
|---|
|
|
Product Specifications 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 | 1686677403308_623080905 |
|---|
| iconfilter | |
|---|
| order | 1,0 |
|---|
| hideControls | false |
|---|
| inverse | false,true |
|---|
| numbering | |
|---|
| datefilter | |
|---|
| column | v_product_spec_fno |
|---|
| sort | Field Name ⇧ |
|---|
| totalcol | |
|---|
| disableSave | false |
|---|
| separator | Point (.) |
|---|
| rowsPerPage | |
|---|
| labels | v_product_spec_fno‚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 |
|---|
|
|
Sample Queries
Query For All SOFR Products
...