PREVIEW / futures_1hour / 2024-09-29
file: by_date/futures_1hour/2024/2024-09-29.parquet size: 19 KB rows: 433
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-29 18:00:00 | ES | Futures | 6004.33 | 6014.45 | 5999.14 | 6014.45 | 10562.0 |
| 2024-09-29 19:00:00 | ES | Futures | 6014.45 | 6022.76 | 6013.42 | 6020.94 | 6679.0 |
| 2024-09-29 20:00:00 | ES | Futures | 6020.94 | 6023.8 | 6018.09 | 6018.87 | 8877.0 |
| 2024-09-29 21:00:00 | ES | Futures | 6018.87 | 6018.87 | 6007.71 | 6010.56 | 13340.0 |
| 2024-09-29 22:00:00 | ES | Futures | 6010.56 | 6012.64 | 6005.89 | 6012.12 | 6764.0 |
| 2024-09-29 23:00:00 | ES | Futures | 6012.38 | 6016.79 | 6012.12 | 6016.01 | 5545.0 |
| 2024-09-29 18:00:00 | NQ | Futures | 21080.15 | 21128.94 | 21037.88 | 21128.16 | 4752.0 |
| 2024-09-29 19:00:00 | NQ | Futures | 21128.42 | 21167.82 | 21120.85 | 21158.68 | 3856.0 |
| 2024-09-29 20:00:00 | NQ | Futures | 21161.29 | 21172.51 | 21126.85 | 21131.03 | 4917.0 |
| 2024-09-29 21:00:00 | NQ | Futures | 21131.29 | 21131.55 | 21054.58 | 21073.11 | 7581.0 |
| 2024-09-29 22:00:00 | NQ | Futures | 21073.37 | 21073.63 | 21033.19 | 21070.24 | 3811.0 |
| 2024-09-29 23:00:00 | NQ | Futures | 21071.02 | 21105.72 | 21065.02 | 21102.33 | 3430.0 |
| 2024-09-29 18:00:00 | YM | Futures | 44386.0 | 44404.7 | 44320.4 | 44398.5 | 981.0 |
| 2024-09-29 19:00:00 | YM | Futures | 44398.5 | 44447.4 | 44390.2 | 44429.7 | 1500.0 |
| 2024-09-29 20:00:00 | YM | Futures | 44431.8 | 44455.7 | 44413.1 | 44421.4 | 1232.0 |
| 2024-09-29 21:00:00 | YM | Futures | 44420.3 | 44425.6 | 44368.3 | 44388.1 | 1321.0 |
| 2024-09-29 22:00:00 | YM | Futures | 44386.0 | 44411.0 | 44373.5 | 44411.0 | 466.0 |
| 2024-09-29 23:00:00 | YM | Futures | 44411.0 | 44417.2 | 44402.7 | 44412.0 | 548.0 |
| 2024-09-29 18:00:00 | CL | Futures | 61.55 | 61.55 | 60.87 | 60.97 | 4650.0 |
| 2024-09-29 19:00:00 | CL | Futures | 60.97 | 61.29 | 60.94 | 61.25 | 1655.0 |
| 2024-09-29 20:00:00 | CL | Futures | 61.25 | 61.37 | 61.14 | 61.35 | 2288.0 |
| 2024-09-29 21:00:00 | CL | Futures | 61.35 | 61.87 | 61.07 | 61.2 | 9107.0 |
| 2024-09-29 22:00:00 | CL | Futures | 61.21 | 61.64 | 61.11 | 61.53 | 3199.0 |
| 2024-09-29 23:00:00 | CL | Futures | 61.54 | 61.59 | 61.35 | 61.38 | 2207.0 |
| 2024-09-29 18:00:00 | GC | Futures | 2822.5 | 2827.7 | 2821.2 | 2826.7 | 3628.0 |
| 2024-09-29 19:00:00 | GC | Futures | 2826.6 | 2829.1 | 2825.5 | 2827.5 | 2291.0 |
| 2024-09-29 20:00:00 | GC | Futures | 2827.6 | 2830.1 | 2824.9 | 2825.2 | 3581.0 |
| 2024-09-29 21:00:00 | GC | Futures | 2825.2 | 2828.2 | 2810.2 | 2816.1 | 8349.0 |
| 2024-09-29 22:00:00 | GC | Futures | 2815.7 | 2819.9 | 2813.5 | 2815.5 | 3532.0 |
| 2024-09-29 23:00:00 | GC | Futures | 2815.6 | 2819.1 | 2815.2 | 2816.9 | 1384.0 |
| 2024-09-29 18:00:00 | ZN | Futures | 114.92774 | 114.943392 | 114.849484 | 114.912089 | 16278.0 |
| 2024-09-29 19:00:00 | ZN | Futures | 114.912089 | 114.92774 | 114.865135 | 114.880786 | 15079.0 |
| 2024-09-29 20:00:00 | ZN | Futures | 114.880786 | 114.912089 | 114.833832 | 114.865135 | 18194.0 |
| 2024-09-29 21:00:00 | ZN | Futures | 114.865135 | 114.92774 | 114.849484 | 114.896438 | 13459.0 |
| 2024-09-29 22:00:00 | ZN | Futures | 114.896438 | 114.92774 | 114.865135 | 114.880786 | 7364.0 |
| 2024-09-29 23:00:00 | ZN | Futures | 114.880786 | 114.896438 | 114.849484 | 114.865135 | 6617.0 |
> showing 36 of 433 rows — these rows as CSV