STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

How Do Market Makers Make Money? The Spread
US stock venues: public exchanges vs off-exchange reporting facilitiesranking · 2026-08-22 · 2×3Preview: 2 ranked values, largest first. AAPL trades by venue, latest session: off-exchange firstranking · 2026-08-22 · 19×4Preview: 16 ranked values, largest first. Average quoted spread: liquid mega-caps vs a thin small-cap (past week)ranking · 2026-08-22 · 3×4Preview: 3 ranked values, smallest first. AAPL average quoted spread by half-hour (ET), one extended sessionseries · 2026-08-22 · 32×2Preview: a 16-point series, ending lower. AAPL: NBBO quote updates on the latest sessionscalar · 2026-08-22 · 1×41.2
How Delta Hedging Actually Works
Total daily movement versus net movement, June 2026ranking · 2026-08-16 · 4×4Preview: 4 ranked values, largest first. SPY at-the-money implied volatility against realized volatility, by monthseries · 2026-08-16 · 12×3Preview: a 12-point series, ending higher. Shares a 1% move forces per 100 at-the-money SPY contracts, by time left (June 2026)ranking · 2026-08-16 · 5×2Preview: 5 ranked values, largest first. Average call and put delta by strike distance from spot (SPY, 25 to 35 days to expiry, June 2026)ranking · 2026-08-16 · 11×3Preview: 11 ranked values, largest first.
How to Become a Registered Market Maker
Average quoted spread across six household names, midday July 16 2026ranking · 2026-08-15 · 6×3Preview: 6 ranked values, smallest first. Quoted spread through one session, AAPL and KO, July 16 2026series · 2026-08-15 · 26×3Preview: a 16-point series, ending lower. Venues publishing a bid in AAPL over one half hour, July 16 2026ranking · 2026-08-15 · 16×4Preview: 16 ranked values, largest first. Listed AAPL option contracts by expiration, July 16 2026series · 2026-08-15 · 24×4Preview: a 16-point series, ending lower.
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.
Who Are the Biggest Market Makers?
Where Apple trades printed on June 10, 2026, by venueranking · 2026-08-11 · 15×3Preview: 15 ranked values, largest first. Quoted spread and quote traffic over fifteen minutes, June 10, 2026table · 2026-08-11 · 5×5 Listed option series carrying data on one date, by underlyingranking · 2026-08-11 · 5×4Preview: 5 ranked values, largest first. Share of Apple volume printed off exchange, by monthseries · 2026-08-11 · 12×2Preview: a 12-point series, ending lower.
Why Your Options Order Isn't Getting Filled
Apple option trades on June 17 2026: share of prints vs share of contracts, by trade sizeranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. Apple option activity by strike distance, 20 to 45 days to expiry, May and June 2026ranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. Median quoted spread on Apple options by contract price, 30 second window on June 17 2026ranking · 2026-08-07 · 5×3Preview: 5 ranked values, smallest first. Apple options quote updates, second by second, 2:00 p.m. ET on June 17 2026series · 2026-08-07 · 30×3Preview: a 16-point series, ending higher.
US stock venues: public exchanges vs off-exchange reporting facilities

US stock venues: public exchanges vs off-exchange reporting facilities

most recentas of ranking 2×3read in context →
US stock venues: public exchanges vs off-exchange reporting facilities — 2 rows by 3 columns, computed from US exchange, SIP and OPRA data.
venue_typevenuesvenue_names
public exchange1824X National Exchange LLC | Cboe BYX | Cboe BZX | Cboe EDGA | Cboe EDGX | Investors Exchange | Long-Term Stock Exchange | MIAX Pearl | Members Exchange | NYSE American, LLC | NYSE Arca, Inc. | NYSE National, Inc. | NYSE Texas, Inc. | Nasdaq | Nasdaq Philadelphia Exchange LLC | Nasdaq Texas, Inc. | New York Stock Exchange | Texas Stock Exchange LLC
off-exchange reporting facility (TRF)6Cboe Stock Exchange | FINRA Alternative Display Facility | FINRA NYSE TRF | FINRA Nasdaq TRF Carteret | FINRA Nasdaq TRF Chicago | International Securities Exchange, LLC - Stocks
the exact SQL behind every number 
SELECT
  if(type = 'TRF', 'off-exchange reporting facility (TRF)', 'public exchange') AS venue_type,
  count() AS venues,
  arrayStringConcat(arraySort(groupArray(name)), ' | ') AS venue_names
FROM global_markets.stocks_exchanges
WHERE asset_class = 'stocks' AND locale = 'us' AND type IN ('exchange', 'TRF')
GROUP BY venue_type
ORDER BY venues DESC
More from this analysisHow Do Market Makers Make Money? The Spread
AAPL trades by venue, latest session: off-exchange first ranking 19×4 → Average quoted spread: liquid mega-caps vs a thin small-cap (past week) ranking 3×4 → AAPL average quoted spread by half-hour (ET), one extended session series 32×2 → AAPL: NBBO quote updates on the latest session scalar 1×4 → See all 2,170 queries →
$