PREVIEW / futures_1hour / 2024-10-01
file: by_date/futures_1hour/2024/2024-10-01.parquet size: 70 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 |
|---|---|---|---|---|---|---|---|
| 2024-10-01 00:00:00 | ES | Futures | 6036.25 | 6036.51 | 6032.1 | 6032.62 | 3917.0 |
| 2024-10-01 01:00:00 | ES | Futures | 6032.62 | 6034.96 | 6028.21 | 6031.58 | 5365.0 |
| 2024-10-01 02:00:00 | ES | Futures | 6031.58 | 6037.03 | 6029.77 | 6034.18 | 6960.0 |
| 2024-10-01 03:00:00 | ES | Futures | 6034.44 | 6035.22 | 6021.72 | 6034.18 | 16953.0 |
| 2024-10-01 04:00:00 | ES | Futures | 6034.18 | 6035.22 | 6027.43 | 6029.77 | 9411.0 |
| 2024-10-01 05:00:00 | ES | Futures | 6029.51 | 6031.84 | 6025.87 | 6030.8 | 7379.0 |
| 2024-10-01 06:00:00 | ES | Futures | 6030.55 | 6039.11 | 6029.51 | 6038.59 | 9337.0 |
| 2024-10-01 07:00:00 | ES | Futures | 6038.33 | 6040.93 | 6029.51 | 6032.1 | 12555.0 |
| 2024-10-01 08:00:00 | ES | Futures | 6032.1 | 6035.48 | 6028.21 | 6032.36 | 14164.0 |
| 2024-10-01 09:00:00 | ES | Futures | 6032.1 | 6033.66 | 5977.86 | 5989.8 | 289397.0 |
| 2024-10-01 10:00:00 | ES | Futures | 5988.24 | 5997.07 | 5958.14 | 5972.93 | 361846.0 |
| 2024-10-01 11:00:00 | ES | Futures | 5973.19 | 5987.98 | 5951.39 | 5976.3 | 232495.0 |
| 2024-10-01 12:00:00 | ES | Futures | 5976.3 | 5989.54 | 5957.62 | 5977.08 | 221165.0 |
| 2024-10-01 13:00:00 | ES | Futures | 5977.08 | 5987.46 | 5954.25 | 5986.95 | 192602.0 |
| 2024-10-01 14:00:00 | ES | Futures | 5986.95 | 6004.07 | 5986.43 | 5998.36 | 162266.0 |
| 2024-10-01 15:00:00 | ES | Futures | 5998.1 | 5999.4 | 5976.82 | 5979.94 | 202149.0 |
| 2024-10-01 16:00:00 | ES | Futures | 5979.94 | 5986.95 | 5976.56 | 5977.6 | 68884.0 |
| 2024-10-01 18:00:00 | ES | Futures | 5979.68 | 5983.05 | 5963.85 | 5968.0 | 10415.0 |
| 2024-10-01 19:00:00 | ES | Futures | 5967.74 | 5973.45 | 5961.25 | 5969.82 | 8729.0 |
| 2024-10-01 20:00:00 | ES | Futures | 5970.08 | 5979.16 | 5968.52 | 5974.49 | 10654.0 |
| 2024-10-01 21:00:00 | ES | Futures | 5974.75 | 5982.27 | 5973.19 | 5980.72 | 6935.0 |
| 2024-10-01 22:00:00 | ES | Futures | 5980.98 | 5983.05 | 5974.23 | 5976.82 | 5765.0 |
| 2024-10-01 23:00:00 | ES | Futures | 5976.56 | 5980.98 | 5971.37 | 5979.68 | 6105.0 |
| 2024-10-01 00:00:00 | NQ | Futures | 21169.64 | 21170.95 | 21136.77 | 21141.46 | 2814.0 |
| 2024-10-01 01:00:00 | NQ | Futures | 21141.2 | 21153.99 | 21116.16 | 21135.2 | 3660.0 |
| 2024-10-01 02:00:00 | NQ | Futures | 21135.99 | 21168.08 | 21127.11 | 21151.9 | 3929.0 |
| 2024-10-01 03:00:00 | NQ | Futures | 21151.12 | 21175.9 | 21097.37 | 21171.47 | 8495.0 |
| 2024-10-01 04:00:00 | NQ | Futures | 21171.21 | 21177.47 | 21134.94 | 21154.77 | 6293.0 |
| 2024-10-01 05:00:00 | NQ | Futures | 21154.77 | 21168.34 | 21139.9 | 21163.12 | 3129.0 |
| 2024-10-01 06:00:00 | NQ | Futures | 21163.38 | 21206.17 | 21156.08 | 21201.74 | 4521.0 |
| 2024-10-01 07:00:00 | NQ | Futures | 21200.95 | 21211.91 | 21140.94 | 21157.64 | 8660.0 |
| 2024-10-01 08:00:00 | NQ | Futures | 21156.86 | 21171.99 | 21137.03 | 21161.03 | 7425.0 |
| 2024-10-01 09:00:00 | NQ | Futures | 21160.25 | 21165.21 | 20850.55 | 20918.91 | 99257.0 |
| 2024-10-01 10:00:00 | NQ | Futures | 20919.43 | 20954.65 | 20733.4 | 20793.15 | 113606.0 |
| 2024-10-01 11:00:00 | NQ | Futures | 20793.67 | 20848.46 | 20683.04 | 20792.62 | 88797.0 |
| 2024-10-01 12:00:00 | NQ | Futures | 20792.89 | 20868.81 | 20721.66 | 20804.63 | 74950.0 |
| 2024-10-01 13:00:00 | NQ | Futures | 20805.15 | 20874.03 | 20710.7 | 20872.2 | 68310.0 |
| 2024-10-01 14:00:00 | NQ | Futures | 20871.68 | 20957.78 | 20869.33 | 20929.6 | 59632.0 |
| 2024-10-01 15:00:00 | NQ | Futures | 20929.86 | 20940.04 | 20824.2 | 20850.55 | 57721.0 |
| 2024-10-01 16:00:00 | NQ | Futures | 20850.29 | 20890.47 | 20824.98 | 20833.59 | 16799.0 |
| 2024-10-01 18:00:00 | NQ | Futures | 20847.16 | 20858.37 | 20774.62 | 20787.67 | 5552.0 |
| 2024-10-01 19:00:00 | NQ | Futures | 20787.67 | 20818.72 | 20759.49 | 20802.8 | 4743.0 |
| 2024-10-01 20:00:00 | NQ | Futures | 20803.32 | 20838.28 | 20793.67 | 20820.54 | 4730.0 |
| 2024-10-01 21:00:00 | NQ | Futures | 20821.85 | 20862.81 | 20816.11 | 20856.29 | 4129.0 |
| 2024-10-01 22:00:00 | NQ | Futures | 20857.59 | 20868.81 | 20827.59 | 20839.07 | 3390.0 |
| 2024-10-01 23:00:00 | NQ | Futures | 20839.07 | 20863.33 | 20812.71 | 20857.07 | 3875.0 |
| 2024-10-01 00:00:00 | YM | Futures | 44365.2 | 44369.4 | 44353.7 | 44356.9 | 291.0 |
| 2024-10-01 01:00:00 | YM | Futures | 44354.8 | 44361.0 | 44334.0 | 44341.3 | 517.0 |
| 2024-10-01 02:00:00 | YM | Futures | 44342.3 | 44378.7 | 44330.8 | 44349.6 | 879.0 |
| 2024-10-01 03:00:00 | YM | Futures | 44348.5 | 44348.5 | 44252.8 | 44319.4 | 1644.0 |
> showing 50 of 2,139 rows — these rows as CSV