PREVIEW / futures_1hour / 2024-10-06
file: by_date/futures_1hour/2024/2024-10-06.parquet size: 20 KB rows: 439
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-10-06 18:00:00 | ES | Futures | 6023.02 | 6029.25 | 6020.42 | 6025.87 | 12690.0 |
| 2024-10-06 19:00:00 | ES | Futures | 6025.87 | 6028.99 | 6022.5 | 6023.02 | 4733.0 |
| 2024-10-06 20:00:00 | ES | Futures | 6023.02 | 6024.06 | 6016.01 | 6018.35 | 8221.0 |
| 2024-10-06 21:00:00 | ES | Futures | 6018.35 | 6026.91 | 6016.53 | 6018.61 | 11959.0 |
| 2024-10-06 22:00:00 | ES | Futures | 6018.87 | 6022.5 | 6016.53 | 6017.31 | 6983.0 |
| 2024-10-06 23:00:00 | ES | Futures | 6017.31 | 6019.39 | 6014.2 | 6016.79 | 5134.0 |
| 2024-10-06 18:00:00 | NQ | Futures | 21102.59 | 21151.9 | 21090.06 | 21130.77 | 6237.0 |
| 2024-10-06 19:00:00 | NQ | Futures | 21131.03 | 21149.03 | 21110.68 | 21114.07 | 3401.0 |
| 2024-10-06 20:00:00 | NQ | Futures | 21113.02 | 21119.55 | 21083.02 | 21100.5 | 5143.0 |
| 2024-10-06 21:00:00 | NQ | Futures | 21099.46 | 21148.25 | 21085.11 | 21097.89 | 6912.0 |
| 2024-10-06 22:00:00 | NQ | Futures | 21097.89 | 21120.07 | 21093.46 | 21100.5 | 3279.0 |
| 2024-10-06 23:00:00 | NQ | Futures | 21099.46 | 21111.72 | 21087.98 | 21102.07 | 2487.0 |
| 2024-10-06 18:00:00 | YM | Futures | 44377.7 | 44439.1 | 44377.7 | 44426.6 | 1255.0 |
| 2024-10-06 19:00:00 | YM | Futures | 44427.6 | 44444.3 | 44408.9 | 44411.0 | 394.0 |
| 2024-10-06 20:00:00 | YM | Futures | 44411.0 | 44417.2 | 44375.6 | 44387.0 | 951.0 |
| 2024-10-06 21:00:00 | YM | Futures | 44389.1 | 44430.8 | 44372.5 | 44390.2 | 989.0 |
| 2024-10-06 22:00:00 | YM | Futures | 44390.2 | 44413.1 | 44369.4 | 44374.6 | 410.0 |
| 2024-10-06 23:00:00 | YM | Futures | 44374.6 | 44383.9 | 44353.7 | 44371.4 | 402.0 |
| 2024-10-06 18:00:00 | CL | Futures | 66.73 | 66.79 | 66.03 | 66.43 | 9137.0 |
| 2024-10-06 19:00:00 | CL | Futures | 66.43 | 66.43 | 66.26 | 66.28 | 1226.0 |
| 2024-10-06 20:00:00 | CL | Futures | 66.28 | 66.5 | 66.15 | 66.45 | 2233.0 |
| 2024-10-06 21:00:00 | CL | Futures | 66.46 | 66.55 | 66.33 | 66.4 | 2416.0 |
| 2024-10-06 22:00:00 | CL | Futures | 66.39 | 66.58 | 66.37 | 66.45 | 1503.0 |
| 2024-10-06 23:00:00 | CL | Futures | 66.45 | 66.59 | 66.44 | 66.51 | 1442.0 |
| 2024-10-06 18:00:00 | GC | Futures | 2813.2 | 2814.2 | 2809.2 | 2811.6 | 1873.0 |
| 2024-10-06 19:00:00 | GC | Futures | 2811.5 | 2813.4 | 2810.5 | 2811.0 | 1251.0 |
| 2024-10-06 20:00:00 | GC | Futures | 2811.1 | 2811.9 | 2808.5 | 2810.2 | 1797.0 |
| 2024-10-06 21:00:00 | GC | Futures | 2810.3 | 2813.0 | 2804.0 | 2806.9 | 3512.0 |
| 2024-10-06 22:00:00 | GC | Futures | 2806.9 | 2809.4 | 2805.7 | 2805.7 | 1758.0 |
| 2024-10-06 23:00:00 | GC | Futures | 2805.7 | 2808.3 | 2804.6 | 2808.2 | 2060.0 |
| 2024-10-06 18:00:00 | ZN | Futures | 113.002626 | 113.002626 | 112.877416 | 112.940021 | 41309.0 |
| 2024-10-06 19:00:00 | ZN | Futures | 112.940021 | 113.018278 | 112.92437 | 112.986975 | 15514.0 |
| 2024-10-06 20:00:00 | ZN | Futures | 112.986975 | 113.033929 | 112.908718 | 113.002626 | 32414.0 |
| 2024-10-06 21:00:00 | ZN | Futures | 113.002626 | 113.080883 | 113.002626 | 113.04958 | 29006.0 |
| 2024-10-06 22:00:00 | ZN | Futures | 113.065232 | 113.080883 | 113.033929 | 113.033929 | 19144.0 |
| 2024-10-06 23:00:00 | ZN | Futures | 113.033929 | 113.065232 | 113.033929 | 113.065232 | 9610.0 |
> showing 36 of 439 rows — these rows as CSV