Baselight
Sign In

Query Result

1select trades.created_time as "Timestamp", markets.title as "Market", markets.yes_sub_title as "Market - Subtitle", format('${:,.0f}', price * count) 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 price * count DESC
5limit 100
TimestampMarketMarket - SubtitleCost (USD)pricecounttaker_side
2025-11-05 02:23:33.58321+00Will a representative of the Democratic party win the NYC Mayor race in 2025?Zohran Mamdani$3,096,5450.993127823yes
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$2,613,9330.972694776no
2024-12-05 23:46:33.33961+00Will Donald Trump or another Republican win the Presidency?Donald Trump$2,205,1030.992227377no
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$1,342,6000.981370000yes
2024-11-15 20:58:36.735236+00Will the Republican party win the popular vote?Donald Trump$1,316,3670.981343232yes
2024-11-15 20:58:36.735236+00Will the Republican party win the popular vote?Donald Trump$1,171,8370.981195752yes
2024-11-19 14:51:37.648906+00Will the Republican party win Georgia in the presidential election?Donald Trump$990,0000.991000000yes
2024-12-05 23:46:33.33961+00Will Donald Trump or another Republican win the Presidency?Donald Trump$987,6470.99997623no
2025-01-01 04:22:12.548783+00Will Democratics win the Senate race in Arizona?Ruben Gallego$987,4620.99997436no
2024-12-05 23:11:20.934583+00Will Donald Trump or another Republican win the Presidency?Donald Trump$985,8300.99995788yes
2024-11-15 20:58:36.735236+00Will the Republican party win the popular vote?Donald Trump$980,0000.981000000yes
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$980,0000.981000000yes
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$980,0000.981000000yes
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$980,0000.981000000yes
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$980,0000.981000000yes
2024-11-15 20:58:36.735236+00Will the Republican party win the popular vote?Donald Trump$980,0000.981000000yes
2025-11-08 23:04:19.281209+00Louisiana Tech at Delaware Winner?Louisiana Tech$949,0530.99958639no
2026-02-28 05:32:39.527289+00Denver at Oklahoma City Winner?Oklahoma City$792,0000.99800000no
2024-12-23 14:52:08.595337+00Will the popular vote margin of victory for be between -1.00 and -1.99?Trump by 1-1.99%$792,0000.99800000no
2024-11-18 17:56:16.384923+00Will Donald Trump or another Republican win the Presidency?Donald Trump$786,3470.98802395yes
2025-11-07 04:02:48.730914+00Georgia Southern at Appalachian St. Winner?Georgia Southern$670,5330.99677306no
2025-01-01 04:21:32.74864+00Will Democratics win the Senate race in Arizona?Ruben Gallego$653,1510.99659748no
2026-02-25 12:47:23.057683+00Will Nick Shirley attend the 2026 State of the Union Address?Nick Shirley$639,2290.99645686yes
2026-03-11 18:18:35.016022+00Will the Federal Reserve Hike rates by 0bps at their March 2026 meeting?Fed maintains rate$633,3420.99639739yes
2024-11-08 01:44:58.155951+00Will Donald Trump or another Republican win the Presidency?Donald Trump$625,0730.97644405no
2025-11-07 04:01:20.371699+00Georgia Southern at Appalachian St. Winner?Georgia Southern$619,1130.99625367no
2024-11-14 13:00:14.728532+00Will Donald Trump or another Republican win the Presidency?Donald Trump$604,1240.97622808no
2024-11-14 13:20:35.63905+00Will the Republican party win the popular vote?Donald Trump$580,1230.98591962yes
2025-11-05 02:23:33.58321+00Will a representative of the Democratic party win the NYC Mayor race in 2025?Zohran Mamdani$554,3820.99559982yes
2024-11-22 03:06:48.708461+00Will Democratics win the Senate race in Arizona?Ruben Gallego$495,0000.99500000no
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-19 14:51:37.648906+00Will the Republican party win Georgia in the presidential election?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2025-01-01 04:46:48.694599+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000no
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-19 14:51:37.648906+00Will the Republican party win Georgia in the presidential election?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2025-02-10 02:18:52.328487+00Will the Philadelphia Eagles win the Super Bowl?Philadelphia$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2025-11-05 02:23:33.58321+00Will a representative of the Democratic party win the NYC Mayor race in 2025?Zohran Mamdani$495,0000.99500000yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$495,0000.99500000yes
2025-11-08 20:36:54.568285+00Indiana at Penn St. Winner?Indiana$490,0000.98500000yes
2025-11-11 13:48:09.876251+00Will the federal government shut down for fewer than 92 days?Yes$490,0000.98500000yes
2025-11-06 16:00:57.441782+00Mercyhurst at Loyola Chicago Winner?Loyola Chicago$490,0000.98500000no
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$485,0000.97500000no
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$485,0000.97500000no
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$485,0000.97500000no
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$485,0000.97500000no
2024-11-07 02:43:50.932126+00Will Donald Trump or another Republican win the Presidency?Donald Trump$471,3800.98481000yes
2024-11-04 18:44:35.831925+00Will Kamala Harris or another Democrat win the Presidency?Kamala Harris$460,0000.461000000yes
2024-11-13 16:41:40.835852+00Will Donald Trump or another Republican win the Presidency?Donald Trump$456,9440.97471076no
2025-07-04 15:32:35.75339+00Will the Joey Chestnut win the Nathan's Hot Dog Eating Contest?Joey Chestnut$454,0580.95477956yes
2026-02-09 02:56:16.743835+00Will the Seattle win the 2026 Pro Football Championship?Seattle$441,3520.98450359no
2024-11-06 03:34:50.445306+00Will Donald Trump or another Republican win the Presidency?Donald Trump$432,8700.98441704yes
2024-11-04 18:44:35.831925+00Will Kamala Harris or another Democrat win the Presidency?Kamala Harris$428,4760.46931470yes
2024-11-14 14:59:43.944131+00Will the Republican party win Florida in the presidential election?Donald Trump$423,2150.98431852no
2024-11-04 15:47:07.456296+00Will Kamala Harris or another Democrat win the Presidency?Kamala Harris$420,0000.421000000no
2025-11-09 06:26:21.935907+00Sam Houston at Oregon St. Winner?Sam Houston$415,1460.99419339no
2024-12-23 14:40:45.864096+00Will the popular vote margin of victory for be between 1.25 and 1.49?Trump by 1.25-1.49%$412,4130.99416579no
2025-12-30 02:47:05.621428+00Los Angeles R at Atlanta Winner?Atlanta$410,0000.82500000no
2025-02-10 02:18:53.031285+00Will the Philadelphia Eagles win the Super Bowl?Philadelphia$402,0700.99406131yes
2024-11-01 20:12:37.854008+00Will Donald Trump or another Republican win the Presidency?Donald Trump$397,8030.55723278no
2026-01-23 04:11:10.780393+00Los Angeles L at Los Angeles C Winner?Los Angeles C$397,6940.9441882no
2026-01-01 23:19:27.392411+00Alabama at Indiana Winner?Indiana$396,0000.99400000no
2024-11-19 14:53:54.629638+00Will the Republican party win Michigan in the presidential election?Donald Trump$396,0000.99400000yes
2026-02-08 05:23:15.477942+00Cleveland at Sacramento Winner?Cleveland$396,0000.99400000no
2025-12-04 04:47:58.175865+00Will d4vd be the #1 rank on Google’s Year in Search 2025 Global – People?d4vd$396,0000.99400000no
2024-11-06 05:43:17.925151+00Will the Republican party win Georgia in the presidential election?Donald Trump$396,0000.99400000yes
2026-01-02 04:55:42.424287+00Ole Miss at Georgia Winner?Ole Miss$395,9010.99399900no
2026-01-15 04:57:09.999883+00Denver at Dallas Winner?Denver$395,9010.99399900no
2026-02-28 05:32:39.527289+00Denver at Oklahoma City Winner?Oklahoma City$395,9010.99399900no
2024-11-06 13:09:00.534539+00Will Donald Trump or another Republican win the Presidency?Donald Trump$392,7520.99396719yes
2025-12-02 02:58:36.705852+00New York G at New England Winner?New England$392,0000.98400000no
2024-11-19 14:53:54.629638+00Will the Republican party win Michigan in the presidential election?Donald Trump$380,6550.99384500yes
2026-01-02 14:22:10.037442+00Rice at Texas St. Winner?Texas St.$377,4190.85444022yes
2024-11-04 17:31:05.144936+00Will Kamala Harris or another Democrat win the Presidency?Kamala Harris$372,1530.47791815yes
2024-11-14 13:20:35.63905+00Will the Republican party win the popular vote?Donald Trump$361,8590.98369244yes
2026-01-18 01:21:42.186386+00San Francisco at Seattle Winner?Seattle$360,0000.72500000yes
2025-12-10 16:12:35.871457+00Will the Federal Reserve Cut rates by 25bps at their December 2025 meeting?Cut 25bps$359,4960.98366833yes
2024-11-26 14:13:47.329164+00Will the Republican party win the popular vote?Donald Trump$356,4000.99360000yes
2025-07-04 15:11:10.27622+00Will the Joey Chestnut win the Nathan's Hot Dog Eating Contest?Joey Chestnut$350,4460.93376824yes
2026-01-15 04:57:09.999883+00Denver at Dallas Winner?Denver$350,2640.99353802no
2026-02-13 06:01:52.793234+00Will the US government be shut down on Feb 14, 2026?Yes$349,7710.94372097no
2026-01-08 05:19:12.289186+00Milwaukee at Golden State Winner?Golden State$349,3900.99352919no
2025-11-08 23:57:29.922581+00Duke at UConn Winner?UConn$347,1850.99350692no
2024-11-09 13:47:38.505627+00Will Donald Trump or another Republican win the Presidency?Donald Trump$343,8760.98350894yes
2026-01-11 19:55:56.275823+00San Francisco at Philadelphia Winner?Philadelphia$342,7130.69496686no
2026-01-11 05:22:51.756739+00BYU wins by over 4.5 Points?BYU wins by over 4.5 Points$340,6360.99344077no
2025-10-27 21:18:20.543179+00Washington at Kansas City Winner?Kansas City$338,2120.84402633yes
2026-01-04 20:14:11.100005+00Green Bay at Minnesota Winner?Minnesota$336,5010.99339900no
2025-11-05 02:23:33.58321+00Will a representative of the Democratic party win the NYC Mayor race in 2025?Zohran Mamdani$334,7860.99338168yes
2024-11-21 18:17:12.193549+00Will the Republican party win the popular vote?Donald Trump$331,3180.98338080no
2024-10-15 20:02:49.160268+00Will Donald Trump or another Republican win the Presidency?Donald Trump$330,0000.55600000no
2024-11-07 23:50:33.513578+00Will Donald Trump or another Republican win the Presidency?Donald Trump$318,0900.97327928no
2026-03-11 14:57:01.830393+00Will the Federal Reserve Hike rates by 0bps at their March 2026 meeting?Fed maintains rate$317,2990.99320504yes
2025-11-16 05:06:46.701025+00San Francisco at Arizona Winner?San Francisco$315,0000.63500000yes

Share link

Anyone who has the link will be able to view this.