The ten busiest option contracts of July 6, 2026

SELECT
    contract,
    contracts_traded,
    trades,
    toUInt8(min(expires_july_6) OVER ()) AS all_ten_expire_july_6,
    toUInt8(min(root_is_spy_or_qqq) OVER ()) AS all_ten_spy_or_qqq
FROM (
    SELECT
        concat(substring(ticker, 3, length(ticker) - 17), ' $',
               toString(round(toFloat64(toUInt32OrZero(substring(ticker, length(ticker) - 7, 8))) / 1000, 2)),
               if(substring(ticker, length(ticker) - 8, 1) = 'P', ' put', ' call'),
               ', expires 20', substring(ticker, length(ticker) - 14, 2), '-', substring(ticker, length(ticker) - 12, 2), '-', substring(ticker, length(ticker) - 10, 2)) AS contract,
        toUInt64(sum(volume)) AS contracts_traded,
        toUInt64(sum(transactions)) AS trades,
        substring(ticker, length(ticker) - 14, 6) = '260706' AS expires_july_6,
        substring(ticker, 3, length(ticker) - 17) IN ('SPY', 'QQQ') AS root_is_spy_or_qqq
    FROM global_markets.options_minute_aggs
    WHERE window_start >= '2026-07-06 00:00:00' AND window_start < '2026-07-07 00:00:00'
      AND match(substring(ticker, 3, length(ticker) - 17), '^[A-Z]+$')
      AND substring(ticker, 3, length(ticker) - 17) NOT IN ('SPCX')
    GROUP BY ticker
    ORDER BY contracts_traded DESC, ticker ASC
    LIMIT 10
)
ORDER BY contracts_traded DESC, contract ASC