Query editor
WITH mapping AS (SELECT DISTINCT report_ticker, categoryFROM kalshi.market_report)SELECTCAST(a.date AS DATE) AS trade_day,AVG(a.contracts_traded) AS avg_trade_sizeFROM kalshi.trade_report aLEFT JOIN mapping mON a.report_ticker = m.report_tickerWHERE CAST(a.date AS DATE) >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1ORDER BY 1;