zegar_marzec

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
    toString(sesja)                                              AS date,
    formatDateTime(min(window_start), '%H:%i', 'Europe/Warsaw')  AS otwarcie_pl,
    round(min(min_pl) / 60, 2)                                   AS otwarcie_pl_h,
    round((max(min_pl) + 1) / 60, 2)                             AS zamkniecie_pl_h,
    max(roznica)                                                 AS roznica_h
FROM
(
    SELECT
        window_start,
        toDate(window_start, 'America/New_York')                                    AS sesja,
        toHour(toTimeZone(window_start, 'Europe/Warsaw')) * 60
          + toMinute(toTimeZone(window_start, 'Europe/Warsaw'))                     AS min_pl,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York'))                  AS min_et,
        toInt16((toHour(toTimeZone(window_start, 'Europe/Warsaw'))
                 - toHour(toTimeZone(window_start, 'America/New_York')) + 24) % 24) AS roznica
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-03-02 00:00:00')
      AND window_start <  toDateTime('2026-04-04 00:00:00')
)
WHERE min_et >= 570 AND min_et < 960
GROUP BY sesja
ORDER BY sesja