STRASMORE/EXPLORE 2,985 QUERIES

aapl_recent_closes

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-10-03, from aapl-stock-price-in-inr.

as of series 32×4read in context →
aapl_recent_closes — 32 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelclose_usdday_range_pct
2026-08-19Aug 19316.833.06
2026-08-20Aug 20311.33.09
2026-08-21Aug 21309.351.74
2026-08-24Aug 24310.341.09
2026-08-25Aug 25309.91.74
2026-08-26Aug 26313.452.12
2026-08-27Aug 27314.581.91
2026-08-28Aug 28319.72.16
2026-08-31Aug 31316.852.66
2026-09-01Sep 1325.133.87
2026-09-02Sep 2324.961.5
2026-09-03Sep 3328.212.04
2026-09-04Sep 4319.973.46
2026-09-08Sep 8316.221.83
2026-09-09Sep 9315.342.93
2026-09-10Sep 10326.573.13
2026-09-11Sep 11332.272.99
2026-09-14Sep 14333.081.25
2026-09-15Sep 15331.341.04
2026-09-16Sep 16332.411.44
2026-09-17Sep 173372.42
2026-09-18Sep 18336.131.77
2026-09-21Sep 21338.981.94
2026-09-22Sep 22339.751.94
2026-09-23Sep 23337.021.87
2026-09-24Sep 24335.921.37
2026-09-25Sep 25341.072.09
2026-09-28Sep 28338.41.46
2026-09-29Sep 29329.42.55
2026-09-30Sep 30333.022.81
2026-10-01Oct 1330.322.02
2026-10-02Oct 2333.691.18
Rows × columns
32 × 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 aapl_recent_closes, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2026-08-19 to 2026-10-02
session_label text 32 distinct values (Aug 19, Aug 20, Aug 21…)
close_usd number 309.35 to 341.07 US dollars
day_range_pct number 1.04 to 3.87 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(date)                        AS session_date,
    formatDateTime(date, '%b %e')         AS session_label,
    round(toFloat64(any(close)), 2)       AS close_usd,
    round(toFloat64(any(high) - any(low)) / toFloat64(any(close)) * 100, 2) AS day_range_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date >= today() - 45
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter

ఈ డేటాతో మీ AI అసిస్టెంట్‌లో పని చేయండి

ఈ పేజీ డేటాతో, క్వెరీకి సిద్ధంగా తెరుచుకుంటుంది. ఉచితం, ఖాతా అవసరం లేదు.

Claude ChatGPT Gemini Muse మీ సొంత ఏజెంట్