PREVIEW / futures_1hour / 2024-06-09
file: by_date/futures_1hour/2024/2024-06-09.parquet size: 18 KB rows: 420
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-06-09 18:00:00 | ES | Futures | 5678.92 | 5688.47 | 5675.47 | 5684.49 | 9723.0 |
| 2024-06-09 19:00:00 | ES | Futures | 5684.49 | 5684.49 | 5679.98 | 5680.78 | 3444.0 |
| 2024-06-09 20:00:00 | ES | Futures | 5681.04 | 5684.76 | 5679.19 | 5682.1 | 5978.0 |
| 2024-06-09 21:00:00 | ES | Futures | 5682.37 | 5683.16 | 5680.78 | 5683.16 | 2760.0 |
| 2024-06-09 22:00:00 | ES | Futures | 5682.9 | 5683.43 | 5681.31 | 5682.63 | 2135.0 |
| 2024-06-09 23:00:00 | ES | Futures | 5682.9 | 5686.88 | 5682.9 | 5683.7 | 3960.0 |
| 2024-06-09 18:00:00 | NQ | Futures | 20357.06 | 20394.24 | 20339.94 | 20376.05 | 5006.0 |
| 2024-06-09 19:00:00 | NQ | Futures | 20376.58 | 20376.85 | 20356.25 | 20359.2 | 2151.0 |
| 2024-06-09 20:00:00 | NQ | Futures | 20359.73 | 20373.11 | 20346.36 | 20365.35 | 3606.0 |
| 2024-06-09 21:00:00 | NQ | Futures | 20365.08 | 20373.11 | 20359.73 | 20372.04 | 1880.0 |
| 2024-06-09 22:00:00 | NQ | Futures | 20371.5 | 20374.44 | 20364.81 | 20370.16 | 1750.0 |
| 2024-06-09 23:00:00 | NQ | Futures | 20370.16 | 20384.88 | 20369.63 | 20375.78 | 2133.0 |
| 2024-06-09 18:00:00 | YM | Futures | 41249.3 | 41296.0 | 41218.5 | 41269.4 | 1050.0 |
| 2024-06-09 19:00:00 | YM | Futures | 41269.4 | 41270.5 | 41248.2 | 41250.3 | 639.0 |
| 2024-06-09 20:00:00 | YM | Futures | 41250.3 | 41270.5 | 41235.5 | 41250.3 | 940.0 |
| 2024-06-09 21:00:00 | YM | Futures | 41249.3 | 41253.5 | 41238.6 | 41246.1 | 414.0 |
| 2024-06-09 22:00:00 | YM | Futures | 41247.1 | 41249.3 | 41234.4 | 41244.0 | 327.0 |
| 2024-06-09 23:00:00 | YM | Futures | 41246.1 | 41272.6 | 41242.9 | 41244.0 | 653.0 |
| 2024-06-09 18:00:00 | CL | Futures | 64.15 | 64.29 | 64.05 | 64.15 | 1303.0 |
| 2024-06-09 19:00:00 | CL | Futures | 64.15 | 64.17 | 64.11 | 64.16 | 568.0 |
| 2024-06-09 20:00:00 | CL | Futures | 64.16 | 64.37 | 64.12 | 64.36 | 1678.0 |
| 2024-06-09 21:00:00 | CL | Futures | 64.36 | 64.45 | 64.31 | 64.44 | 1139.0 |
| 2024-06-09 22:00:00 | CL | Futures | 64.44 | 64.49 | 64.41 | 64.48 | 679.0 |
| 2024-06-09 23:00:00 | CL | Futures | 64.48 | 64.62 | 64.48 | 64.5 | 1816.0 |
| 2024-06-09 18:00:00 | GC | Futures | 2481.7 | 2486.6 | 2476.2 | 2485.1 | 4657.0 |
| 2024-06-09 19:00:00 | GC | Futures | 2485.0 | 2488.1 | 2484.1 | 2486.5 | 2230.0 |
| 2024-06-09 20:00:00 | GC | Futures | 2486.5 | 2487.8 | 2481.7 | 2484.8 | 3384.0 |
| 2024-06-09 21:00:00 | GC | Futures | 2484.7 | 2485.7 | 2481.4 | 2485.7 | 2285.0 |
| 2024-06-09 22:00:00 | GC | Futures | 2485.6 | 2489.5 | 2483.3 | 2484.1 | 4011.0 |
| 2024-06-09 23:00:00 | GC | Futures | 2484.0 | 2485.7 | 2482.4 | 2482.9 | 2292.0 |
| 2024-06-09 18:00:00 | ZN | Futures | 109.85215 | 109.867861 | 109.726461 | 109.757883 | 17261.0 |
| 2024-06-09 19:00:00 | ZN | Futures | 109.742172 | 109.773594 | 109.742172 | 109.757883 | 8580.0 |
| 2024-06-09 20:00:00 | ZN | Futures | 109.773594 | 109.820727 | 109.726461 | 109.820727 | 20042.0 |
| 2024-06-09 21:00:00 | ZN | Futures | 109.820727 | 109.820727 | 109.773594 | 109.805016 | 10788.0 |
| 2024-06-09 22:00:00 | ZN | Futures | 109.789305 | 109.820727 | 109.757883 | 109.773594 | 6391.0 |
| 2024-06-09 23:00:00 | ZN | Futures | 109.773594 | 109.789305 | 109.757883 | 109.773594 | 13931.0 |
> showing 36 of 420 rows — these rows as CSV