PREVIEW / futures_1hour / 2020-12-20
file: by_date/futures_1hour/2020/2020-12-20.parquet size: 19 KB rows: 409
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-20 18:00:00 | ES | Futures | 4174.35 | 4180.81 | 4155.27 | 4161.72 | 28709.0 |
| 2020-12-20 19:00:00 | ES | Futures | 4161.44 | 4166.77 | 4153.02 | 4160.88 | 19944.0 |
| 2020-12-20 20:00:00 | ES | Futures | 4160.6 | 4166.77 | 4150.49 | 4154.14 | 20671.0 |
| 2020-12-20 21:00:00 | ES | Futures | 4153.86 | 4158.07 | 4151.9 | 4156.11 | 8895.0 |
| 2020-12-20 22:00:00 | ES | Futures | 4156.39 | 4156.39 | 4151.06 | 4151.06 | 5116.0 |
| 2020-12-20 23:00:00 | ES | Futures | 4151.06 | 4156.11 | 4149.93 | 4155.55 | 5406.0 |
| 2020-12-20 18:00:00 | NQ | Futures | 14772.7 | 14798.75 | 14731.89 | 14760.54 | 8977.0 |
| 2020-12-20 19:00:00 | NQ | Futures | 14760.54 | 14769.51 | 14735.65 | 14750.41 | 6254.0 |
| 2020-12-20 20:00:00 | NQ | Futures | 14749.83 | 14769.51 | 14737.68 | 14750.7 | 6088.0 |
| 2020-12-20 21:00:00 | NQ | Futures | 14750.99 | 14763.44 | 14745.49 | 14758.52 | 3606.0 |
| 2020-12-20 22:00:00 | NQ | Futures | 14758.23 | 14759.96 | 14748.1 | 14750.7 | 2121.0 |
| 2020-12-20 23:00:00 | NQ | Futures | 14751.28 | 14767.2 | 14748.96 | 14760.83 | 2198.0 |
| 2020-12-20 18:00:00 | YM | Futures | 33608.6 | 33645.2 | 33409.0 | 33456.7 | 5746.0 |
| 2020-12-20 19:00:00 | YM | Futures | 33455.5 | 33507.7 | 33401.2 | 33463.3 | 3750.0 |
| 2020-12-20 20:00:00 | YM | Futures | 33463.3 | 33506.6 | 33362.4 | 33399.0 | 4363.0 |
| 2020-12-20 21:00:00 | YM | Futures | 33401.2 | 33430.0 | 33381.2 | 33416.7 | 2286.0 |
| 2020-12-20 22:00:00 | YM | Futures | 33417.8 | 33417.8 | 33376.8 | 33377.9 | 1354.0 |
| 2020-12-20 23:00:00 | YM | Futures | 33379.0 | 33417.8 | 33365.7 | 33414.5 | 1194.0 |
| 2020-12-20 18:00:00 | CL | Futures | 33.36 | 33.4 | 32.83 | 32.9 | 8205.0 |
| 2020-12-20 19:00:00 | CL | Futures | 32.9 | 32.91 | 32.75 | 32.77 | 4285.0 |
| 2020-12-20 20:00:00 | CL | Futures | 32.78 | 32.78 | 32.13 | 32.36 | 21083.0 |
| 2020-12-20 21:00:00 | CL | Futures | 32.37 | 32.42 | 32.23 | 32.23 | 6455.0 |
| 2020-12-20 22:00:00 | CL | Futures | 32.23 | 32.34 | 32.19 | 32.32 | 2839.0 |
| 2020-12-20 23:00:00 | CL | Futures | 32.32 | 32.42 | 32.31 | 32.38 | 3003.0 |
| 2020-12-20 18:00:00 | GC | Futures | 2294.2 | 2294.2 | 2288.1 | 2288.7 | 2471.0 |
| 2020-12-20 19:00:00 | GC | Futures | 2288.6 | 2296.5 | 2288.4 | 2295.3 | 3671.0 |
| 2020-12-20 20:00:00 | GC | Futures | 2295.2 | 2309.9 | 2294.8 | 2305.9 | 17608.0 |
| 2020-12-20 21:00:00 | GC | Futures | 2305.9 | 2308.4 | 2303.3 | 2306.2 | 4169.0 |
| 2020-12-20 22:00:00 | GC | Futures | 2306.3 | 2306.4 | 2302.4 | 2304.2 | 3298.0 |
| 2020-12-20 23:00:00 | GC | Futures | 2304.5 | 2309.5 | 2304.2 | 2309.3 | 4138.0 |
| 2020-12-20 18:00:00 | ZN | Futures | 138.009019 | 138.134254 | 138.009019 | 138.102945 | 20835.0 |
| 2020-12-20 19:00:00 | ZN | Futures | 138.102945 | 138.134254 | 138.087291 | 138.134254 | 8528.0 |
| 2020-12-20 20:00:00 | ZN | Futures | 138.118599 | 138.181217 | 138.087291 | 138.165563 | 18246.0 |
| 2020-12-20 21:00:00 | ZN | Futures | 138.165563 | 138.212526 | 138.149908 | 138.196871 | 14818.0 |
| 2020-12-20 22:00:00 | ZN | Futures | 138.196871 | 138.212526 | 138.165563 | 138.181217 | 11105.0 |
| 2020-12-20 23:00:00 | ZN | Futures | 138.165563 | 138.196871 | 138.165563 | 138.181217 | 3847.0 |
> showing 36 of 409 rows — these rows as CSV