price_path
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-01, from aapl-stock-for-thai-investors.
| month | month_end_close | running_high_5y | worst_drawdown_in_month_pct |
|---|---|---|---|
| 2021-11-01 | 165.3 | 165.3 | -3.2 |
| 2021-12-01 | 177.57 | 180.33 | -5.4 |
| 2022-01-01 | 174.78 | 182.01 | -12.5 |
| 2022-02-01 | 165.12 | 182.01 | -12.1 |
| 2022-03-01 | 174.61 | 182.01 | -17.2 |
| 2022-04-01 | 157.65 | 182.01 | -14 |
| 2022-05-01 | 148.84 | 182.01 | -24.5 |
| 2022-06-01 | 136.72 | 182.01 | -28.5 |
| 2022-07-01 | 162.51 | 182.01 | -23.7 |
| 2022-08-01 | 157.22 | 182.01 | -13.6 |
| 2022-09-01 | 138.2 | 182.01 | -24.1 |
| 2022-10-01 | 153.34 | 182.01 | -24 |
| 2022-11-01 | 148.03 | 182.01 | -25.9 |
| 2022-12-01 | 129.93 | 182.01 | -30.8 |
| 2023-01-01 | 144.29 | 182.01 | -31.3 |
| 2023-02-01 | 147.41 | 182.01 | -20.1 |
| 2023-03-01 | 164.9 | 182.01 | -20.2 |
| 2023-04-01 | 169.68 | 182.01 | -12 |
| 2023-05-01 | 177.25 | 182.01 | -8.9 |
| 2023-06-01 | 193.97 | 193.97 | -2.3 |
| 2023-07-01 | 196.45 | 196.45 | -3 |
| 2023-08-01 | 187.87 | 196.45 | -11.4 |
| 2023-09-01 | 171.21 | 196.45 | -13.2 |
| 2023-10-01 | 170.77 | 196.45 | -15 |
| 2023-11-01 | 189.95 | 196.45 | -11.4 |
| 2023-12-01 | 192.53 | 198.11 | -3.6 |
| 2024-01-01 | 184.4 | 198.11 | -8.5 |
| 2024-02-01 | 180.75 | 198.11 | -8.8 |
| 2024-03-01 | 171.48 | 198.11 | -14.7 |
| 2024-04-01 | 170.33 | 198.11 | -16.7 |
| 2024-05-01 | 192.25 | 198.11 | -14.5 |
| 2024-06-01 | 210.62 | 216.67 | -4.2 |
| 2024-07-01 | 222.08 | 234.82 | -7.4 |
| 2024-08-01 | 229 | 234.82 | -11.7 |
| 2024-09-01 | 233 | 234.82 | -7.9 |
| 2024-10-01 | 225.91 | 236.48 | -5.6 |
| 2024-11-01 | 237.33 | 237.33 | -6.1 |
| 2024-12-01 | 250.42 | 259.02 | -3.3 |
| 2025-01-01 | 236 | 259.02 | -14 |
| 2025-02-01 | 241.84 | 259.02 | -12.1 |
| 2025-03-01 | 222.13 | 259.02 | -19 |
| 2025-04-01 | 212.5 | 259.02 | -33.4 |
| 2025-05-01 | 200.85 | 259.02 | -24.6 |
| 2025-06-01 | 205.17 | 259.02 | -24.5 |
| 2025-07-01 | 207.57 | 259.02 | -19.9 |
| 2025-08-01 | 232.14 | 259.02 | -21.9 |
| 2025-09-01 | 254.63 | 259.02 | -12.4 |
| 2025-10-01 | 270.37 | 271.4 | -5.3 |
| 2025-11-01 | 278.85 | 278.85 | -3.3 |
| 2025-12-01 | 271.86 | 286.19 | -5.3 |
| 2026-01-01 | 259.48 | 286.19 | -13.8 |
| 2026-02-01 | 264.18 | 286.19 | -10.6 |
| 2026-03-01 | 253.79 | 286.19 | -13.8 |
| 2026-04-01 | 271.35 | 286.19 | -11.4 |
| 2026-05-01 | 312.06 | 312.51 | -3.3 |
| 2026-06-01 | 289.36 | 315.2 | -12.7 |
| 2026-07-01 | 308.91 | 340.08 | -9.2 |
| 2026-08-01 | 316.85 | 340.08 | -11.1 |
| 2026-09-01 | 333.02 | 341.07 | -7.3 |
| 2026-10-01 | 344.63 | 348.91 | -3.2 |
- Rows × columns
- 60 × 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 | 2021-11-01 to 2026-10-01 | |
month_end_close |
number | 129.93 to 344.63 | US dollars |
running_high_5y |
number | 165.3 to 348.91 | US dollars |
worst_drawdown_in_month_pct |
number | -33.4 to -2.3 | 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.
SELECT
toString(toStartOfMonth(date)) AS month,
round(argMax(close_f, date), 2) AS month_end_close,
round(max(running_high), 2) AS running_high_5y,
round(min((close_f / running_high - 1) * 100), 1) AS worst_drawdown_in_month_pct
FROM
(
SELECT
date,
toFloat64(close) AS close_f,
max(toFloat64(close)) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_high
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
AND date > subtractYears(today(), 5)
AND date <= today()
)
GROUP BY month
ORDER BY month
ใช้ข้อมูลนี้ในผู้ช่วย AI ของคุณ
เปิดพร้อมคิวรีได้ทันที พร้อมข้อมูลของหน้านี้ ฟรี ไม่ต้องมีบัญชี