PREVIEW / futures_1hour / 2022-08-28
file: by_date/futures_1hour/2022/2022-08-28.parquet size: 20 KB rows: 423
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-08-28 18:00:00 | ES | Futures | 4559.54 | 4568.32 | 4554.16 | 4561.52 | 25233.0 |
| 2022-08-28 19:00:00 | ES | Futures | 4561.52 | 4563.22 | 4543.96 | 4547.36 | 17324.0 |
| 2022-08-28 20:00:00 | ES | Futures | 4547.36 | 4558.4 | 4543.11 | 4545.66 | 26376.0 |
| 2022-08-28 21:00:00 | ES | Futures | 4545.37 | 4551.89 | 4539.99 | 4551.32 | 17358.0 |
| 2022-08-28 22:00:00 | ES | Futures | 4551.32 | 4563.79 | 4549.91 | 4558.12 | 14148.0 |
| 2022-08-28 23:00:00 | ES | Futures | 4558.4 | 4565.49 | 4556.42 | 4565.49 | 10158.0 |
| 2022-08-28 18:00:00 | NQ | Futures | 14444.6 | 14477.57 | 14417.41 | 14449.8 | 11873.0 |
| 2022-08-28 19:00:00 | NQ | Futures | 14449.8 | 14458.77 | 14359.85 | 14369.11 | 9393.0 |
| 2022-08-28 20:00:00 | NQ | Futures | 14368.82 | 14406.71 | 14353.2 | 14365.64 | 9929.0 |
| 2022-08-28 21:00:00 | NQ | Futures | 14365.06 | 14400.34 | 14347.99 | 14396.87 | 7709.0 |
| 2022-08-28 22:00:00 | NQ | Futures | 14396.87 | 14446.04 | 14389.64 | 14422.04 | 7328.0 |
| 2022-08-28 23:00:00 | NQ | Futures | 14422.91 | 14442.86 | 14413.65 | 14441.13 | 3796.0 |
| 2022-08-28 18:00:00 | YM | Futures | 36152.1 | 36195.0 | 36107.0 | 36163.4 | 3276.0 |
| 2022-08-28 19:00:00 | YM | Futures | 36166.8 | 36172.4 | 36042.7 | 36078.8 | 2914.0 |
| 2022-08-28 20:00:00 | YM | Futures | 36077.7 | 36151.0 | 36049.4 | 36066.4 | 3250.0 |
| 2022-08-28 21:00:00 | YM | Futures | 36066.4 | 36096.8 | 36023.5 | 36085.6 | 1905.0 |
| 2022-08-28 22:00:00 | YM | Futures | 36085.6 | 36169.1 | 36075.4 | 36132.9 | 1792.0 |
| 2022-08-28 23:00:00 | YM | Futures | 36135.2 | 36184.8 | 36126.2 | 36182.6 | 1050.0 |
| 2022-08-28 18:00:00 | CL | Futures | 74.31 | 74.41 | 73.77 | 74.2 | 2794.0 |
| 2022-08-28 19:00:00 | CL | Futures | 74.19 | 74.6 | 74.17 | 74.3 | 2311.0 |
| 2022-08-28 20:00:00 | CL | Futures | 74.29 | 74.73 | 74.19 | 74.69 | 2265.0 |
| 2022-08-28 21:00:00 | CL | Futures | 74.7 | 75.12 | 74.44 | 75.08 | 5486.0 |
| 2022-08-28 22:00:00 | CL | Futures | 75.08 | 75.4 | 74.94 | 75.32 | 5016.0 |
| 2022-08-28 23:00:00 | CL | Futures | 75.32 | 75.4 | 75.2 | 75.32 | 2340.0 |
| 2022-08-28 18:00:00 | GC | Futures | 2065.1 | 2067.8 | 2062.0 | 2063.6 | 2433.0 |
| 2022-08-28 19:00:00 | GC | Futures | 2063.9 | 2064.6 | 2057.9 | 2062.5 | 3115.0 |
| 2022-08-28 20:00:00 | GC | Futures | 2062.4 | 2064.0 | 2060.6 | 2062.0 | 3103.0 |
| 2022-08-28 21:00:00 | GC | Futures | 2062.0 | 2062.0 | 2049.8 | 2049.9 | 9027.0 |
| 2022-08-28 22:00:00 | GC | Futures | 2049.8 | 2054.7 | 2049.2 | 2052.7 | 4231.0 |
| 2022-08-28 23:00:00 | GC | Futures | 2052.7 | 2053.3 | 2050.0 | 2050.3 | 2450.0 |
| 2022-08-28 18:00:00 | ZN | Futures | 121.157315 | 121.157315 | 121.028372 | 121.108961 | 5636.0 |
| 2022-08-28 19:00:00 | ZN | Futures | 121.108961 | 121.108961 | 120.963901 | 120.980019 | 5220.0 |
| 2022-08-28 20:00:00 | ZN | Futures | 120.980019 | 120.996137 | 120.770488 | 120.834959 | 19428.0 |
| 2022-08-28 21:00:00 | ZN | Futures | 120.818841 | 120.89943 | 120.641546 | 120.706017 | 17517.0 |
| 2022-08-28 22:00:00 | ZN | Futures | 120.689899 | 120.75437 | 120.641546 | 120.641546 | 6166.0 |
| 2022-08-28 23:00:00 | ZN | Futures | 120.625428 | 120.641546 | 120.544839 | 120.560957 | 10678.0 |
> showing 36 of 423 rows — these rows as CSV