PREVIEW / futures_1hour / 2025-10-29
file: by_date/futures_1hour/2025/2025-10-29.parquet size: 67 KB rows: 2,139
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-29 00:00:00 | ES | Futures | 6990.03 | 6991.29 | 6984.99 | 6990.78 | 3181.0 |
| 2025-10-29 01:00:00 | ES | Futures | 6990.53 | 6993.3 | 6990.28 | 6992.54 | 4111.0 |
| 2025-10-29 02:00:00 | ES | Futures | 6992.54 | 6996.07 | 6991.54 | 6995.06 | 6382.0 |
| 2025-10-29 03:00:00 | ES | Futures | 6995.06 | 6997.58 | 6991.54 | 6997.08 | 8606.0 |
| 2025-10-29 04:00:00 | ES | Futures | 6996.83 | 7001.36 | 6987.76 | 6989.27 | 16223.0 |
| 2025-10-29 05:00:00 | ES | Futures | 6989.27 | 6989.77 | 6982.72 | 6987.76 | 14137.0 |
| 2025-10-29 06:00:00 | ES | Futures | 6987.76 | 6994.56 | 6986.5 | 6990.78 | 10735.0 |
| 2025-10-29 07:00:00 | ES | Futures | 6990.53 | 7000.6 | 6988.77 | 6995.06 | 16778.0 |
| 2025-10-29 08:00:00 | ES | Futures | 6995.06 | 6998.09 | 6989.52 | 6994.06 | 15751.0 |
| 2025-10-29 09:00:00 | ES | Futures | 6994.06 | 7003.88 | 6988.26 | 7002.87 | 118208.0 |
| 2025-10-29 10:00:00 | ES | Futures | 7002.87 | 7004.13 | 6984.48 | 6990.03 | 158448.0 |
| 2025-10-29 11:00:00 | ES | Futures | 6990.28 | 6994.81 | 6984.74 | 6986.75 | 127763.0 |
| 2025-10-29 12:00:00 | ES | Futures | 6986.75 | 6994.56 | 6981.71 | 6992.04 | 104847.0 |
| 2025-10-29 13:00:00 | ES | Futures | 6991.79 | 6994.56 | 6982.47 | 6987.0 | 73413.0 |
| 2025-10-29 14:00:00 | ES | Futures | 6987.51 | 6996.57 | 6933.86 | 6966.6 | 364678.0 |
| 2025-10-29 15:00:00 | ES | Futures | 6966.6 | 6980.71 | 6946.7 | 6979.95 | 288449.0 |
| 2025-10-29 16:00:00 | ES | Futures | 6979.95 | 6997.58 | 6957.28 | 6969.88 | 97616.0 |
| 2025-10-29 18:00:00 | ES | Futures | 6958.29 | 6974.16 | 6954.26 | 6964.84 | 11671.0 |
| 2025-10-29 19:00:00 | ES | Futures | 6964.59 | 6976.68 | 6960.05 | 6974.16 | 8521.0 |
| 2025-10-29 20:00:00 | ES | Futures | 6974.41 | 6992.04 | 6974.16 | 6984.99 | 11456.0 |
| 2025-10-29 21:00:00 | ES | Futures | 6985.24 | 6991.29 | 6978.19 | 6987.76 | 9714.0 |
| 2025-10-29 22:00:00 | ES | Futures | 6988.01 | 7000.86 | 6987.51 | 6996.32 | 10271.0 |
| 2025-10-29 23:00:00 | ES | Futures | 6996.07 | 7005.89 | 6996.07 | 7000.1 | 9582.0 |
| 2025-10-29 00:00:00 | NQ | Futures | 26473.65 | 26478.94 | 26450.2 | 26475.67 | 2897.0 |
| 2025-10-29 01:00:00 | NQ | Futures | 26474.91 | 26493.32 | 26474.41 | 26490.29 | 2974.0 |
| 2025-10-29 02:00:00 | NQ | Futures | 26490.8 | 26520.81 | 26486.01 | 26510.72 | 4420.0 |
| 2025-10-29 03:00:00 | NQ | Futures | 26510.72 | 26528.88 | 26490.55 | 26522.57 | 5027.0 |
| 2025-10-29 04:00:00 | NQ | Futures | 26521.56 | 26539.72 | 26489.79 | 26499.37 | 7596.0 |
| 2025-10-29 05:00:00 | NQ | Futures | 26498.36 | 26500.88 | 26455.74 | 26467.09 | 8297.0 |
| 2025-10-29 06:00:00 | NQ | Futures | 26466.34 | 26502.9 | 26459.53 | 26479.7 | 7194.0 |
| 2025-10-29 07:00:00 | NQ | Futures | 26478.94 | 26526.61 | 26474.91 | 26505.17 | 6493.0 |
| 2025-10-29 08:00:00 | NQ | Futures | 26504.42 | 26517.78 | 26473.4 | 26489.79 | 8691.0 |
| 2025-10-29 09:00:00 | NQ | Futures | 26490.29 | 26549.56 | 26484.24 | 26548.8 | 68154.0 |
| 2025-10-29 10:00:00 | NQ | Futures | 26549.05 | 26556.62 | 26472.89 | 26489.03 | 65375.0 |
| 2025-10-29 11:00:00 | NQ | Futures | 26489.79 | 26507.69 | 26447.67 | 26467.09 | 54104.0 |
| 2025-10-29 12:00:00 | NQ | Futures | 26467.09 | 26496.09 | 26432.29 | 26483.74 | 41379.0 |
| 2025-10-29 13:00:00 | NQ | Futures | 26483.48 | 26497.86 | 26448.18 | 26483.48 | 21888.0 |
| 2025-10-29 14:00:00 | NQ | Futures | 26484.49 | 26519.8 | 26276.94 | 26413.63 | 96024.0 |
| 2025-10-29 15:00:00 | NQ | Futures | 26414.13 | 26517.28 | 26339.99 | 26510.97 | 81957.0 |
| 2025-10-29 16:00:00 | NQ | Futures | 26510.22 | 26610.33 | 26388.41 | 26450.2 | 40468.0 |
| 2025-10-29 18:00:00 | NQ | Futures | 26383.11 | 26485.25 | 26378.57 | 26429.01 | 7688.0 |
| 2025-10-29 19:00:00 | NQ | Futures | 26428.26 | 26476.67 | 26391.44 | 26464.07 | 6349.0 |
| 2025-10-29 20:00:00 | NQ | Futures | 26465.58 | 26548.3 | 26465.58 | 26518.54 | 7028.0 |
| 2025-10-29 21:00:00 | NQ | Futures | 26518.29 | 26541.49 | 26489.54 | 26528.12 | 5861.0 |
| 2025-10-29 22:00:00 | NQ | Futures | 26528.63 | 26602.26 | 26525.85 | 26586.38 | 7651.0 |
| 2025-10-29 23:00:00 | NQ | Futures | 26587.38 | 26629.75 | 26586.63 | 26608.32 | 5993.0 |
| 2025-10-29 00:00:00 | YM | Futures | 48516.1 | 48535.4 | 48503.0 | 48531.3 | 361.0 |
| 2025-10-29 01:00:00 | YM | Futures | 48529.3 | 48537.4 | 48512.1 | 48521.2 | 455.0 |
| 2025-10-29 02:00:00 | YM | Futures | 48520.2 | 48537.4 | 48513.1 | 48535.4 | 634.0 |
| 2025-10-29 03:00:00 | YM | Futures | 48533.4 | 48556.7 | 48522.2 | 48547.6 | 942.0 |
> showing 50 of 2,139 rows — these rows as CSV