STRASMORE/EXPLORE 2,170 QUERIES

The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-04, from US Market Hours and Daylight Saving Time.

as of table 8×5read in context →
The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026 — 8 rows by 5 columns, computed from US exchange, SIP and OPRA data.
citylocal_open_us_summerlocal_open_us_winterhours_ahead_us_summerhours_ahead_us_winter
Sao Paulo10:3011:3012
London14:3014:3055
Frankfurt15:3015:3066
Dubai17:3018:3089
Mumbai19:0020:009.510.5
Singapore21:3022:301213
Tokyo22:3023:301314
Sydney23:3001:301416
Rows × columns
8 × 5
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for The 9:30 New York open in eight cities: US summer clock against US winter clock, 2026, derived from the stored result.
ColumnTypeRangeNotes
city text 8 distinct values (Dubai, Frankfurt, London…)
local_open_us_summer text 8 distinct values (10:30, 14:30, 15:30…)
local_open_us_winter text 8 distinct values (01:30, 11:30, 14:30…)
hours_ahead_us_summer number 1 to 14
hours_ahead_us_winter number 2 to 16

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
WITH anchors AS (
    SELECT maxIf(window_start, toMonth(toTimeZone(window_start, 'America/New_York')) = 6) AS summer,
           maxIf(window_start, toMonth(toTimeZone(window_start, 'America/New_York')) = 1) AS winter
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toYear(toTimeZone(window_start, 'America/New_York')) = 2026
      AND toMonth(toTimeZone(window_start, 'America/New_York')) IN (1, 6)
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) = 570
),
local_opens AS (
    SELECT arrayJoin([
        ('Sao Paulo', toHour(toTimeZone(summer, 'America/Sao_Paulo')) * 60 + toMinute(toTimeZone(summer, 'America/Sao_Paulo')), toHour(toTimeZone(winter, 'America/Sao_Paulo')) * 60 + toMinute(toTimeZone(winter, 'America/Sao_Paulo'))),
        ('London', toHour(toTimeZone(summer, 'Europe/London')) * 60 + toMinute(toTimeZone(summer, 'Europe/London')), toHour(toTimeZone(winter, 'Europe/London')) * 60 + toMinute(toTimeZone(winter, 'Europe/London'))),
        ('Frankfurt', toHour(toTimeZone(summer, 'Europe/Berlin')) * 60 + toMinute(toTimeZone(summer, 'Europe/Berlin')), toHour(toTimeZone(winter, 'Europe/Berlin')) * 60 + toMinute(toTimeZone(winter, 'Europe/Berlin'))),
        ('Dubai', toHour(toTimeZone(summer, 'Asia/Dubai')) * 60 + toMinute(toTimeZone(summer, 'Asia/Dubai')), toHour(toTimeZone(winter, 'Asia/Dubai')) * 60 + toMinute(toTimeZone(winter, 'Asia/Dubai'))),
        ('Mumbai', toHour(toTimeZone(summer, 'Asia/Kolkata')) * 60 + toMinute(toTimeZone(summer, 'Asia/Kolkata')), toHour(toTimeZone(winter, 'Asia/Kolkata')) * 60 + toMinute(toTimeZone(winter, 'Asia/Kolkata'))),
        ('Singapore', toHour(toTimeZone(summer, 'Asia/Singapore')) * 60 + toMinute(toTimeZone(summer, 'Asia/Singapore')), toHour(toTimeZone(winter, 'Asia/Singapore')) * 60 + toMinute(toTimeZone(winter, 'Asia/Singapore'))),
        ('Tokyo', toHour(toTimeZone(summer, 'Asia/Tokyo')) * 60 + toMinute(toTimeZone(summer, 'Asia/Tokyo')), toHour(toTimeZone(winter, 'Asia/Tokyo')) * 60 + toMinute(toTimeZone(winter, 'Asia/Tokyo'))),
        ('Sydney', toHour(toTimeZone(summer, 'Australia/Sydney')) * 60 + toMinute(toTimeZone(summer, 'Australia/Sydney')), toHour(toTimeZone(winter, 'Australia/Sydney')) * 60 + toMinute(toTimeZone(winter, 'Australia/Sydney')))
    ]) AS city_open
    FROM anchors
)
SELECT tupleElement(city_open, 1) AS city,
       formatDateTime(toDateTime(tupleElement(city_open, 2) * 60, 'UTC'), '%H:%i') AS local_open_us_summer,
       formatDateTime(toDateTime(tupleElement(city_open, 3) * 60, 'UTC'), '%H:%i') AS local_open_us_winter,
       round(((tupleElement(city_open, 2) + 1440 - 570) % 1440) / 60, 1) AS hours_ahead_us_summer,
       round(((tupleElement(city_open, 3) + 1440 - 570) % 1440) / 60, 1) AS hours_ahead_us_winter
FROM local_opens
ORDER BY hours_ahead_us_summer

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisUS Market Hours and Daylight Saving Time
London and Frankfurt distance from New York, session by session, March to April 2026 series 29×6 → London and Tokyo distance from New York, session by session, October to November 2025 series 25×6 → The New York open on two clocks: month-end sessions, August 2024 to July 2026 series 24×6 → The US trading day converted into ten local clocks: static illustrative reference, July 2026 table 10×6 → 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 → See all 2,170 queries →