STRASMORE/EXPLORE 2,401 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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

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
⌘/Ctrl + Enter
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 → Sydney open and close of the first US session each week series 57×5 → Upcoming US market closures, in Sydney date and time series 12×6 → See all 2,401 queries →