PREVIEW / futures_1hour / 2023-12-17
file: by_date/futures_1hour/2023/2023-12-17.parquet size: 19 KB rows: 428
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-17 18:00:00 | ES | Futures | 5125.25 | 5129.27 | 5124.17 | 5129.27 | 9035.0 |
| 2023-12-17 19:00:00 | ES | Futures | 5129.27 | 5133.84 | 5128.47 | 5131.69 | 9414.0 |
| 2023-12-17 20:00:00 | ES | Futures | 5131.69 | 5133.03 | 5129.54 | 5131.15 | 7141.0 |
| 2023-12-17 21:00:00 | ES | Futures | 5131.15 | 5133.03 | 5130.35 | 5132.5 | 4317.0 |
| 2023-12-17 22:00:00 | ES | Futures | 5132.23 | 5134.92 | 5131.69 | 5133.84 | 5187.0 |
| 2023-12-17 23:00:00 | ES | Futures | 5134.11 | 5136.8 | 5133.3 | 5136.53 | 5214.0 |
| 2023-12-17 18:00:00 | NQ | Futures | 18246.99 | 18274.92 | 18227.46 | 18250.51 | 6193.0 |
| 2023-12-17 19:00:00 | NQ | Futures | 18250.51 | 18266.78 | 18248.07 | 18252.68 | 5351.0 |
| 2023-12-17 20:00:00 | NQ | Futures | 18252.95 | 18259.73 | 18246.17 | 18255.93 | 3263.0 |
| 2023-12-17 21:00:00 | NQ | Futures | 18255.93 | 18272.21 | 18254.04 | 18268.68 | 2829.0 |
| 2023-12-17 22:00:00 | NQ | Futures | 18268.41 | 18274.65 | 18263.8 | 18270.58 | 2504.0 |
| 2023-12-17 23:00:00 | NQ | Futures | 18270.31 | 18282.78 | 18267.05 | 18281.97 | 2454.0 |
| 2023-12-17 18:00:00 | YM | Futures | 40449.8 | 40488.4 | 40449.8 | 40487.4 | 1446.0 |
| 2023-12-17 19:00:00 | YM | Futures | 40487.4 | 40523.9 | 40485.2 | 40513.1 | 1260.0 |
| 2023-12-17 20:00:00 | YM | Futures | 40513.1 | 40520.7 | 40494.9 | 40501.3 | 1038.0 |
| 2023-12-17 21:00:00 | YM | Futures | 40501.3 | 40509.9 | 40498.1 | 40505.6 | 340.0 |
| 2023-12-17 22:00:00 | YM | Futures | 40505.6 | 40527.1 | 40501.3 | 40523.9 | 472.0 |
| 2023-12-17 23:00:00 | YM | Futures | 40522.8 | 40536.8 | 40518.5 | 40535.7 | 542.0 |
| 2023-12-17 18:00:00 | CL | Futures | 60.24 | 60.64 | 60.24 | 60.63 | 2367.0 |
| 2023-12-17 19:00:00 | CL | Futures | 60.62 | 60.74 | 60.39 | 60.4 | 2124.0 |
| 2023-12-17 20:00:00 | CL | Futures | 60.39 | 60.46 | 60.16 | 60.27 | 3507.0 |
| 2023-12-17 21:00:00 | CL | Futures | 60.27 | 60.38 | 60.25 | 60.26 | 1706.0 |
| 2023-12-17 22:00:00 | CL | Futures | 60.27 | 60.33 | 60.21 | 60.27 | 1540.0 |
| 2023-12-17 23:00:00 | CL | Futures | 60.28 | 60.31 | 60.26 | 60.31 | 1061.0 |
| 2023-12-17 18:00:00 | GC | Futures | 2249.5 | 2251.2 | 2245.2 | 2246.9 | 3186.0 |
| 2023-12-17 19:00:00 | GC | Futures | 2247.0 | 2250.3 | 2245.2 | 2249.9 | 2991.0 |
| 2023-12-17 20:00:00 | GC | Futures | 2249.9 | 2254.3 | 2248.3 | 2249.2 | 5494.0 |
| 2023-12-17 21:00:00 | GC | Futures | 2249.1 | 2253.5 | 2248.9 | 2251.9 | 2299.0 |
| 2023-12-17 22:00:00 | GC | Futures | 2252.0 | 2254.4 | 2251.3 | 2253.0 | 2384.0 |
| 2023-12-17 23:00:00 | GC | Futures | 2252.8 | 2253.4 | 2251.4 | 2253.2 | 1092.0 |
| 2023-12-17 18:00:00 | ZN | Futures | 114.033611 | 114.033611 | 113.970251 | 113.986091 | 11304.0 |
| 2023-12-17 19:00:00 | ZN | Futures | 113.986091 | 114.001931 | 113.92273 | 113.986091 | 14360.0 |
| 2023-12-17 20:00:00 | ZN | Futures | 113.986091 | 114.017771 | 113.93857 | 114.001931 | 8600.0 |
| 2023-12-17 21:00:00 | ZN | Futures | 114.001931 | 114.033611 | 113.970251 | 113.986091 | 5902.0 |
| 2023-12-17 22:00:00 | ZN | Futures | 113.986091 | 114.065292 | 113.986091 | 114.017771 | 7378.0 |
| 2023-12-17 23:00:00 | ZN | Futures | 114.017771 | 114.112812 | 114.017771 | 114.096972 | 6091.0 |
> showing 36 of 428 rows — these rows as CSV