Days when the New York open lands at 14:30 Frankfurt time (three-hour overlap), 2026 and 2027

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.

SELECT
    concat(toString(toDayOfMonth(min(day))), ' ', formatDateTime(min(day), '%b %Y')) AS first_day,
    concat(toString(toDayOfMonth(max(day))), ' ', formatDateTime(max(day), '%b %Y')) AS last_day,
    countIf(toDayOfWeek(day) <= 5)                                                   AS weekdays,
    any(ny_open_frankfurt)                                                           AS ny_open_frankfurt,
    any(xetra_close_new_york)                                                        AS xetra_close_new_york
FROM
(
    SELECT
        day,
        toDateTime(concat(toString(day), ' 09:30:00'), 'America/New_York')      AS ny_open,
        toDateTime(concat(toString(day), ' 17:30:00'), 'Europe/Berlin')         AS xetra_close,
        formatDateTime(toTimeZone(ny_open, 'Europe/Berlin'), '%H:%i')           AS ny_open_frankfurt,
        formatDateTime(toTimeZone(xetra_close, 'America/New_York'), '%H:%i')    AS xetra_close_new_york,
        intDiv(toUnixTimestamp(xetra_close) - toUnixTimestamp(ny_open), 3600)   AS overlap_hours
    FROM
    (
        SELECT toDate('2026-01-01') + arrayJoin(range(730)) AS day
    )
)
WHERE overlap_hours = 3
GROUP BY toYear(day), toMonth(day) < 7
ORDER BY min(day)