PREVIEW / futures_1hour / 2018-07-08
file: by_date/futures_1hour/2018/2018-07-08.parquet size: 15 KB rows: 301
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-08 18:00:00 | ES | Futures | 3010.21 | 3014.02 | 3009.94 | 3012.66 | 3378.0 |
| 2018-07-08 19:00:00 | ES | Futures | 3012.66 | 3015.66 | 3011.57 | 3014.29 | 3871.0 |
| 2018-07-08 20:00:00 | ES | Futures | 3014.57 | 3018.65 | 3013.75 | 3017.56 | 8558.0 |
| 2018-07-08 21:00:00 | ES | Futures | 3017.84 | 3021.92 | 3017.29 | 3021.38 | 13185.0 |
| 2018-07-08 22:00:00 | ES | Futures | 3021.65 | 3023.56 | 3021.38 | 3023.29 | 8930.0 |
| 2018-07-08 23:00:00 | ES | Futures | 3023.01 | 3023.83 | 3021.65 | 3022.47 | 4059.0 |
| 2018-07-08 18:00:00 | NQ | Futures | 8517.52 | 8525.76 | 8517.22 | 8523.41 | 1280.0 |
| 2018-07-08 19:00:00 | NQ | Futures | 8523.11 | 8529.59 | 8519.87 | 8525.17 | 1737.0 |
| 2018-07-08 20:00:00 | NQ | Futures | 8524.88 | 8545.19 | 8523.41 | 8541.36 | 3739.0 |
| 2018-07-08 21:00:00 | NQ | Futures | 8541.36 | 8554.32 | 8538.13 | 8552.55 | 4717.0 |
| 2018-07-08 22:00:00 | NQ | Futures | 8553.14 | 8561.68 | 8553.14 | 8558.15 | 3188.0 |
| 2018-07-08 23:00:00 | NQ | Futures | 8557.85 | 8559.62 | 8551.38 | 8552.85 | 1721.0 |
| 2018-07-08 18:00:00 | YM | Futures | 26588.2 | 26627.3 | 26583.8 | 26618.6 | 1096.0 |
| 2018-07-08 19:00:00 | YM | Futures | 26618.6 | 26662.1 | 26605.6 | 26641.4 | 1227.0 |
| 2018-07-08 20:00:00 | YM | Futures | 26643.6 | 26690.4 | 26632.7 | 26678.4 | 2285.0 |
| 2018-07-08 21:00:00 | YM | Futures | 26678.4 | 26717.5 | 26671.9 | 26709.9 | 3203.0 |
| 2018-07-08 22:00:00 | YM | Futures | 26709.9 | 26725.1 | 26709.9 | 26718.6 | 1585.0 |
| 2018-07-08 23:00:00 | YM | Futures | 26719.7 | 26748.0 | 26711.0 | 26733.8 | 1760.0 |
| 2018-07-08 18:00:00 | CL | Futures | 66.13 | 66.5 | 66.1 | 66.18 | 3844.0 |
| 2018-07-08 19:00:00 | CL | Futures | 66.18 | 66.2 | 66.02 | 66.15 | 3122.0 |
| 2018-07-08 20:00:00 | CL | Futures | 66.14 | 66.17 | 66.02 | 66.07 | 5399.0 |
| 2018-07-08 21:00:00 | CL | Futures | 66.07 | 66.37 | 66.07 | 66.33 | 6693.0 |
| 2018-07-08 22:00:00 | CL | Futures | 66.34 | 66.39 | 66.27 | 66.38 | 5439.0 |
| 2018-07-08 23:00:00 | CL | Futures | 66.38 | 66.43 | 66.28 | 66.32 | 4137.0 |
| 2018-07-08 18:00:00 | GC | Futures | 1648.7 | 1650.6 | 1648.7 | 1650.2 | 1591.0 |
| 2018-07-08 19:00:00 | GC | Futures | 1650.2 | 1651.2 | 1649.9 | 1651.0 | 2377.0 |
| 2018-07-08 20:00:00 | GC | Futures | 1650.9 | 1651.5 | 1649.5 | 1651.2 | 4860.0 |
| 2018-07-08 21:00:00 | GC | Futures | 1651.2 | 1655.3 | 1649.9 | 1653.9 | 8759.0 |
| 2018-07-08 22:00:00 | GC | Futures | 1653.7 | 1654.8 | 1652.8 | 1653.6 | 6642.0 |
| 2018-07-08 23:00:00 | GC | Futures | 1653.7 | 1654.7 | 1653.1 | 1654.1 | 3239.0 |
| 2018-07-08 18:00:00 | ZN | Futures | 121.076696 | 121.092412 | 121.045264 | 121.076696 | 6815.0 |
| 2018-07-08 19:00:00 | ZN | Futures | 121.092412 | 121.092412 | 121.06098 | 121.076696 | 7035.0 |
| 2018-07-08 20:00:00 | ZN | Futures | 121.076696 | 121.076696 | 120.9824 | 121.013832 | 16617.0 |
| 2018-07-08 21:00:00 | ZN | Futures | 121.013832 | 121.013832 | 120.935251 | 120.950967 | 13209.0 |
| 2018-07-08 22:00:00 | ZN | Futures | 120.935251 | 120.950967 | 120.903819 | 120.935251 | 9711.0 |
| 2018-07-08 23:00:00 | ZN | Futures | 120.950967 | 120.966683 | 120.935251 | 120.950967 | 2817.0 |
> showing 36 of 301 rows — these rows as CSV