PREVIEW / futures_1hour / 2023-07-16
file: by_date/futures_1hour/2023/2023-07-16.parquet size: 18 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-07-16 18:00:00 | ES | Futures | 4980.73 | 4981.01 | 4973.87 | 4974.42 | 6961.0 |
| 2023-07-16 19:00:00 | ES | Futures | 4974.7 | 4974.97 | 4971.95 | 4973.32 | 4539.0 |
| 2023-07-16 20:00:00 | ES | Futures | 4973.32 | 4976.34 | 4972.22 | 4974.97 | 5065.0 |
| 2023-07-16 21:00:00 | ES | Futures | 4975.24 | 4979.36 | 4974.42 | 4976.34 | 5578.0 |
| 2023-07-16 22:00:00 | ES | Futures | 4976.07 | 4978.54 | 4974.15 | 4976.89 | 3807.0 |
| 2023-07-16 23:00:00 | ES | Futures | 4976.89 | 4977.99 | 4976.34 | 4976.89 | 2326.0 |
| 2023-07-16 18:00:00 | NQ | Futures | 17455.51 | 17455.79 | 17438.82 | 17442.44 | 4337.0 |
| 2023-07-16 19:00:00 | NQ | Futures | 17442.16 | 17446.61 | 17423.8 | 17429.64 | 3290.0 |
| 2023-07-16 20:00:00 | NQ | Futures | 17429.64 | 17445.78 | 17424.92 | 17439.66 | 3288.0 |
| 2023-07-16 21:00:00 | NQ | Futures | 17439.94 | 17454.68 | 17433.26 | 17441.88 | 3789.0 |
| 2023-07-16 22:00:00 | NQ | Futures | 17441.33 | 17451.62 | 17430.2 | 17443.83 | 2759.0 |
| 2023-07-16 23:00:00 | NQ | Futures | 17444.11 | 17449.39 | 17437.15 | 17441.6 | 1907.0 |
| 2023-07-16 18:00:00 | YM | Futures | 37957.4 | 37996.8 | 37922.3 | 37924.5 | 1139.0 |
| 2023-07-16 19:00:00 | YM | Futures | 37926.7 | 37933.3 | 37912.4 | 37928.9 | 574.0 |
| 2023-07-16 20:00:00 | YM | Futures | 37928.9 | 37948.6 | 37910.2 | 37944.2 | 1202.0 |
| 2023-07-16 21:00:00 | YM | Futures | 37944.2 | 37977.1 | 37940.9 | 37955.2 | 937.0 |
| 2023-07-16 22:00:00 | YM | Futures | 37955.2 | 37968.3 | 37940.9 | 37957.4 | 677.0 |
| 2023-07-16 23:00:00 | YM | Futures | 37958.5 | 37967.2 | 37953.0 | 37962.8 | 414.0 |
| 2023-07-16 18:00:00 | CL | Futures | 60.9 | 61.04 | 60.61 | 60.82 | 2468.0 |
| 2023-07-16 19:00:00 | CL | Futures | 60.82 | 60.86 | 60.74 | 60.84 | 492.0 |
| 2023-07-16 20:00:00 | CL | Futures | 60.84 | 60.89 | 60.81 | 60.85 | 795.0 |
| 2023-07-16 21:00:00 | CL | Futures | 60.87 | 60.99 | 60.64 | 60.7 | 2275.0 |
| 2023-07-16 22:00:00 | CL | Futures | 60.69 | 60.77 | 60.66 | 60.69 | 766.0 |
| 2023-07-16 23:00:00 | CL | Futures | 60.7 | 60.76 | 60.69 | 60.74 | 584.0 |
| 2023-07-16 18:00:00 | GC | Futures | 2231.1 | 2232.8 | 2229.4 | 2229.5 | 1522.0 |
| 2023-07-16 19:00:00 | GC | Futures | 2229.6 | 2230.1 | 2227.7 | 2230.0 | 1854.0 |
| 2023-07-16 20:00:00 | GC | Futures | 2230.0 | 2231.4 | 2228.7 | 2231.3 | 2627.0 |
| 2023-07-16 21:00:00 | GC | Futures | 2231.2 | 2232.7 | 2227.9 | 2228.7 | 3426.0 |
| 2023-07-16 22:00:00 | GC | Futures | 2228.6 | 2230.3 | 2227.2 | 2229.7 | 2465.0 |
| 2023-07-16 23:00:00 | GC | Futures | 2229.8 | 2230.0 | 2226.4 | 2228.0 | 2084.0 |
| 2023-07-16 18:00:00 | ZN | Futures | 114.6503 | 114.761828 | 114.6503 | 114.729963 | 6597.0 |
| 2023-07-16 19:00:00 | ZN | Futures | 114.729963 | 114.761828 | 114.71403 | 114.745895 | 2154.0 |
| 2023-07-16 20:00:00 | ZN | Futures | 114.729963 | 114.809625 | 114.71403 | 114.809625 | 6787.0 |
| 2023-07-16 21:00:00 | ZN | Futures | 114.793693 | 114.825558 | 114.77776 | 114.793693 | 5802.0 |
| 2023-07-16 22:00:00 | ZN | Futures | 114.809625 | 114.841491 | 114.793693 | 114.825558 | 4028.0 |
| 2023-07-16 23:00:00 | ZN | Futures | 114.825558 | 114.825558 | 114.793693 | 114.793693 | 2523.0 |
> showing 36 of 405 rows — these rows as CSV