PREVIEW / futures_1hour / 2025-08-31
file: by_date/futures_1hour/2025/2025-08-31.parquet size: 17 KB rows: 380
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-08-31 18:00:00 | ES | Futures | 6527.33 | 6536.15 | 6522.8 | 6535.9 | 7115.0 |
| 2025-08-31 19:00:00 | ES | Futures | 6535.9 | 6538.41 | 6534.89 | 6536.9 | 2867.0 |
| 2025-08-31 20:00:00 | ES | Futures | 6536.9 | 6540.18 | 6533.88 | 6537.41 | 5080.0 |
| 2025-08-31 21:00:00 | ES | Futures | 6537.41 | 6537.66 | 6531.36 | 6532.87 | 4580.0 |
| 2025-08-31 22:00:00 | ES | Futures | 6532.87 | 6533.13 | 6523.3 | 6524.31 | 4900.0 |
| 2025-08-31 23:00:00 | ES | Futures | 6524.06 | 6527.33 | 6516.75 | 6518.77 | 4924.0 |
| 2025-08-31 18:00:00 | NQ | Futures | 23683.49 | 23742.0 | 23668.36 | 23740.99 | 5368.0 |
| 2025-08-31 19:00:00 | NQ | Futures | 23740.23 | 23751.33 | 23734.94 | 23743.51 | 2601.0 |
| 2025-08-31 20:00:00 | NQ | Futures | 23743.51 | 23757.63 | 23734.94 | 23742.76 | 3450.0 |
| 2025-08-31 21:00:00 | NQ | Futures | 23743.51 | 23745.28 | 23713.0 | 23722.58 | 3683.0 |
| 2025-08-31 22:00:00 | NQ | Futures | 23722.83 | 23723.34 | 23670.38 | 23673.41 | 4955.0 |
| 2025-08-31 23:00:00 | NQ | Futures | 23673.41 | 23689.29 | 23635.83 | 23646.42 | 5615.0 |
| 2025-08-31 18:00:00 | YM | Futures | 46670.5 | 46695.0 | 46614.3 | 46694.0 | 540.0 |
| 2025-08-31 19:00:00 | YM | Futures | 46696.1 | 46719.5 | 46682.8 | 46694.0 | 346.0 |
| 2025-08-31 20:00:00 | YM | Futures | 46696.1 | 46739.0 | 46677.7 | 46713.4 | 743.0 |
| 2025-08-31 21:00:00 | YM | Futures | 46711.4 | 46712.4 | 46662.3 | 46666.4 | 520.0 |
| 2025-08-31 22:00:00 | YM | Futures | 46666.4 | 46668.5 | 46609.2 | 46625.6 | 958.0 |
| 2025-08-31 23:00:00 | YM | Futures | 46626.6 | 46647.0 | 46552.0 | 46583.7 | 1626.0 |
| 2025-08-31 18:00:00 | CL | Futures | 62.02 | 62.11 | 61.97 | 62.04 | 641.0 |
| 2025-08-31 19:00:00 | CL | Futures | 62.03 | 62.04 | 61.98 | 62.03 | 160.0 |
| 2025-08-31 20:00:00 | CL | Futures | 62.02 | 62.02 | 61.92 | 61.98 | 568.0 |
| 2025-08-31 21:00:00 | CL | Futures | 61.97 | 61.97 | 61.75 | 61.81 | 1334.0 |
| 2025-08-31 22:00:00 | CL | Futures | 61.81 | 61.9 | 61.74 | 61.86 | 735.0 |
| 2025-08-31 23:00:00 | CL | Futures | 61.86 | 61.89 | 61.82 | 61.83 | 470.0 |
| 2025-08-31 18:00:00 | GC | Futures | 3573.2 | 3573.3 | 3566.1 | 3568.7 | 3515.0 |
| 2025-08-31 19:00:00 | GC | Futures | 3568.8 | 3569.5 | 3564.8 | 3567.3 | 1840.0 |
| 2025-08-31 20:00:00 | GC | Futures | 3567.1 | 3570.0 | 3564.9 | 3566.6 | 2689.0 |
| 2025-08-31 21:00:00 | GC | Futures | 3566.6 | 3584.0 | 3561.1 | 3581.8 | 9128.0 |
| 2025-08-31 22:00:00 | GC | Futures | 3581.9 | 3606.7 | 3579.5 | 3605.2 | 22656.0 |
| 2025-08-31 23:00:00 | GC | Futures | 3605.4 | 3608.2 | 3594.5 | 3598.9 | 7183.0 |
| 2025-08-31 18:00:00 | ZN | Futures | 112.437389 | 112.468644 | 112.421762 | 112.437389 | 35.0 |
| 2025-08-31 19:00:00 | ZN | Futures | 112.437389 | 112.437389 | 112.421762 | 112.421762 | 3.0 |
| 2025-08-31 20:00:00 | ZN | Futures | 112.406135 | 112.421762 | 112.406135 | 112.421762 | 21.0 |
| 2025-08-31 22:00:00 | ZN | Futures | 112.421762 | 112.421762 | 112.390508 | 112.390508 | 26.0 |
| 2025-08-31 23:00:00 | ZN | Futures | 112.406135 | 112.406135 | 112.390508 | 112.390508 | 77.0 |
> showing 35 of 380 rows — these rows as CSV