Query: Kalshi totals - TOP traded markets last 7 days by Paulo Sousa

Loading chart...

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

market	# Trades	USD (millions)
yes James Wood: 1+,yes Aaron Judge: 1+,yes Yordan Alvarez: 1+	23	null
yes New York Y,yes Pittsburgh wins by over 1.5 runs,yes Tampa Bay wins by over 1.5 runs	4	null
yes Brandon Lowe: 1+,yes Yordan Alvarez: 1+,yes Shohei Ohtani: 1+	1	null
yes Arizona,yes Texas,yes Pittsburgh,yes Milwaukee,yes New York Y,yes Tampa Bay,yes Los Angeles D,yes Atlanta,yes San Diego	1	null
yes Cade Cunningham: 25+,yes Desmond Bane: 15+,yes Paolo Banchero: 25+,yes Jalen Duren: 6+	1	null
yes Pittsburgh,yes Milwaukee,yes New York Y,yes Boston,yes Tampa Bay,yes Los Angeles D,yes Atlanta,yes New York M	1	null
Jose Altuve: 1+ home runs?	37	null
yes Austin Reaves: 20+,yes LeBron James: 30+	6	null
yes Pittsburgh,yes Miami,yes Toronto,yes Los Angeles A,yes Cleveland,yes San Diego,yes Orlando,yes Houston,yes BUF Sabres,yes MTL Canadiens,yes UTA Mammoth	1	null
yes Brandon Nimmo: 1+,yes Sal Stewart: 1+,yes Ben Rice: 1+,yes Junior Caminero: 1+	1	null

Query Result