1WITH raw as (
2select markets.title, count(*) as count_trades, round(sum(trades.price*trades.count)/1000000,1) as total_trades_usd
3from @kalshi.markets.market_trades trades
4INNER JOIN @kalshi.markets.markets markets ON (trades.market_ticker=markets.ticker)
5WHERE trades.created_time > now() - interval '7 days'
6GROUP BY ALL
7ORDER BY total_trades_usd DESC
8LIMIT 10
9)
10select title as market, count_trades as "# Trades", total_trades_usd as "USD (millions)"
11from raw
12order by total_trades_usd