PREVIEW / futures_1hour / 2024-10-03
file: by_date/futures_1hour/2024/2024-10-03.parquet size: 68 KB rows: 2,099
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-03 00:00:00 | ES | Futures | 5970.08 | 5971.11 | 5967.22 | 5967.48 | 3254.0 |
| 2024-10-03 01:00:00 | ES | Futures | 5967.74 | 5971.63 | 5965.92 | 5966.44 | 6082.0 |
| 2024-10-03 02:00:00 | ES | Futures | 5966.44 | 5973.19 | 5965.4 | 5970.85 | 7623.0 |
| 2024-10-03 03:00:00 | ES | Futures | 5970.85 | 5971.89 | 5944.64 | 5950.61 | 32998.0 |
| 2024-10-03 04:00:00 | ES | Futures | 5950.61 | 5961.77 | 5949.83 | 5957.88 | 19645.0 |
| 2024-10-03 05:00:00 | ES | Futures | 5958.14 | 5962.29 | 5955.02 | 5959.95 | 8087.0 |
| 2024-10-03 06:00:00 | ES | Futures | 5959.95 | 5965.66 | 5956.58 | 5965.4 | 8424.0 |
| 2024-10-03 07:00:00 | ES | Futures | 5965.15 | 5974.49 | 5962.81 | 5974.49 | 13706.0 |
| 2024-10-03 08:00:00 | ES | Futures | 5974.49 | 5978.64 | 5962.55 | 5963.07 | 35368.0 |
| 2024-10-03 09:00:00 | ES | Futures | 5963.33 | 5973.45 | 5957.88 | 5968.52 | 150092.0 |
| 2024-10-03 10:00:00 | ES | Futures | 5969.04 | 5989.8 | 5951.91 | 5956.58 | 313102.0 |
| 2024-10-03 11:00:00 | ES | Futures | 5956.58 | 5980.98 | 5951.91 | 5975.79 | 150636.0 |
| 2024-10-03 12:00:00 | ES | Futures | 5975.79 | 5983.05 | 5947.5 | 5953.47 | 143285.0 |
| 2024-10-03 13:00:00 | ES | Futures | 5953.47 | 5964.37 | 5943.86 | 5960.73 | 134291.0 |
| 2024-10-03 14:00:00 | ES | Futures | 5960.73 | 5964.37 | 5953.99 | 5957.62 | 67807.0 |
| 2024-10-03 15:00:00 | ES | Futures | 5957.62 | 5973.45 | 5949.57 | 5968.0 | 168531.0 |
| 2024-10-03 16:00:00 | ES | Futures | 5968.0 | 5973.45 | 5962.29 | 5962.81 | 53636.0 |
| 2024-10-03 18:00:00 | ES | Futures | 5964.63 | 5970.85 | 5959.7 | 5967.74 | 5961.0 |
| 2024-10-03 19:00:00 | ES | Futures | 5968.0 | 5969.56 | 5964.11 | 5968.26 | 3975.0 |
| 2024-10-03 20:00:00 | ES | Futures | 5968.0 | 5968.78 | 5960.73 | 5966.96 | 5523.0 |
| 2024-10-03 21:00:00 | ES | Futures | 5966.96 | 5980.46 | 5964.11 | 5978.38 | 9715.0 |
| 2024-10-03 22:00:00 | ES | Futures | 5978.38 | 5982.79 | 5975.79 | 5976.82 | 6955.0 |
| 2024-10-03 23:00:00 | ES | Futures | 5977.08 | 5977.6 | 5970.85 | 5971.89 | 4462.0 |
| 2024-10-03 00:00:00 | NQ | Futures | 20820.8 | 20829.15 | 20809.58 | 20815.58 | 1697.0 |
| 2024-10-03 01:00:00 | NQ | Futures | 20815.85 | 20838.02 | 20800.71 | 20809.32 | 2930.0 |
| 2024-10-03 02:00:00 | NQ | Futures | 20808.28 | 20844.29 | 20793.93 | 20835.68 | 5253.0 |
| 2024-10-03 03:00:00 | NQ | Futures | 20833.59 | 20838.55 | 20718.53 | 20752.97 | 13015.0 |
| 2024-10-03 04:00:00 | NQ | Futures | 20752.97 | 20799.41 | 20750.88 | 20778.8 | 8197.0 |
| 2024-10-03 05:00:00 | NQ | Futures | 20779.06 | 20796.8 | 20765.23 | 20788.19 | 4529.0 |
| 2024-10-03 06:00:00 | NQ | Futures | 20786.36 | 20818.19 | 20772.8 | 20817.93 | 4656.0 |
| 2024-10-03 07:00:00 | NQ | Futures | 20817.15 | 20849.5 | 20799.41 | 20849.5 | 6514.0 |
| 2024-10-03 08:00:00 | NQ | Futures | 20849.5 | 20867.77 | 20787.41 | 20791.06 | 16349.0 |
| 2024-10-03 09:00:00 | NQ | Futures | 20790.54 | 20923.34 | 20763.14 | 20896.99 | 63640.0 |
| 2024-10-03 10:00:00 | NQ | Futures | 20898.03 | 20991.7 | 20781.67 | 20810.89 | 130001.0 |
| 2024-10-03 11:00:00 | NQ | Futures | 20810.63 | 20935.08 | 20796.28 | 20914.99 | 55335.0 |
| 2024-10-03 12:00:00 | NQ | Futures | 20914.47 | 20926.99 | 20770.45 | 20789.49 | 49568.0 |
| 2024-10-03 13:00:00 | NQ | Futures | 20790.28 | 20861.24 | 20746.7 | 20834.11 | 49529.0 |
| 2024-10-03 14:00:00 | NQ | Futures | 20834.37 | 20847.68 | 20794.45 | 20813.24 | 27499.0 |
| 2024-10-03 15:00:00 | NQ | Futures | 20813.24 | 20880.03 | 20782.97 | 20860.46 | 45958.0 |
| 2024-10-03 16:00:00 | NQ | Futures | 20861.24 | 20891.25 | 20826.28 | 20829.41 | 11132.0 |
| 2024-10-03 18:00:00 | NQ | Futures | 20836.98 | 20868.55 | 20811.93 | 20853.16 | 3355.0 |
| 2024-10-03 19:00:00 | NQ | Futures | 20853.16 | 20863.33 | 20839.07 | 20855.77 | 2465.0 |
| 2024-10-03 20:00:00 | NQ | Futures | 20854.72 | 20857.33 | 20818.98 | 20853.42 | 3013.0 |
| 2024-10-03 21:00:00 | NQ | Futures | 20853.16 | 20926.47 | 20842.72 | 20917.34 | 5388.0 |
| 2024-10-03 22:00:00 | NQ | Futures | 20918.38 | 20945.52 | 20904.03 | 20913.95 | 4522.0 |
| 2024-10-03 23:00:00 | NQ | Futures | 20913.95 | 20919.17 | 20877.16 | 20886.03 | 3375.0 |
| 2024-10-03 00:00:00 | YM | Futures | 44192.4 | 44199.7 | 44170.6 | 44174.7 | 220.0 |
| 2024-10-03 01:00:00 | YM | Futures | 44174.7 | 44190.3 | 44164.3 | 44169.5 | 474.0 |
| 2024-10-03 02:00:00 | YM | Futures | 44167.4 | 44204.9 | 44160.2 | 44187.2 | 974.0 |
| 2024-10-03 03:00:00 | YM | Futures | 44186.2 | 44199.7 | 43997.8 | 44037.4 | 3595.0 |
> showing 50 of 2,099 rows — these rows as CSV