PREVIEW / futures_1hour / 2025-05-21
file: by_date/futures_1hour/2025/2025-05-21.parquet size: 68 KB rows: 2,098
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-21 00:00:00 | ES | Futures | 6038.28 | 6038.53 | 6031.67 | 6033.96 | 3409.0 |
| 2025-05-21 01:00:00 | ES | Futures | 6033.96 | 6039.55 | 6027.1 | 6027.86 | 4475.0 |
| 2025-05-21 02:00:00 | ES | Futures | 6027.86 | 6029.39 | 6018.72 | 6020.5 | 10504.0 |
| 2025-05-21 03:00:00 | ES | Futures | 6020.5 | 6030.15 | 6020.24 | 6028.37 | 9034.0 |
| 2025-05-21 04:00:00 | ES | Futures | 6028.37 | 6030.15 | 6015.92 | 6022.78 | 8805.0 |
| 2025-05-21 05:00:00 | ES | Futures | 6022.78 | 6026.08 | 6007.79 | 6010.08 | 11636.0 |
| 2025-05-21 06:00:00 | ES | Futures | 6010.08 | 6015.16 | 6000.43 | 6014.91 | 15326.0 |
| 2025-05-21 07:00:00 | ES | Futures | 6014.65 | 6029.89 | 6014.4 | 6026.59 | 18964.0 |
| 2025-05-21 08:00:00 | ES | Futures | 6026.59 | 6027.35 | 6012.37 | 6018.72 | 27596.0 |
| 2025-05-21 09:00:00 | ES | Futures | 6018.72 | 6031.16 | 6004.24 | 6024.05 | 130920.0 |
| 2025-05-21 10:00:00 | ES | Futures | 6024.31 | 6040.56 | 6014.14 | 6032.43 | 164012.0 |
| 2025-05-21 11:00:00 | ES | Futures | 6032.43 | 6048.95 | 6029.64 | 6043.61 | 130053.0 |
| 2025-05-21 12:00:00 | ES | Futures | 6043.61 | 6052.5 | 6040.56 | 6042.34 | 85097.0 |
| 2025-05-21 13:00:00 | ES | Futures | 6042.6 | 6044.12 | 5961.81 | 5986.45 | 317380.0 |
| 2025-05-21 14:00:00 | ES | Futures | 5986.2 | 5988.74 | 5962.07 | 5964.61 | 161316.0 |
| 2025-05-21 15:00:00 | ES | Futures | 5964.61 | 5970.96 | 5942.25 | 5953.94 | 272961.0 |
| 2025-05-21 16:00:00 | ES | Futures | 5953.94 | 5956.22 | 5945.81 | 5953.43 | 60824.0 |
| 2025-05-21 18:00:00 | ES | Futures | 5952.67 | 5960.54 | 5945.55 | 5952.92 | 8186.0 |
| 2025-05-21 19:00:00 | ES | Futures | 5952.67 | 5960.03 | 5950.63 | 5955.21 | 6878.0 |
| 2025-05-21 20:00:00 | ES | Futures | 5955.46 | 5967.15 | 5953.17 | 5966.38 | 9368.0 |
| 2025-05-21 21:00:00 | ES | Futures | 5966.38 | 5969.18 | 5957.49 | 5958.0 | 6643.0 |
| 2025-05-21 22:00:00 | ES | Futures | 5957.75 | 5963.84 | 5955.97 | 5958.0 | 5817.0 |
| 2025-05-21 23:00:00 | ES | Futures | 5958.0 | 5963.34 | 5957.75 | 5959.78 | 3992.0 |
| 2025-05-21 00:00:00 | NQ | Futures | 21775.87 | 21775.87 | 21746.84 | 21755.24 | 2879.0 |
| 2025-05-21 01:00:00 | NQ | Futures | 21755.75 | 21782.49 | 21723.92 | 21728.25 | 4378.0 |
| 2025-05-21 02:00:00 | NQ | Futures | 21728.5 | 21737.67 | 21682.67 | 21690.81 | 9413.0 |
| 2025-05-21 03:00:00 | NQ | Futures | 21690.31 | 21746.07 | 21689.54 | 21740.47 | 5483.0 |
| 2025-05-21 04:00:00 | NQ | Futures | 21740.73 | 21745.57 | 21685.47 | 21719.34 | 5616.0 |
| 2025-05-21 05:00:00 | NQ | Futures | 21719.59 | 21733.09 | 21656.95 | 21665.09 | 7218.0 |
| 2025-05-21 06:00:00 | NQ | Futures | 21665.35 | 21698.96 | 21624.86 | 21696.67 | 8441.0 |
| 2025-05-21 07:00:00 | NQ | Futures | 21696.42 | 21753.2 | 21692.34 | 21737.16 | 9158.0 |
| 2025-05-21 08:00:00 | NQ | Futures | 21736.91 | 21739.71 | 21680.12 | 21708.39 | 12410.0 |
| 2025-05-21 09:00:00 | NQ | Futures | 21709.4 | 21803.12 | 21658.22 | 21772.05 | 57589.0 |
| 2025-05-21 10:00:00 | NQ | Futures | 21772.05 | 21858.38 | 21760.08 | 21856.08 | 64538.0 |
| 2025-05-21 11:00:00 | NQ | Futures | 21855.83 | 21935.79 | 21846.15 | 21916.18 | 57216.0 |
| 2025-05-21 12:00:00 | NQ | Futures | 21915.42 | 21959.73 | 21908.8 | 21915.67 | 34732.0 |
| 2025-05-21 13:00:00 | NQ | Futures | 21915.67 | 21923.82 | 21553.3 | 21667.13 | 126003.0 |
| 2025-05-21 14:00:00 | NQ | Futures | 21667.39 | 21678.85 | 21560.94 | 21570.62 | 60793.0 |
| 2025-05-21 15:00:00 | NQ | Futures | 21572.15 | 21615.95 | 21464.94 | 21542.61 | 86069.0 |
| 2025-05-21 16:00:00 | NQ | Futures | 21542.61 | 21549.23 | 21504.15 | 21539.04 | 17849.0 |
| 2025-05-21 18:00:00 | NQ | Futures | 21538.53 | 21571.13 | 21506.7 | 21537.0 | 6308.0 |
| 2025-05-21 19:00:00 | NQ | Futures | 21537.77 | 21569.85 | 21526.82 | 21539.3 | 4789.0 |
| 2025-05-21 20:00:00 | NQ | Futures | 21541.08 | 21595.57 | 21528.6 | 21591.75 | 6569.0 |
| 2025-05-21 21:00:00 | NQ | Futures | 21592.01 | 21603.21 | 21543.88 | 21548.97 | 4894.0 |
| 2025-05-21 22:00:00 | NQ | Futures | 21548.46 | 21576.48 | 21539.04 | 21550.25 | 4380.0 |
| 2025-05-21 23:00:00 | NQ | Futures | 21551.01 | 21574.44 | 21550.76 | 21559.92 | 3087.0 |
| 2025-05-21 00:00:00 | YM | Futures | 43901.2 | 43904.3 | 43863.1 | 43880.6 | 313.0 |
| 2025-05-21 01:00:00 | YM | Futures | 43882.7 | 43909.4 | 43839.4 | 43847.7 | 495.0 |
| 2025-05-21 02:00:00 | YM | Futures | 43843.6 | 43851.8 | 43792.1 | 43792.1 | 1588.0 |
| 2025-05-21 03:00:00 | YM | Futures | 43797.2 | 43850.8 | 43796.2 | 43831.2 | 825.0 |
> showing 50 of 2,098 rows — these rows as CSV