CME Historical Market Depth Data on Google Cloud Platform
As of December 1, 2022, CME Historical Market Depth Data on Google Cloud Platform (GCP) is available for clients to access through Google BigQuery services and is easily discoverable through Google Analytics Hub. This service enables customer to query data from 2014 to the present day and can handle the heaviest workloads.
This topic provides a technical overview of CME Historical Market Depth Data on GCP.
For complete details regarding Google Cloud Services, including BigQuery and Analytics Hub, please refer to:
Analytics Hub:
BigQuery:
Contents
Revision History
Date | Description |
---|---|
6/14/2023 | Revised Onboarding section. |
12/1/2022 | Initial publication. |
Key Events and Dates
Date | Milestone |
---|---|
12/1/2022 | Production |
Certification
Certification for Historical Market Depth Data on Google Cloud Platform is not required.
Onboarding
Customers access CME Group data products on Google Cloud (GCP) through any BigQuery discovery service, including Analytics Hub.
Customers interested in accessing the CME Historical Market Depth Data on GCP dataset should contact CME Group Data Sales, complete the Information License Agreement (if required) and pay the applicable fee.
Access Products
The following steps are required for onboarding and entitlements to the CME Historical Market Depth Data on GCP dataset in BigQuery:
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 (
), then navigate to BigQuery > AnalyticsHub.
Select Search Listings.
Enter "CME Group" and select from the following products
CME Group Historical Market Depth Data
New York Mercantile Exchange 10 Level Order Book
Commodities Exchange Center 10 Level Order Book
Chicago Mercantile Exchange 10 Level Order Book
Chicago Board of Trade 10 Level Order Book
Select Request Access to begin the licensing workflow to fill out the Schedule 6 and share your Google account to gain access.
Sample Queries
This T+1 service gives customers the ability to directly access the CME database from January 2014 to the present day. After gaining access, customers will be able to streamline data into other cloud services, such as Google Sheets, BigQuery Machine Learning and Google Vertex AI,etc.
The historical market depth dataset contains 3 different data tables:
Statistics: Data examples include Settlements, Open, High, Low, Close, aggregated volume
Depth of Book: All market data for 10 Levels deep in futures and 5 level deep in options.
Quotes: User Defined Spread data. Customers can query when instruments were RFQ'd.
These tables allow customers to recreate the book or easily query for Top of Book or Time and Sales. More advance users will be able to extract market analytics such as 200 MA, TWAP, and VWAP, etc., from these two tables.
Top of Book
SELECT transaction_ts, glbx_sym, bid_level_1_qty,bid_level_1_px,ask_level_1_px,ask_level_1_qty
FROM customersProject.prod_cme_globex_10_level_order_book.v_orderbook_10_lvl_futuresandoptions
WHERE cycle_date = "2022-09-09"