PREVIEW / futures_1hour / 2025-06-15
file: by_date/futures_1hour/2025/2025-06-15.parquet size: 19 KB rows: 419
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-15 18:00:00 | ES | Futures | 6046.0 | 6083.28 | 6044.99 | 6074.97 | 9747.0 |
| 2025-06-15 19:00:00 | ES | Futures | 6075.22 | 6087.56 | 6068.16 | 6085.29 | 5588.0 |
| 2025-06-15 20:00:00 | ES | Futures | 6085.04 | 6088.06 | 6080.0 | 6086.3 | 4629.0 |
| 2025-06-15 21:00:00 | ES | Futures | 6086.8 | 6088.57 | 6081.77 | 6085.54 | 2567.0 |
| 2025-06-15 22:00:00 | ES | Futures | 6085.8 | 6092.6 | 6083.78 | 6088.57 | 2595.0 |
| 2025-06-15 23:00:00 | ES | Futures | 6088.57 | 6089.32 | 6082.77 | 6084.79 | 1262.0 |
| 2025-06-15 18:00:00 | NQ | Futures | 21962.13 | 22094.52 | 21915.23 | 22054.43 | 5130.0 |
| 2025-06-15 19:00:00 | NQ | Futures | 22055.94 | 22107.13 | 22018.37 | 22096.54 | 2981.0 |
| 2025-06-15 20:00:00 | NQ | Futures | 22094.02 | 22112.43 | 22067.54 | 22100.83 | 3268.0 |
| 2025-06-15 21:00:00 | NQ | Futures | 22103.1 | 22108.39 | 22073.34 | 22095.78 | 1856.0 |
| 2025-06-15 22:00:00 | NQ | Futures | 22095.03 | 22129.07 | 22088.98 | 22112.68 | 1687.0 |
| 2025-06-15 23:00:00 | NQ | Futures | 22112.68 | 22117.98 | 22084.44 | 22099.57 | 1259.0 |
| 2025-06-15 18:00:00 | YM | Futures | 43249.7 | 43449.4 | 43142.7 | 43406.2 | 637.0 |
| 2025-06-15 19:00:00 | YM | Futures | 43404.1 | 43487.5 | 43381.5 | 43470.0 | 195.0 |
| 2025-06-15 20:00:00 | YM | Futures | 43472.0 | 43489.5 | 43443.2 | 43487.5 | 287.0 |
| 2025-06-15 21:00:00 | YM | Futures | 43491.6 | 43499.8 | 43464.8 | 43483.3 | 170.0 |
| 2025-06-15 22:00:00 | YM | Futures | 43470.0 | 43518.3 | 43462.8 | 43494.7 | 221.0 |
| 2025-06-15 23:00:00 | YM | Futures | 43494.7 | 43498.8 | 43458.6 | 43462.8 | 151.0 |
| 2025-06-15 18:00:00 | CL | Futures | 72.4 | 72.4 | 69.71 | 69.75 | 13406.0 |
| 2025-06-15 19:00:00 | CL | Futures | 69.73 | 70.25 | 69.66 | 69.72 | 3142.0 |
| 2025-06-15 20:00:00 | CL | Futures | 69.74 | 69.75 | 68.99 | 69.15 | 4325.0 |
| 2025-06-15 21:00:00 | CL | Futures | 69.14 | 69.35 | 68.4 | 69.32 | 5436.0 |
| 2025-06-15 22:00:00 | CL | Futures | 69.35 | 69.43 | 68.9 | 69.19 | 1653.0 |
| 2025-06-15 23:00:00 | CL | Futures | 69.18 | 69.22 | 68.77 | 69.01 | 1362.0 |
| 2025-06-15 18:00:00 | GC | Futures | 3587.9 | 3591.3 | 3558.0 | 3583.5 | 12131.0 |
| 2025-06-15 19:00:00 | GC | Futures | 3583.7 | 3585.3 | 3574.0 | 3578.6 | 5097.0 |
| 2025-06-15 20:00:00 | GC | Futures | 3578.9 | 3586.4 | 3568.3 | 3570.9 | 8081.0 |
| 2025-06-15 21:00:00 | GC | Futures | 3571.0 | 3577.2 | 3567.5 | 3575.1 | 6623.0 |
| 2025-06-15 22:00:00 | GC | Futures | 3575.4 | 3580.6 | 3571.7 | 3572.4 | 5120.0 |
| 2025-06-15 23:00:00 | GC | Futures | 3572.2 | 3573.4 | 3562.4 | 3564.9 | 4928.0 |
| 2025-06-15 18:00:00 | ZN | Futures | 110.765284 | 110.827792 | 110.593385 | 110.687148 | 18957.0 |
| 2025-06-15 19:00:00 | ZN | Futures | 110.687148 | 110.702775 | 110.624639 | 110.655893 | 8928.0 |
| 2025-06-15 20:00:00 | ZN | Futures | 110.671521 | 110.718402 | 110.624639 | 110.702775 | 8957.0 |
| 2025-06-15 21:00:00 | ZN | Futures | 110.718402 | 110.780911 | 110.687148 | 110.702775 | 13891.0 |
| 2025-06-15 22:00:00 | ZN | Futures | 110.687148 | 110.702775 | 110.624639 | 110.655893 | 9101.0 |
| 2025-06-15 23:00:00 | ZN | Futures | 110.640266 | 110.655893 | 110.577758 | 110.593385 | 9058.0 |
> showing 36 of 419 rows — these rows as CSV