Traded volume across strikes, one AAPL expiry (Sep 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.

WITH busiest_expiry AS
(
    SELECT expiration_date
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date = '2026-09-16'
      AND days_to_expiry BETWEEN 20 AND 45
      AND volume > 0
    GROUP BY expiration_date
    ORDER BY sum(volume) DESC
    LIMIT 1
)
SELECT
    round(toFloat64(strike_price), 2)                            AS strike_price,
    sumIf(volume, startsWith(lower(toString(option_type)), 'c')) AS call_volume,
    sumIf(volume, startsWith(lower(toString(option_type)), 'p')) AS put_volume
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date = '2026-09-16'
  AND expiration_date IN (SELECT expiration_date FROM busiest_expiry)
  AND volume > 0
GROUP BY strike_price
ORDER BY strike_price