AAPL's final half hour on its tightest monthly expiration close since 2025

WITH pin_day AS
(
    SELECT
        date                    AS session_day,
        round(toFloat64(close)) AS strike
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2025-01-01'
      AND date <  '2026-08-01'
      AND toDayOfWeek(date) = 5
      AND toDayOfMonth(date) BETWEEN 15 AND 21
    ORDER BY abs(toFloat64(close) - round(toFloat64(close))) ASC
    LIMIT 1
)
SELECT
    formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i') AS et_time,
    round(toFloat64(close), 2)                                           AS aapl_last,
    (SELECT strike FROM pin_day)                                         AS strike_line,
    round(abs(toFloat64(close) - (SELECT strike FROM pin_day)), 2)       AS gap_spread,
    formatDateTime((SELECT session_day FROM pin_day), '%b %e, %Y')       AS expiry_label
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'AAPL'
  AND window_start >= '2025-01-01'
  AND window_start <  '2026-08-01'
  AND toDate(toTimeZone(window_start, 'America/New_York')) = (SELECT session_day FROM pin_day)
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 930
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
ORDER BY window_start