PREVIEW / futures_5min / 2017-05-31
file: by_date/futures_5min/2017/2017-05-31.parquet size: 245 KB rows: 15,632
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-05-31 00:00:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 67.0 |
| 2017-05-31 00:05:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 132.0 |
| 2017-05-31 00:10:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 60.0 |
| 2017-05-31 00:15:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 71.0 |
| 2017-05-31 00:20:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 49.0 |
| 2017-05-31 00:25:00 | ES | Futures | 2634.74 | 2635.28 | 2634.74 | 2635.28 | 75.0 |
| 2017-05-31 00:30:00 | ES | Futures | 2635.01 | 2635.28 | 2635.01 | 2635.28 | 216.0 |
| 2017-05-31 00:35:00 | ES | Futures | 2635.28 | 2635.28 | 2635.01 | 2635.28 | 23.0 |
| 2017-05-31 00:40:00 | ES | Futures | 2635.01 | 2635.28 | 2634.46 | 2634.74 | 229.0 |
| 2017-05-31 00:45:00 | ES | Futures | 2634.46 | 2634.74 | 2634.46 | 2634.74 | 66.0 |
| 2017-05-31 00:50:00 | ES | Futures | 2634.74 | 2635.01 | 2634.74 | 2634.74 | 49.0 |
| 2017-05-31 00:55:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 54.0 |
| 2017-05-31 01:00:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2635.01 | 60.0 |
| 2017-05-31 01:05:00 | ES | Futures | 2634.74 | 2635.01 | 2634.46 | 2634.74 | 59.0 |
| 2017-05-31 01:10:00 | ES | Futures | 2634.46 | 2635.28 | 2634.46 | 2635.28 | 256.0 |
| 2017-05-31 01:15:00 | ES | Futures | 2635.01 | 2635.28 | 2635.01 | 2635.01 | 79.0 |
| 2017-05-31 01:20:00 | ES | Futures | 2635.01 | 2635.01 | 2634.74 | 2634.74 | 13.0 |
| 2017-05-31 01:25:00 | ES | Futures | 2635.01 | 2635.01 | 2634.46 | 2634.46 | 130.0 |
| 2017-05-31 01:30:00 | ES | Futures | 2634.74 | 2634.74 | 2634.19 | 2634.46 | 233.0 |
| 2017-05-31 01:35:00 | ES | Futures | 2634.46 | 2634.46 | 2634.19 | 2634.19 | 551.0 |
| 2017-05-31 01:40:00 | ES | Futures | 2634.46 | 2634.46 | 2634.19 | 2634.19 | 65.0 |
| 2017-05-31 01:45:00 | ES | Futures | 2634.46 | 2634.74 | 2634.19 | 2634.74 | 143.0 |
| 2017-05-31 01:50:00 | ES | Futures | 2634.46 | 2634.74 | 2634.19 | 2634.19 | 142.0 |
| 2017-05-31 01:55:00 | ES | Futures | 2634.46 | 2634.46 | 2634.19 | 2634.46 | 322.0 |
| 2017-05-31 02:00:00 | ES | Futures | 2634.19 | 2635.28 | 2634.19 | 2635.28 | 928.0 |
| 2017-05-31 02:05:00 | ES | Futures | 2635.01 | 2635.56 | 2635.01 | 2635.28 | 629.0 |
| 2017-05-31 02:10:00 | ES | Futures | 2635.28 | 2635.56 | 2635.01 | 2635.56 | 792.0 |
| 2017-05-31 02:15:00 | ES | Futures | 2635.28 | 2635.56 | 2635.01 | 2635.28 | 512.0 |
| 2017-05-31 02:20:00 | ES | Futures | 2635.01 | 2635.28 | 2634.74 | 2635.01 | 318.0 |
| 2017-05-31 02:25:00 | ES | Futures | 2635.01 | 2635.28 | 2634.74 | 2635.28 | 512.0 |
| 2017-05-31 02:30:00 | ES | Futures | 2635.56 | 2635.56 | 2635.01 | 2635.56 | 608.0 |
| 2017-05-31 02:35:00 | ES | Futures | 2635.56 | 2635.83 | 2635.56 | 2635.83 | 376.0 |
| 2017-05-31 02:40:00 | ES | Futures | 2635.83 | 2635.83 | 2635.28 | 2635.56 | 331.0 |
| 2017-05-31 02:45:00 | ES | Futures | 2635.28 | 2635.56 | 2635.28 | 2635.56 | 82.0 |
| 2017-05-31 02:50:00 | ES | Futures | 2635.28 | 2635.83 | 2635.28 | 2635.56 | 402.0 |
| 2017-05-31 02:55:00 | ES | Futures | 2635.83 | 2636.1 | 2635.83 | 2635.83 | 1013.0 |
| 2017-05-31 03:00:00 | ES | Futures | 2635.83 | 2636.92 | 2635.56 | 2636.38 | 4089.0 |
| 2017-05-31 03:05:00 | ES | Futures | 2636.1 | 2636.38 | 2635.28 | 2636.38 | 2690.0 |
| 2017-05-31 03:10:00 | ES | Futures | 2636.1 | 2636.65 | 2636.1 | 2636.1 | 996.0 |
| 2017-05-31 03:15:00 | ES | Futures | 2636.1 | 2636.65 | 2635.56 | 2635.83 | 1259.0 |
| 2017-05-31 03:20:00 | ES | Futures | 2636.1 | 2636.1 | 2635.56 | 2635.83 | 570.0 |
| 2017-05-31 03:25:00 | ES | Futures | 2635.83 | 2636.38 | 2635.56 | 2635.83 | 719.0 |
| 2017-05-31 03:30:00 | ES | Futures | 2635.83 | 2636.38 | 2635.56 | 2635.56 | 501.0 |
| 2017-05-31 03:35:00 | ES | Futures | 2635.56 | 2635.56 | 2634.46 | 2635.01 | 2453.0 |
| 2017-05-31 03:40:00 | ES | Futures | 2635.01 | 2635.01 | 2634.19 | 2634.46 | 893.0 |
| 2017-05-31 03:45:00 | ES | Futures | 2634.46 | 2635.28 | 2634.46 | 2635.01 | 683.0 |
| 2017-05-31 03:50:00 | ES | Futures | 2634.74 | 2635.01 | 2634.46 | 2634.74 | 467.0 |
| 2017-05-31 03:55:00 | ES | Futures | 2634.46 | 2635.56 | 2634.46 | 2635.28 | 1076.0 |
| 2017-05-31 04:00:00 | ES | Futures | 2635.28 | 2635.83 | 2635.28 | 2635.56 | 1467.0 |
| 2017-05-31 04:05:00 | ES | Futures | 2635.56 | 2636.1 | 2635.56 | 2635.56 | 868.0 |
> showing 50 of 15,632 rows — these rows as CSV