PREVIEW / futures_5min / 2018-07-20
file: by_date/futures_5min/2018/2018-07-20.parquet size: 229 KB rows: 13,345
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-20 00:00:00 | ES | Futures | 3052.17 | 3052.17 | 3051.62 | 3051.89 | 215.0 |
| 2018-07-20 00:05:00 | ES | Futures | 3051.62 | 3052.17 | 3051.62 | 3052.17 | 248.0 |
| 2018-07-20 00:10:00 | ES | Futures | 3052.17 | 3052.71 | 3052.17 | 3052.44 | 360.0 |
| 2018-07-20 00:15:00 | ES | Futures | 3052.44 | 3052.98 | 3051.62 | 3052.17 | 447.0 |
| 2018-07-20 00:20:00 | ES | Futures | 3052.44 | 3052.98 | 3052.44 | 3052.71 | 213.0 |
| 2018-07-20 00:25:00 | ES | Futures | 3052.71 | 3052.98 | 3051.62 | 3052.17 | 433.0 |
| 2018-07-20 00:30:00 | ES | Futures | 3051.89 | 3052.17 | 3051.62 | 3051.62 | 93.0 |
| 2018-07-20 00:35:00 | ES | Futures | 3051.89 | 3051.89 | 3051.35 | 3051.62 | 199.0 |
| 2018-07-20 00:40:00 | ES | Futures | 3051.89 | 3052.17 | 3051.35 | 3051.62 | 167.0 |
| 2018-07-20 00:45:00 | ES | Futures | 3051.35 | 3051.62 | 3051.08 | 3051.62 | 195.0 |
| 2018-07-20 00:50:00 | ES | Futures | 3051.62 | 3052.17 | 3051.62 | 3051.89 | 226.0 |
| 2018-07-20 00:55:00 | ES | Futures | 3052.17 | 3052.44 | 3051.08 | 3051.62 | 509.0 |
| 2018-07-20 01:00:00 | ES | Futures | 3051.35 | 3052.44 | 3051.35 | 3051.35 | 579.0 |
| 2018-07-20 01:05:00 | ES | Futures | 3051.08 | 3052.44 | 3051.08 | 3051.89 | 397.0 |
| 2018-07-20 01:10:00 | ES | Futures | 3051.89 | 3053.53 | 3051.89 | 3053.53 | 869.0 |
| 2018-07-20 01:15:00 | ES | Futures | 3053.53 | 3054.62 | 3053.26 | 3054.35 | 1520.0 |
| 2018-07-20 01:20:00 | ES | Futures | 3054.07 | 3054.35 | 3052.98 | 3052.98 | 587.0 |
| 2018-07-20 01:25:00 | ES | Futures | 3052.98 | 3054.35 | 3052.98 | 3054.07 | 705.0 |
| 2018-07-20 01:30:00 | ES | Futures | 3053.8 | 3054.62 | 3053.53 | 3054.35 | 795.0 |
| 2018-07-20 01:35:00 | ES | Futures | 3054.07 | 3054.62 | 3053.8 | 3054.07 | 817.0 |
| 2018-07-20 01:40:00 | ES | Futures | 3053.8 | 3055.71 | 3053.8 | 3055.44 | 1600.0 |
| 2018-07-20 01:45:00 | ES | Futures | 3055.71 | 3055.98 | 3055.16 | 3055.71 | 806.0 |
| 2018-07-20 01:50:00 | ES | Futures | 3055.44 | 3055.71 | 3055.16 | 3055.71 | 340.0 |
| 2018-07-20 01:55:00 | ES | Futures | 3055.44 | 3055.98 | 3054.89 | 3055.16 | 673.0 |
| 2018-07-20 02:00:00 | ES | Futures | 3055.16 | 3055.44 | 3054.62 | 3055.44 | 613.0 |
| 2018-07-20 02:05:00 | ES | Futures | 3055.16 | 3055.71 | 3054.89 | 3054.89 | 757.0 |
| 2018-07-20 02:10:00 | ES | Futures | 3055.16 | 3055.71 | 3054.89 | 3055.44 | 1295.0 |
| 2018-07-20 02:15:00 | ES | Futures | 3055.44 | 3055.71 | 3055.16 | 3055.16 | 825.0 |
| 2018-07-20 02:20:00 | ES | Futures | 3055.16 | 3055.44 | 3053.8 | 3054.07 | 1198.0 |
| 2018-07-20 02:25:00 | ES | Futures | 3054.07 | 3054.07 | 3052.71 | 3053.53 | 797.0 |
| 2018-07-20 02:30:00 | ES | Futures | 3053.53 | 3053.53 | 3052.44 | 3052.71 | 795.0 |
| 2018-07-20 02:35:00 | ES | Futures | 3052.71 | 3053.53 | 3052.71 | 3053.53 | 583.0 |
| 2018-07-20 02:40:00 | ES | Futures | 3053.26 | 3053.53 | 3052.71 | 3053.53 | 487.0 |
| 2018-07-20 02:45:00 | ES | Futures | 3053.26 | 3054.07 | 3053.26 | 3054.07 | 831.0 |
| 2018-07-20 02:50:00 | ES | Futures | 3054.35 | 3054.89 | 3054.07 | 3054.35 | 433.0 |
| 2018-07-20 02:55:00 | ES | Futures | 3054.35 | 3054.89 | 3054.35 | 3054.62 | 283.0 |
| 2018-07-20 03:00:00 | ES | Futures | 3054.35 | 3055.16 | 3053.8 | 3054.07 | 1420.0 |
| 2018-07-20 03:05:00 | ES | Futures | 3053.8 | 3055.16 | 3053.26 | 3054.35 | 1160.0 |
| 2018-07-20 03:10:00 | ES | Futures | 3054.62 | 3055.98 | 3054.35 | 3055.16 | 1384.0 |
| 2018-07-20 03:15:00 | ES | Futures | 3054.89 | 3055.16 | 3053.8 | 3054.62 | 724.0 |
| 2018-07-20 03:20:00 | ES | Futures | 3054.62 | 3055.71 | 3054.62 | 3055.16 | 730.0 |
| 2018-07-20 03:25:00 | ES | Futures | 3055.16 | 3055.98 | 3054.89 | 3055.98 | 610.0 |
| 2018-07-20 03:30:00 | ES | Futures | 3055.98 | 3056.53 | 3055.44 | 3055.44 | 532.0 |
| 2018-07-20 03:35:00 | ES | Futures | 3055.16 | 3056.25 | 3054.62 | 3055.71 | 950.0 |
| 2018-07-20 03:40:00 | ES | Futures | 3055.98 | 3056.25 | 3055.71 | 3056.25 | 809.0 |
| 2018-07-20 03:45:00 | ES | Futures | 3056.25 | 3056.25 | 3055.16 | 3055.44 | 591.0 |
| 2018-07-20 03:50:00 | ES | Futures | 3055.71 | 3055.71 | 3055.16 | 3055.16 | 237.0 |
| 2018-07-20 03:55:00 | ES | Futures | 3055.44 | 3055.98 | 3055.16 | 3055.98 | 280.0 |
| 2018-07-20 04:00:00 | ES | Futures | 3055.98 | 3056.25 | 3055.44 | 3055.71 | 352.0 |
| 2018-07-20 04:05:00 | ES | Futures | 3055.98 | 3055.98 | 3055.44 | 3055.44 | 481.0 |
> showing 50 of 13,345 rows — these rows as CSV