How often the close finished above the 3:50 p.m. price, July 2026 sessions

SELECT
    d.sym AS ticker,
    round(100 * countIf(d.official_close > m.px_1550) / count(), 1)                       AS pct_closed_higher,
    round(100 * countIf(abs(d.official_close / m.px_1550 - 1) * 10000 > 10) / count(), 1) AS pct_moved_over_10bps
FROM
(
    SELECT
        ticker                AS sym,
        date                  AS session_date,
        max(toFloat64(close)) AS official_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('JNJ', 'JPM', 'KO', 'PG', 'WMT', 'XOM')
      AND date >= '2026-07-01'
      AND date <  '2026-08-01'
    GROUP BY sym, session_date
) AS d
INNER JOIN
(
    SELECT
        ticker                                               AS sym,
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
        max(toFloat64(close))                                AS px_1550
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('JNJ', 'JPM', 'KO', 'PG', 'WMT', 'XOM')
      AND window_start >= '2026-07-01'
      AND window_start <  '2026-08-01'
      AND toHour(toTimeZone(window_start, 'America/New_York'))   = 15
      AND toMinute(toTimeZone(window_start, 'America/New_York')) = 50
    GROUP BY sym, session_date
) AS m ON m.sym = d.sym AND m.session_date = d.session_date
GROUP BY d.sym
ORDER BY pct_closed_higher DESC