PREVIEW / futures_1hour / 2023-06-11
file: by_date/futures_1hour/2023/2023-06-11.parquet size: 17 KB rows: 380
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-11 18:00:00 | ES | Futures | 4777.69 | 4783.51 | 4776.3 | 4782.13 | 4006.0 |
| 2023-06-11 19:00:00 | ES | Futures | 4782.4 | 4785.46 | 4779.91 | 4782.4 | 3229.0 |
| 2023-06-11 20:00:00 | ES | Futures | 4782.13 | 4785.46 | 4780.46 | 4784.35 | 4238.0 |
| 2023-06-11 21:00:00 | ES | Futures | 4784.35 | 4785.46 | 4781.57 | 4782.13 | 2906.0 |
| 2023-06-11 22:00:00 | ES | Futures | 4782.4 | 4784.07 | 4780.74 | 4781.85 | 2471.0 |
| 2023-06-11 23:00:00 | ES | Futures | 4781.85 | 4783.51 | 4780.74 | 4781.3 | 1400.0 |
| 2023-06-11 18:00:00 | NQ | Futures | 16397.93 | 16452.27 | 16391.17 | 16439.32 | 3574.0 |
| 2023-06-11 19:00:00 | NQ | Futures | 16439.32 | 16451.71 | 16424.4 | 16433.12 | 1740.0 |
| 2023-06-11 20:00:00 | NQ | Futures | 16432.0 | 16442.13 | 16424.68 | 16437.07 | 1736.0 |
| 2023-06-11 21:00:00 | NQ | Futures | 16437.63 | 16437.91 | 16427.77 | 16436.78 | 1513.0 |
| 2023-06-11 22:00:00 | NQ | Futures | 16435.94 | 16444.67 | 16432.28 | 16434.53 | 1555.0 |
| 2023-06-11 23:00:00 | NQ | Futures | 16434.81 | 16441.57 | 16426.65 | 16428.62 | 915.0 |
| 2023-06-11 18:00:00 | YM | Futures | 37456.7 | 37496.1 | 37451.2 | 37485.2 | 909.0 |
| 2023-06-11 19:00:00 | YM | Futures | 37485.2 | 37512.6 | 37475.3 | 37490.7 | 644.0 |
| 2023-06-11 20:00:00 | YM | Futures | 37488.5 | 37504.9 | 37475.3 | 37496.1 | 945.0 |
| 2023-06-11 21:00:00 | YM | Futures | 37496.1 | 37507.1 | 37477.5 | 37480.8 | 544.0 |
| 2023-06-11 22:00:00 | YM | Futures | 37480.8 | 37490.7 | 37463.3 | 37470.9 | 514.0 |
| 2023-06-11 23:00:00 | YM | Futures | 37470.9 | 37480.8 | 37465.5 | 37470.9 | 365.0 |
| 2023-06-11 18:00:00 | CL | Futures | 57.17 | 57.22 | 56.87 | 56.88 | 2100.0 |
| 2023-06-11 19:00:00 | CL | Futures | 56.89 | 56.95 | 56.82 | 56.93 | 1051.0 |
| 2023-06-11 20:00:00 | CL | Futures | 56.93 | 56.94 | 56.8 | 56.92 | 1749.0 |
| 2023-06-11 21:00:00 | CL | Futures | 56.91 | 56.92 | 56.39 | 56.42 | 7608.0 |
| 2023-06-11 22:00:00 | CL | Futures | 56.4 | 56.54 | 56.38 | 56.43 | 3345.0 |
| 2023-06-11 23:00:00 | CL | Futures | 56.43 | 56.47 | 56.36 | 56.45 | 1929.0 |
| 2023-06-11 18:00:00 | GC | Futures | 2250.5 | 2250.7 | 2247.7 | 2248.0 | 1127.0 |
| 2023-06-11 19:00:00 | GC | Futures | 2248.0 | 2249.9 | 2246.9 | 2249.0 | 1180.0 |
| 2023-06-11 20:00:00 | GC | Futures | 2249.0 | 2249.7 | 2246.8 | 2247.2 | 1455.0 |
| 2023-06-11 21:00:00 | GC | Futures | 2247.2 | 2248.5 | 2243.7 | 2244.3 | 3857.0 |
| 2023-06-11 22:00:00 | GC | Futures | 2244.2 | 2244.8 | 2242.3 | 2244.3 | 2834.0 |
| 2023-06-11 23:00:00 | GC | Futures | 2244.2 | 2247.6 | 2243.5 | 2247.2 | 1759.0 |
| 2023-06-11 18:00:00 | ZN | Futures | 115.510656 | 115.574386 | 115.446926 | 115.558453 | 7204.0 |
| 2023-06-11 19:00:00 | ZN | Futures | 115.558453 | 115.606251 | 115.510656 | 115.574386 | 4835.0 |
| 2023-06-11 20:00:00 | ZN | Futures | 115.590318 | 115.638116 | 115.590318 | 115.590318 | 7341.0 |
| 2023-06-11 21:00:00 | ZN | Futures | 115.590318 | 115.654048 | 115.574386 | 115.590318 | 5350.0 |
| 2023-06-11 22:00:00 | ZN | Futures | 115.590318 | 115.622183 | 115.558453 | 115.574386 | 6704.0 |
| 2023-06-11 23:00:00 | ZN | Futures | 115.574386 | 115.590318 | 115.558453 | 115.558453 | 2011.0 |
> showing 36 of 380 rows — these rows as CSV