PREVIEW / futures_1hour / 2020-12-06
file: by_date/futures_1hour/2020/2020-12-06.parquet size: 17 KB rows: 380
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-06 18:00:00 | ES | Futures | 4139.52 | 4151.0 | 4137.56 | 4144.56 | 15176.0 |
| 2020-12-06 19:00:00 | ES | Futures | 4144.28 | 4145.4 | 4137.0 | 4143.16 | 12794.0 |
| 2020-12-06 20:00:00 | ES | Futures | 4143.16 | 4145.4 | 4138.12 | 4139.24 | 11880.0 |
| 2020-12-06 21:00:00 | ES | Futures | 4139.24 | 4139.52 | 4131.95 | 4134.76 | 8979.0 |
| 2020-12-06 22:00:00 | ES | Futures | 4134.76 | 4136.16 | 4129.99 | 4130.55 | 6451.0 |
| 2020-12-06 23:00:00 | ES | Futures | 4130.55 | 4133.91 | 4129.43 | 4133.63 | 4100.0 |
| 2020-12-06 18:00:00 | NQ | Futures | 14502.38 | 14557.38 | 14500.65 | 14525.54 | 5470.0 |
| 2020-12-06 19:00:00 | NQ | Futures | 14525.25 | 14535.96 | 14503.83 | 14528.43 | 4435.0 |
| 2020-12-06 20:00:00 | NQ | Futures | 14527.86 | 14535.38 | 14505.86 | 14513.38 | 4052.0 |
| 2020-12-06 21:00:00 | NQ | Futures | 14513.67 | 14516.57 | 14492.54 | 14498.33 | 3071.0 |
| 2020-12-06 22:00:00 | NQ | Futures | 14500.07 | 14503.54 | 14486.46 | 14487.91 | 2432.0 |
| 2020-12-06 23:00:00 | NQ | Futures | 14487.33 | 14497.75 | 14484.72 | 14494.86 | 1541.0 |
| 2020-12-06 18:00:00 | YM | Futures | 33361.0 | 33461.6 | 33357.6 | 33417.3 | 3189.0 |
| 2020-12-06 19:00:00 | YM | Futures | 33417.3 | 33420.7 | 33344.4 | 33401.9 | 3529.0 |
| 2020-12-06 20:00:00 | YM | Futures | 33397.4 | 33417.3 | 33351.0 | 33361.0 | 2483.0 |
| 2020-12-06 21:00:00 | YM | Futures | 33363.2 | 33365.4 | 33294.6 | 33323.4 | 2454.0 |
| 2020-12-06 22:00:00 | YM | Futures | 33324.5 | 33337.7 | 33280.3 | 33289.1 | 1921.0 |
| 2020-12-06 23:00:00 | YM | Futures | 33289.1 | 33324.5 | 33282.5 | 33323.4 | 1070.0 |
| 2020-12-06 18:00:00 | CL | Futures | 31.36 | 31.43 | 31.31 | 31.31 | 2433.0 |
| 2020-12-06 19:00:00 | CL | Futures | 31.31 | 31.32 | 31.25 | 31.29 | 2178.0 |
| 2020-12-06 20:00:00 | CL | Futures | 31.28 | 31.39 | 31.26 | 31.31 | 3699.0 |
| 2020-12-06 21:00:00 | CL | Futures | 31.31 | 31.35 | 31.21 | 31.31 | 2394.0 |
| 2020-12-06 22:00:00 | CL | Futures | 31.3 | 31.33 | 31.26 | 31.3 | 1522.0 |
| 2020-12-06 23:00:00 | CL | Futures | 31.3 | 31.32 | 31.26 | 31.28 | 1167.0 |
| 2020-12-06 18:00:00 | GC | Futures | 2231.4 | 2233.7 | 2225.6 | 2228.2 | 3055.0 |
| 2020-12-06 19:00:00 | GC | Futures | 2228.2 | 2233.6 | 2227.8 | 2230.8 | 5156.0 |
| 2020-12-06 20:00:00 | GC | Futures | 2230.7 | 2233.3 | 2227.9 | 2231.5 | 5226.0 |
| 2020-12-06 21:00:00 | GC | Futures | 2231.4 | 2233.6 | 2230.2 | 2232.9 | 3323.0 |
| 2020-12-06 22:00:00 | GC | Futures | 2232.9 | 2233.6 | 2229.3 | 2231.8 | 3178.0 |
| 2020-12-06 23:00:00 | GC | Futures | 2231.8 | 2234.2 | 2230.6 | 2233.2 | 2619.0 |
| 2020-12-06 18:00:00 | ZN | Futures | 137.634308 | 137.634308 | 137.618703 | 137.618703 | 88.0 |
| 2020-12-06 19:00:00 | ZN | Futures | 137.634308 | 137.743542 | 137.618703 | 137.696727 | 202.0 |
| 2020-12-06 20:00:00 | ZN | Futures | 137.665518 | 137.727937 | 137.665518 | 137.696727 | 122.0 |
| 2020-12-06 21:00:00 | ZN | Futures | 137.696727 | 137.696727 | 137.696727 | 137.696727 | 1.0 |
| 2020-12-06 23:00:00 | ZN | Futures | 137.727937 | 137.727937 | 137.727937 | 137.727937 | 3.0 |
> showing 35 of 380 rows — these rows as CSV