PREVIEW / futures_1hour / 2023-03-12
file: by_date/futures_1hour/2023/2023-03-12.parquet size: 20 KB rows: 412
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-03-12 18:00:00 | ES | Futures | 4348.16 | 4392.9 | 4316.01 | 4354.87 | 94287.0 |
| 2023-03-12 19:00:00 | ES | Futures | 4354.87 | 4381.99 | 4351.8 | 4370.25 | 44041.0 |
| 2023-03-12 20:00:00 | ES | Futures | 4369.97 | 4386.47 | 4369.13 | 4376.12 | 28487.0 |
| 2023-03-12 21:00:00 | ES | Futures | 4375.84 | 4380.88 | 4364.66 | 4370.81 | 16699.0 |
| 2023-03-12 22:00:00 | ES | Futures | 4370.81 | 4395.97 | 4368.29 | 4394.02 | 20307.0 |
| 2023-03-12 23:00:00 | ES | Futures | 4394.3 | 4401.01 | 4392.34 | 4394.3 | 9702.0 |
| 2023-03-12 18:00:00 | NQ | Futures | 13535.94 | 13706.92 | 13485.02 | 13601.66 | 19228.0 |
| 2023-03-12 19:00:00 | NQ | Futures | 13601.66 | 13684.45 | 13582.32 | 13644.9 | 10174.0 |
| 2023-03-12 20:00:00 | NQ | Futures | 13644.34 | 13680.75 | 13631.53 | 13638.93 | 8345.0 |
| 2023-03-12 21:00:00 | NQ | Futures | 13639.21 | 13654.58 | 13598.82 | 13629.26 | 7105.0 |
| 2023-03-12 22:00:00 | NQ | Futures | 13629.83 | 13715.17 | 13621.58 | 13713.18 | 8625.0 |
| 2023-03-12 23:00:00 | NQ | Futures | 13713.18 | 13741.63 | 13703.79 | 13711.48 | 4451.0 |
| 2023-03-12 18:00:00 | YM | Futures | 35693.7 | 35976.7 | 35463.8 | 35747.9 | 8361.0 |
| 2023-03-12 19:00:00 | YM | Futures | 35750.1 | 35900.4 | 35712.5 | 35833.0 | 3446.0 |
| 2023-03-12 20:00:00 | YM | Futures | 35835.2 | 35943.5 | 35831.9 | 35883.8 | 1765.0 |
| 2023-03-12 21:00:00 | YM | Futures | 35877.2 | 35907.0 | 35798.7 | 35845.2 | 1456.0 |
| 2023-03-12 22:00:00 | YM | Futures | 35846.3 | 36024.2 | 35831.9 | 35991.1 | 3957.0 |
| 2023-03-12 23:00:00 | YM | Futures | 35992.2 | 36027.5 | 35974.5 | 35986.6 | 2211.0 |
| 2023-03-12 18:00:00 | CL | Futures | 62.25 | 62.96 | 61.88 | 62.72 | 5030.0 |
| 2023-03-12 19:00:00 | CL | Futures | 62.7 | 62.72 | 62.46 | 62.66 | 2446.0 |
| 2023-03-12 20:00:00 | CL | Futures | 62.66 | 62.72 | 62.57 | 62.57 | 2206.0 |
| 2023-03-12 21:00:00 | CL | Futures | 62.58 | 62.77 | 62.07 | 62.14 | 4608.0 |
| 2023-03-12 22:00:00 | CL | Futures | 62.14 | 62.6 | 62.08 | 62.54 | 3576.0 |
| 2023-03-12 23:00:00 | CL | Futures | 62.54 | 62.57 | 62.42 | 62.5 | 1461.0 |
| 2023-03-12 18:00:00 | GC | Futures | 2179.7 | 2205.9 | 2179.6 | 2192.7 | 21952.0 |
| 2023-03-12 19:00:00 | GC | Futures | 2192.8 | 2199.1 | 2183.3 | 2185.5 | 11834.0 |
| 2023-03-12 20:00:00 | GC | Futures | 2185.5 | 2191.0 | 2182.6 | 2184.8 | 8943.0 |
| 2023-03-12 21:00:00 | GC | Futures | 2184.8 | 2187.7 | 2178.8 | 2179.8 | 7101.0 |
| 2023-03-12 22:00:00 | GC | Futures | 2179.8 | 2199.1 | 2179.1 | 2196.2 | 10414.0 |
| 2023-03-12 23:00:00 | GC | Futures | 2196.0 | 2196.3 | 2190.6 | 2190.8 | 5137.0 |
| 2023-03-12 18:00:00 | ZN | Futures | 116.104631 | 116.938071 | 115.912299 | 116.377102 | 154245.0 |
| 2023-03-12 19:00:00 | ZN | Futures | 116.377102 | 116.633545 | 115.639828 | 115.687911 | 104769.0 |
| 2023-03-12 20:00:00 | ZN | Futures | 115.687911 | 116.104631 | 115.559689 | 115.896271 | 85859.0 |
| 2023-03-12 21:00:00 | ZN | Futures | 115.896271 | 115.944354 | 115.671883 | 115.752022 | 34390.0 |
| 2023-03-12 22:00:00 | ZN | Futures | 115.735994 | 116.425185 | 115.719966 | 116.361074 | 77722.0 |
| 2023-03-12 23:00:00 | ZN | Futures | 116.361074 | 116.425185 | 116.152714 | 116.152714 | 31859.0 |
> showing 36 of 412 rows — these rows as CSV