PREVIEW / futures_1hour / 2021-02-07
file: by_date/futures_1hour/2021/2021-02-07.parquet size: 18 KB rows: 387
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-02-07 18:00:00 | ES | Futures | 4366.05 | 4373.34 | 4362.12 | 4367.73 | 16076.0 |
| 2021-02-07 19:00:00 | ES | Futures | 4368.01 | 4375.59 | 4363.24 | 4372.78 | 15491.0 |
| 2021-02-07 20:00:00 | ES | Futures | 4372.78 | 4378.11 | 4371.38 | 4377.27 | 9615.0 |
| 2021-02-07 21:00:00 | ES | Futures | 4377.27 | 4378.96 | 4375.59 | 4378.68 | 12298.0 |
| 2021-02-07 22:00:00 | ES | Futures | 4378.68 | 4378.96 | 4375.03 | 4375.59 | 6260.0 |
| 2021-02-07 23:00:00 | ES | Futures | 4375.59 | 4376.43 | 4373.34 | 4375.31 | 5359.0 |
| 2021-02-07 18:00:00 | NQ | Futures | 15772.69 | 15800.48 | 15751.27 | 15790.64 | 5302.0 |
| 2021-02-07 19:00:00 | NQ | Futures | 15789.19 | 15819.87 | 15774.72 | 15809.74 | 6270.0 |
| 2021-02-07 20:00:00 | NQ | Futures | 15810.03 | 15846.21 | 15805.98 | 15837.52 | 5892.0 |
| 2021-02-07 21:00:00 | NQ | Futures | 15837.24 | 15843.02 | 15822.18 | 15833.47 | 4861.0 |
| 2021-02-07 22:00:00 | NQ | Futures | 15833.47 | 15839.84 | 15823.63 | 15829.71 | 3142.0 |
| 2021-02-07 23:00:00 | NQ | Futures | 15829.42 | 15833.18 | 15824.79 | 15829.13 | 1689.0 |
| 2021-02-07 18:00:00 | YM | Futures | 34524.8 | 34567.0 | 34454.9 | 34474.9 | 4011.0 |
| 2021-02-07 19:00:00 | YM | Futures | 34476.0 | 34565.8 | 34440.5 | 34530.4 | 3434.0 |
| 2021-02-07 20:00:00 | YM | Futures | 34527.0 | 34572.5 | 34521.5 | 34565.8 | 1696.0 |
| 2021-02-07 21:00:00 | YM | Futures | 34564.7 | 34636.8 | 34550.3 | 34635.7 | 4190.0 |
| 2021-02-07 22:00:00 | YM | Futures | 34637.9 | 34637.9 | 34592.5 | 34605.8 | 1708.0 |
| 2021-02-07 23:00:00 | YM | Futures | 34605.8 | 34609.1 | 34579.2 | 34592.5 | 802.0 |
| 2021-02-07 18:00:00 | CL | Futures | 38.62 | 38.85 | 38.58 | 38.85 | 5243.0 |
| 2021-02-07 19:00:00 | CL | Futures | 38.85 | 38.91 | 38.8 | 38.81 | 4094.0 |
| 2021-02-07 20:00:00 | CL | Futures | 38.81 | 38.92 | 38.79 | 38.84 | 5566.0 |
| 2021-02-07 21:00:00 | CL | Futures | 38.83 | 38.87 | 38.79 | 38.82 | 2898.0 |
| 2021-02-07 22:00:00 | CL | Futures | 38.81 | 38.88 | 38.79 | 38.87 | 2019.0 |
| 2021-02-07 23:00:00 | CL | Futures | 38.87 | 38.91 | 38.86 | 38.91 | 1489.0 |
| 2021-02-07 18:00:00 | GC | Futures | 2199.1 | 2201.0 | 2195.4 | 2199.7 | 3280.0 |
| 2021-02-07 19:00:00 | GC | Futures | 2199.7 | 2201.0 | 2193.1 | 2193.6 | 3090.0 |
| 2021-02-07 20:00:00 | GC | Futures | 2193.6 | 2197.0 | 2193.0 | 2196.4 | 3520.0 |
| 2021-02-07 21:00:00 | GC | Futures | 2196.4 | 2196.4 | 2187.2 | 2190.3 | 6085.0 |
| 2021-02-07 22:00:00 | GC | Futures | 2190.2 | 2191.6 | 2189.3 | 2190.3 | 2595.0 |
| 2021-02-07 23:00:00 | GC | Futures | 2190.3 | 2191.2 | 2189.7 | 2190.2 | 1698.0 |
| 2021-02-07 18:00:00 | ZN | Futures | 136.928867 | 136.928867 | 136.83494 | 136.913212 | 21115.0 |
| 2021-02-07 19:00:00 | ZN | Futures | 136.897558 | 136.944521 | 136.850595 | 136.897558 | 16766.0 |
| 2021-02-07 20:00:00 | ZN | Futures | 136.897558 | 136.913212 | 136.83494 | 136.850595 | 12879.0 |
| 2021-02-07 21:00:00 | ZN | Futures | 136.866249 | 136.897558 | 136.850595 | 136.881903 | 14161.0 |
| 2021-02-07 22:00:00 | ZN | Futures | 136.881903 | 136.897558 | 136.850595 | 136.866249 | 9511.0 |
| 2021-02-07 23:00:00 | ZN | Futures | 136.866249 | 136.866249 | 136.803631 | 136.819286 | 27417.0 |
> showing 36 of 387 rows — these rows as CSV