PREVIEW / futures_5min / 2018-09-30
file: by_date/futures_5min/2018/2018-09-30.parquet size: 49 KB rows: 2,732
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-09-30 18:00:00 | ES | Futures | 3179.66 | 3184.28 | 3179.66 | 3182.65 | 5883.0 |
| 2018-09-30 18:05:00 | ES | Futures | 3182.65 | 3183.47 | 3182.11 | 3182.92 | 1171.0 |
| 2018-09-30 18:10:00 | ES | Futures | 3182.92 | 3183.2 | 3182.11 | 3182.11 | 1040.0 |
| 2018-09-30 18:15:00 | ES | Futures | 3182.38 | 3182.92 | 3181.84 | 3182.11 | 361.0 |
| 2018-09-30 18:20:00 | ES | Futures | 3182.11 | 3182.11 | 3181.02 | 3181.84 | 614.0 |
| 2018-09-30 18:25:00 | ES | Futures | 3181.84 | 3182.38 | 3181.02 | 3182.11 | 544.0 |
| 2018-09-30 18:30:00 | ES | Futures | 3182.38 | 3182.65 | 3181.56 | 3182.11 | 721.0 |
| 2018-09-30 18:35:00 | ES | Futures | 3182.11 | 3182.65 | 3182.11 | 3182.65 | 443.0 |
| 2018-09-30 18:40:00 | ES | Futures | 3182.38 | 3182.92 | 3182.38 | 3182.65 | 185.0 |
| 2018-09-30 18:45:00 | ES | Futures | 3182.65 | 3183.2 | 3182.65 | 3182.65 | 209.0 |
| 2018-09-30 18:50:00 | ES | Futures | 3182.92 | 3182.92 | 3182.65 | 3182.92 | 116.0 |
| 2018-09-30 18:55:00 | ES | Futures | 3182.92 | 3183.47 | 3182.65 | 3183.2 | 276.0 |
| 2018-09-30 19:00:00 | ES | Futures | 3183.2 | 3183.74 | 3183.2 | 3183.74 | 701.0 |
| 2018-09-30 19:05:00 | ES | Futures | 3183.74 | 3185.64 | 3183.47 | 3185.1 | 1556.0 |
| 2018-09-30 19:10:00 | ES | Futures | 3185.1 | 3185.92 | 3184.83 | 3185.64 | 742.0 |
| 2018-09-30 19:15:00 | ES | Futures | 3185.37 | 3185.64 | 3185.37 | 3185.37 | 608.0 |
| 2018-09-30 19:20:00 | ES | Futures | 3185.37 | 3187.55 | 3185.37 | 3187.0 | 1917.0 |
| 2018-09-30 19:25:00 | ES | Futures | 3186.73 | 3187.55 | 3186.46 | 3187.0 | 631.0 |
| 2018-09-30 19:30:00 | ES | Futures | 3187.0 | 3187.0 | 3185.64 | 3186.19 | 958.0 |
| 2018-09-30 19:35:00 | ES | Futures | 3186.19 | 3186.46 | 3185.64 | 3185.64 | 332.0 |
| 2018-09-30 19:40:00 | ES | Futures | 3185.92 | 3185.92 | 3185.1 | 3185.1 | 379.0 |
| 2018-09-30 19:45:00 | ES | Futures | 3185.37 | 3185.64 | 3184.56 | 3185.37 | 903.0 |
| 2018-09-30 19:50:00 | ES | Futures | 3185.37 | 3185.37 | 3184.56 | 3185.1 | 492.0 |
| 2018-09-30 19:55:00 | ES | Futures | 3185.1 | 3185.92 | 3184.83 | 3185.92 | 390.0 |
| 2018-09-30 20:00:00 | ES | Futures | 3185.92 | 3185.92 | 3184.83 | 3184.83 | 1173.0 |
| 2018-09-30 20:05:00 | ES | Futures | 3185.1 | 3185.92 | 3184.56 | 3185.64 | 733.0 |
| 2018-09-30 20:10:00 | ES | Futures | 3185.64 | 3186.73 | 3185.37 | 3186.46 | 804.0 |
| 2018-09-30 20:15:00 | ES | Futures | 3186.46 | 3186.73 | 3185.92 | 3186.19 | 737.0 |
| 2018-09-30 20:20:00 | ES | Futures | 3186.19 | 3186.73 | 3185.92 | 3186.73 | 448.0 |
| 2018-09-30 20:25:00 | ES | Futures | 3186.73 | 3186.73 | 3185.92 | 3185.92 | 418.0 |
| 2018-09-30 20:30:00 | ES | Futures | 3185.92 | 3186.46 | 3185.64 | 3186.19 | 625.0 |
| 2018-09-30 20:35:00 | ES | Futures | 3186.19 | 3186.73 | 3185.92 | 3186.46 | 269.0 |
| 2018-09-30 20:40:00 | ES | Futures | 3186.19 | 3186.73 | 3186.19 | 3186.46 | 338.0 |
| 2018-09-30 20:45:00 | ES | Futures | 3186.46 | 3187.28 | 3186.19 | 3186.73 | 1028.0 |
| 2018-09-30 20:50:00 | ES | Futures | 3187.0 | 3187.0 | 3186.46 | 3186.73 | 523.0 |
| 2018-09-30 20:55:00 | ES | Futures | 3186.73 | 3187.28 | 3186.46 | 3187.0 | 332.0 |
| 2018-09-30 21:00:00 | ES | Futures | 3187.28 | 3188.36 | 3187.0 | 3187.28 | 2176.0 |
| 2018-09-30 21:05:00 | ES | Futures | 3187.28 | 3187.55 | 3187.28 | 3187.55 | 254.0 |
| 2018-09-30 21:10:00 | ES | Futures | 3187.55 | 3187.55 | 3187.28 | 3187.55 | 476.0 |
| 2018-09-30 21:15:00 | ES | Futures | 3187.55 | 3188.09 | 3187.28 | 3187.82 | 1306.0 |
| 2018-09-30 21:20:00 | ES | Futures | 3187.82 | 3187.82 | 3186.46 | 3186.73 | 848.0 |
| 2018-09-30 21:25:00 | ES | Futures | 3186.73 | 3187.0 | 3186.46 | 3186.46 | 551.0 |
| 2018-09-30 21:30:00 | ES | Futures | 3186.46 | 3186.73 | 3186.19 | 3186.73 | 303.0 |
| 2018-09-30 21:35:00 | ES | Futures | 3186.73 | 3186.73 | 3186.19 | 3186.46 | 445.0 |
| 2018-09-30 21:40:00 | ES | Futures | 3186.46 | 3186.73 | 3186.19 | 3186.73 | 255.0 |
| 2018-09-30 21:45:00 | ES | Futures | 3186.73 | 3187.55 | 3186.73 | 3187.0 | 428.0 |
| 2018-09-30 21:50:00 | ES | Futures | 3187.0 | 3187.82 | 3186.73 | 3187.55 | 1114.0 |
| 2018-09-30 21:55:00 | ES | Futures | 3187.55 | 3187.82 | 3187.28 | 3187.55 | 615.0 |
| 2018-09-30 22:00:00 | ES | Futures | 3187.55 | 3188.09 | 3187.28 | 3188.09 | 451.0 |
| 2018-09-30 22:05:00 | ES | Futures | 3188.09 | 3188.36 | 3188.09 | 3188.36 | 627.0 |
> showing 50 of 2,732 rows — these rows as CSV