PREVIEW / futures_1hour / 2021-06-20
file: by_date/futures_1hour/2021/2021-06-20.parquet size: 19 KB rows: 396
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-06-20 18:00:00 | ES | Futures | 4665.82 | 4677.08 | 4665.25 | 4676.24 | 15033.0 |
| 2021-06-20 19:00:00 | ES | Futures | 4676.24 | 4676.8 | 4671.45 | 4673.98 | 8502.0 |
| 2021-06-20 20:00:00 | ES | Futures | 4673.98 | 4676.24 | 4667.51 | 4672.01 | 14892.0 |
| 2021-06-20 21:00:00 | ES | Futures | 4672.01 | 4672.58 | 4660.19 | 4660.47 | 19133.0 |
| 2021-06-20 22:00:00 | ES | Futures | 4660.19 | 4661.88 | 4652.02 | 4655.96 | 21033.0 |
| 2021-06-20 23:00:00 | ES | Futures | 4655.96 | 4656.24 | 4648.08 | 4652.86 | 13335.0 |
| 2021-06-20 18:00:00 | NQ | Futures | 16248.51 | 16276.9 | 16233.74 | 16271.11 | 5792.0 |
| 2021-06-20 19:00:00 | NQ | Futures | 16271.4 | 16274.58 | 16251.99 | 16266.18 | 3543.0 |
| 2021-06-20 20:00:00 | NQ | Futures | 16266.18 | 16276.32 | 16244.17 | 16263.86 | 5230.0 |
| 2021-06-20 21:00:00 | NQ | Futures | 16264.73 | 16266.18 | 16226.5 | 16226.79 | 6279.0 |
| 2021-06-20 22:00:00 | NQ | Futures | 16226.5 | 16244.75 | 16215.78 | 16233.45 | 5962.0 |
| 2021-06-20 23:00:00 | NQ | Futures | 16233.16 | 16233.74 | 16203.32 | 16224.76 | 6123.0 |
| 2021-06-20 18:00:00 | YM | Futures | 36949.8 | 37055.9 | 36940.8 | 37044.7 | 4202.0 |
| 2021-06-20 19:00:00 | YM | Futures | 37044.7 | 37047.0 | 36993.3 | 37009.0 | 2122.0 |
| 2021-06-20 20:00:00 | YM | Futures | 37011.2 | 37030.2 | 36946.4 | 36979.9 | 3135.0 |
| 2021-06-20 21:00:00 | YM | Futures | 36982.2 | 36993.3 | 36870.4 | 36870.4 | 4286.0 |
| 2021-06-20 22:00:00 | YM | Futures | 36871.6 | 36883.8 | 36779.9 | 36814.6 | 4761.0 |
| 2021-06-20 23:00:00 | YM | Futures | 36816.8 | 36817.9 | 36759.8 | 36798.9 | 3707.0 |
| 2021-06-20 18:00:00 | CL | Futures | 48.5 | 48.79 | 48.48 | 48.77 | 3214.0 |
| 2021-06-20 19:00:00 | CL | Futures | 48.78 | 48.83 | 48.69 | 48.73 | 1914.0 |
| 2021-06-20 20:00:00 | CL | Futures | 48.73 | 48.92 | 48.67 | 48.92 | 3624.0 |
| 2021-06-20 21:00:00 | CL | Futures | 48.92 | 49.12 | 48.91 | 49.01 | 9679.0 |
| 2021-06-20 22:00:00 | CL | Futures | 49.01 | 49.1 | 49.0 | 49.08 | 4278.0 |
| 2021-06-20 23:00:00 | CL | Futures | 49.08 | 49.08 | 48.84 | 48.9 | 5801.0 |
| 2021-06-20 18:00:00 | GC | Futures | 2128.7 | 2135.8 | 2128.4 | 2134.1 | 3235.0 |
| 2021-06-20 19:00:00 | GC | Futures | 2134.1 | 2135.8 | 2132.9 | 2134.8 | 1754.0 |
| 2021-06-20 20:00:00 | GC | Futures | 2134.7 | 2139.4 | 2133.9 | 2139.4 | 4095.0 |
| 2021-06-20 21:00:00 | GC | Futures | 2139.4 | 2140.4 | 2136.1 | 2137.0 | 7004.0 |
| 2021-06-20 22:00:00 | GC | Futures | 2136.9 | 2142.8 | 2136.6 | 2142.5 | 4583.0 |
| 2021-06-20 23:00:00 | GC | Futures | 2142.5 | 2144.0 | 2140.2 | 2141.0 | 6289.0 |
| 2021-06-20 18:00:00 | ZN | Futures | 134.639439 | 134.702993 | 134.575885 | 134.575885 | 19103.0 |
| 2021-06-20 19:00:00 | ZN | Futures | 134.591773 | 134.62355 | 134.575885 | 134.607662 | 12494.0 |
| 2021-06-20 20:00:00 | ZN | Futures | 134.607662 | 134.782436 | 134.575885 | 134.718881 | 36074.0 |
| 2021-06-20 21:00:00 | ZN | Futures | 134.718881 | 134.893655 | 134.718881 | 134.830101 | 60697.0 |
| 2021-06-20 22:00:00 | ZN | Futures | 134.830101 | 134.893655 | 134.814213 | 134.877767 | 35773.0 |
| 2021-06-20 23:00:00 | ZN | Futures | 134.877767 | 135.179649 | 134.861878 | 135.052541 | 108017.0 |
> showing 36 of 396 rows — these rows as CSV