PREVIEW / futures_1hour / 2025-10-30
file: by_date/futures_1hour/2025/2025-10-30.parquet size: 68 KB rows: 2,132
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-30 00:00:00 | ES | Futures | 6999.85 | 7001.11 | 6952.75 | 6966.1 | 57394.0 |
| 2025-10-30 01:00:00 | ES | Futures | 6966.1 | 6991.03 | 6964.08 | 6981.71 | 12937.0 |
| 2025-10-30 02:00:00 | ES | Futures | 6981.71 | 6982.22 | 6967.86 | 6971.14 | 10857.0 |
| 2025-10-30 03:00:00 | ES | Futures | 6971.39 | 6984.74 | 6963.58 | 6979.2 | 15331.0 |
| 2025-10-30 04:00:00 | ES | Futures | 6978.94 | 6981.46 | 6967.86 | 6973.91 | 14050.0 |
| 2025-10-30 05:00:00 | ES | Futures | 6973.91 | 6977.68 | 6957.53 | 6960.05 | 13411.0 |
| 2025-10-30 06:00:00 | ES | Futures | 6960.3 | 6972.14 | 6958.54 | 6969.88 | 12107.0 |
| 2025-10-30 07:00:00 | ES | Futures | 6970.13 | 6981.71 | 6968.36 | 6973.65 | 16159.0 |
| 2025-10-30 08:00:00 | ES | Futures | 6973.65 | 6976.68 | 6942.17 | 6942.67 | 64622.0 |
| 2025-10-30 09:00:00 | ES | Futures | 6942.42 | 6962.57 | 6919.25 | 6956.02 | 254029.0 |
| 2025-10-30 10:00:00 | ES | Futures | 6955.77 | 6965.59 | 6937.89 | 6949.98 | 272906.0 |
| 2025-10-30 11:00:00 | ES | Futures | 6949.98 | 6961.31 | 6935.37 | 6939.4 | 161327.0 |
| 2025-10-30 12:00:00 | ES | Futures | 6939.4 | 6957.53 | 6937.64 | 6949.98 | 122884.0 |
| 2025-10-30 13:00:00 | ES | Futures | 6949.98 | 6952.24 | 6935.62 | 6949.98 | 115407.0 |
| 2025-10-30 14:00:00 | ES | Futures | 6949.73 | 6949.98 | 6926.81 | 6929.07 | 146302.0 |
| 2025-10-30 15:00:00 | ES | Futures | 6928.82 | 6929.83 | 6903.89 | 6905.14 | 296685.0 |
| 2025-10-30 16:00:00 | ES | Futures | 6905.14 | 6948.21 | 6902.37 | 6945.7 | 113687.0 |
| 2025-10-30 18:00:00 | ES | Futures | 6948.72 | 6951.74 | 6942.42 | 6944.94 | 9609.0 |
| 2025-10-30 19:00:00 | ES | Futures | 6945.19 | 6950.99 | 6939.65 | 6950.23 | 8022.0 |
| 2025-10-30 20:00:00 | ES | Futures | 6950.48 | 6955.02 | 6940.91 | 6952.75 | 10090.0 |
| 2025-10-30 21:00:00 | ES | Futures | 6952.5 | 6955.77 | 6947.21 | 6955.02 | 7170.0 |
| 2025-10-30 22:00:00 | ES | Futures | 6955.02 | 6956.27 | 6944.94 | 6948.72 | 6716.0 |
| 2025-10-30 23:00:00 | ES | Futures | 6948.47 | 6952.24 | 6944.69 | 6951.74 | 7799.0 |
| 2025-10-30 00:00:00 | NQ | Futures | 26607.81 | 26613.36 | 26368.49 | 26435.06 | 26061.0 |
| 2025-10-30 01:00:00 | NQ | Futures | 26435.57 | 26558.38 | 26423.72 | 26510.97 | 9572.0 |
| 2025-10-30 02:00:00 | NQ | Futures | 26510.22 | 26513.24 | 26440.86 | 26452.97 | 5132.0 |
| 2025-10-30 03:00:00 | NQ | Futures | 26453.73 | 26515.26 | 26418.92 | 26499.37 | 7516.0 |
| 2025-10-30 04:00:00 | NQ | Futures | 26499.37 | 26519.8 | 26462.05 | 26499.37 | 6158.0 |
| 2025-10-30 05:00:00 | NQ | Futures | 26501.14 | 26521.06 | 26424.22 | 26435.32 | 7182.0 |
| 2025-10-30 06:00:00 | NQ | Futures | 26434.56 | 26473.9 | 26425.99 | 26461.04 | 6324.0 |
| 2025-10-30 07:00:00 | NQ | Futures | 26461.54 | 26516.77 | 26454.23 | 26490.04 | 6077.0 |
| 2025-10-30 08:00:00 | NQ | Futures | 26490.04 | 26502.15 | 26314.27 | 26315.28 | 26998.0 |
| 2025-10-30 09:00:00 | NQ | Futures | 26315.02 | 26375.8 | 26169.01 | 26353.36 | 106559.0 |
| 2025-10-30 10:00:00 | NQ | Futures | 26353.1 | 26411.36 | 26206.08 | 26243.91 | 102227.0 |
| 2025-10-30 11:00:00 | NQ | Futures | 26243.66 | 26304.94 | 26192.21 | 26218.19 | 56401.0 |
| 2025-10-30 12:00:00 | NQ | Futures | 26218.94 | 26325.11 | 26212.38 | 26301.15 | 50941.0 |
| 2025-10-30 13:00:00 | NQ | Futures | 26301.15 | 26303.42 | 26226.25 | 26295.35 | 39953.0 |
| 2025-10-30 14:00:00 | NQ | Futures | 26295.35 | 26295.35 | 26202.3 | 26216.17 | 41917.0 |
| 2025-10-30 15:00:00 | NQ | Futures | 26216.17 | 26220.96 | 26095.12 | 26098.14 | 71439.0 |
| 2025-10-30 16:00:00 | NQ | Futures | 26098.14 | 26378.07 | 26078.98 | 26377.82 | 43474.0 |
| 2025-10-30 18:00:00 | NQ | Futures | 26379.08 | 26420.94 | 26362.94 | 26377.06 | 6430.0 |
| 2025-10-30 19:00:00 | NQ | Futures | 26378.32 | 26403.79 | 26355.63 | 26399.0 | 5608.0 |
| 2025-10-30 20:00:00 | NQ | Futures | 26400.01 | 26428.76 | 26364.96 | 26422.71 | 6846.0 |
| 2025-10-30 21:00:00 | NQ | Futures | 26421.95 | 26438.09 | 26398.75 | 26435.82 | 4578.0 |
| 2025-10-30 22:00:00 | NQ | Futures | 26436.58 | 26442.63 | 26393.45 | 26414.39 | 4005.0 |
| 2025-10-30 23:00:00 | NQ | Futures | 26413.63 | 26427.25 | 26389.42 | 26419.93 | 3436.0 |
| 2025-10-30 00:00:00 | YM | Futures | 48553.7 | 48567.9 | 48322.4 | 48383.3 | 6419.0 |
| 2025-10-30 01:00:00 | YM | Futures | 48381.3 | 48514.1 | 48370.1 | 48469.5 | 1780.0 |
| 2025-10-30 02:00:00 | YM | Futures | 48468.5 | 48470.5 | 48390.4 | 48441.1 | 1144.0 |
| 2025-10-30 03:00:00 | YM | Futures | 48442.1 | 48506.0 | 48393.4 | 48458.3 | 1616.0 |
> showing 50 of 2,132 rows — these rows as CSV