PREVIEW / futures_1hour / 2022-09-11
file: by_date/futures_1hour/2022/2022-09-11.parquet size: 18 KB rows: 381
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-09-11 18:00:00 | ES | Futures | 4619.87 | 4631.49 | 4619.87 | 4622.14 | 7322.0 |
| 2022-09-11 19:00:00 | ES | Futures | 4621.86 | 4624.97 | 4619.02 | 4619.59 | 2517.0 |
| 2022-09-11 20:00:00 | ES | Futures | 4619.59 | 4619.59 | 4611.09 | 4613.36 | 4629.0 |
| 2022-09-11 21:00:00 | ES | Futures | 4613.36 | 4615.91 | 4607.13 | 4614.78 | 3624.0 |
| 2022-09-11 22:00:00 | ES | Futures | 4615.06 | 4615.63 | 4604.29 | 4607.98 | 3176.0 |
| 2022-09-11 23:00:00 | ES | Futures | 4608.26 | 4610.53 | 4604.01 | 4607.13 | 2556.0 |
| 2022-09-11 18:00:00 | NQ | Futures | 14607.73 | 14669.34 | 14607.73 | 14624.5 | 5005.0 |
| 2022-09-11 19:00:00 | NQ | Futures | 14624.5 | 14631.74 | 14608.89 | 14614.67 | 2202.0 |
| 2022-09-11 20:00:00 | NQ | Futures | 14614.09 | 14614.09 | 14577.65 | 14591.53 | 4186.0 |
| 2022-09-11 21:00:00 | NQ | Futures | 14592.69 | 14597.89 | 14571.0 | 14595.58 | 3366.0 |
| 2022-09-11 22:00:00 | NQ | Futures | 14596.74 | 14598.76 | 14554.8 | 14569.55 | 3571.0 |
| 2022-09-11 23:00:00 | NQ | Futures | 14568.1 | 14573.31 | 14550.46 | 14559.43 | 2529.0 |
| 2022-09-11 18:00:00 | YM | Futures | 36268.3 | 36333.4 | 36268.3 | 36287.4 | 1129.0 |
| 2022-09-11 19:00:00 | YM | Futures | 36285.2 | 36315.5 | 36274.0 | 36276.2 | 392.0 |
| 2022-09-11 20:00:00 | YM | Futures | 36275.1 | 36277.3 | 36220.1 | 36235.8 | 842.0 |
| 2022-09-11 21:00:00 | YM | Futures | 36234.7 | 36256.0 | 36190.9 | 36250.4 | 522.0 |
| 2022-09-11 22:00:00 | YM | Futures | 36252.6 | 36256.0 | 36181.9 | 36216.7 | 500.0 |
| 2022-09-11 23:00:00 | YM | Futures | 36212.2 | 36224.6 | 36185.3 | 36204.4 | 330.0 |
| 2022-09-11 18:00:00 | CL | Futures | 68.95 | 69.3 | 68.86 | 69.11 | 1556.0 |
| 2022-09-11 19:00:00 | CL | Futures | 69.11 | 69.14 | 68.97 | 68.99 | 1593.0 |
| 2022-09-11 20:00:00 | CL | Futures | 69.01 | 69.03 | 68.43 | 68.48 | 2107.0 |
| 2022-09-11 21:00:00 | CL | Futures | 68.49 | 68.51 | 68.07 | 68.26 | 3066.0 |
| 2022-09-11 22:00:00 | CL | Futures | 68.27 | 68.39 | 68.21 | 68.39 | 1883.0 |
| 2022-09-11 23:00:00 | CL | Futures | 68.39 | 68.39 | 68.17 | 68.33 | 1289.0 |
| 2022-09-11 18:00:00 | GC | Futures | 2041.5 | 2045.0 | 2040.7 | 2044.3 | 1923.0 |
| 2022-09-11 19:00:00 | GC | Futures | 2044.3 | 2044.3 | 2042.0 | 2042.8 | 858.0 |
| 2022-09-11 20:00:00 | GC | Futures | 2042.7 | 2043.1 | 2040.1 | 2040.9 | 1553.0 |
| 2022-09-11 21:00:00 | GC | Futures | 2040.9 | 2042.8 | 2039.4 | 2040.2 | 2050.0 |
| 2022-09-11 22:00:00 | GC | Futures | 2040.1 | 2040.3 | 2035.8 | 2036.6 | 2547.0 |
| 2022-09-11 23:00:00 | GC | Futures | 2036.5 | 2037.0 | 2034.8 | 2036.3 | 1888.0 |
| 2022-09-11 18:00:00 | ZN | Futures | 119.319888 | 119.432713 | 119.319888 | 119.416595 | 5617.0 |
| 2022-09-11 19:00:00 | ZN | Futures | 119.416595 | 119.44883 | 119.400477 | 119.432713 | 2426.0 |
| 2022-09-11 20:00:00 | ZN | Futures | 119.432713 | 119.44883 | 119.384359 | 119.432713 | 3267.0 |
| 2022-09-11 21:00:00 | ZN | Futures | 119.432713 | 119.513301 | 119.416595 | 119.432713 | 6136.0 |
| 2022-09-11 22:00:00 | ZN | Futures | 119.432713 | 119.44883 | 119.384359 | 119.432713 | 5042.0 |
| 2022-09-11 23:00:00 | ZN | Futures | 119.416595 | 119.416595 | 119.352124 | 119.384359 | 7943.0 |
> showing 36 of 381 rows — these rows as CSV