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.
Stock Order Types Explained: The Core Four
AAPL average quoted spread by ET clock time, Sep 16 2026series · 2026-10-08 · 64×3Preview: a 16-point series, ending lower. Average quoted spread across six household names, one mid-morning hourranking · 2026-10-08 · 6×3Preview: 6 ranked values, smallest first. How often a buy limit under the prior close was reached (AAPL, one year of sessions)ranking · 2026-10-08 · 6×2Preview: 6 ranked values, largest first. Overnight gap between one close and the next open, year to Sep 2026ranking · 2026-10-08 · 6×4Preview: 6 ranked values, largest first.
Forex Pending Order Types: Limits & Stops
Median and 95th-percentile opening step by weekday (SPY, 2016 to 2026)series · 2026-10-07 · 5×3Preview: a 5-point series, roughly flat. How often a session reached a level set away from the open (SPY, 2016 to 2026)ranking · 2026-10-07 · 5×3Preview: 5 ranked values, largest first. How far the open landed from the prior close (SPY sessions, 2016 to 2026)ranking · 2026-10-07 · 6×3Preview: 6 ranked values, largest first. The ten largest opening steps in SPY, 2016 to 2026series · 2026-10-07 · 10×4Preview: a 10-point series, ending lower.
Limit Orders on Crypto Exchanges vs Stocks
The same stock, quoted venue by venue: AAPL spreads by exchangeranking · 2026-10-06 · 3×4Preview: 3 ranked values, smallest first. AAPL print sizes in one hour, Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Where AAPL's volume sat by ET hour, September 2026series · 2026-10-06 · 16×3Preview: a 16-point series, roughly flat. Average quoted spread across household names, five minutes on Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, smallest first.
Why a Limit Order Didn't Fill: 5 Causes
Where one session of AAPL prints actually happened, by venueranking · 2026-10-05 · 15×4Preview: 15 ranked values, largest first. Minutes a session spends near its own low, five household namesseries · 2026-10-05 · 5×4Preview: a 5-point series, roughly flat. Shares traded at KO's lowest price levels in one sessionranking · 2026-10-05 · 8×3Preview: 8 ranked values, smallest first. Odd lots versus round lots in one AAPL session: prints and sharesranking · 2026-10-05 · 5×4Preview: 5 ranked values, largest first.
Can You Cancel a Limit Order Before It Fills
How often the best quote changed, fifteen minute buckets, Sep 15 2026series · 2026-10-05 · 26×3Preview: a 16-point series, ending lower. AAPL print sizes, share of trades and share of volume, Sep 15 2026ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. Average gap between tape prints, regular session, Sep 15 2026ranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. SPY volume by fifteen minute bucket, Sep 15 2026series · 2026-10-05 · 26×2Preview: a 16-point series, ending lower.
Buy Limit vs Sell Limit Orders Explained
How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. A 1% buy limit vs a 1% sell limit: share of SPY sessions reached, by yearranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. The gap a marketable limit crosses: average quoted spread, five names, Sep 15 2026ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. A real quote in motion: Apple's bid and ask by the minute, Sep 15 2026series · 2026-10-05 · 15×4Preview: a 15-point series, ending higher.
Ex-Dividend Date: Open Orders and Premarket
KO premarket on its latest ex-dividend morning, both references side by sideseries · 2026-10-04 · 11×4Preview: a 11-point series, ending lower. KO's ex-date opening print, measured against both referencesseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. KO: every quarterly ex-dividend adjustment over the trailing three yearsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. Upcoming ex-dividend dates and the size of the open-order reductionranking · 2026-10-04 · 2×4Preview: 2 ranked values, largest first.
Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. How far one index ETF travelled inside each recent sessionseries · 2026-10-04 · 30×4Preview: a 16-point series, ending lower. Upcoming market closures that move a fund order's strike dateseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Time in Force Explained: Day, GTC, IOC, FOK
SPY share volume by ET clock hour, June 2026series · 2026-09-28 · 16×2Preview: a 16-point series, roughly flat. Print sizes across five names, 10:00 to 11:00 a.m. ET on 2026-06-10ranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. US stock splits per month, forward and reverseseries · 2026-09-28 · 12×3Preview: a 12-point series, ending higher. SPY volume per minute into the close, then the closing cross, June 2026 session averageseries · 2026-09-28 · 16×2Preview: a 16-point series, ending higher.
Stop Order vs Stop-Limit Order: How Each Fills
Average one-minute high-low range by time of dayseries · 2026-08-08 · 13×3Preview: a 13-point series, ending lower. Sessions that gapped through a 2% stop, and whether the limit price tradedranking · 2026-08-08 · 5×3Preview: 5 ranked values, smallest first. NVDA's largest gap-down opens and the 30 minutes that followedseries · 2026-08-08 · 8×3Preview: a 8-point series, ending higher. How often each stock opened below the prior closeranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first.
The Sub-Penny Rule and Price Improvement
What one cent is worth, by share price bandranking · 2026-08-07 · 8×3Preview: 8 ranked values, smallest first. The penny tick and the quoted gap, in basis pointstable · 2026-08-07 · 7×5 Share of prints that landed on a sub-penny priceranking · 2026-08-07 · 7×3Preview: 7 ranked values, largest first. AAPL sub-penny print rate by trade size, 17 June 2026ranking · 2026-08-07 · 5×3Preview: 5 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 →
$