STRASMORE/EXPLORE 2,985 QUERIES

pending_splits

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-10-03, from how-stock-splits-are-announced.

as of table 33×5read in context →
pending_splits — 33 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickerratiodirectioneffective_ondays_away
CMND1:8reverseOct 5, 20262
GUTS1:12reverseOct 5, 20262
PSKY2:1forwardOct 5, 20262
SCNX1:25reverseOct 5, 20262
TGOSY5:1forwardOct 5, 20262
VIVK1:15reverseOct 5, 20262
VTAK1:10reverseOct 5, 20262
ETHA1:3reverseOct 6, 20263
GPMT1:10reverseOct 6, 20263
ITOC1:16reverseOct 6, 20263
RUBI1.5:1forwardOct 6, 20263
GCDT1:6reverseOct 7, 20264
SUGP1:6reverseOct 7, 20264
TELWY5:1forwardOct 7, 20264
TKOMY15:1forwardOct 7, 20264
TOPPY2:1forwardOct 7, 20264
MGF1:5reverseOct 8, 20265
MIN1:6reverseOct 8, 20265
DWAHY2:1forwardOct 9, 20266
DXJ3:1forwardOct 9, 20266
HKHUY10:1forwardOct 9, 20266
IBIDY2:1forwardOct 9, 20266
IMHDY2:1forwardOct 9, 20266
KXIAY3:1forwardOct 9, 20266
IDTID192:100forwardOct 12, 20269
POAS1:15reverseOct 12, 20269
JZ1:15reverseOct 15, 202612
CTAMF1:40reverseOct 23, 202620
LU1:10reverseOct 23, 202620
ENHA1:10reverseOct 28, 202625
SOXX3:1forwardNov 5, 202633
NWSZF11:10forwardNov 23, 202651
DPU1:50reverseDec 17, 202675
Rows × columns
33 × 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 pending_splits, derived from the stored result.
ColumnTypeRangeNotes
ticker text 33 distinct values (CMND, CTAMF, DPU…)
ratio text 19 distinct values (1.5:1, 10:1, 11:10…)
direction text 2 distinct values (forward, reverse)
effective_on text 12 distinct values (Dec 17, 2026, Nov 23, 2026, Nov 5, 2026…)
days_away number 2 to 75

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
    ticker,
    concat(toString(toFloat64(split_to)), ':', toString(toFloat64(split_from)))  AS ratio,
    if(toFloat64(split_to) > toFloat64(split_from), 'forward', 'reverse')        AS direction,
    formatDateTime(execution_date, '%b %e, %Y')                                  AS effective_on,
    toUInt32(dateDiff('day', today(), execution_date))                           AS days_away
FROM global_markets.stocks_splits
WHERE execution_date >= today()
  AND execution_date <= today() + 180
  AND ticker NOT IN ('SPCX')
GROUP BY ticker, execution_date, split_to, split_from
ORDER BY execution_date ASC, ticker ASC
LIMIT 40
⌘/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 analysishow-stock-splits-are-announced
fastest_slowest table 10×5 → gap_by_month series 19×6 → gap_percentiles ranking 5×2 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → See all 2,985 queries →