PREVIEW / futures_1hour / 2025-10-05
file: by_date/futures_1hour/2025/2025-10-05.parquet size: 19 KB rows: 428
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 |
|---|---|---|---|---|---|---|---|
| 2025-10-05 18:00:00 | ES | Futures | 6818.75 | 6828.57 | 6817.74 | 6827.32 | 8234.0 |
| 2025-10-05 19:00:00 | ES | Futures | 6827.32 | 6834.37 | 6827.06 | 6829.33 | 6730.0 |
| 2025-10-05 20:00:00 | ES | Futures | 6829.33 | 6830.09 | 6825.8 | 6828.32 | 6808.0 |
| 2025-10-05 21:00:00 | ES | Futures | 6828.57 | 6830.84 | 6826.56 | 6830.59 | 3969.0 |
| 2025-10-05 22:00:00 | ES | Futures | 6830.34 | 6832.86 | 6829.58 | 6832.35 | 2807.0 |
| 2025-10-05 23:00:00 | ES | Futures | 6832.6 | 6836.38 | 6832.6 | 6833.86 | 4112.0 |
| 2025-10-05 18:00:00 | NQ | Futures | 25218.52 | 25277.53 | 25213.48 | 25272.74 | 5317.0 |
| 2025-10-05 19:00:00 | NQ | Futures | 25272.49 | 25306.03 | 25271.99 | 25285.86 | 4207.0 |
| 2025-10-05 20:00:00 | NQ | Futures | 25285.6 | 25293.93 | 25269.46 | 25283.08 | 3927.0 |
| 2025-10-05 21:00:00 | NQ | Futures | 25283.08 | 25297.2 | 25275.01 | 25295.19 | 2697.0 |
| 2025-10-05 22:00:00 | NQ | Futures | 25295.19 | 25302.25 | 25292.41 | 25300.74 | 1470.0 |
| 2025-10-05 23:00:00 | NQ | Futures | 25300.23 | 25318.39 | 25299.98 | 25308.3 | 2194.0 |
| 2025-10-05 18:00:00 | YM | Futures | 47711.9 | 47785.0 | 47711.9 | 47769.8 | 784.0 |
| 2025-10-05 19:00:00 | YM | Futures | 47772.8 | 47824.5 | 47766.7 | 47783.9 | 722.0 |
| 2025-10-05 20:00:00 | YM | Futures | 47783.9 | 47791.0 | 47724.1 | 47743.4 | 1351.0 |
| 2025-10-05 21:00:00 | YM | Futures | 47744.4 | 47759.6 | 47725.1 | 47759.6 | 598.0 |
| 2025-10-05 22:00:00 | YM | Futures | 47756.6 | 47783.9 | 47750.5 | 47779.9 | 357.0 |
| 2025-10-05 23:00:00 | YM | Futures | 47781.9 | 47799.2 | 47781.9 | 47791.0 | 379.0 |
| 2025-10-05 18:00:00 | CL | Futures | 59.57 | 60.26 | 59.52 | 59.84 | 5211.0 |
| 2025-10-05 19:00:00 | CL | Futures | 59.85 | 60.03 | 59.82 | 60.0 | 2090.0 |
| 2025-10-05 20:00:00 | CL | Futures | 60.02 | 60.25 | 59.94 | 60.19 | 2870.0 |
| 2025-10-05 21:00:00 | CL | Futures | 60.19 | 60.21 | 60.08 | 60.2 | 1298.0 |
| 2025-10-05 22:00:00 | CL | Futures | 60.2 | 60.22 | 60.15 | 60.17 | 1217.0 |
| 2025-10-05 23:00:00 | CL | Futures | 60.17 | 60.23 | 60.15 | 60.22 | 995.0 |
| 2025-10-05 18:00:00 | GC | Futures | 3975.0 | 3992.0 | 3970.6 | 3989.0 | 8806.0 |
| 2025-10-05 19:00:00 | GC | Futures | 3989.3 | 4007.2 | 3986.7 | 3997.1 | 15139.0 |
| 2025-10-05 20:00:00 | GC | Futures | 3997.2 | 3997.7 | 3985.9 | 3987.8 | 9083.0 |
| 2025-10-05 21:00:00 | GC | Futures | 3988.2 | 4005.3 | 3987.2 | 4005.2 | 7689.0 |
| 2025-10-05 22:00:00 | GC | Futures | 4005.2 | 4012.1 | 4004.6 | 4008.1 | 9589.0 |
| 2025-10-05 23:00:00 | GC | Futures | 4007.8 | 4019.0 | 4006.9 | 4016.8 | 7935.0 |
| 2025-10-05 18:00:00 | ZN | Futures | 112.578125 | 112.59375 | 112.5 | 112.53125 | 18003.0 |
| 2025-10-05 19:00:00 | ZN | Futures | 112.515625 | 112.546875 | 112.5 | 112.515625 | 11882.0 |
| 2025-10-05 20:00:00 | ZN | Futures | 112.53125 | 112.546875 | 112.484375 | 112.546875 | 16739.0 |
| 2025-10-05 21:00:00 | ZN | Futures | 112.5625 | 112.578125 | 112.515625 | 112.546875 | 8211.0 |
| 2025-10-05 22:00:00 | ZN | Futures | 112.546875 | 112.546875 | 112.5 | 112.515625 | 4865.0 |
| 2025-10-05 23:00:00 | ZN | Futures | 112.53125 | 112.546875 | 112.484375 | 112.484375 | 13182.0 |
> showing 36 of 428 rows — these rows as CSV