1select trades.created_time::date as trade_date, ROUND(sum(trades.price*trades.count)/1000) as total_usd_thousands
2from @kalshi.markets.market_trades trades
3INNER JOIN @kalshi.markets.markets markets ON (trades.market_ticker=markets.ticker)
4WHERE trades.created_time > now() - interval '7 days' AND trades.created_time < now()::date
5      AND markets.title = 'Who will be the top Spotify artist this year?'
6GROUP BY ALL
7ORDER By 1