Two definitions of one daily close, side by side

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(m.day)                                                    AS date,
    round(m.session_close, 2)                                          AS session_close,
    round(a.agg_close, 2)                                              AS daily_bar_close,
    round(10000 * (a.agg_close - m.session_close) / m.session_close, 1) AS close_spread_bps
FROM
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS day,
        toFloat64(argMax(close, window_start))               AS session_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-06-01 04:00:00'
      AND window_start <  '2026-07-01 04:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY day
) AS m
INNER JOIN
(
    SELECT
        date                  AS day,
        toFloat64(max(close)) AS agg_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2026-06-01'
      AND date <= '2026-06-30'
    GROUP BY day
) AS a ON a.day = m.day
ORDER BY date