List of columns per Dataset
Quick explanation
Section titled Quick explanationEach dataset has a list of field detailled below.
When importing the dataset in your favorite langage, you may load this dataset into a table
or dataframe
and fields may be called columns
.
Orderbook updates
Section titled Orderbook updatesField | Type | Description |
---|---|---|
lts | uint64 | Local timestamp |
rts | uint64 | Remote timestamp |
px | float64 | Updated price |
qty | float64 | Updated quantity |
flag | char | Update type (p, u, d) |
Notes
Section titled NotesFlag is very important if you want to do backtesting
Field qty is negative if the updated level is on the bid side of the book, positive if the updated level is on the ask side.
Flag p stands for Partial, it indicates that the price update refer to the initial snapshot of the book.
flag u stands for Update, meaning that the price level of the book is updated to the quantity found in the qty field.
flag d stands for Delete, meaning that the price level of the book is deleted (does not exist anymore). The qty field will be either 1 or -1, to indicate which side of the book must be deleted.
Orderbook snapshots
Section titled Orderbook snapshotsField | Type | Description |
---|---|---|
lts | uint64 | Local timestamp |
bp0 | float64 | Bid price at level 0 |
bq0 | float64 | Bid quantity at level 0 |
ap0 | float64 | Ask price at level 0 |
aq0 | float64 | Ask quantity at level 0 |
… | … | … |
bpN | float64 | Bid price at level N |
bqN | float64 | Bid quantity at level N |
apN | float64 | Ask price at level N |
aqN | float64 | Ask quantity at level N |
Trades
Section titled TradesField | Type | Description |
---|---|---|
lts | uint64 | Local timestamp |
rts | uint64 | Remote timestamp |
px | float64 | Trade price |
qty | float64 | Trade quantity |
flag | char | Flag (exchange dependent) |
Notes
Section titled Notes- The trade price (execution price) provided by exchanges correspond to the price closest to best bid (resp. best offer), in case when trade matches several book levels.
- The quantity is positive when the trade matches with orders at the ask side of the book, negative otherwise.
- The flag indicates the execution type, and is exchange dependent, see exchange documentation.
OHLCV
Section titled OHLCVField | Type | Description |
---|---|---|
lts | uint64 | Local timestamp |
o | float64 | Opening price |
h | float64 | High price |
l | float64 | Low price |
c | float64 | Closing price |
bv | float64 | Bid volume |
av | float64 | Ask volume |