PREVIEW / futures_30min / 2025-10-27
file: by_date/futures_30min/2025/2025-10-27.parquet size: 106 KB rows: 4,009
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-27 00:00:00 | ES | Futures | 6929.83 | 6931.59 | 6928.57 | 6931.34 | 2186.0 |
| 2025-10-27 00:30:00 | ES | Futures | 6931.34 | 6932.1 | 6929.58 | 6930.84 | 1799.0 |
| 2025-10-27 01:00:00 | ES | Futures | 6930.58 | 6935.12 | 6930.58 | 6934.61 | 2981.0 |
| 2025-10-27 01:30:00 | ES | Futures | 6934.87 | 6935.37 | 6932.85 | 6934.36 | 2067.0 |
| 2025-10-27 02:00:00 | ES | Futures | 6934.61 | 6939.9 | 6933.86 | 6939.4 | 5001.0 |
| 2025-10-27 02:30:00 | ES | Futures | 6939.15 | 6939.65 | 6935.37 | 6936.12 | 3906.0 |
| 2025-10-27 03:00:00 | ES | Futures | 6936.12 | 6940.41 | 6934.36 | 6938.64 | 5891.0 |
| 2025-10-27 03:30:00 | ES | Futures | 6938.9 | 6940.66 | 6934.36 | 6934.36 | 5778.0 |
| 2025-10-27 04:00:00 | ES | Futures | 6934.61 | 6935.87 | 6928.82 | 6929.58 | 9193.0 |
| 2025-10-27 04:30:00 | ES | Futures | 6929.83 | 6933.86 | 6928.07 | 6932.6 | 6925.0 |
| 2025-10-27 05:00:00 | ES | Futures | 6932.85 | 6933.86 | 6930.33 | 6930.58 | 4396.0 |
| 2025-10-27 05:30:00 | ES | Futures | 6930.58 | 6938.64 | 6930.58 | 6938.64 | 6938.0 |
| 2025-10-27 06:00:00 | ES | Futures | 6938.64 | 6939.15 | 6935.62 | 6938.39 | 5475.0 |
| 2025-10-27 06:30:00 | ES | Futures | 6938.39 | 6940.15 | 6937.38 | 6938.14 | 5278.0 |
| 2025-10-27 07:00:00 | ES | Futures | 6938.14 | 6940.66 | 6935.12 | 6935.87 | 8816.0 |
| 2025-10-27 07:30:00 | ES | Futures | 6935.87 | 6936.12 | 6930.33 | 6931.84 | 10690.0 |
| 2025-10-27 08:00:00 | ES | Futures | 6931.59 | 6936.88 | 6930.84 | 6933.61 | 8918.0 |
| 2025-10-27 08:30:00 | ES | Futures | 6934.11 | 6935.87 | 6931.59 | 6934.61 | 8410.0 |
| 2025-10-27 09:00:00 | ES | Futures | 6934.36 | 6938.14 | 6932.1 | 6934.36 | 17512.0 |
| 2025-10-27 09:30:00 | ES | Futures | 6934.61 | 6940.66 | 6928.57 | 6938.39 | 118296.0 |
| 2025-10-27 10:00:00 | ES | Futures | 6938.39 | 6944.18 | 6931.34 | 6938.14 | 109222.0 |
| 2025-10-27 10:30:00 | ES | Futures | 6938.14 | 6941.41 | 6933.1 | 6934.61 | 77224.0 |
| 2025-10-27 11:00:00 | ES | Futures | 6934.61 | 6941.41 | 6932.85 | 6941.41 | 58985.0 |
| 2025-10-27 11:30:00 | ES | Futures | 6941.16 | 6943.93 | 6939.65 | 6941.92 | 49947.0 |
| 2025-10-27 12:00:00 | ES | Futures | 6941.92 | 6945.44 | 6941.41 | 6942.93 | 37973.0 |
| 2025-10-27 12:30:00 | ES | Futures | 6942.93 | 6946.7 | 6942.67 | 6945.44 | 33344.0 |
| 2025-10-27 13:00:00 | ES | Futures | 6945.44 | 6945.95 | 6939.4 | 6942.17 | 36668.0 |
| 2025-10-27 13:30:00 | ES | Futures | 6942.17 | 6947.71 | 6940.91 | 6947.21 | 39222.0 |
| 2025-10-27 14:00:00 | ES | Futures | 6947.46 | 6947.46 | 6945.44 | 6946.2 | 32772.0 |
| 2025-10-27 14:30:00 | ES | Futures | 6946.45 | 6950.48 | 6946.45 | 6949.22 | 48103.0 |
| 2025-10-27 15:00:00 | ES | Futures | 6949.22 | 6950.99 | 6947.96 | 6950.48 | 43793.0 |
| 2025-10-27 15:30:00 | ES | Futures | 6950.48 | 6963.58 | 6949.73 | 6959.3 | 189965.0 |
| 2025-10-27 16:00:00 | ES | Futures | 6959.3 | 6965.59 | 6958.79 | 6965.59 | 52116.0 |
| 2025-10-27 16:30:00 | ES | Futures | 6965.59 | 6968.11 | 6965.34 | 6965.85 | 15690.0 |
| 2025-10-27 18:00:00 | ES | Futures | 6965.85 | 6965.85 | 6962.07 | 6964.08 | 3490.0 |
| 2025-10-27 18:30:00 | ES | Futures | 6964.08 | 6965.09 | 6962.82 | 6963.58 | 1488.0 |
| 2025-10-27 19:00:00 | ES | Futures | 6963.33 | 6969.12 | 6962.57 | 6968.62 | 3226.0 |
| 2025-10-27 19:30:00 | ES | Futures | 6968.36 | 6969.62 | 6962.57 | 6962.82 | 3151.0 |
| 2025-10-27 20:00:00 | ES | Futures | 6962.57 | 6963.83 | 6960.3 | 6961.82 | 3674.0 |
| 2025-10-27 20:30:00 | ES | Futures | 6961.56 | 6963.08 | 6960.3 | 6960.81 | 2954.0 |
| 2025-10-27 21:00:00 | ES | Futures | 6960.81 | 6961.56 | 6957.79 | 6959.3 | 3574.0 |
| 2025-10-27 21:30:00 | ES | Futures | 6959.55 | 6962.07 | 6958.29 | 6959.05 | 3256.0 |
| 2025-10-27 22:00:00 | ES | Futures | 6959.05 | 6961.06 | 6958.79 | 6959.8 | 2105.0 |
| 2025-10-27 22:30:00 | ES | Futures | 6959.8 | 6960.3 | 6957.03 | 6959.55 | 2472.0 |
| 2025-10-27 23:00:00 | ES | Futures | 6959.55 | 6961.06 | 6957.79 | 6959.05 | 1842.0 |
| 2025-10-27 23:30:00 | ES | Futures | 6959.05 | 6961.82 | 6958.29 | 6960.05 | 2108.0 |
| 2025-10-27 00:00:00 | NQ | Futures | 25985.92 | 25992.73 | 25978.1 | 25991.97 | 1879.0 |
| 2025-10-27 00:30:00 | NQ | Futures | 25991.47 | 25993.99 | 25982.39 | 25987.18 | 1119.0 |
| 2025-10-27 01:00:00 | NQ | Futures | 25989.2 | 26009.38 | 25986.43 | 26006.35 | 2235.0 |
| 2025-10-27 01:30:00 | NQ | Futures | 26006.35 | 26015.18 | 25997.27 | 26007.86 | 1518.0 |
> showing 50 of 4,009 rows — these rows as CSV