PREVIEW / futures_1hour / 2024-10-20
file: by_date/futures_1hour/2024/2024-10-20.parquet size: 19 KB rows: 431
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-10-20 18:00:00 | ES | Futures | 6136.69 | 6140.06 | 6135.91 | 6139.03 | 4107.0 |
| 2024-10-20 19:00:00 | ES | Futures | 6139.03 | 6140.84 | 6136.95 | 6138.77 | 2611.0 |
| 2024-10-20 20:00:00 | ES | Futures | 6139.03 | 6139.29 | 6135.91 | 6137.99 | 3232.0 |
| 2024-10-20 21:00:00 | ES | Futures | 6137.99 | 6140.06 | 6136.95 | 6137.21 | 3269.0 |
| 2024-10-20 22:00:00 | ES | Futures | 6137.21 | 6137.73 | 6133.84 | 6134.61 | 3147.0 |
| 2024-10-20 23:00:00 | ES | Futures | 6134.61 | 6135.65 | 6132.54 | 6133.32 | 2665.0 |
| 2024-10-20 18:00:00 | NQ | Futures | 21390.9 | 21419.6 | 21390.64 | 21412.03 | 3452.0 |
| 2024-10-20 19:00:00 | NQ | Futures | 21411.77 | 21421.95 | 21400.29 | 21409.16 | 2716.0 |
| 2024-10-20 20:00:00 | NQ | Futures | 21409.94 | 21419.34 | 21393.77 | 21405.77 | 2769.0 |
| 2024-10-20 21:00:00 | NQ | Futures | 21405.25 | 21415.94 | 21400.55 | 21402.64 | 2388.0 |
| 2024-10-20 22:00:00 | NQ | Futures | 21402.9 | 21406.29 | 21378.89 | 21385.16 | 3078.0 |
| 2024-10-20 23:00:00 | NQ | Futures | 21384.37 | 21395.07 | 21369.5 | 21374.2 | 2776.0 |
| 2024-10-20 18:00:00 | YM | Futures | 45315.4 | 45341.4 | 45306.0 | 45338.3 | 813.0 |
| 2024-10-20 19:00:00 | YM | Futures | 45338.3 | 45349.7 | 45332.0 | 45342.5 | 600.0 |
| 2024-10-20 20:00:00 | YM | Futures | 45343.5 | 45351.8 | 45330.0 | 45346.6 | 518.0 |
| 2024-10-20 21:00:00 | YM | Futures | 45346.6 | 45353.9 | 45336.2 | 45337.3 | 366.0 |
| 2024-10-20 22:00:00 | YM | Futures | 45339.3 | 45340.4 | 45325.8 | 45328.9 | 379.0 |
| 2024-10-20 23:00:00 | YM | Futures | 45328.9 | 45331.0 | 45319.6 | 45321.6 | 308.0 |
| 2024-10-20 18:00:00 | CL | Futures | 62.39 | 62.46 | 61.96 | 62.18 | 3864.0 |
| 2024-10-20 19:00:00 | CL | Futures | 62.19 | 62.34 | 62.17 | 62.29 | 919.0 |
| 2024-10-20 20:00:00 | CL | Futures | 62.28 | 62.42 | 62.2 | 62.41 | 1839.0 |
| 2024-10-20 21:00:00 | CL | Futures | 62.41 | 62.49 | 62.04 | 62.05 | 3738.0 |
| 2024-10-20 22:00:00 | CL | Futures | 62.05 | 62.47 | 62.03 | 62.35 | 3319.0 |
| 2024-10-20 23:00:00 | CL | Futures | 62.33 | 62.54 | 62.31 | 62.54 | 2169.0 |
| 2024-10-20 18:00:00 | GC | Futures | 2881.2 | 2884.0 | 2879.4 | 2883.8 | 2579.0 |
| 2024-10-20 19:00:00 | GC | Futures | 2883.5 | 2885.3 | 2882.4 | 2883.7 | 2039.0 |
| 2024-10-20 20:00:00 | GC | Futures | 2883.8 | 2886.1 | 2881.2 | 2881.5 | 3478.0 |
| 2024-10-20 21:00:00 | GC | Futures | 2881.7 | 2889.7 | 2880.8 | 2886.5 | 7111.0 |
| 2024-10-20 22:00:00 | GC | Futures | 2886.6 | 2891.8 | 2885.0 | 2891.0 | 5427.0 |
| 2024-10-20 23:00:00 | GC | Futures | 2891.0 | 2893.3 | 2889.7 | 2892.0 | 5143.0 |
| 2024-10-20 18:00:00 | ZN | Futures | 112.360922 | 112.376573 | 112.282665 | 112.298316 | 16388.0 |
| 2024-10-20 19:00:00 | ZN | Futures | 112.298316 | 112.313968 | 112.267014 | 112.282665 | 8250.0 |
| 2024-10-20 20:00:00 | ZN | Futures | 112.282665 | 112.329619 | 112.282665 | 112.329619 | 11788.0 |
| 2024-10-20 21:00:00 | ZN | Futures | 112.329619 | 112.376573 | 112.282665 | 112.376573 | 12870.0 |
| 2024-10-20 22:00:00 | ZN | Futures | 112.360922 | 112.392224 | 112.34527 | 112.376573 | 4245.0 |
| 2024-10-20 23:00:00 | ZN | Futures | 112.376573 | 112.392224 | 112.360922 | 112.360922 | 3909.0 |
> showing 36 of 431 rows — these rows as CSV