SPY option prints per half hour, May 15, 2025 (ET)

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,
    print_count,
    formatReadableQuantity(print_count)       AS prints_label,
    cumulative_prints,
    formatReadableQuantity(cumulative_prints) AS cumulative_label
FROM
(
    SELECT
        et_time,
        print_count,
        sum(print_count) OVER (ORDER BY et_time) AS cumulative_prints
    FROM
    (
        SELECT
            formatDateTime(toStartOfInterval(toTimeZone(sip_timestamp, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
            count()                                                                                                          AS print_count
        FROM global_markets.options_trades
        WHERE underlying_symbol = 'SPY'
          AND sip_timestamp >= '2025-05-15 00:00:00'
          AND sip_timestamp <  '2025-05-16 00:00:00'
        GROUP BY et_time
    )
)
ORDER BY et_time