PREVIEW / futures_1hour / 2025-10-02
file: by_date/futures_1hour/2025/2025-10-02.parquet size: 65 KB rows: 2,066
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-02 00:00:00 | ES | Futures | 6818.5 | 6821.77 | 6815.23 | 6819.76 | 4085.0 |
| 2025-10-02 01:00:00 | ES | Futures | 6819.51 | 6822.28 | 6818.25 | 6819.26 | 3711.0 |
| 2025-10-02 02:00:00 | ES | Futures | 6819.26 | 6820.77 | 6815.23 | 6816.48 | 7407.0 |
| 2025-10-02 03:00:00 | ES | Futures | 6816.48 | 6821.52 | 6814.47 | 6818.5 | 12868.0 |
| 2025-10-02 04:00:00 | ES | Futures | 6818.75 | 6825.8 | 6818.25 | 6824.8 | 13724.0 |
| 2025-10-02 05:00:00 | ES | Futures | 6824.8 | 6825.3 | 6816.23 | 6821.27 | 9735.0 |
| 2025-10-02 06:00:00 | ES | Futures | 6821.02 | 6826.06 | 6820.77 | 6823.03 | 9583.0 |
| 2025-10-02 07:00:00 | ES | Futures | 6822.78 | 6829.33 | 6822.53 | 6828.57 | 13740.0 |
| 2025-10-02 08:00:00 | ES | Futures | 6828.32 | 6831.85 | 6827.06 | 6830.09 | 18380.0 |
| 2025-10-02 09:00:00 | ES | Futures | 6829.83 | 6833.11 | 6812.45 | 6819.26 | 164918.0 |
| 2025-10-02 10:00:00 | ES | Futures | 6819.0 | 6820.01 | 6800.36 | 6800.36 | 184568.0 |
| 2025-10-02 11:00:00 | ES | Futures | 6800.36 | 6808.93 | 6792.05 | 6808.17 | 174740.0 |
| 2025-10-02 12:00:00 | ES | Futures | 6808.17 | 6810.69 | 6799.86 | 6808.93 | 98175.0 |
| 2025-10-02 13:00:00 | ES | Futures | 6809.18 | 6815.73 | 6804.14 | 6813.46 | 84618.0 |
| 2025-10-02 14:00:00 | ES | Futures | 6813.71 | 6822.28 | 6813.21 | 6818.75 | 87297.0 |
| 2025-10-02 15:00:00 | ES | Futures | 6818.5 | 6821.27 | 6813.21 | 6817.49 | 177224.0 |
| 2025-10-02 16:00:00 | ES | Futures | 6817.49 | 6819.76 | 6814.47 | 6815.73 | 35238.0 |
| 2025-10-02 18:00:00 | ES | Futures | 6815.48 | 6816.99 | 6809.43 | 6816.23 | 4427.0 |
| 2025-10-02 19:00:00 | ES | Futures | 6815.98 | 6820.26 | 6814.47 | 6820.01 | 3142.0 |
| 2025-10-02 20:00:00 | ES | Futures | 6820.01 | 6826.06 | 6817.74 | 6824.04 | 6017.0 |
| 2025-10-02 21:00:00 | ES | Futures | 6823.79 | 6828.57 | 6822.28 | 6828.57 | 5134.0 |
| 2025-10-02 22:00:00 | ES | Futures | 6828.57 | 6828.57 | 6824.54 | 6827.32 | 3778.0 |
| 2025-10-02 23:00:00 | ES | Futures | 6827.57 | 6831.6 | 6827.06 | 6830.84 | 3580.0 |
| 2025-10-02 00:00:00 | NQ | Futures | 25283.33 | 25293.67 | 25269.97 | 25285.86 | 2387.0 |
| 2025-10-02 01:00:00 | NQ | Futures | 25286.11 | 25295.44 | 25280.31 | 25288.38 | 2188.0 |
| 2025-10-02 02:00:00 | NQ | Futures | 25288.38 | 25295.44 | 25275.52 | 25282.07 | 2822.0 |
| 2025-10-02 03:00:00 | NQ | Futures | 25280.31 | 25307.29 | 25272.74 | 25296.7 | 6484.0 |
| 2025-10-02 04:00:00 | NQ | Futures | 25295.94 | 25333.77 | 25292.92 | 25332.51 | 6257.0 |
| 2025-10-02 05:00:00 | NQ | Futures | 25333.27 | 25336.55 | 25294.93 | 25315.36 | 5485.0 |
| 2025-10-02 06:00:00 | NQ | Futures | 25314.35 | 25344.36 | 25312.84 | 25330.49 | 6197.0 |
| 2025-10-02 07:00:00 | NQ | Futures | 25330.49 | 25370.84 | 25326.96 | 25368.83 | 7131.0 |
| 2025-10-02 08:00:00 | NQ | Futures | 25369.08 | 25384.21 | 25363.02 | 25381.94 | 8550.0 |
| 2025-10-02 09:00:00 | NQ | Futures | 25381.94 | 25400.1 | 25232.65 | 25281.82 | 84850.0 |
| 2025-10-02 10:00:00 | NQ | Futures | 25282.58 | 25310.82 | 25237.69 | 25240.46 | 78551.0 |
| 2025-10-02 11:00:00 | NQ | Futures | 25239.96 | 25301.49 | 25212.22 | 25296.7 | 67431.0 |
| 2025-10-02 12:00:00 | NQ | Futures | 25296.7 | 25299.47 | 25252.82 | 25296.45 | 39328.0 |
| 2025-10-02 13:00:00 | NQ | Futures | 25296.2 | 25332.51 | 25278.54 | 25304.77 | 31371.0 |
| 2025-10-02 14:00:00 | NQ | Futures | 25304.77 | 25339.57 | 25298.47 | 25331.75 | 28459.0 |
| 2025-10-02 15:00:00 | NQ | Futures | 25331.25 | 25346.13 | 25310.32 | 25328.98 | 42136.0 |
| 2025-10-02 16:00:00 | NQ | Futures | 25328.98 | 25344.87 | 25318.89 | 25324.44 | 11938.0 |
| 2025-10-02 18:00:00 | NQ | Futures | 25320.91 | 25327.21 | 25292.16 | 25323.68 | 3518.0 |
| 2025-10-02 19:00:00 | NQ | Futures | 25323.18 | 25344.62 | 25316.62 | 25342.85 | 2446.0 |
| 2025-10-02 20:00:00 | NQ | Futures | 25344.11 | 25377.4 | 25335.54 | 25366.56 | 4381.0 |
| 2025-10-02 21:00:00 | NQ | Futures | 25366.05 | 25381.94 | 25356.97 | 25380.68 | 3139.0 |
| 2025-10-02 22:00:00 | NQ | Futures | 25381.18 | 25383.96 | 25366.05 | 25377.9 | 2438.0 |
| 2025-10-02 23:00:00 | NQ | Futures | 25376.64 | 25395.3 | 25375.38 | 25390.51 | 1906.0 |
| 2025-10-02 00:00:00 | YM | Futures | 47370.2 | 47404.7 | 47346.9 | 47382.4 | 613.0 |
| 2025-10-02 01:00:00 | YM | Futures | 47381.3 | 47402.6 | 47370.2 | 47381.3 | 608.0 |
| 2025-10-02 02:00:00 | YM | Futures | 47379.3 | 47391.5 | 47341.8 | 47360.0 | 992.0 |
| 2025-10-02 03:00:00 | YM | Futures | 47359.0 | 47389.5 | 47343.8 | 47355.0 | 1366.0 |
> showing 50 of 2,066 rows — these rows as CSV