2,358 answered market questions

SELECT
    ticker,
    round(100 * sumIf(v, et_min = 570) / sum(v), 2) AS opening_minute_pct,
    round(100 * sumIf(v, et_min = 750) / sum(v), 2) AS midday_minute_pct,
    round(100 * sumIf(v, et_min = 960) / sum(v), 2) AS closing_minute_pct
FROM
(
    SELECT
        ticker,
        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 IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'TSLA')
      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 ticker
HAVING sum(v) > 0
ORDER BY ticker