PREVIEW / futures_1hour / 2025-05-29
file: by_date/futures_1hour/2025/2025-05-29.parquet size: 67 KB rows: 2,073
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-05-29 00:00:00 | ES | Futures | 6091.12 | 6096.96 | 6090.36 | 6095.95 | 6220.0 |
| 2025-05-29 01:00:00 | ES | Futures | 6096.2 | 6100.26 | 6093.15 | 6095.69 | 6799.0 |
| 2025-05-29 02:00:00 | ES | Futures | 6095.44 | 6095.69 | 6086.04 | 6087.82 | 10933.0 |
| 2025-05-29 03:00:00 | ES | Futures | 6087.82 | 6102.3 | 6081.97 | 6102.3 | 19827.0 |
| 2025-05-29 04:00:00 | ES | Futures | 6102.55 | 6105.09 | 6086.8 | 6087.82 | 16833.0 |
| 2025-05-29 05:00:00 | ES | Futures | 6088.07 | 6091.88 | 6080.45 | 6080.96 | 11453.0 |
| 2025-05-29 06:00:00 | ES | Futures | 6081.46 | 6081.97 | 6061.14 | 6066.73 | 22307.0 |
| 2025-05-29 07:00:00 | ES | Futures | 6066.73 | 6066.98 | 6047.17 | 6047.93 | 26802.0 |
| 2025-05-29 08:00:00 | ES | Futures | 6048.19 | 6055.81 | 6036.5 | 6042.85 | 45992.0 |
| 2025-05-29 09:00:00 | ES | Futures | 6042.85 | 6054.03 | 6022.02 | 6032.18 | 162720.0 |
| 2025-05-29 10:00:00 | ES | Futures | 6031.93 | 6035.99 | 6003.98 | 6028.62 | 193300.0 |
| 2025-05-29 11:00:00 | ES | Futures | 6028.62 | 6029.64 | 5983.66 | 5990.26 | 156948.0 |
| 2025-05-29 12:00:00 | ES | Futures | 5990.26 | 6021.0 | 5979.09 | 6017.19 | 130253.0 |
| 2025-05-29 13:00:00 | ES | Futures | 6016.94 | 6024.05 | 6002.97 | 6004.49 | 87767.0 |
| 2025-05-29 14:00:00 | ES | Futures | 6004.74 | 6014.65 | 5994.84 | 6007.03 | 107526.0 |
| 2025-05-29 15:00:00 | ES | Futures | 6007.29 | 6026.59 | 6001.7 | 6018.97 | 192011.0 |
| 2025-05-29 16:00:00 | ES | Futures | 6019.22 | 6022.02 | 6011.1 | 6012.87 | 40603.0 |
| 2025-05-29 18:00:00 | ES | Futures | 6007.79 | 6016.18 | 6001.19 | 6006.78 | 8461.0 |
| 2025-05-29 19:00:00 | ES | Futures | 6006.78 | 6010.59 | 5999.66 | 5999.92 | 5245.0 |
| 2025-05-29 20:00:00 | ES | Futures | 5999.92 | 6007.29 | 5999.66 | 6002.71 | 6937.0 |
| 2025-05-29 21:00:00 | ES | Futures | 6002.97 | 6005.51 | 5986.2 | 6005.0 | 11045.0 |
| 2025-05-29 22:00:00 | ES | Futures | 6005.0 | 6008.3 | 6002.71 | 6007.29 | 4159.0 |
| 2025-05-29 23:00:00 | ES | Futures | 6007.54 | 6008.56 | 6002.2 | 6005.25 | 2980.0 |
| 2025-05-29 00:00:00 | NQ | Futures | 22187.9 | 22213.11 | 22180.51 | 22202.41 | 4168.0 |
| 2025-05-29 01:00:00 | NQ | Futures | 22202.16 | 22230.42 | 22196.56 | 22211.07 | 5363.0 |
| 2025-05-29 02:00:00 | NQ | Futures | 22210.56 | 22212.09 | 22171.85 | 22175.67 | 5493.0 |
| 2025-05-29 03:00:00 | NQ | Futures | 22176.18 | 22256.14 | 22151.23 | 22256.14 | 9330.0 |
| 2025-05-29 04:00:00 | NQ | Futures | 22256.14 | 22265.57 | 22180.26 | 22188.15 | 9581.0 |
| 2025-05-29 05:00:00 | NQ | Futures | 22188.15 | 22224.57 | 22180.26 | 22190.44 | 7292.0 |
| 2025-05-29 06:00:00 | NQ | Futures | 22191.46 | 22193.24 | 22114.05 | 22140.02 | 10693.0 |
| 2025-05-29 07:00:00 | NQ | Futures | 22140.02 | 22144.1 | 22051.15 | 22057.51 | 12105.0 |
| 2025-05-29 08:00:00 | NQ | Futures | 22057.77 | 22092.91 | 22022.88 | 22047.58 | 21372.0 |
| 2025-05-29 09:00:00 | NQ | Futures | 22048.35 | 22096.48 | 21885.11 | 21918.47 | 72783.0 |
| 2025-05-29 10:00:00 | NQ | Futures | 21917.97 | 21934.01 | 21778.42 | 21916.44 | 76023.0 |
| 2025-05-29 11:00:00 | NQ | Futures | 21915.42 | 21920.0 | 21722.39 | 21746.07 | 55691.0 |
| 2025-05-29 12:00:00 | NQ | Futures | 21745.31 | 21871.11 | 21697.44 | 21855.58 | 47938.0 |
| 2025-05-29 13:00:00 | NQ | Futures | 21854.56 | 21884.86 | 21765.68 | 21770.01 | 37561.0 |
| 2025-05-29 14:00:00 | NQ | Futures | 21770.78 | 21803.37 | 21713.99 | 21760.34 | 39417.0 |
| 2025-05-29 15:00:00 | NQ | Futures | 21760.59 | 21846.41 | 21735.38 | 21809.74 | 54078.0 |
| 2025-05-29 16:00:00 | NQ | Futures | 21809.99 | 21826.29 | 21764.92 | 21783.0 | 14759.0 |
| 2025-05-29 18:00:00 | NQ | Futures | 21768.99 | 21793.44 | 21732.32 | 21751.17 | 6301.0 |
| 2025-05-29 19:00:00 | NQ | Futures | 21749.64 | 21767.21 | 21710.42 | 21713.73 | 4952.0 |
| 2025-05-29 20:00:00 | NQ | Futures | 21713.99 | 21753.97 | 21711.7 | 21738.94 | 5257.0 |
| 2025-05-29 21:00:00 | NQ | Futures | 21737.93 | 21745.82 | 21664.33 | 21739.71 | 7675.0 |
| 2025-05-29 22:00:00 | NQ | Futures | 21740.73 | 21760.34 | 21730.54 | 21756.26 | 3494.0 |
| 2025-05-29 23:00:00 | NQ | Futures | 21757.53 | 21762.63 | 21731.3 | 21743.27 | 2484.0 |
| 2025-05-29 00:00:00 | YM | Futures | 43946.5 | 43993.8 | 43944.4 | 43987.6 | 776.0 |
| 2025-05-29 01:00:00 | YM | Futures | 43988.7 | 44025.7 | 43970.1 | 43987.6 | 974.0 |
| 2025-05-29 02:00:00 | YM | Futures | 43984.6 | 43985.6 | 43914.6 | 43923.8 | 1419.0 |
| 2025-05-29 03:00:00 | YM | Futures | 43922.8 | 43980.4 | 43879.6 | 43975.3 | 2358.0 |
> showing 50 of 2,073 rows — these rows as CSV