Query editor
SELECTdate_trunc('month', _date) AS month,SUM(CASE WHEN category = 'Commodities' AND report_ticker LIKE '%15M'THEN daily_volume ELSE 0 END) AS pyth_15m_contracts,SUM(daily_volume) AS all_price_contracts,SUM(CASE WHEN category = 'Commodities' AND report_ticker LIKE '%15M'THEN daily_volume ELSE 0 END) / SUM(daily_volume) AS pyth_shareFROM kalshi.market_reportWHERE _date >= DATE '2026-06-01'AND _date < DATE '2026-10-01'AND category IN ('Crypto', 'Commodities', 'Financials')GROUP BY 1ORDER BY 1