PREVIEW / futures_1hour / 2025-07-06
file: by_date/futures_1hour/2025/2025-07-06.parquet size: 19 KB rows: 418
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-07-06 18:00:00 | ES | Futures | 6355.05 | 6360.34 | 6342.71 | 6348.0 | 13088.0 |
| 2025-07-06 19:00:00 | ES | Futures | 6348.0 | 6353.29 | 6345.73 | 6348.5 | 5028.0 |
| 2025-07-06 20:00:00 | ES | Futures | 6348.5 | 6353.29 | 6346.49 | 6348.75 | 5462.0 |
| 2025-07-06 21:00:00 | ES | Futures | 6348.75 | 6349.01 | 6338.17 | 6344.47 | 8837.0 |
| 2025-07-06 22:00:00 | ES | Futures | 6344.72 | 6349.01 | 6343.72 | 6345.48 | 4385.0 |
| 2025-07-06 23:00:00 | ES | Futures | 6345.48 | 6349.51 | 6341.2 | 6349.26 | 3334.0 |
| 2025-07-06 18:00:00 | NQ | Futures | 23170.06 | 23229.07 | 23142.83 | 23175.36 | 7120.0 |
| 2025-07-06 19:00:00 | NQ | Futures | 23176.36 | 23206.12 | 23159.97 | 23183.68 | 4455.0 |
| 2025-07-06 20:00:00 | NQ | Futures | 23183.93 | 23200.07 | 23164.01 | 23170.31 | 3807.0 |
| 2025-07-06 21:00:00 | NQ | Futures | 23169.81 | 23170.56 | 23114.08 | 23142.57 | 6765.0 |
| 2025-07-06 22:00:00 | NQ | Futures | 23141.82 | 23169.56 | 23138.79 | 23157.96 | 4030.0 |
| 2025-07-06 23:00:00 | NQ | Futures | 23156.95 | 23176.87 | 23141.31 | 23175.1 | 3918.0 |
| 2025-07-06 18:00:00 | YM | Futures | 45883.9 | 46021.8 | 45883.9 | 45923.7 | 635.0 |
| 2025-07-06 19:00:00 | YM | Futures | 45924.8 | 45965.6 | 45914.5 | 45932.9 | 414.0 |
| 2025-07-06 20:00:00 | YM | Futures | 45931.9 | 45984.0 | 45921.7 | 45971.8 | 821.0 |
| 2025-07-06 21:00:00 | YM | Futures | 45971.8 | 45981.0 | 45914.5 | 45934.0 | 1044.0 |
| 2025-07-06 22:00:00 | YM | Futures | 45938.0 | 45952.3 | 45914.5 | 45921.7 | 499.0 |
| 2025-07-06 23:00:00 | YM | Futures | 45919.7 | 45947.2 | 45890.0 | 45942.1 | 382.0 |
| 2025-07-06 18:00:00 | CL | Futures | 63.0 | 63.43 | 62.71 | 63.4 | 5764.0 |
| 2025-07-06 19:00:00 | CL | Futures | 63.39 | 63.46 | 63.18 | 63.21 | 1272.0 |
| 2025-07-06 20:00:00 | CL | Futures | 63.2 | 63.2 | 62.84 | 63.18 | 3075.0 |
| 2025-07-06 21:00:00 | CL | Futures | 63.18 | 63.29 | 62.88 | 63.14 | 2665.0 |
| 2025-07-06 22:00:00 | CL | Futures | 63.15 | 63.29 | 63.09 | 63.23 | 1132.0 |
| 2025-07-06 23:00:00 | CL | Futures | 63.23 | 63.42 | 63.18 | 63.28 | 1173.0 |
| 2025-07-06 18:00:00 | GC | Futures | 3455.2 | 3463.8 | 3452.8 | 3453.9 | 3328.0 |
| 2025-07-06 19:00:00 | GC | Futures | 3454.0 | 3455.0 | 3445.6 | 3448.2 | 3070.0 |
| 2025-07-06 20:00:00 | GC | Futures | 3448.4 | 3449.1 | 3440.7 | 3446.1 | 4536.0 |
| 2025-07-06 21:00:00 | GC | Futures | 3446.1 | 3447.4 | 3425.1 | 3435.3 | 11779.0 |
| 2025-07-06 22:00:00 | GC | Futures | 3435.6 | 3436.9 | 3424.3 | 3427.7 | 5106.0 |
| 2025-07-06 23:00:00 | GC | Futures | 3427.7 | 3434.4 | 3425.7 | 3429.7 | 3636.0 |
| 2025-07-06 18:00:00 | ZN | Futures | 111.312234 | 111.39037 | 111.28098 | 111.374743 | 7820.0 |
| 2025-07-06 19:00:00 | ZN | Futures | 111.374743 | 111.405997 | 111.343488 | 111.405997 | 8191.0 |
| 2025-07-06 20:00:00 | ZN | Futures | 111.39037 | 111.405997 | 111.312234 | 111.312234 | 15238.0 |
| 2025-07-06 21:00:00 | ZN | Futures | 111.312234 | 111.374743 | 111.312234 | 111.327861 | 7636.0 |
| 2025-07-06 22:00:00 | ZN | Futures | 111.327861 | 111.359115 | 111.327861 | 111.343488 | 2800.0 |
| 2025-07-06 23:00:00 | ZN | Futures | 111.327861 | 111.359115 | 111.327861 | 111.327861 | 5063.0 |
> showing 36 of 418 rows — these rows as CSV