STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

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
How Much Does One Share of Stock Cost?
Median and 90th percentile US share price, by monthseries · 2026-11-07 · 48×4Preview: a 16-point series, roughly flat. Highest closing share prices on the most recent sessionranking · 2026-11-07 · 8×2Preview: 8 ranked values, largest first. How many US stocks trade in each price bandranking · 2026-11-07 · 7×2Preview: 7 ranked values, largest first. Price to earnings ratio, same ten household namesranking · 2026-11-07 · 8×2Preview: 8 ranked values, largest first. Closing share price, ten household US namesranking · 2026-11-07 · 10×2Preview: 10 ranked values, largest first.
Median and 90th percentile US share price, by month

Median and 90th percentile US share price, by month

most recentas 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
the exact SQL behind every number
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
$