aapl_open_minute_trace

SELECT
    toString(d)                                                AS session,
    round(100 * sumIf(v, et_min = 570) / sum(v), 2)            AS opening_minute_pct,
    round(100 * sumIf(v, et_min = 960) / sum(v), 2)            AS closing_minute_pct,
    concat(monthName(d), ' ', toString(toDayOfMonth(d)))       AS session_label
FROM
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))        AS d,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_min,
        toFloat64(volume)                                           AS v
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-08-03 00:00:00'
      AND window_start <  '2026-09-01 00:00:00'
)
WHERE d BETWEEN '2026-08-03' AND '2026-08-31'
  AND et_min BETWEEN 570 AND 960
GROUP BY d
HAVING sum(v) > 0
ORDER BY d