istanbul_acilis

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 sessions AS
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
        min(window_start)                                    AS first_bar_utc
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2025-10-06 00:00:00')
      AND window_start <  toDateTime('2026-02-28 00:00:00')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY session_date
)
SELECT
    toString(toMonday(session_date))                   AS week,
    formatDateTime(toMonday(session_date), '%d.%m.%Y') AS week_label,
    count()                                            AS sessions,
    min(formatDateTime(toTimeZone(first_bar_utc, 'Europe/Istanbul'), '%H:%i'))   AS istanbul_open_label,
    min(formatDateTime(toTimeZone(first_bar_utc, 'America/New_York'), '%H:%i'))  AS et_open_label,
    round(avg(toHour(toTimeZone(first_bar_utc, 'Europe/Istanbul')) * 60
              + toMinute(toTimeZone(first_bar_utc, 'Europe/Istanbul'))) / 60, 2) AS istanbul_open_hour
FROM sessions
GROUP BY week, week_label
ORDER BY week