PREVIEW / futures_1hour / 2024-11-17
file: by_date/futures_1hour/2024/2024-11-17.parquet size: 21 KB rows: 465
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-11-17 18:00:00 | ES | Futures | 6124.49 | 6129.42 | 6116.19 | 6129.16 | 16538.0 |
| 2024-11-17 19:00:00 | ES | Futures | 6129.42 | 6139.8 | 6127.87 | 6139.03 | 15789.0 |
| 2024-11-17 20:00:00 | ES | Futures | 6138.77 | 6139.55 | 6135.65 | 6137.21 | 8486.0 |
| 2024-11-17 21:00:00 | ES | Futures | 6137.21 | 6138.51 | 6133.84 | 6137.21 | 6817.0 |
| 2024-11-17 22:00:00 | ES | Futures | 6137.21 | 6138.51 | 6134.87 | 6136.43 | 5170.0 |
| 2024-11-17 23:00:00 | ES | Futures | 6136.43 | 6140.84 | 6136.17 | 6139.29 | 6873.0 |
| 2024-11-17 18:00:00 | NQ | Futures | 21398.98 | 21466.56 | 21369.76 | 21466.04 | 9181.0 |
| 2024-11-17 19:00:00 | NQ | Futures | 21465.26 | 21530.22 | 21458.47 | 21528.4 | 8535.0 |
| 2024-11-17 20:00:00 | NQ | Futures | 21528.4 | 21531.01 | 21502.83 | 21509.09 | 6622.0 |
| 2024-11-17 21:00:00 | NQ | Futures | 21508.57 | 21528.66 | 21492.13 | 21528.4 | 4841.0 |
| 2024-11-17 22:00:00 | NQ | Futures | 21528.92 | 21541.96 | 21519.27 | 21529.96 | 3986.0 |
| 2024-11-17 23:00:00 | NQ | Futures | 21530.75 | 21558.66 | 21530.22 | 21550.31 | 3874.0 |
| 2024-11-17 18:00:00 | YM | Futures | 45357.0 | 45362.2 | 45287.3 | 45332.0 | 2237.0 |
| 2024-11-17 19:00:00 | YM | Futures | 45333.1 | 45389.3 | 45325.8 | 45384.1 | 1253.0 |
| 2024-11-17 20:00:00 | YM | Futures | 45385.1 | 45398.7 | 45372.6 | 45383.0 | 788.0 |
| 2024-11-17 21:00:00 | YM | Futures | 45381.0 | 45381.0 | 45348.7 | 45351.8 | 628.0 |
| 2024-11-17 22:00:00 | YM | Futures | 45352.9 | 45354.9 | 45319.6 | 45323.7 | 585.0 |
| 2024-11-17 23:00:00 | YM | Futures | 45324.8 | 45359.1 | 45323.7 | 45345.6 | 762.0 |
| 2024-11-17 18:00:00 | CL | Futures | 60.57 | 60.66 | 60.35 | 60.53 | 3365.0 |
| 2024-11-17 19:00:00 | CL | Futures | 60.54 | 60.85 | 60.52 | 60.83 | 1649.0 |
| 2024-11-17 20:00:00 | CL | Futures | 60.82 | 60.86 | 60.61 | 60.79 | 2297.0 |
| 2024-11-17 21:00:00 | CL | Futures | 60.79 | 60.89 | 60.72 | 60.85 | 1401.0 |
| 2024-11-17 22:00:00 | CL | Futures | 60.85 | 61.03 | 60.85 | 60.99 | 1657.0 |
| 2024-11-17 23:00:00 | CL | Futures | 60.99 | 61.01 | 60.91 | 60.93 | 706.0 |
| 2024-11-17 18:00:00 | GC | Futures | 2707.7 | 2716.7 | 2704.5 | 2712.3 | 5267.0 |
| 2024-11-17 19:00:00 | GC | Futures | 2712.2 | 2718.7 | 2710.8 | 2717.7 | 3464.0 |
| 2024-11-17 20:00:00 | GC | Futures | 2717.7 | 2739.7 | 2717.7 | 2728.7 | 17659.0 |
| 2024-11-17 21:00:00 | GC | Futures | 2728.6 | 2737.7 | 2728.6 | 2733.1 | 6586.0 |
| 2024-11-17 22:00:00 | GC | Futures | 2733.0 | 2734.7 | 2729.7 | 2731.8 | 2745.0 |
| 2024-11-17 23:00:00 | GC | Futures | 2731.8 | 2735.3 | 2731.3 | 2734.3 | 1460.0 |
| 2024-11-17 18:00:00 | ZN | Futures | 109.606287 | 109.684544 | 109.590636 | 109.621938 | 20396.0 |
| 2024-11-17 19:00:00 | ZN | Futures | 109.621938 | 109.715846 | 109.590636 | 109.700195 | 17487.0 |
| 2024-11-17 20:00:00 | ZN | Futures | 109.684544 | 109.715846 | 109.668892 | 109.684544 | 14939.0 |
| 2024-11-17 21:00:00 | ZN | Futures | 109.684544 | 109.715846 | 109.621938 | 109.653241 | 10608.0 |
| 2024-11-17 22:00:00 | ZN | Futures | 109.63759 | 109.653241 | 109.559333 | 109.621938 | 12428.0 |
| 2024-11-17 23:00:00 | ZN | Futures | 109.63759 | 109.653241 | 109.621938 | 109.63759 | 3350.0 |
> showing 36 of 465 rows — these rows as CSV