PREVIEW / futures_1hour / 2022-07-17
file: by_date/futures_1hour/2022/2022-07-17.parquet size: 19 KB rows: 403
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-17 18:00:00 | ES | Futures | 4394.67 | 4398.07 | 4383.34 | 4385.04 | 8435.0 |
| 2022-07-17 19:00:00 | ES | Futures | 4385.04 | 4392.12 | 4384.19 | 4390.14 | 4440.0 |
| 2022-07-17 20:00:00 | ES | Futures | 4390.14 | 4392.12 | 4380.23 | 4381.93 | 6168.0 |
| 2022-07-17 21:00:00 | ES | Futures | 4382.21 | 4391.27 | 4381.93 | 4388.44 | 6206.0 |
| 2022-07-17 22:00:00 | ES | Futures | 4389.01 | 4391.27 | 4385.33 | 4390.42 | 4336.0 |
| 2022-07-17 23:00:00 | ES | Futures | 4390.71 | 4400.91 | 4390.14 | 4396.94 | 6989.0 |
| 2022-07-17 18:00:00 | NQ | Futures | 13933.8 | 13973.72 | 13929.75 | 13934.96 | 4995.0 |
| 2022-07-17 19:00:00 | NQ | Futures | 13935.54 | 13960.12 | 13934.09 | 13952.6 | 2669.0 |
| 2022-07-17 20:00:00 | NQ | Futures | 13951.45 | 13954.34 | 13915.87 | 13926.57 | 3775.0 |
| 2022-07-17 21:00:00 | NQ | Futures | 13926.28 | 13953.47 | 13926.28 | 13943.06 | 3742.0 |
| 2022-07-17 22:00:00 | NQ | Futures | 13943.93 | 13952.6 | 13933.22 | 13950.58 | 2489.0 |
| 2022-07-17 23:00:00 | NQ | Futures | 13951.16 | 14003.51 | 13949.71 | 13998.01 | 6108.0 |
| 2022-07-17 18:00:00 | YM | Futures | 35314.9 | 35345.4 | 35255.1 | 35272.0 | 2210.0 |
| 2022-07-17 19:00:00 | YM | Futures | 35275.4 | 35331.8 | 35265.2 | 35319.4 | 1495.0 |
| 2022-07-17 20:00:00 | YM | Futures | 35319.4 | 35334.1 | 35240.4 | 35250.6 | 1277.0 |
| 2022-07-17 21:00:00 | YM | Futures | 35254.0 | 35326.2 | 35250.6 | 35303.6 | 1207.0 |
| 2022-07-17 22:00:00 | YM | Futures | 35308.1 | 35328.4 | 35292.3 | 35325.1 | 647.0 |
| 2022-07-17 23:00:00 | YM | Futures | 35327.3 | 35372.4 | 35322.8 | 35344.2 | 1846.0 |
| 2022-07-17 18:00:00 | CL | Futures | 74.94 | 75.46 | 74.82 | 75.06 | 2529.0 |
| 2022-07-17 19:00:00 | CL | Futures | 75.04 | 75.1 | 74.84 | 74.87 | 1036.0 |
| 2022-07-17 20:00:00 | CL | Futures | 74.86 | 74.86 | 73.78 | 73.94 | 4119.0 |
| 2022-07-17 21:00:00 | CL | Futures | 73.94 | 74.94 | 73.83 | 74.6 | 8903.0 |
| 2022-07-17 22:00:00 | CL | Futures | 74.6 | 75.58 | 74.38 | 75.48 | 5665.0 |
| 2022-07-17 23:00:00 | CL | Futures | 75.47 | 75.72 | 75.33 | 75.53 | 3687.0 |
| 2022-07-17 18:00:00 | GC | Futures | 2036.6 | 2037.4 | 2034.2 | 2037.4 | 1886.0 |
| 2022-07-17 19:00:00 | GC | Futures | 2037.3 | 2040.0 | 2036.2 | 2039.7 | 1698.0 |
| 2022-07-17 20:00:00 | GC | Futures | 2039.7 | 2040.3 | 2035.6 | 2037.0 | 1993.0 |
| 2022-07-17 21:00:00 | GC | Futures | 2036.9 | 2044.6 | 2036.3 | 2044.1 | 4825.0 |
| 2022-07-17 22:00:00 | GC | Futures | 2044.2 | 2045.0 | 2042.8 | 2043.4 | 2264.0 |
| 2022-07-17 23:00:00 | GC | Futures | 2043.6 | 2048.1 | 2043.2 | 2046.2 | 3093.0 |
| 2022-07-17 18:00:00 | ZN | Futures | 122.398383 | 122.478972 | 122.317794 | 122.462854 | 6431.0 |
| 2022-07-17 19:00:00 | ZN | Futures | 122.462854 | 122.478972 | 122.430619 | 122.446737 | 1417.0 |
| 2022-07-17 20:00:00 | ZN | Futures | 122.462854 | 122.64015 | 122.446737 | 122.64015 | 7115.0 |
| 2022-07-17 21:00:00 | ZN | Futures | 122.64015 | 122.672385 | 122.559561 | 122.656268 | 5402.0 |
| 2022-07-17 22:00:00 | ZN | Futures | 122.656268 | 122.672385 | 122.607914 | 122.64015 | 5523.0 |
| 2022-07-17 23:00:00 | ZN | Futures | 122.624032 | 122.64015 | 122.575679 | 122.575679 | 3232.0 |
> showing 36 of 403 rows — these rows as CSV