PREVIEW / futures_1hour / 2025-10-01
file: by_date/futures_1hour/2025/2025-10-01.parquet size: 67 KB rows: 2,110
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-01 00:00:00 | ES | Futures | 6758.81 | 6761.07 | 6758.05 | 6758.81 | 4400.0 |
| 2025-10-01 01:00:00 | ES | Futures | 6759.06 | 6760.06 | 6754.27 | 6754.78 | 5982.0 |
| 2025-10-01 02:00:00 | ES | Futures | 6754.78 | 6757.29 | 6730.09 | 6733.62 | 28057.0 |
| 2025-10-01 03:00:00 | ES | Futures | 6733.37 | 6741.17 | 6730.85 | 6737.65 | 25875.0 |
| 2025-10-01 04:00:00 | ES | Futures | 6737.65 | 6748.98 | 6733.87 | 6746.21 | 19021.0 |
| 2025-10-01 05:00:00 | ES | Futures | 6746.21 | 6756.29 | 6745.46 | 6752.26 | 15851.0 |
| 2025-10-01 06:00:00 | ES | Futures | 6752.26 | 6756.03 | 6747.97 | 6749.74 | 12862.0 |
| 2025-10-01 07:00:00 | ES | Futures | 6749.74 | 6765.61 | 6749.49 | 6764.6 | 16800.0 |
| 2025-10-01 08:00:00 | ES | Futures | 6764.6 | 6765.61 | 6752.26 | 6760.82 | 43561.0 |
| 2025-10-01 09:00:00 | ES | Futures | 6761.07 | 6779.46 | 6755.53 | 6763.09 | 182299.0 |
| 2025-10-01 10:00:00 | ES | Futures | 6762.33 | 6786.26 | 6758.81 | 6783.74 | 174925.0 |
| 2025-10-01 11:00:00 | ES | Futures | 6783.74 | 6798.1 | 6782.73 | 6795.33 | 127672.0 |
| 2025-10-01 12:00:00 | ES | Futures | 6795.58 | 6797.34 | 6789.53 | 6794.82 | 85816.0 |
| 2025-10-01 13:00:00 | ES | Futures | 6794.82 | 6807.17 | 6793.56 | 6805.4 | 94034.0 |
| 2025-10-01 14:00:00 | ES | Futures | 6805.65 | 6819.76 | 6804.9 | 6817.74 | 104199.0 |
| 2025-10-01 15:00:00 | ES | Futures | 6817.74 | 6820.26 | 6811.2 | 6811.2 | 213761.0 |
| 2025-10-01 16:00:00 | ES | Futures | 6811.45 | 6811.95 | 6805.65 | 6807.67 | 52288.0 |
| 2025-10-01 18:00:00 | ES | Futures | 6807.67 | 6811.45 | 6806.66 | 6808.93 | 4039.0 |
| 2025-10-01 19:00:00 | ES | Futures | 6808.68 | 6812.2 | 6806.66 | 6810.19 | 4015.0 |
| 2025-10-01 20:00:00 | ES | Futures | 6810.44 | 6819.76 | 6809.18 | 6818.25 | 8837.0 |
| 2025-10-01 21:00:00 | ES | Futures | 6818.5 | 6822.53 | 6815.73 | 6822.03 | 8265.0 |
| 2025-10-01 22:00:00 | ES | Futures | 6822.03 | 6822.28 | 6815.98 | 6817.24 | 4442.0 |
| 2025-10-01 23:00:00 | ES | Futures | 6817.49 | 6819.0 | 6814.47 | 6818.5 | 3932.0 |
| 2025-10-01 00:00:00 | NQ | Futures | 24988.78 | 24998.87 | 24986.01 | 24990.3 | 2117.0 |
| 2025-10-01 01:00:00 | NQ | Futures | 24991.05 | 24996.6 | 24974.41 | 24977.69 | 2739.0 |
| 2025-10-01 02:00:00 | NQ | Futures | 24978.44 | 24986.01 | 24848.57 | 24867.48 | 10589.0 |
| 2025-10-01 03:00:00 | NQ | Futures | 24866.98 | 24905.56 | 24852.85 | 24887.15 | 9537.0 |
| 2025-10-01 04:00:00 | NQ | Futures | 24886.39 | 24948.68 | 24868.74 | 24936.33 | 8825.0 |
| 2025-10-01 05:00:00 | NQ | Futures | 24935.57 | 24983.23 | 24929.77 | 24962.05 | 6463.0 |
| 2025-10-01 06:00:00 | NQ | Futures | 24962.05 | 24980.46 | 24937.84 | 24947.68 | 4783.0 |
| 2025-10-01 07:00:00 | NQ | Futures | 24948.94 | 25020.05 | 24947.17 | 25015.26 | 8130.0 |
| 2025-10-01 08:00:00 | NQ | Futures | 25015.26 | 25022.32 | 24963.56 | 24993.57 | 16517.0 |
| 2025-10-01 09:00:00 | NQ | Futures | 24994.08 | 25058.64 | 24942.13 | 25001.39 | 73888.0 |
| 2025-10-01 10:00:00 | NQ | Futures | 24997.86 | 25129.75 | 24966.34 | 25115.13 | 72519.0 |
| 2025-10-01 11:00:00 | NQ | Futures | 25114.37 | 25156.49 | 25092.68 | 25148.92 | 49817.0 |
| 2025-10-01 12:00:00 | NQ | Futures | 25149.42 | 25175.9 | 25146.65 | 25173.13 | 30614.0 |
| 2025-10-01 13:00:00 | NQ | Futures | 25173.13 | 25208.44 | 25170.36 | 25201.88 | 35782.0 |
| 2025-10-01 14:00:00 | NQ | Futures | 25201.37 | 25253.58 | 25191.03 | 25242.73 | 41830.0 |
| 2025-10-01 15:00:00 | NQ | Futures | 25242.48 | 25255.59 | 25219.28 | 25230.38 | 51921.0 |
| 2025-10-01 16:00:00 | NQ | Futures | 25230.12 | 25233.4 | 25211.21 | 25227.85 | 15173.0 |
| 2025-10-01 18:00:00 | NQ | Futures | 25227.85 | 25238.95 | 25220.29 | 25230.88 | 2205.0 |
| 2025-10-01 19:00:00 | NQ | Futures | 25231.38 | 25247.78 | 25221.8 | 25240.97 | 3038.0 |
| 2025-10-01 20:00:00 | NQ | Futures | 25240.72 | 25282.58 | 25237.94 | 25279.05 | 5095.0 |
| 2025-10-01 21:00:00 | NQ | Futures | 25279.55 | 25295.69 | 25265.43 | 25293.17 | 4250.0 |
| 2025-10-01 22:00:00 | NQ | Futures | 25293.17 | 25294.68 | 25270.73 | 25276.27 | 2334.0 |
| 2025-10-01 23:00:00 | NQ | Futures | 25277.28 | 25286.61 | 25258.87 | 25283.08 | 3175.0 |
| 2025-10-01 00:00:00 | YM | Futures | 47152.2 | 47174.5 | 47145.1 | 47162.3 | 594.0 |
| 2025-10-01 01:00:00 | YM | Futures | 47161.3 | 47167.4 | 47120.7 | 47121.7 | 577.0 |
| 2025-10-01 02:00:00 | YM | Futures | 47124.8 | 47150.1 | 47000.0 | 47022.4 | 2796.0 |
| 2025-10-01 03:00:00 | YM | Futures | 47020.3 | 47056.8 | 46988.9 | 47036.5 | 2793.0 |
> showing 50 of 2,110 rows — these rows as CSV