STRASMORE/EXPLORE 3,293 QUERIES
Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan

Median and 90th percentile US share price, by month

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-11-07, from How Much Does One Share of Stock Cost?.

as of series 48×4read in context →
Median and 90th percentile US share price, by month — 48 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelmedian_share_pricep90_share_price
2022-11-01Nov 202220.0285.83
2022-12-01Dec 202220.1486.59
2023-01-01Jan 202321.291.92
2023-02-01Feb 202321.7993.14
2023-03-01Mar 202320.4283.31
2023-04-01Apr 202321.0285.34
2023-05-01May 202321.1385.52
2023-06-01Jun 202321.8690.37
2023-07-01Jul 202321.8791.1
2023-08-01Aug 202321.8590.88
2023-09-01Sep 202322.0486.4
2023-10-01Oct 202321.4182.76
2023-11-01Nov 202322.3185.93
2023-12-01Dec 202323.388.94
2024-01-01Jan 202423.589.82
2024-02-01Feb 202423.5197.38
2024-03-01Mar 202423.3195
2024-04-01Apr 202423.4290.5
2024-05-01May 202424.0790.46
2024-06-01Jun 202423.8889.28
2024-07-01Jul 202424.0785.32
2024-08-01Aug 202423.9481.98
2024-09-01Sep 202424.3887.56
2024-10-01Oct 202424.992.04
2024-11-01Nov 202424.8492.91
2024-12-01Dec 202424.7591.55
2025-01-01Jan 202524.6591.5
2025-02-01Feb 202524.8491.07
2025-03-01Mar 202524.1189.28
2025-04-01Apr 202523.3484.16
2025-05-01May 202524.6689.64
2025-06-01Jun 20252590.29
2025-07-01Jul 202525.0190.49
2025-08-01Aug 202525.1991.5
2025-09-01Sep 202525.5192.26
2025-10-01Oct 202524.5182.68
2025-11-01Nov 202525.6591.8
2025-12-01Dec 202525.1386.34
2026-01-01Jan 202625.4891.05
2026-02-01Feb 202625.3691.9
2026-03-01Mar 202624.2479.66
2026-04-01Apr 202625.1680.64
2026-05-01May 202625.4389.21
2026-06-01Jun 202625.0681.51
2026-07-01Jul 202624.8382.58
2026-08-01Aug 202625.0785.04
2026-09-01Sep 202624.881.2
2026-10-01Oct 202624.4180.29
Rows × columns
48 × 4
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 Median and 90th percentile US share price, by month, derived from the stored result.
ColumnTypeRangeNotes
month date 2022-11-01 to 2026-10-01
month_label text 48 distinct values (Apr 2023, Apr 2024, Apr 2025…)
median_share_price number 20.02 to 25.65 US dollars
p90_share_price number 79.66 to 97.38 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(quantileDeterministic(0.5)(toFloat64(close), cityHash64(ticker)), 2) AS median_share_price,
    round(quantileDeterministic(0.9)(toFloat64(close), cityHash64(ticker)), 2) AS p90_share_price
FROM global_markets.stocks_daily_aggs
WHERE date >= toStartOfMonth(today() - 1460)
  AND date <  toStartOfMonth(today())
  AND volume > 0
  AND close > 0
GROUP BY month, month_label
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.

More from this analysisHow Much Does One Share of Stock Cost?
Closing share price, ten household US names ranking 10×2 → Highest closing share prices on the most recent session ranking 8×2 → Price to earnings ratio, same ten household names ranking 8×2 → How many US stocks trade in each price band ranking 7×2 → Apple, monthly highest and lowest close, 2014 through 2020, restated to the share basis of each day series 84×4 → Symbols closing the month below $5 and below $1, past two years series 24×3 → See all 3,293 queries →