PREVIEW / futures_1hour / 2024-01-07
file: by_date/futures_1hour/2024/2024-01-07.parquet size: 20 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-01-07 18:00:00 | ES | Futures | 5087.91 | 5094.09 | 5085.49 | 5091.4 | 8937.0 |
| 2024-01-07 19:00:00 | ES | Futures | 5091.13 | 5095.16 | 5091.13 | 5093.82 | 4802.0 |
| 2024-01-07 20:00:00 | ES | Futures | 5093.82 | 5095.97 | 5088.18 | 5088.72 | 7702.0 |
| 2024-01-07 21:00:00 | ES | Futures | 5088.45 | 5088.45 | 5084.96 | 5086.84 | 6587.0 |
| 2024-01-07 22:00:00 | ES | Futures | 5087.11 | 5087.11 | 5082.0 | 5083.08 | 6239.0 |
| 2024-01-07 23:00:00 | ES | Futures | 5082.81 | 5084.69 | 5082.0 | 5084.15 | 2230.0 |
| 2024-01-07 18:00:00 | NQ | Futures | 17867.03 | 17888.72 | 17854.82 | 17880.86 | 5940.0 |
| 2024-01-07 19:00:00 | NQ | Futures | 17880.32 | 17897.13 | 17880.04 | 17892.25 | 3675.0 |
| 2024-01-07 20:00:00 | NQ | Futures | 17891.71 | 17899.84 | 17864.86 | 17866.21 | 4617.0 |
| 2024-01-07 21:00:00 | NQ | Futures | 17865.94 | 17865.94 | 17852.92 | 17857.26 | 4075.0 |
| 2024-01-07 22:00:00 | NQ | Futures | 17858.08 | 17859.43 | 17832.31 | 17835.84 | 4681.0 |
| 2024-01-07 23:00:00 | NQ | Futures | 17835.84 | 17845.87 | 17833.67 | 17843.7 | 2213.0 |
| 2024-01-07 18:00:00 | YM | Futures | 40464.8 | 40502.4 | 40442.2 | 40462.7 | 2663.0 |
| 2024-01-07 19:00:00 | YM | Futures | 40460.5 | 40476.6 | 40445.5 | 40450.8 | 1340.0 |
| 2024-01-07 20:00:00 | YM | Futures | 40450.8 | 40454.1 | 40375.7 | 40379.9 | 1650.0 |
| 2024-01-07 21:00:00 | YM | Futures | 40379.9 | 40385.3 | 40353.1 | 40381.0 | 1359.0 |
| 2024-01-07 22:00:00 | YM | Futures | 40378.9 | 40379.9 | 40349.9 | 40356.3 | 695.0 |
| 2024-01-07 23:00:00 | YM | Futures | 40356.3 | 40373.5 | 40352.0 | 40372.4 | 349.0 |
| 2024-01-07 18:00:00 | CL | Futures | 61.46 | 61.83 | 61.28 | 61.69 | 2995.0 |
| 2024-01-07 19:00:00 | CL | Futures | 61.68 | 61.74 | 61.56 | 61.63 | 1524.0 |
| 2024-01-07 20:00:00 | CL | Futures | 61.63 | 61.64 | 61.3 | 61.31 | 3774.0 |
| 2024-01-07 21:00:00 | CL | Futures | 61.31 | 61.33 | 60.95 | 60.98 | 4175.0 |
| 2024-01-07 22:00:00 | CL | Futures | 60.99 | 61.04 | 60.91 | 61.01 | 2532.0 |
| 2024-01-07 23:00:00 | CL | Futures | 61.01 | 61.02 | 60.87 | 60.89 | 1921.0 |
| 2024-01-07 18:00:00 | GC | Futures | 2270.8 | 2270.8 | 2267.7 | 2269.1 | 2626.0 |
| 2024-01-07 19:00:00 | GC | Futures | 2269.1 | 2271.2 | 2268.6 | 2270.7 | 1571.0 |
| 2024-01-07 20:00:00 | GC | Futures | 2270.8 | 2271.6 | 2267.2 | 2268.1 | 3623.0 |
| 2024-01-07 21:00:00 | GC | Futures | 2268.1 | 2268.3 | 2265.4 | 2265.5 | 4548.0 |
| 2024-01-07 22:00:00 | GC | Futures | 2265.4 | 2265.7 | 2258.7 | 2260.1 | 4965.0 |
| 2024-01-07 23:00:00 | GC | Futures | 2260.0 | 2261.7 | 2259.3 | 2259.4 | 2423.0 |
| 2024-01-07 18:00:00 | ZN | Futures | 113.257442 | 113.257442 | 113.019839 | 113.083199 | 18908.0 |
| 2024-01-07 19:00:00 | ZN | Futures | 113.083199 | 113.14656 | 113.083199 | 113.11488 | 10221.0 |
| 2024-01-07 20:00:00 | ZN | Futures | 113.11488 | 113.178241 | 113.11488 | 113.178241 | 12528.0 |
| 2024-01-07 21:00:00 | ZN | Futures | 113.1624 | 113.1624 | 113.11488 | 113.11488 | 5828.0 |
| 2024-01-07 22:00:00 | ZN | Futures | 113.13072 | 113.14656 | 113.051519 | 113.067359 | 10097.0 |
| 2024-01-07 23:00:00 | ZN | Futures | 113.067359 | 113.083199 | 113.051519 | 113.083199 | 7142.0 |
> showing 36 of 443 rows — these rows as CSV