PREVIEW / futures_1hour / 2023-08-06
file: by_date/futures_1hour/2023/2023-08-06.parquet size: 19 KB rows: 410
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-08-06 18:00:00 | ES | Futures | 4941.75 | 4949.17 | 4941.75 | 4948.62 | 12753.0 |
| 2023-08-06 19:00:00 | ES | Futures | 4948.62 | 4949.44 | 4944.77 | 4948.89 | 6553.0 |
| 2023-08-06 20:00:00 | ES | Futures | 4949.17 | 4955.48 | 4948.62 | 4955.21 | 10396.0 |
| 2023-08-06 21:00:00 | ES | Futures | 4954.93 | 4957.13 | 4951.36 | 4956.58 | 10206.0 |
| 2023-08-06 22:00:00 | ES | Futures | 4956.58 | 4959.32 | 4956.03 | 4958.5 | 6588.0 |
| 2023-08-06 23:00:00 | ES | Futures | 4958.5 | 4959.87 | 4957.4 | 4958.22 | 5227.0 |
| 2023-08-06 18:00:00 | NQ | Futures | 17100.06 | 17131.49 | 17085.87 | 17128.98 | 5895.0 |
| 2023-08-06 19:00:00 | NQ | Futures | 17128.98 | 17136.22 | 17114.24 | 17134.27 | 3474.0 |
| 2023-08-06 20:00:00 | NQ | Futures | 17134.83 | 17171.54 | 17130.65 | 17166.81 | 7871.0 |
| 2023-08-06 21:00:00 | NQ | Futures | 17166.53 | 17175.43 | 17145.12 | 17170.7 | 7527.0 |
| 2023-08-06 22:00:00 | NQ | Futures | 17170.15 | 17182.66 | 17165.7 | 17176.27 | 3525.0 |
| 2023-08-06 23:00:00 | NQ | Futures | 17176.54 | 17181.27 | 17169.87 | 17171.26 | 2760.0 |
| 2023-08-06 18:00:00 | YM | Futures | 38508.4 | 38569.8 | 38497.5 | 38558.8 | 1377.0 |
| 2023-08-06 19:00:00 | YM | Futures | 38559.9 | 38563.2 | 38535.8 | 38554.4 | 680.0 |
| 2023-08-06 20:00:00 | YM | Futures | 38555.5 | 38596.1 | 38552.2 | 38592.8 | 1078.0 |
| 2023-08-06 21:00:00 | YM | Futures | 38591.7 | 38611.4 | 38574.1 | 38604.8 | 1036.0 |
| 2023-08-06 22:00:00 | YM | Futures | 38608.1 | 38626.7 | 38604.8 | 38622.4 | 747.0 |
| 2023-08-06 23:00:00 | YM | Futures | 38622.4 | 38630.0 | 38612.5 | 38621.3 | 634.0 |
| 2023-08-06 18:00:00 | CL | Futures | 67.36 | 67.75 | 67.3 | 67.47 | 4270.0 |
| 2023-08-06 19:00:00 | CL | Futures | 67.47 | 67.53 | 67.4 | 67.48 | 1227.0 |
| 2023-08-06 20:00:00 | CL | Futures | 67.47 | 67.7 | 67.42 | 67.69 | 2830.0 |
| 2023-08-06 21:00:00 | CL | Futures | 67.69 | 67.69 | 67.27 | 67.44 | 4549.0 |
| 2023-08-06 22:00:00 | CL | Futures | 67.44 | 67.45 | 67.27 | 67.31 | 1398.0 |
| 2023-08-06 23:00:00 | CL | Futures | 67.31 | 67.36 | 67.29 | 67.32 | 740.0 |
| 2023-08-06 18:00:00 | GC | Futures | 2208.9 | 2213.5 | 2208.5 | 2209.9 | 3443.0 |
| 2023-08-06 19:00:00 | GC | Futures | 2209.9 | 2210.1 | 2208.8 | 2209.9 | 789.0 |
| 2023-08-06 20:00:00 | GC | Futures | 2210.0 | 2211.8 | 2209.0 | 2210.6 | 1629.0 |
| 2023-08-06 21:00:00 | GC | Futures | 2210.5 | 2210.6 | 2207.1 | 2208.5 | 2219.0 |
| 2023-08-06 22:00:00 | GC | Futures | 2208.6 | 2209.1 | 2206.1 | 2206.8 | 1988.0 |
| 2023-08-06 23:00:00 | GC | Futures | 2206.9 | 2207.8 | 2203.9 | 2204.9 | 2991.0 |
| 2023-08-06 18:00:00 | ZN | Futures | 113.455363 | 113.455363 | 113.343835 | 113.343835 | 11103.0 |
| 2023-08-06 19:00:00 | ZN | Futures | 113.343835 | 113.407565 | 113.327903 | 113.407565 | 8265.0 |
| 2023-08-06 20:00:00 | ZN | Futures | 113.391633 | 113.43943 | 113.359768 | 113.3757 | 20333.0 |
| 2023-08-06 21:00:00 | ZN | Futures | 113.359768 | 113.359768 | 113.24824 | 113.280105 | 24593.0 |
| 2023-08-06 22:00:00 | ZN | Futures | 113.280105 | 113.327903 | 113.264173 | 113.31197 | 8995.0 |
| 2023-08-06 23:00:00 | ZN | Futures | 113.31197 | 113.31197 | 113.232308 | 113.232308 | 9963.0 |
> showing 36 of 410 rows — these rows as CSV