How close SPY closes to a whole dollar strike, expiration Fridays vs every other session

SELECT
    distance_band,
    round(100 * expiry_sessions / sum(expiry_sessions) OVER (), 1) AS monthly_expiry_pct,
    round(100 * other_sessions  / sum(other_sessions)  OVER (), 1) AS other_session_pct,
    expiry_sessions                                                AS expiry_session_count
FROM
(
    SELECT
        multiIf(cents_from_strike <  5.0, 'within 5c',
                cents_from_strike < 15.0, '5c to 15c',
                cents_from_strike < 30.0, '15c to 30c',
                                          '30c to 50c') AS distance_band,
        min(cents_from_strike)                          AS band_floor,
        countIf(is_monthly_expiry = 1)                  AS expiry_sessions,
        countIf(is_monthly_expiry = 0)                  AS other_sessions
    FROM
    (
        SELECT
            round(100 * abs(toFloat64(close) - round(toFloat64(close))), 2)  AS cents_from_strike,
            (toDayOfWeek(date) = 5 AND toDayOfMonth(date) BETWEEN 15 AND 21) AS is_monthly_expiry
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SPY'
          AND date >= '2021-01-04'
          AND date <  today()
    )
    GROUP BY distance_band
)
ORDER BY band_floor