PREVIEW / futures_5min / 2018-08-22
file: by_date/futures_5min/2018/2018-08-22.parquet size: 242 KB rows: 15,235
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-08-22 00:00:00 | ES | Futures | 3113.2 | 3113.47 | 3112.93 | 3113.2 | 410.0 |
| 2018-08-22 00:05:00 | ES | Futures | 3113.2 | 3113.2 | 3112.65 | 3112.65 | 325.0 |
| 2018-08-22 00:10:00 | ES | Futures | 3112.65 | 3112.93 | 3112.38 | 3112.38 | 223.0 |
| 2018-08-22 00:15:00 | ES | Futures | 3112.65 | 3112.93 | 3112.38 | 3112.38 | 152.0 |
| 2018-08-22 00:20:00 | ES | Futures | 3112.38 | 3112.38 | 3111.29 | 3111.57 | 643.0 |
| 2018-08-22 00:25:00 | ES | Futures | 3111.57 | 3111.57 | 3110.75 | 3111.02 | 645.0 |
| 2018-08-22 00:30:00 | ES | Futures | 3111.02 | 3111.57 | 3110.75 | 3111.29 | 411.0 |
| 2018-08-22 00:35:00 | ES | Futures | 3111.57 | 3112.11 | 3111.29 | 3111.84 | 149.0 |
| 2018-08-22 00:40:00 | ES | Futures | 3112.11 | 3112.38 | 3111.84 | 3111.84 | 244.0 |
| 2018-08-22 00:45:00 | ES | Futures | 3111.84 | 3112.11 | 3111.29 | 3111.29 | 155.0 |
| 2018-08-22 00:50:00 | ES | Futures | 3111.57 | 3111.57 | 3111.02 | 3111.29 | 468.0 |
| 2018-08-22 00:55:00 | ES | Futures | 3111.29 | 3111.57 | 3110.75 | 3111.02 | 318.0 |
| 2018-08-22 01:00:00 | ES | Futures | 3111.29 | 3111.84 | 3111.02 | 3111.57 | 460.0 |
| 2018-08-22 01:05:00 | ES | Futures | 3111.84 | 3111.84 | 3111.02 | 3111.02 | 250.0 |
| 2018-08-22 01:10:00 | ES | Futures | 3111.02 | 3111.02 | 3109.93 | 3110.48 | 567.0 |
| 2018-08-22 01:15:00 | ES | Futures | 3110.2 | 3111.02 | 3110.2 | 3110.75 | 444.0 |
| 2018-08-22 01:20:00 | ES | Futures | 3110.75 | 3110.75 | 3110.48 | 3110.75 | 255.0 |
| 2018-08-22 01:25:00 | ES | Futures | 3110.48 | 3110.75 | 3110.48 | 3110.75 | 109.0 |
| 2018-08-22 01:30:00 | ES | Futures | 3110.48 | 3112.38 | 3110.48 | 3112.11 | 570.0 |
| 2018-08-22 01:35:00 | ES | Futures | 3112.38 | 3112.65 | 3111.84 | 3111.84 | 240.0 |
| 2018-08-22 01:40:00 | ES | Futures | 3112.11 | 3112.38 | 3111.29 | 3111.57 | 425.0 |
| 2018-08-22 01:45:00 | ES | Futures | 3111.57 | 3111.84 | 3111.29 | 3111.57 | 378.0 |
| 2018-08-22 01:50:00 | ES | Futures | 3111.57 | 3111.84 | 3111.02 | 3111.02 | 902.0 |
| 2018-08-22 01:55:00 | ES | Futures | 3111.02 | 3111.84 | 3110.75 | 3110.75 | 1048.0 |
| 2018-08-22 02:00:00 | ES | Futures | 3111.02 | 3111.02 | 3109.66 | 3109.66 | 1940.0 |
| 2018-08-22 02:05:00 | ES | Futures | 3109.66 | 3109.93 | 3109.11 | 3109.39 | 1492.0 |
| 2018-08-22 02:10:00 | ES | Futures | 3109.39 | 3109.93 | 3109.11 | 3109.39 | 355.0 |
| 2018-08-22 02:15:00 | ES | Futures | 3109.39 | 3109.39 | 3108.3 | 3108.57 | 831.0 |
| 2018-08-22 02:20:00 | ES | Futures | 3108.57 | 3108.84 | 3108.3 | 3108.57 | 419.0 |
| 2018-08-22 02:25:00 | ES | Futures | 3108.57 | 3109.39 | 3107.48 | 3109.11 | 2011.0 |
| 2018-08-22 02:30:00 | ES | Futures | 3109.11 | 3109.11 | 3108.02 | 3109.11 | 669.0 |
| 2018-08-22 02:35:00 | ES | Futures | 3108.84 | 3109.93 | 3108.57 | 3109.93 | 396.0 |
| 2018-08-22 02:40:00 | ES | Futures | 3109.93 | 3111.02 | 3109.93 | 3111.02 | 1111.0 |
| 2018-08-22 02:45:00 | ES | Futures | 3110.75 | 3112.11 | 3110.75 | 3111.84 | 1408.0 |
| 2018-08-22 02:50:00 | ES | Futures | 3111.84 | 3112.38 | 3111.57 | 3111.84 | 1716.0 |
| 2018-08-22 02:55:00 | ES | Futures | 3111.57 | 3112.65 | 3111.57 | 3111.57 | 719.0 |
| 2018-08-22 03:00:00 | ES | Futures | 3111.57 | 3113.47 | 3110.75 | 3113.2 | 2974.0 |
| 2018-08-22 03:05:00 | ES | Futures | 3112.93 | 3114.02 | 3112.65 | 3112.93 | 2341.0 |
| 2018-08-22 03:10:00 | ES | Futures | 3112.65 | 3113.2 | 3112.11 | 3113.2 | 1319.0 |
| 2018-08-22 03:15:00 | ES | Futures | 3113.2 | 3114.29 | 3112.38 | 3112.93 | 2135.0 |
| 2018-08-22 03:20:00 | ES | Futures | 3112.65 | 3113.2 | 3112.38 | 3112.38 | 767.0 |
| 2018-08-22 03:25:00 | ES | Futures | 3112.38 | 3113.2 | 3112.11 | 3112.11 | 1052.0 |
| 2018-08-22 03:30:00 | ES | Futures | 3112.11 | 3112.93 | 3111.57 | 3112.93 | 1086.0 |
| 2018-08-22 03:35:00 | ES | Futures | 3112.93 | 3113.2 | 3112.38 | 3112.93 | 548.0 |
| 2018-08-22 03:40:00 | ES | Futures | 3112.93 | 3112.93 | 3112.38 | 3112.93 | 431.0 |
| 2018-08-22 03:45:00 | ES | Futures | 3112.65 | 3112.93 | 3111.57 | 3112.11 | 804.0 |
| 2018-08-22 03:50:00 | ES | Futures | 3112.38 | 3112.65 | 3111.29 | 3112.38 | 701.0 |
| 2018-08-22 03:55:00 | ES | Futures | 3112.11 | 3113.47 | 3111.84 | 3112.11 | 1299.0 |
| 2018-08-22 04:00:00 | ES | Futures | 3111.84 | 3112.65 | 3111.57 | 3111.57 | 1481.0 |
| 2018-08-22 04:05:00 | ES | Futures | 3111.84 | 3112.11 | 3111.02 | 3111.84 | 1182.0 |
> showing 50 of 15,235 rows — these rows as CSV