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

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.
Every AAPL stock split and the running share count

Every AAPL stock split and the running share count

most recentas of series 3×5read in context →
Every AAPL stock split and the running share count — 3 rows by 5 columns, computed from US exchange, SIP and OPRA data.
execution_datesplit_ratioshares_after_splitcumulative_share_counteffective_on
2005-02-282-for-122Feb 28, 2005
2014-06-097-for-1714Jun 9, 2014
2020-08-314-for-1456Aug 31, 2020
the exact SQL behind every number 
WITH events AS
(
    SELECT
        id,
        any(execution_date)                              AS split_date,
        any(toFloat64(split_to) / toFloat64(split_from)) AS ratio,
        concat(toString(toUInt32(any(split_to))), '-for-', toString(toUInt32(any(split_from)))) AS split_ratio
    FROM global_markets.stocks_splits
    WHERE ticker = 'AAPL'
    GROUP BY id
)
SELECT
    toString(split_date)                    AS execution_date,
    split_ratio,
    round(ratio, 0)                         AS shares_after_split,
    round(exp(sum(log(ratio)) OVER (ORDER BY split_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)), 0) AS cumulative_share_count,
    formatDateTime(split_date, '%b %e, %Y') AS effective_on
FROM events
ORDER BY split_date
More from this analysisAAPL Dividend History: Splits and Raises
Every AAPL dividend year, as declared and split adjusted ranking 15×4 → AAPL quarterly dividend by year, split adjusted, with the annual step ranking 14×3 → AAPL dividends paid against free cash flow, by fiscal year ranking 13×4 → Longest gaps between consecutive AAPL dividend payments, in years ranking 6×4 → See all 2,170 queries →
$