STRASMORE/EXPLORE 2,830 QUERIES

price_history

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-30, from aapl-market-cap-and-share-count.

as of series 132×4read in context →
price_history — 132 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_datedate_labelclose_usdvolume_mn
2026-03-2424 Mar 2026251.6445.2
2026-03-2525 Mar 2026252.6228.5
2026-03-2626 Mar 2026252.8941.8
2026-03-2727 Mar 2026248.847.9
2026-03-3030 Mar 2026246.6339.4
2026-03-3131 Mar 2026253.7949.6
2026-04-011 Apr 2026255.6340.1
2026-04-022 Apr 2026255.9231.3
2026-04-066 Apr 2026258.8629.3
2026-04-077 Apr 2026253.562.1
2026-04-088 Apr 2026258.941
2026-04-099 Apr 2026260.4928.1
2026-04-1010 Apr 2026260.4831.3
2026-04-1313 Apr 2026259.236.2
2026-04-1414 Apr 2026258.8348.4
2026-04-1515 Apr 2026266.4349.9
2026-04-1616 Apr 2026263.443.3
2026-04-1717 Apr 2026270.2361.4
2026-04-2020 Apr 2026273.0536.6
2026-04-2121 Apr 2026266.1750.2
2026-04-2222 Apr 2026273.1743.2
2026-04-2323 Apr 2026273.4333.4
2026-04-2424 Apr 2026271.0638.1
2026-04-2727 Apr 2026267.6141.2
2026-04-2828 Apr 2026270.7140
2026-04-2929 Apr 2026270.1729.8
2026-04-3030 Apr 2026271.3591.8
2026-05-011 May 2026280.1479.9
2026-05-044 May 2026276.8346.7
2026-05-055 May 2026284.1849.3
2026-05-066 May 2026287.5158.3
2026-05-077 May 2026287.4445.2
2026-05-088 May 2026293.3252.7
2026-05-1111 May 2026292.6842.2
2026-05-1212 May 2026294.845.7
2026-05-1313 May 2026298.8752.7
2026-05-1414 May 2026298.2135.3
2026-05-1515 May 2026300.2354.9
2026-05-1818 May 2026297.8434.5
2026-05-1919 May 2026298.9742.2
2026-05-2020 May 2026302.2538.2
2026-05-2121 May 2026304.9942.9
2026-05-2222 May 2026308.8243.7
2026-05-2626 May 2026308.3348
2026-05-2727 May 2026310.8550.8
2026-05-2828 May 2026312.5149.1
2026-05-2929 May 2026312.0670
2026-06-011 Jun 2026306.3148.8
2026-06-022 Jun 2026315.244.7
2026-06-033 Jun 2026310.2650.8
2026-06-044 Jun 2026311.2344.9
2026-06-055 Jun 2026307.3465.3
2026-06-088 Jun 2026301.5477.9
2026-06-099 Jun 2026290.5570.1
2026-06-1010 Jun 2026291.5852.8
2026-06-1111 Jun 2026295.6342.6
2026-06-1212 Jun 2026291.1338.8
2026-06-1515 Jun 2026296.4245.7
2026-06-1616 Jun 2026299.2439.9
2026-06-1717 Jun 2026295.9542.7
2026-06-1818 Jun 2026298.0186
2026-06-2222 Jun 2026297.0144.9
2026-06-2323 Jun 2026294.352
2026-06-2424 Jun 2026293.0853.1
2026-06-2525 Jun 2026275.15107.3
2026-06-2626 Jun 2026283.78261.8
2026-06-2929 Jun 2026281.7466.4
2026-06-3030 Jun 2026289.3665.1
2026-07-011 Jul 2026294.3850.2
2026-07-022 Jul 2026308.6375.4
2026-07-066 Jul 2026312.6653.6
2026-07-077 Jul 2026310.6642.5
2026-07-088 Jul 2026313.3941.3
2026-07-099 Jul 2026316.2248.1
2026-07-1010 Jul 2026315.3234.1
2026-07-1313 Jul 2026317.3143.3
2026-07-1414 Jul 2026314.8635.8
2026-07-1515 Jul 2026327.561
2026-07-1616 Jul 2026333.2663
2026-07-1717 Jul 2026333.7463.4
2026-07-2020 Jul 2026326.5953.5
2026-07-2121 Jul 2026327.7441.3
2026-07-2222 Jul 2026325.8938.8
2026-07-2323 Jul 2026321.6640.8
2026-07-2424 Jul 2026333.0247.5
2026-07-2727 Jul 2026336.9149.6
2026-07-2828 Jul 2026340.0851.9
2026-07-2929 Jul 2026338.1956.1
2026-07-3030 Jul 2026333.4374.8
2026-07-3131 Jul 2026308.91132.5
2026-08-033 Aug 2026303.4275.1
2026-08-044 Aug 2026309.3868
2026-08-055 Aug 202631149.4
2026-08-066 Aug 2026312.4146.1
2026-08-077 Aug 2026313.3334.4
2026-08-1010 Aug 2026308.2644.8
2026-08-1111 Aug 2026304.9137.5
2026-08-1212 Aug 2026302.2541.7
2026-08-1313 Aug 2026305.2640.3
2026-08-1414 Aug 2026305.9328.2
2026-08-1717 Aug 2026305.5938.2
2026-08-1818 Aug 2026310.0353.4
2026-08-1919 Aug 2026316.8350.5
2026-08-2020 Aug 2026311.341
2026-08-2121 Aug 2026309.3546.9
2026-08-2424 Aug 2026310.3434.7
2026-08-2525 Aug 2026309.925.9
2026-08-2626 Aug 2026313.4534
2026-08-2727 Aug 2026314.5832.4
2026-08-2828 Aug 2026319.738.6
2026-08-3131 Aug 2026316.8541.2
2026-09-011 Sep 2026325.1353.2
2026-09-022 Sep 2026324.9633.8
2026-09-033 Sep 2026328.2137.2
2026-09-044 Sep 2026319.9739.6
2026-09-088 Sep 2026316.2235.5
2026-09-099 Sep 2026315.3465.6
2026-09-1010 Sep 2026326.5770
2026-09-1111 Sep 2026332.2750.7
2026-09-1414 Sep 2026333.0839.3
2026-09-1515 Sep 2026331.3431.7
2026-09-1616 Sep 2026332.4136
2026-09-1717 Sep 202633736.7
2026-09-1818 Sep 2026336.1386.6
2026-09-2121 Sep 2026338.9835
2026-09-2222 Sep 2026339.7540.7
2026-09-2323 Sep 2026337.0231.7
2026-09-2424 Sep 2026335.9224.7
2026-09-2525 Sep 2026341.0730
2026-09-2828 Sep 2026338.432.8
2026-09-2929 Sep 2026329.438.5
2026-09-3030 Sep 2026329.640.2
Rows × columns
132 × 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 price_history, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2026-03-24 to 2026-09-30
date_label text 132 distinct values (1 Apr 2026, 1 Jul 2026, 1 Jun 2026…)
close_usd number 246.63 to 341.07 US dollars
volume_mn number 0.2 to 261.8 count

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(date)                       AS session_date,
    formatDateTime(date, '%e %b %Y')     AS date_label,
    round(toFloat64(close), 2)           AS close_usd,
    round(volume / 1e6, 1)               AS volume_mn
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date >= today() - 190
ORDER BY date
⌘/Ctrl + Enter

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

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