NVDA trading volume, 20 sessions before vs 20 sessions from its 10-for-1 split (June 10, 2024)

WITH daily AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           sum(toFloat64(volume)) AS shares,
           sum(toFloat64(close) * toFloat64(volume)) AS dollars
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'NVDA'
      AND window_start >= '2024-05-08 00:00:00' AND window_start < '2024-07-12 00:00:00'
    GROUP BY d
),
ranked AS (
    SELECT d, shares, dollars,
           d >= toDate('2024-06-10') AS post,
           row_number() OVER (PARTITION BY d >= toDate('2024-06-10')
                              ORDER BY if(d < toDate('2024-06-10'), -toUInt32(d), toUInt32(d))) AS rn
    FROM daily
)
SELECT if(post = 0, 'Last 20 sessions before the split', 'First 20 sessions from the split') AS phase,
       count() AS sessions,
       round(avg(shares) / 1e6, 1) AS avg_daily_shares_millions,
       round(avg(dollars) / 1e9, 1) AS avg_daily_dollars_billions
FROM ranked
WHERE rn <= 20
GROUP BY phase, post
ORDER BY post