PREVIEW / futures_1hour / 2024-05-05
file: by_date/futures_1hour/2024/2024-05-05.parquet size: 19 KB rows: 430
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-05-05 18:00:00 | ES | Futures | 5482.87 | 5486.05 | 5478.09 | 5479.42 | 6212.0 |
| 2024-05-05 19:00:00 | ES | Futures | 5479.42 | 5480.74 | 5474.38 | 5474.91 | 4579.0 |
| 2024-05-05 20:00:00 | ES | Futures | 5475.17 | 5477.03 | 5471.46 | 5474.91 | 10256.0 |
| 2024-05-05 21:00:00 | ES | Futures | 5474.64 | 5476.5 | 5473.58 | 5476.5 | 4656.0 |
| 2024-05-05 22:00:00 | ES | Futures | 5476.5 | 5476.76 | 5474.11 | 5474.64 | 3259.0 |
| 2024-05-05 23:00:00 | ES | Futures | 5474.38 | 5476.23 | 5473.05 | 5475.44 | 3518.0 |
| 2024-05-05 18:00:00 | NQ | Futures | 19311.12 | 19328.5 | 19288.11 | 19294.53 | 4157.0 |
| 2024-05-05 19:00:00 | NQ | Futures | 19294.53 | 19296.4 | 19261.09 | 19265.64 | 3869.0 |
| 2024-05-05 20:00:00 | NQ | Futures | 19265.64 | 19275.81 | 19254.94 | 19266.71 | 3940.0 |
| 2024-05-05 21:00:00 | NQ | Futures | 19266.71 | 19273.13 | 19259.49 | 19272.06 | 2504.0 |
| 2024-05-05 22:00:00 | NQ | Futures | 19272.6 | 19275.81 | 19264.84 | 19266.18 | 1500.0 |
| 2024-05-05 23:00:00 | NQ | Futures | 19265.91 | 19268.58 | 19258.69 | 19266.18 | 1346.0 |
| 2024-05-05 18:00:00 | YM | Futures | 41321.5 | 41322.5 | 41281.1 | 41298.1 | 657.0 |
| 2024-05-05 19:00:00 | YM | Futures | 41298.1 | 41305.5 | 41268.4 | 41271.6 | 514.0 |
| 2024-05-05 20:00:00 | YM | Futures | 41274.7 | 41285.4 | 41245.0 | 41260.9 | 979.0 |
| 2024-05-05 21:00:00 | YM | Futures | 41260.9 | 41273.7 | 41255.6 | 41268.4 | 545.0 |
| 2024-05-05 22:00:00 | YM | Futures | 41268.4 | 41276.9 | 41265.2 | 41267.3 | 360.0 |
| 2024-05-05 23:00:00 | YM | Futures | 41264.1 | 41273.7 | 41256.7 | 41269.4 | 279.0 |
| 2024-05-05 18:00:00 | CL | Futures | 66.12 | 66.48 | 66.0 | 66.41 | 3629.0 |
| 2024-05-05 19:00:00 | CL | Futures | 66.41 | 66.45 | 66.29 | 66.3 | 1203.0 |
| 2024-05-05 20:00:00 | CL | Futures | 66.29 | 66.32 | 66.01 | 66.21 | 3195.0 |
| 2024-05-05 21:00:00 | CL | Futures | 66.2 | 66.49 | 66.16 | 66.32 | 6094.0 |
| 2024-05-05 22:00:00 | CL | Futures | 66.32 | 66.42 | 66.25 | 66.27 | 1724.0 |
| 2024-05-05 23:00:00 | CL | Futures | 66.26 | 66.35 | 66.22 | 66.31 | 1145.0 |
| 2024-05-05 18:00:00 | GC | Futures | 2509.8 | 2511.7 | 2505.8 | 2507.4 | 1622.0 |
| 2024-05-05 19:00:00 | GC | Futures | 2507.5 | 2508.6 | 2498.1 | 2498.8 | 5720.0 |
| 2024-05-05 20:00:00 | GC | Futures | 2498.8 | 2503.5 | 2496.5 | 2501.2 | 7291.0 |
| 2024-05-05 21:00:00 | GC | Futures | 2501.1 | 2515.6 | 2500.6 | 2514.7 | 10342.0 |
| 2024-05-05 22:00:00 | GC | Futures | 2514.7 | 2522.4 | 2513.7 | 2517.7 | 6312.0 |
| 2024-05-05 23:00:00 | GC | Futures | 2517.6 | 2518.6 | 2514.4 | 2515.6 | 2028.0 |
| 2024-05-05 18:00:00 | ZN | Futures | 109.631692 | 109.663186 | 109.58445 | 109.647439 | 7488.0 |
| 2024-05-05 19:00:00 | ZN | Futures | 109.647439 | 109.647439 | 109.568703 | 109.568703 | 6352.0 |
| 2024-05-05 20:00:00 | ZN | Futures | 109.568703 | 109.647439 | 109.568703 | 109.631692 | 7566.0 |
| 2024-05-05 21:00:00 | ZN | Futures | 109.631692 | 109.663186 | 109.600198 | 109.615945 | 10906.0 |
| 2024-05-05 22:00:00 | ZN | Futures | 109.615945 | 109.663186 | 109.600198 | 109.647439 | 8341.0 |
| 2024-05-05 23:00:00 | ZN | Futures | 109.631692 | 109.663186 | 109.615945 | 109.647439 | 4689.0 |
> showing 36 of 430 rows — these rows as CSV