PowerShares QQQ ETF (Nasdaq) Historical Data Downloader
A desktop app that downloads PowerShares QQQ ETF (Nasdaq) (QQQUSUSD) price history on your own machine, written straight to your disk as CSV or JSON. History runs from 2017-01-26 — around 9 years — at every timeframe from raw ticks to monthly candles. A complete PowerShares QQQ ETF (Nasdaq) 1-minute series is roughly 3.5M rows, about 174 MB as CSV.
Preview a PowerShares QQQ ETF (Nasdaq) 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 PowerShares QQQ ETF (Nasdaq)
| Symbol | QQQUSUSD |
|---|---|
| Instrument | PowerShares QQQ ETF (Nasdaq) |
| Asset class | ETFs |
| History available from | 2017-01-26 |
| 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-01-26 → 2026-09-17 (last completed trading day) |
| Retrieval | Local — your machine connects directly to Dukascopy Bank SA |
| Runs on | Windows, macOS, Linux |
PowerShares QQQ ETF (Nasdaq) timeframes the app supports
- Tick (every quote)
- 1 second
- 1 minute
- 5 minutes
- 15 minutes
- 30 minutes
- 1 hour
- 4 hours
- Daily
- Monthly
PowerShares QQQ ETF (Nasdaq) coverage & file size, timeframe by timeframe
Every PowerShares QQQ ETF (Nasdaq) timeframe shares the same 2017-01-26 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-01-26 | very large | — |
| 1 second | 2017-01-26 | very large | — |
| 1 minute | 2017-01-26 | ~3.5M | ~174 MB |
| 5 minutes | 2017-01-26 | ~696K | ~35 MB |
| 15 minutes | 2017-01-26 | ~232K | ~12 MB |
| 30 minutes | 2017-01-26 | ~116K | ~6 MB |
| 1 hour | 2017-01-26 | ~58,000 | ~3 MB |
| 4 hours | 2017-01-26 | ~14,500 | ~725 KB |
| Daily | 2017-01-26 | ~2,400 | ~121 KB |
| Monthly | 2017-01-26 | ~120 | ~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 PowerShares QQQ ETF (Nasdaq) series
The Nasdaq-100's own composition rules changed inside this series. On 24 July 2023 the index ran its first special rebalance since 2011, triggered by a cap on how much weight its largest members may collectively hold; the seven biggest names were cut from roughly 56% of the index to roughly 44% overnight, with no securities added or removed. Any concentration or diversification metric computed across that date is measuring a rule change rather than the market. Note too what the index excludes by construction — it holds no financials, so it is not a broad-market proxy however it gets used.
What's inside the PowerShares QQQ ETF (Nasdaq) 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 PowerShares QQQ ETF (Nasdaq)
PowerShares QQQ ETF (Nasdaq) (QQQUSUSD) 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-01-26 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 PowerShares QQQ ETF (Nasdaq) data go?
- PowerShares QQQ ETF (Nasdaq) history runs from 2017-01-26 — 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 PowerShares QQQ ETF (Nasdaq) download?
- The complete PowerShares QQQ ETF (Nasdaq) 1-minute history is roughly 3.5M rows, about 174 MB as CSV. Daily candles over the same instrument are far smaller — around 2,400 rows, 121 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 PowerShares QQQ ETF (Nasdaq) 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 PowerShares QQQ ETF (Nasdaq) data?
- No — we sell software. The MarketData Hub client retrieves PowerShares QQQ ETF (Nasdaq) (QQQUSUSD) 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
- SPDR S&P 500 ETF
- 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 PowerShares QQQ ETF (Nasdaq) download — pick a range, see the exact file →
Sizing it up rather than fetching it? Estimate PowerShares QQQ ETF (Nasdaq) 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.