PREVIEW / futures_1hour / 2022-06-12
file: by_date/futures_1hour/2022/2022-06-12.parquet size: 20 KB rows: 422
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-06-12 18:00:00 | ES | Futures | 4388.5 | 4395.02 | 4377.45 | 4380.85 | 16704.0 |
| 2022-06-12 19:00:00 | ES | Futures | 4380.57 | 4383.4 | 4375.18 | 4378.58 | 6514.0 |
| 2022-06-12 20:00:00 | ES | Futures | 4378.3 | 4379.72 | 4363.85 | 4364.13 | 12266.0 |
| 2022-06-12 21:00:00 | ES | Futures | 4364.41 | 4364.41 | 4345.42 | 4352.51 | 19609.0 |
| 2022-06-12 22:00:00 | ES | Futures | 4352.51 | 4364.98 | 4351.66 | 4362.71 | 8538.0 |
| 2022-06-12 23:00:00 | ES | Futures | 4363.0 | 4366.68 | 4360.16 | 4363.28 | 5853.0 |
| 2022-06-12 18:00:00 | NQ | Futures | 13649.71 | 13654.92 | 13513.13 | 13525.02 | 8691.0 |
| 2022-06-12 19:00:00 | NQ | Futures | 13525.89 | 13540.38 | 13510.81 | 13532.56 | 2836.0 |
| 2022-06-12 20:00:00 | NQ | Futures | 13532.27 | 13533.72 | 13465.28 | 13468.47 | 5687.0 |
| 2022-06-12 21:00:00 | NQ | Futures | 13469.63 | 13482.1 | 13420.05 | 13458.9 | 8611.0 |
| 2022-06-12 22:00:00 | NQ | Futures | 13459.19 | 13499.21 | 13450.49 | 13491.67 | 4641.0 |
| 2022-06-12 23:00:00 | NQ | Futures | 13492.83 | 13498.05 | 13473.11 | 13481.52 | 3111.0 |
| 2022-06-12 18:00:00 | YM | Futures | 35316.0 | 35316.0 | 35123.1 | 35203.2 | 3567.0 |
| 2022-06-12 19:00:00 | YM | Futures | 35202.1 | 35219.0 | 35149.0 | 35166.0 | 1457.0 |
| 2022-06-12 20:00:00 | YM | Futures | 35170.5 | 35182.9 | 35071.2 | 35080.2 | 2393.0 |
| 2022-06-12 21:00:00 | YM | Futures | 35082.5 | 35082.5 | 34920.0 | 34957.2 | 4645.0 |
| 2022-06-12 22:00:00 | YM | Futures | 34957.2 | 35054.2 | 34951.6 | 35036.2 | 2412.0 |
| 2022-06-12 23:00:00 | YM | Futures | 35039.6 | 35059.9 | 35022.7 | 35041.8 | 1879.0 |
| 2022-06-12 18:00:00 | CL | Futures | 91.05 | 91.1 | 89.9 | 90.08 | 5577.0 |
| 2022-06-12 19:00:00 | CL | Futures | 90.09 | 90.28 | 89.99 | 90.02 | 1530.0 |
| 2022-06-12 20:00:00 | CL | Futures | 90.03 | 90.09 | 89.51 | 89.81 | 4250.0 |
| 2022-06-12 21:00:00 | CL | Futures | 89.8 | 90.28 | 89.58 | 89.61 | 7036.0 |
| 2022-06-12 22:00:00 | CL | Futures | 89.61 | 90.22 | 89.58 | 90.21 | 3459.0 |
| 2022-06-12 23:00:00 | CL | Futures | 90.22 | 90.23 | 89.99 | 90.06 | 1537.0 |
| 2022-06-12 18:00:00 | GC | Futures | 2242.6 | 2246.7 | 2241.1 | 2243.9 | 5743.0 |
| 2022-06-12 19:00:00 | GC | Futures | 2243.9 | 2244.7 | 2241.8 | 2244.7 | 2287.0 |
| 2022-06-12 20:00:00 | GC | Futures | 2244.8 | 2245.4 | 2239.2 | 2239.3 | 3929.0 |
| 2022-06-12 21:00:00 | GC | Futures | 2239.5 | 2239.5 | 2226.7 | 2227.2 | 9541.0 |
| 2022-06-12 22:00:00 | GC | Futures | 2227.0 | 2228.6 | 2223.7 | 2228.1 | 7154.0 |
| 2022-06-12 23:00:00 | GC | Futures | 2228.1 | 2231.0 | 2227.5 | 2228.2 | 3213.0 |
| 2022-06-12 18:00:00 | ZN | Futures | 120.432015 | 120.46425 | 120.17413 | 120.399779 | 34542.0 |
| 2022-06-12 19:00:00 | ZN | Futures | 120.415897 | 120.448132 | 120.238601 | 120.270837 | 15966.0 |
| 2022-06-12 20:00:00 | ZN | Futures | 120.270837 | 120.432015 | 120.093541 | 120.158012 | 50287.0 |
| 2022-06-12 21:00:00 | ZN | Futures | 120.17413 | 120.270837 | 120.045188 | 120.061306 | 35412.0 |
| 2022-06-12 22:00:00 | ZN | Futures | 120.061306 | 120.206366 | 120.045188 | 120.190248 | 23788.0 |
| 2022-06-12 23:00:00 | ZN | Futures | 120.17413 | 120.206366 | 120.109659 | 120.125777 | 11096.0 |
> showing 36 of 422 rows — these rows as CSV