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-06-23 07:26:11.6198+00	Will all teams in Group D collectively score at least 16 goals in the group stage of the 2026 Men's FIFA World Cup?	16+ goals	null	null	null	yes
2026-06-23 06:16:41.850712+00	Will all teams in Group E collectively score at least 18 goals in the group stage of the 2026 Men's FIFA World Cup?	18+ goals	null	null	null	yes
2026-06-23 05:44:22.208665+00	Will a human case of Ebola disease in Kenya be reported before Jul 1, 2026?	Kenya	null	null	null	no
2026-06-23 05:31:23.680281+00	Will all teams in Group A collectively score at least 14 goals in the group stage of the 2026 Men's FIFA World Cup?	14+ goals	null	null	null	yes
2026-06-23 05:01:58.749638+00	Will a human case of Ebola disease in South Sudan be reported before Jul 1, 2026?	South Sudan	null	null	null	yes
2026-06-23 04:57:04.57187+00	Will a human case of Ebola disease in China be reported before Jul 1, 2026?	China	null	null	null	no
2026-06-23 04:56:51.904921+00	Will a human case of Ebola disease in United States be reported before Jul 1, 2026?	United States	null	null	null	no
2026-06-23 04:56:35.957858+00	Will a human case of Ebola disease in India be reported before Jul 1, 2026?	India	null	null	null	no
2026-06-23 04:56:23.448919+00	Will a human case of Ebola disease in Canada be reported before Jul 1, 2026?	Canada	null	null	null	no
2026-06-23 04:35:32.181129+00	Will all teams in Group J collectively score at least 12 goals in the group stage of the 2026 Men's FIFA World Cup?	12+ goals	null	null	null	yes
2026-06-23 04:35:32.181129+00	Will all teams in Group J collectively score at least 12 goals in the group stage of the 2026 Men's FIFA World Cup?	12+ goals	null	null	null	yes
2026-06-23 04:35:32.181129+00	Will all teams in Group J collectively score at least 12 goals in the group stage of the 2026 Men's FIFA World Cup?	12+ goals	null	null	null	yes
2026-06-23 04:30:35.664911+00	Will Lake Mead's end-of-month water elevation be above 1045.5 feet in Jun 2026?	Above 1045.5 Ft	null	null	null	yes
2026-06-23 04:05:13.871617+00	Will all teams in Group E collectively score at least 16 goals in the group stage of the 2026 Men's FIFA World Cup?	16+ goals	null	null	null	yes
2026-06-23 03:54:19.5425+00	Where will David Alaba go next?	Any MLS Club	null	null	null	no
2026-06-23 03:54:19.5425+00	Where will David Alaba go next?	Any MLS Club	null	null	null	no
2026-06-23 03:43:06.435795+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:43:06.435795+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:43:06.435795+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:41:58.256358+00	Will all teams in Group J collectively score at least 12 goals in the group stage of the 2026 Men's FIFA World Cup?	12+ goals	null	null	null	yes
2026-06-23 03:40:58.263029+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:40:46.266693+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:40:41.09282+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:40:32.796879+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:40:15.142952+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:32:08.175045+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 03:32:08.175045+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 03:32:08.175045+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 03:32:08.175045+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 03:32:08.175045+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 03:30:37.320583+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:24:29.775228+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	no
2026-06-23 03:20:48.637449+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:20:48.637449+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:20:48.637449+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:13:07.60434+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:13:07.60434+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:13:07.60434+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 03:11:28.034452+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	no
2026-06-23 03:09:53.544838+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 03:07:30.268654+00	How many launches will SpaceX have in 2026?	Above 10	null	null	null	yes
2026-06-23 02:55:16.205816+00	Will a human case of Ebola disease in South Sudan be reported before Jul 1, 2026?	South Sudan	null	null	null	yes
2026-06-23 02:55:16.205816+00	Will a human case of Ebola disease in South Sudan be reported before Jul 1, 2026?	South Sudan	null	null	null	yes
2026-06-23 02:55:16.205816+00	Will a human case of Ebola disease in South Sudan be reported before Jul 1, 2026?	South Sudan	null	null	null	yes
2026-06-23 02:54:48.126102+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:50:06.223633+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:49:04.221567+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:48:32.390185+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:45:47.841772+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:44:11.347023+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 02:44:06.411452+00	Will all teams in Group A collectively score at least 18 goals in the group stage of the 2026 Men's FIFA World Cup?	18+ goals	null	null	null	no
2026-06-23 02:43:50.491854+00	Will all teams in Group D collectively score at least 20 goals in the group stage of the 2026 Men's FIFA World Cup?	20+ goals	null	null	null	no
2026-06-23 02:40:30.111691+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:40:30.111691+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:40:30.111691+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:39:15.632758+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:35:24.648562+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 02:34:48.331327+00	Will any member of Trump's Cabinet leave before Jul 2026?	Before Jul 2026	null	null	null	yes
2026-06-23 02:33:25.010154+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 02:33:13.074155+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 02:33:13.074155+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 02:32:58.511095+00	Will all teams in Group D collectively score at least 20 goals in the group stage of the 2026 Men's FIFA World Cup?	20+ goals	null	null	null	yes
2026-06-23 02:32:57.570757+00	Will all teams in Group K collectively score at least 22 goals in the group stage of the 2026 Men's FIFA World Cup?	22+ goals	null	null	null	yes
2026-06-23 02:32:46.953374+00	Will all teams in Group E collectively score at least 22 goals in the group stage of the 2026 Men's FIFA World Cup?	22+ goals	null	null	null	yes
2026-06-23 02:24:01.010542+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 02:23:20.450408+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 02:22:27.885348+00	Will all teams in Group A collectively score at least 16 goals in the group stage of the 2026 Men's FIFA World Cup?	16+ goals	null	null	null	yes
2026-06-23 02:20:01.62608+00	Will all teams in Group L collectively score at least 10 goals in the group stage of the 2026 Men's FIFA World Cup?	10+ goals	null	null	null	yes
2026-06-23 02:20:01.62608+00	Will all teams in Group L collectively score at least 10 goals in the group stage of the 2026 Men's FIFA World Cup?	10+ goals	null	null	null	yes
2026-06-23 02:16:59.165832+00	Will all teams in Group L collectively score at least 10 goals in the group stage of the 2026 Men's FIFA World Cup?	10+ goals	null	null	null	yes
2026-06-23 02:16:52.891787+00	How many launches will SpaceX have in 2026?	Above 10	null	null	null	yes
2026-06-23 02:15:26.418076+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 02:15:23.475573+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:11:59.569662+00	Will a human case of Ebola disease in India be reported before Jul 1, 2026?	India	null	null	null	no
2026-06-23 02:11:53.757635+00	Will all teams in Group J collectively score at least 18 goals in the group stage of the 2026 Men's FIFA World Cup?	18+ goals	null	null	null	no
2026-06-23 02:08:28.025302+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:08:23.586746+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:08:23.586746+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:08:23.586746+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:08:23.586746+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:08:23.586746+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	no
2026-06-23 02:07:39.634982+00	How many launches will SpaceX have in 2026?	Above 10	null	null	null	no
2026-06-23 02:07:39.634982+00	How many launches will SpaceX have in 2026?	Above 10	null	null	null	no
2026-06-23 02:07:39.634982+00	How many launches will SpaceX have in 2026?	Above 10	null	null	null	no
2026-06-23 02:03:55.399996+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 02:03:36.201877+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 01:58:42.396177+00	Will all teams in Group J collectively score at least 10 goals in the group stage of the 2026 Men's FIFA World Cup?	10+ goals	null	null	null	yes
2026-06-23 01:58:42.396177+00	Will all teams in Group J collectively score at least 10 goals in the group stage of the 2026 Men's FIFA World Cup?	10+ goals	null	null	null	yes
2026-06-23 01:56:09.640729+00	How many launches will SpaceX have in 2026?	Above 12	null	null	null	yes
2026-06-23 01:52:55.377736+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 01:50:48.473759+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 01:50:16.94266+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	no
2026-06-23 01:48:40.660709+00	Will a human case of Ebola disease in Kenya be reported before Jul 1, 2026?	Kenya	null	null	null	yes
2026-06-23 01:48:40.040283+00	Will Lake Mead's end-of-month water elevation be above 1044 feet in Jun 2026?	Above 1044 Ft	null	null	null	no
2026-06-23 01:48:20.601292+00	Will Lake Mead's end-of-month water elevation be above 1045 feet in Jun 2026?	Above 1045 Ft	null	null	null	yes
2026-06-23 01:48:20.601292+00	Will Lake Mead's end-of-month water elevation be above 1045 feet in Jun 2026?	Above 1045 Ft	null	null	null	yes
2026-06-23 01:46:41.366738+00	How many launches will SpaceX have in 2026?	Above 13	null	null	null	yes
2026-06-23 01:46:33.623034+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 01:45:26.988933+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	yes
2026-06-23 01:45:25.094513+00	How many launches will SpaceX have in 2026?	Above 14	null	null	null	no

Query Result