slippage — 7 answered market questions

Share of AAPL prints carrying a sub-penny price, by ET hour (Sep 16, 2026)

most recentas of 2026-10-05 ranking 5×3read in context →

Share of AAPL prints carrying a sub-penny price, by ET hour (Sep 16, 2026) — 5 rows by 3 columns, computed 2026-10-05 from US exchange, SIP and OPRA data.
et_hour	print_count	subpenny_pct
10:00	117449	53.19
11:00	110938	62.82
12:00	54569	50.3
13:00	40150	32.93
14:00	81758	26.85

the exact SQL behind every number

SELECT
    formatDateTime(toStartOfHour(toTimeZone(sip_timestamp, 'America/New_York')), '%H:%i') AS et_hour,
    count()                                                                   AS print_count,
    round(100 * countIf(toUInt64(round(toFloat64(price) * 10000)) % 100 != 0)
          / count(), 2)                                                       AS subpenny_pct
FROM global_markets.stocks_trades
WHERE ticker = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-09-16 14:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-09-16 19:00:00', 'UTC')
  AND price > 0
  AND size > 0
GROUP BY et_hour
ORDER BY et_hour

More from this analysisWhat Price Does a Market Order Fill At?

Quoted spread across six household names, 11:00 to 11:30 a.m. ET on Sep 16, 2026 ranking 6×3 → How AAPL volume splits across print sizes, 10:00 a.m. to 3:00 p.m. ET (Sep 16, 2026) ranking 5×3 → AAPL quoted spread in five minute buckets, 9:00 to 11:00 a.m. ET (Sep 16, 2026) series 24×3 → Venue timestamp to consolidated feed, in microseconds ranking 5×3 → See all 3,094 queries →