ES historical data: 1-minute to daily bars, 2008 to 2026
ES is the E-mini S&P 500 futures; it tracks the S&P 500 index. MarketParquet holds ES as a futures contract with 1-minute, 5-minute, 30-minute, 1-hour and daily OHLCV bars from 2008-01-02 to 2026-09-11 (4,717 daily bars), continuous contract, ratio-adjusted at each roll, as one Parquet file per trading day.
ES is the most traded equity index future. Nearly every intraday index strategy is developed on its 1-minute or 5-minute bars.
ES at a glance
| Instrument | E-mini S&P 500 futures (ES) |
| Asset class | Futures (continuous contract) |
| First bar | 2008-01-02 |
| Latest bar | 2026-09-11 |
| Daily bars | 4,717 |
| Timeframes | 1-minute, 5-minute, 30-minute, 1-hour, daily |
| Adjustment | continuous contract, ratio-adjusted at each roll |
| Timezone | US/Eastern bar open time; intraday files include pre-market and after-hours bars where available |
| Format | Apache Parquet, one file per trading day containing every Futures symbol |
Sample: ES 30-minute bars on 2026-09-16
The first regular-session bars from the newest 30-minute file, read live from the archive. Prices are the values as published; the full session has many more rows.
| timestamp | open | high | low | close | volume |
|---|---|---|---|---|---|
| 09:30 | 7676.50 | 7686.50 | 7669.00 | 7684.25 | 86,467 |
| 10:00 | 7684.50 | 7686.50 | 7669.50 | 7671.75 | 58,411 |
| 10:30 | 7671.75 | 7685.00 | 7670.00 | 7684.25 | 49,632 |
| 11:00 | 7684.50 | 7692.75 | 7683.75 | 7686.00 | 68,517 |
| 11:30 | 7685.75 | 7699.00 | 7682.00 | 7689.00 | 62,362 |
| 12:00 | 7689.00 | 7689.75 | 7680.25 | 7683.25 | 31,018 |
| 12:30 | 7683.25 | 7684.00 | 7678.25 | 7679.25 | 25,296 |
| 13:00 | 7679.50 | 7681.00 | 7674.00 | 7680.75 | 28,457 |
Corporate actions in the changelog
ES is a continuous contract: each roll is ratio-adjusted so the series has no artificial gaps between expiries. There are no splits to record; the continuous futures page explains the roll method.
Load ES in Python
Files are partitioned by trading day, so pulling one symbol means filtering across files. DuckDB reads the whole daily history in one statement; union_by_name and the COALESCE cover the older daily files, which carry a timestamp column where newer ones carry date:
import duckdb
es = duckdb.sql("""
SELECT COALESCE(date, CAST(timestamp AS DATE)) AS date,
open, high, low, close, volume
FROM read_parquet('by_date/futures_daily/*/*.parquet', union_by_name=true)
WHERE symbol = 'ES'
ORDER BY 1
""").df()
Intraday files all share one schema, so Polars can scan a year of 5-minute bars lazily and keep only ES:
import polars as pl
bars = (
pl.scan_parquet("by_date/futures_5min/2025/*.parquet")
.filter(pl.col("symbol") == "ES")
.select(["timestamp", "open", "high", "low", "close", "volume"])
.sort("timestamp")
.collect()
)
Timestamps are US/Eastern bar open times. The Polars guide, the DuckDB guide and the backtrader guide take it from here: multi-year loads, resampling and feeding a backtest engine.
Available Futures files
| Timeframe | Files | Date range |
|---|---|---|
| 1-Min | 5,854 | 2007-12-31 to 2026-09-16 |
| 5-Min | 5,854 | 2007-12-31 to 2026-09-16 |
| 30-Min | 5,854 | 2007-12-31 to 2026-09-16 |
| 1-Hour | 5,854 | 2007-12-31 to 2026-09-16 |
| Daily | 4,869 | 2007-12-31 to 2026-09-16 |
Every file holds all Futures symbols for that day, ES included.
Get ES data
Free: a free account can download roughly the last year of daily Futures files, which include ES, from the daily browse page or by API key. Complete Archive: every timeframe and the full history back to 2008-01-02 for ES and every other symbol, $79 one-time.
> Download the free daily sample > See pricingFAQ
Is ES history split-adjusted?
Futures do not split. ES is a continuous, ratio-adjusted series, so returns are correct across contract rolls.
How far back does ES go?
The first ES bar in the archive is dated 2008-01-02 and the newest is 2026-09-11. New sessions are added the same night, typically by midnight ET.
What timezone are the intraday bars in?
US/Eastern. Regular hours are 9:30 AM to 4:00 PM ET; 1-minute files also carry pre-market from 4:00 AM and after-hours to 8:00 PM where trades occurred.
Can I download only ES?
Files are per day, not per symbol, so you download the daily or intraday files for the dates you need and filter on symbol == "ES". A year of daily files is small; the snippets above do the filtering in one pass.
Related
Futures data hub · browse Futures daily · all symbol pages · pricing
Other Futures pages: NQ · MES · MNQ · YM · RTY · CL · MCL · GC · MGC · SI · NG · ZN · BTC