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

3,293 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.
Micro E-mini vs E-mini Futures: Specs & Cost
SPY volume on each quarterly expiry Friday against its prior 20 sessionsseries · 2026-09-28 · 13×3Preview: a 13-point series, ending higher. Average daily range by index family, trailing six monthsranking · 2026-09-28 · 4×3Preview: 4 ranked values, largest first.
DAX Futures Explained: FDAX, FDXM, FDXS
Quarterly third Friday volume against the trailing 20 session averageseries · 2026-09-23 · 14×5Preview: a 14-point series, ending higher. Share of a Germany fund's monthly volume printed after the 17:30 CET Frankfurt closeseries · 2026-09-23 · 12×3Preview: a 12-point series, ending lower. Where a listed Germany fund's volume sits on the New York clock (Jun to Aug 2026)ranking · 2026-09-23 · 8×3Preview: 8 ranked values, largest first.
Futures Tick Size and Tick Value Explained
Worked P&L examples: ticks moved x tick value x contracts (hypothetical)table · 2026-09-16 · 7×5 Outright tick size and tick value per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first. Calendar spread tick versus outright tick, dollars per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first.
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
$