STRASMORE/EXPLORE 3,256 QUERIES

price_monthly

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 qqq-etf-for-israeli-investors.

as of series 94×3read in context →
price_monthly — 94 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelclose_usd
2019-01-01Jan 2019168.16
2019-02-01Feb 2019173.19
2019-03-01Mar 2019179.66
2019-04-01Apr 2019189.54
2019-05-01May 2019173.95
2019-06-01Jun 2019186.74
2019-07-01Jul 2019191.1
2019-08-01Aug 2019187.47
2019-09-01Sep 2019188.81
2019-10-01Oct 2019197.08
2019-11-01Nov 2019205.1
2019-12-01Dec 2019212.61
2020-01-01Jan 2020219.07
2020-02-01Feb 2020205.8
2020-03-01Mar 2020190.4
2020-04-01Apr 2020218.91
2020-05-01May 2020233.36
2020-06-01Jun 2020247.6
2020-07-01Jul 2020265.79
2020-08-01Aug 2020294.88
2020-09-01Sep 2020277.84
2020-10-01Oct 2020269.38
2020-11-01Nov 2020299.62
2020-12-01Dec 2020313.74
2021-01-01Jan 2021314.56
2021-02-01Feb 2021314.14
2021-03-01Mar 2021319.13
2021-04-01Apr 2021337.99
2021-05-01May 2021333.93
2021-06-01Jun 2021354.43
2021-07-01Jul 2021364.57
2021-08-01Aug 2021379.95
2021-09-01Sep 2021357.96
2021-10-01Oct 2021386.11
2021-11-01Nov 2021393.82
2021-12-01Dec 2021397.85
2022-01-01Jan 2022363.05
2022-02-01Feb 2022346.8
2022-03-01Mar 2022362.54
2022-04-01Apr 2022313.25
2022-05-01May 2022308.28
2022-06-01Jun 2022280.28
2022-07-01Jul 2022315.46
2022-08-01Aug 2022299.27
2022-09-01Sep 2022267.26
2022-10-01Oct 2022277.95
2022-11-01Nov 2022293.36
2022-12-01Dec 2022266.28
2023-01-01Jan 2023294.62
2023-02-01Feb 2023293.56
2023-03-01Mar 2023320.93
2023-04-01Apr 2023322.56
2023-05-01May 2023347.99
2023-06-01Jun 2023369.42
2023-07-01Jul 2023383.68
2023-08-01Aug 2023377.99
2023-09-01Sep 2023358.27
2023-10-01Oct 2023350.87
2023-11-01Nov 2023388.83
2023-12-01Dec 2023409.52
2024-01-01Jan 2024416.97
2024-02-01Feb 2024439
2024-03-01Mar 2024444.01
2024-04-01Apr 2024424.59
2024-05-01May 2024450.71
2024-06-01Jun 2024479.11
2024-07-01Jul 2024471.07
2024-08-01Aug 2024476.27
2024-09-01Sep 2024488.07
2024-10-01Oct 2024483.85
2024-11-01Nov 2024509.74
2024-12-01Dec 2024511.23
2025-01-01Jan 2025522.29
2025-02-01Feb 2025508.17
2025-03-01Mar 2025468.92
2025-04-01Apr 2025475.47
2025-05-01May 2025519.11
2025-06-01Jun 2025551.64
2025-07-01Jul 2025565.01
2025-08-01Aug 2025570.4
2025-09-01Sep 2025600.37
2025-10-01Oct 2025629.07
2025-11-01Nov 2025619.25
2025-12-01Dec 2025614.31
2026-01-01Jan 2026621.87
2026-02-01Feb 2026607.29
2026-03-01Mar 2026577.18
2026-04-01Apr 2026667.74
2026-05-01May 2026738.31
2026-06-01Jun 2026736.4
2026-07-01Jul 2026687.99
2026-08-01Aug 2026716.76
2026-09-01Sep 2026739.77
2026-10-01Oct 2026754.41
Rows × columns
94 × 3
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for price_monthly, derived from the stored result.
ColumnTypeRangeNotes
month date 2019-01-01 to 2026-10-01
month_label text 94 distinct values (Apr 2019, Apr 2020, Apr 2021…)
close_usd number 168.16 to 754.41 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,
    formatDateTime(toStartOfMonth(date), '%b %Y')  AS month_label,
    round(toFloat64(argMax(close, date)), 2)       AS close_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'QQQ'
  AND date >= '2019-01-01'
GROUP BY toStartOfMonth(date)
ORDER BY month
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent