STRASMORE/EXPLORE 3,127 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,127 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

How Many Shares in an Options Contract?
Recent reverse splits and the deliverable left behindranking · 2026-10-06 · 10×4Preview: 10 ranked values, smallest first. Average near-the-money premium per share, September 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Fractional-ratio splits and the share count they leave per contractranking · 2026-10-06 · 12×4Preview: 12 ranked values, largest first. One quote, two multipliers: AAPL near-the-money premium converted to cashseries · 2026-10-06 · 21×4Preview: a 16-point series, ending lower.
Recent reverse splits and the deliverable left behind

Recent reverse splits and the deliverable left behind

most recentas of ranking 10×4read in context →
Recent reverse splits and the deliverable left behind — 10 rows by 4 columns, computed from US exchange, SIP and OPRA data.
symboleffective_labelratioshares_per_contract
SHFSSep 30, 20261-for-128.33
GSPFDSep 30, 20261-for-520
DHYSep 30, 20261-for-1010
TRUGSep 29, 20261-for-1010
VRMESep 29, 20261-for-1010
AGRZSep 29, 20261-for-205
CDTSep 29, 20261-for-254
ONMDSep 29, 20261-for-1010
GMEXSep 28, 20261-for-911.11
DLXYSep 28, 20261-for-520
the exact SQL behind every number
SELECT
    ticker                                            AS symbol,
    formatDateTime(execution_date, '%b %e, %Y')       AS effective_label,
    concat(
        toString(round(toFloat64(any(split_to)), 2)),
        '-for-',
        toString(round(toFloat64(any(split_from)), 2))
    )                                                 AS ratio,
    round(100 * toFloat64(any(split_to)) / toFloat64(any(split_from)), 2) AS shares_per_contract
FROM global_markets.stocks_splits
WHERE execution_date >= '2026-01-01'
  AND execution_date <= '2026-09-30'
  AND ticker NOT IN ('SPCX')
  AND toFloat64(split_to) < toFloat64(split_from)
GROUP BY ticker, execution_date
ORDER BY execution_date DESC
LIMIT 10
$