Query: Kalshi recent trades - crypto 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)
4     INNER JOIN @kalshi.markets.events events ON (markets.event_ticker=events.event_ticker)
5WHERE events.category = 'Crypto'
6ORDER By trades.created_time DESC
7limit 100

Timestamp	Market	Market - Subtitle	Cost (USD)	price	count	taker_side
2026-05-07 20:59:00.350558+00	BNB price on May 7, 2026?	$640 to 644.99	null	null	null	yes
2026-05-07 20:55:03.589334+00	BNB price on May 7, 2026?	$640 to 644.99	null	null	null	yes
2026-05-07 20:55:03.589334+00	BNB price on May 7, 2026?	$640 to 644.99	null	null	null	yes
2026-05-07 20:54:07.475567+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 20:54:07.475567+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 20:52:59.387717+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.38 to 1.3999	null	null	null	yes
2026-05-07 20:52:59.386911+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.38 to 1.3999	null	null	null	yes
2026-05-07 20:37:24.141923+00	Dogecoin price on May 7, 2026?	$0.11 or above	null	null	null	yes
2026-05-07 20:37:24.141923+00	Dogecoin price on May 7, 2026?	$0.11 or above	null	null	null	yes
2026-05-07 20:30:39.011721+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.38 to 1.3999	null	null	null	yes
2026-05-07 20:22:47.328056+00	Dogecoin price on May 7, 2026?	$0.105 or above	null	null	null	no
2026-05-07 20:20:09.181105+00	Shiba Inu price on May 7, 2026?	$0.0000065 or above	null	null	null	yes
2026-05-07 20:03:55.029695+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.36 to 1.3799	null	null	null	no
2026-05-07 20:03:50.169123+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.36 to 1.3799	null	null	null	no
2026-05-07 20:03:34.563245+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.36 to 1.3799	null	null	null	no
2026-05-07 20:03:34.562026+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.36 to 1.3799	null	null	null	no
2026-05-07 20:01:56.095046+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:52:26.403562+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	no
2026-05-07 19:52:17.327094+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	yes
2026-05-07 19:52:05.507145+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	no
2026-05-07 19:52:05.507145+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	no
2026-05-07 19:52:03.321879+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:51:51.186612+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:51:38.540653+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:51:38.540653+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:50:43.122321+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:50:32.262218+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.36 to 1.3799	null	null	null	yes
2026-05-07 19:49:34.394512+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:49:34.394512+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:49:28.31244+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:49:07.967996+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	no
2026-05-07 19:46:17.737138+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:44:55.49226+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:44:55.49226+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:44:39.597296+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:44:39.597296+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:44:39.597296+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:42:50.939317+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:42:50.939317+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:42:14.89335+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:42:10.230257+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	yes
2026-05-07 19:42:10.230257+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	yes
2026-05-07 19:41:57.59188+00	Bitcoin price range on May 7, 2026?	$80,500 to 80,749.99	null	null	null	no
2026-05-07 19:41:37.340462+00	Bitcoin price range on May 7, 2026?	$78,500 to 78,749.99	null	null	null	yes
2026-05-07 19:41:24.690371+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	no
2026-05-07 19:38:34.262859+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	no
2026-05-07 19:38:05.275828+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	no
2026-05-07 19:37:39.733502+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:35:23.264764+00	Bitcoin price range on May 7, 2026?	$79,500 to 79,749.99	null	null	null	yes
2026-05-07 19:34:36.083876+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:33:54.256518+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:29:33.641249+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:29:11.117748+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	no
2026-05-07 19:28:49.627035+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	no
2026-05-07 19:25:05.160158+00	Bitcoin price range on May 7, 2026?	$87,250 to 87,499.99	null	null	null	no
2026-05-07 19:25:05.160158+00	Bitcoin price range on May 7, 2026?	$87,250 to 87,499.99	null	null	null	no
2026-05-07 19:25:04.752679+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	no
2026-05-07 19:24:51.52389+00	Bitcoin price range on May 7, 2026?	$77,250 to 77,499.99	null	null	null	no
2026-05-07 19:24:40.464565+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:24:40.464565+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:24:15.581492+00	Bitcoin price range on May 7, 2026?	$79,000 to 79,249.99	null	null	null	no
2026-05-07 19:23:40.460359+00	Bitcoin price range on May 7, 2026?	$89,000 to 89,249.99	null	null	null	yes
2026-05-07 19:23:40.365545+00	Bitcoin price range on May 7, 2026?	$89,250 to 89,499.99	null	null	null	yes
2026-05-07 19:23:40.262825+00	Bitcoin price range on May 7, 2026?	$89,500 to 89,749.99	null	null	null	yes
2026-05-07 19:23:40.158176+00	Bitcoin price range on May 7, 2026?	$89,750 to 89,999.99	null	null	null	yes
2026-05-07 19:23:40.059677+00	Bitcoin price range on May 7, 2026?	$90,000 to 90,249.99	null	null	null	yes
2026-05-07 19:23:39.958152+00	Bitcoin price range on May 7, 2026?	$90,250 to 90,499.99	null	null	null	yes
2026-05-07 19:23:39.851516+00	Bitcoin price range on May 7, 2026?	$90,500 to 90,749.99	null	null	null	yes
2026-05-07 19:23:39.750272+00	Bitcoin price range on May 7, 2026?	$90,750 to 90,999.99	null	null	null	yes
2026-05-07 19:23:39.647413+00	Bitcoin price range on May 7, 2026?	$91,000 to 91,249.99	null	null	null	yes
2026-05-07 19:23:39.545809+00	Bitcoin price range on May 7, 2026?	$71,749.99 or below	null	null	null	yes
2026-05-07 19:23:39.450684+00	Bitcoin price range on May 7, 2026?	$91,250 or above	null	null	null	yes
2026-05-07 19:23:21.590295+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:23:21.590295+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:19:58.516173+00	BNB price on May 7, 2026?	$555 to 559.99	null	null	null	yes
2026-05-07 19:19:58.516173+00	BNB price on May 7, 2026?	$555 to 559.99	null	null	null	yes
2026-05-07 19:19:58.516173+00	BNB price on May 7, 2026?	$555 to 559.99	null	null	null	yes
2026-05-07 19:19:39.885182+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:19:39.885182+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:19:38.100003+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.4 to 1.4199	null	null	null	no
2026-05-07 19:19:38.100003+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.4 to 1.4199	null	null	null	no
2026-05-07 19:19:28.983026+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:19:28.710423+00	Bitcoin price range on May 7, 2026?	$80,500 to 80,749.99	null	null	null	no
2026-05-07 19:19:26.07476+00	Bitcoin price range on May 7, 2026?	$79,000 to 79,249.99	null	null	null	no
2026-05-07 19:19:16.946455+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:19:14.861619+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	no
2026-05-07 19:19:14.860272+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	no
2026-05-07 19:18:32.634973+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:18:26.582414+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:18:20.576972+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:18:14.428696+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:18:08.362325+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:18:01.878733+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:17:59.585367+00	Bitcoin price range on May 7, 2026?	$79,750 to 79,999.99	null	null	null	yes
2026-05-07 19:17:54.859555+00	Ripple price at May 7, 2026 at 5pm EDT?	$1.39991 or above	null	null	null	yes
2026-05-07 19:16:55.636063+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:16:55.636063+00	Bitcoin price range on May 7, 2026?	$80,250 to 80,499.99	null	null	null	yes
2026-05-07 19:16:53.8199+00	BNB price on May 7, 2026?	$550 to 554.99	null	null	null	yes
2026-05-07 19:13:18.512951+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes
2026-05-07 19:13:18.512951+00	Bitcoin price range on May 7, 2026?	$80,000 to 80,249.99	null	null	null	yes

Query Result