The CME Group Reference Data Warehouse (RDW) is a set of Google Cloud BigQuery datasets discoverable via the Analytics Hub. RDW provides access to historical product and instrument referential data for CME Group futures and options, BrokerTec, EBS, Hosted Partners and CME Group-cleared markets. Client systems can utilize RDW to streamline and automate their historical analyses and access product and instrument referential information directly from CME Group data in Google Cloud.
Data from all tables and datasets can easily be queried via Joins and other BigQuery functions.
...
Info |
---|
RDW is not a real-time service; data is updated once a day every evening. For real-time information, please rely on the Reference Data API or MDP 3.0 Security Definition messages. User-Defined Spreads are not currently available in RDW. |
For complete details regarding Google Cloud Services, including BigQuery and Analytics Hub, please refer to:
- Service Accounts
- Analytics Hub:
- BigQuery:
...
Certification
Certification for RDW on Google Cloud is not required.
Onboarding
...
- Confirm/Obtain your CME Group Login ID. See additional information about creating a CME Group Login account as needed.
- Confirm/Obtain your Google Cloud account and Project. Navigate to cloud.google.com to login.
- From your Google Account, select the Google Cloud menu BigQuery > AnalyticsHub. , then navigate to
- Select Search Listings.
- Enter "CME Group" and select from the following datasets. Each dataset has two versions - one for the New Release records ("Data Exchange : CMEGroup Reference Data - UT") and one for the Production records ("Data Exchange : CMEGroup Reference Data"). Please ensure you select the correct dataset for your desired environment.
- Reference Data Warehouse Futures and Options on Futures
- Reference Data Warehouse BrokerTec
Reference Data Warehouse EBS
Examples:New Release Environment Data: Production Data:
- Select Request Access to begin the licensing workflow to fill out the Schedule 6 and share your Google account to gain access.
...