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

Warrants vs Call Options: Key Differences
Recent forward stock splits and the share multiplierranking · 2026-08-22 · 12×4Preview: 12 ranked values, smallest first. Tesla basic and diluted share counts, quarter by quarterseries · 2026-08-22 · 12×5Preview: a 12-point series, ending lower. AAPL call contracts traded, by expiration dateseries · 2026-08-22 · 22×4Preview: a 16-point series, ending higher. Basic and diluted share counts across eight large capsranking · 2026-08-22 · 8×4Preview: 8 ranked values, smallest first.
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
SFBSAug 21, 20262-for-12
HCHDYAug 13, 20267-for-17.5
TYOYYAug 12, 202616-for-116
MNSTAug 11, 20262-for-12
BMJJFAug 10, 202610-for-110
WRIVJul 31, 20262-for-12
TORIFJul 30, 20262-for-12
CMTDFJul 30, 20264-for-14
IRLCFJul 27, 202610-for-110
WBKCYJul 23, 20264-for-14
WLFCJul 21, 20263-for-13
LABXJul 21, 20266-for-16
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 22×4 → Tesla basic and diluted share counts, quarter by quarter series 12×5 → One time cash distributions per calendar year, and their share of all payouts ranking 9×3 → See all 2,170 queries →
$