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
2026-02-25 17:09:09.837567+00	CPI year-over-year in May 2026?	Exactly 2.8%	$120,000	0.5	240000	no
2026-02-25 15:52:09.040352+00	Will Graham Platner be the Democratic nominee for the Senate in Maine?	Graham Platner	$79,362	0.8	99203	yes
2026-02-01 16:14:41.119088+00	Will Democrats win the House in 2026?	Democratic Party	$78,000	0.78	100000	yes
2026-02-25 07:47:40.076453+00	CPI core year-over-year in Jun 2026?	Exactly 2.3%	$75,000	0.5	150000	no
2026-02-26 23:01:17.452553+00	Who will win MVP?	Shai Gilgeous-Alexander	$56,000	0.56	100000	yes
2026-02-21 15:09:10.292131+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$55,869	0.75	74492	yes
2026-02-28 05:32:30.413683+00	Will Aubry Bracco win Survivor Season 50?	Aubry Bracco	$45,500	0.91	50000	yes
2026-02-25 16:51:48.504519+00	CPI year-over-year in May 2026?	Exactly 2.9%	$45,000	0.5	90000	no
2026-02-26 23:02:19.321121+00	Will Paramount's takeover of Warner Brothers succeed Before July 2027?	Paramount	$43,409	0.98	44295	yes
2026-03-04 20:12:38.89794+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$42,000	0.84	50000	yes
2026-03-09 15:18:54.950015+00	Who will win MVP?	Shai Gilgeous-Alexander	$40,000	0.8	50000	yes
2026-02-24 12:24:18.195038+00	CPI year-over-year in May 2026?	Exactly 2.1%	$40,000	0.5	80000	no
2026-02-24 13:06:54.198764+00	CPI year-over-year in May 2026?	Exactly 2.0%	$39,500	0.5	79000	no
2026-01-08 19:56:35.229869+00	Will Arsenal win the English Premier League?	Arsenal	$38,985	0.78	49981	no
2026-02-15 20:50:32.912484+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	$37,830	0.39	96999	yes
2026-02-25 16:48:25.707943+00	CPI year-over-year in May 2026?	Exactly 3.0%	$37,500	0.5	75000	no
2026-02-11 18:26:22.473967+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$35,402	0.71	49862	yes
2026-01-17 17:59:08.771583+00	Will Democrats win the House in 2026?	Democratic Party	$35,278	0.77	45816	yes
2026-01-30 18:26:12.223492+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$34,998	0.35	99993	yes
2026-03-05 22:55:27.412978+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$34,096	0.83	41079	no
2026-03-04 19:40:16.588085+00	Will Arsenal win the English Premier League?	Arsenal	$34,000	0.68	50000	yes
2026-02-07 23:57:18.583206+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$33,097	0.6	55161	yes
2026-01-16 21:14:45.695406+00	Will Barcelona win the La Liga?	Barcelona	$33,000	0.66	50000	yes
2026-01-15 15:04:53.317388+00	Will Barcelona win the La Liga?	Barcelona	$32,999	0.66	49999	yes
2026-02-19 00:51:08.525929+00	Will Democrats win the House in 2026?	Democratic Party	$32,184	0.78	41261	yes
2025-12-22 14:19:23.082111+00	Will Barcelona win the La Liga?	Barcelona	$30,000	0.6	50000	yes
2026-02-24 16:15:04.418496+00	Will the U.S. confirm that aliens exist before 2027?	Before 2027	$29,548	0.26	113648	yes
2026-02-25 13:26:26.953619+00	CPI core year-over-year in Jun 2026?	Exactly 3.6%	$29,450	0.95	31000	yes
2026-02-24 01:21:15.502056+00	Will the U.S. confirm that aliens exist before 2027?	Before 2027	$27,500	0.55	50000	yes
2026-02-25 10:59:50.45791+00	CPI year-over-year in May 2026?	Exactly 3.1%	$27,200	0.5	54399	yes
2026-02-15 20:24:52.379054+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	$25,652	0.38	67504	yes
2026-01-01 21:13:51.14726+00	Will J.D. Vance be the nominee for the Presidency for the Republican party?	J.D. Vance	$25,500	0.51	50000	yes
2025-12-27 01:10:01.244845+00	Who will win Rookie of the Year?	Cooper Flagg	$24,870	0.83	29964	yes
2025-11-07 19:24:43.406195+00	Will Inter win the Serie A?	Inter	$23,500	0.47	50000	yes
2026-02-24 10:47:56.59961+00	Will Las Vegas make the 1st Overall Pick in the 2026 Pro Football Draft?	Las Vegas	$23,139	0.97	23855	no
2026-01-10 03:04:50.533766+00	Will Republicans win the House in 2026?	Republican Party	$23,124	0.25	92495	yes
2025-12-24 16:01:43.499527+00	Will Graham Platner be the Democratic nominee for the Senate in Maine?	Graham Platner	$23,017	0.58	39684	yes
2026-02-26 16:04:31.726289+00	CPI core year-over-year in Jul 2026?	Exactly 3.7%	$22,992	0.5	45985	yes
2026-02-23 18:24:59.734969+00	CPI month-over-month in Jun 2026?	Exactly -0.1%	$22,500	0.5	45000	yes
2026-02-25 15:45:40.695017+00	CPI core year-over-year in Jun 2026?	Exactly 3.5%	$22,492	0.5	44985	yes
2025-12-07 22:05:19.190705+00	Will Barcelona win the La Liga?	Barcelona	$22,410	0.55	40745	yes
2025-12-30 21:43:12.849402+00	Will Arsenal win the English Premier League?	Arsenal	$22,400	0.56	40000	yes
2025-12-30 21:43:02.061138+00	Will Arsenal win the English Premier League?	Arsenal	$22,400	0.56	40000	yes
2026-03-04 18:46:25.41701+00	Will Dem Nominee be James Talarico AND GOP Nominee be John Cornyn for Nov 2026?	Talarico vs. Cornyn	$22,387	0.9	24874	yes
2026-03-04 18:48:29.261865+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$22,310	0.89	25067	no
2026-03-04 19:53:15.774278+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$22,250	0.89	25000	no
2026-02-23 18:30:34.168449+00	CPI month-over-month in Jun 2026?	Exactly 0.0%	$22,000	0.5	44000	yes
2025-12-03 18:17:39.828868+00	Will Barcelona win the La Liga?	Barcelona	$22,000	0.44	50000	no
2025-12-04 11:27:58.122722+00	Will Barcelona win the La Liga?	Barcelona	$22,000	0.44	50000	no
2025-12-04 11:46:14.783288+00	Will Barcelona win the La Liga?	Barcelona	$22,000	0.44	50000	no
2025-12-04 00:48:11.315568+00	Will Barcelona win the La Liga?	Barcelona	$22,000	0.44	50000	no
2026-02-23 18:25:35.338725+00	CPI month-over-month in Jun 2026?	Exactly -0.1%	$21,998	0.5	43995	yes
2026-02-23 18:23:46.693913+00	CPI month-over-month in Jun 2026?	Exactly -0.2%	$21,985	0.5	43970	yes
2026-02-23 18:24:19.806739+00	CPI month-over-month in Jun 2026?	Exactly -0.2%	$21,982	0.5	43965	yes
2026-03-04 18:16:47.602591+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$21,600	0.72	30000	yes
2026-02-26 16:05:11.896399+00	CPI core year-over-year in Jul 2026?	Exactly 3.7%	$21,490	0.5	42980	yes
2026-02-26 01:53:55.425293+00	CPI core year-over-year in Jul 2026?	Exactly 2.5%	$21,238	0.5	42475	yes
2026-01-25 17:38:18.76025+00	Will Arsenal win the English Premier League?	Arsenal	$20,661	0.75	27548	no
2026-03-09 02:46:29.699888+00	Will House Control be Democratic AND Senate Control be Democratic for Feb 2027?	D-House, D-Senate	$20,350	0.44	46249	yes
2025-07-11 12:23:40.698+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	$20,202	0.51	39611	yes
2026-02-21 02:42:03.3928+00	CPI year-over-year in Jun 2026?	Exactly 2.5%	$20,000	0.5	40000	yes
2025-10-23 16:29:07.002523+00	Will the San Antonio win the 2026 Pro Basketball Finals?	San Antonio	$20,000	0.04	500000	yes
2026-02-21 02:49:28.275814+00	CPI year-over-year in Jun 2026?	Exactly 3.2%	$20,000	0.5	40000	yes
2026-02-20 04:16:52.213318+00	CPI year-over-year in Apr 2026?	Exactly 3.3%	$19,998	0.5	39995	yes
2026-02-19 20:16:29.105475+00	CPI month-over-month in Apr 2026?	Exactly 0.6%	$19,998	0.5	39995	yes
2026-02-21 02:49:58.147145+00	CPI year-over-year in Jun 2026?	Exactly 3.2%	$19,998	0.5	39995	yes
2026-02-20 14:12:16.038055+00	CPI year-over-year in Jun 2026?	Exactly 2.3%	$19,995	0.5	39990	yes
2026-02-17 08:05:53.072605+00	Will the maximum USD/BRL exchange rate reach 6.9999 by Dec 31, 2026?	7 or above	$19,995	0.5	39990	yes
2026-02-21 18:15:40.035548+00	CPI core month-over-month in May 2026?	Exactly -0.1%	$19,990	0.5	39980	yes
2026-02-21 18:16:08.150994+00	CPI core month-over-month in May 2026?	Exactly -0.1%	$19,988	0.5	39975	yes
2026-02-26 14:55:50.783761+00	Will Democrats win the House in 2026?	Democratic Party	$19,751	0.82	24086	yes
2026-02-24 15:55:43.610467+00	Will Democrats win the House in 2026?	Democratic Party	$19,694	0.82	24017	yes
2025-11-23 13:56:05.129617+00	Will Graham Platner be the Democratic nominee for the Senate in Maine?	Graham Platner	$19,412	0.67	28973	yes
2026-03-04 19:37:03.485502+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$19,318	0.92	20998	yes
2025-10-29 22:18:32.102739+00	Will Inter win the Serie A?	Inter	$19,000	0.38	50000	yes
2026-02-21 02:42:36.919044+00	CPI year-over-year in Jun 2026?	Exactly 2.5%	$18,998	0.5	37995	yes
2026-02-21 02:41:07.037427+00	CPI year-over-year in Jun 2026?	Exactly 3.4%	$18,982	0.5	37965	yes
2026-03-04 18:20:07.947383+00	Will Dem Nominee be James Talarico AND GOP Nominee be John Cornyn for Nov 2026?	Talarico vs. Cornyn	$18,668	0.79	23630	yes
2026-02-17 19:56:59.681+00	Will Janet Mills be the Democratic nominee for the Senate in Maine?	Janet Mills	$18,617	0.34	54757	no
2026-02-26 20:08:48.499092+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$18,613	0.77	24173	yes
2026-03-10 08:12:51.504791+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	$18,613	0.38	48981	yes
2026-03-04 19:34:40.63202+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$18,200	0.91	20000	no
2026-03-04 19:00:10.833013+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$18,000	0.9	20000	yes
2026-02-25 15:44:55.308454+00	CPI core year-over-year in Jun 2026?	Exactly 3.5%	$17,995	0.5	35990	yes
2025-12-03 01:19:04.186754+00	Will Democrats win the House in 2026?	Democratic Party	$17,900	0.76	23552	yes
2025-09-14 21:50:55.452236+00	Which EPL teams will qualify for the Champions League?	Chelsea	$17,750	0.71	25000	no
2025-09-13 19:41:29.664458+00	Which EPL teams will qualify for the Champions League?	Chelsea	$17,750	0.71	25000	no
2026-03-04 19:00:06.638521+00	Will Dem Nominee be James Talarico AND GOP Nominee be John Cornyn for Nov 2026?	Talarico vs. Cornyn	$17,726	0.92	19267	yes
2026-02-24 00:45:57.112648+00	Will the U.S. confirm that aliens exist before 2027?	Before 2027	$17,527	0.21	83463	yes
2026-02-04 16:08:53.215995+00	Who will win Defensive Player of the Year?	Victor Wembanyama	$17,500	0.5	35000	yes
2026-02-17 08:06:53.180527+00	Will the maximum USD/BRL exchange rate reach 6.7499 by Dec 31, 2026?	6.75 or above	$17,500	0.5	35000	yes
2026-01-23 13:49:03.145001+00	Will Democrats win the House in 2026?	Democratic Party	$17,335	0.77	22513	yes
2026-03-04 18:48:07.367816+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	$17,307	0.89	19446	yes
2026-02-21 02:51:50.24129+00	CPI year-over-year in Jun 2026?	Exactly 2.4%	$17,250	0.5	34500	yes
2026-02-19 01:31:47.8562+00	Who will win Most Improved Player?	Deni Avdija	$16,986	0.56	30332	yes
2025-11-07 06:48:35.447255+00	Will Graham Platner be the Democratic nominee for the Senate in Maine?	Graham Platner	$16,795	0.5	33590	yes
2026-03-02 23:20:34.330506+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	$16,600	0.83	20000	no
2025-09-20 16:39:34.629553+00	Which EPL teams will qualify for the Champions League?	Chelsea	$16,500	0.66	25000	no
2025-10-24 17:58:14.8609+00	Will Inter win the Serie A?	Inter	$16,500	0.33	50000	yes
2026-02-25 17:52:36.971749+00	CPI year-over-year in May 2026?	Exactly 2.7%	$16,204	0.9	18005	yes

Query Result