PREVIEW / futures_1hour / 2025-10-27
file: by_date/futures_1hour/2025/2025-10-27.parquet size: 66 KB rows: 2,121
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-10-27 00:00:00 | ES | Futures | 6929.83 | 6932.1 | 6928.57 | 6930.84 | 3985.0 |
| 2025-10-27 01:00:00 | ES | Futures | 6930.58 | 6935.37 | 6930.58 | 6934.36 | 5048.0 |
| 2025-10-27 02:00:00 | ES | Futures | 6934.61 | 6939.9 | 6933.86 | 6936.12 | 8907.0 |
| 2025-10-27 03:00:00 | ES | Futures | 6936.12 | 6940.66 | 6934.36 | 6934.36 | 11669.0 |
| 2025-10-27 04:00:00 | ES | Futures | 6934.61 | 6935.87 | 6928.07 | 6932.6 | 16118.0 |
| 2025-10-27 05:00:00 | ES | Futures | 6932.85 | 6938.64 | 6930.33 | 6938.64 | 11334.0 |
| 2025-10-27 06:00:00 | ES | Futures | 6938.64 | 6940.15 | 6935.62 | 6938.14 | 10753.0 |
| 2025-10-27 07:00:00 | ES | Futures | 6938.14 | 6940.66 | 6930.33 | 6931.84 | 19506.0 |
| 2025-10-27 08:00:00 | ES | Futures | 6931.59 | 6936.88 | 6930.84 | 6934.61 | 17328.0 |
| 2025-10-27 09:00:00 | ES | Futures | 6934.36 | 6940.66 | 6928.57 | 6938.39 | 135808.0 |
| 2025-10-27 10:00:00 | ES | Futures | 6938.39 | 6944.18 | 6931.34 | 6934.61 | 186446.0 |
| 2025-10-27 11:00:00 | ES | Futures | 6934.61 | 6943.93 | 6932.85 | 6941.92 | 108932.0 |
| 2025-10-27 12:00:00 | ES | Futures | 6941.92 | 6946.7 | 6941.41 | 6945.44 | 71317.0 |
| 2025-10-27 13:00:00 | ES | Futures | 6945.44 | 6947.71 | 6939.4 | 6947.21 | 75890.0 |
| 2025-10-27 14:00:00 | ES | Futures | 6947.46 | 6950.48 | 6945.44 | 6949.22 | 80875.0 |
| 2025-10-27 15:00:00 | ES | Futures | 6949.22 | 6963.58 | 6947.96 | 6959.3 | 233758.0 |
| 2025-10-27 16:00:00 | ES | Futures | 6959.3 | 6968.11 | 6958.79 | 6965.85 | 67806.0 |
| 2025-10-27 18:00:00 | ES | Futures | 6965.85 | 6965.85 | 6962.07 | 6963.58 | 4978.0 |
| 2025-10-27 19:00:00 | ES | Futures | 6963.33 | 6969.62 | 6962.57 | 6962.82 | 6377.0 |
| 2025-10-27 20:00:00 | ES | Futures | 6962.57 | 6963.83 | 6960.3 | 6960.81 | 6628.0 |
| 2025-10-27 21:00:00 | ES | Futures | 6960.81 | 6962.07 | 6957.79 | 6959.05 | 6830.0 |
| 2025-10-27 22:00:00 | ES | Futures | 6959.05 | 6961.06 | 6957.03 | 6959.55 | 4577.0 |
| 2025-10-27 23:00:00 | ES | Futures | 6959.55 | 6961.82 | 6957.79 | 6960.05 | 3950.0 |
| 2025-10-27 00:00:00 | NQ | Futures | 25985.92 | 25993.99 | 25978.1 | 25987.18 | 2998.0 |
| 2025-10-27 01:00:00 | NQ | Futures | 25989.2 | 26015.18 | 25986.43 | 26007.86 | 3753.0 |
| 2025-10-27 02:00:00 | NQ | Futures | 26008.37 | 26027.53 | 26005.34 | 26009.12 | 4019.0 |
| 2025-10-27 03:00:00 | NQ | Futures | 26007.86 | 26042.16 | 26004.58 | 26017.95 | 6000.0 |
| 2025-10-27 04:00:00 | NQ | Futures | 26018.45 | 26032.83 | 25993.74 | 26028.04 | 6822.0 |
| 2025-10-27 05:00:00 | NQ | Futures | 26028.79 | 26065.36 | 26015.43 | 26065.36 | 6398.0 |
| 2025-10-27 06:00:00 | NQ | Futures | 26065.36 | 26078.47 | 26055.02 | 26064.35 | 5532.0 |
| 2025-10-27 07:00:00 | NQ | Futures | 26063.85 | 26074.44 | 26036.61 | 26045.44 | 7241.0 |
| 2025-10-27 08:00:00 | NQ | Futures | 26045.19 | 26071.67 | 26042.92 | 26056.79 | 8166.0 |
| 2025-10-27 09:00:00 | NQ | Futures | 26056.53 | 26085.54 | 26021.98 | 26074.69 | 61581.0 |
| 2025-10-27 10:00:00 | NQ | Futures | 26074.94 | 26118.32 | 26048.72 | 26083.52 | 68956.0 |
| 2025-10-27 11:00:00 | NQ | Futures | 26083.77 | 26136.48 | 26081.5 | 26119.33 | 42753.0 |
| 2025-10-27 12:00:00 | NQ | Futures | 26119.33 | 26144.55 | 26115.29 | 26140.26 | 26555.0 |
| 2025-10-27 13:00:00 | NQ | Futures | 26140.01 | 26155.64 | 26117.31 | 26153.12 | 27735.0 |
| 2025-10-27 14:00:00 | NQ | Futures | 26153.37 | 26173.04 | 26146.06 | 26168.25 | 27105.0 |
| 2025-10-27 15:00:00 | NQ | Futures | 26168.5 | 26208.35 | 26147.07 | 26187.67 | 62982.0 |
| 2025-10-27 16:00:00 | NQ | Futures | 26187.92 | 26240.88 | 26186.91 | 26231.05 | 20886.0 |
| 2025-10-27 18:00:00 | NQ | Futures | 26229.79 | 26230.04 | 26213.14 | 26223.23 | 2809.0 |
| 2025-10-27 19:00:00 | NQ | Futures | 26223.73 | 26246.18 | 26220.71 | 26222.22 | 3727.0 |
| 2025-10-27 20:00:00 | NQ | Futures | 26221.21 | 26222.72 | 26201.04 | 26202.55 | 4246.0 |
| 2025-10-27 21:00:00 | NQ | Futures | 26202.3 | 26208.6 | 26188.43 | 26196.5 | 4252.0 |
| 2025-10-27 22:00:00 | NQ | Futures | 26195.74 | 26208.35 | 26190.44 | 26204.06 | 2457.0 |
| 2025-10-27 23:00:00 | NQ | Futures | 26204.57 | 26216.17 | 26194.23 | 26209.61 | 2017.0 |
| 2025-10-27 00:00:00 | YM | Futures | 48333.6 | 48356.9 | 48330.6 | 48349.8 | 430.0 |
| 2025-10-27 01:00:00 | YM | Futures | 48348.8 | 48371.1 | 48346.8 | 48364.0 | 391.0 |
| 2025-10-27 02:00:00 | YM | Futures | 48365.0 | 48407.6 | 48361.0 | 48388.4 | 901.0 |
| 2025-10-27 03:00:00 | YM | Futures | 48386.3 | 48409.7 | 48374.2 | 48375.2 | 1638.0 |
> showing 50 of 2,121 rows — these rows as CSV