PREVIEW / futures_5min / 2018-09-28
file: by_date/futures_5min/2018/2018-09-28.parquet size: 235 KB rows: 13,633
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-28 00:00:00 | ES | Futures | 3180.2 | 3180.48 | 3179.93 | 3180.48 | 180.0 |
| 2018-09-28 00:05:00 | ES | Futures | 3180.2 | 3180.2 | 3179.93 | 3179.93 | 184.0 |
| 2018-09-28 00:10:00 | ES | Futures | 3179.93 | 3179.93 | 3179.39 | 3179.39 | 440.0 |
| 2018-09-28 00:15:00 | ES | Futures | 3179.39 | 3179.39 | 3178.84 | 3179.12 | 509.0 |
| 2018-09-28 00:20:00 | ES | Futures | 3178.84 | 3179.39 | 3178.57 | 3178.57 | 208.0 |
| 2018-09-28 00:25:00 | ES | Futures | 3178.57 | 3179.39 | 3178.57 | 3179.12 | 169.0 |
| 2018-09-28 00:30:00 | ES | Futures | 3178.84 | 3179.12 | 3178.57 | 3178.84 | 85.0 |
| 2018-09-28 00:35:00 | ES | Futures | 3178.57 | 3179.12 | 3178.57 | 3178.84 | 92.0 |
| 2018-09-28 00:40:00 | ES | Futures | 3179.12 | 3179.12 | 3178.3 | 3178.84 | 446.0 |
| 2018-09-28 00:45:00 | ES | Futures | 3178.84 | 3179.12 | 3178.84 | 3179.12 | 250.0 |
| 2018-09-28 00:50:00 | ES | Futures | 3178.84 | 3178.84 | 3178.3 | 3178.57 | 289.0 |
| 2018-09-28 00:55:00 | ES | Futures | 3178.57 | 3179.93 | 3178.57 | 3179.66 | 370.0 |
| 2018-09-28 01:00:00 | ES | Futures | 3179.66 | 3179.93 | 3179.39 | 3179.39 | 310.0 |
| 2018-09-28 01:05:00 | ES | Futures | 3179.39 | 3179.66 | 3178.84 | 3179.12 | 230.0 |
| 2018-09-28 01:10:00 | ES | Futures | 3178.84 | 3179.39 | 3178.3 | 3178.3 | 291.0 |
| 2018-09-28 01:15:00 | ES | Futures | 3178.3 | 3178.84 | 3178.3 | 3178.3 | 390.0 |
| 2018-09-28 01:20:00 | ES | Futures | 3178.57 | 3178.57 | 3178.03 | 3178.3 | 151.0 |
| 2018-09-28 01:25:00 | ES | Futures | 3178.57 | 3178.84 | 3178.3 | 3178.3 | 270.0 |
| 2018-09-28 01:30:00 | ES | Futures | 3178.57 | 3178.84 | 3178.3 | 3178.84 | 213.0 |
| 2018-09-28 01:35:00 | ES | Futures | 3178.57 | 3178.84 | 3178.3 | 3178.84 | 248.0 |
| 2018-09-28 01:40:00 | ES | Futures | 3178.84 | 3179.12 | 3178.57 | 3178.57 | 465.0 |
| 2018-09-28 01:45:00 | ES | Futures | 3178.84 | 3178.84 | 3178.3 | 3178.3 | 495.0 |
| 2018-09-28 01:50:00 | ES | Futures | 3178.57 | 3178.84 | 3178.3 | 3178.57 | 961.0 |
| 2018-09-28 01:55:00 | ES | Futures | 3178.57 | 3178.84 | 3178.03 | 3178.03 | 488.0 |
| 2018-09-28 02:00:00 | ES | Futures | 3178.3 | 3178.57 | 3177.76 | 3178.03 | 1071.0 |
| 2018-09-28 02:05:00 | ES | Futures | 3177.76 | 3178.03 | 3177.21 | 3177.21 | 587.0 |
| 2018-09-28 02:10:00 | ES | Futures | 3177.21 | 3177.48 | 3176.94 | 3177.21 | 928.0 |
| 2018-09-28 02:15:00 | ES | Futures | 3177.21 | 3177.48 | 3176.94 | 3177.21 | 801.0 |
| 2018-09-28 02:20:00 | ES | Futures | 3177.21 | 3177.48 | 3176.94 | 3176.94 | 302.0 |
| 2018-09-28 02:25:00 | ES | Futures | 3176.94 | 3177.21 | 3176.12 | 3176.12 | 1015.0 |
| 2018-09-28 02:30:00 | ES | Futures | 3176.4 | 3176.67 | 3176.12 | 3176.67 | 512.0 |
| 2018-09-28 02:35:00 | ES | Futures | 3176.4 | 3176.4 | 3175.31 | 3175.58 | 893.0 |
| 2018-09-28 02:40:00 | ES | Futures | 3175.31 | 3175.58 | 3175.31 | 3175.31 | 710.0 |
| 2018-09-28 02:45:00 | ES | Futures | 3175.31 | 3176.4 | 3175.31 | 3175.85 | 733.0 |
| 2018-09-28 02:50:00 | ES | Futures | 3175.85 | 3176.12 | 3175.04 | 3175.31 | 831.0 |
| 2018-09-28 02:55:00 | ES | Futures | 3175.31 | 3175.31 | 3174.76 | 3175.04 | 983.0 |
| 2018-09-28 03:00:00 | ES | Futures | 3174.76 | 3175.31 | 3174.49 | 3174.76 | 2445.0 |
| 2018-09-28 03:05:00 | ES | Futures | 3174.49 | 3174.49 | 3172.32 | 3172.59 | 4479.0 |
| 2018-09-28 03:10:00 | ES | Futures | 3172.86 | 3173.68 | 3171.5 | 3173.68 | 3271.0 |
| 2018-09-28 03:15:00 | ES | Futures | 3173.4 | 3175.04 | 3173.13 | 3175.04 | 3026.0 |
| 2018-09-28 03:20:00 | ES | Futures | 3175.04 | 3175.04 | 3173.13 | 3173.68 | 2175.0 |
| 2018-09-28 03:25:00 | ES | Futures | 3173.68 | 3173.68 | 3172.59 | 3172.86 | 2910.0 |
| 2018-09-28 03:30:00 | ES | Futures | 3172.86 | 3174.22 | 3172.86 | 3174.22 | 1572.0 |
| 2018-09-28 03:35:00 | ES | Futures | 3174.22 | 3174.76 | 3173.68 | 3174.49 | 2536.0 |
| 2018-09-28 03:40:00 | ES | Futures | 3174.49 | 3176.12 | 3174.49 | 3175.31 | 1905.0 |
| 2018-09-28 03:45:00 | ES | Futures | 3175.31 | 3175.31 | 3173.95 | 3174.76 | 1138.0 |
| 2018-09-28 03:50:00 | ES | Futures | 3174.76 | 3174.76 | 3173.13 | 3173.95 | 1346.0 |
| 2018-09-28 03:55:00 | ES | Futures | 3173.68 | 3174.22 | 3173.68 | 3174.22 | 1355.0 |
| 2018-09-28 04:00:00 | ES | Futures | 3174.22 | 3175.31 | 3173.4 | 3174.76 | 2162.0 |
| 2018-09-28 04:05:00 | ES | Futures | 3174.76 | 3175.58 | 3174.49 | 3175.58 | 1407.0 |
> showing 50 of 13,633 rows — these rows as CSV