Query: Kalshi recent trades by Paulo Sousa

1select trades.created_time as "Timestamp", markets.title as "Market", markets.yes_sub_title as "Market - Subtitle", round(price * count,2) 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 trades.created_time DESC
5limit 100

Timestamp	Market	Market - Subtitle	Cost (USD)	price	count	taker_side
2026-03-18 16:44:02.095106+00	Will the Democratic party win the governorship in New York	Democratic party	null	null	null	no
2026-03-18 16:37:34.722094+00	Will NASA land a person on the Moon before 2027?	Before 2027	null	null	null	no
2026-03-18 16:36:08.355189+00	PS6 announced by 2026?	By 2026	null	null	null	yes
2026-03-18 16:33:55.935085+00	Will Democratics win the Senate race in Texas?	James Talarico	null	null	null	no
2026-03-18 16:33:15.733713+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	yes
2026-03-18 16:32:38.584241+00	Will Trump take back the Panama Canal?	During Trump's term	null	null	null	yes
2026-03-18 16:32:38.584241+00	Will Trump take back the Panama Canal?	During Trump's term	null	null	null	yes
2026-03-18 16:32:28.942528+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	yes
2026-03-18 16:31:04.233663+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	no
2026-03-18 16:30:20.414078+00	Will Republicans win the Senate race in Ohio?	Republican party	null	null	null	no
2026-03-18 16:30:07.884861+00	Will Henry Cavill be the next James Bond?	Henry Cavill	null	null	null	yes
2026-03-18 16:30:07.884861+00	Will Henry Cavill be the next James Bond?	Henry Cavill	null	null	null	yes
2026-03-18 16:29:25.789451+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:29:24.728725+00	Will Alexandria Ocasio-Cortez be the Democratic Presidential nominee in 2028?	Alexandria Ocasio-Cortez	null	null	null	yes
2026-03-18 16:29:24.728725+00	Will Alexandria Ocasio-Cortez be the Democratic Presidential nominee in 2028?	Alexandria Ocasio-Cortez	null	null	null	yes
2026-03-18 16:29:24.728725+00	Will Alexandria Ocasio-Cortez be the Democratic Presidential nominee in 2028?	Alexandria Ocasio-Cortez	null	null	null	yes
2026-03-18 16:29:24.728725+00	Will Alexandria Ocasio-Cortez be the Democratic Presidential nominee in 2028?	Alexandria Ocasio-Cortez	null	null	null	yes
2026-03-18 16:28:19.199518+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:27:55.989922+00	Will Gavin Newsom be the nominee for the Vice Presidency for the Democratic party?	Gavin Newsom	null	null	null	yes
2026-03-18 16:27:55.989922+00	Will Gavin Newsom be the nominee for the Vice Presidency for the Democratic party?	Gavin Newsom	null	null	null	yes
2026-03-18 16:27:55.989922+00	Will Gavin Newsom be the nominee for the Vice Presidency for the Democratic party?	Gavin Newsom	null	null	null	yes
2026-03-18 16:26:54.378729+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	yes
2026-03-18 16:26:48.995947+00	Will Marco Rubio be the nominee for the Presidency for the Republican party?	Marco Rubio	null	null	null	yes
2026-03-18 16:26:32.947126+00	Will J.D. Vance be the nominee for the Presidency for the Republican party?	J.D. Vance	null	null	null	yes
2026-03-18 16:25:47.102469+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	no
2026-03-18 16:25:41.012822+00	Which countries will have recessions?	Japan	null	null	null	yes
2026-03-18 16:25:23.768558+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	null	null	null	yes
2026-03-18 16:25:12.208967+00	Will the IMF declare a global recession before 2027?	Before 2027	null	null	null	yes
2026-03-18 16:24:53.561151+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	null	null	null	yes
2026-03-18 16:24:33.961496+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	yes
2026-03-18 16:23:22.008489+00	Will Larry Ellison be the world's first trillionaire?	Larry Ellison	null	null	null	no
2026-03-18 16:21:59.039824+00	Will Republicans win the House in 2026?	Republican Party	null	null	null	yes
2026-03-18 16:21:11.635552+00	Wil Keisha Lance Bottoms be the Democratic nominee for Governor in Georgia?	Keisha Lance Bottoms	null	null	null	yes
2026-03-18 16:21:11.635552+00	Wil Keisha Lance Bottoms be the Democratic nominee for Governor in Georgia?	Keisha Lance Bottoms	null	null	null	yes
2026-03-18 16:20:15.254084+00	Wil Janet Mills be the Democratic nominee for the Senate in Maine?	Janet Mills	null	null	null	yes
2026-03-18 16:19:34.45461+00	Will Republicans win the U.S. Senate in 2026?	Republican Party	null	null	null	yes
2026-03-18 16:18:37.454988+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:18:37.454988+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:18:37.454988+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:18:37.454988+00	Will Democrats win the U.S. Senate in 2026?	Democratic Party	null	null	null	yes
2026-03-18 16:17:11.325739+00	Will Gavin Newsom be the Democratic Presidential nominee in 2028?	Gavin Newsom	null	null	null	no
2026-03-18 16:17:02.30834+00	Will Republicans win the U.S. Senate in 2026?	Republican Party	null	null	null	yes
2026-03-18 16:16:01.709988+00	Will J.B. Pritzker be the Democratic Presidential nominee in 2028?	J.B. Pritzker	null	null	null	yes
2026-03-18 16:15:44.608522+00	Will the DOJ win their antitrust lawsuit against Live Nation before Jan 1, 2030?	Before Jan 1, 2030	null	null	null	no
2026-03-18 16:15:44.608522+00	Will the DOJ win their antitrust lawsuit against Live Nation before Jan 1, 2030?	Before Jan 1, 2030	null	null	null	no
2026-03-18 16:15:03.800284+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	null	null	null	yes
2026-03-18 16:14:18.726183+00	Will any country join the EU by 2030?	Any country	null	null	null	no
2026-03-18 16:13:49.942898+00	Will US test scores in Reading decline?	Significant decrease	null	null	null	no
2026-03-18 16:13:49.942898+00	Will US test scores in Reading decline?	Significant decrease	null	null	null	no
2026-03-18 16:11:48.788031+00	Will Democratics win the Senate race in Texas?	James Talarico	null	null	null	yes
2026-03-18 16:11:13.575288+00	Will Republicans win the Senate race in Maine?	Republican party	null	null	null	yes
2026-03-18 16:09:55.013327+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	null	null	null	yes
2026-03-18 16:08:52.4008+00	Will any country join the EU by 2030?	Any country	null	null	null	no
2026-03-18 16:08:51.410456+00	Will any country join the EU by 2030?	Any country	null	null	null	no
2026-03-18 16:07:10.545513+00	Will Democrats win the House in 2026?	Democratic Party	null	null	null	no
2026-03-18 16:06:51.252501+00	Will Puerto Rico be the 51st U.S. state before Jan 20, 2029?	Puerto Rico	null	null	null	yes
2026-03-18 16:06:14.763352+00	Will Republicans win the U.S. Senate in 2026?	Republican Party	null	null	null	yes
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:26.832018+00	Wil Byron Donalds be the Republican nominee for Governor in Florida?	Byron Donalds	null	null	null	no
2026-03-18 16:05:19.360402+00	Will Marco Rubio be the nominee for the Presidency for the Republican party?	Marco Rubio	null	null	null	no
2026-03-18 16:05:19.229572+00	Will Ken Paxton be the Republican nominee for the Senate in Texas?	Ken Paxton	null	null	null	no
2026-03-18 16:05:13.444483+00	Will Donald J. Trump be the nominee for the Presidency for the Republican party?	Donald J. Trump	null	null	null	yes
2026-03-18 16:04:58.268245+00	Will Donald J. Trump be the nominee for the Presidency for the Republican party?	Donald J. Trump	null	null	null	yes
2026-03-18 16:04:27.969521+00	Will Donald J. Trump be the nominee for the Presidency for the Republican party?	Donald J. Trump	null	null	null	yes
2026-03-18 16:04:27.147879+00	Will Galatasaray win the Champions League Winner?	Galatasaray	null	null	null	yes
2026-03-18 16:04:23.154993+00	Will Marco Rubio be the nominee for the Presidency for the Republican party?	Marco Rubio	null	null	null	yes
2026-03-18 16:04:07.979873+00	Will the national debt hit $50 trillion during the Trump Administration?	$50 trillion	null	null	null	yes
2026-03-18 16:04:07.979873+00	Will the national debt hit $50 trillion during the Trump Administration?	$50 trillion	null	null	null	yes
2026-03-18 16:04:02.52001+00	Who will win the governorship in California?	Chad Bianco	null	null	null	yes
2026-03-18 16:03:50.8602+00	Will John Cornyn be the Republican nominee for the Senate in Texas?	John Cornyn	null	null	null	yes
2026-03-18 16:03:50.59795+00	Will Galatasaray win the Champions League Winner?	Galatasaray	null	null	null	yes
2026-03-18 16:03:48.131341+00	Will "SAVE Act" (H.R. 22) becomes law before Jan 4, 2027?	Before Jan 4, 2027	null	null	null	yes
2026-03-18 16:03:46.613623+00	Will US test scores in Reading decline?	No significant difference	null	null	null	yes
2026-03-18 16:03:44.061034+00	Will the US government take control of any AI company or project before 2030?	Before 2030	null	null	null	no
2026-03-18 16:03:26.22559+00	Will Real Madrid win the Champions League Winner?	Real Madrid	null	null	null	yes
2026-03-18 16:03:24.171009+00	When will the next U.S. recession start?	Q1 2026	null	null	null	yes
2026-03-18 16:03:24.171009+00	When will the next U.S. recession start?	Q1 2026	null	null	null	yes
2026-03-18 16:03:21.607785+00	Will the Gukesh Dommaraju win the World Chess Championship?	Gukesh Dommaraju	null	null	null	no
2026-03-18 16:03:16.412909+00	Will PSG win the Champions League Winner?	PSG	null	null	null	yes
2026-03-18 16:02:59.184299+00	Will Democratics win the Senate race in Texas?	James Talarico	null	null	null	yes
2026-03-18 16:02:58.08182+00	Will the Democratic party win the governorship in Illinois	Democratic party	null	null	null	yes
2026-03-18 16:02:56.805088+00	What will be the largest source of global primary energy consumption in 2030?	Modern biofuels	null	null	null	no
2026-03-18 16:02:43.190603+00	Who will win MVP?	Luka Doncic	null	null	null	yes
2026-03-18 16:02:37.538863+00	Wil Mallory McMorrow be the Democratic nominee for the Senate in Michigan?	Mallory McMorrow	null	null	null	yes
2026-03-18 16:02:37.538863+00	Wil Mallory McMorrow be the Democratic nominee for the Senate in Michigan?	Mallory McMorrow	null	null	null	yes
2026-03-18 16:02:37.538863+00	Wil Mallory McMorrow be the Democratic nominee for the Senate in Michigan?	Mallory McMorrow	null	null	null	yes
2026-03-18 16:02:37.538863+00	Wil Mallory McMorrow be the Democratic nominee for the Senate in Michigan?	Mallory McMorrow	null	null	null	yes
2026-03-18 16:02:36.979704+00	What will be the largest source of global primary energy consumption in 2030?	Nuclear	null	null	null	no
2026-03-18 16:02:32.432548+00	Will the United States acquire any part of Greenland before 2029?	Before January 21, 2029	null	null	null	no
2026-03-18 16:02:20.812352+00	Will the Federal Reserve Cut rates by 25bps at their March 2026 meeting?	Cut 25bps	null	null	null	yes
2026-03-18 16:02:19.64716+00	Will the Federal Reserve Hike rates by 0bps at their March 2026 meeting?	Fed maintains rate	null	null	null	no
2026-03-18 16:02:14.332241+00	Will the Federal Reserve Cut rates by 25bps at their March 2026 meeting?	Cut 25bps	null	null	null	yes
2026-03-18 16:01:56.277262+00	Who will win the governorship in California?	Katie Porter	null	null	null	yes
2026-03-18 16:01:56.277262+00	Who will win the governorship in California?	Katie Porter	null	null	null	yes
2026-03-18 16:01:56.277262+00	Who will win the governorship in California?	Katie Porter	null	null	null	yes

Query Result