PREVIEW / futures_1hour / 2025-06-26
file: by_date/futures_1hour/2025/2025-06-26.parquet size: 66 KB rows: 2,052
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-26 00:00:00 | ES | Futures | 6198.64 | 6201.66 | 6196.87 | 6200.9 | 2340.0 |
| 2025-06-26 01:00:00 | ES | Futures | 6200.9 | 6202.92 | 6198.89 | 6202.41 | 2967.0 |
| 2025-06-26 02:00:00 | ES | Futures | 6202.41 | 6209.47 | 6201.66 | 6206.7 | 6326.0 |
| 2025-06-26 03:00:00 | ES | Futures | 6206.95 | 6213.5 | 6205.44 | 6206.44 | 9383.0 |
| 2025-06-26 04:00:00 | ES | Futures | 6206.44 | 6216.77 | 6205.94 | 6212.49 | 10063.0 |
| 2025-06-26 05:00:00 | ES | Futures | 6212.49 | 6213.24 | 6207.45 | 6209.21 | 6603.0 |
| 2025-06-26 06:00:00 | ES | Futures | 6209.21 | 6217.02 | 6207.7 | 6210.73 | 8668.0 |
| 2025-06-26 07:00:00 | ES | Futures | 6210.73 | 6216.52 | 6210.22 | 6215.76 | 10157.0 |
| 2025-06-26 08:00:00 | ES | Futures | 6216.02 | 6217.27 | 6203.93 | 6212.74 | 24407.0 |
| 2025-06-26 09:00:00 | ES | Futures | 6212.49 | 6216.02 | 6205.44 | 6213.24 | 122090.0 |
| 2025-06-26 10:00:00 | ES | Futures | 6213.24 | 6228.36 | 6212.74 | 6226.34 | 134637.0 |
| 2025-06-26 11:00:00 | ES | Futures | 6226.09 | 6231.38 | 6220.55 | 6227.85 | 107364.0 |
| 2025-06-26 12:00:00 | ES | Futures | 6227.85 | 6233.9 | 6227.1 | 6231.13 | 69598.0 |
| 2025-06-26 13:00:00 | ES | Futures | 6231.13 | 6238.94 | 6228.86 | 6235.66 | 70782.0 |
| 2025-06-26 14:00:00 | ES | Futures | 6235.41 | 6244.48 | 6233.65 | 6237.17 | 95411.0 |
| 2025-06-26 15:00:00 | ES | Futures | 6237.42 | 6246.49 | 6234.91 | 6242.71 | 207070.0 |
| 2025-06-26 16:00:00 | ES | Futures | 6242.97 | 6243.22 | 6235.66 | 6242.21 | 51403.0 |
| 2025-06-26 18:00:00 | ES | Futures | 6243.97 | 6251.78 | 6241.71 | 6247.5 | 8808.0 |
| 2025-06-26 19:00:00 | ES | Futures | 6247.5 | 6249.01 | 6241.71 | 6242.97 | 4751.0 |
| 2025-06-26 20:00:00 | ES | Futures | 6243.22 | 6246.24 | 6241.2 | 6242.21 | 4540.0 |
| 2025-06-26 21:00:00 | ES | Futures | 6241.96 | 6246.74 | 6240.45 | 6244.73 | 4349.0 |
| 2025-06-26 22:00:00 | ES | Futures | 6244.73 | 6248.51 | 6243.47 | 6248.51 | 2959.0 |
| 2025-06-26 23:00:00 | ES | Futures | 6248.51 | 6250.77 | 6247.75 | 6248.51 | 3436.0 |
| 2025-06-26 00:00:00 | NQ | Futures | 22691.18 | 22704.04 | 22685.38 | 22701.01 | 1951.0 |
| 2025-06-26 01:00:00 | NQ | Futures | 22700.51 | 22709.08 | 22689.66 | 22707.06 | 2406.0 |
| 2025-06-26 02:00:00 | NQ | Futures | 22707.06 | 22741.36 | 22704.79 | 22729.0 | 4975.0 |
| 2025-06-26 03:00:00 | NQ | Futures | 22729.25 | 22755.99 | 22719.67 | 22728.75 | 5882.0 |
| 2025-06-26 04:00:00 | NQ | Futures | 22728.5 | 22773.39 | 22722.19 | 22758.51 | 6571.0 |
| 2025-06-26 05:00:00 | NQ | Futures | 22758.51 | 22763.8 | 22740.1 | 22746.91 | 4476.0 |
| 2025-06-26 06:00:00 | NQ | Futures | 22747.16 | 22777.92 | 22737.83 | 22753.72 | 5894.0 |
| 2025-06-26 07:00:00 | NQ | Futures | 22753.97 | 22773.89 | 22750.94 | 22773.64 | 5827.0 |
| 2025-06-26 08:00:00 | NQ | Futures | 22773.89 | 22781.71 | 22716.14 | 22750.69 | 13263.0 |
| 2025-06-26 09:00:00 | NQ | Futures | 22750.94 | 22763.05 | 22671.76 | 22740.1 | 63690.0 |
| 2025-06-26 10:00:00 | NQ | Futures | 22740.1 | 22794.06 | 22733.54 | 22767.59 | 55193.0 |
| 2025-06-26 11:00:00 | NQ | Futures | 22766.83 | 22815.75 | 22746.4 | 22806.92 | 50693.0 |
| 2025-06-26 12:00:00 | NQ | Futures | 22806.92 | 22829.87 | 22793.56 | 22804.15 | 30740.0 |
| 2025-06-26 13:00:00 | NQ | Futures | 22804.15 | 22849.29 | 22794.32 | 22837.19 | 29964.0 |
| 2025-06-26 14:00:00 | NQ | Futures | 22837.44 | 22884.6 | 22831.39 | 22864.42 | 36237.0 |
| 2025-06-26 15:00:00 | NQ | Futures | 22864.42 | 22891.66 | 22849.8 | 22871.23 | 51786.0 |
| 2025-06-26 16:00:00 | NQ | Futures | 22870.73 | 22874.76 | 22838.19 | 22869.97 | 16140.0 |
| 2025-06-26 18:00:00 | NQ | Futures | 22873.75 | 22911.33 | 22866.69 | 22893.17 | 4768.0 |
| 2025-06-26 19:00:00 | NQ | Futures | 22893.17 | 22897.96 | 22867.7 | 22876.02 | 3349.0 |
| 2025-06-26 20:00:00 | NQ | Futures | 22876.02 | 22889.64 | 22862.66 | 22865.18 | 3779.0 |
| 2025-06-26 21:00:00 | NQ | Futures | 22863.92 | 22887.37 | 22857.61 | 22878.04 | 3078.0 |
| 2025-06-26 22:00:00 | NQ | Futures | 22877.28 | 22894.18 | 22872.49 | 22892.92 | 2503.0 |
| 2025-06-26 23:00:00 | NQ | Futures | 22893.17 | 22905.78 | 22887.87 | 22890.9 | 2928.0 |
| 2025-06-26 00:00:00 | YM | Futures | 44275.9 | 44286.2 | 44257.6 | 44281.1 | 348.0 |
| 2025-06-26 01:00:00 | YM | Futures | 44281.1 | 44295.4 | 44271.9 | 44292.3 | 305.0 |
| 2025-06-26 02:00:00 | YM | Futures | 44291.3 | 44334.2 | 44288.2 | 44315.8 | 945.0 |
| 2025-06-26 03:00:00 | YM | Futures | 44317.8 | 44359.7 | 44310.7 | 44314.8 | 1065.0 |
> showing 50 of 2,052 rows — these rows as CSV