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.
Short Interest vs Short Volume: The Difference
Data points per dataset: AAPL, last 60 daysranking · 2026-08-22 · 2×2Preview: 2 ranked values, smallest first. Highest days to cover, latest settlement date (min 1M shares/day traded)ranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first. AAPL daily short volume ratio (last ~60 days)series · 2026-08-22 · 33×2Preview: a 16-point series, roughly flat. AAPL short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-08-22 · 47×3Preview: a 16-point series, roughly flat. AAPL days to cover at each settlement date (last 2 years)series · 2026-08-22 · 47×3Preview: a 16-point series, roughly flat.
AAPL Implied Volatility: IV Now & Its History
AAPL ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. AAPL vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×4Preview: a 16-point series, ending lower. AAPL at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
AAPL Dividend History: Splits and Raises
Every AAPL stock split and the running share countseries · 2026-08-22 · 3×5Preview: a 3-point series, ending higher. AAPL quarterly dividend by year, split adjusted, with the annual stepranking · 2026-08-22 · 14×3Preview: 14 ranked values, smallest first. AAPL dividends paid against free cash flow, by fiscal yearranking · 2026-08-22 · 13×4Preview: 13 ranked values, smallest first. Longest gaps between consecutive AAPL dividend payments, in yearsranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. Every AAPL dividend year, as declared and split adjustedranking · 2026-08-22 · 15×4Preview: 15 ranked values, largest first.
Apple (AAPL) Dividend 2026: Per Share & Yield
AAPL dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-08-22 · 1×70.27 AAPL recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-22 · 10×2Preview: a 10-point series, ending lower. AAPL total dividends paid per year (regular dividends)ranking · 2026-08-22 · 7×2Preview: 7 ranked values, largest 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)
$