PREVIEW / futures_30min / 2025-01-09
file: by_date/futures_30min/2025/2025-01-09.parquet size: 97 KB rows: 3,671
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-01-09 00:00:00 | ES | Futures | 6096.15 | 6100.76 | 6094.1 | 6097.43 | 2363.0 |
| 2025-01-09 00:30:00 | ES | Futures | 6097.43 | 6101.53 | 6096.92 | 6100.76 | 1004.0 |
| 2025-01-09 01:00:00 | ES | Futures | 6100.76 | 6101.79 | 6098.97 | 6101.27 | 1192.0 |
| 2025-01-09 01:30:00 | ES | Futures | 6101.27 | 6101.53 | 6098.2 | 6100.25 | 1153.0 |
| 2025-01-09 02:00:00 | ES | Futures | 6099.99 | 6100.25 | 6092.56 | 6093.07 | 2746.0 |
| 2025-01-09 02:30:00 | ES | Futures | 6093.07 | 6093.33 | 6085.12 | 6086.4 | 4754.0 |
| 2025-01-09 03:00:00 | ES | Futures | 6086.4 | 6097.43 | 6080.51 | 6097.43 | 7988.0 |
| 2025-01-09 03:30:00 | ES | Futures | 6097.43 | 6103.84 | 6096.92 | 6101.53 | 4657.0 |
| 2025-01-09 04:00:00 | ES | Futures | 6101.79 | 6103.33 | 6098.45 | 6100.76 | 2890.0 |
| 2025-01-09 04:30:00 | ES | Futures | 6100.76 | 6106.15 | 6099.99 | 6104.35 | 4191.0 |
| 2025-01-09 05:00:00 | ES | Futures | 6104.35 | 6108.97 | 6104.09 | 6106.4 | 3457.0 |
| 2025-01-09 05:30:00 | ES | Futures | 6106.4 | 6107.43 | 6103.07 | 6105.63 | 2729.0 |
| 2025-01-09 06:00:00 | ES | Futures | 6105.63 | 6105.63 | 6097.17 | 6103.84 | 4080.0 |
| 2025-01-09 06:30:00 | ES | Futures | 6103.84 | 6104.09 | 6094.86 | 6099.22 | 4118.0 |
| 2025-01-09 07:00:00 | ES | Futures | 6099.74 | 6103.33 | 6094.86 | 6095.89 | 3351.0 |
| 2025-01-09 07:30:00 | ES | Futures | 6095.89 | 6102.81 | 6094.86 | 6102.56 | 4377.0 |
| 2025-01-09 08:00:00 | ES | Futures | 6102.3 | 6106.66 | 6099.48 | 6102.3 | 6676.0 |
| 2025-01-09 08:30:00 | ES | Futures | 6102.3 | 6105.89 | 6095.63 | 6097.94 | 8524.0 |
| 2025-01-09 09:00:00 | ES | Futures | 6097.94 | 6097.94 | 6087.43 | 6096.4 | 14918.0 |
| 2025-01-09 18:00:00 | ES | Futures | 6095.38 | 6096.92 | 6085.89 | 6086.92 | 7067.0 |
| 2025-01-09 18:30:00 | ES | Futures | 6087.17 | 6087.43 | 6077.43 | 6081.79 | 6690.0 |
| 2025-01-09 19:00:00 | ES | Futures | 6082.05 | 6084.1 | 6071.53 | 6076.41 | 9941.0 |
| 2025-01-09 19:30:00 | ES | Futures | 6076.41 | 6079.74 | 6073.07 | 6073.84 | 4877.0 |
| 2025-01-09 20:00:00 | ES | Futures | 6074.1 | 6084.87 | 6073.84 | 6083.07 | 4619.0 |
| 2025-01-09 20:30:00 | ES | Futures | 6082.81 | 6087.43 | 6081.28 | 6085.64 | 3753.0 |
| 2025-01-09 21:00:00 | ES | Futures | 6085.64 | 6089.99 | 6083.58 | 6088.97 | 3345.0 |
| 2025-01-09 21:30:00 | ES | Futures | 6088.97 | 6091.53 | 6087.94 | 6090.25 | 2749.0 |
| 2025-01-09 22:00:00 | ES | Futures | 6090.25 | 6093.84 | 6089.99 | 6093.07 | 2561.0 |
| 2025-01-09 22:30:00 | ES | Futures | 6093.07 | 6097.17 | 6091.02 | 6094.61 | 3866.0 |
| 2025-01-09 23:00:00 | ES | Futures | 6094.35 | 6095.38 | 6091.53 | 6092.3 | 2054.0 |
| 2025-01-09 23:30:00 | ES | Futures | 6092.3 | 6096.4 | 6091.79 | 6095.63 | 1778.0 |
| 2025-01-09 00:00:00 | NQ | Futures | 21936.49 | 21956.05 | 21928.25 | 21938.03 | 1515.0 |
| 2025-01-09 00:30:00 | NQ | Futures | 21938.03 | 21954.25 | 21935.72 | 21949.61 | 975.0 |
| 2025-01-09 01:00:00 | NQ | Futures | 21950.64 | 21955.53 | 21938.8 | 21950.64 | 1120.0 |
| 2025-01-09 01:30:00 | NQ | Futures | 21951.16 | 21952.44 | 21933.14 | 21940.61 | 1032.0 |
| 2025-01-09 02:00:00 | NQ | Futures | 21941.89 | 21942.92 | 21900.97 | 21901.23 | 2259.0 |
| 2025-01-09 02:30:00 | NQ | Futures | 21901.75 | 21903.55 | 21865.2 | 21873.44 | 4157.0 |
| 2025-01-09 03:00:00 | NQ | Futures | 21873.44 | 21906.12 | 21841.53 | 21904.83 | 5057.0 |
| 2025-01-09 03:30:00 | NQ | Futures | 21905.09 | 21932.89 | 21901.49 | 21919.25 | 3768.0 |
| 2025-01-09 04:00:00 | NQ | Futures | 21920.53 | 21928.51 | 21903.55 | 21914.1 | 2869.0 |
| 2025-01-09 04:30:00 | NQ | Futures | 21914.36 | 21940.09 | 21908.44 | 21937.52 | 2805.0 |
| 2025-01-09 05:00:00 | NQ | Futures | 21937.78 | 21961.45 | 21936.23 | 21948.33 | 2118.0 |
| 2025-01-09 05:30:00 | NQ | Futures | 21947.81 | 21960.68 | 21940.61 | 21954.25 | 1885.0 |
| 2025-01-09 06:00:00 | NQ | Futures | 21954.5 | 21955.53 | 21908.44 | 21939.58 | 3366.0 |
| 2025-01-09 06:30:00 | NQ | Futures | 21940.09 | 21940.61 | 21901.75 | 21927.74 | 3450.0 |
| 2025-01-09 07:00:00 | NQ | Futures | 21928.77 | 21944.21 | 21911.53 | 21917.19 | 2129.0 |
| 2025-01-09 07:30:00 | NQ | Futures | 21916.42 | 21939.06 | 21911.27 | 21938.03 | 2391.0 |
| 2025-01-09 08:00:00 | NQ | Futures | 21937.78 | 21958.36 | 21930.83 | 21945.75 | 3587.0 |
| 2025-01-09 08:30:00 | NQ | Futures | 21945.24 | 21960.94 | 21918.73 | 21931.08 | 4032.0 |
| 2025-01-09 09:00:00 | NQ | Futures | 21930.05 | 21936.49 | 21889.91 | 21927.48 | 6494.0 |
> showing 50 of 3,671 rows — these rows as CSV