PREVIEW / futures_1hour / 2022-02-20
file: by_date/futures_1hour/2022/2022-02-20.parquet size: 18 KB rows: 383
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-02-20 18:00:00 | ES | Futures | 4891.63 | 4902.37 | 4881.45 | 4889.93 | 21045.0 |
| 2022-02-20 19:00:00 | ES | Futures | 4889.37 | 4923.58 | 4878.62 | 4920.19 | 29210.0 |
| 2022-02-20 20:00:00 | ES | Futures | 4920.19 | 4947.91 | 4906.62 | 4939.7 | 36674.0 |
| 2022-02-20 21:00:00 | ES | Futures | 4939.7 | 4945.36 | 4934.61 | 4941.97 | 7990.0 |
| 2022-02-20 22:00:00 | ES | Futures | 4941.97 | 4945.36 | 4930.65 | 4932.92 | 8186.0 |
| 2022-02-20 23:00:00 | ES | Futures | 4932.63 | 4941.12 | 4930.65 | 4939.99 | 5588.0 |
| 2022-02-20 18:00:00 | NQ | Futures | 16174.99 | 16178.46 | 16040.8 | 16057.9 | 13989.0 |
| 2022-02-20 19:00:00 | NQ | Futures | 16057.9 | 16212.37 | 16009.21 | 16188.32 | 15057.0 |
| 2022-02-20 20:00:00 | NQ | Futures | 16190.35 | 16329.17 | 16141.08 | 16297.58 | 16119.0 |
| 2022-02-20 21:00:00 | NQ | Futures | 16297.29 | 16318.44 | 16283.09 | 16301.93 | 4441.0 |
| 2022-02-20 22:00:00 | NQ | Futures | 16302.5 | 16314.97 | 16232.66 | 16250.34 | 5368.0 |
| 2022-02-20 23:00:00 | NQ | Futures | 16249.18 | 16304.82 | 16239.61 | 16297.0 | 3599.0 |
| 2022-02-20 18:00:00 | YM | Futures | 38062.0 | 38160.9 | 38020.4 | 38128.3 | 5761.0 |
| 2022-02-20 19:00:00 | YM | Futures | 38128.3 | 38335.1 | 38066.5 | 38309.2 | 6642.0 |
| 2022-02-20 20:00:00 | YM | Futures | 38308.1 | 38459.8 | 38217.1 | 38396.9 | 6441.0 |
| 2022-02-20 21:00:00 | YM | Futures | 38405.9 | 38431.7 | 38353.1 | 38410.4 | 1677.0 |
| 2022-02-20 22:00:00 | YM | Futures | 38412.6 | 38439.6 | 38348.6 | 38373.3 | 1883.0 |
| 2022-02-20 23:00:00 | YM | Futures | 38369.9 | 38414.9 | 38356.4 | 38408.1 | 1312.0 |
| 2022-02-20 18:00:00 | CL | Futures | 66.33 | 66.66 | 66.11 | 66.54 | 7815.0 |
| 2022-02-20 19:00:00 | CL | Futures | 66.54 | 66.63 | 65.77 | 65.83 | 9300.0 |
| 2022-02-20 20:00:00 | CL | Futures | 65.83 | 65.99 | 64.68 | 64.95 | 23552.0 |
| 2022-02-20 21:00:00 | CL | Futures | 64.95 | 65.21 | 64.79 | 65.16 | 5217.0 |
| 2022-02-20 22:00:00 | CL | Futures | 65.16 | 65.3 | 65.04 | 65.24 | 2955.0 |
| 2022-02-20 23:00:00 | CL | Futures | 65.24 | 65.53 | 65.11 | 65.18 | 5440.0 |
| 2022-02-20 18:00:00 | GC | Futures | 2285.0 | 2292.2 | 2280.2 | 2289.6 | 6710.0 |
| 2022-02-20 19:00:00 | GC | Futures | 2289.7 | 2293.8 | 2279.1 | 2281.5 | 7501.0 |
| 2022-02-20 20:00:00 | GC | Futures | 2281.5 | 2287.8 | 2272.8 | 2277.8 | 11468.0 |
| 2022-02-20 21:00:00 | GC | Futures | 2277.9 | 2280.6 | 2277.0 | 2280.0 | 2195.0 |
| 2022-02-20 22:00:00 | GC | Futures | 2279.8 | 2282.0 | 2279.5 | 2279.5 | 1958.0 |
| 2022-02-20 23:00:00 | GC | Futures | 2279.4 | 2279.7 | 2270.4 | 2273.6 | 3922.0 |
| 2022-02-20 18:00:00 | ZN | Futures | 130.192425 | 130.320773 | 130.096165 | 130.208469 | 28772.0 |
| 2022-02-20 19:00:00 | ZN | Futures | 130.208469 | 130.320773 | 129.983861 | 130.015947 | 42791.0 |
| 2022-02-20 20:00:00 | ZN | Futures | 129.999904 | 130.176382 | 129.999904 | 130.080121 | 40418.0 |
| 2022-02-20 21:00:00 | ZN | Futures | 130.080121 | 130.144295 | 130.048034 | 130.080121 | 7268.0 |
| 2022-02-20 22:00:00 | ZN | Futures | 130.080121 | 130.160338 | 130.080121 | 130.096165 | 6956.0 |
| 2022-02-20 23:00:00 | ZN | Futures | 130.112208 | 130.112208 | 130.031991 | 130.048034 | 4868.0 |
> showing 36 of 383 rows — these rows as CSV