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

Warrants vs Call Options: Key Differences
Recent forward stock splits and the share multiplierranking · 2026-10-04 · 12×4Preview: 12 ranked values, smallest first. Tesla basic and diluted share counts, quarter by quarterseries · 2026-10-04 · 12×5Preview: a 12-point series, ending lower. AAPL call contracts traded, by expiration dateseries · 2026-10-04 · 24×4Preview: a 16-point series, ending higher. Basic and diluted share counts across eight large capsranking · 2026-10-04 · 8×4Preview: 8 ranked values, smallest first.
Can German Retail Investors Short Stocks?
Aggregate short interest with no holder named: days to cover, household US namesranking · 2026-09-26 · 8×4Preview: 8 ranked values, largest first. What a put costs to hold: premium and daily decay by time to expiry (AAPL, Q3 2025)ranking · 2026-09-26 · 5×3Preview: 5 ranked values, smallest first. A minus one fund against its index, month by month (SPY vs SH, 2025)series · 2026-09-26 · 12×4Preview: a 12-point series, ending lower. Barrier touches: intraday high versus closing print, NVDA, Q3 2025table · 2026-09-26 · 10×5
Recent forward stock splits and the share multiplier

Recent forward stock splits and the share multiplier

most recentas of ranking 12×4read in context →
Recent forward stock splits and the share multiplier — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickereffective_onsplit_ratioshares_multiplier
MMSMYOct 2, 20262-for-12
NGKSYOct 2, 20263-for-13
ZCSHSep 30, 20263-for-13
TRDCFSep 29, 20262-for-12
SYCHFSep 29, 20264-for-14
OGKYFSep 29, 20265-for-15
TOELFSep 29, 20265-for-15
RYOTFSep 29, 20262-for-12
RTOKFSep 29, 20264-for-14
IBIDFSep 29, 20262-for-12
AKAFFSep 29, 20263-for-13
TKOMFSep 29, 202615-for-115
the exact SQL behind every number 
SELECT
    ticker,
    formatDateTime(execution_date, '%b %e, %Y')                                             AS effective_on,
    concat(toString(toUInt32(any(split_to))), '-for-', toString(toUInt32(any(split_from)))) AS split_ratio,
    round(toFloat64(any(split_to)) / toFloat64(any(split_from)), 2)                         AS shares_multiplier
FROM global_markets.stocks_splits
WHERE execution_date >= today() - 365
  AND execution_date <= today()
  AND split_from > 0
  AND toFloat64(split_to) / toFloat64(split_from) >= 2
  AND ticker NOT IN ('SPCX')
GROUP BY ticker, execution_date
ORDER BY execution_date DESC
LIMIT 12
More from this analysisWarrants vs Call Options: Key Differences
Basic and diluted share counts across eight large caps ranking 8×4 → AAPL call contracts traded, by expiration date series 24×4 → Tesla basic and diluted share counts, quarter by quarter series 12×5 → Fractional-ratio splits and the share count they leave per contract ranking 12×4 → See all 3,256 queries →
$