3,256 answered market questions

SELECT
    concat(
        formatDateTime(expiration_date, '%b %e'),
        ' $',
        toString(toUInt32(toFloat64(strike_price))),
        ' ',
        option_type
    )                                                               AS contract,
    round(contracts_traded / 1000, 1)                               AS volume_thousands,
    round(100 * contracts_traded / sum(contracts_traded) OVER (), 2) AS share_of_day_pct
FROM
(
    SELECT
        expiration_date,
        strike_price,
        option_type,
        sum(volume) AS contracts_traded
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date = '2026-06-16'
      AND volume > 0
    GROUP BY expiration_date, strike_price, option_type
)
ORDER BY volume_thousands DESC
LIMIT 12