PREVIEW / futures_1hour / 2024-11-01
file: by_date/futures_1hour/2024/2024-11-01.parquet size: 59 KB rows: 1,702
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-11-01 00:00:00 | ES | Futures | 5967.22 | 5970.08 | 5964.89 | 5966.96 | 4559.0 |
| 2024-11-01 01:00:00 | ES | Futures | 5966.96 | 5973.71 | 5966.44 | 5972.41 | 10989.0 |
| 2024-11-01 02:00:00 | ES | Futures | 5972.67 | 5972.67 | 5963.07 | 5965.15 | 7460.0 |
| 2024-11-01 03:00:00 | ES | Futures | 5965.4 | 5970.34 | 5959.18 | 5969.04 | 13421.0 |
| 2024-11-01 04:00:00 | ES | Futures | 5969.04 | 5976.3 | 5967.48 | 5972.93 | 24359.0 |
| 2024-11-01 05:00:00 | ES | Futures | 5972.93 | 5977.34 | 5971.89 | 5975.01 | 13810.0 |
| 2024-11-01 06:00:00 | ES | Futures | 5975.01 | 5981.5 | 5974.23 | 5980.2 | 14967.0 |
| 2024-11-01 07:00:00 | ES | Futures | 5980.2 | 5983.83 | 5975.79 | 5980.72 | 19483.0 |
| 2024-11-01 08:00:00 | ES | Futures | 5980.98 | 5989.28 | 5972.93 | 5986.17 | 69021.0 |
| 2024-11-01 09:00:00 | ES | Futures | 5986.17 | 6001.48 | 5974.75 | 5999.66 | 172235.0 |
| 2024-11-01 10:00:00 | ES | Futures | 5999.66 | 6024.84 | 5993.69 | 6012.64 | 277682.0 |
| 2024-11-01 11:00:00 | ES | Futures | 6012.64 | 6021.98 | 6001.22 | 6004.33 | 162483.0 |
| 2024-11-01 12:00:00 | ES | Futures | 6004.33 | 6011.08 | 5993.69 | 5997.07 | 121334.0 |
| 2024-11-01 13:00:00 | ES | Futures | 5997.07 | 6006.41 | 5982.27 | 5982.79 | 159419.0 |
| 2024-11-01 14:00:00 | ES | Futures | 5982.53 | 5991.62 | 5977.08 | 5988.24 | 119628.0 |
| 2024-11-01 15:00:00 | ES | Futures | 5988.24 | 5996.55 | 5971.63 | 5976.05 | 226728.0 |
| 2024-11-01 16:00:00 | ES | Futures | 5976.05 | 5984.87 | 5975.27 | 5978.64 | 50886.0 |
| 2024-11-01 00:00:00 | NQ | Futures | 20964.04 | 20977.35 | 20949.69 | 20957.52 | 2876.0 |
| 2024-11-01 01:00:00 | NQ | Futures | 20958.04 | 21005.53 | 20953.61 | 20998.75 | 4873.0 |
| 2024-11-01 02:00:00 | NQ | Futures | 20999.79 | 21001.62 | 20937.69 | 20952.04 | 4176.0 |
| 2024-11-01 03:00:00 | NQ | Futures | 20952.56 | 20975.79 | 20930.65 | 20966.65 | 5151.0 |
| 2024-11-01 04:00:00 | NQ | Futures | 20967.7 | 20994.83 | 20958.3 | 20973.18 | 8057.0 |
| 2024-11-01 05:00:00 | NQ | Futures | 20973.96 | 20990.4 | 20964.04 | 20971.87 | 4583.0 |
| 2024-11-01 06:00:00 | NQ | Futures | 20972.39 | 20999.01 | 20965.09 | 20989.87 | 3928.0 |
| 2024-11-01 07:00:00 | NQ | Futures | 20989.35 | 21010.49 | 20969.78 | 20985.44 | 6557.0 |
| 2024-11-01 08:00:00 | NQ | Futures | 20987.27 | 21025.88 | 20953.35 | 20991.44 | 20224.0 |
| 2024-11-01 09:00:00 | NQ | Futures | 20991.44 | 21056.41 | 20933.0 | 21050.15 | 70788.0 |
| 2024-11-01 10:00:00 | NQ | Futures | 21051.97 | 21162.08 | 21011.01 | 21118.24 | 105257.0 |
| 2024-11-01 11:00:00 | NQ | Futures | 21118.77 | 21173.56 | 21090.33 | 21104.41 | 64556.0 |
| 2024-11-01 12:00:00 | NQ | Futures | 21104.94 | 21137.81 | 21072.58 | 21092.93 | 41348.0 |
| 2024-11-01 13:00:00 | NQ | Futures | 21093.2 | 21136.77 | 21035.01 | 21037.1 | 57846.0 |
| 2024-11-01 14:00:00 | NQ | Futures | 21037.62 | 21060.58 | 21006.31 | 21046.49 | 38208.0 |
| 2024-11-01 15:00:00 | NQ | Futures | 21046.49 | 21084.06 | 21001.09 | 21026.4 | 60949.0 |
| 2024-11-01 16:00:00 | NQ | Futures | 21025.88 | 21065.54 | 21024.84 | 21050.67 | 13569.0 |
| 2024-11-01 00:00:00 | YM | Futures | 43698.1 | 43708.5 | 43687.7 | 43699.1 | 516.0 |
| 2024-11-01 01:00:00 | YM | Futures | 43701.2 | 43726.2 | 43696.0 | 43718.9 | 763.0 |
| 2024-11-01 02:00:00 | YM | Futures | 43718.9 | 43721.0 | 43675.2 | 43684.5 | 681.0 |
| 2024-11-01 03:00:00 | YM | Futures | 43685.6 | 43708.5 | 43647.1 | 43693.9 | 1354.0 |
| 2024-11-01 04:00:00 | YM | Futures | 43694.9 | 43749.1 | 43677.3 | 43726.2 | 2195.0 |
| 2024-11-01 05:00:00 | YM | Futures | 43726.2 | 43764.7 | 43726.2 | 43759.5 | 1261.0 |
| 2024-11-01 06:00:00 | YM | Futures | 43761.6 | 43810.5 | 43759.5 | 43805.3 | 1668.0 |
| 2024-11-01 07:00:00 | YM | Futures | 43803.2 | 43850.0 | 43796.9 | 43840.6 | 2220.0 |
| 2024-11-01 08:00:00 | YM | Futures | 43842.7 | 43897.9 | 43766.8 | 43883.3 | 5952.0 |
| 2024-11-01 09:00:00 | YM | Futures | 43885.4 | 43998.8 | 43804.2 | 43948.9 | 17998.0 |
| 2024-11-01 10:00:00 | YM | Futures | 43954.1 | 44184.1 | 43911.4 | 44117.5 | 22129.0 |
| 2024-11-01 11:00:00 | YM | Futures | 44119.6 | 44226.8 | 44080.0 | 44090.4 | 11948.0 |
| 2024-11-01 12:00:00 | YM | Futures | 44090.4 | 44159.1 | 44004.0 | 44024.9 | 7692.0 |
| 2024-11-01 13:00:00 | YM | Futures | 44026.9 | 44104.0 | 43915.6 | 43925.0 | 10321.0 |
| 2024-11-01 14:00:00 | YM | Futures | 43923.9 | 44031.1 | 43889.6 | 44004.0 | 7214.0 |
| 2024-11-01 15:00:00 | YM | Futures | 44004.0 | 44046.7 | 43874.0 | 43915.6 | 12878.0 |
> showing 50 of 1,702 rows — these rows as CSV