1select trades.created_time as "Timestamp", markets.title as "Market", markets.yes_sub_title as "Market - Subtitle", format('${:,.0f}', price * count) as "Cost (USD)", trades.* exclude (trades.created_time, trades.trade_id, trades.market_ticker, trades.yes_price, trades.no_price, trades.yes_price_dollars, trades.no_price_dollars)
2from @kalshi.markets.market_trades trades
3     INNER JOIN @kalshi.markets.markets markets ON (trades.market_ticker=markets.ticker)
4ORDER By price * count DESC
5limit 100