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

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.
Why Are Spreads Wider at the Open? Real Data
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling windowscalar · 2026-10-04 · 1×2570 Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET)series · 2026-10-04 · 13×4Preview: a 13-point series, ending higher. Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET)series · 2026-10-04 · 13×4Preview: a 13-point series, ending lower. Session by session: how often, and by how much, the open ran wider than middaytable · 2026-10-04 · 3×6 Median quoted spread by phase of the trading day, in basis points (ET clock)ranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. The opening premium priced: median and 90th-percentile spread at the open (9:30-10:00 ET) vs. midday (12:00-14:00 ET)table · 2026-10-04 · 3×12 MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours)series · 2026-10-04 · 13×5Preview: a 13-point series, ending lower. MU into July 7, 2026: prior regular-session close, opening print, overnight gapscalar · 2026-10-04 · 1×3984.31
What It Costs to Trade a Stock, Measured
The one-cent floor: share price, percent of quotes exactly one cent wide, and what a penny costs in bpstable · 2026-10-04 · 5×6 NVDA vs SOXS: median quoted spread over the window, with the smallest single-session gapscalar · 2026-10-04 · 1×50.87 NVDA vs SOXS: median quoted spread by session (bps of the midpoint)series · 2026-10-04 · 5×4Preview: a 5-point series, ending higher. The cost-to-trade ladder: median quoted spread in bps of the midpoint, regular hours, recent completed sessionstable · 2026-10-04 · 12×5
What Is a Bid-Ask Spread? Real Costs
Typical quoted spread: six liquid names vs. two thin small caps, with the 100-share costranking · 2026-10-04 · 8×4Preview: 8 ranked values, smallest first. AAPL median quoted spread by 30-minute bucket (ET, extended hours included)series · 2026-10-04 · 32×2Preview: a 16-point series, ending lower. The same curve at four checkpoints: premarket, the open, midday, the closeseries · 2026-10-04 · 4×2Preview: a 4-point series, ending lower. AAPL: the last recorded NBBO quote in our data windowscalar · 2026-10-04 · 1×70.015
Paper Trading Before Real Money
One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessionsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. Five years of sessions: share closing above the open, typical move, and the extremes (SPY, 2021-2025)table · 2026-10-04 · 5×6 What a real fill costs: median quoted spread in bps of the midpoint, regular hours, recent completed sessionsranking · 2026-10-04 · 6×4Preview: 6 ranked values, smallest first.
How Do Market Makers Make Money? The Spread
US stock venues: public exchanges vs off-exchange reporting facilitiesranking · 2026-10-04 · 2×3Preview: 2 ranked values, largest first. AAPL trades by venue, latest session: off-exchange firstranking · 2026-10-04 · 19×4Preview: 16 ranked values, largest first. Average quoted spread: liquid mega-caps vs a thin small-cap (past week)ranking · 2026-10-04 · 3×4Preview: 3 ranked values, smallest first. AAPL average quoted spread by half-hour (ET), one extended sessionseries · 2026-10-04 · 32×2Preview: a 16-point series, ending lower. AAPL: NBBO quote updates on the latest sessionscalar · 2026-10-04 · 1×40.72
How Much Does It Cost to Trade Options?
Options trade size distribution on July 2, 2026 (whole-tape contracts per print)scalar · 2026-08-14 · 1×41 SPY options vs. SPY stock on one session: quote count, trade count, and median quoted spreadscalar · 2026-08-14 · 1×10462.93M SPY options quoted-spread distribution: percentiles in basis pointsscalar · 2026-08-14 · 1×635.51 SPY options quote quality: valid, one-sided, and locked/crossed recordsscalar · 2026-08-14 · 1×7463.20M SPY options median spread by expiration date, near-the-money strikes onlyranking · 2026-08-14 · 25×4Preview: 16 ranked values, largest first. Options bid-ask spreads by product: median basis points, July 2, 2026 regular hoursranking · 2026-08-14 · 5×4Preview: 5 ranked values, smallest first.
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,256 queries →
$