PREVIEW / futures_5min / 2018-07-22
file: by_date/futures_5min/2018/2018-07-22.parquet size: 54 KB rows: 2,787
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-22 18:00:00 | ES | Futures | 3057.34 | 3058.16 | 3055.44 | 3055.71 | 1435.0 |
| 2018-07-22 18:05:00 | ES | Futures | 3055.71 | 3057.89 | 3055.44 | 3056.8 | 566.0 |
| 2018-07-22 18:10:00 | ES | Futures | 3056.8 | 3057.34 | 3056.53 | 3056.8 | 229.0 |
| 2018-07-22 18:15:00 | ES | Futures | 3056.53 | 3056.53 | 3055.71 | 3055.71 | 153.0 |
| 2018-07-22 18:20:00 | ES | Futures | 3055.71 | 3055.98 | 3054.89 | 3055.98 | 281.0 |
| 2018-07-22 18:25:00 | ES | Futures | 3055.98 | 3056.25 | 3055.71 | 3055.98 | 56.0 |
| 2018-07-22 18:30:00 | ES | Futures | 3055.98 | 3056.8 | 3055.71 | 3055.98 | 249.0 |
| 2018-07-22 18:35:00 | ES | Futures | 3055.98 | 3056.8 | 3055.98 | 3056.25 | 334.0 |
| 2018-07-22 18:40:00 | ES | Futures | 3056.53 | 3056.53 | 3055.44 | 3055.98 | 203.0 |
| 2018-07-22 18:45:00 | ES | Futures | 3055.98 | 3056.25 | 3055.44 | 3055.44 | 53.0 |
| 2018-07-22 18:50:00 | ES | Futures | 3055.44 | 3055.71 | 3055.16 | 3055.44 | 144.0 |
| 2018-07-22 18:55:00 | ES | Futures | 3055.44 | 3056.53 | 3055.44 | 3056.53 | 100.0 |
| 2018-07-22 19:00:00 | ES | Futures | 3056.53 | 3056.53 | 3055.98 | 3056.25 | 276.0 |
| 2018-07-22 19:05:00 | ES | Futures | 3056.25 | 3057.07 | 3056.25 | 3056.8 | 238.0 |
| 2018-07-22 19:10:00 | ES | Futures | 3056.53 | 3056.8 | 3056.53 | 3056.8 | 136.0 |
| 2018-07-22 19:15:00 | ES | Futures | 3056.8 | 3056.8 | 3056.53 | 3056.8 | 73.0 |
| 2018-07-22 19:20:00 | ES | Futures | 3056.8 | 3056.8 | 3056.53 | 3056.8 | 120.0 |
| 2018-07-22 19:25:00 | ES | Futures | 3056.8 | 3056.8 | 3056.53 | 3056.53 | 136.0 |
| 2018-07-22 19:30:00 | ES | Futures | 3056.53 | 3056.8 | 3056.25 | 3056.53 | 120.0 |
| 2018-07-22 19:35:00 | ES | Futures | 3056.25 | 3056.53 | 3054.07 | 3054.07 | 412.0 |
| 2018-07-22 19:40:00 | ES | Futures | 3054.35 | 3055.16 | 3054.35 | 3054.35 | 300.0 |
| 2018-07-22 19:45:00 | ES | Futures | 3054.62 | 3054.89 | 3054.35 | 3054.35 | 261.0 |
| 2018-07-22 19:50:00 | ES | Futures | 3054.35 | 3054.62 | 3054.07 | 3054.35 | 203.0 |
| 2018-07-22 19:55:00 | ES | Futures | 3054.35 | 3054.89 | 3053.8 | 3053.8 | 361.0 |
| 2018-07-22 20:00:00 | ES | Futures | 3053.8 | 3054.62 | 3053.26 | 3054.35 | 875.0 |
| 2018-07-22 20:05:00 | ES | Futures | 3054.07 | 3054.62 | 3052.98 | 3052.98 | 811.0 |
| 2018-07-22 20:10:00 | ES | Futures | 3052.71 | 3053.8 | 3052.44 | 3053.26 | 748.0 |
| 2018-07-22 20:15:00 | ES | Futures | 3053.53 | 3054.07 | 3052.98 | 3053.8 | 422.0 |
| 2018-07-22 20:20:00 | ES | Futures | 3053.8 | 3053.8 | 3053.26 | 3053.53 | 576.0 |
| 2018-07-22 20:25:00 | ES | Futures | 3053.53 | 3053.8 | 3052.17 | 3052.44 | 1026.0 |
| 2018-07-22 20:30:00 | ES | Futures | 3052.44 | 3053.53 | 3052.17 | 3052.98 | 613.0 |
| 2018-07-22 20:35:00 | ES | Futures | 3053.26 | 3053.8 | 3052.71 | 3053.8 | 253.0 |
| 2018-07-22 20:40:00 | ES | Futures | 3053.8 | 3053.8 | 3053.26 | 3053.8 | 1079.0 |
| 2018-07-22 20:45:00 | ES | Futures | 3053.8 | 3053.8 | 3050.26 | 3050.53 | 2422.0 |
| 2018-07-22 20:50:00 | ES | Futures | 3050.81 | 3051.62 | 3050.53 | 3050.81 | 589.0 |
| 2018-07-22 20:55:00 | ES | Futures | 3050.81 | 3051.08 | 3048.35 | 3048.9 | 1903.0 |
| 2018-07-22 21:00:00 | ES | Futures | 3048.9 | 3049.17 | 3047.26 | 3048.35 | 1627.0 |
| 2018-07-22 21:05:00 | ES | Futures | 3048.35 | 3048.35 | 3046.17 | 3047.26 | 1476.0 |
| 2018-07-22 21:10:00 | ES | Futures | 3047.26 | 3048.9 | 3047.26 | 3047.54 | 2141.0 |
| 2018-07-22 21:15:00 | ES | Futures | 3047.54 | 3048.63 | 3046.72 | 3047.81 | 1969.0 |
| 2018-07-22 21:20:00 | ES | Futures | 3048.08 | 3048.63 | 3046.45 | 3047.26 | 1450.0 |
| 2018-07-22 21:25:00 | ES | Futures | 3046.99 | 3047.81 | 3046.72 | 3047.26 | 426.0 |
| 2018-07-22 21:30:00 | ES | Futures | 3047.26 | 3048.63 | 3046.72 | 3047.54 | 1212.0 |
| 2018-07-22 21:35:00 | ES | Futures | 3047.26 | 3048.08 | 3046.99 | 3047.26 | 523.0 |
| 2018-07-22 21:40:00 | ES | Futures | 3047.54 | 3047.81 | 3045.36 | 3045.9 | 1200.0 |
| 2018-07-22 21:45:00 | ES | Futures | 3045.63 | 3046.45 | 3045.36 | 3046.17 | 1014.0 |
| 2018-07-22 21:50:00 | ES | Futures | 3046.17 | 3047.26 | 3045.63 | 3046.99 | 631.0 |
| 2018-07-22 21:55:00 | ES | Futures | 3046.99 | 3047.81 | 3046.99 | 3047.54 | 692.0 |
| 2018-07-22 22:00:00 | ES | Futures | 3047.26 | 3047.81 | 3046.45 | 3046.72 | 652.0 |
| 2018-07-22 22:05:00 | ES | Futures | 3046.72 | 3047.54 | 3046.45 | 3047.54 | 658.0 |
> showing 50 of 2,787 rows — these rows as CSV