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

What Limit Price Should I Set on a Stock?
How many cents separate MSFT's bid and ask, by share of quotesranking · 2026-10-09 · 8×3Preview: 8 ranked values, smallest first. AAPL quoted spread by time of day, premarket through late sessionseries · 2026-10-09 · 26×3Preview: a 16-point series, ending lower. Average quoted spread across five household names, mid-sessionranking · 2026-10-09 · 5×4Preview: 5 ranked values, largest first. Share of prints under 100 shares, same mid-session windowranking · 2026-10-09 · 5×4Preview: 5 ranked values, largest first.
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
When Short Options Get Assigned Early
Time value left in AAPL contracts by depth in the moneytable · 2026-10-04 · 5×5 AAPL calls 1 to 5 percent in the money, by days left to expiryranking · 2026-10-04 · 6×4Preview: 6 ranked values, smallest first. Latest cash dividend per share, and what it is worth against the stockseries · 2026-10-04 · 6×4Preview: a 6-point series, ending lower. Put versus call implied volatility, near the money, 20 to 45 days outranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first.
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
When a Spread Expires Between the Strikes
SPY Friday closes against the whole dollar strike grid, by yeartable · 2026-09-27 · 5×5 SPY, 3:00 p.m. to the close on the August 21, 2026 expirationseries · 2026-09-27 · 12×3Preview: a 12-point series, roughly flat. How far SPY travels between 3:00 p.m. ET and the Friday closeranking · 2026-09-27 · 5×4Preview: 5 ranked values, largest first. Where the close finished on a narrow call vertical set at 3:00 p.m. ETtable · 2026-09-27 · 6×5
Why Market Makers Lose Money: Adverse Selection
AAPL prints by distance from the midpoint: share of volume and 60 second markoutranking · 2026-08-13 · 4×3Preview: 4 ranked values, smallest first. How much of the spread survives: AAPL markout curve, 1 second to 5 minutesranking · 2026-08-13 · 6×3Preview: 6 ranked values, smallest first. AAPL fills by print size: credit at the fill and value 60 seconds laterranking · 2026-08-13 · 4×4Preview: 4 ranked values, largest first. How far the price travels while a position waits: SPY and NVDA, May 2026ranking · 2026-08-13 · 6×3Preview: 6 ranked values, smallest first.
Half-Penny Tick Sizes Under Rule 612
Average quoted spread and time on the penny floor, pinned sessionranking · 2026-08-13 · 8×3Preview: 8 ranked values, smallest first. Share of the session spent at each quoted spread, three namesranking · 2026-08-13 · 5×4Preview: 5 ranked values, largest first. Share of each 15 minute bucket spent at a one cent quoted spreadseries · 2026-08-13 · 30×3Preview: a 16-point series, ending higher. What one cent is worth, as a share of the closing priceranking · 2026-08-13 · 8×3Preview: 8 ranked values, largest first.
Sector Scorecard H1 2026: Winners and Losers
Eight heavily traded chip and memory names: H1 return, quarter split, H1 dollar volumetable · 2026-07-26 · 8×5 Median quoted spread by sector ETF, one representative session (June 29, 2026), regular hoursranking · 2026-07-26 · 11×4Preview: 11 ranked values, smallest first. The eleven sector ETFs: H1 2026 return, Q1 and Q2 split, and H1 dollar volumetable · 2026-07-26 · 11×5 XLE, XLF, and XLK by month: the H1 2026 rotation at month grainseries · 2026-07-26 · 18×3Preview: a 16-point series, ending lower. Five-name baskets per sector: members up vs down, median, best and worst, H1 2026table · 2026-07-26 · 11×9 Sector ETF dollar volume, Q1 vs Q2 2026: every fund traded less in the recovery quarterranking · 2026-07-26 · 11×4Preview: 11 ranked values, largest first.
How many cents separate MSFT's bid and ask, by share of quotes

How many cents separate MSFT's bid and ask, by share of quotes

most recentas of ranking 8×3read in context →
How many cents separate MSFT's bid and ask, by share of quotes — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
spread_widthshare_of_quotes_pctquote_count
1 cent wide2.91326
2 cents wide5.22411
3 cents wide8.53955
4 cents wide13.86397
5 cents wide15.77265
6 cents wide17.58105
7 cents wide20.49437
8 cents wide15.97379
the exact SQL behind every number 
WITH quotes AS
(
    SELECT toUInt32(round((toFloat64(ask_price) - toFloat64(bid_price)) * 100)) AS ticks
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'MSFT'
      AND sip_timestamp >= '2026-09-15 14:00:00'
      AND sip_timestamp <  '2026-09-15 19:00:00'
      AND bid_price > 0
      AND ask_price > bid_price
      AND (toFloat64(ask_price) - toFloat64(bid_price)) <= 0.08
)
SELECT
    concat(toString(ticks), if(ticks = 1, ' cent wide', ' cents wide')) AS spread_width,
    round(100 * count() / (SELECT count() FROM quotes), 1)              AS share_of_quotes_pct,
    count()                                                             AS quote_count
FROM quotes
GROUP BY ticks
ORDER BY ticks
More from this analysisWhat Limit Price Should I Set on a Stock?
Average quoted spread across five household names, mid-session ranking 5×4 → Share of prints under 100 shares, same mid-session window ranking 5×4 → AAPL quoted spread by time of day, premarket through late session series 26×3 → Where one session of AAPL prints actually happened, by venue ranking 15×4 → See all 3,256 queries →
$