PREVIEW / futures_1hour / 2025-06-02
file: by_date/futures_1hour/2025/2025-06-02.parquet size: 67 KB rows: 2,077
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-06-02 00:00:00 | ES | Futures | 5982.39 | 5987.72 | 5979.34 | 5981.88 | 5468.0 |
| 2025-06-02 01:00:00 | ES | Futures | 5981.88 | 5985.69 | 5976.29 | 5980.1 | 6258.0 |
| 2025-06-02 02:00:00 | ES | Futures | 5979.85 | 5983.91 | 5972.74 | 5977.56 | 8543.0 |
| 2025-06-02 03:00:00 | ES | Futures | 5977.31 | 5987.72 | 5962.32 | 5976.04 | 19610.0 |
| 2025-06-02 04:00:00 | ES | Futures | 5975.78 | 5990.01 | 5974.51 | 5982.64 | 16130.0 |
| 2025-06-02 05:00:00 | ES | Futures | 5982.64 | 5983.91 | 5971.47 | 5977.56 | 13852.0 |
| 2025-06-02 06:00:00 | ES | Futures | 5977.56 | 5985.95 | 5975.78 | 5985.18 | 11608.0 |
| 2025-06-02 07:00:00 | ES | Futures | 5984.93 | 5995.35 | 5982.14 | 5987.22 | 16244.0 |
| 2025-06-02 08:00:00 | ES | Futures | 5987.47 | 5996.87 | 5984.42 | 5994.33 | 19193.0 |
| 2025-06-02 09:00:00 | ES | Futures | 5994.33 | 6013.38 | 5981.12 | 5982.14 | 152575.0 |
| 2025-06-02 10:00:00 | ES | Futures | 5982.39 | 6011.6 | 5965.37 | 6009.57 | 214860.0 |
| 2025-06-02 11:00:00 | ES | Futures | 6009.57 | 6016.94 | 5996.87 | 6014.4 | 124658.0 |
| 2025-06-02 12:00:00 | ES | Futures | 6014.4 | 6018.21 | 6005.76 | 6016.18 | 78713.0 |
| 2025-06-02 13:00:00 | ES | Futures | 6016.43 | 6022.78 | 6011.1 | 6015.92 | 77046.0 |
| 2025-06-02 14:00:00 | ES | Futures | 6015.92 | 6036.5 | 6011.6 | 6035.23 | 117479.0 |
| 2025-06-02 15:00:00 | ES | Futures | 6035.48 | 6045.14 | 6033.2 | 6043.36 | 164637.0 |
| 2025-06-02 16:00:00 | ES | Futures | 6043.1 | 6051.74 | 6042.85 | 6045.39 | 57255.0 |
| 2025-06-02 18:00:00 | ES | Futures | 6045.14 | 6045.65 | 6037.77 | 6038.02 | 4501.0 |
| 2025-06-02 19:00:00 | ES | Futures | 6038.28 | 6043.61 | 6026.08 | 6030.91 | 10296.0 |
| 2025-06-02 20:00:00 | ES | Futures | 6031.16 | 6032.43 | 6027.35 | 6029.39 | 5255.0 |
| 2025-06-02 21:00:00 | ES | Futures | 6029.64 | 6032.18 | 6027.35 | 6028.62 | 5483.0 |
| 2025-06-02 22:00:00 | ES | Futures | 6028.88 | 6029.64 | 6017.7 | 6023.54 | 8911.0 |
| 2025-06-02 23:00:00 | ES | Futures | 6023.04 | 6023.04 | 6016.43 | 6021.0 | 5842.0 |
| 2025-06-02 00:00:00 | NQ | Futures | 21626.64 | 21650.07 | 21613.66 | 21631.23 | 2787.0 |
| 2025-06-02 01:00:00 | NQ | Futures | 21631.48 | 21646.51 | 21608.05 | 21625.37 | 3463.0 |
| 2025-06-02 02:00:00 | NQ | Futures | 21625.62 | 21643.96 | 21592.52 | 21623.59 | 5444.0 |
| 2025-06-02 03:00:00 | NQ | Futures | 21622.82 | 21663.31 | 21556.87 | 21606.27 | 10937.0 |
| 2025-06-02 04:00:00 | NQ | Futures | 21606.02 | 21659.24 | 21601.18 | 21630.97 | 7443.0 |
| 2025-06-02 05:00:00 | NQ | Futures | 21629.95 | 21637.85 | 21595.83 | 21621.04 | 6493.0 |
| 2025-06-02 06:00:00 | NQ | Futures | 21620.28 | 21649.05 | 21609.07 | 21645.74 | 5932.0 |
| 2025-06-02 07:00:00 | NQ | Futures | 21645.74 | 21687.76 | 21634.03 | 21650.83 | 7128.0 |
| 2025-06-02 08:00:00 | NQ | Futures | 21651.6 | 21690.81 | 21635.05 | 21680.88 | 9941.0 |
| 2025-06-02 09:00:00 | NQ | Futures | 21681.14 | 21857.36 | 21653.38 | 21713.99 | 66165.0 |
| 2025-06-02 10:00:00 | NQ | Futures | 21707.62 | 21817.38 | 21629.95 | 21795.48 | 72626.0 |
| 2025-06-02 11:00:00 | NQ | Futures | 21795.22 | 21843.86 | 21752.7 | 21833.17 | 45730.0 |
| 2025-06-02 12:00:00 | NQ | Futures | 21832.91 | 21853.79 | 21799.55 | 21844.88 | 29342.0 |
| 2025-06-02 13:00:00 | NQ | Futures | 21844.88 | 21873.91 | 21824.0 | 21844.63 | 28552.0 |
| 2025-06-02 14:00:00 | NQ | Futures | 21844.63 | 21926.37 | 21825.53 | 21918.22 | 37210.0 |
| 2025-06-02 15:00:00 | NQ | Futures | 21918.22 | 21944.7 | 21895.3 | 21935.03 | 43298.0 |
| 2025-06-02 16:00:00 | NQ | Futures | 21934.52 | 21977.81 | 21928.41 | 21955.65 | 17052.0 |
| 2025-06-02 18:00:00 | NQ | Futures | 21956.16 | 21956.42 | 21915.42 | 21920.0 | 2999.0 |
| 2025-06-02 19:00:00 | NQ | Futures | 21919.24 | 21945.21 | 21865.25 | 21894.28 | 8163.0 |
| 2025-06-02 20:00:00 | NQ | Futures | 21895.05 | 21902.69 | 21873.66 | 21883.33 | 3306.0 |
| 2025-06-02 21:00:00 | NQ | Futures | 21883.59 | 21902.43 | 21876.2 | 21887.15 | 3479.0 |
| 2025-06-02 22:00:00 | NQ | Futures | 21887.66 | 21890.21 | 21840.81 | 21867.8 | 4729.0 |
| 2025-06-02 23:00:00 | NQ | Futures | 21866.53 | 21867.54 | 21835.97 | 21861.18 | 3507.0 |
| 2025-06-02 00:00:00 | YM | Futures | 43372.2 | 43397.9 | 43350.6 | 43362.9 | 424.0 |
| 2025-06-02 01:00:00 | YM | Futures | 43371.2 | 43385.6 | 43326.9 | 43343.4 | 615.0 |
| 2025-06-02 02:00:00 | YM | Futures | 43342.4 | 43352.6 | 43283.7 | 43301.2 | 1089.0 |
| 2025-06-02 03:00:00 | YM | Futures | 43302.2 | 43378.4 | 43200.3 | 43299.1 | 2489.0 |
> showing 50 of 2,077 rows — these rows as CSV