PREVIEW / futures_1hour / 2022-12-26
file: by_date/futures_1hour/2022/2022-12-26.parquet size: 18 KB rows: 381
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-26 18:00:00 | ES | Futures | 4337.26 | 4356.55 | 4336.14 | 4354.87 | 12548.0 |
| 2022-12-26 19:00:00 | ES | Futures | 4354.87 | 4355.71 | 4349.84 | 4351.52 | 6212.0 |
| 2022-12-26 20:00:00 | ES | Futures | 4351.52 | 4361.3 | 4350.96 | 4360.46 | 8251.0 |
| 2022-12-26 21:00:00 | ES | Futures | 4360.46 | 4362.42 | 4358.51 | 4359.63 | 5316.0 |
| 2022-12-26 22:00:00 | ES | Futures | 4359.63 | 4359.9 | 4354.31 | 4354.87 | 4033.0 |
| 2022-12-26 23:00:00 | ES | Futures | 4354.59 | 4356.55 | 4353.19 | 4356.27 | 2107.0 |
| 2022-12-26 18:00:00 | NQ | Futures | 12636.09 | 12703.8 | 12636.09 | 12696.4 | 5357.0 |
| 2022-12-26 19:00:00 | NQ | Futures | 12696.4 | 12702.38 | 12682.46 | 12687.01 | 2770.0 |
| 2022-12-26 20:00:00 | NQ | Futures | 12686.16 | 12725.99 | 12684.74 | 12722.57 | 4485.0 |
| 2022-12-26 21:00:00 | NQ | Futures | 12722.29 | 12726.84 | 12713.47 | 12720.58 | 2163.0 |
| 2022-12-26 22:00:00 | NQ | Futures | 12720.87 | 12722.01 | 12700.38 | 12702.09 | 2131.0 |
| 2022-12-26 23:00:00 | NQ | Futures | 12701.24 | 12705.5 | 12693.27 | 12703.23 | 1499.0 |
| 2022-12-26 18:00:00 | YM | Futures | 37212.6 | 37376.3 | 37212.6 | 37366.3 | 2081.0 |
| 2022-12-26 19:00:00 | YM | Futures | 37365.2 | 37371.9 | 37328.4 | 37339.6 | 752.0 |
| 2022-12-26 20:00:00 | YM | Futures | 37338.5 | 37407.5 | 37335.1 | 37399.7 | 1303.0 |
| 2022-12-26 21:00:00 | YM | Futures | 37399.7 | 37413.1 | 37384.1 | 37395.3 | 966.0 |
| 2022-12-26 22:00:00 | YM | Futures | 37395.3 | 37396.4 | 37359.6 | 37363.0 | 600.0 |
| 2022-12-26 23:00:00 | YM | Futures | 37364.1 | 37374.1 | 37352.9 | 37370.8 | 394.0 |
| 2022-12-26 18:00:00 | CL | Futures | 65.39 | 66.34 | 65.39 | 66.26 | 4732.0 |
| 2022-12-26 19:00:00 | CL | Futures | 66.27 | 66.27 | 65.8 | 65.82 | 1707.0 |
| 2022-12-26 20:00:00 | CL | Futures | 65.82 | 65.9 | 65.53 | 65.86 | 4684.0 |
| 2022-12-26 21:00:00 | CL | Futures | 65.86 | 65.91 | 65.68 | 65.75 | 1529.0 |
| 2022-12-26 22:00:00 | CL | Futures | 65.75 | 65.75 | 65.41 | 65.46 | 2020.0 |
| 2022-12-26 23:00:00 | CL | Futures | 65.46 | 65.57 | 65.34 | 65.56 | 1393.0 |
| 2022-12-26 18:00:00 | GC | Futures | 2117.9 | 2122.4 | 2117.7 | 2119.7 | 2196.0 |
| 2022-12-26 19:00:00 | GC | Futures | 2119.6 | 2121.5 | 2118.7 | 2119.8 | 1679.0 |
| 2022-12-26 20:00:00 | GC | Futures | 2119.8 | 2123.1 | 2118.2 | 2122.8 | 2723.0 |
| 2022-12-26 21:00:00 | GC | Futures | 2122.8 | 2124.6 | 2121.7 | 2124.5 | 3165.0 |
| 2022-12-26 22:00:00 | GC | Futures | 2124.6 | 2124.6 | 2121.9 | 2122.3 | 1336.0 |
| 2022-12-26 23:00:00 | GC | Futures | 2122.1 | 2123.3 | 2121.3 | 2122.8 | 915.0 |
| 2022-12-26 18:00:00 | ZN | Futures | 116.598134 | 116.61423 | 116.517655 | 116.549846 | 5218.0 |
| 2022-12-26 19:00:00 | ZN | Futures | 116.53375 | 116.61423 | 116.53375 | 116.582038 | 4837.0 |
| 2022-12-26 20:00:00 | ZN | Futures | 116.565942 | 116.582038 | 116.517655 | 116.549846 | 6096.0 |
| 2022-12-26 21:00:00 | ZN | Futures | 116.53375 | 116.582038 | 116.53375 | 116.549846 | 3638.0 |
| 2022-12-26 22:00:00 | ZN | Futures | 116.549846 | 116.549846 | 116.517655 | 116.53375 | 3757.0 |
| 2022-12-26 23:00:00 | ZN | Futures | 116.53375 | 116.549846 | 116.501559 | 116.517655 | 1193.0 |
> showing 36 of 381 rows — these rows as CSV