PREVIEW / futures_1hour / 2025-07-20
file: by_date/futures_1hour/2025/2025-07-20.parquet size: 19 KB rows: 413
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-20 18:00:00 | ES | Futures | 6383.26 | 6386.79 | 6377.22 | 6385.53 | 7193.0 |
| 2025-07-20 19:00:00 | ES | Futures | 6385.78 | 6390.56 | 6384.27 | 6390.31 | 3626.0 |
| 2025-07-20 20:00:00 | ES | Futures | 6390.31 | 6391.32 | 6389.05 | 6389.56 | 3020.0 |
| 2025-07-20 21:00:00 | ES | Futures | 6389.56 | 6392.58 | 6388.8 | 6389.56 | 3991.0 |
| 2025-07-20 22:00:00 | ES | Futures | 6389.56 | 6390.82 | 6387.54 | 6388.3 | 2217.0 |
| 2025-07-20 23:00:00 | ES | Futures | 6388.3 | 6389.31 | 6386.28 | 6387.29 | 2008.0 |
| 2025-07-20 18:00:00 | NQ | Futures | 23434.85 | 23447.96 | 23405.85 | 23446.45 | 4598.0 |
| 2025-07-20 19:00:00 | NQ | Futures | 23447.71 | 23465.36 | 23439.39 | 23462.84 | 3487.0 |
| 2025-07-20 20:00:00 | NQ | Futures | 23463.09 | 23465.61 | 23453.0 | 23454.52 | 2467.0 |
| 2025-07-20 21:00:00 | NQ | Futures | 23455.02 | 23479.99 | 23453.51 | 23466.62 | 3454.0 |
| 2025-07-20 22:00:00 | NQ | Futures | 23466.62 | 23473.18 | 23457.79 | 23460.06 | 2049.0 |
| 2025-07-20 23:00:00 | NQ | Futures | 23459.81 | 23464.35 | 23444.93 | 23448.97 | 1897.0 |
| 2025-07-20 18:00:00 | YM | Futures | 45497.7 | 45523.3 | 45450.8 | 45512.1 | 417.0 |
| 2025-07-20 19:00:00 | YM | Futures | 45514.1 | 45566.2 | 45509.0 | 45564.2 | 652.0 |
| 2025-07-20 20:00:00 | YM | Futures | 45565.2 | 45574.4 | 45556.0 | 45567.2 | 486.0 |
| 2025-07-20 21:00:00 | YM | Futures | 45568.2 | 45573.3 | 45540.7 | 45544.7 | 632.0 |
| 2025-07-20 22:00:00 | YM | Futures | 45545.8 | 45553.9 | 45527.4 | 45533.5 | 280.0 |
| 2025-07-20 23:00:00 | YM | Futures | 45533.5 | 45547.8 | 45523.3 | 45530.4 | 297.0 |
| 2025-07-20 18:00:00 | CL | Futures | 63.33 | 63.57 | 63.27 | 63.54 | 1714.0 |
| 2025-07-20 19:00:00 | CL | Futures | 63.53 | 63.55 | 63.42 | 63.44 | 666.0 |
| 2025-07-20 20:00:00 | CL | Futures | 63.44 | 63.51 | 63.33 | 63.45 | 1067.0 |
| 2025-07-20 21:00:00 | CL | Futures | 63.45 | 63.58 | 63.39 | 63.44 | 2086.0 |
| 2025-07-20 22:00:00 | CL | Futures | 63.45 | 63.47 | 63.35 | 63.4 | 1151.0 |
| 2025-07-20 23:00:00 | CL | Futures | 63.4 | 63.5 | 63.39 | 63.48 | 907.0 |
| 2025-07-20 18:00:00 | GC | Futures | 3466.6 | 3467.9 | 3461.9 | 3465.3 | 2708.0 |
| 2025-07-20 19:00:00 | GC | Futures | 3465.2 | 3466.5 | 3462.4 | 3466.2 | 1403.0 |
| 2025-07-20 20:00:00 | GC | Futures | 3466.3 | 3471.9 | 3464.8 | 3469.5 | 3079.0 |
| 2025-07-20 21:00:00 | GC | Futures | 3469.3 | 3476.5 | 3469.1 | 3474.1 | 4267.0 |
| 2025-07-20 22:00:00 | GC | Futures | 3474.2 | 3475.2 | 3469.6 | 3471.7 | 2856.0 |
| 2025-07-20 23:00:00 | GC | Futures | 3471.7 | 3474.5 | 3468.3 | 3468.7 | 2448.0 |
| 2025-07-20 18:00:00 | ZN | Futures | 110.874674 | 110.890301 | 110.765284 | 110.796538 | 8186.0 |
| 2025-07-20 19:00:00 | ZN | Futures | 110.780911 | 110.812165 | 110.780911 | 110.796538 | 2860.0 |
| 2025-07-20 20:00:00 | ZN | Futures | 110.812165 | 110.874674 | 110.780911 | 110.859046 | 5334.0 |
| 2025-07-20 21:00:00 | ZN | Futures | 110.859046 | 110.874674 | 110.843419 | 110.874674 | 4416.0 |
| 2025-07-20 22:00:00 | ZN | Futures | 110.874674 | 110.890301 | 110.859046 | 110.874674 | 4193.0 |
| 2025-07-20 23:00:00 | ZN | Futures | 110.874674 | 110.874674 | 110.812165 | 110.827792 | 3928.0 |
> showing 36 of 413 rows — these rows as CSV