STRASMORE/EXPLORE 2,595 QUERIES

aapl_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-09-25, from aapl-stock-price-in-pkr.

as of series 26×5read in context →
aapl_monthly — 26 rows by 5 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelmonth_end_closemonth_highmonth_low
2024-08Aug 2024229232.92196
2024-09Sep 2024233233.09213.92
2024-10Oct 2024225.91237.49221.33
2024-11Nov 2024237.33237.81219.71
2024-12Dec 2024250.42260.1237.16
2025-01Jan 2025236249.1219.38
2025-02Feb 2025241.84250225.7
2025-03Mar 2025222.13244.03208.42
2025-04Apr 2025212.5225.19169.21
2025-05May 2025200.85214.56193.25
2025-06Jun 2025205.17207.39195.07
2025-07Jul 2025207.57216.23206.14
2025-08Aug 2025232.14235.12201.5
2025-09Sep 2025254.63257.6225.95
2025-10Oct 2025270.37277.32244
2025-11Nov 2025278.85280.38265.32
2025-12Dec 2025271.86288.62266.95
2026-01Jan 2026259.48277.84243.42
2026-02Feb 2026264.18280.9255.45
2026-03Mar 2026253.79266.53245.51
2026-04Apr 2026271.35276245.7
2026-05May 2026312.06315274.86
2026-06Jun 2026289.36317.4273.75
2026-07Jul 2026308.91344.57289.2
2026-08Aug 2026316.85322.37300.57
2026-09Sep 2026336.26345.34309.9
Rows × columns
26 × 5
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 aapl_monthly, derived from the stored result.
ColumnTypeRangeNotes
month text 26 distinct values (2024-08, 2024-09, 2024-10…)
month_label text 26 distinct values (Apr 2025, Apr 2026, Aug 2024…)
month_end_close number 200.85 to 336.26 US dollars
month_high number 207.39 to 345.34 US dollars
month_low number 169.21 to 309.9 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
    formatDateTime(toStartOfMonth(date), '%Y-%m')  AS month,
    formatDateTime(toStartOfMonth(date), '%b %Y')  AS month_label,
    round(toFloat64(argMax(close, date)), 2)       AS month_end_close,
    round(toFloat64(max(high)), 2)                 AS month_high,
    round(toFloat64(min(low)), 2)                  AS month_low
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date >= toStartOfMonth(today() - 760)
GROUP BY month, month_label
ORDER BY month
⌘/Ctrl + Enter

اس ڈیٹا کے ساتھ اپنے AI اسسٹنٹ میں کام کریں

اس صفحے کے ڈیٹا کے ساتھ، کوئری کے لیے تیار کھلتا ہے۔ مفت، بغیر اکاؤنٹ۔

Claude ChatGPT Gemini Muse آپ کا اپنا ایجنٹ