Loading dataset
Updated

62.4 MB across 68 parts, newest sealed 24 October 2026 at 18:38 UTC.

The recorder has sealed 68 parts. The table now holds 3.8M rows.

ticker

string

Kalshi market ticker in series KXSOLE, naming the contract window and the strike.

  • KXSOLE-26SEP2517-B1141%
  • KXSOLE-26OCT0217-B1201%
  • KXSOLE-26SEP1817-B991%
  • Other (6,644)
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
6,656 · 0.2% of valid

timestamp_ms

integer

Venue event time in epoch milliseconds (the delta's ts_ms; recorder arrival time for the opening snapshot).

Histogram: 1789055648000 to 1789532075530.125, 768,520; 1789532075530.125 to 1790008503060.25, 686,082; 1790008503060.25 to 1790484930590.375, 707,222; 1790484930590.375 to 1790961358120.5, 573,240; 1790961358120.5 to 1791437785650.625, 228,622; 1791437785650.625 to 1791914213180.75, 389,489; 1791914213180.75 to 1792390640710.875, 331,435; 1792390640710.875 to 1792867068241, 112,427
17890556480001792867068241
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
3,208,358 · 84.5% of valid
Min
1789055648000
25%
1789720614592
Median
1790262449226
75%
1791192355427
Max
1792867068241

sequence

integer

Position of the last event of this second in the recording's arrival order (one order across every sealed segment; the venue's own sequence restarts on every connection).

Histogram: 1 to 2157.125, 3,585,234; 2157.125 to 4313.25, 153,909; 4313.25 to 6469.375, 26,513; 6469.375 to 8625.5, 11,076; 8625.5 to 10781.625, 6,719; 10781.625 to 12937.75, 5,793; 12937.75 to 15093.875, 4,616; 15093.875 to 17250, 3,177
117250
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
16,498 · 0.4% of valid
Min
1
25%
136
Median
363
75%
791
Max
17250

best_bid

integer

Best YES bid in cents, 0 to 100.

Histogram: 1 to 13.25, 2,364,216; 13.25 to 25.5, 614,626; 25.5 to 37.75, 237,485; 37.75 to 50, 104,189; 50 to 62.25, 52,814; 62.25 to 74.5, 26,367; 74.5 to 86.75, 15,769; 86.75 to 99, 11,636
199
Valid
3,427,102 · 90.3%
Missing
369,935 · 9.7%
Distinct
99 · 0% of valid
Min
1
25%
3
Median
7
75%
16
Max
99

best_ask

integer

Best YES ask in cents, 0 to 100.

Histogram: 1 to 13.25, 1,737,444; 13.25 to 25.5, 981,819; 25.5 to 37.75, 392,267; 37.75 to 50, 165,216; 50 to 62.25, 85,081; 62.25 to 74.5, 118,283; 74.5 to 86.75, 41,984; 86.75 to 99, 258,929
199
Valid
3,781,023 · 99.6%
Missing
16,014 · 0.4%
Distinct
99 · 0% of valid
Min
1
25%
10
Median
15
75%
28
Max
99

bid_depth

integer

Total resting contracts on the YES bid side.

Histogram: 0 to 2658.75, 2,159,458; 2658.75 to 5317.5, 1,049,646; 5317.5 to 7976.25, 278,300; 7976.25 to 10635, 142,280; 10635 to 13293.75, 134,808; 13293.75 to 15952.5, 31,857; 15952.5 to 18611.25, 313; 18611.25 to 21270, 375
021270
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
13,079 · 0.3% of valid
Min
0
25%
20
Median
2027
75%
5239
Max
21270

ask_depth

integer

Total resting contracts on the YES ask side.

Histogram: 0 to 9362.25, 3,770,309; 9362.25 to 18724.5, 25,247; 18724.5 to 28086.75, 1,045; 28086.75 to 37449, 317; 37449 to 46811.25, 62; 46811.25 to 56173.5, 26; 56173.5 to 65535.75, 22; 65535.75 to 74898, 9
074898
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
11,511 · 0.3% of valid
Min
0
25%
264
Median
2057
75%
5905
Max
74898

yes_bids

string

JSON array of {price, size} YES bid levels in cents and contracts, best first.

  • []10%
  • [{"price":1,"size":5000}]6%
  • [{"price":2,"size":5000}]4%
  • Other (246,016)
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
246,028 · 6.5% of valid

yes_asks

string

JSON array of {price, size} YES ask levels in cents and contracts, best first.

  • [{"price":95,"size":400}]4%
  • [{"price":9,"size":5000},{"price":95,"size":400}]2%
  • [{"price":10,"size":5000},{"price":95,"size":400}]1%
  • Other (597,836)
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
597,848 · 15.7% of valid

ingest_time_ms

integer

When the recorder received the frame, epoch milliseconds.

Histogram: 1789055648000 to 1789532075500, 768,520; 1789532075500 to 1790008503000, 686,078; 1790008503000 to 1790484930500, 707,226; 1790484930500 to 1790961358000, 573,240; 1790961358000 to 1791437785500, 228,622; 1791437785500 to 1791914213000, 389,489; 1791914213000 to 1792390640500, 331,435; 1792390640500 to 1792867068000, 112,427
17890556480001792867068000
Valid
3,797,037 · 100%
Missing
0 · 0%
Distinct
1,371,764 · 36.1% of valid
Min
1789055648000
25%
1789720614000
Median
1790262449000
75%
1791192355000
Max
1792867068000