Share of the day's volume printed minute by minute into the US close, and the closing cross itself

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
    et_time,
    round(100 * sum(shares) / any(d.session_volume), 3) AS share_of_session_pct
FROM
(
    SELECT
        if(has(conditions, 8), '16:00',
           formatDateTime(toTimeZone(sip_timestamp, 'America/New_York'), '%H:%i')) AS et_time,
        toFloat64(size)                                                          AS shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-09-15 15:50:00', 'America/New_York')
      AND sip_timestamp <  toDateTime('2026-09-15 16:10:00', 'America/New_York')
      AND NOT hasAny(conditions, [15, 16, 38])
      AND (has(conditions, 8)
           OR sip_timestamp < toDateTime('2026-09-15 16:00:00', 'America/New_York'))
) AS m
CROSS JOIN
(
    SELECT toFloat64(sum(size)) AS session_volume
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-09-15 04:00:00', 'America/New_York')
      AND sip_timestamp <  toDateTime('2026-09-15 20:00:00', 'America/New_York')
      AND NOT hasAny(conditions, [15, 16, 38])
) AS d
GROUP BY et_time
ORDER BY et_time