Hamilton mayoral election winner is a one-time elections series on Kalshi, with markets like “Will David Mark Cherkewski win the 2026 Hamilton mayoral election?”. The Kalshi Eye archive lists 13 of its markets and has 12 days of daily Parquet files from October 12, 2026 to October 23, 2026 (4 MB), with every order book change and trade.

Venue: Kalshi, series KXHAMILTONMAYOR
Category: Elections, one-time
Markets: 13 (0 settled, 13 open)
Files: 12 days, October 12, 2026 to October 23, 2026, 4 MB, 379,672 rows
Datasets: Order book (L2, incremental), Order book snapshots (top 10, 1 second), Top of book (every change), Top of book (1-minute bars), Trades

Open Hamilton mayoral election winner in Markets to see every day and market, then export the days you need. Free sample files of each dataset are on the Kalshi data page.

Reading the files

Every KXHAMILTONMAYOR trade on October 23, 2026, in DuckDB:

SELECT ts_recv, ticker, yes_price, size, taker_side
FROM 'kalshieye-data/trades/date=2026-10-23/series=KXHAMILTONMAYOR/trades-KXHAMILTONMAYOR-2026-10-23.parquet'
ORDER BY ts_recv;

To test a strategy on this series, see How to backtest Kalshi markets.

Related Kalshi series

Vote percentages in US general elections (KXVOTEGENERAL): 9,314 markets, 12 days of files
Midterm margin of victory (KXMIDTERMMOV): 5,190 markets, 12 days of files
Midterm Voter Turnout (KXMIDTERMVOTETURN): 4,951 markets, 12 days of files
House Race Winner? (KXHOUSERACE): 708 markets, 12 days of files
County vote percentages (KXVOTECOUNTY): 460 markets, 12 days of files
Which state ballot measures will pass? (KXSTATEBALLOTMEASURE): 125 markets, 12 days of files

Figures as of October 24, 2026. All Kalshi series with pages are listed on Kalshi series.