PREVIEW / futures_1hour / 2022-06-19
file: by_date/futures_1hour/2022/2022-06-19.parquet size: 18 KB rows: 372
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-19 18:00:00 | ES | Futures | 4174.29 | 4195.82 | 4174.29 | 4195.25 | 11336.0 |
| 2022-06-19 19:00:00 | ES | Futures | 4195.25 | 4200.92 | 4188.45 | 4198.37 | 6017.0 |
| 2022-06-19 20:00:00 | ES | Futures | 4198.37 | 4199.5 | 4172.87 | 4175.42 | 15912.0 |
| 2022-06-19 21:00:00 | ES | Futures | 4175.42 | 4181.09 | 4148.79 | 4155.31 | 20497.0 |
| 2022-06-19 22:00:00 | ES | Futures | 4155.31 | 4174.86 | 4152.76 | 4171.74 | 14007.0 |
| 2022-06-19 23:00:00 | ES | Futures | 4172.02 | 4186.47 | 4169.47 | 4181.09 | 11622.0 |
| 2022-06-19 18:00:00 | NQ | Futures | 13111.21 | 13215.04 | 13089.22 | 13210.42 | 8711.0 |
| 2022-06-19 19:00:00 | NQ | Futures | 13209.84 | 13232.69 | 13180.33 | 13223.72 | 4243.0 |
| 2022-06-19 20:00:00 | NQ | Futures | 13221.7 | 13227.19 | 13124.51 | 13129.72 | 8599.0 |
| 2022-06-19 21:00:00 | NQ | Futures | 13131.45 | 13155.75 | 13043.23 | 13074.18 | 9923.0 |
| 2022-06-19 22:00:00 | NQ | Futures | 13075.05 | 13142.15 | 13070.13 | 13134.06 | 7323.0 |
| 2022-06-19 23:00:00 | NQ | Futures | 13134.63 | 13176.28 | 13126.25 | 13154.88 | 5812.0 |
| 2022-06-19 18:00:00 | YM | Futures | 33771.3 | 33911.2 | 33756.7 | 33876.3 | 2425.0 |
| 2022-06-19 19:00:00 | YM | Futures | 33878.5 | 33909.0 | 33834.5 | 33894.3 | 1100.0 |
| 2022-06-19 20:00:00 | YM | Futures | 33889.8 | 33894.3 | 33723.9 | 33748.8 | 2904.0 |
| 2022-06-19 21:00:00 | YM | Futures | 33747.6 | 33784.9 | 33558.1 | 33594.2 | 4032.0 |
| 2022-06-19 22:00:00 | YM | Futures | 33596.4 | 33730.7 | 33570.5 | 33713.8 | 2765.0 |
| 2022-06-19 23:00:00 | YM | Futures | 33712.6 | 33811.9 | 33695.7 | 33777.0 | 1895.0 |
| 2022-06-19 18:00:00 | CL | Futures | 84.19 | 84.66 | 84.03 | 84.54 | 2768.0 |
| 2022-06-19 19:00:00 | CL | Futures | 84.55 | 84.57 | 84.2 | 84.36 | 1455.0 |
| 2022-06-19 20:00:00 | CL | Futures | 84.36 | 84.52 | 83.86 | 84.12 | 5188.0 |
| 2022-06-19 21:00:00 | CL | Futures | 84.1 | 84.15 | 83.08 | 83.22 | 9862.0 |
| 2022-06-19 22:00:00 | CL | Futures | 83.22 | 83.72 | 83.02 | 83.4 | 5284.0 |
| 2022-06-19 23:00:00 | CL | Futures | 83.41 | 83.61 | 83.26 | 83.39 | 2361.0 |
| 2022-06-19 18:00:00 | GC | Futures | 2196.7 | 2199.0 | 2192.2 | 2197.1 | 1438.0 |
| 2022-06-19 19:00:00 | GC | Futures | 2197.0 | 2197.8 | 2195.4 | 2196.7 | 597.0 |
| 2022-06-19 20:00:00 | GC | Futures | 2197.0 | 2199.2 | 2195.1 | 2198.5 | 1214.0 |
| 2022-06-19 21:00:00 | GC | Futures | 2198.5 | 2201.5 | 2194.3 | 2194.3 | 3217.0 |
| 2022-06-19 22:00:00 | GC | Futures | 2194.5 | 2202.8 | 2192.2 | 2201.1 | 4021.0 |
| 2022-06-19 23:00:00 | GC | Futures | 2201.0 | 2206.0 | 2201.0 | 2203.2 | 3205.0 |
| 2022-06-19 18:00:00 | ZN | Futures | 119.73895 | 119.771186 | 119.416595 | 119.690597 | 19850.0 |
| 2022-06-19 19:00:00 | ZN | Futures | 119.674479 | 119.73895 | 119.545537 | 119.610008 | 5990.0 |
| 2022-06-19 20:00:00 | ZN | Futures | 119.610008 | 119.771186 | 119.610008 | 119.73895 | 8313.0 |
| 2022-06-19 21:00:00 | ZN | Futures | 119.73895 | 119.964599 | 119.706715 | 119.900128 | 12940.0 |
| 2022-06-19 22:00:00 | ZN | Futures | 119.88401 | 119.996835 | 119.88401 | 119.948481 | 5094.0 |
| 2022-06-19 23:00:00 | ZN | Futures | 119.932364 | 119.964599 | 119.916246 | 119.932364 | 4284.0 |
> showing 36 of 372 rows — these rows as CSV