PREVIEW / futures_1hour / 2025-10-31
file: by_date/futures_1hour/2025/2025-10-31.parquet size: 55 KB rows: 1,678
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-31 00:00:00 | ES | Futures | 6951.74 | 6954.76 | 6951.49 | 6952.75 | 4116.0 |
| 2025-10-31 01:00:00 | ES | Futures | 6952.5 | 6953.0 | 6945.7 | 6946.96 | 5166.0 |
| 2025-10-31 02:00:00 | ES | Futures | 6946.7 | 6954.26 | 6945.95 | 6947.46 | 8221.0 |
| 2025-10-31 03:00:00 | ES | Futures | 6947.71 | 6958.04 | 6944.69 | 6957.53 | 7600.0 |
| 2025-10-31 04:00:00 | ES | Futures | 6957.79 | 6957.79 | 6947.96 | 6955.02 | 12275.0 |
| 2025-10-31 05:00:00 | ES | Futures | 6955.27 | 6957.79 | 6950.48 | 6951.49 | 8127.0 |
| 2025-10-31 06:00:00 | ES | Futures | 6951.74 | 6952.5 | 6944.94 | 6949.73 | 8652.0 |
| 2025-10-31 07:00:00 | ES | Futures | 6949.73 | 6963.33 | 6946.45 | 6959.55 | 18936.0 |
| 2025-10-31 08:00:00 | ES | Futures | 6959.3 | 6970.38 | 6953.5 | 6957.53 | 45227.0 |
| 2025-10-31 09:00:00 | ES | Futures | 6957.53 | 6958.04 | 6931.59 | 6937.89 | 182376.0 |
| 2025-10-31 10:00:00 | ES | Futures | 6937.89 | 6951.24 | 6925.29 | 6948.21 | 198760.0 |
| 2025-10-31 11:00:00 | ES | Futures | 6948.21 | 6951.24 | 6924.04 | 6925.04 | 208987.0 |
| 2025-10-31 12:00:00 | ES | Futures | 6925.29 | 6927.81 | 6903.89 | 6906.4 | 199815.0 |
| 2025-10-31 13:00:00 | ES | Futures | 6906.4 | 6917.99 | 6894.82 | 6911.95 | 181431.0 |
| 2025-10-31 14:00:00 | ES | Futures | 6911.69 | 6930.84 | 6910.94 | 6929.58 | 133624.0 |
| 2025-10-31 15:00:00 | ES | Futures | 6929.58 | 6951.74 | 6923.28 | 6923.53 | 332989.0 |
| 2025-10-31 16:00:00 | ES | Futures | 6923.78 | 6926.3 | 6918.24 | 6923.78 | 80391.0 |
| 2025-10-31 00:00:00 | NQ | Futures | 26421.45 | 26439.1 | 26415.65 | 26421.19 | 2200.0 |
| 2025-10-31 01:00:00 | NQ | Futures | 26420.94 | 26423.21 | 26388.91 | 26393.96 | 2778.0 |
| 2025-10-31 02:00:00 | NQ | Futures | 26392.95 | 26421.19 | 26383.37 | 26389.42 | 3536.0 |
| 2025-10-31 03:00:00 | NQ | Futures | 26389.67 | 26448.93 | 26372.52 | 26446.66 | 5386.0 |
| 2025-10-31 04:00:00 | NQ | Futures | 26446.16 | 26447.17 | 26386.14 | 26426.24 | 6925.0 |
| 2025-10-31 05:00:00 | NQ | Futures | 26428.26 | 26439.86 | 26406.32 | 26410.85 | 3646.0 |
| 2025-10-31 06:00:00 | NQ | Futures | 26411.11 | 26424.47 | 26390.43 | 26409.85 | 3782.0 |
| 2025-10-31 07:00:00 | NQ | Futures | 26410.6 | 26461.54 | 26395.47 | 26449.94 | 6481.0 |
| 2025-10-31 08:00:00 | NQ | Futures | 26449.69 | 26503.66 | 26433.3 | 26440.36 | 16715.0 |
| 2025-10-31 09:00:00 | NQ | Futures | 26440.11 | 26446.16 | 26308.22 | 26330.41 | 80601.0 |
| 2025-10-31 10:00:00 | NQ | Futures | 26331.67 | 26410.85 | 26287.79 | 26393.2 | 76417.0 |
| 2025-10-31 11:00:00 | NQ | Futures | 26392.7 | 26411.61 | 26277.7 | 26279.97 | 67644.0 |
| 2025-10-31 12:00:00 | NQ | Futures | 26279.97 | 26281.23 | 26156.4 | 26176.32 | 70317.0 |
| 2025-10-31 13:00:00 | NQ | Futures | 26176.07 | 26207.85 | 26115.04 | 26174.56 | 68850.0 |
| 2025-10-31 14:00:00 | NQ | Futures | 26174.81 | 26249.96 | 26171.28 | 26241.39 | 45632.0 |
| 2025-10-31 15:00:00 | NQ | Futures | 26241.89 | 26346.55 | 26219.19 | 26219.95 | 78070.0 |
| 2025-10-31 16:00:00 | NQ | Futures | 26220.45 | 26225.75 | 26193.98 | 26210.12 | 20819.0 |
| 2025-10-31 00:00:00 | YM | Futures | 48377.2 | 48403.6 | 48375.2 | 48384.3 | 479.0 |
| 2025-10-31 01:00:00 | YM | Futures | 48382.3 | 48383.3 | 48342.7 | 48348.8 | 470.0 |
| 2025-10-31 02:00:00 | YM | Futures | 48348.8 | 48389.4 | 48347.8 | 48354.9 | 763.0 |
| 2025-10-31 03:00:00 | YM | Futures | 48356.9 | 48412.7 | 48348.8 | 48407.6 | 1032.0 |
| 2025-10-31 04:00:00 | YM | Futures | 48406.6 | 48408.6 | 48358.9 | 48405.6 | 1639.0 |
| 2025-10-31 05:00:00 | YM | Futures | 48404.6 | 48415.7 | 48348.8 | 48350.8 | 1032.0 |
| 2025-10-31 06:00:00 | YM | Futures | 48350.8 | 48351.9 | 48294.0 | 48327.5 | 1481.0 |
| 2025-10-31 07:00:00 | YM | Futures | 48330.6 | 48433.0 | 48323.5 | 48417.8 | 2211.0 |
| 2025-10-31 08:00:00 | YM | Futures | 48416.8 | 48482.7 | 48381.3 | 48419.8 | 3166.0 |
| 2025-10-31 09:00:00 | YM | Futures | 48417.8 | 48456.3 | 48293.0 | 48410.7 | 14004.0 |
| 2025-10-31 10:00:00 | YM | Futures | 48409.7 | 48491.8 | 48305.2 | 48424.9 | 11265.0 |
| 2025-10-31 11:00:00 | YM | Futures | 48424.9 | 48462.4 | 48283.9 | 48324.5 | 10165.0 |
| 2025-10-31 12:00:00 | YM | Futures | 48323.5 | 48384.3 | 48217.0 | 48233.2 | 9143.0 |
| 2025-10-31 13:00:00 | YM | Futures | 48229.1 | 48278.8 | 48158.2 | 48257.5 | 9280.0 |
| 2025-10-31 14:00:00 | YM | Futures | 48255.5 | 48433.0 | 48254.5 | 48426.9 | 6403.0 |
| 2025-10-31 15:00:00 | YM | Futures | 48426.9 | 48537.4 | 48382.3 | 48384.3 | 13231.0 |
> showing 50 of 1,678 rows — these rows as CSV