SPY daily bar volume vs. the regular-session slice (trailing month)

SELECT
    toString(daily.date)                                                                AS session_date,
    concat(formatDateTime(daily.date, '%b'), ' ', toString(toDayOfMonth(daily.date)))   AS session_label,
    round(toFloat64(daily.day_volume) / 1e6, 1)                                         AS daily_bar_millions,
    round(toFloat64(intraday.regular_volume) / 1e6, 1)                                  AS regular_session_millions,
    round(100 * (toFloat64(daily.day_volume) - toFloat64(intraday.regular_volume))
              / toFloat64(daily.day_volume), 2)                                         AS outside_regular_pct
FROM
(
    SELECT
        date,
        max(volume) AS day_volume
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= today() - 30
      AND date <  today() - 2
    GROUP BY date
) AS daily
INNER JOIN
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
        sum(volume)                                          AS regular_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 30
      AND window_start <  today() - 2
      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 et_date
) AS intraday ON intraday.et_date = daily.date
ORDER BY daily.date