PREVIEW / futures_1hour / 2024-10-02
file: by_date/futures_1hour/2024/2024-10-02.parquet size: 69 KB rows: 2,116
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-02 00:00:00 | ES | Futures | 5979.68 | 5980.2 | 5965.66 | 5969.3 | 5552.0 |
| 2024-10-02 01:00:00 | ES | Futures | 5969.04 | 5971.63 | 5957.36 | 5966.96 | 10529.0 |
| 2024-10-02 02:00:00 | ES | Futures | 5966.96 | 5969.56 | 5959.7 | 5966.44 | 10372.0 |
| 2024-10-02 03:00:00 | ES | Futures | 5966.44 | 5976.56 | 5961.25 | 5971.89 | 14950.0 |
| 2024-10-02 04:00:00 | ES | Futures | 5971.89 | 5976.05 | 5967.48 | 5969.3 | 10783.0 |
| 2024-10-02 05:00:00 | ES | Futures | 5969.56 | 5969.82 | 5957.1 | 5961.25 | 12555.0 |
| 2024-10-02 06:00:00 | ES | Futures | 5960.99 | 5972.93 | 5954.25 | 5970.34 | 18608.0 |
| 2024-10-02 07:00:00 | ES | Futures | 5970.34 | 5972.41 | 5961.25 | 5962.81 | 19358.0 |
| 2024-10-02 08:00:00 | ES | Futures | 5962.81 | 5977.08 | 5960.73 | 5971.63 | 34244.0 |
| 2024-10-02 09:00:00 | ES | Futures | 5971.63 | 5972.93 | 5942.05 | 5962.03 | 188528.0 |
| 2024-10-02 10:00:00 | ES | Futures | 5962.03 | 5989.8 | 5960.21 | 5975.01 | 245797.0 |
| 2024-10-02 11:00:00 | ES | Futures | 5975.01 | 5992.14 | 5972.93 | 5987.98 | 144030.0 |
| 2024-10-02 12:00:00 | ES | Futures | 5987.98 | 5990.84 | 5969.82 | 5970.34 | 79844.0 |
| 2024-10-02 13:00:00 | ES | Futures | 5970.34 | 5983.57 | 5966.96 | 5982.79 | 96020.0 |
| 2024-10-02 14:00:00 | ES | Futures | 5982.79 | 5985.91 | 5968.78 | 5980.72 | 75216.0 |
| 2024-10-02 15:00:00 | ES | Futures | 5980.72 | 5986.95 | 5978.64 | 5980.2 | 128204.0 |
| 2024-10-02 16:00:00 | ES | Futures | 5979.94 | 5993.17 | 5977.86 | 5989.8 | 47298.0 |
| 2024-10-02 18:00:00 | ES | Futures | 5989.28 | 5992.65 | 5986.95 | 5987.98 | 4021.0 |
| 2024-10-02 19:00:00 | ES | Futures | 5987.98 | 5989.8 | 5984.87 | 5989.02 | 3787.0 |
| 2024-10-02 20:00:00 | ES | Futures | 5989.28 | 5989.28 | 5975.27 | 5979.16 | 11174.0 |
| 2024-10-02 21:00:00 | ES | Futures | 5979.16 | 5981.75 | 5970.6 | 5975.27 | 12242.0 |
| 2024-10-02 22:00:00 | ES | Futures | 5975.27 | 5977.34 | 5971.37 | 5972.15 | 6676.0 |
| 2024-10-02 23:00:00 | ES | Futures | 5972.15 | 5975.53 | 5968.0 | 5969.82 | 8134.0 |
| 2024-10-02 00:00:00 | NQ | Futures | 20857.59 | 20862.29 | 20779.32 | 20800.19 | 3596.0 |
| 2024-10-02 01:00:00 | NQ | Futures | 20798.63 | 20817.41 | 20748.01 | 20790.02 | 4823.0 |
| 2024-10-02 02:00:00 | NQ | Futures | 20790.8 | 20810.37 | 20759.23 | 20800.97 | 5224.0 |
| 2024-10-02 03:00:00 | NQ | Futures | 20801.76 | 20843.24 | 20767.58 | 20824.2 | 7649.0 |
| 2024-10-02 04:00:00 | NQ | Futures | 20822.89 | 20842.72 | 20802.28 | 20815.85 | 5147.0 |
| 2024-10-02 05:00:00 | NQ | Futures | 20816.37 | 20817.93 | 20761.32 | 20781.41 | 6047.0 |
| 2024-10-02 06:00:00 | NQ | Futures | 20781.14 | 20843.76 | 20746.44 | 20829.41 | 7287.0 |
| 2024-10-02 07:00:00 | NQ | Futures | 20830.72 | 20847.68 | 20793.93 | 20803.58 | 7737.0 |
| 2024-10-02 08:00:00 | NQ | Futures | 20804.63 | 20884.2 | 20794.97 | 20852.63 | 15703.0 |
| 2024-10-02 09:00:00 | NQ | Futures | 20853.16 | 20859.42 | 20699.22 | 20785.32 | 75259.0 |
| 2024-10-02 10:00:00 | NQ | Futures | 20784.54 | 20932.21 | 20774.36 | 20869.33 | 85500.0 |
| 2024-10-02 11:00:00 | NQ | Futures | 20869.59 | 20967.17 | 20863.85 | 20936.39 | 54235.0 |
| 2024-10-02 12:00:00 | NQ | Futures | 20936.91 | 20961.43 | 20849.76 | 20852.63 | 38677.0 |
| 2024-10-02 13:00:00 | NQ | Futures | 20852.11 | 20923.6 | 20840.11 | 20920.21 | 41441.0 |
| 2024-10-02 14:00:00 | NQ | Futures | 20919.17 | 20933.78 | 20858.11 | 20898.82 | 32914.0 |
| 2024-10-02 15:00:00 | NQ | Futures | 20898.82 | 20933.52 | 20877.68 | 20883.42 | 40975.0 |
| 2024-10-02 16:00:00 | NQ | Futures | 20883.42 | 20948.65 | 20877.16 | 20931.69 | 12291.0 |
| 2024-10-02 18:00:00 | NQ | Futures | 20930.91 | 20943.95 | 20917.34 | 20919.69 | 2031.0 |
| 2024-10-02 19:00:00 | NQ | Futures | 20919.95 | 20932.21 | 20904.03 | 20930.65 | 2659.0 |
| 2024-10-02 20:00:00 | NQ | Futures | 20929.86 | 20930.91 | 20855.77 | 20871.68 | 6200.0 |
| 2024-10-02 21:00:00 | NQ | Futures | 20873.25 | 20888.64 | 20820.8 | 20847.16 | 6459.0 |
| 2024-10-02 22:00:00 | NQ | Futures | 20847.68 | 20860.2 | 20824.98 | 20833.85 | 3577.0 |
| 2024-10-02 23:00:00 | NQ | Futures | 20833.33 | 20853.42 | 20805.15 | 20820.8 | 4407.0 |
| 2024-10-02 00:00:00 | YM | Futures | 44149.8 | 44150.8 | 44087.3 | 44104.0 | 544.0 |
| 2024-10-02 01:00:00 | YM | Futures | 44101.9 | 44115.4 | 44030.1 | 44086.3 | 1154.0 |
| 2024-10-02 02:00:00 | YM | Futures | 44086.3 | 44090.4 | 44039.4 | 44061.3 | 1691.0 |
| 2024-10-02 03:00:00 | YM | Futures | 44060.2 | 44120.6 | 44030.1 | 44087.3 | 1905.0 |
> showing 50 of 2,116 rows — these rows as CSV