PREVIEW / futures_1hour / 2025-07-22
file: by_date/futures_1hour/2025/2025-07-22.parquet size: 67 KB rows: 2,070
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-07-22 00:00:00 | ES | Futures | 6392.58 | 6392.83 | 6388.05 | 6389.05 | 4758.0 |
| 2025-07-22 01:00:00 | ES | Futures | 6389.05 | 6390.06 | 6386.79 | 6389.05 | 3985.0 |
| 2025-07-22 02:00:00 | ES | Futures | 6389.31 | 6390.31 | 6387.54 | 6389.31 | 3532.0 |
| 2025-07-22 03:00:00 | ES | Futures | 6389.05 | 6394.59 | 6384.27 | 6387.04 | 12212.0 |
| 2025-07-22 04:00:00 | ES | Futures | 6386.79 | 6391.57 | 6382.76 | 6384.77 | 13599.0 |
| 2025-07-22 05:00:00 | ES | Futures | 6384.77 | 6386.53 | 6383.26 | 6385.02 | 6909.0 |
| 2025-07-22 06:00:00 | ES | Futures | 6385.28 | 6388.55 | 6384.52 | 6387.79 | 7737.0 |
| 2025-07-22 07:00:00 | ES | Futures | 6387.54 | 6394.34 | 6385.28 | 6393.84 | 16386.0 |
| 2025-07-22 08:00:00 | ES | Futures | 6393.84 | 6396.86 | 6391.82 | 6395.6 | 14322.0 |
| 2025-07-22 09:00:00 | ES | Futures | 6395.6 | 6397.11 | 6366.13 | 6373.44 | 191621.0 |
| 2025-07-22 10:00:00 | ES | Futures | 6373.44 | 6385.28 | 6366.64 | 6384.27 | 190552.0 |
| 2025-07-22 11:00:00 | ES | Futures | 6384.27 | 6386.03 | 6377.72 | 6381.25 | 94511.0 |
| 2025-07-22 12:00:00 | ES | Futures | 6381.25 | 6386.03 | 6374.7 | 6383.51 | 88353.0 |
| 2025-07-22 13:00:00 | ES | Futures | 6383.51 | 6397.37 | 6382.5 | 6388.55 | 96178.0 |
| 2025-07-22 14:00:00 | ES | Futures | 6388.3 | 6400.39 | 6379.99 | 6398.37 | 105923.0 |
| 2025-07-22 15:00:00 | ES | Futures | 6398.37 | 6401.4 | 6392.08 | 6393.08 | 167864.0 |
| 2025-07-22 16:00:00 | ES | Futures | 6393.08 | 6395.1 | 6390.56 | 6394.85 | 50646.0 |
| 2025-07-22 18:00:00 | ES | Futures | 6394.09 | 6397.87 | 6390.31 | 6392.33 | 4106.0 |
| 2025-07-22 19:00:00 | ES | Futures | 6392.33 | 6411.97 | 6392.08 | 6409.71 | 15093.0 |
| 2025-07-22 20:00:00 | ES | Futures | 6409.71 | 6410.71 | 6397.37 | 6398.62 | 9931.0 |
| 2025-07-22 21:00:00 | ES | Futures | 6398.37 | 6408.7 | 6396.61 | 6408.7 | 6643.0 |
| 2025-07-22 22:00:00 | ES | Futures | 6408.45 | 6408.7 | 6404.17 | 6407.94 | 4359.0 |
| 2025-07-22 23:00:00 | ES | Futures | 6407.94 | 6410.71 | 6405.43 | 6406.68 | 4150.0 |
| 2025-07-22 00:00:00 | NQ | Futures | 23532.19 | 23533.2 | 23499.91 | 23509.24 | 4596.0 |
| 2025-07-22 01:00:00 | NQ | Futures | 23508.99 | 23519.33 | 23501.42 | 23517.56 | 2521.0 |
| 2025-07-22 02:00:00 | NQ | Futures | 23517.81 | 23522.6 | 23508.48 | 23517.06 | 2437.0 |
| 2025-07-22 03:00:00 | NQ | Futures | 23517.06 | 23550.85 | 23486.04 | 23507.73 | 9471.0 |
| 2025-07-22 04:00:00 | NQ | Futures | 23507.22 | 23519.58 | 23474.19 | 23479.48 | 8549.0 |
| 2025-07-22 05:00:00 | NQ | Futures | 23479.23 | 23489.57 | 23470.15 | 23484.27 | 4972.0 |
| 2025-07-22 06:00:00 | NQ | Futures | 23484.53 | 23504.7 | 23480.24 | 23502.93 | 6431.0 |
| 2025-07-22 07:00:00 | NQ | Futures | 23502.18 | 23535.47 | 23496.63 | 23534.71 | 9086.0 |
| 2025-07-22 08:00:00 | NQ | Futures | 23533.7 | 23544.54 | 23523.36 | 23537.99 | 7569.0 |
| 2025-07-22 09:00:00 | NQ | Futures | 23537.99 | 23553.12 | 23314.05 | 23343.81 | 104090.0 |
| 2025-07-22 10:00:00 | NQ | Futures | 23343.56 | 23432.32 | 23309.26 | 23426.27 | 100765.0 |
| 2025-07-22 11:00:00 | NQ | Futures | 23426.78 | 23439.64 | 23396.52 | 23408.62 | 54175.0 |
| 2025-07-22 12:00:00 | NQ | Futures | 23408.87 | 23426.78 | 23361.21 | 23400.8 | 47283.0 |
| 2025-07-22 13:00:00 | NQ | Futures | 23400.55 | 23453.26 | 23397.27 | 23419.72 | 38418.0 |
| 2025-07-22 14:00:00 | NQ | Futures | 23419.21 | 23456.03 | 23372.81 | 23454.26 | 42345.0 |
| 2025-07-22 15:00:00 | NQ | Futures | 23454.01 | 23460.32 | 23421.48 | 23424.26 | 50161.0 |
| 2025-07-22 16:00:00 | NQ | Futures | 23423.75 | 23426.02 | 23389.96 | 23401.05 | 20722.0 |
| 2025-07-22 18:00:00 | NQ | Futures | 23393.24 | 23407.11 | 23372.05 | 23383.91 | 3917.0 |
| 2025-07-22 19:00:00 | NQ | Futures | 23384.41 | 23470.66 | 23382.9 | 23464.35 | 9688.0 |
| 2025-07-22 20:00:00 | NQ | Futures | 23464.35 | 23469.65 | 23400.55 | 23406.6 | 7737.0 |
| 2025-07-22 21:00:00 | NQ | Futures | 23405.85 | 23456.28 | 23400.8 | 23454.52 | 6285.0 |
| 2025-07-22 22:00:00 | NQ | Futures | 23454.01 | 23454.52 | 23428.29 | 23447.96 | 3466.0 |
| 2025-07-22 23:00:00 | NQ | Futures | 23448.97 | 23457.54 | 23433.59 | 23440.65 | 2610.0 |
| 2025-07-22 00:00:00 | YM | Futures | 45545.8 | 45547.8 | 45522.3 | 45530.4 | 361.0 |
| 2025-07-22 01:00:00 | YM | Futures | 45528.4 | 45529.4 | 45501.8 | 45509.0 | 357.0 |
| 2025-07-22 02:00:00 | YM | Futures | 45511.0 | 45521.2 | 45498.8 | 45504.9 | 632.0 |
| 2025-07-22 03:00:00 | YM | Futures | 45504.9 | 45535.5 | 45479.4 | 45491.6 | 1152.0 |
> showing 50 of 2,070 rows — these rows as CSV