price_levels
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-04, from qqq-vs-spy-for-korean-investors.
| month | month_label | qqq_usd | spy_usd |
|---|---|---|---|
| 2025-04-01 | 2025년 4월 | 475.47 | 554.54 |
| 2025-05-01 | 2025년 5월 | 519.11 | 589.39 |
| 2025-06-01 | 2025년 6월 | 551.64 | 617.85 |
| 2025-07-01 | 2025년 7월 | 565.01 | 632.08 |
| 2025-08-01 | 2025년 8월 | 570.4 | 645.05 |
| 2025-09-01 | 2025년 9월 | 600.37 | 666.18 |
| 2025-10-01 | 2025년 10월 | 629.07 | 682.06 |
| 2025-11-01 | 2025년 11월 | 619.25 | 683.39 |
| 2025-12-01 | 2025년 12월 | 614.31 | 681.92 |
| 2026-01-01 | 2026년 1월 | 621.87 | 691.97 |
| 2026-02-01 | 2026년 2월 | 607.29 | 685.99 |
| 2026-03-01 | 2026년 3월 | 577.18 | 650.34 |
| 2026-04-01 | 2026년 4월 | 667.74 | 718.66 |
| 2026-05-01 | 2026년 5월 | 738.31 | 756.48 |
| 2026-06-01 | 2026년 6월 | 736.4 | 746.77 |
| 2026-07-01 | 2026년 7월 | 687.99 | 747.03 |
| 2026-08-01 | 2026년 8월 | 716.76 | 767.05 |
| 2026-09-01 | 2026년 9월 | 739.77 | 762.63 |
| 2026-10-01 | 2026년 10월 | 749.58 | 769.64 |
- Rows × columns
- 19 × 4
- Period covered
- to
- 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 |
|---|---|---|---|
month |
date | 2025-04-01 to 2026-10-01 | |
month_label |
text | 19 distinct values (2025년 10월, 2025년 11월, 2025년 12월…) | |
qqq_usd |
number | 475.47 to 749.58 | US dollars |
spy_usd |
number | 554.54 to 769.64 | US dollars |
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.
SELECT
toString(toStartOfMonth(date)) AS month,
any(concat(toString(toYear(date)), '년 ', toString(toMonth(date)), '월')) AS month_label,
round(toFloat64(argMaxIf(close, date, ticker = 'QQQ')), 2) AS qqq_usd,
round(toFloat64(argMaxIf(close, date, ticker = 'SPY')), 2) AS spy_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('QQQ', 'SPY')
AND date >= toStartOfMonth(today() - 540)
AND date < today()
GROUP BY month
HAVING countIf(ticker = 'QQQ') > 0 AND countIf(ticker = 'SPY') > 0
ORDER BY month
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.