volume_per_jam_wib

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 menit AS
(
    SELECT
        formatDateTime(toTimeZone(window_start, 'Asia/Jakarta'), '%H:00')     AS wib_label,
        formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:00') AS jam_et,
        toHour(toTimeZone(window_start, 'America/New_York'))                  AS urut_et,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York'))            AS et_minute,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2026-09-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
),
sesi AS
(
    SELECT *
    FROM menit
    WHERE et_minute >= 240
      AND et_minute <  1200
),
total AS
(
    SELECT sum(volume) AS semua
    FROM sesi
)
SELECT
    wib_label,
    jam_et,
    round(toFloat64(sum(volume)) / 1e6, 1)                         AS volume_juta_lembar,
    round(100 * toFloat64(sum(volume)) / toFloat64(any(semua)), 2) AS persen_volume
FROM sesi
CROSS JOIN total
GROUP BY wib_label, jam_et, urut_et
ORDER BY urut_et