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
SPCX: SpaceX Stock Price Decline From Peak
SPY vs SPCX open-to-close, regular hours, trailing three weeksseries · 2026-08-20 · 15×4Preview: a 15-point series, roughly flat. Stock quote spread and depth by session: the four weeks from listing and the trailing threeseries · 2026-08-20 · 33×5Preview: a 16-point series, ending lower. The arc on one row: issue price, first print, June peak, and the latest closescalar · 2026-08-20 · 1×15150 Options quote spread and size at the touch, the sessions on file in the past week and a halfseries · 2026-08-20 · 4×6Preview: a 4-point series, roughly flat. Put/call volume ratio by session, trailing three weeksseries · 2026-08-20 · 15×5Preview: a 15-point series, roughly flat. News-feed attention from listing day to the latest reading: counts, concentration, and the trailing weekscalar · 2026-08-20 · 1×14627 Latest complete session, half-hour path: closes, lows, and volumeseries · 2026-08-20 · 7×4Preview: a 7-point series, ending higher. Latest session on file: the busiest SPCX option contracts by volumetable · 2026-08-20 · 10×5 Sessions from listing to the first close below the first print: SPCX vs four recent IPOstable · 2026-08-20 · 5×11 Every SPCX filing in the EDGAR index since the June 12 listing, on one rowscalar · 2026-08-20 · 1×1119 Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listingseries · 2026-08-20 · 47×7Preview: a 16-point series, ending lower.
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.
Market Order vs Limit Order, Measured
AAPL options vs. AAPL stock: median quoted spread, same regular session, July 8, 2026scalar · 2026-07-26 · 1×5606 How far SPY moved inside a single minute: average one-minute high-to-low range by time of day, July 8, 2026scalar · 2026-07-26 · 1×470.3 What a 100-share market order pays crossing the spread: July 8, 2026, regular sessionranking · 2026-07-26 · 5×4Preview: 5 ranked values, smallest first. Median quoted spread by session window: pre-market vs. regular vs. after-hours, July 8, 2026ranking · 2026-07-26 · 3×4Preview: 3 ranked values, largest first. Displayed shares at the best ask: median size and how often it covered a 1,000-share order, July 8, 2026ranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first. SPY on a calm day vs. a fast day: session range, per-minute movement, and quoted spreadseries · 2026-07-26 · 2×5Preview: a 2-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 →
$