Query: Kalshi Largest Notional Trades by Paulo Sousa

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

Timestamp	Market	Market - Subtitle	Cost (USD)	price	count	taker_side
2025-11-05 02:23:33.58321+00	Will a representative of the Democratic party win the NYC Mayor race in 2025?	Zohran Mamdani	$3,096,545	0.99	3127823	yes
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$2,613,933	0.97	2694776	no
2024-12-05 23:46:33.33961+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$2,205,103	0.99	2227377	no
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$1,342,600	0.98	1370000	yes
2024-11-15 20:58:36.735236+00	Will the Republican party win the popular vote?	Donald Trump	$1,316,367	0.98	1343232	yes
2024-11-15 20:58:36.735236+00	Will the Republican party win the popular vote?	Donald Trump	$1,171,837	0.98	1195752	yes
2024-11-19 14:51:37.648906+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$990,000	0.99	1000000	yes
2024-12-05 23:46:33.33961+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$987,647	0.99	997623	no
2025-01-01 04:22:12.548783+00	Will Democratics win the Senate race in Arizona?	Ruben Gallego	$987,462	0.99	997436	no
2024-12-05 23:11:20.934583+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$985,830	0.99	995788	yes
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$980,000	0.98	1000000	yes
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$980,000	0.98	1000000	yes
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$980,000	0.98	1000000	yes
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$980,000	0.98	1000000	yes
2024-11-15 20:58:36.735236+00	Will the Republican party win the popular vote?	Donald Trump	$980,000	0.98	1000000	yes
2024-11-15 20:58:36.735236+00	Will the Republican party win the popular vote?	Donald Trump	$980,000	0.98	1000000	yes
2025-11-08 23:04:19.281209+00	Louisiana Tech at Delaware Winner?	Louisiana Tech	$949,053	0.99	958639	no
2024-12-23 14:52:08.595337+00	Will the popular vote margin of victory for be between -1.00 and -1.99?	Trump by 1-1.99%	$792,000	0.99	800000	no
2024-11-18 17:56:16.384923+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$786,347	0.98	802395	yes
2025-11-07 04:02:48.730914+00	Georgia Southern at Appalachian St. Winner?	Georgia Southern	$670,533	0.99	677306	no
2025-01-01 04:21:32.74864+00	Will Democratics win the Senate race in Arizona?	Ruben Gallego	$653,151	0.99	659748	no
2024-11-08 01:44:58.155951+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$625,073	0.97	644405	no
2025-11-07 04:01:20.371699+00	Georgia Southern at Appalachian St. Winner?	Georgia Southern	$619,113	0.99	625367	no
2024-11-14 13:00:14.728532+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$604,124	0.97	622808	no
2024-11-14 13:20:35.63905+00	Will the Republican party win the popular vote?	Donald Trump	$580,123	0.98	591962	yes
2025-11-05 02:23:33.58321+00	Will a representative of the Democratic party win the NYC Mayor race in 2025?	Zohran Mamdani	$554,382	0.99	559982	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2025-02-10 02:18:52.328487+00	Will the Philadelphia Eagles win the Super Bowl?	Philadelphia	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-22 03:06:48.708461+00	Will Democratics win the Senate race in Arizona?	Ruben Gallego	$495,000	0.99	500000	no
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2025-11-05 02:23:33.58321+00	Will a representative of the Democratic party win the NYC Mayor race in 2025?	Zohran Mamdani	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2025-01-01 04:46:48.694599+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	no
2024-11-19 14:51:37.648906+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2024-11-19 14:51:37.648906+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$495,000	0.99	500000	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$495,000	0.99	500000	yes
2025-11-06 16:00:57.441782+00	Mercyhurst at Loyola Chicago Winner?	Loyola Chicago	$490,000	0.98	500000	no
2025-11-11 13:48:09.876251+00	Will the federal government shut down for fewer than 92 days?	Yes	$490,000	0.98	500000	yes
2025-11-08 20:36:54.568285+00	Indiana at Penn St. Winner?	Indiana	$490,000	0.98	500000	yes
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$485,000	0.97	500000	no
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$485,000	0.97	500000	no
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$485,000	0.97	500000	no
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$485,000	0.97	500000	no
2024-11-07 02:43:50.932126+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$471,380	0.98	481000	yes
2024-11-04 18:44:35.831925+00	Will Kamala Harris or another Democrat win the Presidency?	Kamala Harris	$460,000	0.46	1000000	yes
2024-11-13 16:41:40.835852+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$456,944	0.97	471076	no
2025-07-04 15:32:35.75339+00	Will the Joey Chestnut win the Nathan's Hot Dog Eating Contest?	Joey Chestnut	$454,058	0.95	477956	yes
2024-11-06 03:34:50.445306+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$432,870	0.98	441704	yes
2024-11-04 18:44:35.831925+00	Will Kamala Harris or another Democrat win the Presidency?	Kamala Harris	$428,476	0.46	931470	yes
2024-11-14 14:59:43.944131+00	Will the Republican party win Florida in the presidential election?	Donald Trump	$423,215	0.98	431852	no
2024-11-04 15:47:07.456296+00	Will Kamala Harris or another Democrat win the Presidency?	Kamala Harris	$420,000	0.42	1000000	no
2025-11-09 06:26:21.935907+00	Sam Houston at Oregon St. Winner?	Sam Houston	$415,146	0.99	419339	no
2024-12-23 14:40:45.864096+00	Will the popular vote margin of victory for be between 1.25 and 1.49?	Trump by 1.25-1.49%	$412,413	0.99	416579	no
2025-02-10 02:18:53.031285+00	Will the Philadelphia Eagles win the Super Bowl?	Philadelphia	$402,070	0.99	406131	yes
2024-11-01 20:12:37.854008+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$397,803	0.55	723278	no
2024-11-06 05:43:17.925151+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$396,000	0.99	400000	yes
2025-12-04 04:47:58.175865+00	Will d4vd be the #1 rank on Google’s Year in Search 2025 Global – People?	d4vd	$396,000	0.99	400000	no
2024-11-19 14:53:54.629638+00	Will the Republican party win Michigan in the presidential election?	Donald Trump	$396,000	0.99	400000	yes
2024-11-06 13:09:00.534539+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$392,752	0.99	396719	yes
2025-12-02 02:58:36.705852+00	New York G at New England Winner?	New England	$392,000	0.98	400000	no
2024-11-19 14:53:54.629638+00	Will the Republican party win Michigan in the presidential election?	Donald Trump	$380,655	0.99	384500	yes
2024-11-04 17:31:05.144936+00	Will Kamala Harris or another Democrat win the Presidency?	Kamala Harris	$372,153	0.47	791815	yes
2024-11-14 13:20:35.63905+00	Will the Republican party win the popular vote?	Donald Trump	$361,859	0.98	369244	yes
2025-12-10 16:12:35.871457+00	Will the Federal Reserve Cut rates by 25bps at their December 2025 meeting?	Cut 25bps	$359,496	0.98	366833	yes
2024-11-26 14:13:47.329164+00	Will the Republican party win the popular vote?	Donald Trump	$356,400	0.99	360000	yes
2025-07-04 15:11:10.27622+00	Will the Joey Chestnut win the Nathan's Hot Dog Eating Contest?	Joey Chestnut	$350,446	0.93	376824	yes
2025-11-08 23:57:29.922581+00	Duke at UConn Winner?	UConn	$347,185	0.99	350692	no
2024-11-09 13:47:38.505627+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$343,876	0.98	350894	yes
2025-10-27 21:18:20.543179+00	Washington at Kansas City Winner?	Kansas City	$338,212	0.84	402633	yes
2025-11-05 02:23:33.58321+00	Will a representative of the Democratic party win the NYC Mayor race in 2025?	Zohran Mamdani	$334,786	0.99	338168	yes
2024-11-21 18:17:12.193549+00	Will the Republican party win the popular vote?	Donald Trump	$331,318	0.98	338080	no
2024-10-15 20:02:49.160268+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$330,000	0.55	600000	no
2024-11-07 23:50:33.513578+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$318,090	0.97	327928	no
2025-11-16 05:06:46.701025+00	San Francisco at Arizona Winner?	San Francisco	$315,000	0.63	500000	yes
2024-11-06 07:43:54.510707+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$309,545	0.98	315862	yes
2025-11-08 20:30:06.275629+00	Indiana at Penn St. Winner?	Indiana	$308,229	0.98	314519	no
2025-11-16 05:06:46.701025+00	San Francisco at Arizona Winner?	San Francisco	$305,567	0.63	485027	yes
2025-12-10 14:31:56.000771+00	Will the Federal Reserve Cut rates by 25bps at their December 2025 meeting?	Cut 25bps	$303,747	0.97	313141	yes
2024-11-15 03:16:36.133708+00	Will the Democratic party win New York in the presidential election?	Kamala Harris	$302,538	0.98	308712	no
2024-11-09 14:07:16.910877+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$301,350	0.98	307500	yes
2024-11-18 13:09:09.146878+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$300,000	0.98	306122	yes
2024-12-20 01:22:33.557976+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$297,000	0.99	300000	no
2024-11-19 15:11:16.208889+00	Will the Democratic party win New York in the presidential election?	Kamala Harris	$297,000	0.99	300000	yes
2025-12-04 04:47:58.175865+00	Will d4vd be the #1 rank on Google’s Year in Search 2025 Global – People?	d4vd	$297,000	0.99	300000	no
2024-11-19 14:53:54.629638+00	Will the Republican party win Michigan in the presidential election?	Donald Trump	$297,000	0.99	300000	yes
2025-11-05 02:23:33.58321+00	Will a representative of the Democratic party win the NYC Mayor race in 2025?	Zohran Mamdani	$297,000	0.99	300000	yes
2024-11-06 05:43:17.925151+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$297,000	0.99	300000	yes
2024-12-17 15:52:08.133095+00	Will the popular vote margin of victory for be between -1.00 and -1.99?	Trump by 1-1.99%	$297,000	0.99	300000	yes
2025-01-01 04:43:46.958+00	Will the Republican party win the popular vote?	Donald Trump	$297,000	0.99	300000	no
2024-11-06 13:27:48.537514+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$292,950	0.98	298929	yes
2025-02-10 02:17:04.313461+00	Will the Philadelphia Eagles win the Super Bowl?	Philadelphia	$291,995	0.98	297954	yes
2024-11-09 20:56:19.309298+00	Will Donald Trump or another Republican win the Presidency?	Donald Trump	$291,000	0.97	300000	no
2024-11-09 00:49:37.774302+00	Will the Republican party win Georgia in the presidential election?	Donald Trump	$289,589	0.98	295499	no
2024-11-20 13:30:14.845241+00	Will Democratics win the Senate race in Arizona?	Ruben Gallego	$287,100	0.99	290000	yes