One at-the-money call settled two ways: the ten widest splits since January 2024

WITH sessions AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           toFloat64(argMin(open, window_start)) AS first_print,
           toFloat64(argMax(close, window_start)) AS last_print
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2023-12-01') AND toDate('2026-07-31')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date
),
sequenced AS (
    SELECT session_date,
           first_print,
           last_print,
           any(last_print) OVER (ORDER BY session_date ASC
                                 ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_close
    FROM sessions
),
expirations AS (
    SELECT session_date,
           first_print,
           last_print,
           round(prior_close, 0) AS strike,
           abs(first_print / prior_close - 1) * 100 AS gap_abs_raw
    FROM sequenced
    WHERE prior_close > 0
      AND session_date >= toDate('2024-01-01')
      AND toDayOfWeek(session_date) = 5
      AND toDayOfMonth(session_date) BETWEEN 15 AND 21
)
SELECT formatDateTime(session_date, '%b %e, %Y') AS expiry_label,
       round(gap_abs_raw, 2) AS gap_abs_pct,
       round(greatest(first_print - strike, 0), 2) AS am_settlement_usd,
       round(greatest(last_print - strike, 0), 2) AS pm_settlement_usd,
       round(abs(greatest(last_print - strike, 0) - greatest(first_print - strike, 0)), 2) AS settlement_spread_usd
FROM expirations
ORDER BY settlement_spread_usd DESC
LIMIT 10