qqq_year_swing
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-09, from what-is-qqq-etf-for-korean-investors.
| year | annual_change_pct | intra_year_range_pct |
|---|---|---|
| 2011 | 1.16 | 19.83 |
| 2012 | 14.44 | 24.79 |
| 2013 | 31.89 | 33.35 |
| 2014 | 17.93 | 27.58 |
| 2015 | 7.81 | 36.59 |
| 2016 | 8.27 | 28.13 |
| 2017 | 30.55 | 33.54 |
| 2018 | -1.43 | 30.72 |
| 2019 | 40.81 | 43.53 |
| 2020 | 46.33 | 90.8 |
| 2021 | 26.26 | 37.4 |
| 2022 | -33.27 | 58.22 |
| 2023 | 52.44 | 58.61 |
| 2024 | 25.97 | 36.38 |
| 2025 | 19.45 | 58.31 |
- Rows × columns
- 15 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
year |
text | 15 distinct values (2011, 2012, 2013…) | |
annual_change_pct |
number | -33.27 to 52.44 | percent |
intra_year_range_pct |
number | 19.83 to 90.8 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
WITH yearly AS
(
SELECT
toYear(date) AS yr,
round(100 * (toFloat64(argMax(close, date)) / toFloat64(argMin(open, date)) - 1), 2) AS annual_change_pct,
round(100 * (toFloat64(max(high)) / toFloat64(min(low)) - 1), 2) AS intra_year_range_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'QQQ'
AND date >= '2011-01-01'
AND date < toStartOfYear(today())
GROUP BY yr
)
SELECT
toString(yr) AS year,
annual_change_pct,
intra_year_range_pct
FROM yearly
ORDER BY yr
AI 어시스턴트에서 이 데이터로 작업하기
이 페이지의 데이터로 바로 쿼리할 수 있게 열립니다. 무료, 계정 불필요.