STRASMORE/EXPLORE 3,293 QUERIES
Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan

The stock split calendar: recent and scheduled

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-11-01, from Stock Split Calendar From a Free SQL API.

as of table 24×5read in context →
The stock split calendar: recent and scheduled — 24 rows by 5 columns, computed from US exchange, SIP and OPRA data.
day_labeltickerdirectionratioworked_example
Jan 13, 2027IBDSFreverse split2-for-1100 shares becomes 200
Dec 17, 2026DPUreverse split1-for-50100 shares becomes 2
Dec 2, 2026LARKreverse split1-for-1100 shares becomes 105
Nov 30, 2026JZreverse split1-for-15100 shares becomes 6.67
Nov 27, 2026DAFVFforward split4-for-1100 shares becomes 400
Nov 27, 2026MPHSFreverse split1-for-10100 shares becomes 10
Nov 27, 2026TKPTFforward split3-for-1100 shares becomes 300
Nov 23, 2026NWSZFforward split11-for-10100 shares becomes 110
Nov 20, 2026NTCLreverse split1-for-10100 shares becomes 10
Nov 19, 2026LICNreverse split1-for-100100 shares becomes 1
Nov 18, 2026ANCMFreverse split101-for-100100 shares becomes 101
Nov 16, 2026AOHYreverse split1-for-5100 shares becomes 20
Nov 16, 2026CARYreverse split1-for-3100 shares becomes 33.33
Nov 16, 2026MBSreverse split1-for-7100 shares becomes 14.29
Nov 16, 2026YMTreverse split1-for-10100 shares becomes 10
Nov 13, 2026ENVXreverse split5-for-4100 shares becomes 125
Nov 13, 2026RCTreverse split1-for-20100 shares becomes 5
Nov 13, 2026SGRXreverse split1-for-10100 shares becomes 10
Nov 10, 2026JOBreverse split1-for-30100 shares becomes 3.33
Nov 10, 2026LFBCFforward split112-for-100100 shares becomes 112
Nov 9, 2026MMTreverse split1-for-4100 shares becomes 25
Nov 9, 2026STKHreverse split1-for-5100 shares becomes 20
Nov 6, 2026AIIOreverse split1-for-25100 shares becomes 4
Nov 6, 2026NEXRreverse split1-for-5100 shares becomes 20
Rows × columns
24 × 5
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for The stock split calendar: recent and scheduled, derived from the stored result.
ColumnTypeRangeNotes
day_label text 14 distinct values (Dec 17, 2026, Dec 2, 2026, Jan 13, 2027…)
ticker text 24 distinct values (AIIO, ANCMF, AOHY…)
direction text 2 distinct values (forward split, reverse split)
ratio text 19 distinct values (1-for-1, 1-for-10, 1-for-100…)
worked_example text 19 distinct values

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    formatDateTime(execution_date, '%b %e, %Y')                             AS day_label,
    ticker,
    any(if(adjustment_type = 'forward_split', 'forward split', 'reverse split')) AS direction,
    concat(toString(toInt32(any(split_to))), '-for-',
           toString(toInt32(any(split_from))))                              AS ratio,
    concat('100 shares becomes ',
           toString(round(100 * toFloat64(any(split_to)) / toFloat64(any(split_from)), 2))) AS worked_example
FROM global_markets.stocks_splits
WHERE execution_date >= today() - 21
  AND split_from > 0
  AND split_to > 0
  AND ticker NOT IN ('SPCX')
GROUP BY execution_date, ticker
ORDER BY execution_date DESC, ticker
LIMIT 24
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent
More from this analysisStock Split Calendar From a Free SQL API
Forward and reverse splits per month, last 36 months series 36×4 → Most common split ratios, last three years ranking 12×2 → Do the direction labels agree with the ratio columns? ranking 2×4 → Upcoming US stock splits: announced, with a future effective date table 30×5 → Every liquid forward split, 2016-2025: median 3-month return after the split vs the S&P 500, by period table 3×7 → KO daily closes, last 30 sessions returned by the free SQL endpoint series 30×2 → See all 3,293 queries →