PREVIEW / futures_1hour / 2026-06-28
file: by_date/futures_1hour/2026/2026-06-28.parquet size: 19 KB rows: 487
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 |
|---|---|---|---|---|---|---|---|
| 2026-06-28 18:00:00 | ES | Futures | 7398.0 | 7438.5 | 7398.0 | 7434.5 | 15179.0 |
| 2026-06-28 19:00:00 | ES | Futures | 7434.5 | 7455.75 | 7432.5 | 7447.25 | 9935.0 |
| 2026-06-28 20:00:00 | ES | Futures | 7447.5 | 7447.5 | 7422.5 | 7438.5 | 20636.0 |
| 2026-06-28 21:00:00 | ES | Futures | 7438.5 | 7443.0 | 7426.75 | 7438.5 | 12004.0 |
| 2026-06-28 22:00:00 | ES | Futures | 7438.75 | 7443.75 | 7420.75 | 7440.5 | 9220.0 |
| 2026-06-28 23:00:00 | ES | Futures | 7440.75 | 7452.75 | 7434.0 | 7450.25 | 10193.0 |
| 2026-06-28 18:00:00 | NQ | Futures | 29282.5 | 29598.75 | 29280.25 | 29560.5 | 12218.0 |
| 2026-06-28 19:00:00 | NQ | Futures | 29558.25 | 29683.25 | 29548.75 | 29617.0 | 8562.0 |
| 2026-06-28 20:00:00 | NQ | Futures | 29621.0 | 29622.0 | 29363.25 | 29494.0 | 18576.0 |
| 2026-06-28 21:00:00 | NQ | Futures | 29494.0 | 29558.25 | 29420.25 | 29516.25 | 9482.0 |
| 2026-06-28 22:00:00 | NQ | Futures | 29518.5 | 29544.25 | 29389.0 | 29523.25 | 7118.0 |
| 2026-06-28 23:00:00 | NQ | Futures | 29525.75 | 29605.75 | 29482.25 | 29593.0 | 6631.0 |
| 2026-06-28 18:00:00 | YM | Futures | 52183.0 | 52354.0 | 52179.0 | 52337.0 | 768.0 |
| 2026-06-28 19:00:00 | YM | Futures | 52333.0 | 52450.0 | 52325.0 | 52404.0 | 558.0 |
| 2026-06-28 20:00:00 | YM | Futures | 52401.0 | 52404.0 | 52306.0 | 52367.0 | 2245.0 |
| 2026-06-28 21:00:00 | YM | Futures | 52369.0 | 52376.0 | 52273.0 | 52328.0 | 900.0 |
| 2026-06-28 22:00:00 | YM | Futures | 52329.0 | 52371.0 | 52259.0 | 52363.0 | 736.0 |
| 2026-06-28 23:00:00 | YM | Futures | 52362.0 | 52400.0 | 52310.0 | 52384.0 | 576.0 |
| 2026-06-28 18:00:00 | CL | Futures | 70.5 | 70.97 | 69.78 | 70.04 | 5959.0 |
| 2026-06-28 19:00:00 | CL | Futures | 70.05 | 70.1 | 69.66 | 69.76 | 1799.0 |
| 2026-06-28 20:00:00 | CL | Futures | 69.75 | 70.05 | 69.32 | 69.85 | 3022.0 |
| 2026-06-28 21:00:00 | CL | Futures | 69.86 | 70.28 | 69.74 | 70.0 | 2828.0 |
| 2026-06-28 22:00:00 | CL | Futures | 70.0 | 70.11 | 69.78 | 69.96 | 1482.0 |
| 2026-06-28 23:00:00 | CL | Futures | 69.95 | 70.1 | 69.9 | 70.05 | 1119.0 |
| 2026-06-28 18:00:00 | GC | Futures | 4101.1 | 4102.9 | 4067.1 | 4080.8 | 4148.0 |
| 2026-06-28 19:00:00 | GC | Futures | 4080.2 | 4084.8 | 4065.9 | 4076.7 | 1927.0 |
| 2026-06-28 20:00:00 | GC | Futures | 4076.3 | 4088.7 | 4062.6 | 4083.9 | 3868.0 |
| 2026-06-28 21:00:00 | GC | Futures | 4083.7 | 4088.6 | 4068.0 | 4075.8 | 3430.0 |
| 2026-06-28 22:00:00 | GC | Futures | 4075.4 | 4086.5 | 4073.2 | 4080.8 | 2893.0 |
| 2026-06-28 23:00:00 | GC | Futures | 4081.1 | 4090.4 | 4079.9 | 4083.2 | 1331.0 |
| 2026-06-28 18:00:00 | ZN | Futures | 110.234375 | 110.25 | 110.203125 | 110.234375 | 15892.0 |
| 2026-06-28 19:00:00 | ZN | Futures | 110.234375 | 110.265625 | 110.234375 | 110.25 | 5914.0 |
| 2026-06-28 20:00:00 | ZN | Futures | 110.25 | 110.28125 | 110.171875 | 110.203125 | 16777.0 |
| 2026-06-28 21:00:00 | ZN | Futures | 110.203125 | 110.203125 | 110.15625 | 110.171875 | 8203.0 |
| 2026-06-28 22:00:00 | ZN | Futures | 110.171875 | 110.1875 | 110.15625 | 110.171875 | 9641.0 |
| 2026-06-28 23:00:00 | ZN | Futures | 110.15625 | 110.1875 | 110.15625 | 110.171875 | 3982.0 |
> showing 36 of 487 rows — these rows as CSV