STRASMORE/EXPLORE 3,094 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,094 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

What Price Does a Market Order Fill At?
Share of AAPL prints carrying a sub-penny price, by ET hour (Sep 16, 2026)ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. AAPL quoted spread in five minute buckets, 9:00 to 11:00 a.m. ET (Sep 16, 2026)series · 2026-10-05 · 24×3Preview: a 16-point series, ending lower. Quoted spread across six household names, 11:00 to 11:30 a.m. ET on Sep 16, 2026ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. How AAPL volume splits across print sizes, 10:00 a.m. to 3:00 p.m. ET (Sep 16, 2026)ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first.
How Long a Market Order Takes to Fill
Venue timestamp to consolidated feed, in microsecondsranking · 2026-10-02 · 5×3Preview: 5 ranked values, smallest first. Median quoted spread in basis points, same sessionranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first. Prints in a pinned 30-minute window, five household namesranking · 2026-10-02 · 5×4Preview: 5 ranked values, largest first. Seconds between prints, by how often a name tradesranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first.
Share of AAPL prints carrying a sub-penny price, by ET hour (Sep 16, 2026)

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

most recentas of 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 from US exchange, SIP and OPRA data.
et_hourprint_countsubpenny_pct
10:0011744953.19
11:0011093862.82
12:005456950.3
13:004015032.93
14:008175826.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 →
$