How AAPL option volume accumulated through one session (Jun 16, 2026)

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
    formatDateTime(bucket, '%H:%i')                          AS et_time,
    round(bucket_contracts / 1000, 1)                        AS volume_thousands,
    round(100 * cumulative_contracts / session_contracts, 1) AS cumulative_pct
FROM
(
    SELECT
        bucket,
        bucket_contracts,
        sum(bucket_contracts) OVER (ORDER BY bucket) AS cumulative_contracts,
        sum(bucket_contracts) OVER ()                AS session_contracts
    FROM
    (
        SELECT
            toStartOfInterval(toTimeZone(sip_timestamp, 'America/New_York'), INTERVAL 30 MINUTE) AS bucket,
            sum(size)                                                                           AS bucket_contracts
        FROM global_markets.options_trades
        WHERE underlying_symbol = 'AAPL'
          AND sip_timestamp >= '2026-06-16 08:00:00'
          AND sip_timestamp <  '2026-06-17 04:00:00'
        GROUP BY bucket
    )
)
ORDER BY et_time