PREVIEW / futures_1hour / 2025-11-06
file: by_date/futures_1hour/2025/2025-11-06.parquet size: 67 KB rows: 2,132
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-11-06 00:00:00 | ES | Futures | 6877.69 | 6878.45 | 6867.62 | 6869.13 | 5204.0 |
| 2025-11-06 01:00:00 | ES | Futures | 6868.87 | 6872.4 | 6864.59 | 6866.36 | 6474.0 |
| 2025-11-06 02:00:00 | ES | Futures | 6866.36 | 6872.9 | 6858.8 | 6859.56 | 8404.0 |
| 2025-11-06 03:00:00 | ES | Futures | 6859.56 | 6865.85 | 6855.02 | 6863.84 | 14287.0 |
| 2025-11-06 04:00:00 | ES | Futures | 6863.84 | 6878.7 | 6863.33 | 6874.92 | 11856.0 |
| 2025-11-06 05:00:00 | ES | Futures | 6875.17 | 6884.49 | 6873.91 | 6880.21 | 7680.0 |
| 2025-11-06 06:00:00 | ES | Futures | 6880.21 | 6885.25 | 6878.19 | 6879.71 | 8171.0 |
| 2025-11-06 07:00:00 | ES | Futures | 6879.45 | 6889.53 | 6879.2 | 6887.51 | 12500.0 |
| 2025-11-06 08:00:00 | ES | Futures | 6887.26 | 6894.82 | 6882.22 | 6883.23 | 18294.0 |
| 2025-11-06 09:00:00 | ES | Futures | 6882.98 | 6885.5 | 6838.9 | 6839.41 | 226857.0 |
| 2025-11-06 10:00:00 | ES | Futures | 6839.41 | 6851.75 | 6804.9 | 6806.91 | 360273.0 |
| 2025-11-06 11:00:00 | ES | Futures | 6806.66 | 6817.49 | 6787.27 | 6789.28 | 254458.0 |
| 2025-11-06 12:00:00 | ES | Futures | 6789.28 | 6813.21 | 6783.99 | 6808.42 | 187227.0 |
| 2025-11-06 13:00:00 | ES | Futures | 6808.42 | 6819.76 | 6788.53 | 6812.71 | 149594.0 |
| 2025-11-06 14:00:00 | ES | Futures | 6812.96 | 6835.38 | 6810.19 | 6827.82 | 149331.0 |
| 2025-11-06 15:00:00 | ES | Futures | 6827.57 | 6831.6 | 6793.06 | 6800.62 | 237602.0 |
| 2025-11-06 16:00:00 | ES | Futures | 6800.87 | 6818.25 | 6799.36 | 6815.48 | 56912.0 |
| 2025-11-06 18:00:00 | ES | Futures | 6813.71 | 6820.01 | 6806.66 | 6815.73 | 9684.0 |
| 2025-11-06 19:00:00 | ES | Futures | 6815.73 | 6822.78 | 6808.17 | 6817.24 | 12735.0 |
| 2025-11-06 20:00:00 | ES | Futures | 6817.24 | 6818.0 | 6793.06 | 6805.65 | 20521.0 |
| 2025-11-06 21:00:00 | ES | Futures | 6805.91 | 6806.41 | 6793.31 | 6804.14 | 13083.0 |
| 2025-11-06 22:00:00 | ES | Futures | 6804.14 | 6805.91 | 6789.79 | 6795.08 | 11404.0 |
| 2025-11-06 23:00:00 | ES | Futures | 6795.08 | 6802.13 | 6782.48 | 6800.11 | 10581.0 |
| 2025-11-06 00:00:00 | NQ | Futures | 25963.48 | 25967.51 | 25912.54 | 25917.58 | 3410.0 |
| 2025-11-06 01:00:00 | NQ | Futures | 25916.82 | 25937.25 | 25896.9 | 25907.24 | 4006.0 |
| 2025-11-06 02:00:00 | NQ | Futures | 25906.74 | 25940.78 | 25867.14 | 25870.67 | 6838.0 |
| 2025-11-06 03:00:00 | NQ | Futures | 25869.16 | 25908.5 | 25853.53 | 25896.65 | 7889.0 |
| 2025-11-06 04:00:00 | NQ | Futures | 25896.9 | 25972.05 | 25895.39 | 25952.13 | 7519.0 |
| 2025-11-06 05:00:00 | NQ | Futures | 25953.14 | 26003.58 | 25950.62 | 25977.1 | 5054.0 |
| 2025-11-06 06:00:00 | NQ | Futures | 25977.6 | 26001.31 | 25967.51 | 25972.56 | 4708.0 |
| 2025-11-06 07:00:00 | NQ | Futures | 25972.3 | 26016.44 | 25971.3 | 26004.84 | 7185.0 |
| 2025-11-06 08:00:00 | NQ | Futures | 26003.83 | 26047.96 | 25986.43 | 25991.22 | 11942.0 |
| 2025-11-06 09:00:00 | NQ | Futures | 25991.97 | 25999.54 | 25732.98 | 25736.01 | 103642.0 |
| 2025-11-06 10:00:00 | NQ | Futures | 25736.26 | 25770.3 | 25511.81 | 25524.17 | 154940.0 |
| 2025-11-06 11:00:00 | NQ | Futures | 25523.92 | 25592.01 | 25421.53 | 25440.95 | 94307.0 |
| 2025-11-06 12:00:00 | NQ | Futures | 25440.7 | 25577.89 | 25418.0 | 25558.72 | 74180.0 |
| 2025-11-06 13:00:00 | NQ | Futures | 25558.72 | 25593.02 | 25445.99 | 25551.66 | 61245.0 |
| 2025-11-06 14:00:00 | NQ | Futures | 25552.67 | 25660.86 | 25542.33 | 25626.31 | 61249.0 |
| 2025-11-06 15:00:00 | NQ | Futures | 25625.8 | 25636.9 | 25447.0 | 25478.53 | 77032.0 |
| 2025-11-06 16:00:00 | NQ | Futures | 25478.78 | 25540.31 | 25462.39 | 25532.75 | 21241.0 |
| 2025-11-06 18:00:00 | NQ | Futures | 25536.02 | 25557.21 | 25492.9 | 25538.04 | 5672.0 |
| 2025-11-06 19:00:00 | NQ | Futures | 25538.29 | 25571.33 | 25500.21 | 25543.34 | 8800.0 |
| 2025-11-06 20:00:00 | NQ | Futures | 25545.35 | 25554.18 | 25421.28 | 25492.4 | 13493.0 |
| 2025-11-06 21:00:00 | NQ | Futures | 25493.66 | 25495.93 | 25427.58 | 25488.36 | 7365.0 |
| 2025-11-06 22:00:00 | NQ | Futures | 25490.13 | 25502.48 | 25423.3 | 25443.47 | 6383.0 |
| 2025-11-06 23:00:00 | NQ | Futures | 25442.97 | 25485.84 | 25381.94 | 25470.96 | 7688.0 |
| 2025-11-06 00:00:00 | YM | Futures | 48100.4 | 48105.4 | 48054.7 | 48060.8 | 515.0 |
| 2025-11-06 01:00:00 | YM | Futures | 48058.8 | 48081.1 | 48045.6 | 48051.7 | 722.0 |
| 2025-11-06 02:00:00 | YM | Futures | 48051.7 | 48079.1 | 48010.1 | 48019.2 | 1175.0 |
| 2025-11-06 03:00:00 | YM | Futures | 48019.2 | 48037.5 | 47975.6 | 48031.4 | 1460.0 |
> showing 50 of 2,132 rows — these rows as CSV