PREVIEW / futures_1hour / 2025-06-01
file: by_date/futures_1hour/2025/2025-06-01.parquet size: 19 KB rows: 427
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-01 18:00:00 | ES | Futures | 5994.07 | 6004.74 | 5991.28 | 5996.62 | 10436.0 |
| 2025-06-01 19:00:00 | ES | Futures | 5996.87 | 5997.12 | 5988.49 | 5994.07 | 5414.0 |
| 2025-06-01 20:00:00 | ES | Futures | 5994.33 | 6001.44 | 5992.04 | 5995.09 | 8747.0 |
| 2025-06-01 21:00:00 | ES | Futures | 5995.35 | 5999.66 | 5989.5 | 5992.04 | 6470.0 |
| 2025-06-01 22:00:00 | ES | Futures | 5992.3 | 5994.07 | 5986.2 | 5990.01 | 6797.0 |
| 2025-06-01 23:00:00 | ES | Futures | 5990.01 | 5990.01 | 5981.63 | 5982.39 | 8302.0 |
| 2025-06-01 18:00:00 | NQ | Futures | 21700.24 | 21745.82 | 21691.58 | 21710.42 | 5785.0 |
| 2025-06-01 19:00:00 | NQ | Futures | 21710.68 | 21711.7 | 21672.99 | 21701.26 | 4851.0 |
| 2025-06-01 20:00:00 | NQ | Futures | 21701.26 | 21722.9 | 21680.88 | 21690.31 | 4706.0 |
| 2025-06-01 21:00:00 | NQ | Futures | 21691.07 | 21710.17 | 21663.06 | 21673.75 | 4271.0 |
| 2025-06-01 22:00:00 | NQ | Futures | 21675.03 | 21680.88 | 21651.85 | 21661.02 | 4157.0 |
| 2025-06-01 23:00:00 | NQ | Futures | 21660.0 | 21661.02 | 21621.55 | 21626.64 | 4966.0 |
| 2025-06-01 18:00:00 | YM | Futures | 43445.3 | 43470.0 | 43393.8 | 43418.5 | 966.0 |
| 2025-06-01 19:00:00 | YM | Futures | 43421.6 | 43430.9 | 43377.3 | 43414.4 | 768.0 |
| 2025-06-01 20:00:00 | YM | Futures | 43412.3 | 43459.7 | 43406.2 | 43425.7 | 765.0 |
| 2025-06-01 21:00:00 | YM | Futures | 43426.7 | 43451.4 | 43387.6 | 43409.2 | 659.0 |
| 2025-06-01 22:00:00 | YM | Futures | 43411.3 | 43433.9 | 43377.3 | 43411.3 | 567.0 |
| 2025-06-01 23:00:00 | YM | Futures | 43410.3 | 43410.3 | 43358.8 | 43370.1 | 903.0 |
| 2025-06-01 18:00:00 | CL | Futures | 57.48 | 58.61 | 57.43 | 58.24 | 9273.0 |
| 2025-06-01 19:00:00 | CL | Futures | 58.24 | 58.38 | 58.16 | 58.33 | 2015.0 |
| 2025-06-01 20:00:00 | CL | Futures | 58.34 | 58.54 | 58.28 | 58.52 | 3378.0 |
| 2025-06-01 21:00:00 | CL | Futures | 58.51 | 58.8 | 58.45 | 58.65 | 4093.0 |
| 2025-06-01 22:00:00 | CL | Futures | 58.65 | 58.97 | 58.65 | 58.94 | 3521.0 |
| 2025-06-01 23:00:00 | CL | Futures | 58.95 | 58.97 | 58.6 | 58.72 | 4924.0 |
| 2025-06-01 18:00:00 | GC | Futures | 3432.9 | 3449.2 | 3429.2 | 3446.8 | 6774.0 |
| 2025-06-01 19:00:00 | GC | Futures | 3446.8 | 3450.4 | 3443.0 | 3443.6 | 2820.0 |
| 2025-06-01 20:00:00 | GC | Futures | 3443.5 | 3449.2 | 3436.3 | 3444.8 | 5122.0 |
| 2025-06-01 21:00:00 | GC | Futures | 3445.0 | 3447.5 | 3434.3 | 3436.7 | 4813.0 |
| 2025-06-01 22:00:00 | GC | Futures | 3436.7 | 3445.8 | 3436.5 | 3440.7 | 3431.0 |
| 2025-06-01 23:00:00 | GC | Futures | 3440.6 | 3443.1 | 3436.6 | 3442.8 | 2669.0 |
| 2025-06-01 18:00:00 | ZN | Futures | 110.84353 | 110.84353 | 110.8279 | 110.84353 | 51.0 |
| 2025-06-01 19:00:00 | ZN | Futures | 110.8279 | 110.8279 | 110.781012 | 110.781012 | 33.0 |
| 2025-06-01 20:00:00 | ZN | Futures | 110.765383 | 110.781012 | 110.749753 | 110.749753 | 31.0 |
| 2025-06-01 21:00:00 | ZN | Futures | 110.749753 | 110.749753 | 110.718495 | 110.734124 | 554.0 |
| 2025-06-01 22:00:00 | ZN | Futures | 110.749753 | 110.8279 | 110.749753 | 110.8279 | 157.0 |
| 2025-06-01 23:00:00 | ZN | Futures | 110.8279 | 110.84353 | 110.812271 | 110.812271 | 34.0 |
> showing 36 of 427 rows — these rows as CSV