PREVIEW / futures_1hour / 2024-08-25
file: by_date/futures_1hour/2024/2024-08-25.parquet size: 19 KB rows: 435
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-25 18:00:00 | ES | Futures | 5925.43 | 5934.61 | 5917.04 | 5917.56 | 10281.0 |
| 2024-08-25 19:00:00 | ES | Futures | 5917.83 | 5921.5 | 5914.68 | 5921.23 | 6647.0 |
| 2024-08-25 20:00:00 | ES | Futures | 5921.23 | 5931.72 | 5918.35 | 5929.89 | 8625.0 |
| 2024-08-25 21:00:00 | ES | Futures | 5930.15 | 5934.87 | 5927.26 | 5927.79 | 5948.0 |
| 2024-08-25 22:00:00 | ES | Futures | 5927.79 | 5928.84 | 5924.12 | 5924.91 | 3088.0 |
| 2024-08-25 23:00:00 | ES | Futures | 5924.64 | 5927.79 | 5918.88 | 5920.71 | 3959.0 |
| 2024-08-25 18:00:00 | NQ | Futures | 20894.48 | 20941.73 | 20835.08 | 20841.42 | 6349.0 |
| 2024-08-25 19:00:00 | NQ | Futures | 20841.68 | 20868.87 | 20818.98 | 20868.08 | 4205.0 |
| 2024-08-25 20:00:00 | NQ | Futures | 20869.4 | 20924.05 | 20855.67 | 20914.01 | 4999.0 |
| 2024-08-25 21:00:00 | NQ | Futures | 20915.07 | 20941.2 | 20907.41 | 20910.85 | 3688.0 |
| 2024-08-25 22:00:00 | NQ | Futures | 20910.32 | 20919.03 | 20888.41 | 20896.85 | 2393.0 |
| 2024-08-25 23:00:00 | NQ | Futures | 20896.85 | 20910.58 | 20859.11 | 20868.08 | 2943.0 |
| 2024-08-25 18:00:00 | YM | Futures | 43367.7 | 43422.4 | 43334.1 | 43335.2 | 1097.0 |
| 2024-08-25 19:00:00 | YM | Futures | 43335.2 | 43347.8 | 43322.6 | 43341.5 | 631.0 |
| 2024-08-25 20:00:00 | YM | Futures | 43344.6 | 43379.3 | 43322.6 | 43371.9 | 846.0 |
| 2024-08-25 21:00:00 | YM | Futures | 43373.0 | 43390.9 | 43357.2 | 43358.3 | 826.0 |
| 2024-08-25 22:00:00 | YM | Futures | 43359.3 | 43362.5 | 43343.6 | 43345.7 | 350.0 |
| 2024-08-25 23:00:00 | YM | Futures | 43345.7 | 43360.4 | 43324.7 | 43329.9 | 423.0 |
| 2024-08-25 18:00:00 | CL | Futures | 66.51 | 66.78 | 66.51 | 66.62 | 4968.0 |
| 2024-08-25 19:00:00 | CL | Futures | 66.61 | 66.84 | 66.46 | 66.8 | 2754.0 |
| 2024-08-25 20:00:00 | CL | Futures | 66.8 | 66.81 | 66.69 | 66.76 | 1700.0 |
| 2024-08-25 21:00:00 | CL | Futures | 66.76 | 66.88 | 66.72 | 66.82 | 3348.0 |
| 2024-08-25 22:00:00 | CL | Futures | 66.82 | 66.82 | 66.71 | 66.72 | 1619.0 |
| 2024-08-25 23:00:00 | CL | Futures | 66.72 | 66.83 | 66.7 | 66.74 | 1984.0 |
| 2024-08-25 18:00:00 | GC | Futures | 2679.9 | 2685.4 | 2679.4 | 2683.4 | 2458.0 |
| 2024-08-25 19:00:00 | GC | Futures | 2683.4 | 2687.3 | 2683.4 | 2686.4 | 2025.0 |
| 2024-08-25 20:00:00 | GC | Futures | 2686.3 | 2687.5 | 2682.6 | 2684.0 | 4142.0 |
| 2024-08-25 21:00:00 | GC | Futures | 2684.0 | 2685.9 | 2680.9 | 2683.7 | 4017.0 |
| 2024-08-25 22:00:00 | GC | Futures | 2683.7 | 2685.9 | 2682.2 | 2682.2 | 1647.0 |
| 2024-08-25 23:00:00 | GC | Futures | 2682.2 | 2683.4 | 2679.3 | 2679.8 | 1968.0 |
| 2024-08-25 18:00:00 | ZN | Futures | 114.376952 | 114.471219 | 114.329819 | 114.424086 | 21775.0 |
| 2024-08-25 19:00:00 | ZN | Futures | 114.439797 | 114.48693 | 114.424086 | 114.455508 | 9473.0 |
| 2024-08-25 20:00:00 | ZN | Futures | 114.471219 | 114.565486 | 114.424086 | 114.471219 | 24032.0 |
| 2024-08-25 21:00:00 | ZN | Futures | 114.48693 | 114.518352 | 114.455508 | 114.48693 | 14228.0 |
| 2024-08-25 22:00:00 | ZN | Futures | 114.48693 | 114.502641 | 114.424086 | 114.424086 | 12473.0 |
| 2024-08-25 23:00:00 | ZN | Futures | 114.424086 | 114.471219 | 114.424086 | 114.455508 | 9473.0 |
> showing 36 of 435 rows — these rows as CSV