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-05-08 15:29:14.343822+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:29:07.691733+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:28:26.952973+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:27:42.204282+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:27:39.353653+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:27:39.057514+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:27:31.616327+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:27:14.439297+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:26:48.274216+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:26:15.104822+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:25:22.522112+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:25:17.165645+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:25:00.340296+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:24:55.84459+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:24:28.314576+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:23:50.680531+00	Will US new home sales for April 2026 be above 760,000?	Above 760,000	null	null	null	no
2026-05-08 15:23:37.146185+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:23:22.160832+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:20:58.071832+00	New York M vs Arizona Winner?	Arizona	null	null	null	no
2026-05-08 15:19:38.33205+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:19:21.708761+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:19:13.327037+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:18:46.96236+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:17:16.411288+00	yes Lens,yes Monaco,yes Auxerre,yes Lorient,yes PSG,yes Stade Rennais	yes Lens,yes Monaco,yes Auxerre,yes Lorient,yes PSG,yes Stade Rennais	null	null	null	yes
2026-05-08 15:15:14.10398+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:14:39.937396+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:14:29.121664+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:14:00.093666+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:13:44.669047+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:13:36.963836+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:13:02.313723+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:12:55.656855+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:12:37.162086+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:12:15.097832+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:12:02.331584+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	no
2026-05-08 15:11:38.46042+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:11:36.016364+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:11:22.909168+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:09:49.410299+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:08:37.995721+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:08:03.791183+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:07:51.731834+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:07:28.634864+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:06:48.898959+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:05:06.261049+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:04:47.150664+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:02:43.665836+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:02:41.191857+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:02:23.031647+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:02:01.672438+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:02:00.156501+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:01:51.958807+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:01:44.518721+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:00:54.089772+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 15:00:35.738779+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:00:22.9956+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 15:00:21.882276+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 15:00:20.932912+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 15:00:16.262381+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:59:33.738325+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:59:20.8748+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:58:47.95249+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:58:16.313848+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:57:45.658281+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:57:30.457687+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:56:40.012368+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:55:20.905837+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:54:30.78159+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:53:55.683288+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:53:51.008198+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:52:05.968348+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:51:39.987149+00	New York M vs Arizona Winner?	New York M	null	null	null	no
2026-05-08 14:50:09.04727+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:49:39.967339+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:49:30.136593+00	New York M vs Arizona Winner?	New York M	null	null	null	no
2026-05-08 14:48:27.252499+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:47:01.227192+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:46:45.545943+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:46:19.427896+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:45:48.925128+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:45:08.677032+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:45:06.360245+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:42:44.47832+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:42:32.487088+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:41:44.308829+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:41:36.692116+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:41:19.826238+00	St. Louis vs San Diego Winner?	St. Louis	null	null	null	yes
2026-05-08 14:41:09.443084+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:41:06.405253+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:38:58.802887+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:37:50.300592+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:37:39.193287+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:37:29.043126+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:37:05.486284+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:36:51.907341+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:36:09.267117+00	New York M vs Arizona Winner?	Arizona	null	null	null	yes
2026-05-08 14:36:05.858029+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:34:39.739378+00	St. Louis vs San Diego Winner?	San Diego	null	null	null	yes
2026-05-08 14:34:11.493562+00	New York M vs Arizona Winner?	New York M	null	null	null	yes
2026-05-08 14:34:01.338225+00	yes Joaquin Buckley,yes Khamzat Chimaev,yes Ozzy Diaz,yes Jeremy Stephens,yes Joshua van,yes Waldo Cortes-Acosta	yes Joaquin Buckley,yes Khamzat Chimaev,yes Ozzy Diaz,yes Jeremy Stephens,yes Joshua van,yes Waldo Cortes-Acosta	null	null	null	yes

Query Result