How to Become a Registered Market Maker
Average quoted spread across six household names, midday July 16 2026ranking ·
2026-08-15 · 6×3
Quoted spread through one session, AAPL and KO, July 16 2026series ·
2026-08-15 · 26×3
Venues publishing a bid in AAPL over one half hour, July 16 2026ranking ·
2026-08-15 · 16×4
Listed AAPL option contracts by expiration, July 16 2026series ·
2026-08-15 · 24×4
Half-Penny Tick Sizes Under Rule 612
Average quoted spread and time on the penny floor, pinned sessionranking ·
2026-08-13 · 8×3
Share of the session spent at each quoted spread, three namesranking ·
2026-08-13 · 5×4
Share of each 15 minute bucket spent at a one cent quoted spreadseries ·
2026-08-13 · 30×3
What one cent is worth, as a share of the closing priceranking ·
2026-08-13 · 8×3
Average quoted spread across six household names, midday July 16 2026
Average quoted spread across six household names, midday July 16 2026
| ticker | avg_spread_bps | quote_update_count |
|---|---|---|
| AAPL | 1.23 | 145511 |
| KO | 1.41 | 31083 |
| NVDA | 1.43 | 112402 |
| MSFT | 1.91 | 16729 |
| PFE | 3.98 | 9789 |
| F | 7.09 | 6528 |
the exact SQL behind every number
SELECT
ticker,
round(avg(10000 * (toFloat64(ask_price) - toFloat64(bid_price))
/ ((toFloat64(ask_price) + toFloat64(bid_price)) / 2)), 2) AS avg_spread_bps,
count() AS quote_update_count
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'F', 'PFE')
AND sip_timestamp >= toDateTime('2026-07-16 16:00:00')
AND sip_timestamp < toDateTime('2026-07-16 16:30:00')
AND bid_price > 0
AND ask_price > bid_price
GROUP BY ticker
ORDER BY avg_spread_bps
More from this analysisHow to Become a Registered Market Maker
Venues publishing a bid in AAPL over one half hour, July 16 2026
ranking 16×4
→
Quoted spread through one session, AAPL and KO, July 16 2026
series 26×3
→
Listed AAPL option contracts by expiration, July 16 2026
series 24×4
→
AAPL trades by venue, latest session: off-exchange first
ranking 19×4
→
See all 2,170 queries →