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

Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-08-25 · 30×5 Announced upcoming splits by directionranking · 2026-08-25 · 2×2Preview: 2 ranked values, smallest first. Announced stock splits by effective month: forward vs reverseseries · 2026-08-25 · 5×4Preview: a 5-point series, ending lower.
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-08-25 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-08-25 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-08-25 · 15×4Preview: 15 ranked values, smallest first.
What Is a Reverse Stock Split? Good or Bad?
2026 executed US stock splits: reverse vs. forwardscalar · 2026-08-22 · 1×3778 The most recent US reverse stock splits on recordseries · 2026-08-22 · 12×4Preview: a 12-point series, roughly flat. 2026's most common reverse split ratiosranking · 2026-08-22 · 10×2Preview: 10 ranked values, largest first. Where reverse-split companies stood a year later (splits executed 12-18 months ago)ranking · 2026-08-22 · 3×3Preview: 3 ranked values, largest first. ASST: daily closes around its 1-for-20 reverse split (execution date 2026-02-06)series · 2026-08-22 · 69×3Preview: a 16-point series, ending higher. Reverse vs. forward splits by year, 2019 to todayranking · 2026-08-22 · 8×4Preview: 8 ranked values, smallest first. ASST's reverse split history on recordseries · 2026-08-22 · 2×6Preview: a 2-point series, roughly flat. What happened next: median move after a reverse split vs. SPY, splits executed 4-9 months agoseries · 2026-08-22 · 3×7Preview: a 3-point series, ending higher.
How Often Do Stocks Split?
The most common reverse-split ratios, 2016 to todayranking · 2026-08-22 · 8×2Preview: 8 ranked values, largest first. Forward and reverse stock splits per year, 2016 to todayranking · 2026-08-22 · 11×3Preview: 11 ranked values, smallest first. The most common forward-split ratios, 2016 to todayranking · 2026-08-22 · 8×2Preview: 8 ranked values, largest first. Every share-count adjustment since 2016, by typeranking · 2026-08-22 · 3×2Preview: 3 ranked values, largest first. Recent forward splits among widely held stocksseries · 2026-08-22 · 10×4Preview: a 10-point series, roughly flat.
How Monthly Stock Returns Are Measured
SPY June 2026: price return vs total return (June ex-dividend included)scalar · 2026-07-26 · 1×6756.4 SPY monthly close-to-close returns: twelve months ending June 2026, simple and logseries · 2026-07-26 · 12×4Preview: a 12-point series, ending lower. SPY over five years, June 2021 to June 2026: price return vs return with dividendsscalar · 2026-07-26 · 1×7428.07 NVDA June 2024: a raw close-to-close calc vs the split-adjusted returnscalar · 2026-07-26 · 1×61,097.46 June 2026 measured two ways: close-to-close vs open-to-close, NVDA and SPYtable · 2026-07-26 · 2×7 SPY on June 30, 2026: official-close vs the final extended-hours printscalar · 2026-07-26 · 1×3746.32 Sum vs compound: twelve SPY monthly returns linked three waysscalar · 2026-07-26 · 1×712
Does a Stock Go Up After a Split?
The best-known recent stock splits: the six months before vs the three months afterseries · 2026-07-15 · 7×6Preview: a 7-point series, ending lower. Every liquid forward split, 2016-2025: median 3-month return after the split vs the S&P 500, by periodtable · 2026-07-15 · 3×7
Upcoming US stock splits: announced, with a future effective date

Upcoming US stock splits: announced, with a future effective date

most recentas of table 30×5read in context →
Upcoming US stock splits: announced, with a future effective date — 30 rows by 5 columns, computed from US exchange, SIP and OPRA data.
execution_datescheduledtickerratiosplit_direction
2026-08-26Aug 26, 2026VMAR1-for-10reverse split
2026-08-27Aug 27, 2026IMCC1-for-30reverse split
2026-08-27Aug 27, 2026LGVN1-for-10reverse split
2026-08-27Aug 27, 2026NVX1-for-10reverse split
2026-08-27Aug 27, 2026WHLR1-for-4reverse split
2026-08-27Aug 27, 2026YMT1-for-16reverse split
2026-08-28Aug 28, 2026SGIPF2-for-1forward split
2026-08-31Aug 31, 2026TPET1-for-9reverse split
2026-08-31Aug 31, 2026TRUX4-for-1forward split
2026-08-31Aug 31, 2026WZRD1-for-15reverse split
2026-09-01Sep 1, 2026KAPA1-for-7reverse split
2026-09-01Sep 1, 2026NIVF1-for-3reverse split
2026-09-08Sep 8, 2026AIXI1-for-7reverse split
2026-09-08Sep 8, 2026TXXD1-for-10reverse split
2026-09-09Sep 9, 2026AVXX1-for-5reverse split
2026-09-09Sep 9, 2026IONZ1-for-10reverse split
2026-09-09Sep 9, 2026RCAX1-for-5reverse split
2026-09-09Sep 9, 2026RKLZ1-for-5reverse split
2026-09-10Sep 10, 2026ASTN1-for-4reverse split
2026-09-10Sep 10, 2026DAMD1-for-10reverse split
2026-09-10Sep 10, 2026KEEX4-for-1forward split
2026-09-10Sep 10, 2026LFT1-for-10reverse split
2026-09-10Sep 10, 2026LNOK2-for-1forward split
2026-09-10Sep 10, 2026OKLL1-for-5reverse split
2026-09-10Sep 10, 2026OSCX3-for-1forward split
2026-09-10Sep 10, 2026QBTZ1-for-5reverse split
2026-09-10Sep 10, 2026RGTZ1-for-5reverse split
2026-09-10Sep 10, 2026SMCZ1-for-2reverse split
2026-09-10Sep 10, 2026STSM1-for-2reverse split
2026-09-11Sep 11, 2026DLHGF51-for-50forward split
the exact SQL behind every number
SELECT
    execution_date,
    formatDateTime(execution_date, '%b %e, %Y') AS scheduled,
    ticker,
    concat(toString(toInt32(split_to)), '-for-', toString(toInt32(split_from))) AS ratio,
    if(adjustment_type = 'forward_split', 'forward split', 'reverse split') AS split_direction
FROM global_markets.stocks_splits
WHERE execution_date > today()
  AND adjustment_type IN ('forward_split', 'reverse_split')
ORDER BY execution_date, ticker
LIMIT 30
$