1select strftime(trades.created_time, '%Y-%m') as trade_date, ROUND(sum(trades.price*trades.count)/1000000) as total_usd_millions
2from @kalshi.markets.market_trades trades
3WHERE trades.created_time > now() - interval '1 year' AND trades.created_time < now()::date
4GROUP BY ALL
5ORDER By 1