maker taker — 4 answered market questions

How often the quoted spread sits at a single cent (10 June 2026 session)

most recentas of 2026-08-14 ranking 6×3read in context →

How often the quoted spread sits at a single cent (10 June 2026 session) — 6 rows by 3 columns, computed 2026-08-14 from US exchange, SIP and OPRA data.
symbol	avg_spread_cents	one_tick_wide_pct
NFLX	1.3	81.4
KO	1.31	74.2
NVDA	2.6	12.3
AAPL	3.36	10.5
SPY	2.85	10
COST	77.53	0.2

the exact SQL behind every number

SELECT
    ticker                                                                                  AS symbol,
    round(avg(toFloat64(ask_price) - toFloat64(bid_price)) * 100, 2)                        AS avg_spread_cents,
    round(100 * countIf(toFloat64(ask_price) - toFloat64(bid_price) <= 0.0105) / count(), 1) AS one_tick_wide_pct
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('AAPL', 'KO', 'SPY', 'NVDA', 'COST', 'NFLX')
  AND sip_timestamp >= '2026-06-10 13:30:00'
  AND sip_timestamp <  '2026-06-10 20:00:00'
  AND bid_price > 0
  AND ask_price > bid_price
  AND toFloat64(ask_price) - toFloat64(bid_price) < 5
GROUP BY ticker
ORDER BY one_tick_wide_pct DESC

More from this analysisDoes Modifying an Order Lose Queue Priority?

Share of one minute windows carrying at least N shares (June 2026) ranking 9×3 → How fast the tape drains a queue, by time of day (AAPL, June 2026) series 26×3 → Distinct best bid prices per quarter hour (AAPL and KO, 10 June 2026) series 26×3 → Average shares per trade print, June 2026 ranking 8×2 → See all 2,173 queries →