PREVIEW / futures_1hour / 2021-08-01
file: by_date/futures_1hour/2021/2021-08-01.parquet size: 18 KB rows: 405
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-01 18:00:00 | ES | Futures | 4951.9 | 4965.98 | 4950.5 | 4963.45 | 13092.0 |
| 2021-08-01 19:00:00 | ES | Futures | 4963.45 | 4965.14 | 4959.51 | 4963.73 | 8135.0 |
| 2021-08-01 20:00:00 | ES | Futures | 4963.73 | 4970.77 | 4960.35 | 4968.8 | 13133.0 |
| 2021-08-01 21:00:00 | ES | Futures | 4968.8 | 4971.33 | 4966.55 | 4967.39 | 11308.0 |
| 2021-08-01 22:00:00 | ES | Futures | 4967.39 | 4971.05 | 4961.76 | 4969.93 | 12935.0 |
| 2021-08-01 23:00:00 | ES | Futures | 4970.21 | 4971.05 | 4967.96 | 4969.08 | 5936.0 |
| 2021-08-01 18:00:00 | NQ | Futures | 17349.3 | 17391.01 | 17344.96 | 17386.67 | 4810.0 |
| 2021-08-01 19:00:00 | NQ | Futures | 17386.96 | 17394.2 | 17377.4 | 17382.9 | 2811.0 |
| 2021-08-01 20:00:00 | NQ | Futures | 17383.19 | 17404.34 | 17373.05 | 17402.31 | 4169.0 |
| 2021-08-01 21:00:00 | NQ | Futures | 17402.6 | 17409.55 | 17391.01 | 17394.2 | 4630.0 |
| 2021-08-01 22:00:00 | NQ | Futures | 17394.49 | 17421.72 | 17378.56 | 17417.67 | 5909.0 |
| 2021-08-01 23:00:00 | NQ | Futures | 17417.09 | 17420.27 | 17408.97 | 17413.03 | 2410.0 |
| 2021-08-01 18:00:00 | YM | Futures | 38960.8 | 39085.9 | 38960.8 | 39059.1 | 2507.0 |
| 2021-08-01 19:00:00 | YM | Futures | 39055.8 | 39068.1 | 39024.5 | 39056.9 | 1892.0 |
| 2021-08-01 20:00:00 | YM | Futures | 39056.9 | 39111.6 | 39031.2 | 39089.3 | 2578.0 |
| 2021-08-01 21:00:00 | YM | Futures | 39089.3 | 39106.1 | 39069.2 | 39072.5 | 2205.0 |
| 2021-08-01 22:00:00 | YM | Futures | 39073.7 | 39109.4 | 39032.3 | 39097.1 | 2409.0 |
| 2021-08-01 23:00:00 | YM | Futures | 39097.1 | 39100.5 | 39074.8 | 39083.7 | 1009.0 |
| 2021-08-01 18:00:00 | CL | Futures | 50.76 | 50.78 | 50.61 | 50.7 | 2411.0 |
| 2021-08-01 19:00:00 | CL | Futures | 50.7 | 50.72 | 50.61 | 50.63 | 1496.0 |
| 2021-08-01 20:00:00 | CL | Futures | 50.63 | 50.65 | 50.45 | 50.48 | 3618.0 |
| 2021-08-01 21:00:00 | CL | Futures | 50.48 | 50.54 | 50.04 | 50.08 | 13081.0 |
| 2021-08-01 22:00:00 | CL | Futures | 50.09 | 50.17 | 49.97 | 50.14 | 9303.0 |
| 2021-08-01 23:00:00 | CL | Futures | 50.15 | 50.26 | 50.12 | 50.23 | 3137.0 |
| 2021-08-01 18:00:00 | GC | Futures | 2187.3 | 2188.5 | 2186.3 | 2187.4 | 1452.0 |
| 2021-08-01 19:00:00 | GC | Futures | 2187.4 | 2187.4 | 2184.8 | 2186.8 | 1417.0 |
| 2021-08-01 20:00:00 | GC | Futures | 2186.8 | 2190.4 | 2185.2 | 2190.4 | 3054.0 |
| 2021-08-01 21:00:00 | GC | Futures | 2190.3 | 2190.8 | 2180.7 | 2183.6 | 11472.0 |
| 2021-08-01 22:00:00 | GC | Futures | 2183.6 | 2185.1 | 2180.5 | 2184.6 | 5260.0 |
| 2021-08-01 23:00:00 | GC | Futures | 2184.6 | 2184.9 | 2182.2 | 2184.6 | 2756.0 |
| 2021-08-01 18:00:00 | ZN | Futures | 136.800279 | 136.816168 | 136.768502 | 136.816168 | 15168.0 |
| 2021-08-01 19:00:00 | ZN | Futures | 136.800279 | 136.816168 | 136.752614 | 136.752614 | 10129.0 |
| 2021-08-01 20:00:00 | ZN | Futures | 136.752614 | 136.800279 | 136.736725 | 136.800279 | 15982.0 |
| 2021-08-01 21:00:00 | ZN | Futures | 136.800279 | 136.832056 | 136.768502 | 136.816168 | 11781.0 |
| 2021-08-01 22:00:00 | ZN | Futures | 136.832056 | 136.927388 | 136.816168 | 136.879722 | 28213.0 |
| 2021-08-01 23:00:00 | ZN | Futures | 136.863834 | 136.911499 | 136.863834 | 136.911499 | 7335.0 |
> showing 36 of 405 rows — these rows as CSV