rebalance_multiples

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 close_minute AS
(
    SELECT
        ticker,
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
        toFloat64(sum(volume))                               AS close_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'KO')
      AND window_start >= '2025-05-01'
      AND window_start <  '2026-06-29'
      AND toHour(toTimeZone(window_start, 'America/New_York'))   = 16
      AND toMinute(toTimeZone(window_start, 'America/New_York')) = 0
    GROUP BY ticker, session_date
),
ranked AS
(
    SELECT
        ticker,
        session_date,
        close_volume,
        row_number() OVER (PARTITION BY ticker ORDER BY session_date) AS n
    FROM close_minute
),
events AS
(
    SELECT
        ticker,
        close_volume,
        n,
        multiIf(session_date = '2025-06-27', 'Russell recon Jun-2025',
                session_date = '2025-12-19', 'S&P quarterly Dec-2025',
                session_date = '2026-03-20', 'S&P quarterly Mar-2026',
                                             'Russell recon Jun-2026') AS event
    FROM ranked
    WHERE session_date IN ('2025-06-27', '2025-12-19', '2026-03-20', '2026-06-26')
)
SELECT
    concat(e.ticker, ' ', e.event)                                             AS label,
    round(e.close_volume / 1e6, 2)                                             AS close_minute_shares_mm,
    round(quantileDeterministic(0.5)(b.close_volume, b.n) / 1e6, 2)            AS typical_close_shares_mm,
    round(e.close_volume / quantileDeterministic(0.5)(b.close_volume, b.n), 1) AS close_volume_multiple
FROM events AS e
INNER JOIN ranked AS b ON b.ticker = e.ticker
WHERE b.n >= e.n - 20
  AND b.n <= e.n - 1
GROUP BY e.ticker, e.event, e.close_volume
ORDER BY close_volume_multiple DESC