dst_shift

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 buckets AS
(
    SELECT
        toStartOfInterval(window_start, INTERVAL 30 MINUTE) AS bucket,
        sum(volume)                                         AS bucket_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2025-12-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
    GROUP BY bucket
),
monthly AS
(
    SELECT
        toStartOfMonth(bucket)        AS month_start,
        argMax(bucket, bucket_volume) AS top_bucket,
        max(bucket_volume)            AS top_volume
    FROM buckets
    GROUP BY month_start
)
SELECT
    formatDateTime(month_start, '%Y-%m')                                AS month,
    formatDateTime(month_start, '%b %Y')                                AS month_label,
    formatDateTime(toTimeZone(top_bucket, 'Africa/Lagos'), '%H:%i')     AS busiest_30min_wat,
    formatDateTime(toTimeZone(top_bucket, 'America/New_York'), '%H:%i') AS busiest_30min_et,
    modulo(toHour(toTimeZone(top_bucket, 'Africa/Lagos'))
         - toHour(toTimeZone(top_bucket, 'America/New_York')) + 24, 24) AS lagos_minus_ny_hours
FROM monthly
ORDER BY month_start