PREVIEW / futures_1hour / 2025-05-28
file: by_date/futures_1hour/2025/2025-05-28.parquet size: 67 KB rows: 2,080
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-28 00:00:00 | ES | Futures | 6025.58 | 6026.34 | 6023.8 | 6024.31 | 2506.0 |
| 2025-05-28 01:00:00 | ES | Futures | 6024.31 | 6028.37 | 6022.78 | 6025.83 | 4203.0 |
| 2025-05-28 02:00:00 | ES | Futures | 6025.83 | 6028.62 | 6020.75 | 6021.51 | 5495.0 |
| 2025-05-28 03:00:00 | ES | Futures | 6021.77 | 6025.58 | 6018.72 | 6018.97 | 11223.0 |
| 2025-05-28 04:00:00 | ES | Futures | 6019.22 | 6023.29 | 6017.7 | 6018.21 | 8094.0 |
| 2025-05-28 05:00:00 | ES | Futures | 6018.46 | 6020.75 | 6014.14 | 6020.75 | 9018.0 |
| 2025-05-28 06:00:00 | ES | Futures | 6020.75 | 6040.06 | 6019.22 | 6039.29 | 14547.0 |
| 2025-05-28 07:00:00 | ES | Futures | 6039.29 | 6040.06 | 6030.91 | 6034.98 | 12731.0 |
| 2025-05-28 08:00:00 | ES | Futures | 6034.98 | 6041.83 | 6033.45 | 6034.21 | 17511.0 |
| 2025-05-28 09:00:00 | ES | Futures | 6034.47 | 6048.69 | 6025.58 | 6028.37 | 141059.0 |
| 2025-05-28 10:00:00 | ES | Futures | 6028.37 | 6031.93 | 6011.86 | 6013.38 | 162947.0 |
| 2025-05-28 11:00:00 | ES | Futures | 6013.38 | 6021.51 | 6009.32 | 6010.33 | 120305.0 |
| 2025-05-28 12:00:00 | ES | Futures | 6010.59 | 6022.53 | 6010.08 | 6019.48 | 77902.0 |
| 2025-05-28 13:00:00 | ES | Futures | 6019.48 | 6026.34 | 6014.14 | 6017.19 | 83666.0 |
| 2025-05-28 14:00:00 | ES | Futures | 6016.94 | 6024.81 | 5998.65 | 6017.95 | 113411.0 |
| 2025-05-28 15:00:00 | ES | Futures | 6017.7 | 6028.62 | 5989.76 | 5996.87 | 237299.0 |
| 2025-05-28 16:00:00 | ES | Futures | 5997.12 | 6022.78 | 5985.18 | 6021.26 | 78979.0 |
| 2025-05-28 18:00:00 | ES | Futures | 6019.22 | 6042.85 | 6012.11 | 6041.07 | 14263.0 |
| 2025-05-28 19:00:00 | ES | Futures | 6041.33 | 6094.42 | 6041.33 | 6088.58 | 53745.0 |
| 2025-05-28 20:00:00 | ES | Futures | 6088.83 | 6099.76 | 6073.59 | 6097.22 | 25475.0 |
| 2025-05-28 21:00:00 | ES | Futures | 6097.22 | 6097.47 | 6080.96 | 6095.44 | 14195.0 |
| 2025-05-28 22:00:00 | ES | Futures | 6095.18 | 6101.28 | 6092.64 | 6094.93 | 12979.0 |
| 2025-05-28 23:00:00 | ES | Futures | 6094.93 | 6102.8 | 6090.36 | 6091.37 | 9504.0 |
| 2025-05-28 00:00:00 | NQ | Futures | 21842.33 | 21846.66 | 21833.93 | 21837.49 | 2035.0 |
| 2025-05-28 01:00:00 | NQ | Futures | 21837.49 | 21861.94 | 21834.44 | 21851.5 | 3634.0 |
| 2025-05-28 02:00:00 | NQ | Futures | 21852.01 | 21861.69 | 21832.15 | 21834.95 | 3320.0 |
| 2025-05-28 03:00:00 | NQ | Futures | 21835.71 | 21857.87 | 21826.8 | 21832.4 | 5655.0 |
| 2025-05-28 04:00:00 | NQ | Futures | 21831.89 | 21842.33 | 21815.09 | 21817.38 | 4464.0 |
| 2025-05-28 05:00:00 | NQ | Futures | 21818.4 | 21830.11 | 21805.41 | 21828.84 | 4849.0 |
| 2025-05-28 06:00:00 | NQ | Futures | 21828.58 | 21919.24 | 21822.72 | 21916.95 | 10027.0 |
| 2025-05-28 07:00:00 | NQ | Futures | 21916.95 | 21924.33 | 21886.13 | 21904.21 | 8492.0 |
| 2025-05-28 08:00:00 | NQ | Futures | 21904.21 | 21938.34 | 21900.39 | 21907.27 | 10887.0 |
| 2025-05-28 09:00:00 | NQ | Futures | 21907.27 | 21968.9 | 21850.74 | 21867.03 | 63603.0 |
| 2025-05-28 10:00:00 | NQ | Futures | 21867.03 | 21886.64 | 21824.76 | 21831.38 | 54569.0 |
| 2025-05-28 11:00:00 | NQ | Futures | 21830.87 | 21877.22 | 21827.31 | 21835.97 | 39949.0 |
| 2025-05-28 12:00:00 | NQ | Futures | 21836.22 | 21880.79 | 21835.46 | 21864.74 | 27551.0 |
| 2025-05-28 13:00:00 | NQ | Futures | 21865.0 | 21890.46 | 21855.58 | 21870.09 | 25172.0 |
| 2025-05-28 14:00:00 | NQ | Futures | 21869.33 | 21902.43 | 21799.55 | 21868.56 | 35488.0 |
| 2025-05-28 15:00:00 | NQ | Futures | 21867.8 | 21914.65 | 21746.33 | 21770.27 | 65863.0 |
| 2025-05-28 16:00:00 | NQ | Futures | 21770.01 | 21929.42 | 21718.06 | 21925.6 | 31139.0 |
| 2025-05-28 18:00:00 | NQ | Futures | 21913.38 | 21998.94 | 21888.93 | 21989.52 | 9733.0 |
| 2025-05-28 19:00:00 | NQ | Futures | 21990.8 | 22182.29 | 21989.52 | 22171.34 | 26919.0 |
| 2025-05-28 20:00:00 | NQ | Futures | 22171.6 | 22239.85 | 22113.79 | 22226.6 | 16597.0 |
| 2025-05-28 21:00:00 | NQ | Futures | 22226.86 | 22228.39 | 22157.85 | 22199.87 | 9942.0 |
| 2025-05-28 22:00:00 | NQ | Futures | 22199.61 | 22229.66 | 22187.39 | 22196.56 | 7463.0 |
| 2025-05-28 23:00:00 | NQ | Futures | 22196.81 | 22223.04 | 22183.31 | 22188.15 | 4981.0 |
| 2025-05-28 00:00:00 | YM | Futures | 43624.3 | 43626.4 | 43608.9 | 43613.0 | 393.0 |
| 2025-05-28 01:00:00 | YM | Futures | 43614.1 | 43640.8 | 43599.6 | 43614.1 | 341.0 |
| 2025-05-28 02:00:00 | YM | Futures | 43614.1 | 43627.4 | 43578.0 | 43587.3 | 635.0 |
| 2025-05-28 03:00:00 | YM | Futures | 43589.4 | 43608.9 | 43554.4 | 43559.5 | 1108.0 |
> showing 50 of 2,080 rows — these rows as CSV