PREVIEW / futures_1hour / 2021-08-29
file: by_date/futures_1hour/2021/2021-08-29.parquet size: 18 KB rows: 385
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-29 18:00:00 | ES | Futures | 5078.34 | 5079.74 | 5074.96 | 5077.21 | 5866.0 |
| 2021-08-29 19:00:00 | ES | Futures | 5077.49 | 5083.4 | 5076.36 | 5080.59 | 6571.0 |
| 2021-08-29 20:00:00 | ES | Futures | 5080.59 | 5082.0 | 5071.01 | 5072.42 | 11504.0 |
| 2021-08-29 21:00:00 | ES | Futures | 5072.42 | 5074.96 | 5069.32 | 5073.27 | 8597.0 |
| 2021-08-29 22:00:00 | ES | Futures | 5073.55 | 5076.36 | 5072.99 | 5075.24 | 5722.0 |
| 2021-08-29 23:00:00 | ES | Futures | 5075.24 | 5079.18 | 5074.96 | 5078.62 | 4623.0 |
| 2021-08-29 18:00:00 | NQ | Futures | 17882.31 | 17893.32 | 17873.91 | 17889.27 | 3007.0 |
| 2021-08-29 19:00:00 | NQ | Futures | 17889.27 | 17908.67 | 17885.79 | 17904.91 | 3163.0 |
| 2021-08-29 20:00:00 | NQ | Futures | 17905.2 | 17908.96 | 17875.65 | 17877.68 | 4676.0 |
| 2021-08-29 21:00:00 | NQ | Futures | 17877.68 | 17885.79 | 17867.54 | 17878.26 | 4530.0 |
| 2021-08-29 22:00:00 | NQ | Futures | 17878.26 | 17887.82 | 17875.07 | 17882.89 | 3116.0 |
| 2021-08-29 23:00:00 | NQ | Futures | 17883.18 | 17893.03 | 17880.58 | 17891.0 | 1877.0 |
| 2021-08-29 18:00:00 | YM | Futures | 39570.8 | 39590.9 | 39550.7 | 39573.1 | 1471.0 |
| 2021-08-29 19:00:00 | YM | Futures | 39574.2 | 39622.2 | 39567.5 | 39595.4 | 1393.0 |
| 2021-08-29 20:00:00 | YM | Futures | 39597.6 | 39609.9 | 39518.3 | 39530.6 | 2222.0 |
| 2021-08-29 21:00:00 | YM | Futures | 39531.7 | 39551.8 | 39507.1 | 39539.5 | 1803.0 |
| 2021-08-29 22:00:00 | YM | Futures | 39542.9 | 39567.5 | 39538.4 | 39555.2 | 1117.0 |
| 2021-08-29 23:00:00 | YM | Futures | 39553.0 | 39588.7 | 39548.5 | 39583.1 | 874.0 |
| 2021-08-29 18:00:00 | CL | Futures | 47.87 | 48.11 | 47.57 | 47.86 | 11588.0 |
| 2021-08-29 19:00:00 | CL | Futures | 47.84 | 47.98 | 47.83 | 47.89 | 2624.0 |
| 2021-08-29 20:00:00 | CL | Futures | 47.9 | 47.92 | 47.6 | 47.65 | 4861.0 |
| 2021-08-29 21:00:00 | CL | Futures | 47.66 | 47.68 | 47.27 | 47.39 | 10956.0 |
| 2021-08-29 22:00:00 | CL | Futures | 47.39 | 47.62 | 47.38 | 47.46 | 5563.0 |
| 2021-08-29 23:00:00 | CL | Futures | 47.46 | 47.47 | 47.34 | 47.42 | 3822.0 |
| 2021-08-29 18:00:00 | GC | Futures | 2192.8 | 2193.5 | 2191.3 | 2192.0 | 2022.0 |
| 2021-08-29 19:00:00 | GC | Futures | 2191.7 | 2192.8 | 2191.3 | 2192.2 | 981.0 |
| 2021-08-29 20:00:00 | GC | Futures | 2192.2 | 2196.0 | 2190.9 | 2195.6 | 3741.0 |
| 2021-08-29 21:00:00 | GC | Futures | 2195.6 | 2198.7 | 2190.1 | 2191.7 | 9088.0 |
| 2021-08-29 22:00:00 | GC | Futures | 2191.7 | 2193.1 | 2186.3 | 2186.4 | 4886.0 |
| 2021-08-29 23:00:00 | GC | Futures | 2186.3 | 2189.2 | 2186.1 | 2188.4 | 1731.0 |
| 2021-08-29 18:00:00 | ZN | Futures | 136.164738 | 136.228292 | 136.164738 | 136.196515 | 3597.0 |
| 2021-08-29 19:00:00 | ZN | Futures | 136.180627 | 136.212404 | 136.164738 | 136.196515 | 1563.0 |
| 2021-08-29 20:00:00 | ZN | Futures | 136.212404 | 136.244181 | 136.212404 | 136.228292 | 4417.0 |
| 2021-08-29 21:00:00 | ZN | Futures | 136.244181 | 136.244181 | 136.164738 | 136.196515 | 8292.0 |
| 2021-08-29 22:00:00 | ZN | Futures | 136.196515 | 136.212404 | 136.14885 | 136.164738 | 3574.0 |
| 2021-08-29 23:00:00 | ZN | Futures | 136.164738 | 136.180627 | 136.164738 | 136.164738 | 2626.0 |
> showing 36 of 385 rows — these rows as CSV