PREVIEW / futures_1hour / 2022-10-02
file: by_date/futures_1hour/2022/2022-10-02.parquet size: 20 KB rows: 425
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-10-02 18:00:00 | ES | Futures | 4051.66 | 4074.49 | 4046.3 | 4066.88 | 38985.0 |
| 2022-10-02 19:00:00 | ES | Futures | 4067.16 | 4069.98 | 4037.84 | 4042.35 | 22835.0 |
| 2022-10-02 20:00:00 | ES | Futures | 4042.35 | 4042.92 | 4027.41 | 4032.49 | 32903.0 |
| 2022-10-02 21:00:00 | ES | Futures | 4032.49 | 4068.01 | 4032.49 | 4065.75 | 29813.0 |
| 2022-10-02 22:00:00 | ES | Futures | 4065.75 | 4066.32 | 4048.84 | 4049.4 | 18123.0 |
| 2022-10-02 23:00:00 | ES | Futures | 4049.4 | 4064.62 | 4049.12 | 4058.7 | 11469.0 |
| 2022-10-02 18:00:00 | NQ | Futures | 12676.82 | 12700.09 | 12618.2 | 12668.49 | 18018.0 |
| 2022-10-02 19:00:00 | NQ | Futures | 12668.77 | 12683.14 | 12561.89 | 12577.4 | 11342.0 |
| 2022-10-02 20:00:00 | NQ | Futures | 12577.98 | 12583.15 | 12516.78 | 12536.03 | 16739.0 |
| 2022-10-02 21:00:00 | NQ | Futures | 12536.6 | 12670.78 | 12535.17 | 12659.58 | 15001.0 |
| 2022-10-02 22:00:00 | NQ | Futures | 12659.58 | 12661.02 | 12592.92 | 12597.23 | 11588.0 |
| 2022-10-02 23:00:00 | NQ | Futures | 12597.23 | 12650.38 | 12596.65 | 12631.71 | 7015.0 |
| 2022-10-02 18:00:00 | YM | Futures | 32283.3 | 32468.5 | 32242.9 | 32410.1 | 5624.0 |
| 2022-10-02 19:00:00 | YM | Futures | 32414.6 | 32430.3 | 32209.2 | 32241.8 | 3107.0 |
| 2022-10-02 20:00:00 | YM | Futures | 32242.9 | 32246.3 | 32135.2 | 32175.6 | 4472.0 |
| 2022-10-02 21:00:00 | YM | Futures | 32178.9 | 32419.1 | 32178.9 | 32404.5 | 3003.0 |
| 2022-10-02 22:00:00 | YM | Futures | 32404.5 | 32410.1 | 32299.0 | 32302.4 | 2127.0 |
| 2022-10-02 23:00:00 | YM | Futures | 32303.5 | 32404.5 | 32301.3 | 32366.3 | 1411.0 |
| 2022-10-02 18:00:00 | CL | Futures | 65.04 | 65.92 | 64.92 | 65.85 | 6308.0 |
| 2022-10-02 19:00:00 | CL | Futures | 65.86 | 65.95 | 65.78 | 65.88 | 1619.0 |
| 2022-10-02 20:00:00 | CL | Futures | 65.87 | 65.9 | 65.3 | 65.51 | 3144.0 |
| 2022-10-02 21:00:00 | CL | Futures | 65.52 | 65.85 | 65.31 | 65.83 | 2593.0 |
| 2022-10-02 22:00:00 | CL | Futures | 65.82 | 65.95 | 65.62 | 65.62 | 1916.0 |
| 2022-10-02 23:00:00 | CL | Futures | 65.63 | 65.69 | 65.48 | 65.51 | 1394.0 |
| 2022-10-02 18:00:00 | GC | Futures | 1973.1 | 1976.6 | 1970.5 | 1975.7 | 2217.0 |
| 2022-10-02 19:00:00 | GC | Futures | 1975.6 | 1976.1 | 1974.8 | 1975.1 | 2099.0 |
| 2022-10-02 20:00:00 | GC | Futures | 1975.1 | 1976.6 | 1974.9 | 1975.6 | 3157.0 |
| 2022-10-02 21:00:00 | GC | Futures | 1975.6 | 1981.7 | 1975.3 | 1981.1 | 3127.0 |
| 2022-10-02 22:00:00 | GC | Futures | 1981.1 | 1981.1 | 1974.4 | 1974.6 | 2574.0 |
| 2022-10-02 23:00:00 | GC | Futures | 1974.8 | 1976.4 | 1974.6 | 1975.1 | 1347.0 |
| 2022-10-02 18:00:00 | ZN | Futures | 115.354916 | 115.564447 | 115.32268 | 115.532211 | 12843.0 |
| 2022-10-02 19:00:00 | ZN | Futures | 115.532211 | 115.548329 | 115.451622 | 115.46774 | 7061.0 |
| 2022-10-02 20:00:00 | ZN | Futures | 115.46774 | 115.6128 | 115.419387 | 115.6128 | 15060.0 |
| 2022-10-02 21:00:00 | ZN | Futures | 115.596682 | 115.645035 | 115.564447 | 115.628918 | 11964.0 |
| 2022-10-02 22:00:00 | ZN | Futures | 115.628918 | 115.709507 | 115.628918 | 115.677271 | 8538.0 |
| 2022-10-02 23:00:00 | ZN | Futures | 115.661153 | 115.693389 | 115.645035 | 115.661153 | 5722.0 |
> showing 36 of 425 rows — these rows as CSV