USA 500 (S&P 500) Historical Data Downloader

A desktop app that downloads USA 500 (S&P 500) (USA500IDXUSD) price history on your own machine, written straight to your disk as CSV or JSON. Daily and monthly USA 500 (S&P 500) candles reach back to 1980-01-02 — around 46 years — while quote-level tick history begins 2012-01-16. A complete USA 500 (S&P 500) 1-minute series is roughly 5.5M rows, about 274 MB as CSV.

Or work out the size first: the file-size calculator takes a range and returns the row count and CSV size.

Windows, macOS, Linux · €9 one-time for the entry licence · get the app

What the app fetches for USA 500 (S&P 500)

USA 500 (S&P 500) timeframes the app supports

• Tick (every quote)
• 1 second
• 1 minute
• 5 minutes
• 15 minutes
• 30 minutes
• 1 hour
• 4 hours
• Daily
• Monthly

USA 500 (S&P 500) coverage & file size, timeframe by timeframe

USA 500 (S&P 500) does not start at the same date at every granularity: daily candles begin 1980-01-02, but the tick archive only reaches 2012-01-16, roughly 32 years later. Each row below gives that timeframe's own start date and scale, current through 2026-11-02:

Counts are approximate, derived from index session hours across the available history. Tick and 1-second runs are queued and resumable rather than fetched in one pass. See the data methodology for how candles are built.

Working with the USA 500 (S&P 500) series

This is a cash-index CFD, not the S&P 500 itself and not a futures contract, and the distinction changes results: the price tracks the index level, which excludes dividends. Total return on the S&P has historically run roughly two percentage points a year above the price index, so any long-horizon study run on this series understates buy-and-hold by about that much. Note also the coverage split — daily candles reach 1980, but tick data only begins 2012.

S&P 500 historical data — what the CSV holds at each timeframe

S&P 500 1-minute historical data

The 1-minute series starts 2011-09-19 and the full run to today is 5.5M rows, about 274 MB as CSV; hourly is 91,500 rows, about 5 MB as CSV. Quote-level ticks begin 2012-01-16. Before that there is no intraday S&P 500 from this source at any resolution — only daily candles, which reach back to 1980 and total just 11,800 rows, about 590 KB as CSV.

S&P 500 historical data CSV download — the columns

Candle files are timestamp,open,high,low,close with UTC timestamps in epoch milliseconds; tick files carry the ask and bid of every quote, ask first. There is no volume column: an index has no traded volume of its own, and this is the source's index CFD quote, not an exchange tape. If a strategy needs volume, it needs a different dataset, and it is better to know that before the download than after.

Why the daily close is not the 16:00 New York close

Every candle boundary is UTC midnight. The cash market closes at 16:00 New York time, which is 20:00 UTC in summer and 21:00 UTC in winter, and the CFD keeps quoting after it. So this file's daily "close" is the last quote before midnight UTC, several hours after the official close, and it will not match the published S&P 500 closing level. That is a boundary, not an error. If you need candles that end at the cash close, build them from the 1-minute file with your own session cut.

The opening bell moves in UTC — on different weeks from Europe's

The 09:30 New York open is 13:30 UTC during US daylight time and 14:30 UTC in winter. The US changes its clocks on the second Sunday of March and the first Sunday of November; Europe changes on the last Sundays of March and October. For two or three weeks every spring and one week every autumn, London and New York are an hour closer together than usual. A strategy that hard-codes "the open" as one UTC hour trades the wrong minute for about five months of every year, and a London-to-New-York overlap study gets those weeks wrong as well.

US500, SPX500, US SPX 500 — one series

Brokers and charting platforms label the same index CFD differently; the source calls it USA 500 (USA500IDXUSD). Whatever your platform calls it, this is the file — tick to monthly, written to your own disk. The app is a free download, and every licence, including the €9 entry tier, reaches the whole archive at every timeframe. See what each tier changes.

What's inside the USA 500 (S&P 500) file

timestamp,open,high,low,close

One row per candle, stamped with the bar's opening time; tick files instead carry timestamp,askPrice,bidPrice,askVolume,bidVolume on every quote — ask first. Timestamps are epoch milliseconds in UTC, which pd.to_datetime(df.timestamp, unit="ms", utc=True) or =A2/86400000+DATE(1970,1,1) turns into a date. Worked examples and import steps are in the CSV & JSON format guide.

About USA 500 (S&P 500)

USA 500 (S&P 500) (USA500IDXUSD) is a stock-index CFD with 46 years of retrievable history. It is commonly used for backtesting index and CFD strategies, studying long-term market cycles and drawdowns, benchmarking portfolios and building quantitative research datasets. Pick any date range from 1980-01-02 onward, choose a timeframe and the bid or ask side, and the app fetches and writes the files locally — no scripting.

Frequently asked questions

How far back does USA 500 (S&P 500) data go?

USA 500 (S&P 500) daily and monthly candles reach back to 1980-01-02 — roughly 46 years. Tick and intraday history is shorter: it begins 2012-01-16. Both run up to the last completed trading day, and every licence tier reaches all of it.

Why does USA 500 (S&P 500) tick data start later than its daily candles?

Because they come from different parts of the archive. Daily and monthly USA 500 (S&P 500) candles are reconstructed from long-run end-of-day records going back to 1980-01-02, while the tick archive — every individual bid/ask quote — only begins 2012-01-16, about 32 years later. If your study needs the full 46-year span, work in daily candles; if it needs quote-level detail, 2012-01-16 is the earliest USA 500 (S&P 500) start date available.

How large is a full USA 500 (S&P 500) download?

The complete USA 500 (S&P 500) 1-minute history is roughly 5.5M rows, about 274 MB as CSV. Daily candles over the same instrument are far smaller — around 11,800 rows, 590 KB. Tick and 1-second runs are larger again and are queued and resumable rather than fetched in one pass. Sizes are approximate; nothing is priced by volume.

What columns are in the USA 500 (S&P 500) CSV file?

OHLC files contain a timestamp plus open, high, low and close columns; tick files contain a timestamp with bid and ask prices. All timestamps are UTC. The files import directly into Excel, Google Sheets, Python (pandas read_csv), R, MetaTrader, NinjaTrader and TradingView.

Do you sell USA 500 (S&P 500) data?

No — we sell software. The MarketData Hub client retrieves USA 500 (S&P 500) (USA500IDXUSD) on your own machine, under your instruction, directly from the source; we never host, cache or relay it. Your use of the retrieved data is subject to the source's terms.

Guides

• Get the app — Windows, macOS, Linux
• How to download historical index data
• CSV & JSON format — columns explained
• Tick data vs OHLC candles
• Backtesting with historical data
• Nasdaq 100 history
• Excel & Google Sheets
• How far back data goes
• Import into NinjaTrader
• vs Dukascopy export

Related Indices – Americas

• US Dollar Index
• USA 30 (Dow Jones)
• USA 100 (Nasdaq)
• US Small Cap 2000 (Russell)
• Volatility Index (VIX)

Preview your USA 500 (S&P 500) download — pick a range, see the exact file →

Sizing it up rather than fetching it? Estimate USA 500 (S&P 500) rows and CSV size for any date range.

The preview runs in the browser; the download runs in the free desktop app, on your machine.