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

US Stock Market Hours Around the World
The US trading day converted into ten local clocks: static illustrative reference, July 2026table · 2026-07-31 · 10×6 Local time of the 9:30 a.m. New York open, January against July: static illustrative reference for 2026ranking · 2026-07-31 · 6×4Preview: 6 ranked values, smallest first.
Trading US 0DTE Options From Japan
Same-day options volume by Japan Standard Time hour: all US-listed options, Friday July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, largest first. Median bid-ask spread on SPY same-day contracts quoted $1-$10, by Japan Standard Time hour: July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, smallest first. Japanese local time of each US session boundary, January against July: static illustrative reference for 2026series · 2026-07-31 · 4×4Preview: a 4-point series, roughly flat. The US trading day converted into Japan Standard Time: static illustrative reference, July 2026series · 2026-07-31 · 6×5Preview: a 6-point series, ending higher.
The US trading day converted into ten local clocks: static illustrative reference, July 2026

The US trading day converted into ten local clocks: static illustrative reference, July 2026

most recentas of table 10×6read in context →
The US trading day converted into ten local clocks: static illustrative reference, July 2026 — 10 rows by 6 columns, computed from US exchange, SIP and OPRA data.
citylocal_premarket_openlocal_regular_openlocal_regular_closelocal_after_hours_closehours_ahead_of_new_york
Los Angeles01:0006:3013:0017:00-3
New York04:0009:3016:0020:000
Sao Paulo05:0010:3017:0021:001
London09:0014:3021:0001:005
Frankfurt10:0015:3022:0002:006
Moscow15:0020:3003:0007:007
Dubai12:0017:3000:0004:008
Singapore16:0021:3004:0008:0012
Tokyo17:0022:3005:0009:0013
Sydney18:0023:3006:0010:0014
the exact SQL behind every number 
SELECT
    w.1 AS city,
    w.2 AS local_premarket_open,
    w.3 AS local_regular_open,
    w.4 AS local_regular_close,
    w.5 AS local_after_hours_close,
    w.6 AS hours_ahead_of_new_york
FROM
(
    SELECT arrayJoin([
        ('Los Angeles', '01:00', '06:30', '13:00', '17:00', -3),
        ('New York',    '04:00', '09:30', '16:00', '20:00',  0),
        ('Sao Paulo',   '05:00', '10:30', '17:00', '21:00',  1),
        ('London',      '09:00', '14:30', '21:00', '01:00',  5),
        ('Frankfurt',   '10:00', '15:30', '22:00', '02:00',  6),
        ('Moscow',      '15:00', '20:30', '03:00', '07:00',  7),
        ('Dubai',       '12:00', '17:30', '00:00', '04:00',  8),
        ('Singapore',   '16:00', '21:30', '04:00', '08:00', 12),
        ('Tokyo',       '17:00', '22:30', '05:00', '09:00', 13),
        ('Sydney',      '18:00', '23:30', '06:00', '10:00', 14)
    ]) AS w
)
More from this analysisUS Stock Market Hours Around the World
Local time of the 9:30 a.m. New York open, January against July: static illustrative reference for 2026 ranking 6×4 → SPY volume by half hour, premarket through after-hours (same session, ET clock) table 32×2 → The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026 table 8×5 → Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only) table 3×5 → See all 2,170 queries →
$