STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

Apple Stock Split History and Ratios
Apple's yearly price range, split-adjusted, 2012 through the current yearranking · 2026-08-24 · 15×4Preview: 15 ranked values, smallest first. Apple's daily closes around the most recent split, split-adjustedseries · 2026-08-24 · 10×4Preview: a 10-point series, roughly flat. Every Apple stock split and what one old share becomesseries · 2026-08-24 · 3×4Preview: a 3-point series, ending lower. The twelve months before each Apple splitranking · 2026-08-24 · 3×4Preview: 3 ranked values, smallest first.
Apple's yearly price range, split-adjusted, 2012 through the current year

Apple's yearly price range, split-adjusted, 2012 through the current year

most recentas of ranking 15×4read in context →
Apple's yearly price range, split-adjusted, 2012 through the current year — 15 rows by 4 columns, computed from US exchange, SIP and OPRA data.
yearyear_highyear_lowyear_close
201225.1814.6119.01
201320.5413.7520.04
201429.9417.6327.6
201533.642326.32
201629.6722.3728.96
201744.328.6942.31
201858.3736.6539.44
201973.4935.573.41
2020138.7953.15132.69
2021182.13116.21177.57
2022182.94125.87129.93
2023199.62124.17192.53
2024260.1164.08250.42
2025288.62169.21271.86
2026344.57243.42310.4
the exact SQL behind every number
SELECT
    toString(toYear(date))                    AS year,
    round(toFloat64(max(high)), 2)            AS year_high,
    round(toFloat64(min(low)), 2)             AS year_low,
    round(toFloat64(argMax(close, date)), 2)  AS year_close
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date >= '2012-01-01'
GROUP BY toYear(date)
ORDER BY toYear(date)
$