Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

2.5 MB across 64 parts, newest sealed 8 November 2026 at 22:44 UTC.

The recorder has sealed 64 parts. The table now holds 232,374 rows.

ticker

string

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

  • KXSHIBAD-26NOV0817-T0.0000034992%
  • KXSHIBAD-26NOV0817-T0.0000029992%
  • KXSHIBAD-26NOV0717-T0.0000029992%
  • Other (527)
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
539 · 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: 1789055647000 to 1789695912456.5, 25,835; 1789695912456.5 to 1790336177913, 18,896; 1790336177913 to 1790976443369.5, 22,073; 1790976443369.5 to 1791616708826, 21,950; 1791616708826 to 1792256974282.5, 42,533; 1792256974282.5 to 1792897239739, 0; 1792897239739 to 1793537505195.5, 417; 1793537505195.5 to 1794177770652, 100,670
17890556470001794177770652
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
142,062 · 61.1% of valid
Min
1789055647000
25%
1790770593000
Median
1791965795000
75%
1793947259879
Max
1794177770652

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 2062.875, 231,040; 2062.875 to 4124.75, 836; 4124.75 to 6186.625, 371; 6186.625 to 8248.5, 18; 8248.5 to 10310.375, 31; 10310.375 to 12372.25, 17; 12372.25 to 14434.125, 17; 14434.125 to 16496, 44
116496
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
2,965 · 1.3% of valid
Min
1
25%
6
Median
25
75%
72
Max
16496

best_bid

integer

Best YES bid in cents, 0 to 100.

Histogram: 1 to 13.25, 18,715; 13.25 to 25.5, 18,358; 25.5 to 37.75, 16,099; 37.75 to 50, 6,556; 50 to 62.25, 3,217; 62.25 to 74.5, 1,727; 74.5 to 86.75, 4,912; 86.75 to 99, 161,817
199
Valid
231,401 · 99.6%
Missing
973 · 0.4%
Distinct
99 · 0% of valid
Min
1
25%
48
Median
99
75%
99
Max
99

best_ask

integer

Best YES ask in cents, 0 to 100.

Histogram: 1 to 13.25, 4,884; 13.25 to 25.5, 3,123; 25.5 to 37.75, 1,089; 37.75 to 50, 544; 50 to 62.25, 526; 62.25 to 74.5, 709; 74.5 to 86.75, 2,070; 86.75 to 99, 15,974
199
Valid
28,919 · 12.4%
Missing
203,455 · 87.6%
Distinct
98 · 0.3% of valid
Min
1
25%
21
Median
90
75%
98
Max
99

bid_depth

integer

Total resting contracts on the YES bid side.

Histogram: 0 to 4193.75, 76,108; 4193.75 to 8387.5, 79,764; 8387.5 to 12581.25, 40,189; 12581.25 to 16775, 19,176; 16775 to 20968.75, 13,108; 20968.75 to 25162.5, 4,007; 25162.5 to 29356.25, 16; 29356.25 to 33550, 6
033550
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
7,701 · 3.3% of valid
Min
0
25%
2000
Median
6737
75%
10459
Max
33550

ask_depth

integer

Total resting contracts on the YES ask side.

Histogram: 0 to 3008.875, 215,258; 3008.875 to 6017.75, 216; 6017.75 to 9026.625, 1; 9026.625 to 12035.5, 15,402; 12035.5 to 15044.375, 211; 15044.375 to 18053.25, 24; 18053.25 to 21062.125, 658; 21062.125 to 24071, 604
024071
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
1,584 · 0.7% of valid
Min
0
25%
0
Median
0
75%
0
Max
24071

yes_bids

string

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

  • [{"price":99,"size":6000}]4%
  • [{"price":99,"size":7000}]3%
  • [{"price":1,"size":2}]3%
  • Other (50,006)
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
50,018 · 21.5% of valid

yes_asks

string

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

  • []88%
  • [{"price":99,"size":2}]2%
  • [{"price":99,"size":1}]0%
  • Other (6,765)
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
6,777 · 2.9% of valid

ingest_time_ms

integer

When the recorder received the frame, epoch milliseconds.

Histogram: 1789055647000 to 1789695912375, 25,835; 1789695912375 to 1790336177750, 18,896; 1790336177750 to 1790976443125, 22,073; 1790976443125 to 1791616708500, 21,950; 1791616708500 to 1792256973875, 42,533; 1792256973875 to 1792897239250, 0; 1792897239250 to 1793537504625, 417; 1793537504625 to 1794177770000, 100,670
17890556470001794177770000
Valid
232,374 · 100%
Missing
0 · 0%
Distinct
68,497 · 29.5% of valid
Min
1789055647000
25%
1790770593000
Median
1791965795000
75%
1793947259000
Max
1794177770000

Support

Talk to Mostly Right

Loading chat…