PREVIEW / futures_1hour / 2023-12-25
file: by_date/futures_1hour/2023/2023-12-25.parquet size: 15 KB rows: 309
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-25 18:00:00 | ES | Futures | 5157.21 | 5169.56 | 5157.21 | 5167.68 | 9892.0 |
| 2023-12-25 19:00:00 | ES | Futures | 5167.68 | 5167.68 | 5163.39 | 5164.73 | 7651.0 |
| 2023-12-25 20:00:00 | ES | Futures | 5164.46 | 5166.61 | 5163.39 | 5166.34 | 3704.0 |
| 2023-12-25 21:00:00 | ES | Futures | 5166.61 | 5166.61 | 5164.46 | 5165.53 | 3224.0 |
| 2023-12-25 22:00:00 | ES | Futures | 5165.53 | 5169.03 | 5165.53 | 5167.41 | 3321.0 |
| 2023-12-25 23:00:00 | ES | Futures | 5167.41 | 5170.1 | 5167.15 | 5169.03 | 2368.0 |
| 2023-12-25 18:00:00 | NQ | Futures | 18403.47 | 18453.91 | 18403.47 | 18446.32 | 5888.0 |
| 2023-12-25 19:00:00 | NQ | Futures | 18445.78 | 18449.03 | 18432.22 | 18438.73 | 3855.0 |
| 2023-12-25 20:00:00 | NQ | Futures | 18438.18 | 18448.49 | 18432.76 | 18447.95 | 2146.0 |
| 2023-12-25 21:00:00 | NQ | Futures | 18447.95 | 18450.39 | 18441.17 | 18448.22 | 1914.0 |
| 2023-12-25 22:00:00 | NQ | Futures | 18448.22 | 18464.49 | 18448.22 | 18459.88 | 2523.0 |
| 2023-12-25 23:00:00 | NQ | Futures | 18460.15 | 18473.17 | 18456.08 | 18465.85 | 1679.0 |
| 2023-12-25 18:00:00 | YM | Futures | 40486.3 | 40593.7 | 40485.2 | 40590.5 | 1707.0 |
| 2023-12-25 19:00:00 | YM | Futures | 40589.4 | 40590.5 | 40560.4 | 40571.1 | 1121.0 |
| 2023-12-25 20:00:00 | YM | Futures | 40572.2 | 40581.9 | 40562.5 | 40579.7 | 414.0 |
| 2023-12-25 21:00:00 | YM | Futures | 40581.9 | 40581.9 | 40562.5 | 40566.8 | 487.0 |
| 2023-12-25 22:00:00 | YM | Futures | 40566.8 | 40585.1 | 40566.8 | 40575.4 | 426.0 |
| 2023-12-25 23:00:00 | YM | Futures | 40576.5 | 40585.1 | 40571.1 | 40580.8 | 371.0 |
| 2023-12-25 18:00:00 | CL | Futures | 61.5 | 61.82 | 61.41 | 61.69 | 2030.0 |
| 2023-12-25 19:00:00 | CL | Futures | 61.69 | 61.69 | 61.53 | 61.54 | 707.0 |
| 2023-12-25 20:00:00 | CL | Futures | 61.53 | 61.74 | 61.41 | 61.61 | 3562.0 |
| 2023-12-25 21:00:00 | CL | Futures | 61.61 | 61.71 | 61.5 | 61.53 | 1362.0 |
| 2023-12-25 22:00:00 | CL | Futures | 61.54 | 61.6 | 61.5 | 61.57 | 541.0 |
| 2023-12-25 23:00:00 | CL | Futures | 61.57 | 61.69 | 61.51 | 61.68 | 816.0 |
| 2023-12-25 18:00:00 | GC | Futures | 2285.6 | 2287.5 | 2284.7 | 2286.3 | 1953.0 |
| 2023-12-25 19:00:00 | GC | Futures | 2286.4 | 2286.7 | 2284.6 | 2286.3 | 1756.0 |
| 2023-12-25 20:00:00 | GC | Futures | 2286.3 | 2295.6 | 2286.3 | 2294.8 | 6070.0 |
| 2023-12-25 21:00:00 | GC | Futures | 2294.9 | 2296.7 | 2293.3 | 2296.1 | 4195.0 |
| 2023-12-25 22:00:00 | GC | Futures | 2296.2 | 2296.7 | 2294.8 | 2295.5 | 1421.0 |
| 2023-12-25 23:00:00 | GC | Futures | 2295.5 | 2296.2 | 2294.9 | 2295.7 | 919.0 |
| 2023-12-25 18:00:00 | ZN | Futures | 114.223694 | 114.239534 | 114.160333 | 114.176173 | 2998.0 |
| 2023-12-25 19:00:00 | ZN | Futures | 114.192013 | 114.255374 | 114.160333 | 114.239534 | 2898.0 |
| 2023-12-25 20:00:00 | ZN | Futures | 114.255374 | 114.287055 | 114.239534 | 114.287055 | 2549.0 |
| 2023-12-25 21:00:00 | ZN | Futures | 114.287055 | 114.302895 | 114.271214 | 114.287055 | 2833.0 |
| 2023-12-25 22:00:00 | ZN | Futures | 114.287055 | 114.287055 | 114.255374 | 114.287055 | 2421.0 |
| 2023-12-25 23:00:00 | ZN | Futures | 114.271214 | 114.287055 | 114.239534 | 114.255374 | 1472.0 |
> showing 36 of 309 rows — these rows as CSV