How big a one-day move usually is, sessions since 2016

SELECT
    move_bucket,
    round(count() * 100.0 / sum(count()) OVER (), 1) AS frequency_pct
FROM
(
    SELECT
        multiIf(move_pct < 0.25, 'under 0.25%',
                move_pct < 0.50, '0.25% to 0.50%',
                move_pct < 1.00, '0.50% to 1.00%',
                move_pct < 2.00, '1.00% to 2.00%',
                'over 2.00%') AS move_bucket,
        move_pct
    FROM
    (
        SELECT abs(close_px / prior_close - 1) * 100 AS move_pct
        FROM
        (
            SELECT
                date,
                max(toFloat64(close)) AS close_px,
                lagInFrame(max(toFloat64(close)))
                    OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_close
            FROM global_markets.stocks_daily_aggs
            WHERE ticker = 'SPY'
              AND date >= '2016-01-01'
              AND date <  today() - 2
            GROUP BY date
        )
        WHERE prior_close > 0
    )
)
GROUP BY move_bucket
ORDER BY min(move_pct) ASC