Net calls minus puts on AAPL, raw contracts and as a share of volume

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
    toString(month_start)                       AS month,
    formatDateTime(month_start, '%b %Y')        AS month_label,
    round(call_volume / 1000, 0)                AS call_contracts_thousands,
    round(put_volume / 1000, 0)                 AS put_contracts_thousands,
    round((call_volume - put_volume) / 1000, 0) AS net_contracts_thousands,
    round(100 * (call_volume - put_volume) / total_volume, 1) AS net_share_pct
FROM
(
    SELECT
        toStartOfMonth(date)                        AS month_start,
        sumIf(volume, option_type IN ('call', 'C')) AS call_volume,
        sumIf(volume, option_type IN ('put', 'P'))  AS put_volume,
        sum(volume)                                 AS total_volume
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= '2024-01-01'
      AND date <  '2026-07-01'
      AND iv_converged = 1
      AND volume > 0
    GROUP BY month_start
)
ORDER BY month_start