volume_por_hora

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 bars AS
(
    SELECT
        formatDateTime(toTimeZone(window_start, 'America/Sao_Paulo'), '%H:00') AS hora_brasilia,
        if(window_start < toDateTime('2025-11-01 00:00:00', 'UTC'), 'verão', 'padrão') AS regime,
        toFloat64(volume)                                                      AS vol,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York'))           AS et_minuto
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND (
              (window_start >= toDateTime('2025-10-01 00:00:00', 'UTC')
               AND window_start < toDateTime('2025-11-01 00:00:00', 'UTC'))
           OR (window_start >= toDateTime('2025-12-01 00:00:00', 'UTC')
               AND window_start < toDateTime('2026-01-01 02:00:00', 'UTC'))
          )
)
SELECT
    h.hora_brasilia                               AS hora_brasilia,
    round(100 * h.vol_verao  / t.total_verao,  2) AS pct_volume_outubro,
    round(100 * h.vol_padrao / t.total_padrao, 2) AS pct_volume_dezembro
FROM
(
    SELECT
        hora_brasilia,
        sumIf(vol, regime = 'verão')  AS vol_verao,
        sumIf(vol, regime = 'padrão') AS vol_padrao
    FROM bars
    WHERE et_minuto >= 240 AND et_minuto < 1200
    GROUP BY hora_brasilia
) AS h
CROSS JOIN
(
    SELECT
        sumIf(vol, regime = 'verão')  AS total_verao,
        sumIf(vol, regime = 'padrão') AS total_padrao
    FROM bars
    WHERE et_minuto >= 240 AND et_minuto < 1200
) AS t
ORDER BY h.hora_brasilia