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

Self-Match Prevention and Wash Trades
Venues quoting and printing the same stock in one 15-minute windowranking · 2026-08-13 · 6×3Preview: 6 ranked values, largest first. Trade condition flags on one full sessionranking · 2026-08-13 · 10×3Preview: 10 ranked values, largest first. Option contracts with volume on one underlying, June 2026series · 2026-08-13 · 21×3Preview: a 16-point series, ending lower. Prints per 15-minute bucket, one full sessionseries · 2026-08-13 · 64×2Preview: a 16-point series, ending lower.
Price-Time Priority vs Pro-Rata Fills
Quote updates per second and average quoted spread, ten minutes on 17 June 2026ranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first. Average shares per trade print, June 2026ranking · 2026-08-08 · 8×2Preview: 8 ranked values, largest first. AAPL option prints by contract count, 17 June 2026ranking · 2026-08-08 · 5×2Preview: 5 ranked values, largest first. AAPL trade prints by share count, 17 June 2026ranking · 2026-08-08 · 5×2Preview: 5 ranked values, largest first.
Venues quoting and printing the same stock in one 15-minute window

Venues quoting and printing the same stock in one 15-minute window

most recentas of ranking 6×3read in context →
Venues quoting and printing the same stock in one 15-minute window — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickerquoting_venuesprinting_venues
AAPL1617
MSFT1617
NVDA1617
JNJ1416
SPY1417
KO1117
the exact SQL behind every number 
SELECT
    q.ticker          AS ticker,
    q.quoting_venues  AS quoting_venues,
    t.printing_venues AS printing_venues
FROM
(
    SELECT
        ticker,
        countDistinct(bid_exchange) AS quoting_venues
    FROM global_markets.cache_stocks_quotes
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'JNJ')
      AND sip_timestamp >= toDateTime('2026-06-10 14:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-10 14:15:00', 'UTC')
      AND bid_price > 0
    GROUP BY ticker
) AS q
INNER JOIN
(
    SELECT
        ticker,
        countDistinct(exchange) AS printing_venues
    FROM global_markets.stocks_trades
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'JNJ')
      AND sip_timestamp >= toDateTime('2026-06-10 14:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-10 14:15:00', 'UTC')
    GROUP BY ticker
) AS t ON t.ticker = q.ticker
ORDER BY quoting_venues DESC, ticker
More from this analysisSelf-Match Prevention and Wash Trades
Trade condition flags on one full session ranking 10×3 → Prints per 15-minute bucket, one full session series 64×2 → Option contracts with volume on one underlying, June 2026 series 21×3 → Average shares per trade print, June 2026 ranking 8×2 → See all 2,170 queries →
$