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

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.
Quote updates per second and average quoted spread, ten minutes on 17 June 2026

Quote updates per second and average quoted spread, ten minutes on 17 June 2026

most recentas of ranking 5×3read in context →
Quote updates per second and average quoted spread, ten minutes on 17 June 2026 — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbolquote_updates_per_secondavg_spread_bps
SPY296.40.32
NVDA181.11.25
AAPL34.41.51
MSFT29.52.16
KO28.82.27
the exact SQL behind every number 
SELECT
    ticker                    AS symbol,
    round(count() / 600.0, 1) AS quote_updates_per_second,
    round(avg(toFloat64(ask_price) - toFloat64(bid_price))
          / avg(toFloat64(bid_price)) * 10000, 2) AS avg_spread_bps
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO')
  AND sip_timestamp >= '2026-06-17 14:00:00'
  AND sip_timestamp <  '2026-06-17 14:10:00'
  AND bid_price > 0
  AND ask_price > bid_price
GROUP BY ticker
ORDER BY quote_updates_per_second DESC
More from this analysisPrice-Time Priority vs Pro-Rata Fills
Average shares per trade print, June 2026 ranking 8×2 → AAPL option prints by contract count, 17 June 2026 ranking 5×2 → AAPL trade prints by share count, 17 June 2026 ranking 5×2 → Trade condition flags on one full session ranking 10×3 → See all 2,170 queries →
$