1select trades.created_time::date 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 '7 days' AND trades.created_time < now()::date
4GROUP BY ALL
5ORDER By 1