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

How Stock Splits Get Announced: 8-K to Ex-Date
Splits with an effective date still ahead, inside the next six monthstable · 2026-10-04 · 33×5 Announcement to effective date: the spread across forward splitsranking · 2026-10-04 · 5×2Preview: 5 ranked values, smallest first. Median wait from first split story to effective date, by monthseries · 2026-10-04 · 19×6Preview: a 16-point series, ending lower. The quickest and slowest announcement windows, by companytable · 2026-10-04 · 10×5
How to Find a Stock's Earnings Date
Spacing between each name's eight biggest overnight moves, July 2024 to June 2026table · 2026-08-03 · 7×5 Where fiscal quarters actually end: statement periods by calendar month, July 2023 to June 2026ranking · 2026-08-03 · 12×3Preview: 12 ranked values, smallest first. NVDA: the ten largest overnight moves, July 2024 to June 2026ranking · 2026-08-03 · 10×3Preview: 10 ranked values, smallest first.
Splits with an effective date still ahead, inside the next six months

Splits with an effective date still ahead, inside the next six months

most recentas of table 33×5read in context →
Splits with an effective date still ahead, inside the next six months — 33 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickerratiodirectioneffective_ondays_away
CMND1:8reverseOct 5, 20261
GUTS1:12reverseOct 5, 20261
PSKY2:1forwardOct 5, 20261
SCNX1:25reverseOct 5, 20261
TGOSY5:1forwardOct 5, 20261
VIVK1:15reverseOct 5, 20261
VTAK1:10reverseOct 5, 20261
ETHA1:3reverseOct 6, 20262
GPMT1:10reverseOct 6, 20262
ITOC1:16reverseOct 6, 20262
RUBI1.5:1forwardOct 6, 20262
GCDT1:6reverseOct 7, 20263
SUGP1:6reverseOct 7, 20263
TELWY5:1forwardOct 7, 20263
TKOMY15:1forwardOct 7, 20263
TOPPY2:1forwardOct 7, 20263
MGF1:5reverseOct 8, 20264
MIN1:6reverseOct 8, 20264
DWAHY2:1forwardOct 9, 20265
DXJ3:1forwardOct 9, 20265
HKHUY10:1forwardOct 9, 20265
IBIDY2:1forwardOct 9, 20265
IMHDY2:1forwardOct 9, 20265
KXIAY3:1forwardOct 9, 20265
IDTID192:100forwardOct 12, 20268
POAS1:15reverseOct 12, 20268
JZ1:15reverseOct 15, 202611
CTAMF1:40reverseOct 23, 202619
LU1:10reverseOct 23, 202619
ENHA1:10reverseOct 28, 202624
SOXX3:1forwardNov 5, 202632
NWSZF11:10forwardNov 23, 202650
DPU1:50reverseDec 17, 202674
the exact SQL behind every number 
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
More from this analysisHow Stock Splits Get Announced: 8-K to Ex-Date
The quickest and slowest announcement windows, by company table 10×5 → Median wait from first split story to effective date, by month series 19×6 → Announcement to effective date: the spread across forward splits ranking 5×2 → Upcoming US stock splits: announced, with a future effective date table 27×5 → See all 3,256 queries →
$