PREVIEW / futures_1hour / 2024-12-29
file: by_date/futures_1hour/2024/2024-12-29.parquet size: 19 KB rows: 443
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-12-29 18:00:00 | ES | Futures | 6182.55 | 6190.24 | 6171.01 | 6178.44 | 10837.0 |
| 2024-12-29 19:00:00 | ES | Futures | 6178.44 | 6181.01 | 6171.78 | 6178.19 | 7056.0 |
| 2024-12-29 20:00:00 | ES | Futures | 6177.93 | 6180.49 | 6172.8 | 6179.21 | 4889.0 |
| 2024-12-29 21:00:00 | ES | Futures | 6178.96 | 6178.96 | 6173.06 | 6174.09 | 3169.0 |
| 2024-12-29 22:00:00 | ES | Futures | 6174.09 | 6174.09 | 6169.21 | 6170.75 | 4006.0 |
| 2024-12-29 23:00:00 | ES | Futures | 6170.75 | 6173.32 | 6168.7 | 6171.27 | 2942.0 |
| 2024-12-29 18:00:00 | NQ | Futures | 22349.02 | 22381.7 | 22307.32 | 22340.78 | 6944.0 |
| 2024-12-29 19:00:00 | NQ | Futures | 22338.72 | 22360.08 | 22310.67 | 22348.5 | 3442.0 |
| 2024-12-29 20:00:00 | NQ | Futures | 22348.24 | 22350.82 | 22316.07 | 22347.73 | 3156.0 |
| 2024-12-29 21:00:00 | NQ | Futures | 22345.67 | 22349.53 | 22322.51 | 22326.63 | 1934.0 |
| 2024-12-29 22:00:00 | NQ | Futures | 22326.37 | 22331.0 | 22311.19 | 22317.36 | 1878.0 |
| 2024-12-29 23:00:00 | NQ | Futures | 22317.36 | 22333.06 | 22311.44 | 22326.11 | 1690.0 |
| 2024-12-29 18:00:00 | YM | Futures | 44567.2 | 44650.6 | 44530.2 | 44575.5 | 1487.0 |
| 2024-12-29 19:00:00 | YM | Futures | 44572.4 | 44579.6 | 44537.4 | 44556.9 | 566.0 |
| 2024-12-29 20:00:00 | YM | Futures | 44555.9 | 44584.7 | 44534.3 | 44575.5 | 671.0 |
| 2024-12-29 21:00:00 | YM | Futures | 44574.4 | 44574.4 | 44540.5 | 44545.6 | 415.0 |
| 2024-12-29 22:00:00 | YM | Futures | 44542.5 | 44550.8 | 44518.8 | 44528.1 | 516.0 |
| 2024-12-29 23:00:00 | YM | Futures | 44528.1 | 44543.5 | 44513.7 | 44528.1 | 314.0 |
| 2024-12-29 18:00:00 | CL | Futures | 63.96 | 64.04 | 63.69 | 63.98 | 2728.0 |
| 2024-12-29 19:00:00 | CL | Futures | 63.99 | 64.02 | 63.92 | 64.01 | 682.0 |
| 2024-12-29 20:00:00 | CL | Futures | 64.01 | 64.25 | 63.96 | 64.25 | 2193.0 |
| 2024-12-29 21:00:00 | CL | Futures | 64.24 | 64.26 | 64.14 | 64.15 | 1174.0 |
| 2024-12-29 22:00:00 | CL | Futures | 64.16 | 64.18 | 64.12 | 64.17 | 564.0 |
| 2024-12-29 23:00:00 | CL | Futures | 64.18 | 64.22 | 64.13 | 64.21 | 725.0 |
| 2024-12-29 18:00:00 | GC | Futures | 2750.5 | 2755.1 | 2747.9 | 2753.2 | 1856.0 |
| 2024-12-29 19:00:00 | GC | Futures | 2753.4 | 2754.4 | 2749.8 | 2751.0 | 1243.0 |
| 2024-12-29 20:00:00 | GC | Futures | 2750.9 | 2754.8 | 2750.2 | 2752.2 | 2356.0 |
| 2024-12-29 21:00:00 | GC | Futures | 2752.0 | 2753.2 | 2750.0 | 2751.1 | 1740.0 |
| 2024-12-29 22:00:00 | GC | Futures | 2751.3 | 2755.3 | 2750.2 | 2754.5 | 1902.0 |
| 2024-12-29 23:00:00 | GC | Futures | 2754.4 | 2754.4 | 2748.6 | 2749.2 | 1676.0 |
| 2024-12-29 18:00:00 | ZN | Futures | 108.498453 | 108.52972 | 108.435917 | 108.435917 | 10113.0 |
| 2024-12-29 19:00:00 | ZN | Futures | 108.451551 | 108.498453 | 108.435917 | 108.498453 | 9634.0 |
| 2024-12-29 20:00:00 | ZN | Futures | 108.498453 | 108.514086 | 108.482819 | 108.482819 | 4784.0 |
| 2024-12-29 21:00:00 | ZN | Futures | 108.482819 | 108.514086 | 108.451551 | 108.467185 | 5602.0 |
| 2024-12-29 22:00:00 | ZN | Futures | 108.451551 | 108.498453 | 108.435917 | 108.498453 | 4326.0 |
| 2024-12-29 23:00:00 | ZN | Futures | 108.482819 | 108.514086 | 108.467185 | 108.514086 | 6459.0 |
> showing 36 of 443 rows — these rows as CSV