PREVIEW / futures_5min / 2018-07-26
file: by_date/futures_5min/2018/2018-07-26.parquet size: 241 KB rows: 15,476
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-26 00:00:00 | ES | Futures | 3089.22 | 3089.5 | 3089.22 | 3089.22 | 136.0 |
| 2018-07-26 00:05:00 | ES | Futures | 3088.95 | 3089.22 | 3088.68 | 3088.68 | 393.0 |
| 2018-07-26 00:10:00 | ES | Futures | 3088.68 | 3089.22 | 3088.68 | 3089.22 | 93.0 |
| 2018-07-26 00:15:00 | ES | Futures | 3088.95 | 3089.22 | 3088.95 | 3088.95 | 243.0 |
| 2018-07-26 00:20:00 | ES | Futures | 3088.95 | 3089.22 | 3088.95 | 3089.22 | 79.0 |
| 2018-07-26 00:25:00 | ES | Futures | 3088.95 | 3089.22 | 3088.95 | 3088.95 | 98.0 |
| 2018-07-26 00:30:00 | ES | Futures | 3088.95 | 3089.22 | 3088.68 | 3088.95 | 236.0 |
| 2018-07-26 00:35:00 | ES | Futures | 3088.95 | 3089.22 | 3088.95 | 3088.95 | 140.0 |
| 2018-07-26 00:40:00 | ES | Futures | 3088.95 | 3089.5 | 3088.95 | 3089.22 | 351.0 |
| 2018-07-26 00:45:00 | ES | Futures | 3089.22 | 3089.5 | 3088.95 | 3088.95 | 305.0 |
| 2018-07-26 00:50:00 | ES | Futures | 3089.22 | 3089.22 | 3088.95 | 3089.22 | 109.0 |
| 2018-07-26 00:55:00 | ES | Futures | 3089.22 | 3089.5 | 3088.95 | 3089.5 | 247.0 |
| 2018-07-26 01:00:00 | ES | Futures | 3089.5 | 3089.77 | 3088.68 | 3088.68 | 427.0 |
| 2018-07-26 01:05:00 | ES | Futures | 3088.68 | 3089.22 | 3088.13 | 3088.68 | 760.0 |
| 2018-07-26 01:10:00 | ES | Futures | 3088.95 | 3089.22 | 3088.68 | 3088.95 | 302.0 |
| 2018-07-26 01:15:00 | ES | Futures | 3089.22 | 3089.22 | 3088.41 | 3088.41 | 75.0 |
| 2018-07-26 01:20:00 | ES | Futures | 3088.41 | 3088.95 | 3088.41 | 3088.95 | 152.0 |
| 2018-07-26 01:25:00 | ES | Futures | 3088.68 | 3089.22 | 3088.68 | 3088.95 | 490.0 |
| 2018-07-26 01:30:00 | ES | Futures | 3088.68 | 3089.22 | 3088.68 | 3088.95 | 261.0 |
| 2018-07-26 01:35:00 | ES | Futures | 3088.95 | 3088.95 | 3088.41 | 3088.41 | 290.0 |
| 2018-07-26 01:40:00 | ES | Futures | 3088.41 | 3089.22 | 3088.41 | 3089.22 | 329.0 |
| 2018-07-26 01:45:00 | ES | Futures | 3089.22 | 3089.22 | 3088.68 | 3088.95 | 624.0 |
| 2018-07-26 01:50:00 | ES | Futures | 3088.95 | 3088.95 | 3088.41 | 3088.41 | 220.0 |
| 2018-07-26 01:55:00 | ES | Futures | 3088.41 | 3088.95 | 3088.13 | 3088.68 | 626.0 |
| 2018-07-26 02:00:00 | ES | Futures | 3088.68 | 3090.04 | 3088.68 | 3089.5 | 1292.0 |
| 2018-07-26 02:05:00 | ES | Futures | 3089.22 | 3089.77 | 3088.95 | 3089.22 | 798.0 |
| 2018-07-26 02:10:00 | ES | Futures | 3089.5 | 3089.77 | 3089.22 | 3089.77 | 640.0 |
| 2018-07-26 02:15:00 | ES | Futures | 3089.77 | 3091.13 | 3089.5 | 3090.59 | 867.0 |
| 2018-07-26 02:20:00 | ES | Futures | 3090.59 | 3091.13 | 3090.31 | 3090.31 | 666.0 |
| 2018-07-26 02:25:00 | ES | Futures | 3090.31 | 3090.86 | 3090.31 | 3090.59 | 705.0 |
| 2018-07-26 02:30:00 | ES | Futures | 3090.31 | 3090.86 | 3089.5 | 3089.5 | 780.0 |
| 2018-07-26 02:35:00 | ES | Futures | 3089.5 | 3090.86 | 3089.5 | 3090.59 | 518.0 |
| 2018-07-26 02:40:00 | ES | Futures | 3090.59 | 3090.86 | 3089.77 | 3089.77 | 513.0 |
| 2018-07-26 02:45:00 | ES | Futures | 3090.04 | 3090.04 | 3089.22 | 3089.22 | 687.0 |
| 2018-07-26 02:50:00 | ES | Futures | 3089.22 | 3089.77 | 3088.95 | 3089.22 | 541.0 |
| 2018-07-26 02:55:00 | ES | Futures | 3089.22 | 3090.04 | 3088.95 | 3089.77 | 825.0 |
| 2018-07-26 03:00:00 | ES | Futures | 3090.04 | 3090.86 | 3089.22 | 3090.31 | 2092.0 |
| 2018-07-26 03:05:00 | ES | Futures | 3090.31 | 3091.4 | 3089.77 | 3090.31 | 2361.0 |
| 2018-07-26 03:10:00 | ES | Futures | 3090.59 | 3091.95 | 3090.31 | 3091.4 | 2363.0 |
| 2018-07-26 03:15:00 | ES | Futures | 3091.13 | 3091.95 | 3090.04 | 3090.31 | 1177.0 |
| 2018-07-26 03:20:00 | ES | Futures | 3090.31 | 3091.4 | 3089.77 | 3091.4 | 1005.0 |
| 2018-07-26 03:25:00 | ES | Futures | 3091.4 | 3092.22 | 3091.13 | 3091.4 | 873.0 |
| 2018-07-26 03:30:00 | ES | Futures | 3091.13 | 3092.22 | 3090.86 | 3090.86 | 1107.0 |
| 2018-07-26 03:35:00 | ES | Futures | 3090.86 | 3091.68 | 3090.59 | 3091.13 | 850.0 |
| 2018-07-26 03:40:00 | ES | Futures | 3091.13 | 3091.68 | 3090.59 | 3090.59 | 660.0 |
| 2018-07-26 03:45:00 | ES | Futures | 3090.86 | 3091.13 | 3090.31 | 3091.13 | 730.0 |
| 2018-07-26 03:50:00 | ES | Futures | 3091.13 | 3091.4 | 3090.86 | 3091.4 | 466.0 |
| 2018-07-26 03:55:00 | ES | Futures | 3091.4 | 3091.68 | 3091.13 | 3091.4 | 556.0 |
| 2018-07-26 04:00:00 | ES | Futures | 3091.13 | 3091.4 | 3089.77 | 3089.77 | 1306.0 |
| 2018-07-26 04:05:00 | ES | Futures | 3090.04 | 3090.31 | 3089.22 | 3090.31 | 1008.0 |
> showing 50 of 15,476 rows — these rows as CSV