PREVIEW / futures_5min / 2019-07-31
file: by_date/futures_5min/2019/2019-07-31.parquet size: 293 KB rows: 17,692
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-07-31 00:00:00 | ES | Futures | 3268.76 | 3269.31 | 3268.49 | 3268.76 | 348.0 |
| 2019-07-31 00:05:00 | ES | Futures | 3268.76 | 3269.31 | 3268.49 | 3269.31 | 194.0 |
| 2019-07-31 00:10:00 | ES | Futures | 3269.03 | 3269.31 | 3268.76 | 3268.76 | 305.0 |
| 2019-07-31 00:15:00 | ES | Futures | 3269.03 | 3269.58 | 3269.03 | 3269.58 | 393.0 |
| 2019-07-31 00:20:00 | ES | Futures | 3269.58 | 3269.85 | 3269.31 | 3269.31 | 501.0 |
| 2019-07-31 00:25:00 | ES | Futures | 3269.31 | 3269.58 | 3269.03 | 3269.31 | 373.0 |
| 2019-07-31 00:30:00 | ES | Futures | 3269.31 | 3269.85 | 3269.31 | 3269.58 | 253.0 |
| 2019-07-31 00:35:00 | ES | Futures | 3269.58 | 3269.58 | 3269.03 | 3269.31 | 337.0 |
| 2019-07-31 00:40:00 | ES | Futures | 3269.31 | 3269.58 | 3269.03 | 3269.31 | 225.0 |
| 2019-07-31 00:45:00 | ES | Futures | 3269.31 | 3269.58 | 3269.03 | 3269.31 | 251.0 |
| 2019-07-31 00:50:00 | ES | Futures | 3269.31 | 3269.85 | 3269.31 | 3269.85 | 151.0 |
| 2019-07-31 00:55:00 | ES | Futures | 3269.85 | 3269.85 | 3269.31 | 3269.31 | 253.0 |
| 2019-07-31 01:00:00 | ES | Futures | 3269.58 | 3270.39 | 3269.31 | 3270.39 | 682.0 |
| 2019-07-31 01:05:00 | ES | Futures | 3270.12 | 3270.39 | 3269.31 | 3269.58 | 974.0 |
| 2019-07-31 01:10:00 | ES | Futures | 3269.58 | 3269.58 | 3269.03 | 3269.31 | 293.0 |
| 2019-07-31 01:15:00 | ES | Futures | 3269.31 | 3269.58 | 3268.22 | 3268.22 | 440.0 |
| 2019-07-31 01:20:00 | ES | Futures | 3268.22 | 3268.76 | 3268.22 | 3268.76 | 269.0 |
| 2019-07-31 01:25:00 | ES | Futures | 3268.76 | 3268.76 | 3268.49 | 3268.76 | 364.0 |
| 2019-07-31 01:30:00 | ES | Futures | 3268.76 | 3269.03 | 3268.49 | 3268.76 | 511.0 |
| 2019-07-31 01:35:00 | ES | Futures | 3268.76 | 3269.31 | 3268.49 | 3269.31 | 394.0 |
| 2019-07-31 01:40:00 | ES | Futures | 3269.31 | 3269.58 | 3267.95 | 3268.49 | 541.0 |
| 2019-07-31 01:45:00 | ES | Futures | 3268.49 | 3268.76 | 3267.95 | 3268.76 | 415.0 |
| 2019-07-31 01:50:00 | ES | Futures | 3268.76 | 3269.31 | 3268.22 | 3269.03 | 835.0 |
| 2019-07-31 01:55:00 | ES | Futures | 3269.03 | 3269.58 | 3269.03 | 3269.03 | 597.0 |
| 2019-07-31 02:00:00 | ES | Futures | 3268.76 | 3270.12 | 3268.76 | 3269.85 | 1226.0 |
| 2019-07-31 02:05:00 | ES | Futures | 3269.85 | 3270.12 | 3269.03 | 3270.12 | 1293.0 |
| 2019-07-31 02:10:00 | ES | Futures | 3270.39 | 3270.93 | 3269.58 | 3269.58 | 1983.0 |
| 2019-07-31 02:15:00 | ES | Futures | 3269.85 | 3269.85 | 3268.22 | 3268.22 | 1245.0 |
| 2019-07-31 02:20:00 | ES | Futures | 3268.22 | 3268.22 | 3264.7 | 3265.52 | 4242.0 |
| 2019-07-31 02:25:00 | ES | Futures | 3265.52 | 3266.06 | 3265.24 | 3265.24 | 1582.0 |
| 2019-07-31 02:30:00 | ES | Futures | 3265.24 | 3265.79 | 3264.97 | 3265.52 | 1217.0 |
| 2019-07-31 02:35:00 | ES | Futures | 3265.52 | 3265.79 | 3264.97 | 3265.24 | 984.0 |
| 2019-07-31 02:40:00 | ES | Futures | 3265.52 | 3266.6 | 3265.52 | 3266.06 | 1310.0 |
| 2019-07-31 02:45:00 | ES | Futures | 3266.33 | 3266.33 | 3264.16 | 3265.52 | 3701.0 |
| 2019-07-31 02:50:00 | ES | Futures | 3265.24 | 3267.14 | 3264.97 | 3266.06 | 3066.0 |
| 2019-07-31 02:55:00 | ES | Futures | 3266.06 | 3266.06 | 3264.16 | 3264.16 | 1598.0 |
| 2019-07-31 03:00:00 | ES | Futures | 3264.16 | 3265.79 | 3263.62 | 3264.43 | 4634.0 |
| 2019-07-31 03:05:00 | ES | Futures | 3264.16 | 3266.06 | 3264.16 | 3266.06 | 2690.0 |
| 2019-07-31 03:10:00 | ES | Futures | 3266.06 | 3267.95 | 3266.06 | 3266.6 | 2718.0 |
| 2019-07-31 03:15:00 | ES | Futures | 3266.87 | 3267.95 | 3266.06 | 3266.87 | 2501.0 |
| 2019-07-31 03:20:00 | ES | Futures | 3266.87 | 3267.68 | 3266.33 | 3267.68 | 1897.0 |
| 2019-07-31 03:25:00 | ES | Futures | 3267.68 | 3267.68 | 3266.87 | 3266.87 | 2212.0 |
| 2019-07-31 03:30:00 | ES | Futures | 3266.87 | 3268.49 | 3266.87 | 3267.95 | 1284.0 |
| 2019-07-31 03:35:00 | ES | Futures | 3268.22 | 3268.49 | 3267.68 | 3267.95 | 1240.0 |
| 2019-07-31 03:40:00 | ES | Futures | 3267.95 | 3268.22 | 3267.14 | 3267.95 | 1083.0 |
| 2019-07-31 03:45:00 | ES | Futures | 3267.95 | 3268.22 | 3266.87 | 3267.14 | 876.0 |
| 2019-07-31 03:50:00 | ES | Futures | 3266.87 | 3267.41 | 3266.6 | 3267.14 | 899.0 |
| 2019-07-31 03:55:00 | ES | Futures | 3267.41 | 3267.41 | 3266.33 | 3266.6 | 813.0 |
| 2019-07-31 04:00:00 | ES | Futures | 3266.87 | 3268.22 | 3266.6 | 3267.68 | 1606.0 |
| 2019-07-31 04:05:00 | ES | Futures | 3267.95 | 3269.31 | 3267.95 | 3268.76 | 1279.0 |
> showing 50 of 17,692 rows — these rows as CSV