STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

Buying Before or After a Stock Split
Forward and reverse splits by year, US listed companiesranking · 2026-10-08 · 10×3Preview: 10 ranked values, smallest first. Recent forward splits at large US companies, by effective sessionranking · 2026-10-08 · 12×4Preview: 12 ranked values, smallest first. Most-used forward split multipliers, last ten yearsranking · 2026-10-08 · 10×3Preview: 10 ranked values, largest first. AAPL across its 2020 four for one split: split-adjusted closes and volumeseries · 2026-10-08 · 10×4Preview: a 10-point series, roughly flat.
Reverse Split: Round Up or Cash in Lieu?
Reverse splits executed per year, and how many used a ratio of 1-for-10 or largerranking · 2026-10-06 · 11×3Preview: 11 ranked values, smallest first. Reverse split ratios since 2016, by how often each one is usedranking · 2026-10-06 · 12×2Preview: 12 ranked values, largest first. 8-K disclosures mentioning a reverse stock split, and how many spell out the fractionranking · 2026-10-06 · 2×4Preview: 2 ranked values, smallest first. First week post split average close, and what half a share would payseries · 2026-10-06 · 12×4Preview: a 12-point series, ending lower.
Stock Splits vs Fractional Shares Explained
AAPL prints by trade size, one to ten shares, June 10 2026 sessionranking · 2026-10-04 · 10×2Preview: 10 ranked values, smallest first. NVDA strike ladder and share price across its June 2024 splitseries · 2026-10-04 · 10×5Preview: a 10-point series, ending higher. Forward stock splits at liquid US names, past three yearsranking · 2026-10-04 · 12×3Preview: 12 ranked values, smallest first. Price weighting across ten large US names, latest closeranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first.
Cost Basis After a Stock Split, Step by Step
Forward and reverse splits per calendar yearranking · 2026-10-04 · 11×3Preview: 11 ranked values, smallest first. The most common split terms of the past five yearsranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first. One hypothetical 100-share lot through every AAPL splitseries · 2026-10-04 · 3×5Preview: a 3-point series, ending lower. Every KO dividend of the past four years, one new lot each if reinvestedseries · 2026-10-04 · 16×3Preview: a 16-point series, ending higher.
How Much Does One Share of Stock Cost?
Median and 90th percentile US share price, by monthseries · 2026-10-04 · 48×4Preview: a 16-point series, ending lower. Highest closing share prices on the most recent sessionranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first. How many US stocks trade in each price bandranking · 2026-10-04 · 7×2Preview: 7 ranked values, largest first. Price to earnings ratio, same ten household namesranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first. Closing share price, ten household US namesranking · 2026-10-04 · 10×2Preview: 10 ranked values, largest first.
How Fractional Shares Hit the Tape
Small AAPL print sizes: five sessions in January 2026 against five in July 2026table · 2026-08-12 · 26×3 Average shares per print by month, September 2025 through July 2026series · 2026-08-12 · 11×5Preview: a 11-point series, ending lower. Odd lots, round lots and sub-one-share prints across six names, July 8 to 10, 2026ranking · 2026-08-12 · 6×4Preview: 6 ranked values, largest first. AAPL average print size across the February 2026 boundaryseries · 2026-08-12 · 19×4Preview: a 16-point series, roughly flat.
Dividend Reinvestment Plans (DRIPs) Explained
Days from ex-dividend date to cash: six household dividend payersranking · 2026-08-11 · 6×4Preview: 6 ranked values, largest first. KO: ex-dividend close against the pay date close, 2021 to 2026series · 2026-08-11 · 22×5Preview: a 16-point series, ending lower. Reinvestment events a year: a monthly payer against a quarterly payerranking · 2026-08-11 · 10×3Preview: 10 ranked values, smallest first. How often listed payers distribute, trailing yearranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first.
Forward and reverse splits by year, US listed companies

Forward and reverse splits by year, US listed companies

most recentas of ranking 10×3read in context →
Forward and reverse splits by year, US listed companies — 10 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearforward_splitsreverse_splits
2016416725
2017379701
2018516524
2019388606
2020352679
2021404488
2022362622
2023358834
2024451867
20254241036
the exact SQL behind every number 
SELECT
    toYear(execution_date) AS year,
    countIf(mult > 1)      AS forward_splits,
    countIf(mult < 1)      AS reverse_splits
FROM
(
    SELECT
        execution_date,
        ticker,
        toFloat64(any(split_to)) / toFloat64(any(split_from)) AS mult
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2016-01-01'
      AND execution_date <  toStartOfYear(today())
    GROUP BY execution_date, ticker
)
GROUP BY year
ORDER BY year
More from this analysisBuying Before or After a Stock Split
Recent forward splits at large US companies, by effective session ranking 12×4 → Most-used forward split multipliers, last ten years ranking 10×3 → AAPL across its 2020 four for one split: split-adjusted closes and volume series 10×4 → The most common split terms of the past five years ranking 12×3 → See all 3,256 queries →
$