PREVIEW / futures_5min / 2019-07-18
file: by_date/futures_5min/2019/2019-07-18.parquet size: 299 KB rows: 17,918
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-18 00:00:00 | ES | Futures | 3225.18 | 3225.45 | 3224.91 | 3224.91 | 433.0 |
| 2019-07-18 00:05:00 | ES | Futures | 3224.91 | 3225.18 | 3224.64 | 3224.91 | 284.0 |
| 2019-07-18 00:10:00 | ES | Futures | 3224.64 | 3224.91 | 3223.01 | 3223.56 | 1377.0 |
| 2019-07-18 00:15:00 | ES | Futures | 3223.56 | 3224.64 | 3223.56 | 3224.64 | 619.0 |
| 2019-07-18 00:20:00 | ES | Futures | 3224.64 | 3225.45 | 3224.1 | 3225.45 | 514.0 |
| 2019-07-18 00:25:00 | ES | Futures | 3225.45 | 3225.45 | 3224.64 | 3224.91 | 478.0 |
| 2019-07-18 00:30:00 | ES | Futures | 3224.91 | 3225.72 | 3224.64 | 3225.45 | 453.0 |
| 2019-07-18 00:35:00 | ES | Futures | 3225.45 | 3225.45 | 3225.18 | 3225.18 | 316.0 |
| 2019-07-18 00:40:00 | ES | Futures | 3225.18 | 3225.99 | 3224.91 | 3225.99 | 477.0 |
| 2019-07-18 00:45:00 | ES | Futures | 3225.72 | 3225.99 | 3225.45 | 3225.72 | 384.0 |
| 2019-07-18 00:50:00 | ES | Futures | 3225.99 | 3226.26 | 3225.72 | 3226.26 | 325.0 |
| 2019-07-18 00:55:00 | ES | Futures | 3226.26 | 3226.26 | 3225.72 | 3225.72 | 186.0 |
| 2019-07-18 01:00:00 | ES | Futures | 3225.99 | 3226.26 | 3225.72 | 3225.72 | 509.0 |
| 2019-07-18 01:05:00 | ES | Futures | 3225.72 | 3225.99 | 3225.18 | 3225.18 | 353.0 |
| 2019-07-18 01:10:00 | ES | Futures | 3225.45 | 3225.72 | 3225.18 | 3225.18 | 671.0 |
| 2019-07-18 01:15:00 | ES | Futures | 3225.18 | 3225.45 | 3224.37 | 3224.37 | 370.0 |
| 2019-07-18 01:20:00 | ES | Futures | 3224.37 | 3224.64 | 3223.29 | 3223.83 | 1179.0 |
| 2019-07-18 01:25:00 | ES | Futures | 3223.83 | 3224.64 | 3223.56 | 3223.83 | 429.0 |
| 2019-07-18 01:30:00 | ES | Futures | 3224.1 | 3224.37 | 3222.47 | 3222.47 | 2088.0 |
| 2019-07-18 01:35:00 | ES | Futures | 3222.47 | 3223.01 | 3221.93 | 3222.2 | 1042.0 |
| 2019-07-18 01:40:00 | ES | Futures | 3222.2 | 3223.01 | 3221.93 | 3222.74 | 734.0 |
| 2019-07-18 01:45:00 | ES | Futures | 3223.01 | 3223.29 | 3222.2 | 3223.29 | 711.0 |
| 2019-07-18 01:50:00 | ES | Futures | 3223.01 | 3223.01 | 3222.47 | 3222.47 | 955.0 |
| 2019-07-18 01:55:00 | ES | Futures | 3222.47 | 3223.29 | 3222.47 | 3223.01 | 1022.0 |
| 2019-07-18 02:00:00 | ES | Futures | 3223.01 | 3223.56 | 3223.01 | 3223.56 | 1439.0 |
| 2019-07-18 02:05:00 | ES | Futures | 3223.56 | 3224.64 | 3223.29 | 3224.64 | 1004.0 |
| 2019-07-18 02:10:00 | ES | Futures | 3224.37 | 3225.45 | 3224.37 | 3225.45 | 1193.0 |
| 2019-07-18 02:15:00 | ES | Futures | 3225.45 | 3226.8 | 3225.18 | 3226.26 | 1184.0 |
| 2019-07-18 02:20:00 | ES | Futures | 3226.53 | 3226.8 | 3225.72 | 3226.26 | 1010.0 |
| 2019-07-18 02:25:00 | ES | Futures | 3225.99 | 3226.26 | 3225.72 | 3225.72 | 653.0 |
| 2019-07-18 02:30:00 | ES | Futures | 3225.72 | 3225.99 | 3224.37 | 3224.37 | 1135.0 |
| 2019-07-18 02:35:00 | ES | Futures | 3224.64 | 3224.91 | 3224.1 | 3224.37 | 1316.0 |
| 2019-07-18 02:40:00 | ES | Futures | 3224.64 | 3225.45 | 3224.37 | 3224.91 | 1617.0 |
| 2019-07-18 02:45:00 | ES | Futures | 3224.64 | 3224.91 | 3224.1 | 3224.37 | 570.0 |
| 2019-07-18 02:50:00 | ES | Futures | 3224.37 | 3225.18 | 3224.37 | 3224.64 | 537.0 |
| 2019-07-18 02:55:00 | ES | Futures | 3224.64 | 3224.91 | 3223.83 | 3224.37 | 798.0 |
| 2019-07-18 03:00:00 | ES | Futures | 3224.37 | 3224.91 | 3223.01 | 3223.29 | 4257.0 |
| 2019-07-18 03:05:00 | ES | Futures | 3223.56 | 3224.1 | 3223.01 | 3223.83 | 2049.0 |
| 2019-07-18 03:10:00 | ES | Futures | 3224.1 | 3224.91 | 3223.56 | 3224.1 | 2201.0 |
| 2019-07-18 03:15:00 | ES | Futures | 3224.1 | 3224.64 | 3223.83 | 3224.1 | 1472.0 |
| 2019-07-18 03:20:00 | ES | Futures | 3224.37 | 3225.18 | 3223.83 | 3224.37 | 2027.0 |
| 2019-07-18 03:25:00 | ES | Futures | 3224.37 | 3224.91 | 3223.83 | 3224.37 | 2004.0 |
| 2019-07-18 03:30:00 | ES | Futures | 3224.37 | 3225.18 | 3224.1 | 3225.18 | 1745.0 |
| 2019-07-18 03:35:00 | ES | Futures | 3225.18 | 3225.72 | 3224.91 | 3225.18 | 1828.0 |
| 2019-07-18 03:40:00 | ES | Futures | 3225.18 | 3225.72 | 3225.18 | 3225.18 | 1469.0 |
| 2019-07-18 03:45:00 | ES | Futures | 3225.18 | 3226.53 | 3225.18 | 3225.99 | 2256.0 |
| 2019-07-18 03:50:00 | ES | Futures | 3226.26 | 3227.89 | 3225.99 | 3227.35 | 3050.0 |
| 2019-07-18 03:55:00 | ES | Futures | 3227.35 | 3227.89 | 3226.8 | 3226.8 | 2155.0 |
| 2019-07-18 04:00:00 | ES | Futures | 3226.8 | 3227.08 | 3224.91 | 3224.91 | 2431.0 |
| 2019-07-18 04:05:00 | ES | Futures | 3225.18 | 3225.18 | 3224.1 | 3224.91 | 1624.0 |
> showing 50 of 17,918 rows — these rows as CSV