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

3,171 answered market questions

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

The Real Disadvantages of a Stock Split
What a one cent tick costs at each price levelranking · 2026-10-07 · 7×4Preview: 7 ranked values, largest first. A one cent tick before and after real forward splitstable · 2026-10-07 · 12×5 NVIDIA traded option strikes across its 2024 splitseries · 2026-10-07 · 7×4Preview: a 7-point series, ending lower. Share count, per share earnings and revenue across a splitseries · 2026-10-07 · 7×5Preview: a 7-point series, ending higher.
What a one cent tick costs at each price level

What a one cent tick costs at each price level

most recentas of ranking 7×4read in context →
What a one cent tick costs at each price level — 7 rows by 4 columns, computed from US exchange, SIP and OPRA data.
price_buckettickers_countmedian_close_usdtick_spread_bps
Under $512411.7557.143
$5 to $20156711.19.009
$20 to $50160332.123.113
$50 to $10092069.371.442
$100 to $250602142.50.702
$250 to $500203320.510.312
$500 and up66673.30.149
the exact SQL behind every number 
WITH monthly AS (
    SELECT
        ticker,
        argMax(toFloat64(close), date) AS last_close,
        avg(volume)                    AS avg_volume,
        count()                        AS sessions
    FROM global_markets.stocks_daily_aggs
    WHERE date BETWEEN '2026-09-01' AND '2026-09-30'
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    HAVING sessions >= 15
       AND avg_volume >= 100000
       AND last_close > 0
)
SELECT
    multiIf(last_close <   5, 'Under $5',
            last_close <  20, '$5 to $20',
            last_close <  50, '$20 to $50',
            last_close < 100, '$50 to $100',
            last_close < 250, '$100 to $250',
            last_close < 500, '$250 to $500',
                              '$500 and up')                                     AS price_bucket,
    count()                                                                      AS tickers_count,
    round(quantileDeterministic(0.5)(last_close, cityHash64(ticker)), 2)         AS median_close_usd,
    round(100.0 / quantileDeterministic(0.5)(last_close, cityHash64(ticker)), 3) AS tick_spread_bps
FROM monthly
GROUP BY price_bucket
ORDER BY min(last_close)
More from this analysisThe Real Disadvantages of a Stock Split
A one cent tick before and after real forward splits table 12×5 → NVIDIA traded option strikes across its 2024 split series 7×4 → Share count, per share earnings and revenue across a split series 7×5 → Typical quoted spread: six liquid names vs. two thin small caps, with the 100-share cost ranking 8×4 → See all 3,171 queries →
$