Loading dataset
Updated

56.1 MB across 63 parts, newest sealed 22 October 2026 at 10:06 UTC.

The recorder has sealed 63 parts. The table now holds 2.8M rows.

ticker

string

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

  • KXXRP-26SEP2517-B1.38995001%
  • KXXRP-26OCT0217-B1.54995001%
  • KXXRP-26SEP2517-B1.34995001%
  • Other (3,060)
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
3,072 · 0.1% of valid

timestamp_ms

integer

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

Histogram: 1789055666000 to 1789506641611, 428,498; 1789506641611 to 1789957617222, 470,906; 1789957617222 to 1790408592833, 705,090; 1790408592833 to 1790859568444, 471,945; 1790859568444 to 1791310544055, 225,340; 1791310544055 to 1791761519666, 204,796; 1791761519666 to 1792212495277, 281,799; 1792212495277 to 1792663470888, 3,216
17890556660001792663470888
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
2,541,087 · 91% of valid
Min
1789055666000
25%
1789827926535
Median
1790256106395
75%
1790867730909
Max
1792663470888

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 2150.375, 2,342,742; 2150.375 to 4299.75, 354,880; 4299.75 to 6449.125, 57,579; 6449.125 to 8598.5, 11,139; 8598.5 to 10747.875, 9,016; 10747.875 to 12897.25, 6,834; 12897.25 to 15046.625, 5,402; 15046.625 to 17196, 3,998
117196
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
16,615 · 0.6% of valid
Min
1
25%
206
Median
652
75%
1538
Max
17196

best_bid

integer

Best YES bid in cents, 0 to 100.

Histogram: 1 to 13.25, 1,144,310; 13.25 to 25.5, 302,769; 25.5 to 37.75, 208,303; 37.75 to 50, 201,116; 50 to 62.25, 238,847; 62.25 to 74.5, 197,113; 74.5 to 86.75, 192,077; 86.75 to 99, 168,421
199
Valid
2,652,956 · 95%
Missing
138,634 · 5%
Distinct
99 · 0% of valid
Min
1
25%
5
Median
20
75%
57
Max
99

best_ask

integer

Best YES ask in cents, 0 to 100.

Histogram: 1 to 13.25, 762,891; 13.25 to 25.5, 464,003; 25.5 to 37.75, 256,621; 37.75 to 50, 207,347; 50 to 62.25, 251,269; 62.25 to 74.5, 259,155; 74.5 to 86.75, 239,119; 86.75 to 99, 340,433
199
Valid
2,780,838 · 99.6%
Missing
10,752 · 0.4%
Distinct
99 · 0% of valid
Min
1
25%
13
Median
33
75%
69
Max
99

bid_depth

integer

Total resting contracts on the YES bid side.

Histogram: 0 to 2526.125, 1,631,994; 2526.125 to 5052.25, 480,194; 5052.25 to 7578.375, 523,105; 7578.375 to 10104.5, 70,813; 10104.5 to 12630.625, 49,602; 12630.625 to 15156.75, 31,613; 15156.75 to 17682.875, 3,101; 17682.875 to 20209, 1,168
020209
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
13,064 · 0.5% of valid
Min
0
25%
37
Median
2245
75%
5003
Max
20209

ask_depth

integer

Total resting contracts on the YES ask side.

Histogram: 0 to 3964.875, 1,843,905; 3964.875 to 7929.75, 831,345; 7929.75 to 11894.625, 75,916; 11894.625 to 15859.5, 18,132; 15859.5 to 19824.375, 3,718; 19824.375 to 23789.25, 1,601; 23789.25 to 27754.125, 7,820; 27754.125 to 31719, 9,153
031719
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
14,845 · 0.5% of valid
Min
0
25%
85
Median
2270
75%
5559
Max
31719

yes_bids

string

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

  • []5%
  • [{"price":1,"size":5000}]3%
  • [{"price":2,"size":5000}]3%
  • Other (634,262)
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
634,274 · 22.7% of valid

yes_asks

string

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

  • [{"price":95,"size":400}]1%
  • [{"price":94,"size":83},{"price":95,"size":100}]1%
  • [{"price":95,"size":100}]1%
  • Other (833,794)
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
833,806 · 29.9% of valid

ingest_time_ms

integer

When the recorder received the frame, epoch milliseconds.

Histogram: 1789055666000 to 1789506641500, 428,498; 1789506641500 to 1789957617000, 470,906; 1789957617000 to 1790408592500, 705,090; 1790408592500 to 1790859568000, 471,945; 1790859568000 to 1791310543500, 225,340; 1791310543500 to 1791761519000, 204,796; 1791761519000 to 1792212494500, 281,799; 1792212494500 to 1792663470000, 3,216
17890556660001792663470000
Valid
2,791,590 · 100%
Missing
0 · 0%
Distinct
1,281,376 · 45.9% of valid
Min
1789055666000
25%
1789827926000
Median
1790256106000
75%
1790867730000
Max
1792663470000