How close Friday closes land to a whole-dollar strike: seven names, 2023 to July 2026

WITH friday_bars AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS session,
           window_start,
           toFloat64(close) AS px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'NVDA', 'JNJ', 'CVX', 'KO')
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2023-01-02')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-31')
      AND toDayOfWeek(toDate(toTimeZone(window_start, 'America/New_York'))) = 5
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
),
friday_closes AS (
    SELECT ticker,
           session,
           argMax(px, window_start) AS close_px,
           count() AS session_bars
    FROM friday_bars
    GROUP BY ticker, session
    HAVING session_bars > 300
),
distances AS (
    SELECT abs(close_px - round(close_px)) * 100 AS cents_from_strike
    FROM friday_closes
)
SELECT multiIf(cents_from_strike < 1, 'under 1 cent',
               cents_from_strike < 5, '1 to 5 cents',
               cents_from_strike < 10, '5 to 10 cents',
               cents_from_strike < 25, '10 to 25 cents',
               '25 to 50 cents') AS distance_band,
       count() AS closes_count,
       round(100 * count() / sum(count()) OVER (), 2) AS share_pct
FROM distances
GROUP BY distance_band
ORDER BY min(cents_from_strike)