PREVIEW / futures_30min / 2025-06-22
file: by_date/futures_30min/2025/2025-06-22.parquet size: 30 KB rows: 831
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-06-22 18:00:00 | ES | Futures | 6008.72 | 6042.73 | 6003.68 | 6039.7 | 26272.0 |
| 2025-06-22 18:30:00 | ES | Futures | 6040.21 | 6052.8 | 6039.7 | 6046.0 | 8905.0 |
| 2025-06-22 19:00:00 | ES | Futures | 6045.75 | 6046.5 | 6038.19 | 6044.24 | 4779.0 |
| 2025-06-22 19:30:00 | ES | Futures | 6044.24 | 6047.51 | 6040.96 | 6044.24 | 2613.0 |
| 2025-06-22 20:00:00 | ES | Futures | 6044.24 | 6044.74 | 6033.91 | 6036.18 | 4931.0 |
| 2025-06-22 20:30:00 | ES | Futures | 6035.67 | 6040.96 | 6033.91 | 6038.44 | 2818.0 |
| 2025-06-22 21:00:00 | ES | Futures | 6038.7 | 6043.23 | 6035.67 | 6036.18 | 3312.0 |
| 2025-06-22 21:30:00 | ES | Futures | 6035.92 | 6041.47 | 6034.92 | 6041.21 | 2444.0 |
| 2025-06-22 22:00:00 | ES | Futures | 6041.21 | 6045.24 | 6040.71 | 6043.98 | 2447.0 |
| 2025-06-22 22:30:00 | ES | Futures | 6043.98 | 6047.51 | 6042.98 | 6045.24 | 2012.0 |
| 2025-06-22 23:00:00 | ES | Futures | 6044.99 | 6046.76 | 6044.24 | 6045.5 | 1324.0 |
| 2025-06-22 23:30:00 | ES | Futures | 6045.5 | 6048.52 | 6044.99 | 6047.01 | 1854.0 |
| 2025-06-22 18:00:00 | NQ | Futures | 21836.8 | 21941.2 | 21754.59 | 21928.09 | 10306.0 |
| 2025-06-22 18:30:00 | NQ | Futures | 21927.58 | 21976.76 | 21927.08 | 21948.77 | 4178.0 |
| 2025-06-22 19:00:00 | NQ | Futures | 21947.76 | 21952.04 | 21916.23 | 21945.74 | 2990.0 |
| 2025-06-22 19:30:00 | NQ | Futures | 21946.24 | 21960.87 | 21930.36 | 21950.03 | 2381.0 |
| 2025-06-22 20:00:00 | NQ | Futures | 21950.53 | 21950.78 | 21896.06 | 21907.41 | 4630.0 |
| 2025-06-22 20:30:00 | NQ | Futures | 21907.41 | 21928.34 | 21899.09 | 21920.52 | 2042.0 |
| 2025-06-22 21:00:00 | NQ | Futures | 21919.76 | 21942.46 | 21903.88 | 21906.15 | 2622.0 |
| 2025-06-22 21:30:00 | NQ | Futures | 21905.39 | 21930.36 | 21900.1 | 21929.35 | 1633.0 |
| 2025-06-22 22:00:00 | NQ | Futures | 21928.59 | 21947.5 | 21926.83 | 21943.97 | 1888.0 |
| 2025-06-22 22:30:00 | NQ | Futures | 21943.97 | 21961.37 | 21938.17 | 21948.77 | 1949.0 |
| 2025-06-22 23:00:00 | NQ | Futures | 21948.01 | 21958.35 | 21945.23 | 21950.53 | 1136.0 |
| 2025-06-22 23:30:00 | NQ | Futures | 21950.53 | 21963.64 | 21947.5 | 21956.33 | 1074.0 |
| 2025-06-22 18:00:00 | YM | Futures | 43173.7 | 43299.3 | 43004.1 | 43274.8 | 1371.0 |
| 2025-06-22 18:30:00 | YM | Futures | 43285.0 | 43368.8 | 43282.0 | 43318.7 | 412.0 |
| 2025-06-22 19:00:00 | YM | Futures | 43312.6 | 43318.7 | 43264.6 | 43305.5 | 379.0 |
| 2025-06-22 19:30:00 | YM | Futures | 43303.4 | 43320.8 | 43278.9 | 43303.4 | 349.0 |
| 2025-06-22 20:00:00 | YM | Futures | 43301.4 | 43308.5 | 43241.1 | 43247.2 | 896.0 |
| 2025-06-22 20:30:00 | YM | Futures | 43246.2 | 43268.7 | 43237.0 | 43258.5 | 510.0 |
| 2025-06-22 21:00:00 | YM | Futures | 43255.4 | 43286.0 | 43241.1 | 43243.1 | 447.0 |
| 2025-06-22 21:30:00 | YM | Futures | 43242.1 | 43276.9 | 43239.1 | 43276.9 | 294.0 |
| 2025-06-22 22:00:00 | YM | Futures | 43276.9 | 43293.2 | 43269.7 | 43280.9 | 261.0 |
| 2025-06-22 22:30:00 | YM | Futures | 43283.0 | 43302.4 | 43278.9 | 43288.1 | 215.0 |
| 2025-06-22 23:00:00 | YM | Futures | 43288.1 | 43298.3 | 43283.0 | 43286.0 | 151.0 |
| 2025-06-22 23:30:00 | YM | Futures | 43289.1 | 43308.5 | 43283.0 | 43297.3 | 330.0 |
| 2025-06-22 18:00:00 | CL | Futures | 74.8 | 75.18 | 72.69 | 72.77 | 26956.0 |
| 2025-06-22 18:30:00 | CL | Futures | 72.75 | 72.82 | 72.13 | 72.25 | 8036.0 |
| 2025-06-22 19:00:00 | CL | Futures | 72.22 | 72.69 | 72.17 | 72.57 | 4002.0 |
| 2025-06-22 19:30:00 | CL | Futures | 72.56 | 72.74 | 72.26 | 72.66 | 3702.0 |
| 2025-06-22 20:00:00 | CL | Futures | 72.65 | 73.03 | 72.51 | 72.83 | 5117.0 |
| 2025-06-22 20:30:00 | CL | Futures | 72.84 | 72.95 | 72.66 | 72.76 | 2397.0 |
| 2025-06-22 21:00:00 | CL | Futures | 72.76 | 72.93 | 72.43 | 72.65 | 4409.0 |
| 2025-06-22 21:30:00 | CL | Futures | 72.67 | 72.7 | 71.92 | 72.2 | 5196.0 |
| 2025-06-22 22:00:00 | CL | Futures | 72.21 | 72.42 | 72.13 | 72.19 | 2817.0 |
| 2025-06-22 22:30:00 | CL | Futures | 72.18 | 72.2 | 71.99 | 72.16 | 2280.0 |
| 2025-06-22 23:00:00 | CL | Futures | 72.14 | 72.19 | 71.83 | 71.87 | 2744.0 |
| 2025-06-22 23:30:00 | CL | Futures | 71.88 | 72.28 | 71.88 | 72.2 | 1357.0 |
| 2025-06-22 18:00:00 | GC | Futures | 3513.2 | 3526.8 | 3502.6 | 3503.2 | 9205.0 |
| 2025-06-22 18:30:00 | GC | Futures | 3502.9 | 3512.4 | 3498.9 | 3506.4 | 3249.0 |
> showing 50 of 831 rows — these rows as CSV