PREVIEW / futures_5min / 2019-06-17
file: by_date/futures_5min/2019/2019-06-17.parquet size: 238 KB rows: 16,546
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-17 00:00:00 | ES | Futures | 3142.89 | 3143.16 | 3142.89 | 3143.16 | 93.0 |
| 2019-06-17 00:05:00 | ES | Futures | 3143.16 | 3143.16 | 3142.62 | 3143.16 | 342.0 |
| 2019-06-17 00:10:00 | ES | Futures | 3143.16 | 3143.16 | 3142.34 | 3142.34 | 238.0 |
| 2019-06-17 00:15:00 | ES | Futures | 3142.34 | 3142.62 | 3142.07 | 3142.07 | 523.0 |
| 2019-06-17 00:20:00 | ES | Futures | 3142.07 | 3142.07 | 3141.8 | 3142.07 | 116.0 |
| 2019-06-17 00:25:00 | ES | Futures | 3142.07 | 3142.07 | 3141.8 | 3142.07 | 321.0 |
| 2019-06-17 00:30:00 | ES | Futures | 3141.8 | 3142.07 | 3141.53 | 3141.8 | 120.0 |
| 2019-06-17 00:35:00 | ES | Futures | 3141.8 | 3141.8 | 3141.53 | 3141.53 | 66.0 |
| 2019-06-17 00:40:00 | ES | Futures | 3141.8 | 3142.62 | 3141.53 | 3142.34 | 539.0 |
| 2019-06-17 00:45:00 | ES | Futures | 3142.34 | 3142.62 | 3142.07 | 3142.34 | 240.0 |
| 2019-06-17 00:50:00 | ES | Futures | 3142.07 | 3142.62 | 3142.07 | 3142.34 | 137.0 |
| 2019-06-17 00:55:00 | ES | Futures | 3142.34 | 3142.62 | 3142.07 | 3142.34 | 174.0 |
| 2019-06-17 01:00:00 | ES | Futures | 3142.34 | 3142.62 | 3141.8 | 3142.34 | 580.0 |
| 2019-06-17 01:05:00 | ES | Futures | 3142.34 | 3143.16 | 3142.07 | 3143.16 | 759.0 |
| 2019-06-17 01:10:00 | ES | Futures | 3143.16 | 3143.7 | 3143.16 | 3143.7 | 307.0 |
| 2019-06-17 01:15:00 | ES | Futures | 3143.43 | 3143.43 | 3143.16 | 3143.43 | 266.0 |
| 2019-06-17 01:20:00 | ES | Futures | 3143.43 | 3143.43 | 3142.89 | 3143.16 | 320.0 |
| 2019-06-17 01:25:00 | ES | Futures | 3143.16 | 3143.16 | 3142.34 | 3142.62 | 154.0 |
| 2019-06-17 01:30:00 | ES | Futures | 3142.62 | 3143.43 | 3142.62 | 3142.89 | 405.0 |
| 2019-06-17 01:35:00 | ES | Futures | 3143.16 | 3143.7 | 3143.16 | 3143.16 | 274.0 |
| 2019-06-17 01:40:00 | ES | Futures | 3143.16 | 3143.16 | 3142.62 | 3142.89 | 256.0 |
| 2019-06-17 01:45:00 | ES | Futures | 3142.62 | 3142.89 | 3142.34 | 3142.62 | 112.0 |
| 2019-06-17 01:50:00 | ES | Futures | 3142.62 | 3142.62 | 3142.34 | 3142.34 | 119.0 |
| 2019-06-17 01:55:00 | ES | Futures | 3142.34 | 3142.62 | 3140.99 | 3141.53 | 906.0 |
| 2019-06-17 02:00:00 | ES | Futures | 3141.53 | 3141.8 | 3139.91 | 3140.18 | 1258.0 |
| 2019-06-17 02:05:00 | ES | Futures | 3140.18 | 3140.45 | 3139.91 | 3140.18 | 577.0 |
| 2019-06-17 02:10:00 | ES | Futures | 3139.91 | 3140.18 | 3139.64 | 3140.18 | 557.0 |
| 2019-06-17 02:15:00 | ES | Futures | 3140.18 | 3140.18 | 3139.91 | 3139.91 | 304.0 |
| 2019-06-17 02:20:00 | ES | Futures | 3140.18 | 3140.18 | 3139.91 | 3140.18 | 891.0 |
| 2019-06-17 02:25:00 | ES | Futures | 3139.91 | 3140.18 | 3139.64 | 3139.64 | 457.0 |
| 2019-06-17 02:30:00 | ES | Futures | 3139.91 | 3140.18 | 3138.83 | 3138.83 | 504.0 |
| 2019-06-17 02:35:00 | ES | Futures | 3138.83 | 3139.37 | 3138.83 | 3139.37 | 333.0 |
| 2019-06-17 02:40:00 | ES | Futures | 3139.37 | 3139.64 | 3139.1 | 3139.1 | 293.0 |
| 2019-06-17 02:45:00 | ES | Futures | 3139.1 | 3139.64 | 3139.1 | 3139.64 | 258.0 |
| 2019-06-17 02:50:00 | ES | Futures | 3139.64 | 3140.18 | 3139.37 | 3139.64 | 217.0 |
| 2019-06-17 02:55:00 | ES | Futures | 3139.91 | 3140.18 | 3139.1 | 3139.1 | 694.0 |
| 2019-06-17 03:00:00 | ES | Futures | 3139.1 | 3139.37 | 3138.01 | 3138.28 | 1997.0 |
| 2019-06-17 03:05:00 | ES | Futures | 3138.28 | 3138.55 | 3136.39 | 3136.66 | 1709.0 |
| 2019-06-17 03:10:00 | ES | Futures | 3136.66 | 3137.47 | 3136.12 | 3137.47 | 1166.0 |
| 2019-06-17 03:15:00 | ES | Futures | 3137.47 | 3137.74 | 3136.93 | 3137.2 | 818.0 |
| 2019-06-17 03:20:00 | ES | Futures | 3137.2 | 3137.74 | 3136.93 | 3137.2 | 841.0 |
| 2019-06-17 03:25:00 | ES | Futures | 3136.93 | 3139.91 | 3136.93 | 3139.91 | 1352.0 |
| 2019-06-17 03:30:00 | ES | Futures | 3139.91 | 3140.18 | 3139.37 | 3139.37 | 1374.0 |
| 2019-06-17 03:35:00 | ES | Futures | 3139.37 | 3139.64 | 3139.37 | 3139.64 | 453.0 |
| 2019-06-17 03:40:00 | ES | Futures | 3139.64 | 3140.18 | 3138.83 | 3138.83 | 1140.0 |
| 2019-06-17 03:45:00 | ES | Futures | 3138.83 | 3139.91 | 3138.83 | 3139.37 | 833.0 |
| 2019-06-17 03:50:00 | ES | Futures | 3139.37 | 3139.64 | 3138.55 | 3138.83 | 574.0 |
| 2019-06-17 03:55:00 | ES | Futures | 3138.83 | 3139.1 | 3136.93 | 3137.2 | 1272.0 |
| 2019-06-17 04:00:00 | ES | Futures | 3137.47 | 3137.47 | 3136.66 | 3136.93 | 995.0 |
| 2019-06-17 04:05:00 | ES | Futures | 3137.2 | 3138.28 | 3137.2 | 3138.28 | 830.0 |
> showing 50 of 16,546 rows — these rows as CSV