PREVIEW / futures_1hour / 2021-01-03
file: by_date/futures_1hour/2021/2021-01-03.parquet size: 19 KB rows: 399
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-01-03 18:00:00 | ES | Futures | 4208.59 | 4216.17 | 4201.58 | 4208.87 | 19741.0 |
| 2021-01-03 19:00:00 | ES | Futures | 4209.15 | 4209.43 | 4196.8 | 4199.61 | 17496.0 |
| 2021-01-03 20:00:00 | ES | Futures | 4199.61 | 4209.43 | 4198.77 | 4207.19 | 12653.0 |
| 2021-01-03 21:00:00 | ES | Futures | 4207.47 | 4211.4 | 4205.79 | 4206.91 | 7134.0 |
| 2021-01-03 22:00:00 | ES | Futures | 4206.63 | 4210.84 | 4206.07 | 4209.43 | 4846.0 |
| 2021-01-03 23:00:00 | ES | Futures | 4209.43 | 4211.12 | 4206.35 | 4208.03 | 3858.0 |
| 2021-01-03 18:00:00 | NQ | Futures | 14922.05 | 14940.57 | 14880.08 | 14893.1 | 8981.0 |
| 2021-01-03 19:00:00 | NQ | Futures | 14893.68 | 14896.29 | 14848.24 | 14858.66 | 7641.0 |
| 2021-01-03 20:00:00 | NQ | Futures | 14858.66 | 14881.24 | 14857.5 | 14877.76 | 6213.0 |
| 2021-01-03 21:00:00 | NQ | Futures | 14877.76 | 14896.29 | 14877.76 | 14887.31 | 4281.0 |
| 2021-01-03 22:00:00 | NQ | Futures | 14887.89 | 14904.1 | 14883.55 | 14901.21 | 2906.0 |
| 2021-01-03 23:00:00 | NQ | Futures | 14901.21 | 14908.73 | 14900.92 | 14905.26 | 2319.0 |
| 2021-01-03 18:00:00 | YM | Futures | 33809.4 | 33868.2 | 33756.1 | 33836.0 | 3685.0 |
| 2021-01-03 19:00:00 | YM | Futures | 33836.0 | 33836.0 | 33736.2 | 33752.8 | 3897.0 |
| 2021-01-03 20:00:00 | YM | Futures | 33751.7 | 33843.8 | 33749.5 | 33828.2 | 2816.0 |
| 2021-01-03 21:00:00 | YM | Futures | 33829.3 | 33860.4 | 33813.8 | 33822.7 | 1732.0 |
| 2021-01-03 22:00:00 | YM | Futures | 33822.7 | 33858.2 | 33816.0 | 33842.7 | 1202.0 |
| 2021-01-03 23:00:00 | YM | Futures | 33844.9 | 33858.2 | 33812.7 | 33824.9 | 786.0 |
| 2021-01-03 18:00:00 | CL | Futures | 32.78 | 32.86 | 32.59 | 32.8 | 5333.0 |
| 2021-01-03 19:00:00 | CL | Futures | 32.8 | 32.83 | 32.76 | 32.78 | 2204.0 |
| 2021-01-03 20:00:00 | CL | Futures | 32.78 | 33.04 | 32.78 | 33.03 | 7640.0 |
| 2021-01-03 21:00:00 | CL | Futures | 33.03 | 33.41 | 33.01 | 33.3 | 8590.0 |
| 2021-01-03 22:00:00 | CL | Futures | 33.31 | 33.35 | 33.15 | 33.17 | 6238.0 |
| 2021-01-03 23:00:00 | CL | Futures | 33.18 | 33.24 | 33.15 | 33.22 | 1816.0 |
| 2021-01-03 18:00:00 | GC | Futures | 2312.7 | 2325.7 | 2310.2 | 2323.9 | 15099.0 |
| 2021-01-03 19:00:00 | GC | Futures | 2323.5 | 2325.2 | 2320.5 | 2324.5 | 4126.0 |
| 2021-01-03 20:00:00 | GC | Futures | 2324.5 | 2331.1 | 2323.3 | 2328.8 | 11497.0 |
| 2021-01-03 21:00:00 | GC | Futures | 2328.8 | 2334.3 | 2327.4 | 2333.9 | 6499.0 |
| 2021-01-03 22:00:00 | GC | Futures | 2334.1 | 2338.2 | 2332.8 | 2336.0 | 5757.0 |
| 2021-01-03 23:00:00 | GC | Futures | 2335.9 | 2336.6 | 2332.5 | 2335.4 | 3039.0 |
| 2021-01-03 18:00:00 | ZN | Futures | 138.22818 | 138.243834 | 138.196871 | 138.212526 | 26472.0 |
| 2021-01-03 19:00:00 | ZN | Futures | 138.22818 | 138.243834 | 138.181217 | 138.212526 | 16272.0 |
| 2021-01-03 20:00:00 | ZN | Futures | 138.196871 | 138.196871 | 138.134254 | 138.134254 | 21426.0 |
| 2021-01-03 21:00:00 | ZN | Futures | 138.134254 | 138.149908 | 138.102945 | 138.102945 | 20347.0 |
| 2021-01-03 22:00:00 | ZN | Futures | 138.102945 | 138.118599 | 138.102945 | 138.118599 | 5981.0 |
| 2021-01-03 23:00:00 | ZN | Futures | 138.102945 | 138.134254 | 138.087291 | 138.134254 | 5989.0 |
> showing 36 of 399 rows — these rows as CSV