Baselight
Sign In

Query Result

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)
4ORDER By trades.created_time DESC
5limit 100
TimestampMarketMarket - SubtitleCost (USD)pricecounttaker_side
2026-06-14 11:28:46.698754+00yes Josh Hokit,yes Diego Lopes,yes Kyle Daukaus,yes Sean O'Malley,yes Ciryl Gane,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQyes Josh Hokit,yes Diego Lopes,yes Kyle Daukaus,yes Sean O'Malley,yes Ciryl Gane,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 09:59:03.700531+00yes Kyle Daukaus,yes Aiemann Zahabi,yes Alex Pereira,yes Michael Chandler,yes Ilia Topuriayes Kyle Daukaus,yes Aiemann Zahabi,yes Alex Pereira,yes Michael Chandler,yes Ilia Topurianullnullnullyes
2026-06-14 09:42:26.702901+00yes Josh Hokit,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 3yes Josh Hokit,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 3nullnullnullyes
2026-06-14 08:50:16.574108+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 08:50:16.574108+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 08:50:16.574108+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 08:43:17.695719+00yes Steve Garcia,yes Kyle Daukaus,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topuriayes Steve Garcia,yes Kyle Daukaus,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topurianullnullnullyes
2026-06-14 08:31:49.702804+00yes Diego Lopes,yes Kyle Daukaus,yes Alex Pereira,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQyes Diego Lopes,yes Kyle Daukaus,yes Alex Pereira,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 08:25:53.712502+00yes Diego Lopes,yes Kyle Daukaus,yes Alex Pereira,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQyes Diego Lopes,yes Kyle Daukaus,yes Alex Pereira,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 07:38:27.717145+00yes Derrick Lewis,yes Diego Lopes,yes Sean O'Malley,yes Alex Pereira,yes Decisionyes Derrick Lewis,yes Diego Lopes,yes Sean O'Malley,yes Alex Pereira,yes Decisionnullnullnullyes
2026-06-14 07:37:34.706689+00yes Josh Hokit,yes Sean O'Malley,yes Alex Pereira,yes Ilia Topuria,yes KO/TKO/DQ,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQyes Josh Hokit,yes Sean O'Malley,yes Alex Pereira,yes Ilia Topuria,yes KO/TKO/DQ,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 07:29:36.690152+00Will average price of electricity per kilowatt-hour in the U.S. city average for June 2026 be above 19.4¢?Above 19.4¢nullnullnullno
2026-06-14 07:18:32.707657+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 07:12:38.727648+00yes Bo Nickal,yes Ciryl Gane,yes Mauricio Ruffy,yes Justin Gaethjeyes Bo Nickal,yes Ciryl Gane,yes Mauricio Ruffy,yes Justin Gaethjenullnullnullyes
2026-06-14 07:09:56.805133+00Will average price of electricity per kilowatt-hour in the U.S. city average for June 2026 be above 19.2¢?Above 19.2¢nullnullnullyes
2026-06-14 07:09:25.253576+00Will average price of electricity per kilowatt-hour in the U.S. city average for June 2026 be above 19.2¢?Above 19.2¢nullnullnullyes
2026-06-14 07:04:57.700246+00yes Sean O'Malley,yes Alex Pereira,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 4,yes Fight ends before round 5yes Sean O'Malley,yes Alex Pereira,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 4,yes Fight ends before round 5nullnullnullyes
2026-06-14 07:00:50.701361+00yes Diego Lopes,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQyes Diego Lopes,yes Sean O'Malley,yes Mauricio Ruffy,yes Ilia Topuria,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 06:55:44.698961+00yes Bo Nickal,yes KO/TKO/DQyes Bo Nickal,yes KO/TKO/DQnullnullnullyes
2026-06-14 06:54:29.700675+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 06:53:39.706487+00yes Ecuador,yes Curacao,yes Tieyes Ecuador,yes Curacao,yes Tienullnullnullyes
2026-06-14 06:47:11.726767+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 06:45:07.716865+00yes Germany,yes Spain,yes Uruguay,yes Argentina,yes France,yes Norway,yes Portugalyes Germany,yes Spain,yes Uruguay,yes Argentina,yes France,yes Norway,yes Portugalnullnullnullyes
2026-06-14 06:44:46.701388+00yes Mexico,yes Germany,yes Belgium,yes Spain,yes Uruguay,yes Argentina,yes France,yes Norway,yes Portugal,yes Colombia,yes Brazil,yes Germany,yes Netherlands,yes Belgium,yes Spain,yes Uruguay,yes Argentina,yes England,yes Portugalyes Mexico,yes Germany,yes Belgium,yes Spain,yes Uruguay,yes Argentina,yes France,yes Norway,yes Portugal,yes Colombia,yes Brazil,yes Germany,yes Netherlands,yes Belgium,yes Spain,yes Uruguay,yes Argentina,yes England,yes Portugalnullnullnullyes
2026-06-14 06:24:44.701757+00yes Over 1.5 goals scored,yes Over 4.5 goals scored,yes Over 2.5 goals scoredyes Over 1.5 goals scored,yes Over 4.5 goals scored,yes Over 2.5 goals scorednullnullnullyes
2026-06-14 06:20:06.718014+00yes Ecuador,yes Germany,yes Belgium,yes Spain,yes Argentina,yes France,yes Portugal,yes Colombiayes Ecuador,yes Germany,yes Belgium,yes Spain,yes Argentina,yes France,yes Portugal,yes Colombianullnullnullyes
2026-06-14 06:18:41.701265+00yes Over 4.5 goals scored,yes Over 2.5 goals scoredyes Over 4.5 goals scored,yes Over 2.5 goals scorednullnullnullyes
2026-06-14 06:16:12.713159+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 06:14:23.721098+00yes Australia,yes Spainyes Australia,yes Spainnullnullnullno
2026-06-14 06:13:23.706086+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 06:08:48.731493+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 06:08:33.786049+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 06:06:25.881393+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 06:06:25.881393+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 06:06:25.881393+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 06:06:25.881393+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 06:06:22.736699+00yes Ecuador,yes Curacao,yes Tieyes Ecuador,yes Curacao,yes Tienullnullnullyes
2026-06-14 06:06:21.716391+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 06:05:18.551313+00Will David Bransdon win the Principal Charity Classic?David Bransdonnullnullnullyes
2026-06-14 06:05:00.701916+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguayyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguaynullnullnullyes
2026-06-14 06:02:13.707018+00yes Derrick Lewis,yes Steve Garcia,yes Sean O'Malley,yes Alex Pereira,yes Michael Chandler,yes Justin Gaethje,yes KO/TKO/DQ,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 2,yes Fight ends before round 2yes Derrick Lewis,yes Steve Garcia,yes Sean O'Malley,yes Alex Pereira,yes Michael Chandler,yes Justin Gaethje,yes KO/TKO/DQ,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQ,yes Fight ends before round 2,yes Fight ends before round 2nullnullnullyes
2026-06-14 05:59:50.715389+00yes Tie,yes Germany,yes Japanyes Tie,yes Germany,yes Japannullnullnullyes
2026-06-14 05:57:59.72035+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:57:47.700426+00yes Diego Lopes,yes Bo Nickal,yes Alex Pereira,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQyes Diego Lopes,yes Bo Nickal,yes Alex Pereira,yes Decision,yes KO/TKO/DQ,yes KO/TKO/DQnullnullnullyes
2026-06-14 05:57:16.73816+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:56:35.704694+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:54:46.951252+00What will the announcers say during Alex Pereira vs Ciryl Gane UFC Fight?Trump / Presidentnullnullnullyes
2026-06-14 05:53:03.705631+00yes Ecuador,yes Curacao,yes Tieyes Ecuador,yes Curacao,yes Tienullnullnullyes
2026-06-14 05:52:44.713073+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:51:47.720113+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:51:24.70411+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:51:19.759979+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullyes
2026-06-14 05:50:30.732496+00yes France,yes Portugal,yes Mexicoyes France,yes Portugal,yes Mexiconullnullnullyes
2026-06-14 05:50:27.717265+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullno
2026-06-14 05:50:25.730336+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguayyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguaynullnullnullyes
2026-06-14 05:50:07.713699+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:49:33.718062+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainnullnullnullyes
2026-06-14 05:48:56.701193+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:47:35.733349+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:46:37.745092+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainnullnullnullyes
2026-06-14 05:45:33.709386+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:45:10.767807+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainnullnullnullyes
2026-06-14 05:44:42.709551+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:43:03.795165+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainnullnullnullyes
2026-06-14 05:42:41.737334+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:41:37.735106+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguayyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguaynullnullnullyes
2026-06-14 05:41:18.728688+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:50.728007+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:28.714756+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:27.708833+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:15.728497+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:02.71672+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:40:00.760423+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:39:36.715931+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:39:05.720663+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullyes
2026-06-14 05:38:17.697126+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguayyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguaynullnullnullyes
2026-06-14 05:37:57.700574+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:37:21.729758+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:36:49.770511+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:36:05.718711+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguayyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Belgium,yes Spain,yes Uruguaynullnullnullyes
2026-06-14 05:35:46.726321+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:35:44.712042+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Sweden,yes Spainnullnullnullyes
2026-06-14 05:35:14.75419+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullno
2026-06-14 05:35:08.728772+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullno
2026-06-14 05:35:05.731505+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:34:57.731248+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullno
2026-06-14 05:34:28.099473+00yes Australia,yes Spainyes Australia,yes Spainnullnullnullyes
2026-06-14 05:34:03.706368+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:33:57.702174+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullyes
2026-06-14 05:33:32.731734+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:33:29.714443+00yes Ecuador,yes Netherlands,yes Sweden,yes Belgium,yes Uruguay,yes Argentina,yes France,yes Norwayyes Ecuador,yes Netherlands,yes Sweden,yes Belgium,yes Uruguay,yes Argentina,yes France,yes Norwaynullnullnullyes
2026-06-14 05:33:26.774724+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullno
2026-06-14 05:33:25.702853+00yes Australia,yes Spainyes Australia,yes Spainnullnullnullyes
2026-06-14 05:33:16.704074+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullno
2026-06-14 05:32:16.724624+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:30:42.730618+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:30:28.732873+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:30:15.701845+00yes Both Teams To Score,yes Turkiyeyes Both Teams To Score,yes Turkiyenullnullnullyes
2026-06-14 05:29:46.730324+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes
2026-06-14 05:29:46.700171+00yes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedenyes Australia,yes Ecuador,yes Germany,yes Netherlands,yes Swedennullnullnullyes

Share link

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