PREVIEW / futures_1hour / 2021-08-08
file: by_date/futures_1hour/2021/2021-08-08.parquet size: 18 KB rows: 383
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-08 00:00:00 | ES | Futures | 4978.94 | 4978.94 | 4978.94 | 4978.94 | 12.0 |
| 2021-08-08 18:00:00 | ES | Futures | 4987.38 | 4989.07 | 4980.63 | 4982.03 | 7686.0 |
| 2021-08-08 19:00:00 | ES | Futures | 4982.03 | 4982.32 | 4970.21 | 4972.74 | 15247.0 |
| 2021-08-08 20:00:00 | ES | Futures | 4972.74 | 4974.99 | 4969.64 | 4973.87 | 8627.0 |
| 2021-08-08 21:00:00 | ES | Futures | 4974.15 | 4977.25 | 4972.46 | 4974.99 | 7761.0 |
| 2021-08-08 22:00:00 | ES | Futures | 4974.99 | 4979.5 | 4974.99 | 4979.22 | 5533.0 |
| 2021-08-08 23:00:00 | ES | Futures | 4979.5 | 4981.47 | 4978.09 | 4979.22 | 3860.0 |
| 2021-08-08 18:00:00 | NQ | Futures | 17485.45 | 17491.24 | 17440.26 | 17443.74 | 4840.0 |
| 2021-08-08 19:00:00 | NQ | Futures | 17444.03 | 17445.18 | 17384.64 | 17405.79 | 8234.0 |
| 2021-08-08 20:00:00 | NQ | Futures | 17406.08 | 17417.09 | 17395.36 | 17413.61 | 4181.0 |
| 2021-08-08 21:00:00 | NQ | Futures | 17413.9 | 17425.49 | 17408.11 | 17418.53 | 4036.0 |
| 2021-08-08 22:00:00 | NQ | Futures | 17417.95 | 17434.76 | 17416.8 | 17432.44 | 2873.0 |
| 2021-08-08 23:00:00 | NQ | Futures | 17432.73 | 17437.94 | 17428.67 | 17431.86 | 1963.0 |
| 2021-08-08 18:00:00 | YM | Futures | 39215.5 | 39221.1 | 39166.4 | 39183.1 | 2096.0 |
| 2021-08-08 19:00:00 | YM | Futures | 39184.3 | 39188.7 | 39087.1 | 39107.2 | 3960.0 |
| 2021-08-08 20:00:00 | YM | Futures | 39108.3 | 39125.0 | 39082.6 | 39119.5 | 1827.0 |
| 2021-08-08 21:00:00 | YM | Futures | 39119.5 | 39141.8 | 39101.6 | 39127.3 | 1719.0 |
| 2021-08-08 22:00:00 | YM | Futures | 39128.4 | 39173.1 | 39125.0 | 39156.3 | 1205.0 |
| 2021-08-08 23:00:00 | YM | Futures | 39158.6 | 39178.7 | 39149.6 | 39157.4 | 661.0 |
| 2021-08-08 18:00:00 | CL | Futures | 46.62 | 46.63 | 45.76 | 45.98 | 9840.0 |
| 2021-08-08 19:00:00 | CL | Futures | 45.98 | 46.19 | 45.87 | 46.14 | 5334.0 |
| 2021-08-08 20:00:00 | CL | Futures | 46.13 | 46.14 | 45.92 | 46.06 | 5002.0 |
| 2021-08-08 21:00:00 | CL | Futures | 46.06 | 46.18 | 45.83 | 45.84 | 9210.0 |
| 2021-08-08 22:00:00 | CL | Futures | 45.84 | 46.05 | 45.8 | 45.87 | 5464.0 |
| 2021-08-08 23:00:00 | CL | Futures | 45.87 | 45.98 | 45.86 | 45.97 | 2995.0 |
| 2021-08-08 18:00:00 | GC | Futures | 2124.7 | 2125.5 | 2019.8 | 2059.2 | 23537.0 |
| 2021-08-08 19:00:00 | GC | Futures | 2058.8 | 2081.1 | 2039.5 | 2072.4 | 23387.0 |
| 2021-08-08 20:00:00 | GC | Futures | 2072.4 | 2084.6 | 2058.5 | 2083.0 | 15429.0 |
| 2021-08-08 21:00:00 | GC | Futures | 2083.0 | 2098.8 | 2082.9 | 2090.3 | 18054.0 |
| 2021-08-08 22:00:00 | GC | Futures | 2090.3 | 2098.6 | 2088.8 | 2096.4 | 7084.0 |
| 2021-08-08 23:00:00 | GC | Futures | 2096.4 | 2096.9 | 2091.6 | 2093.6 | 4206.0 |
| 2021-08-08 18:00:00 | ZN | Futures | 136.164738 | 136.228292 | 136.132961 | 136.132961 | 15599.0 |
| 2021-08-08 19:00:00 | ZN | Futures | 136.14885 | 136.14885 | 136.101184 | 136.117072 | 10379.0 |
| 2021-08-08 20:00:00 | ZN | Futures | 136.132961 | 136.196515 | 136.101184 | 136.180627 | 12781.0 |
| 2021-08-08 21:00:00 | ZN | Futures | 136.164738 | 136.228292 | 136.164738 | 136.196515 | 5948.0 |
| 2021-08-08 22:00:00 | ZN | Futures | 136.180627 | 136.196515 | 136.132961 | 136.164738 | 6414.0 |
| 2021-08-08 23:00:00 | ZN | Futures | 136.164738 | 136.164738 | 136.14885 | 136.164738 | 991.0 |
> showing 37 of 383 rows — these rows as CSV