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-03-18 15:55:13.433534+00	When will Dogecoin hit $1?	Before Jun 1, 2026	null	null	null	yes
2026-03-18 15:51:47.050414+00	When will Bitcoin hit $150k?	Before April 2026	null	null	null	yes
2026-03-18 15:47:08.801653+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	no
2026-03-18 15:42:38.572056+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	no
2026-03-18 15:42:38.572056+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	no
2026-03-18 15:38:42.278809+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	no
2026-03-18 15:37:41.900954+00	Will Bitcoin be above $200000 by Jan 1, 2027 at 11:59PM ET?	Above $200000	null	null	null	no
2026-03-18 15:37:41.900954+00	Will Bitcoin be above $200000 by Jan 1, 2027 at 11:59PM ET?	Above $200000	null	null	null	no
2026-03-18 15:36:21.30722+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:36:14.843611+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	yes
2026-03-18 15:35:48.649785+00	When will Bitcoin hit $150k?	Before April 2026	null	null	null	yes
2026-03-18 15:34:58.270615+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:34:48.450717+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	no
2026-03-18 15:34:44.724189+00	When will Dogecoin hit $1?	Before Jun 1, 2027	null	null	null	no
2026-03-18 15:34:09.661273+00	Will Bitcoin be above $109,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $109,999.99	null	null	null	no
2026-03-18 15:33:26.049293+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	yes
2026-03-18 15:31:37.0447+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	no
2026-03-18 15:29:36.169242+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	no
2026-03-18 15:29:08.742056+00	Which of these cryptocurrencies will have a positive return in 2026?	Dogecoin (DOGE)	null	null	null	yes
2026-03-18 15:24:23.146283+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	yes
2026-03-18 15:21:56.503226+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:20:26.908324+00	When will Bitcoin hit $150k?	Before May 2026	null	null	null	yes
2026-03-18 15:20:14.285987+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:20:03.131049+00	Will Bitcoin be above $100000 by May 1, 2026 at 12:00AM ET?	Before May 2026	null	null	null	yes
2026-03-18 15:20:03.131049+00	Will Bitcoin be above $100000 by May 1, 2026 at 12:00AM ET?	Before May 2026	null	null	null	yes
2026-03-18 15:19:27.564778+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:19:27.564778+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:17:52.944549+00	When will Bitcoin hit $150k?	Before April 2026	null	null	null	yes
2026-03-18 15:17:39.901678+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:17:39.901678+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:17:28.910728+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	yes
2026-03-18 15:17:28.910728+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	yes
2026-03-18 15:17:28.910728+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	yes
2026-03-18 15:17:28.910728+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	yes
2026-03-18 15:17:28.910728+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	yes
2026-03-18 15:17:28.909322+00	Will Bitcoin be above $109,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $109,999.99	null	null	null	no
2026-03-18 15:16:27.48898+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	yes
2026-03-18 15:16:27.48898+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	yes
2026-03-18 15:16:01.814135+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	yes
2026-03-18 15:15:31.714235+00	When will Bitcoin hit $150k?	Before April 2026	null	null	null	yes
2026-03-18 15:14:53.295955+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	no
2026-03-18 15:14:53.295955+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	no
2026-03-18 15:14:53.295955+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	no
2026-03-18 15:14:30.772553+00	Will Bitcoin be above $200000 by Jan 1, 2027 at 11:59PM ET?	Above $200000	null	null	null	no
2026-03-18 15:12:07.2326+00	Will Bitcoin be above $100000 by May 1, 2026 at 12:00AM ET?	Before May 2026	null	null	null	yes
2026-03-18 15:08:41.382359+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	yes
2026-03-18 15:08:29.962495+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:08:29.962495+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:08:29.962495+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:08:29.962495+00	Will Ethereum reach above $4500.00 by Jan 1, 2027 at 12:00AM?	Above $4,500.00	null	null	null	no
2026-03-18 15:07:44.08145+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:07:11.647578+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	yes
2026-03-18 15:05:01.78399+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:05:01.78399+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:04:52.897054+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:04:52.897054+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:04:52.897054+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:04:52.897054+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:04:52.897054+00	Will Bitcoin be above $99,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $99,999.99	null	null	null	yes
2026-03-18 15:01:47.213209+00	Will Bitcoin be above $129,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $129,999.99	null	null	null	no
2026-03-18 15:01:47.213209+00	Will Bitcoin be above $129,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $129,999.99	null	null	null	no
2026-03-18 15:01:47.213209+00	Will Bitcoin be above $129,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $129,999.99	null	null	null	no
2026-03-18 15:01:47.213209+00	Will Bitcoin be above $129,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $129,999.99	null	null	null	no
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:01:47.122416+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:00:50.348188+00	When will Bitcoin hit $150k?	Before April 2026	null	null	null	yes
2026-03-18 15:00:15.268716+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	no
2026-03-18 15:00:15.268716+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	no
2026-03-18 15:00:15.268716+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	no
2026-03-18 15:00:15.268716+00	Will Bitcoin be above $119,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $119,999.99	null	null	null	no
2026-03-18 15:00:15.127596+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:00:15.127596+00	Will Bitcoin be below $40000.00 by Jan 1, 2027 at 12:00am ET?	Below $40,000.00	null	null	null	yes
2026-03-18 15:00:11.646483+00	Will Bitcoin be above $250000 by Jan 1, 2027 at 12:00AM ET?	Above $250000	null	null	null	yes
2026-03-18 14:59:10.066838+00	Will Bitcoin be above $139,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $139,999.99	null	null	null	no
2026-03-18 14:58:39.519679+00	Will Ethereum reach below $1500.00 by Jan 1, 2027 at 12:00AM ET?	Below $1,500.00	null	null	null	yes
2026-03-18 14:58:09.004634+00	Will Bitcoin be above $100000 by July 1, 2026 at 12:00AM ET?	Before July 2026	null	null	null	yes
2026-03-18 14:58:06.597203+00	Which of these cryptocurrencies will have a positive return in 2026?	Bitcoin (BTC)	null	null	null	yes
2026-03-18 14:58:06.597203+00	Which of these cryptocurrencies will have a positive return in 2026?	Bitcoin (BTC)	null	null	null	yes
2026-03-18 14:56:36.903615+00	Will Bitcoin be below $60000.00 by Jan 1, 2027 at 12:00am ET?	Below $60,000.00	null	null	null	no
2026-03-18 14:55:47.562883+00	Will GTE deploy on MegaETH mainnet before Jan 1, 2027?	Yes	null	null	null	no
2026-03-18 14:55:24.102778+00	Will Bitcoin be above $100000 by April 1st, 2026 at 12:00AM ET?	Before April 2026	null	null	null	yes
2026-03-18 14:53:59.68037+00	Will Bitcoin be above $100000 by July 1, 2026 at 12:00AM ET?	Before July 2026	null	null	null	yes
2026-03-18 14:53:59.68037+00	Will Bitcoin be above $100000 by July 1, 2026 at 12:00AM ET?	Before July 2026	null	null	null	yes
2026-03-18 14:53:44.965835+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	no
2026-03-18 14:53:44.965835+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	no
2026-03-18 14:53:44.965835+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	no
2026-03-18 14:53:44.965835+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	no
2026-03-18 14:51:23.922801+00	Will Bitcoin be above $200000 by Jan 1, 2027 at 11:59PM ET?	Above $200000	null	null	null	yes
2026-03-18 14:48:41.186734+00	When will Bitcoin hit $150k?	Before June 2026	null	null	null	no
2026-03-18 14:47:58.999354+00	ETH price on Jan 1, 2027?	2,000 to 2,249.99	null	null	null	yes
2026-03-18 14:45:13.555404+00	Will Bitcoin be above $100000 by June 1, 2026 at 12:00AM ET?	Before June 2026	null	null	null	no
2026-03-18 14:44:39.616452+00	Will BTC trimmed mean be below $55000.00 by 11:59 PM ET on Mar 31, 2026?	Below $55,000.00	null	null	null	yes
2026-03-18 14:44:39.616452+00	Will BTC trimmed mean be below $55000.00 by 11:59 PM ET on Mar 31, 2026?	Below $55,000.00	null	null	null	yes
2026-03-18 14:43:30.902636+00	Will Bitcoin be above $109,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $109,999.99	null	null	null	no
2026-03-18 14:43:30.902636+00	Will Bitcoin be above $109,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $109,999.99	null	null	null	no
2026-03-18 14:43:30.902636+00	Will Bitcoin be above $109,999.99 by Dec 31, 2026 at 11:59 PM ET?	Above $109,999.99	null	null	null	no

Query Result