PREVIEW / futures_1hour / 2025-09-24
file: by_date/futures_1hour/2025/2025-09-24.parquet size: 63 KB rows: 2,061
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-09-24 00:00:00 | ES | Futures | 6768.63 | 6771.4 | 6768.38 | 6771.15 | 2053.0 |
| 2025-09-24 01:00:00 | ES | Futures | 6771.15 | 6773.16 | 6769.89 | 6772.91 | 3438.0 |
| 2025-09-24 02:00:00 | ES | Futures | 6773.16 | 6778.45 | 6772.41 | 6775.68 | 8097.0 |
| 2025-09-24 03:00:00 | ES | Futures | 6775.93 | 6777.19 | 6765.86 | 6776.94 | 14292.0 |
| 2025-09-24 04:00:00 | ES | Futures | 6777.19 | 6778.2 | 6772.66 | 6774.93 | 10075.0 |
| 2025-09-24 05:00:00 | ES | Futures | 6774.67 | 6777.95 | 6774.42 | 6776.18 | 6354.0 |
| 2025-09-24 06:00:00 | ES | Futures | 6776.44 | 6777.19 | 6771.9 | 6775.93 | 6888.0 |
| 2025-09-24 07:00:00 | ES | Futures | 6775.93 | 6779.21 | 6772.91 | 6776.18 | 9447.0 |
| 2025-09-24 08:00:00 | ES | Futures | 6775.93 | 6777.95 | 6773.92 | 6777.19 | 13016.0 |
| 2025-09-24 09:00:00 | ES | Futures | 6777.19 | 6778.96 | 6756.29 | 6762.84 | 146375.0 |
| 2025-09-24 10:00:00 | ES | Futures | 6762.84 | 6769.38 | 6758.81 | 6761.83 | 143409.0 |
| 2025-09-24 11:00:00 | ES | Futures | 6761.83 | 6764.09 | 6733.87 | 6735.63 | 164488.0 |
| 2025-09-24 12:00:00 | ES | Futures | 6735.63 | 6743.19 | 6728.08 | 6737.14 | 175717.0 |
| 2025-09-24 13:00:00 | ES | Futures | 6737.4 | 6750.24 | 6735.38 | 6737.65 | 112351.0 |
| 2025-09-24 14:00:00 | ES | Futures | 6737.4 | 6743.69 | 6731.35 | 6743.44 | 110213.0 |
| 2025-09-24 15:00:00 | ES | Futures | 6743.19 | 6746.21 | 6737.14 | 6742.18 | 182700.0 |
| 2025-09-24 16:00:00 | ES | Futures | 6742.18 | 6749.74 | 6742.18 | 6747.22 | 51496.0 |
| 2025-09-24 18:00:00 | ES | Futures | 6747.47 | 6750.24 | 6744.7 | 6747.22 | 3820.0 |
| 2025-09-24 19:00:00 | ES | Futures | 6746.97 | 6748.98 | 6744.7 | 6748.73 | 2224.0 |
| 2025-09-24 20:00:00 | ES | Futures | 6748.48 | 6753.26 | 6747.72 | 6752.51 | 5879.0 |
| 2025-09-24 21:00:00 | ES | Futures | 6752.51 | 6755.53 | 6751.5 | 6753.52 | 4054.0 |
| 2025-09-24 22:00:00 | ES | Futures | 6753.52 | 6755.28 | 6752.51 | 6754.78 | 2372.0 |
| 2025-09-24 23:00:00 | ES | Futures | 6755.03 | 6755.03 | 6753.26 | 6755.03 | 1962.0 |
| 2025-09-24 00:00:00 | NQ | Futures | 25054.6 | 25069.48 | 25053.09 | 25068.98 | 1967.0 |
| 2025-09-24 01:00:00 | NQ | Futures | 25068.47 | 25078.56 | 25063.43 | 25078.31 | 2411.0 |
| 2025-09-24 02:00:00 | NQ | Futures | 25078.06 | 25110.59 | 25076.54 | 25099.24 | 4643.0 |
| 2025-09-24 03:00:00 | NQ | Futures | 25099.49 | 25116.14 | 25063.68 | 25116.14 | 7184.0 |
| 2025-09-24 04:00:00 | NQ | Futures | 25115.88 | 25124.71 | 25102.01 | 25113.87 | 5798.0 |
| 2025-09-24 05:00:00 | NQ | Futures | 25113.61 | 25127.99 | 25112.1 | 25123.45 | 3262.0 |
| 2025-09-24 06:00:00 | NQ | Futures | 25123.45 | 25131.27 | 25100.5 | 25122.19 | 4333.0 |
| 2025-09-24 07:00:00 | NQ | Futures | 25121.68 | 25130.51 | 25093.44 | 25106.8 | 6205.0 |
| 2025-09-24 08:00:00 | NQ | Futures | 25106.3 | 25114.12 | 25086.88 | 25098.99 | 10308.0 |
| 2025-09-24 09:00:00 | NQ | Futures | 25098.99 | 25116.89 | 25001.14 | 25037.71 | 76490.0 |
| 2025-09-24 10:00:00 | NQ | Futures | 25037.96 | 25058.13 | 25006.94 | 25010.72 | 68775.0 |
| 2025-09-24 11:00:00 | NQ | Futures | 25010.72 | 25026.86 | 24893.96 | 24895.47 | 77015.0 |
| 2025-09-24 12:00:00 | NQ | Futures | 24895.47 | 24921.95 | 24842.26 | 24900.77 | 73932.0 |
| 2025-09-24 13:00:00 | NQ | Futures | 24901.02 | 24975.42 | 24898.5 | 24925.74 | 53423.0 |
| 2025-09-24 14:00:00 | NQ | Futures | 24925.48 | 24957.76 | 24898.5 | 24955.24 | 42312.0 |
| 2025-09-24 15:00:00 | NQ | Futures | 24956.0 | 24965.58 | 24916.4 | 24955.75 | 52368.0 |
| 2025-09-24 16:00:00 | NQ | Futures | 24955.75 | 24971.13 | 24955.49 | 24963.82 | 13456.0 |
| 2025-09-24 18:00:00 | NQ | Futures | 24962.3 | 24969.36 | 24956.25 | 24966.59 | 2511.0 |
| 2025-09-24 19:00:00 | NQ | Futures | 24965.83 | 24973.4 | 24956.5 | 24972.14 | 1711.0 |
| 2025-09-24 20:00:00 | NQ | Futures | 24972.39 | 24995.59 | 24968.86 | 24992.31 | 4686.0 |
| 2025-09-24 21:00:00 | NQ | Futures | 24991.56 | 25010.22 | 24988.78 | 25000.63 | 3026.0 |
| 2025-09-24 22:00:00 | NQ | Futures | 25000.63 | 25008.45 | 24993.32 | 25006.44 | 1742.0 |
| 2025-09-24 23:00:00 | NQ | Futures | 25005.68 | 25005.68 | 24997.36 | 25001.9 | 1723.0 |
| 2025-09-24 00:00:00 | YM | Futures | 47342.8 | 47361.1 | 47337.7 | 47356.0 | 1106.0 |
| 2025-09-24 01:00:00 | YM | Futures | 47356.0 | 47370.2 | 47348.9 | 47370.2 | 408.0 |
| 2025-09-24 02:00:00 | YM | Futures | 47370.2 | 47388.4 | 47359.0 | 47365.1 | 1075.0 |
| 2025-09-24 03:00:00 | YM | Futures | 47366.1 | 47374.2 | 47279.9 | 47349.9 | 2016.0 |
> showing 50 of 2,061 rows — these rows as CSV