PREVIEW / futures_1hour / 2024-05-12
file: by_date/futures_1hour/2024/2024-05-12.parquet size: 19 KB rows: 421
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-12 18:00:00 | ES | Futures | 5561.13 | 5564.31 | 5560.33 | 5563.52 | 4847.0 |
| 2024-05-12 19:00:00 | ES | Futures | 5563.78 | 5565.11 | 5562.72 | 5563.52 | 1934.0 |
| 2024-05-12 20:00:00 | ES | Futures | 5563.78 | 5566.17 | 5561.92 | 5565.9 | 4670.0 |
| 2024-05-12 21:00:00 | ES | Futures | 5565.9 | 5566.43 | 5564.31 | 5566.43 | 3244.0 |
| 2024-05-12 22:00:00 | ES | Futures | 5566.17 | 5566.7 | 5564.58 | 5564.84 | 3020.0 |
| 2024-05-12 23:00:00 | ES | Futures | 5564.84 | 5571.21 | 5564.05 | 5570.15 | 6992.0 |
| 2024-05-12 18:00:00 | NQ | Futures | 19514.95 | 19527.26 | 19505.06 | 19524.05 | 2801.0 |
| 2024-05-12 19:00:00 | NQ | Futures | 19525.12 | 19532.88 | 19518.16 | 19523.25 | 1836.0 |
| 2024-05-12 20:00:00 | NQ | Futures | 19522.98 | 19537.42 | 19514.95 | 19536.62 | 3672.0 |
| 2024-05-12 21:00:00 | NQ | Futures | 19536.89 | 19542.24 | 19531.27 | 19538.76 | 2688.0 |
| 2024-05-12 22:00:00 | NQ | Futures | 19538.76 | 19540.37 | 19532.88 | 19534.48 | 1557.0 |
| 2024-05-12 23:00:00 | NQ | Futures | 19534.21 | 19559.36 | 19529.93 | 19558.02 | 3559.0 |
| 2024-05-12 18:00:00 | YM | Futures | 42064.6 | 42079.5 | 42017.9 | 42070.0 | 1114.0 |
| 2024-05-12 19:00:00 | YM | Futures | 42071.0 | 42080.6 | 42068.9 | 42076.3 | 335.0 |
| 2024-05-12 20:00:00 | YM | Futures | 42077.4 | 42083.8 | 42061.5 | 42079.5 | 544.0 |
| 2024-05-12 21:00:00 | YM | Futures | 42078.4 | 42084.8 | 42072.1 | 42079.5 | 406.0 |
| 2024-05-12 22:00:00 | YM | Futures | 42080.6 | 42084.8 | 42061.5 | 42065.7 | 397.0 |
| 2024-05-12 23:00:00 | YM | Futures | 42064.6 | 42099.7 | 42061.5 | 42083.8 | 968.0 |
| 2024-05-12 18:00:00 | CL | Futures | 66.14 | 66.14 | 65.97 | 66.0 | 1700.0 |
| 2024-05-12 19:00:00 | CL | Futures | 66.01 | 66.06 | 66.0 | 66.05 | 490.0 |
| 2024-05-12 20:00:00 | CL | Futures | 66.05 | 66.12 | 65.99 | 66.02 | 1143.0 |
| 2024-05-12 21:00:00 | CL | Futures | 66.01 | 66.01 | 65.8 | 65.81 | 3353.0 |
| 2024-05-12 22:00:00 | CL | Futures | 65.81 | 66.08 | 65.81 | 66.07 | 1592.0 |
| 2024-05-12 23:00:00 | CL | Futures | 66.06 | 66.09 | 65.99 | 66.04 | 1106.0 |
| 2024-05-12 18:00:00 | GC | Futures | 2570.8 | 2572.4 | 2568.0 | 2569.4 | 3025.0 |
| 2024-05-12 19:00:00 | GC | Futures | 2569.4 | 2570.5 | 2567.3 | 2568.1 | 2153.0 |
| 2024-05-12 20:00:00 | GC | Futures | 2568.1 | 2572.7 | 2567.6 | 2572.1 | 3060.0 |
| 2024-05-12 21:00:00 | GC | Futures | 2572.1 | 2572.4 | 2562.2 | 2566.9 | 5870.0 |
| 2024-05-12 22:00:00 | GC | Futures | 2567.0 | 2567.6 | 2565.1 | 2566.7 | 2465.0 |
| 2024-05-12 23:00:00 | GC | Futures | 2566.7 | 2567.3 | 2563.8 | 2564.8 | 1642.0 |
| 2024-05-12 18:00:00 | ZN | Futures | 109.58445 | 109.600198 | 109.568703 | 109.600198 | 5681.0 |
| 2024-05-12 19:00:00 | ZN | Futures | 109.600198 | 109.631692 | 109.58445 | 109.631692 | 4717.0 |
| 2024-05-12 20:00:00 | ZN | Futures | 109.631692 | 109.647439 | 109.615945 | 109.647439 | 14730.0 |
| 2024-05-12 21:00:00 | ZN | Futures | 109.631692 | 109.631692 | 109.58445 | 109.600198 | 11766.0 |
| 2024-05-12 22:00:00 | ZN | Futures | 109.615945 | 109.615945 | 109.600198 | 109.615945 | 3970.0 |
| 2024-05-12 23:00:00 | ZN | Futures | 109.615945 | 109.631692 | 109.600198 | 109.600198 | 8821.0 |
> showing 36 of 421 rows — these rows as CSV