PREVIEW / futures_1hour / 2025-11-04
file: by_date/futures_1hour/2025/2025-11-04.parquet size: 69 KB rows: 2,158
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-04 00:00:00 | ES | Futures | 6900.86 | 6901.62 | 6877.69 | 6881.22 | 18053.0 |
| 2025-11-04 01:00:00 | ES | Futures | 6881.22 | 6881.72 | 6865.85 | 6871.65 | 25550.0 |
| 2025-11-04 02:00:00 | ES | Futures | 6871.65 | 6875.68 | 6862.83 | 6872.65 | 19458.0 |
| 2025-11-04 03:00:00 | ES | Futures | 6872.9 | 6872.9 | 6857.54 | 6865.35 | 25038.0 |
| 2025-11-04 04:00:00 | ES | Futures | 6865.6 | 6869.88 | 6842.43 | 6843.69 | 29695.0 |
| 2025-11-04 05:00:00 | ES | Futures | 6843.69 | 6866.36 | 6837.14 | 6864.59 | 29398.0 |
| 2025-11-04 06:00:00 | ES | Futures | 6864.59 | 6868.87 | 6861.82 | 6863.84 | 19716.0 |
| 2025-11-04 07:00:00 | ES | Futures | 6864.09 | 6871.65 | 6856.03 | 6865.6 | 26866.0 |
| 2025-11-04 08:00:00 | ES | Futures | 6865.35 | 6867.62 | 6853.26 | 6860.06 | 35196.0 |
| 2025-11-04 09:00:00 | ES | Futures | 6859.81 | 6889.02 | 6846.71 | 6887.77 | 227157.0 |
| 2025-11-04 10:00:00 | ES | Futures | 6887.51 | 6900.61 | 6876.93 | 6882.48 | 212755.0 |
| 2025-11-04 11:00:00 | ES | Futures | 6882.48 | 6889.28 | 6875.17 | 6882.73 | 167269.0 |
| 2025-11-04 12:00:00 | ES | Futures | 6882.98 | 6882.98 | 6857.04 | 6860.31 | 177238.0 |
| 2025-11-04 13:00:00 | ES | Futures | 6860.31 | 6864.34 | 6847.21 | 6861.57 | 140093.0 |
| 2025-11-04 14:00:00 | ES | Futures | 6861.32 | 6867.11 | 6845.7 | 6852.25 | 130417.0 |
| 2025-11-04 15:00:00 | ES | Futures | 6852.25 | 6866.1 | 6846.71 | 6854.52 | 221376.0 |
| 2025-11-04 16:00:00 | ES | Futures | 6854.52 | 6859.05 | 6847.72 | 6857.29 | 59774.0 |
| 2025-11-04 18:00:00 | ES | Futures | 6852.0 | 6857.54 | 6843.94 | 6844.19 | 10880.0 |
| 2025-11-04 19:00:00 | ES | Futures | 6844.44 | 6844.44 | 6823.79 | 6824.04 | 22686.0 |
| 2025-11-04 20:00:00 | ES | Futures | 6824.29 | 6824.29 | 6799.11 | 6810.69 | 39722.0 |
| 2025-11-04 21:00:00 | ES | Futures | 6810.69 | 6827.82 | 6803.39 | 6826.06 | 21201.0 |
| 2025-11-04 22:00:00 | ES | Futures | 6826.31 | 6846.21 | 6826.06 | 6845.95 | 19174.0 |
| 2025-11-04 23:00:00 | ES | Futures | 6846.21 | 6846.71 | 6833.61 | 6837.64 | 9660.0 |
| 2025-11-04 00:00:00 | NQ | Futures | 26151.36 | 26153.63 | 26032.58 | 26047.2 | 11066.0 |
| 2025-11-04 01:00:00 | NQ | Futures | 26047.71 | 26051.24 | 25967.01 | 26001.31 | 15112.0 |
| 2025-11-04 02:00:00 | NQ | Futures | 26000.55 | 26027.03 | 25960.45 | 26017.7 | 10916.0 |
| 2025-11-04 03:00:00 | NQ | Futures | 26017.19 | 26017.19 | 25954.65 | 25990.21 | 10910.0 |
| 2025-11-04 04:00:00 | NQ | Futures | 25991.47 | 26014.92 | 25892.61 | 25899.17 | 13924.0 |
| 2025-11-04 05:00:00 | NQ | Futures | 25899.42 | 25998.03 | 25869.16 | 25983.4 | 11636.0 |
| 2025-11-04 06:00:00 | NQ | Futures | 25983.9 | 26017.95 | 25972.3 | 25991.97 | 7279.0 |
| 2025-11-04 07:00:00 | NQ | Futures | 25992.73 | 26016.18 | 25949.86 | 25979.62 | 11638.0 |
| 2025-11-04 08:00:00 | NQ | Futures | 25979.37 | 25991.22 | 25909.01 | 25941.03 | 19644.0 |
| 2025-11-04 09:00:00 | NQ | Futures | 25940.53 | 26106.97 | 25887.32 | 26101.42 | 98761.0 |
| 2025-11-04 10:00:00 | NQ | Futures | 26100.92 | 26119.83 | 25988.95 | 26014.92 | 84067.0 |
| 2025-11-04 11:00:00 | NQ | Futures | 26014.42 | 26048.46 | 25948.09 | 25981.38 | 64854.0 |
| 2025-11-04 12:00:00 | NQ | Futures | 25981.38 | 25982.9 | 25866.39 | 25903.71 | 64090.0 |
| 2025-11-04 13:00:00 | NQ | Futures | 25901.69 | 25909.01 | 25825.53 | 25893.62 | 58160.0 |
| 2025-11-04 14:00:00 | NQ | Futures | 25892.36 | 25912.79 | 25797.79 | 25829.06 | 50553.0 |
| 2025-11-04 15:00:00 | NQ | Futures | 25829.57 | 25866.64 | 25767.28 | 25802.58 | 70766.0 |
| 2025-11-04 16:00:00 | NQ | Futures | 25802.84 | 25816.71 | 25745.84 | 25800.57 | 22488.0 |
| 2025-11-04 18:00:00 | NQ | Futures | 25768.29 | 25797.79 | 25724.66 | 25727.18 | 7079.0 |
| 2025-11-04 19:00:00 | NQ | Futures | 25726.17 | 25726.17 | 25629.58 | 25632.36 | 14500.0 |
| 2025-11-04 20:00:00 | NQ | Futures | 25631.35 | 25633.12 | 25502.99 | 25559.23 | 24924.0 |
| 2025-11-04 21:00:00 | NQ | Futures | 25559.98 | 25645.98 | 25517.11 | 25637.4 | 15839.0 |
| 2025-11-04 22:00:00 | NQ | Futures | 25638.16 | 25743.07 | 25637.4 | 25739.29 | 14385.0 |
| 2025-11-04 23:00:00 | NQ | Futures | 25738.28 | 25740.04 | 25665.14 | 25687.84 | 7916.0 |
| 2025-11-04 00:00:00 | YM | Futures | 47974.6 | 47978.7 | 47877.2 | 47896.5 | 1978.0 |
| 2025-11-04 01:00:00 | YM | Futures | 47897.5 | 47914.8 | 47819.4 | 47847.8 | 3524.0 |
| 2025-11-04 02:00:00 | YM | Futures | 47845.8 | 47864.1 | 47791.0 | 47826.5 | 2797.0 |
| 2025-11-04 03:00:00 | YM | Futures | 47826.5 | 47826.5 | 47723.1 | 47793.1 | 3575.0 |
> showing 50 of 2,158 rows — these rows as CSV