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-06-20 15:08:34.154315+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 15:06:13.871835+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	yes
2026-06-20 15:04:58.061409+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 15:04:58.061409+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 15:01:09.369382+00	Will XRP trimmed mean be above $1.40 by 11:59 PM ET on Jun 30, 2026?	Above $1.40	null	null	null	no
2026-06-20 15:00:42.040598+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	yes
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 15:00:32.809742+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	no
2026-06-20 14:59:42.460217+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	yes
2026-06-20 14:55:08.047368+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	no
2026-06-20 14:55:03.553598+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	no
2026-06-20 14:55:03.553598+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	no
2026-06-20 14:53:22.514463+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 14:53:22.514463+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 14:53:22.451764+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	no
2026-06-20 14:52:32.51773+00	Will ETH trimmed mean be above $2250.00 by 11:59 PM ET on Jun 30, 2026?	Above $2,250.00	null	null	null	no
2026-06-20 14:52:19.306472+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 14:52:19.306472+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	yes
2026-06-20 14:51:41.075599+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:51:27.338297+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:51:27.338297+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:51:27.338297+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:51:27.338297+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:51:27.338297+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:50:40.790377+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:50:06.111263+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	no
2026-06-20 14:49:06.554637+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	yes
2026-06-20 14:49:06.554637+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	yes
2026-06-20 14:49:06.554637+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	yes
2026-06-20 14:49:06.554637+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	yes
2026-06-20 14:49:06.554637+00	Will SOL trimmed mean be above $90.00 by 11:59 PM ET on Jun 30, 2026?	Above $90.00	null	null	null	yes
2026-06-20 14:49:02.713901+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	yes
2026-06-20 14:48:49.850644+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	yes
2026-06-20 14:48:26.389541+00	Will XRP trimmed mean be above $1.40 by 11:59 PM ET on Jun 30, 2026?	Above $1.40	null	null	null	yes
2026-06-20 14:47:14.621196+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	yes
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:46:28.784408+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	no
2026-06-20 14:37:24.36106+00	Will BTC trimmed mean be above $80000.00 by 11:59 PM ET on Jun 30, 2026?	Above $80,000.00	null	null	null	yes
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:34:15.747664+00	Will BTC trimmed mean be above $77500.00 by 11:59 PM ET on Jun 30, 2026?	Above $77,500.00	null	null	null	no
2026-06-20 14:31:28.789449+00	Will DOGE trimmed mean be above $0.11 by 11:59 PM ET on Jun 30, 2026?	Above $0.11	null	null	null	yes
2026-06-20 14:29:56.849406+00	Will BTC trimmed mean be above $75000.00 by 11:59 PM ET on Jun 30, 2026?	Above $75,000.00	null	null	null	yes
2026-06-20 14:27:54.6386+00	Will XRP trimmed mean be above $1.40 by 11:59 PM ET on Jun 30, 2026?	Above $1.40	null	null	null	no
2026-06-20 14:27:35.591813+00	Will XRP trimmed mean be above $1.50 by 11:59 PM ET on Jun 30, 2026?	Above $1.50	null	null	null	no
2026-06-20 14:27:16.228207+00	Will XRP trimmed mean be above $2.10 by 11:59 PM ET on Jun 30, 2026?	Above $2.10	null	null	null	no
2026-06-20 14:23:00.874298+00	Will BTC trimmed mean be below $57500.00 by 11:59 PM ET on Jun 30, 2026?	Below $57,500.00	null	null	null	yes
2026-06-20 14:13:31.314187+00	Will BNB trimmed mean be above $770.00 by 11:59 PM ET on Jun 30, 2026?	Above $770.00	null	null	null	yes
2026-06-20 14:13:31.314187+00	Will BNB trimmed mean be above $770.00 by 11:59 PM ET on Jun 30, 2026?	Above $770.00	null	null	null	yes

Query Result