Early access is open. Free sample datasets are live now. Download a sample

Historical data ยท Early access

E-mini S&P 500 Futures (ES) Historical Data Download

E-mini S&P 500 futures (ES): intraday and daily bars, back-adjusted continuous series, trades and L1 quotes, settlements, open interest and COT data.

Coverage

Data available for ES

ES is the most searched futures contract we carry, and every futures dataset covers it. The cards show which plan gives you what.

Data What it is Granularity Delivery Plan Details
OHLCV bars, intraday and daily Per-contract bars with settlement and open interest on daily rows 1 second to 1 day API and CSV/Parquet file Front-month daily on Free; 1-minute from Starter Product page
Continuous and back-adjusted contracts One long series per root, raw, back-adjusted or ratio-adjusted 1 minute to 1 day API and file Daily on Starter; intraday on Pro Product page
Trades and L1 quotes Every trade with aggressor side and every best bid/offer change Each event, nanoseconds where the venue sends them API and file 30 days of trades on Pro; full history and L1 on Business Product page
Settlement, open interest, limits The official daily numbers the exchange publishes per contract 1 day API and file Prior-day front months on Free; full history on Starter Product page
CFTC Commitments of Traders Weekly long and short positions by trader category Weekly (Tuesday data, Friday release) API and free bulk file Raw reports on Free; derived fields on Starter Product page

Sample data

Sample data preview

Futures Positioning (CFTC Commitments of Traders)

The free COT file covers all financial futures. These are the three E-mini S&P 500 rows, one per weekly report from late October to mid-November 2026.

symbol date market exchange cftc_code open_interest dealer_long dealer_short asset_manager_long asset_manager_short leveraged_funds_long leveraged_funds_short change_in_open_interest
ES 2026-10-27 E-MINI S&P 500 CHICAGO MERCANTILE EXCHANGE 13874A 1955711 193848 833441 1111055 187606 102079 502683 20241
ES 2026-11-03 E-MINI S&P 500 CHICAGO MERCANTILE EXCHANGE 13874A 1986532 182419 870993 1111721 183137 125269 497587 30821
ES 2026-11-10 E-MINI S&P 500 CHICAGO MERCANTILE EXCHANGE 13874A 2017687 175005 910294 1115756 201626 145755 448815 31155

Source: CFTC

Open interest rose each week, from about 1.96 million to 2.02 million contracts. The ZIP also has the Micro E-mini (MES) rows if you want both.

Schema

Schema

ES bars use the futures schema below. On daily rows, settlement_price is the official CME value, which can differ from the last trade in close.

Field Type Description
symbol string Contract in our format, e.g. ESZ6
root string Product root, e.g. ES
exchange string Venue MIC or short code, e.g. CME
interval string 1s, 1m, 5m, 1h, 1d
timestamp string Bar start, ISO 8601 UTC (intraday)
date string Trading session date, YYYY-MM-DD (daily)
session_date string Trading day the bar belongs to; the Globex session opens the evening before (intraday)
open number First trade price
high number Highest trade price
low number Lowest trade price
close number Last trade price in the bar
volume number Contracts traded
trade_count number Number of trades (optional)
vwap number Volume-weighted average price (optional)
settlement_price number Official exchange settlement (daily, optional)
open_interest number Open contracts reported for the session (daily, optional)
buy_aggressor_volume number Volume where the buyer crossed the spread (optional)
sell_aggressor_volume number Volume where the seller crossed the spread (optional)

API

Get it by API

Here is an early access example for one Globex session of ES minute bars on the December 2026 contract.

curl (example)

curl -G "https://api.marketdata.co/v1/futures/bars" \
  -H "Authorization: Bearer $MARKETDATA_API_KEY" \
  --data-urlencode "symbol=ESZ6" \
  --data-urlencode "interval=1m" \
  --data-urlencode "start=2026-11-17T23:00:00Z" \
  --data-urlencode "end=2026-11-18T22:00:00Z"

Python (example)

import os
import requests
import pandas as pd

resp = requests.get(  # ES minute bars, regular trading hours only
    "https://api.marketdata.co/v1/futures/bars",
    headers={"Authorization": f"Bearer {os.environ['MARKETDATA_API_KEY']}"},
    params={"symbol": "ESZ6", "interval": "1m",
            "start": "2026-11-17T23:00:00Z", "end": "2026-11-18T22:00:00Z"},
    timeout=30,
)
resp.raise_for_status()
bars = pd.DataFrame(resp.json()["results"])
bars["timestamp"] = pd.to_datetime(bars["timestamp"], utc=True)
rth = bars[(bars["timestamp"] >= "2026-11-18T14:30:00Z") & (bars["timestamp"] < "2026-11-18T21:00:00Z")]
print(rth["volume"].sum() / bars["volume"].sum())

The Python tab splits out the cash session, 09:30 to 16:00 New York time. Most ES volume trades inside it.

Datasets

Get it as a file

ES files are sold per root, every expiry included. Planned prices:

  • Formats: CSV and Parquet
  • 1-minute bars: $12 per root per year, all expiries included
  • Full daily history: $39 per root
  • Continuous contracts: $29 per root, all three adjustments and the roll calendar
  • Trades: $49 per root per year ($99 with L1 quotes)
  • COT positioning: free bulk download

If you just need a clean long series for a daily strategy, the $29 continuous file covers full history with all three adjustments.

Use cases

About E-mini S&P 500 Futures (for traders)

ES is CME's E-mini S&P 500 future, the most traded equity index contract in the world. Each point is worth $50, so a 10-point move is $500 per contract. Contracts are quarterly (March, June, September, December) and cash-settled on the third Friday of the expiry month.

It moves with the S&P 500: Fed decisions, CPI and payrolls, big-tech earnings and anything that changes risk appetite. Because it trades nearly around the clock, ES is where overnight news shows up first, hours before the cash open.

Globex runs Sunday 17:00 to Friday 16:00 Chicago time, with a daily break from 16:00 to 17:00. The busiest stretch is the cash session, 08:30 to 15:00 Chicago time, and the 15:00 to 15:15 window after the cash close still trades actively.

Rolls are the main data issue. Volume shifts to the next quarter about eight days before expiry, and the price gap between contracts reflects dividends and interest. A raw continuous series shows a jump at each roll; back-adjusted series remove it but change the price level of older bars.

Pricing

Pricing

These are the futures plan rows that apply to ES:

Free $0 Starter $29/mo Pro $79/mo Business $249/mo
Daily bars Front month, 1 year Full history Full history Full history
Intraday bars No 1-minute, 10-minute delay, 5 years 1-second to daily, delayed Real-time WebSocket bars
Continuous contracts No Daily, all three adjustments Adds intraday and custom roll rule As Pro
Settlement and OI Prior day, front months Full history Adds preliminary settlements and limits As Pro
Trades and L1 quotes No No Last 30 days of trades, delayed Full history, L1 quotes, real time
COT positioning All raw reports Adds net positions and percentiles As Starter As Starter

Full plan details are on the pricing page.

FAQ

Frequently asked questions

How far back does ES historical data go?

E-mini S&P 500 futures launched in 1997, so that's the earliest possible start. We'll publish our exact start dates per resolution before launch.

Is ES data back-adjusted?

Contract-level bars are raw prices. The continuous dataset offers unadjusted, back-adjusted (Panama) and ratio-adjusted versions, and records the underlying contract on every bar.

What time zone are ES bars in?

UTC. Each bar also carries a session_date, because a Globex session opens the evening before its trading day.

Is there free ES data?

Yes, ES positioning is in the free CFTC sample, and front-month daily bars are planned for the Free plan. Intraday bars start on Starter.

Can I get ES 1-minute data in Excel?

Yes, as CSV. One year of ES minute bars on the front contract is roughly 340,000 rows, which fits in Excel.

Keep reading