Data Shapes
An executed query returns a Data object. It exposes several lazily computed data shapes over the same response, without making additional requests.
| API | Returns | Missing values |
|---|---|---|
.rows() | A flat array of all rows | null |
.series() | Map of row arrays, keyed by exchange:product | null |
.columns() | Map of index-aligned Float64Arrays, keyed by exchange:product | NaN |
.candles() | Map of OHLCV candle arrays, keyed by exchange:product | Skipped |
[
{
"exchange": "binance",
"coin": "BTC",
"product": "BTCUSDT",
"time": 1785160560000,
"open_price": 65441.98,
"high_price": 65441.99,
"low_price": 65308.02,
"close_price": 65347.87,
"dollar_volume": 1258607.7729999353
},
{
"exchange": "coinbase",
"coin": "BTC",
"product": "BTC-USD",
"time": 1785160560000,
"open_price": 65377.66,
"high_price": 65379.99,
"low_price": 65238.68,
"close_price": 65288.9,
"dollar_volume": 508561.6389999999
}
]{
"binance:BTCUSDT": [
{
"exchange": "binance",
"coin": "BTC",
"product": "BTCUSDT",
"time": 1785160560000,
"open_price": 65441.98,
"high_price": 65441.99,
"low_price": 65308.02,
"close_price": 65347.87,
"dollar_volume": 1258607.7729999353
},
{
"exchange": "binance",
"coin": "BTC",
"product": "BTCUSDT",
"time": 1785160620000,
"open_price": 65347.87,
"high_price": 65360,
"low_price": 65220.83,
"close_price": 65230.16,
"dollar_volume": 2171446.9780000555
}
]
}{
"binance:BTCUSDT": {
"exchange": "binance",
"coin": "BTC",
"product": "BTCUSDT",
"time": [
1785160560000,
1785160620000
],
"values": {
"open_price": [
65441.98,
65347.87
],
"high_price": [
65441.99,
65360
],
"low_price": [
65308.02,
65220.83
],
"close_price": [
65347.87,
65230.16
],
"dollar_volume": [
1258607.7729999353,
2171446.9780000555
]
}
}
}{
"binance:BTCUSDT": [
{
"time": 1785160560000,
"open": 65441.98,
"high": 65441.99,
"low": 65308.02,
"close": 65347.87,
"volume": 1258607.7729999353
},
{
"time": 1785160620000,
"open": 65347.87,
"high": 65360,
"low": 65220.83,
"close": 65230.16,
"volume": 2171446.9780000555
}
]
}