PREVIEW / futures_5min / 2019-07-25
file: by_date/futures_5min/2019/2019-07-25.parquet size: 283 KB rows: 17,259
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-25 00:00:00 | ES | Futures | 3272.55 | 3272.55 | 3272.01 | 3272.28 | 600.0 |
| 2019-07-25 00:05:00 | ES | Futures | 3272.55 | 3272.55 | 3272.01 | 3272.28 | 194.0 |
| 2019-07-25 00:10:00 | ES | Futures | 3272.28 | 3272.55 | 3272.01 | 3272.28 | 131.0 |
| 2019-07-25 00:15:00 | ES | Futures | 3272.55 | 3272.55 | 3272.28 | 3272.28 | 188.0 |
| 2019-07-25 00:20:00 | ES | Futures | 3272.55 | 3272.82 | 3272.28 | 3272.55 | 155.0 |
| 2019-07-25 00:25:00 | ES | Futures | 3272.55 | 3273.09 | 3272.55 | 3273.09 | 217.0 |
| 2019-07-25 00:30:00 | ES | Futures | 3273.09 | 3273.37 | 3272.82 | 3272.82 | 462.0 |
| 2019-07-25 00:35:00 | ES | Futures | 3272.82 | 3272.82 | 3272.82 | 3272.82 | 101.0 |
| 2019-07-25 00:40:00 | ES | Futures | 3272.82 | 3273.09 | 3272.55 | 3272.82 | 381.0 |
| 2019-07-25 00:45:00 | ES | Futures | 3272.82 | 3272.82 | 3272.55 | 3272.55 | 42.0 |
| 2019-07-25 00:50:00 | ES | Futures | 3272.55 | 3273.09 | 3272.55 | 3272.82 | 167.0 |
| 2019-07-25 00:55:00 | ES | Futures | 3272.82 | 3273.09 | 3272.55 | 3272.82 | 185.0 |
| 2019-07-25 01:00:00 | ES | Futures | 3273.09 | 3273.09 | 3272.55 | 3272.55 | 481.0 |
| 2019-07-25 01:05:00 | ES | Futures | 3272.55 | 3273.64 | 3272.55 | 3273.37 | 864.0 |
| 2019-07-25 01:10:00 | ES | Futures | 3273.64 | 3274.99 | 3273.37 | 3274.72 | 1478.0 |
| 2019-07-25 01:15:00 | ES | Futures | 3274.72 | 3274.72 | 3274.18 | 3274.45 | 1043.0 |
| 2019-07-25 01:20:00 | ES | Futures | 3274.45 | 3274.72 | 3273.91 | 3274.18 | 503.0 |
| 2019-07-25 01:25:00 | ES | Futures | 3274.18 | 3274.45 | 3273.91 | 3274.18 | 467.0 |
| 2019-07-25 01:30:00 | ES | Futures | 3274.18 | 3274.45 | 3273.64 | 3273.64 | 331.0 |
| 2019-07-25 01:35:00 | ES | Futures | 3273.64 | 3273.91 | 3273.37 | 3273.91 | 375.0 |
| 2019-07-25 01:40:00 | ES | Futures | 3273.91 | 3273.91 | 3273.64 | 3273.91 | 222.0 |
| 2019-07-25 01:45:00 | ES | Futures | 3273.91 | 3274.18 | 3273.64 | 3273.91 | 167.0 |
| 2019-07-25 01:50:00 | ES | Futures | 3274.18 | 3274.18 | 3273.64 | 3273.64 | 321.0 |
| 2019-07-25 01:55:00 | ES | Futures | 3273.64 | 3273.91 | 3273.37 | 3273.64 | 306.0 |
| 2019-07-25 02:00:00 | ES | Futures | 3273.91 | 3274.45 | 3273.09 | 3273.91 | 1873.0 |
| 2019-07-25 02:05:00 | ES | Futures | 3274.18 | 3274.18 | 3273.64 | 3273.91 | 596.0 |
| 2019-07-25 02:10:00 | ES | Futures | 3273.91 | 3274.72 | 3273.91 | 3274.18 | 545.0 |
| 2019-07-25 02:15:00 | ES | Futures | 3274.45 | 3274.99 | 3273.91 | 3273.91 | 1060.0 |
| 2019-07-25 02:20:00 | ES | Futures | 3274.18 | 3274.45 | 3273.91 | 3274.45 | 402.0 |
| 2019-07-25 02:25:00 | ES | Futures | 3274.18 | 3274.72 | 3274.18 | 3274.18 | 802.0 |
| 2019-07-25 02:30:00 | ES | Futures | 3274.45 | 3274.99 | 3274.18 | 3274.99 | 600.0 |
| 2019-07-25 02:35:00 | ES | Futures | 3274.99 | 3274.99 | 3274.18 | 3274.99 | 614.0 |
| 2019-07-25 02:40:00 | ES | Futures | 3274.72 | 3274.99 | 3274.45 | 3274.99 | 470.0 |
| 2019-07-25 02:45:00 | ES | Futures | 3274.99 | 3275.26 | 3274.45 | 3274.72 | 674.0 |
| 2019-07-25 02:50:00 | ES | Futures | 3274.99 | 3274.99 | 3274.18 | 3274.45 | 385.0 |
| 2019-07-25 02:55:00 | ES | Futures | 3274.45 | 3274.99 | 3274.18 | 3274.72 | 717.0 |
| 2019-07-25 03:00:00 | ES | Futures | 3274.45 | 3274.72 | 3273.09 | 3273.09 | 2729.0 |
| 2019-07-25 03:05:00 | ES | Futures | 3273.09 | 3273.91 | 3272.01 | 3272.01 | 2758.0 |
| 2019-07-25 03:10:00 | ES | Futures | 3271.74 | 3272.82 | 3271.47 | 3272.55 | 1563.0 |
| 2019-07-25 03:15:00 | ES | Futures | 3272.28 | 3272.55 | 3270.93 | 3270.93 | 939.0 |
| 2019-07-25 03:20:00 | ES | Futures | 3271.2 | 3272.01 | 3270.93 | 3271.47 | 1870.0 |
| 2019-07-25 03:25:00 | ES | Futures | 3271.47 | 3272.28 | 3270.93 | 3272.01 | 1254.0 |
| 2019-07-25 03:30:00 | ES | Futures | 3271.74 | 3272.82 | 3271.74 | 3272.55 | 1687.0 |
| 2019-07-25 03:35:00 | ES | Futures | 3272.28 | 3272.55 | 3271.74 | 3272.28 | 1211.0 |
| 2019-07-25 03:40:00 | ES | Futures | 3272.55 | 3272.55 | 3271.2 | 3271.2 | 1041.0 |
| 2019-07-25 03:45:00 | ES | Futures | 3271.2 | 3272.01 | 3271.2 | 3271.47 | 778.0 |
| 2019-07-25 03:50:00 | ES | Futures | 3271.47 | 3272.55 | 3271.2 | 3272.55 | 1000.0 |
| 2019-07-25 03:55:00 | ES | Futures | 3272.55 | 3273.09 | 3272.28 | 3272.55 | 1031.0 |
| 2019-07-25 04:00:00 | ES | Futures | 3272.55 | 3272.82 | 3271.74 | 3272.55 | 1383.0 |
| 2019-07-25 04:05:00 | ES | Futures | 3272.55 | 3272.82 | 3272.28 | 3272.28 | 1275.0 |
> showing 50 of 17,259 rows — these rows as CSV