PREVIEW / futures_1hour / 2021-08-22
file: by_date/futures_1hour/2021/2021-08-22.parquet size: 18 KB rows: 386
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-22 18:00:00 | ES | Futures | 4995.27 | 5003.43 | 4993.58 | 5000.62 | 8133.0 |
| 2021-08-22 19:00:00 | ES | Futures | 5000.62 | 5003.72 | 4999.49 | 5000.9 | 4763.0 |
| 2021-08-22 20:00:00 | ES | Futures | 5001.18 | 5004.84 | 5000.06 | 5004.0 | 10306.0 |
| 2021-08-22 21:00:00 | ES | Futures | 5004.28 | 5012.45 | 5003.43 | 5010.76 | 13992.0 |
| 2021-08-22 22:00:00 | ES | Futures | 5010.76 | 5014.13 | 5010.19 | 5013.57 | 7257.0 |
| 2021-08-22 23:00:00 | ES | Futures | 5013.85 | 5017.8 | 5013.01 | 5014.98 | 7872.0 |
| 2021-08-22 18:00:00 | NQ | Futures | 17485.16 | 17520.5 | 17481.11 | 17515.58 | 5680.0 |
| 2021-08-22 19:00:00 | NQ | Futures | 17515.87 | 17519.63 | 17503.12 | 17505.15 | 2242.0 |
| 2021-08-22 20:00:00 | NQ | Futures | 17505.15 | 17514.42 | 17500.51 | 17510.07 | 3717.0 |
| 2021-08-22 21:00:00 | NQ | Futures | 17509.78 | 17542.52 | 17507.47 | 17540.78 | 6083.0 |
| 2021-08-22 22:00:00 | NQ | Futures | 17540.78 | 17555.26 | 17536.14 | 17546.86 | 4890.0 |
| 2021-08-22 23:00:00 | NQ | Futures | 17547.15 | 17554.97 | 17544.26 | 17550.34 | 3290.0 |
| 2021-08-22 18:00:00 | YM | Futures | 39138.5 | 39195.4 | 39121.7 | 39178.7 | 1400.0 |
| 2021-08-22 19:00:00 | YM | Futures | 39178.7 | 39206.6 | 39160.8 | 39178.7 | 1022.0 |
| 2021-08-22 20:00:00 | YM | Futures | 39179.8 | 39230.1 | 39177.6 | 39222.2 | 1559.0 |
| 2021-08-22 21:00:00 | YM | Futures | 39223.4 | 39296.0 | 39220.0 | 39280.3 | 2841.0 |
| 2021-08-22 22:00:00 | YM | Futures | 39278.1 | 39308.3 | 39277.0 | 39302.7 | 1076.0 |
| 2021-08-22 23:00:00 | YM | Futures | 39302.7 | 39340.7 | 39296.0 | 39320.6 | 1419.0 |
| 2021-08-22 18:00:00 | CL | Futures | 42.8 | 43.03 | 42.65 | 42.99 | 3400.0 |
| 2021-08-22 19:00:00 | CL | Futures | 42.98 | 43.15 | 42.97 | 43.05 | 2378.0 |
| 2021-08-22 20:00:00 | CL | Futures | 43.05 | 43.39 | 43.04 | 43.36 | 5372.0 |
| 2021-08-22 21:00:00 | CL | Futures | 43.35 | 43.43 | 43.22 | 43.29 | 6256.0 |
| 2021-08-22 22:00:00 | CL | Futures | 43.29 | 43.46 | 43.23 | 43.45 | 3916.0 |
| 2021-08-22 23:00:00 | CL | Futures | 43.44 | 43.83 | 43.4 | 43.66 | 9035.0 |
| 2021-08-22 18:00:00 | GC | Futures | 2144.2 | 2147.7 | 2142.0 | 2142.5 | 1890.0 |
| 2021-08-22 19:00:00 | GC | Futures | 2142.4 | 2143.7 | 2141.3 | 2143.1 | 1706.0 |
| 2021-08-22 20:00:00 | GC | Futures | 2143.0 | 2144.4 | 2141.2 | 2143.8 | 2335.0 |
| 2021-08-22 21:00:00 | GC | Futures | 2143.8 | 2152.9 | 2140.3 | 2151.7 | 7931.0 |
| 2021-08-22 22:00:00 | GC | Futures | 2151.8 | 2154.3 | 2150.9 | 2154.3 | 4103.0 |
| 2021-08-22 23:00:00 | GC | Futures | 2154.4 | 2155.1 | 2152.1 | 2153.1 | 2068.0 |
| 2021-08-22 18:00:00 | ZN | Futures | 136.403066 | 136.450732 | 136.3554 | 136.403066 | 9999.0 |
| 2021-08-22 19:00:00 | ZN | Futures | 136.403066 | 136.403066 | 136.371289 | 136.387178 | 4579.0 |
| 2021-08-22 20:00:00 | ZN | Futures | 136.371289 | 136.387178 | 136.307735 | 136.323623 | 18428.0 |
| 2021-08-22 21:00:00 | ZN | Futures | 136.307735 | 136.323623 | 136.291846 | 136.323623 | 11530.0 |
| 2021-08-22 22:00:00 | ZN | Futures | 136.307735 | 136.323623 | 136.307735 | 136.323623 | 6258.0 |
| 2021-08-22 23:00:00 | ZN | Futures | 136.307735 | 136.323623 | 136.260069 | 136.291846 | 10846.0 |
> showing 36 of 386 rows — these rows as CSV