KO and AAPL closes across the July 2026 holiday week, with settlement dates

SELECT
    toString(w.date)                                                                                                 AS trade_date,
    concat(formatDateTime(w.date, '%a'), ', ', formatDateTime(w.date, '%b'), ' ', toString(toDayOfMonth(w.date)))     AS traded_on,
    round(toFloat64(w.ko_close), 2)                                                                                  AS ko_close,
    round(toFloat64(w.aapl_close), 2)                                                                                AS aapl_close,
    concat(formatDateTime(w.next_open, '%a'), ', ', formatDateTime(w.next_open, '%b'), ' ', toString(toDayOfMonth(w.next_open))) AS settles_on
FROM
(
    SELECT
        date,
        ko_close,
        aapl_close,
        leadInFrame(date) OVER (ORDER BY date ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) AS next_open
    FROM
    (
        SELECT
            date,
            maxIf(close, ticker = 'KO')   AS ko_close,
            maxIf(close, ticker = 'AAPL') AS aapl_close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('KO', 'AAPL')
          AND date BETWEEN '2026-06-29' AND '2026-07-14'
        GROUP BY date
        HAVING countIf(ticker = 'KO') > 0
           AND countIf(ticker = 'AAPL') > 0
    )
) AS w
WHERE w.date <= '2026-07-10'
ORDER BY w.date