PREVIEW / futures_1hour / 2025-05-27
file: by_date/futures_1hour/2025/2025-05-27.parquet size: 67 KB rows: 2,082
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-05-27 00:00:00 | ES | Futures | 5959.53 | 5964.61 | 5958.51 | 5963.84 | 2362.0 |
| 2025-05-27 01:00:00 | ES | Futures | 5964.1 | 5972.48 | 5961.05 | 5970.45 | 5296.0 |
| 2025-05-27 02:00:00 | ES | Futures | 5970.45 | 5981.12 | 5970.2 | 5978.07 | 5786.0 |
| 2025-05-27 03:00:00 | ES | Futures | 5978.32 | 6008.05 | 5975.78 | 6001.95 | 19913.0 |
| 2025-05-27 04:00:00 | ES | Futures | 6001.7 | 6003.98 | 5992.8 | 5996.36 | 11723.0 |
| 2025-05-27 05:00:00 | ES | Futures | 5996.36 | 6005.51 | 5995.09 | 6000.68 | 11652.0 |
| 2025-05-27 06:00:00 | ES | Futures | 6000.68 | 6005.0 | 5995.09 | 5995.35 | 9184.0 |
| 2025-05-27 07:00:00 | ES | Futures | 5995.35 | 6000.17 | 5989.76 | 5996.11 | 14989.0 |
| 2025-05-27 08:00:00 | ES | Futures | 5995.85 | 5997.89 | 5981.12 | 5986.96 | 24996.0 |
| 2025-05-27 09:00:00 | ES | Futures | 5986.96 | 5995.6 | 5963.08 | 5981.37 | 137813.0 |
| 2025-05-27 10:00:00 | ES | Futures | 5981.37 | 6006.78 | 5980.61 | 6001.19 | 171264.0 |
| 2025-05-27 11:00:00 | ES | Futures | 6000.93 | 6012.11 | 6000.17 | 6010.59 | 108592.0 |
| 2025-05-27 12:00:00 | ES | Futures | 6010.59 | 6028.12 | 6009.83 | 6020.5 | 115043.0 |
| 2025-05-27 13:00:00 | ES | Futures | 6020.5 | 6032.18 | 6019.99 | 6031.67 | 75466.0 |
| 2025-05-27 14:00:00 | ES | Futures | 6031.67 | 6034.72 | 6024.81 | 6025.07 | 77742.0 |
| 2025-05-27 15:00:00 | ES | Futures | 6025.07 | 6032.18 | 6019.48 | 6031.93 | 203113.0 |
| 2025-05-27 16:00:00 | ES | Futures | 6032.18 | 6037.77 | 6028.12 | 6036.25 | 58512.0 |
| 2025-05-27 18:00:00 | ES | Futures | 6036.75 | 6037.52 | 6031.16 | 6034.98 | 5126.0 |
| 2025-05-27 19:00:00 | ES | Futures | 6034.98 | 6037.77 | 6033.2 | 6033.45 | 4452.0 |
| 2025-05-27 20:00:00 | ES | Futures | 6033.2 | 6033.45 | 6030.4 | 6031.67 | 4976.0 |
| 2025-05-27 21:00:00 | ES | Futures | 6031.93 | 6034.72 | 6029.39 | 6029.89 | 4523.0 |
| 2025-05-27 22:00:00 | ES | Futures | 6029.89 | 6032.18 | 6028.88 | 6029.39 | 2980.0 |
| 2025-05-27 23:00:00 | ES | Futures | 6029.39 | 6032.18 | 6025.07 | 6025.58 | 3967.0 |
| 2025-05-27 00:00:00 | NQ | Futures | 21545.66 | 21571.13 | 21538.53 | 21570.11 | 2747.0 |
| 2025-05-27 01:00:00 | NQ | Futures | 21569.85 | 21612.38 | 21553.3 | 21602.7 | 4971.0 |
| 2025-05-27 02:00:00 | NQ | Futures | 21602.45 | 21650.58 | 21599.39 | 21638.1 | 4797.0 |
| 2025-05-27 03:00:00 | NQ | Futures | 21638.36 | 21757.28 | 21630.72 | 21730.8 | 12992.0 |
| 2025-05-27 04:00:00 | NQ | Futures | 21728.76 | 21744.04 | 21694.89 | 21709.91 | 7759.0 |
| 2025-05-27 05:00:00 | NQ | Futures | 21710.17 | 21750.4 | 21706.6 | 21729.52 | 6921.0 |
| 2025-05-27 06:00:00 | NQ | Futures | 21730.03 | 21748.62 | 21697.18 | 21699.47 | 5575.0 |
| 2025-05-27 07:00:00 | NQ | Futures | 21698.71 | 21707.11 | 21668.15 | 21692.85 | 7693.0 |
| 2025-05-27 08:00:00 | NQ | Futures | 21691.83 | 21701.51 | 21649.31 | 21671.72 | 11712.0 |
| 2025-05-27 09:00:00 | NQ | Futures | 21672.73 | 21711.95 | 21587.17 | 21690.05 | 59464.0 |
| 2025-05-27 10:00:00 | NQ | Futures | 21689.03 | 21787.58 | 21688.52 | 21752.7 | 61226.0 |
| 2025-05-27 11:00:00 | NQ | Futures | 21752.95 | 21804.9 | 21750.4 | 21797.77 | 39147.0 |
| 2025-05-27 12:00:00 | NQ | Futures | 21798.28 | 21858.63 | 21793.69 | 21829.09 | 39112.0 |
| 2025-05-27 13:00:00 | NQ | Futures | 21829.35 | 21880.02 | 21828.84 | 21876.46 | 31709.0 |
| 2025-05-27 14:00:00 | NQ | Futures | 21876.2 | 21888.43 | 21839.79 | 21841.82 | 32419.0 |
| 2025-05-27 15:00:00 | NQ | Futures | 21841.57 | 21869.07 | 21812.79 | 21866.02 | 61247.0 |
| 2025-05-27 16:00:00 | NQ | Futures | 21865.25 | 21879.26 | 21842.59 | 21876.71 | 17518.0 |
| 2025-05-27 18:00:00 | NQ | Futures | 21879.77 | 21879.77 | 21852.77 | 21870.35 | 4123.0 |
| 2025-05-27 19:00:00 | NQ | Futures | 21869.84 | 21884.61 | 21866.53 | 21870.35 | 3669.0 |
| 2025-05-27 20:00:00 | NQ | Futures | 21869.84 | 21872.38 | 21856.08 | 21869.33 | 3220.0 |
| 2025-05-27 21:00:00 | NQ | Futures | 21869.58 | 21883.84 | 21859.65 | 21862.45 | 3138.0 |
| 2025-05-27 22:00:00 | NQ | Futures | 21862.71 | 21874.67 | 21860.41 | 21865.0 | 1883.0 |
| 2025-05-27 23:00:00 | NQ | Futures | 21865.0 | 21876.97 | 21837.49 | 21843.86 | 3080.0 |
| 2025-05-27 00:00:00 | YM | Futures | 43220.9 | 43255.9 | 43218.9 | 43250.8 | 286.0 |
| 2025-05-27 01:00:00 | YM | Futures | 43245.6 | 43287.8 | 43231.2 | 43272.4 | 502.0 |
| 2025-05-27 02:00:00 | YM | Futures | 43271.3 | 43344.4 | 43270.3 | 43320.7 | 891.0 |
| 2025-05-27 03:00:00 | YM | Futures | 43322.8 | 43513.2 | 43308.4 | 43468.9 | 2688.0 |
> showing 50 of 2,082 rows — these rows as CSV