End of Market Summary - Standard
- Space Sync for Confluence
End-of-Day files contain all of the official closing information for CME Group futures and options contracts. This dataset includes the open, high, low, close, open interest, total volume, volume breakdown by venue, settlement, delta, and implied volatilities. Delivered in an easy-to-use CSV format, End-of-Day preliminary settlements are available at 6:00 p.m. Central Time.
Contents
- 1 Dates Available
- 1.1 By Exchange
- 1.2 By Product
- 2 Sample Files
- 3 Layout Guides
- 4 FAQ
Dates Available
End of Day data is available on four exchanges in CSV format from as early as 1972.
By Exchange
Exchange | Open Date | Close Date |
---|
Exchange | Open Date | Close Date |
---|---|---|
CME Electronic Pit |
1/4/1993 1/4/1982 |
Present Present |
CBOT Electronic Pit |
8/28/2000 1/3/1972 |
Present Present |
NYMEX Electronic Pit |
6/25/1993 7/1/1986 |
Present Present |
COMEX Electronic Pit |
7/2/1993 1/1/1975 |
Present Present |
By Product
Filter EOD data availability by product here.
Sample Files
| Agriculture | Energy | Equity | Foreign Exchange | Interest Rates | Metals |
---|
| Agriculture | Energy | Equity | Foreign Exchange | Interest Rates | Metals |
---|---|---|---|---|---|---|
Futures | ||||||
Options |
Layout Guides
Fields with an * in the “Field Availability” column are only available post-November 1st, 2010.
Field Name | Excel Column | Example Value | Supported Values | Description | Field Availability |
---|
Field Name | Excel Column | Example Value | Supported Values | Description | Field Availability |
---|---|---|---|---|---|
Trade Date | A | 20120801 | YYYYMMDD | The trade date in YYYYMMDD format. |
|
Exchange Code | B | XCME | XCME, XCBT, XNYM, XCEC | The exchange where the product is traded. |
|
Asset Class | C | EQUITY INDEX | AGRICULTURE, ENERGY, EQUITY INDEX, INTEREST RATES, FX, METALS | Identifies an entire suite of products. | * |
Product Code | D | EZ | String | The code assigned to a particular product. |
|
Clearing Code | E | EZ | String | Identifies a contract as it is known to CME Clearing. | * |
Product Description | F | E-MINI S&P 500 OPTIONS | String | The textual description of a product. |
|
Product Type | G | O | F, O | Designates whether the contract is a Future (F) or Option (O). |
|
Underlying Product Code | H | 0 | String | If an option, the Product Code assigned to the underlying future. | * |
Put/Call | I | C | P, C | Designates whether the contract is a Put (P) or Call (C). |
|
Strike Price | J | 1200 | String | If an option, the strike price. |
|
Contract Year | K | 2012 | YYYY | The year the contract expires. |
|
Contract Month | L | 8 | MM | The delivery month for the future or option contract. |
|
Contract Day | M | 0 | DD | Indicates the expiration day of the option contract. Only used for daily options. |
|
Settlement | N | 170.8 | String | Settlement Price. |
|
Settlement Cabinet Indicator | O | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. |
|
Open Interest | P | 54 | String | The open interest for the contract. |
|
Total Volume | Q | 2880 | String | The total number of contracts traded -- the sum of Globex, Floor, and PNT. |
|
Globex Volume | R | 998 | String | The number of contracts traded on Globex. |
|
Floor Volume | S | 0 | String | The number of contracts traded on the Floor. | * |
PNT Volume | T | 0 | String | The number of contracts traded in Privately-Negotiated Transactions. | * |
Block Volume | U | 1805 | String | The number of contracts traded as Blocks. | * |
EFP Volume | V | 2 | String | The number of contracts traded as Exchange-for-Physical. | * |
EOO Volume | W | 11 | String | The number of contracts traded as Exchange-of-Options-for-Options. | * |
EFR Volume | X | 6 | String | The number of contracts traded as Exchange-for-Risk. | * |
EFS Volume | Y | 24 | String | The number of contracts traded as Exchange-of Futures-for-Swaps. | * |
EFB Volume | Z | 1 | String | The number of contracts traded as Exchange-for-Basis. | * |
EFM Volume | AA | 42 | String | The number of contracts traded as Exchange-for-Minis. | * |
SUB Volume | AB | 4 | String | The number of contracts traded as Substitution-of-Futures-for-Forwards. | * |
OPNT Volume | AC | 1 | String | The number of contracts traded as OTC Privately Negotiated Transactions. | * |
TAS Volume | AD | 101 | String | The number of contracts traded as Trading-at-Settlement. | * |
TAS Block Volume | AE | 16 | String | The number of TAS contracts traded as Blocks. | * |
TAM Singapore Volume | AF | 3 | String | Trade-at-Marker volume for the Singapore marker. | * |
TAM Singapore Block Volume | AG | 0 | String | Trade-at-Marker block volume for the Singapore marker. | * |
TAM London Volume | AH | 102 | String | Trade-at-Marker volume for the London marker. | * |
TAM London Block Volume | AI | 6 | String | Trade-at-Marker block volume for the London marker. | * |
Globex Open Price | AJ | 177.3 | String | The opening price for the Globex session. |
|
Globex Open Price Bid/Ask Indicator | AK | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Globex Open Price Cabinet Indicator | AL | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. | * |
Globex High Price | AM | 174.5 | String | Indicates the high price for the Globex session. |
|
Globex High Price Bid/Ask Indicator | AN | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Globex High Price Cabinet Indicator | AO | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. | * |
Globex Low Price | AP | 173.5 | String | The low price for the Globex session. |
|
Globex Low Price Bid/Ask Indicator | AQ | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Globex Low Price Cabinet Indicator | AR | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. | * |
Globex Close Price | AS | 174.5 | String | The closing price for the Globex session. |
|
Globex Close Price Bid/Ask Indicator | AT | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Globex Close Price Cabinet Indicator | AU | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. |
|
Floor Open Price | AV | 177.3 | String | The opening price for the Floor session. |
|
Floor Open Price Bid/Ask Indicator | AW | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Floor Open Price Cabinet Indicator | AX | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. |
|
Floor Open Second Price | AY | 176 | String | Lists a second price if there were multiple prices. |
|
Floor Open Second Price Bid/Ask Indicator | AZ | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. | * |
Floor High Price | BA | 177.3 | String | The high price for the Floor session. |
|
Floor High Price Bid/Ask Indicator | BB | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Floor High Price Cabinet Indicator | BC | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. | * |
Floor Low Price | BD | 173.5 | String | The low price for the Floor session. |
|
Floor Low Price Bid/Ask Indicator | BE | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Floor Low Price Cabinet Indicator | BF | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. | * |
Floor Close Price | BG | 162.5 | String | The closing price for the Floor session. |
|
Floor Close Price Bid/Ask Indicator | BH | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Floor Close Price Cabinet Inidicator | BI | CAB | Null, CAB | Indicates that the price is based off a Cabinet (CAB) price. |
|
Floor Close Second Price | BJ | 177.7 | String | Lists a second price if there were multiple prices. |
|
Floor Close Second Price Bid/Ask Indicator | BK | A | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. |
|
Floor Post-Close Price | BL | 173.5 | String | The post-close price for the Floor session. | * |
Floor Post-Close Price Bid/Ask Indicator | BM | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. | * |
Floor Post-Close Second Price | BN | 174.3 | String | Lists a second price if there were multiple prices. | * |
Floor Post-Close Second Price Bid/Ask Indicator | BO | B | Null, B, A, N, $ | Indicates that the price is based off a trade (null), Bid (B), Cabinet ($), Ask (A), or Nominal (N) price. | * |
Delta | BP | 0.986 | String | If an option, the Delta for the contract. | * |
Implied Volatility | BQ | 0.291 | String | If an option, the Implied Volatility for the contract. |
|
Last Trade Date | BR | 20120817 | YYYYMMDD | The last day the contract can trade. | * |
TAM (Trade At Marker) | BS | 123.321 | ###.### | Please see below for products (Product Code) that have TAM associated with them.
|
|
FAQ
Does End-of-Day include both floor and CME Globex prices?
Yes, both venues are included in the dataset. They cannot be delivered separately.
Do you have a list of End-of-Day product availability?
Yes. View product availability.
Do you have sample files available?
Sample files can be found here.
What is the historical product availability for implied volatility data?
CME Products - February 1987
CBOT Products - July 2008
NYMEX Products - November 2009
COMEX Products - November 2009
Why are some expiries and/or strikes missing settlements?
We do not currently provide settlements for expiries or option strikes that have not traded that day and do not have open interest.
Are there any known data issues?
Starting on September 29, 2023 and going forward, the preliminary and final file's strike price will now match what we generate for the early files and with no strike price values with decimals. This affects all NYMEX products.
Due to an upstream technical issue, on September 27, 2024 the early file for 2RB was not generated and we are unable to regenerate.
For Dec 31, 2024, under the DME exchange, the Feb 25 Oman Crude future and marker settle price changed from 76.06 to 74.43.
What format is the file delivered in?
End–of-day is delivered in .CSV format.
What should I expect for the file name?
EOD files delivered via subscription service adhere to the following naming convention:
[DATA TYPE]_[TRADE DATE]_[SUFFIX]. Example: EOD_20120921_P.zip
Data Type:
Data Type will be EOD if your product set does not include all products on the exchange level.
Data type will be EODE if your product set includes all products for an exchange.
Trade Date:
The date in the file name matches the trade date associated with the data in the file.
The date in the file name is in YYYYMMDD format.
Suffix:
E is associated with the earliest file that is sent. This file contains settlement data only.
P is associated with the preliminary file that is sent at the end of the trade date.
F is associated with the final file sent the morning of the next trade date.
What time are these files delivered?
E-files will arrive at approximately 5:30 p.m. CT. P files will arrive at approximately 9:30 p.m. CT. F files will arrive at approximately 9:30 a.m. CT the next trade date.
How are these files delivered?
EOD files are delivered via API transfer.
How many files will I receive for a given trade date?
You can receive one to three files for a given trade date.
Why do you deliver all of the products again, and not just those with adjusted open interest?
After the process to update open interest, all of the values can be considered final. By delivering all of the information in a single file, the user can decide whether to take the P file and then update it if an F file is received, or to only consume the P file.
What are E, P, and F files?
E files are the earliest file sent. This file contains settlement data only. Early files did not exist prior to February 25, 2016. P files are the preliminary file that is sent at the end of the trade date. F files are the final file sent the morning of the next trade date.
Will I always get a P file?
You will always receive a P File for subscription files. One-time orders will only receive the F file, not a P file.
Why did I only receive a P file?
If none of the contracts in your product set had adjusted open interest, then you will only receive a P file. However, in the case where a product has no adjusted open interest, only an E file will be delivered rather than a P file.
Why do I receive F files some days, but not others?
You will only receive an F file if a contract in your product set had adjusted open interest.
Will I always get an F file?
No. F files are only delivered if the open interest of one or more contracts in your product set was adjusted. If no adjustment was made, only a P file will be delivered.
If the open interest can be adjusted, can any of the other values be adjusted as well?
No. All values in the P file with the exception of open interest are final for that trade date. Only the open interest could be updated the next morning.
How do I know if there was adjusted open interest?
Adjusted open interest will be indicated by the presence of a file with an F in the naming convention. When there is no adjustment to open interest, there will be no F file.
What are all these new volumes?
Further definition can be found in the CME Glossary.
Why is underlying product code populated with 0s?
This is a known issue that the team is working to resolve.
How was your Client Systems Wiki Experience? Submit Feedback
Copyright © 2024 CME Group Inc. All rights reserved.