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
2025-12-13 23:27:50.930448+00	How high will Bitcoin get this year?	$200,000 or above	1.68	0.01	168	yes
2025-12-13 23:26:17.827662+00	How high will Ethereum get this year?	$5,000 or above	40.56	0.02	2028	no
2025-12-13 23:25:10.589625+00	How low will Bitcoin get this year?	Below $70,000	6.95	0.05	139	yes
2025-12-13 23:25:10.589625+00	How low will Bitcoin get this year?	Below $70,000	16.35	0.05	327	yes
2025-12-13 23:23:14.79302+00	When will Bitcoin hit $150k?	Before May 2026	3.2	0.16	20	yes
2025-12-13 23:23:14.79302+00	When will Bitcoin hit $150k?	Before May 2026	3.2	0.16	20	yes
2025-12-13 23:23:14.79302+00	When will Bitcoin hit $150k?	Before May 2026	8.16	0.16	51	yes
2025-12-13 23:23:14.79302+00	When will Bitcoin hit $150k?	Before May 2026	3.2	0.16	20	yes
2025-12-13 23:22:53.061809+00	How low will Bitcoin get this year?	Below $70,000	0.1	0.05	2	yes
2025-12-13 23:22:37.202855+00	How low will Bitcoin get this year?	Below $60,000	0.08	0.04	2	yes
2025-12-13 23:22:18.684122+00	How low will Bitcoin get this year?	Below $80,000	0.42	0.21	2	yes
2025-12-13 23:22:14.99859+00	When will Bitcoin hit $150k?	Before May 2026	88.65	0.15	591	no
2025-12-13 23:21:30.362379+00	When will Bitcoin hit $150k?	Before May 2026	450	0.15	3000	yes
2025-12-13 23:21:19.510024+00	When will Bitcoin hit $150k?	Before June 2026	586	0.2	2930	yes
2025-12-13 23:20:51.881327+00	How low will Bitcoin get this year?	Below $80,000	0.17	0.17	1	no
2025-12-13 23:18:57.713832+00	How low will Bitcoin get this year?	Below $80,000	0.17	0.17	1	no
2025-12-13 23:17:56.665756+00	Will Avalanche achieve max TPS above 300 before Jan 1, 2026?	Above 300	8.2	0.82	10	yes
2025-12-13 23:17:56.665756+00	Will Avalanche achieve max TPS above 300 before Jan 1, 2026?	Above 300	8.2	0.82	10	yes
2025-12-13 23:17:56.665756+00	Will Avalanche achieve max TPS above 300 before Jan 1, 2026?	Above 300	8.2	0.82	10	yes
2025-12-13 23:17:56.665756+00	Will Avalanche achieve max TPS above 300 before Jan 1, 2026?	Above 300	40.5	0.81	50	yes
2025-12-13 23:17:56.665756+00	Will Avalanche achieve max TPS above 300 before Jan 1, 2026?	Above 300	83	0.83	100	yes
2025-12-13 23:17:14.945063+00	How low will Ethereum get this year?	Below $2,250	7	0.07	100	no
2025-12-13 23:16:28.722266+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	46.98	0.29	162	yes
2025-12-13 23:16:28.722266+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	11.02	0.29	38	yes
2025-12-13 23:16:21.736638+00	How high will XRP get this year?	$4 or above	0.24	0.01	24	no
2025-12-13 23:16:03.607059+00	How high will XRP get this year?	$4 or above	0.23	0.01	23	no
2025-12-13 23:15:58.947596+00	How low will Ethereum get this year?	Below $1,000	0.13	0.01	13	no
2025-12-13 23:15:45.140879+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	9.28	0.29	32	yes
2025-12-13 23:14:05.833836+00	How high will Bitcoin get this year?	$130,000 or above	30	0.02	1500	yes
2025-12-13 23:12:54.258586+00	When will Bitcoin hit $150k?	Before March 2026	4	0.08	50	yes
2025-12-13 23:12:28.268364+00	How low will Bitcoin get this year?	Below $80,000	18.53	0.17	109	no
2025-12-13 23:12:28.268364+00	How low will Bitcoin get this year?	Below $80,000	1.62	0.18	9	no
2025-12-13 23:12:28.268364+00	How low will Bitcoin get this year?	Below $80,000	0.18	0.18	1	no
2025-12-13 23:11:41.360872+00	How high will Ethereum get this year?	$5,000 or above	24	0.03	800	yes
2025-12-13 23:11:07.00161+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.87	0.29	3	yes
2025-12-13 23:10:02.430952+00	When will Dogecoin hit $1?	Before Jun 1, 2026	1	0.05	20	no
2025-12-13 23:09:38.041248+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	13.5	0.27	50	no
2025-12-13 23:09:24.324245+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	18.85	0.29	65	yes
2025-12-13 23:08:28.136091+00	Will the spot price of Solana be above $294.096 before Jan 1, 2026 at 10:00 AM ET ET?	above $294.096	0.1	0.01	10	no
2025-12-13 23:08:00.741632+00	How high will Bitcoin get this year?	$130,000 or above	0.02	0.02	1	yes
2025-12-13 23:07:59.575381+00	How low will Ethereum get this year?	Below $2,500	7	0.14	50	yes
2025-12-13 23:07:41.663169+00	Will MrBeast launch a new digital asset before 2026?	MrBeast	0.03	0.03	1	no
2025-12-13 23:07:41.663169+00	Will MrBeast launch a new digital asset before 2026?	MrBeast	0.24	0.03	8	no
2025-12-13 23:07:41.663169+00	Will MrBeast launch a new digital asset before 2026?	MrBeast	0.03	0.03	1	no
2025-12-13 23:07:23.872314+00	Will Joe Rogan launch a new digital asset before 2026?	Joe Rogan	0.07	0.01	7	no
2025-12-13 23:07:16.714665+00	Bitcoin price on Dec 19, 2025?	$90,000 or above	1000	0.5	2000	no
2025-12-13 23:07:08.100991+00	Bitcoin price on Dec 19, 2025?	$90,000 or above	1000	0.5	2000	no
2025-12-13 23:06:26.167939+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	3.51	0.27	13	no
2025-12-13 23:05:39.379405+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.27	0.27	1	no
2025-12-13 23:05:04.503937+00	How low will Bitcoin get this year?	Below $80,000	0.42	0.21	2	yes
2025-12-13 23:04:27.144006+00	Will Ethereum reach above $4953.73 by Dec 31, 2025 at 11:59 PM?	Above $4953.73	9.34	0.02	467	yes
2025-12-13 23:04:02.290148+00	How low will Bitcoin get this year?	Below $80,000	0.18	0.18	1	no
2025-12-13 23:01:31.055496+00	SOL price on Jan 1, 2027?	150 or above	10.26	0.54	19	yes
2025-12-13 23:01:00.602655+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	22.33	0.29	77	yes
2025-12-13 23:00:36.861241+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.87	0.29	3	yes
2025-12-13 22:59:47.193235+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	4.64	0.29	16	yes
2025-12-13 22:56:57.381666+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	41.18	0.29	142	yes
2025-12-13 22:56:57.381666+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	6.38	0.29	22	yes
2025-12-13 22:56:04.379888+00	How low will Bitcoin get this year?	Below $80,000	0.42	0.21	2	yes
2025-12-13 22:56:04.135029+00	Will Bitcoin be above $250000 by Jan 1, 2027 at 12:00AM ET?	Above $250000	0.7	0.1	7	yes
2025-12-13 22:56:04.135029+00	Will Bitcoin be above $250000 by Jan 1, 2027 at 12:00AM ET?	Above $250000	0.2	0.1	2	yes
2025-12-13 22:56:04.135029+00	Will Bitcoin be above $250000 by Jan 1, 2027 at 12:00AM ET?	Above $250000	1.6	0.1	16	yes
2025-12-13 22:55:48.518074+00	How low will Bitcoin get this year?	Below $70,000	0.15	0.05	3	yes
2025-12-13 22:55:42.969922+00	How high will Bitcoin get this year?	$130,000 or above	0.19	0.01	19	no
2025-12-13 22:55:32.652519+00	How low will Bitcoin get this year?	Below $60,000	0.12	0.04	3	yes
2025-12-13 22:55:18.715308+00	Will Bitcoin be above $200000 by Jan 1, 2027 at 11:59PM ET?	Above $200000	3.6	0.18	20	yes
2025-12-13 22:55:16.092374+00	How low will Bitcoin get this year?	Below $80,000	1	0.2	5	yes
2025-12-13 22:54:59.883067+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	47.56	0.29	164	yes
2025-12-13 22:54:49.292294+00	How low will Bitcoin get this year?	Below $50,000	0.02	0.02	1	yes
2025-12-13 22:54:42.453618+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	75.98	0.29	262	yes
2025-12-13 22:54:36.069034+00	How low will Bitcoin get this year?	Below $60,000	0.08	0.04	2	yes
2025-12-13 22:54:20.63762+00	How low will Bitcoin get this year?	Below $70,000	0.1	0.05	2	yes
2025-12-13 22:53:22.981031+00	When will Bitcoin hit $150k?	Before June 2026	0.2	0.2	1	yes
2025-12-13 22:53:22.981031+00	When will Bitcoin hit $150k?	Before June 2026	14	0.2	70	yes
2025-12-13 22:53:09.094652+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	20.3	0.29	70	yes
2025-12-13 22:50:05.219059+00	How low will Bitcoin get this year?	Below $70,000	4.65	0.05	93	yes
2025-12-13 22:49:51.339221+00	How low will Bitcoin get this year?	Below $80,000	14.07	0.21	67	yes
2025-12-13 22:49:20.000633+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	4.64	0.29	16	yes
2025-12-13 22:48:24.939633+00	How high will Bitcoin get this year?	$150,000 or above	2.4	0.02	120	yes
2025-12-13 22:48:05.773758+00	How high will Bitcoin get this year?	$130,000 or above	2.5	0.02	125	yes
2025-12-13 22:47:07.163803+00	How high will Bitcoin get this year?	$150,000 or above	6.86	0.02	343	yes
2025-12-13 22:47:07.163803+00	How high will Bitcoin get this year?	$150,000 or above	3.23	0.01	323	yes
2025-12-13 22:46:13.470988+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.27	0.27	1	no
2025-12-13 22:45:20.139189+00	How low will Ethereum get this year?	Below $2,000	4	0.04	100	yes
2025-12-13 22:44:47.591121+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.27	0.27	1	no
2025-12-13 22:43:44.572696+00	How high will Bitcoin get this year?	$130,000 or above	0.5	0.02	25	yes
2025-12-13 22:43:12.052129+00	How low will Ethereum get this year?	Below $2,250	35	0.07	500	no
2025-12-13 22:42:47.682831+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	2.61	0.29	9	yes
2025-12-13 22:42:00.458999+00	Will Bitcoin be above $$100,000 by Dec 31, 2025 at 11:59pm ET?	Above $100,000	0.29	0.29	1	yes
2025-12-13 22:41:57.611546+00	How high will Bitcoin get this year?	$130,000 or above	1.4	0.01	140	no
2025-12-13 22:41:28.021256+00	Will Joe Rogan launch a new digital asset before 2026?	Joe Rogan	0.44	0.04	11	yes
2025-12-13 22:41:06.012287+00	Will MrBeast launch a new digital asset before 2026?	MrBeast	0.42	0.06	7	yes
2025-12-13 22:40:20.584227+00	How low will Bitcoin get this year?	Below $80,000	0.19	0.19	1	no
2025-12-13 22:40:18.343009+00	How high will Bitcoin get this year?	$130,000 or above	0.01	0.01	1	no
2025-12-13 22:39:31.310004+00	How high will Bitcoin get this year?	$130,000 or above	0.6	0.02	30	yes
2025-12-13 22:38:25.928064+00	Which cryptocurrencies will have positive return this year?	Bitcoin	4.4	0.44	10	yes
2025-12-13 22:37:25.503135+00	How low will Bitcoin get this year?	Below $80,000	50.19	0.21	239	no
2025-12-13 22:37:25.503135+00	How low will Bitcoin get this year?	Below $80,000	0.42	0.21	2	no
2025-12-13 22:37:16.60468+00	How low will Bitcoin get this year?	Below $80,000	11.13	0.21	53	yes
2025-12-13 22:37:11.723892+00	How low will Bitcoin get this year?	Below $80,000	42.94	0.19	226	no