PREVIEW / futures_1hour / 2022-08-21
file: by_date/futures_1hour/2022/2022-08-21.parquet size: 19 KB rows: 406
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-21 18:00:00 | ES | Futures | 4782.76 | 4783.32 | 4771.71 | 4778.22 | 10810.0 |
| 2022-08-21 19:00:00 | ES | Futures | 4778.22 | 4779.92 | 4766.89 | 4769.73 | 8284.0 |
| 2022-08-21 20:00:00 | ES | Futures | 4769.73 | 4773.12 | 4766.04 | 4768.59 | 9431.0 |
| 2022-08-21 21:00:00 | ES | Futures | 4768.59 | 4776.52 | 4767.46 | 4774.26 | 8383.0 |
| 2022-08-21 22:00:00 | ES | Futures | 4774.54 | 4783.04 | 4773.41 | 4782.47 | 7085.0 |
| 2022-08-21 23:00:00 | ES | Futures | 4782.76 | 4782.76 | 4775.39 | 4776.52 | 4071.0 |
| 2022-08-21 18:00:00 | NQ | Futures | 15302.48 | 15302.48 | 15245.21 | 15269.8 | 6539.0 |
| 2022-08-21 19:00:00 | NQ | Futures | 15269.51 | 15284.84 | 15245.21 | 15257.07 | 3769.0 |
| 2022-08-21 20:00:00 | NQ | Futures | 15257.65 | 15270.66 | 15245.79 | 15255.05 | 4296.0 |
| 2022-08-21 21:00:00 | NQ | Futures | 15254.47 | 15279.63 | 15251.86 | 15267.77 | 3952.0 |
| 2022-08-21 22:00:00 | NQ | Futures | 15268.64 | 15298.14 | 15266.62 | 15294.09 | 3249.0 |
| 2022-08-21 23:00:00 | NQ | Futures | 15293.51 | 15295.25 | 15275.58 | 15281.08 | 2020.0 |
| 2022-08-21 18:00:00 | YM | Futures | 37934.9 | 37973.3 | 37901.1 | 37931.5 | 1248.0 |
| 2022-08-21 19:00:00 | YM | Futures | 37929.3 | 37934.9 | 37830.0 | 37845.8 | 1389.0 |
| 2022-08-21 20:00:00 | YM | Futures | 37848.0 | 37872.9 | 37820.9 | 37833.4 | 1516.0 |
| 2022-08-21 21:00:00 | YM | Futures | 37827.7 | 37899.9 | 37827.7 | 37880.7 | 1119.0 |
| 2022-08-21 22:00:00 | YM | Futures | 37884.1 | 37950.7 | 37878.5 | 37947.3 | 990.0 |
| 2022-08-21 23:00:00 | YM | Futures | 37946.2 | 37947.3 | 37885.3 | 37890.9 | 571.0 |
| 2022-08-21 18:00:00 | CL | Futures | 71.65 | 71.65 | 71.26 | 71.44 | 2733.0 |
| 2022-08-21 19:00:00 | CL | Futures | 71.45 | 71.58 | 71.43 | 71.52 | 1313.0 |
| 2022-08-21 20:00:00 | CL | Futures | 71.53 | 71.54 | 71.3 | 71.43 | 1982.0 |
| 2022-08-21 21:00:00 | CL | Futures | 71.44 | 71.7 | 71.26 | 71.44 | 4473.0 |
| 2022-08-21 22:00:00 | CL | Futures | 71.46 | 71.65 | 71.42 | 71.62 | 2034.0 |
| 2022-08-21 23:00:00 | CL | Futures | 71.64 | 71.65 | 71.4 | 71.44 | 1465.0 |
| 2022-08-21 18:00:00 | GC | Futures | 2079.5 | 2080.8 | 2076.9 | 2079.8 | 1174.0 |
| 2022-08-21 19:00:00 | GC | Futures | 2079.6 | 2080.1 | 2077.0 | 2077.7 | 937.0 |
| 2022-08-21 20:00:00 | GC | Futures | 2077.7 | 2078.8 | 2076.6 | 2077.0 | 1541.0 |
| 2022-08-21 21:00:00 | GC | Futures | 2077.3 | 2079.9 | 2076.7 | 2078.1 | 3228.0 |
| 2022-08-21 22:00:00 | GC | Futures | 2078.2 | 2080.5 | 2077.6 | 2080.0 | 1606.0 |
| 2022-08-21 23:00:00 | GC | Futures | 2080.0 | 2081.3 | 2078.2 | 2078.3 | 1385.0 |
| 2022-08-21 18:00:00 | ZN | Futures | 121.979321 | 121.995439 | 121.866497 | 121.91485 | 7421.0 |
| 2022-08-21 19:00:00 | ZN | Futures | 121.91485 | 121.947085 | 121.818143 | 121.850379 | 6576.0 |
| 2022-08-21 20:00:00 | ZN | Futures | 121.850379 | 121.866497 | 121.753672 | 121.76979 | 16787.0 |
| 2022-08-21 21:00:00 | ZN | Futures | 121.785908 | 121.818143 | 121.705319 | 121.818143 | 17301.0 |
| 2022-08-21 22:00:00 | ZN | Futures | 121.802026 | 121.850379 | 121.753672 | 121.818143 | 8726.0 |
| 2022-08-21 23:00:00 | ZN | Futures | 121.818143 | 121.882614 | 121.802026 | 121.866497 | 5586.0 |
> showing 36 of 406 rows — these rows as CSV