SPDR S&P 500 ETF Historical Data Downloader
A desktop app that downloads SPDR S&P 500 ETF (SPYUSUSD) price history on your own machine, written straight to your disk as CSV or JSON. History runs from 2017-02-16 — around 9 years — at every timeframe from raw ticks to monthly candles. A complete SPDR S&P 500 ETF 1-minute series is roughly 3.5M rows, about 173 MB as CSV.
Preview a SPDR S&P 500 ETF download →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 SPDR S&P 500 ETF
| Symbol | SPYUSUSD |
|---|---|
| Instrument | SPDR S&P 500 ETF |
| Asset class | ETFs |
| History available from | 2017-02-16 |
| Timeframes | Tick → 1s → 1m → 5m → 15m → 30m → 1h → 4h → Daily → Monthly |
| Price types | Bid & Ask |
| File formats | CSV, JSON (MetaTrader, NinjaTrader, Parquet & SQLite/DuckDB from the Pro licence) |
| Coverage | 2017-02-16 → 2026-09-17 (last completed trading day) |
| Retrieval | Local — your machine connects directly to Dukascopy Bank SA |
| Runs on | Windows, macOS, Linux |
SPDR S&P 500 ETF timeframes the app supports
- Tick (every quote)
- 1 second
- 1 minute
- 5 minutes
- 15 minutes
- 30 minutes
- 1 hour
- 4 hours
- Daily
- Monthly
SPDR S&P 500 ETF coverage & file size, timeframe by timeframe
Every SPDR S&P 500 ETF timeframe shares the same 2017-02-16 start date, but not the same scale — coarser candles stay small while tick and intraday files grow fast. Current through 2026-09-17:
| Timeframe | History from | Approx. rows | Approx. CSV |
|---|---|---|---|
| Tick (every quote) | 2017-02-16 | very large | — |
| 1 second | 2017-02-16 | very large | — |
| 1 minute | 2017-02-16 | ~3.5M | ~173 MB |
| 5 minutes | 2017-02-16 | ~692K | ~35 MB |
| 15 minutes | 2017-02-16 | ~231K | ~12 MB |
| 30 minutes | 2017-02-16 | ~115K | ~6 MB |
| 1 hour | 2017-02-16 | ~57,700 | ~3 MB |
| 4 hours | 2017-02-16 | ~14,400 | ~721 KB |
| Daily | 2017-02-16 | ~2,400 | ~120 KB |
| Monthly | 2017-02-16 | ~110 | ~6 KB |
Counts are approximate, derived from etf 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 SPDR S&P 500 ETF series
SPY is the oldest US ETF, launched in January 1993, and it is still structured as a unit investment trust — which means it may not reinvest the dividends it receives. Cash accumulates un-invested until the quarterly distribution, a small but persistent drag a total-return index does not carry. Two consequences here: the price drops on each ex-dividend date and those drops are not signals, and if you compare this against the S&P 500 CFD series in this catalogue, one trades exchange hours while the other runs nearly around the clock, so a join on date alone lines up sessions that never overlapped.
What's inside the SPDR S&P 500 ETF file
timestamp,open,high,low,closeOne row per candle; tick files instead carry timestamp,bid,ask on every quote. All timestamps are UTC. Worked examples and import steps are in the CSV & JSON format guide.
About SPDR S&P 500 ETF
SPDR S&P 500 ETF (SPYUSUSD) is an ETF CFD with 9 years of retrievable history. It is commonly used for ETF and portfolio backtesting, asset-allocation research, charting long-term performance and training quantitative models. Pick any date range from 2017-02-16 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 SPDR S&P 500 ETF data go?
- SPDR S&P 500 ETF history runs from 2017-02-16 — roughly 9 years — up to the last completed trading day, at every timeframe from raw ticks to monthly candles. Every licence tier reaches all of it.
- How large is a full SPDR S&P 500 ETF download?
- The complete SPDR S&P 500 ETF 1-minute history is roughly 3.5M rows, about 173 MB as CSV. Daily candles over the same instrument are far smaller — around 2,400 rows, 120 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 SPDR S&P 500 ETF 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 SPDR S&P 500 ETF data?
- No — we sell software. The MarketData Hub client retrieves SPDR S&P 500 ETF (SPYUSUSD) 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 etf data
- CSV & JSON format — columns explained
- Tick data vs OHLC candles
- Backtesting with historical data
- Excel & Google Sheets
- Load in Python (pandas)
Related ETFs
- PowerShares QQQ ETF (Nasdaq)
- SPDR Dow Jones Industrial Avg ETF
- iShares Russell 2000 ETF
- SPDR Gold Shares ETF
- iShares Silver Trust ETF
- iShares MSCI Emerging Markets ETF
- iShares 20+ Year Treasury Bond ETF
- Financial Select Sector SPDR Fund
- Technology Select Sector SPDR Fund
- Energy Select Sector SPDR Fund
- Industrial Select Sector SPDR Fund
- Health Care Select Sector SPDR Fund
Preview your SPDR S&P 500 ETF download — pick a range, see the exact file →
Sizing it up rather than fetching it? Estimate SPDR S&P 500 ETF 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.