How far the Friday close lands from the nearest whole dollar

WITH friday_closes AS
(
    SELECT
        ticker,
        date                                                     AS friday_session,
        round(abs(toFloat64(close) - round(toFloat64(close))), 2) AS gap_to_round_number
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'AMD')
      AND toDayOfWeek(date) = 5
      AND date >= '2025-01-01'
      AND date <  '2026-08-01'
)
SELECT
    concat(toString(band_floor_cents), 'c to ', toString(band_floor_cents + 5), 'c') AS gap_to_nearest_round_number,
    count()                                                                         AS expiration_day_count,
    round(100 * count() / (SELECT count() FROM friday_closes), 1)                   AS share_of_days_pct
FROM
(
    SELECT least(toUInt16(floor(gap_to_round_number * 20) * 5), 45) AS band_floor_cents
    FROM friday_closes
)
GROUP BY band_floor_cents
ORDER BY band_floor_cents