PREVIEW / futures_1hour / 2023-10-22
file: by_date/futures_1hour/2023/2023-10-22.parquet size: 19 KB rows: 405
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-10-22 18:00:00 | ES | Futures | 4623.28 | 4627.9 | 4614.32 | 4626.0 | 19090.0 |
| 2023-10-22 19:00:00 | ES | Futures | 4626.0 | 4628.98 | 4624.1 | 4628.71 | 5811.0 |
| 2023-10-22 20:00:00 | ES | Futures | 4628.44 | 4628.98 | 4622.47 | 4626.0 | 8922.0 |
| 2023-10-22 21:00:00 | ES | Futures | 4626.0 | 4628.44 | 4623.82 | 4626.81 | 6699.0 |
| 2023-10-22 22:00:00 | ES | Futures | 4626.54 | 4627.08 | 4620.29 | 4620.29 | 5640.0 |
| 2023-10-22 23:00:00 | ES | Futures | 4620.57 | 4625.45 | 4620.57 | 4622.19 | 5681.0 |
| 2023-10-22 18:00:00 | NQ | Futures | 16128.28 | 16156.3 | 16109.05 | 16149.98 | 7552.0 |
| 2023-10-22 19:00:00 | NQ | Futures | 16149.98 | 16162.07 | 16142.29 | 16160.97 | 3119.0 |
| 2023-10-22 20:00:00 | NQ | Futures | 16160.97 | 16164.26 | 16138.99 | 16156.02 | 4973.0 |
| 2023-10-22 21:00:00 | NQ | Futures | 16156.3 | 16167.83 | 16147.51 | 16161.24 | 4620.0 |
| 2023-10-22 22:00:00 | NQ | Futures | 16160.97 | 16163.44 | 16132.4 | 16133.23 | 4710.0 |
| 2023-10-22 23:00:00 | NQ | Futures | 16134.05 | 16148.61 | 16134.05 | 16139.27 | 3006.0 |
| 2023-10-22 18:00:00 | YM | Futures | 36122.5 | 36156.2 | 36056.4 | 36141.0 | 2313.0 |
| 2023-10-22 19:00:00 | YM | Futures | 36139.9 | 36163.8 | 36132.3 | 36160.5 | 869.0 |
| 2023-10-22 20:00:00 | YM | Futures | 36159.4 | 36163.8 | 36121.5 | 36136.6 | 1286.0 |
| 2023-10-22 21:00:00 | YM | Futures | 36137.7 | 36152.9 | 36123.6 | 36142.1 | 830.0 |
| 2023-10-22 22:00:00 | YM | Futures | 36141.0 | 36144.2 | 36103.0 | 36104.1 | 924.0 |
| 2023-10-22 23:00:00 | YM | Futures | 36105.2 | 36134.5 | 36103.0 | 36112.8 | 902.0 |
| 2023-10-22 18:00:00 | CL | Futures | 73.85 | 74.09 | 73.65 | 73.66 | 3290.0 |
| 2023-10-22 19:00:00 | CL | Futures | 73.67 | 73.77 | 73.52 | 73.63 | 1321.0 |
| 2023-10-22 20:00:00 | CL | Futures | 73.62 | 73.78 | 73.35 | 73.39 | 2708.0 |
| 2023-10-22 21:00:00 | CL | Futures | 73.38 | 73.4 | 73.04 | 73.26 | 4983.0 |
| 2023-10-22 22:00:00 | CL | Futures | 73.26 | 73.36 | 73.1 | 73.13 | 2174.0 |
| 2023-10-22 23:00:00 | CL | Futures | 73.15 | 73.31 | 73.1 | 73.12 | 1355.0 |
| 2023-10-22 18:00:00 | GC | Futures | 2220.2 | 2222.6 | 2201.5 | 2220.1 | 6281.0 |
| 2023-10-22 19:00:00 | GC | Futures | 2220.2 | 2222.2 | 2212.9 | 2214.7 | 3479.0 |
| 2023-10-22 20:00:00 | GC | Futures | 2214.6 | 2216.8 | 2206.6 | 2208.7 | 6883.0 |
| 2023-10-22 21:00:00 | GC | Futures | 2208.8 | 2211.5 | 2206.6 | 2209.5 | 6001.0 |
| 2023-10-22 22:00:00 | GC | Futures | 2209.4 | 2217.8 | 2209.2 | 2215.9 | 5411.0 |
| 2023-10-22 23:00:00 | GC | Futures | 2215.8 | 2218.6 | 2214.8 | 2217.1 | 3965.0 |
| 2023-10-22 18:00:00 | ZN | Futures | 107.434904 | 107.498381 | 107.355558 | 107.450773 | 21308.0 |
| 2023-10-22 19:00:00 | ZN | Futures | 107.450773 | 107.51425 | 107.403166 | 107.403166 | 11610.0 |
| 2023-10-22 20:00:00 | ZN | Futures | 107.419035 | 107.53012 | 107.419035 | 107.434904 | 15640.0 |
| 2023-10-22 21:00:00 | ZN | Futures | 107.434904 | 107.466643 | 107.339689 | 107.355558 | 17769.0 |
| 2023-10-22 22:00:00 | ZN | Futures | 107.355558 | 107.371427 | 107.244473 | 107.244473 | 22136.0 |
| 2023-10-22 23:00:00 | ZN | Futures | 107.260342 | 107.292081 | 107.180996 | 107.228604 | 23845.0 |
> showing 36 of 405 rows — these rows as CSV