PREVIEW / futures_1hour / 2018-06-17
file: by_date/futures_1hour/2018/2018-06-17.parquet size: 15 KB rows: 304
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-06-17 18:00:00 | ES | Futures | 3029.83 | 3037.18 | 3028.74 | 3036.36 | 8076.0 |
| 2018-06-17 19:00:00 | ES | Futures | 3036.36 | 3036.64 | 3033.09 | 3033.37 | 3868.0 |
| 2018-06-17 20:00:00 | ES | Futures | 3033.37 | 3033.64 | 3021.38 | 3023.29 | 14527.0 |
| 2018-06-17 21:00:00 | ES | Futures | 3023.56 | 3023.83 | 3018.11 | 3019.2 | 13337.0 |
| 2018-06-17 22:00:00 | ES | Futures | 3019.2 | 3021.65 | 3016.75 | 3021.11 | 10035.0 |
| 2018-06-17 23:00:00 | ES | Futures | 3021.38 | 3021.65 | 3018.93 | 3020.02 | 3078.0 |
| 2018-06-17 18:00:00 | NQ | Futures | 8568.75 | 8584.35 | 8566.39 | 8577.28 | 1752.0 |
| 2018-06-17 19:00:00 | NQ | Futures | 8577.58 | 8582.88 | 8574.63 | 8576.7 | 1276.0 |
| 2018-06-17 20:00:00 | NQ | Futures | 8576.11 | 8576.7 | 8538.42 | 8543.13 | 4248.0 |
| 2018-06-17 21:00:00 | NQ | Futures | 8543.43 | 8544.01 | 8519.28 | 8521.64 | 4982.0 |
| 2018-06-17 22:00:00 | NQ | Futures | 8521.34 | 8529.59 | 8508.1 | 8525.47 | 3552.0 |
| 2018-06-17 23:00:00 | NQ | Futures | 8526.06 | 8530.77 | 8521.64 | 8524.29 | 1488.0 |
| 2018-06-17 18:00:00 | YM | Futures | 27258.9 | 27339.4 | 27242.6 | 27319.8 | 1629.0 |
| 2018-06-17 19:00:00 | YM | Futures | 27318.7 | 27323.1 | 27290.5 | 27294.8 | 1035.0 |
| 2018-06-17 20:00:00 | YM | Futures | 27293.7 | 27294.8 | 27180.7 | 27202.4 | 3375.0 |
| 2018-06-17 21:00:00 | YM | Futures | 27202.4 | 27206.7 | 27148.0 | 27152.4 | 2484.0 |
| 2018-06-17 22:00:00 | YM | Futures | 27151.3 | 27185.0 | 27129.6 | 27175.2 | 2285.0 |
| 2018-06-17 23:00:00 | YM | Futures | 27177.4 | 27181.7 | 27148.0 | 27155.7 | 1027.0 |
| 2018-06-17 18:00:00 | CL | Futures | 57.49 | 57.6 | 57.28 | 57.38 | 4940.0 |
| 2018-06-17 19:00:00 | CL | Futures | 57.38 | 57.5 | 57.36 | 57.48 | 2355.0 |
| 2018-06-17 20:00:00 | CL | Futures | 57.48 | 57.48 | 57.31 | 57.39 | 4429.0 |
| 2018-06-17 21:00:00 | CL | Futures | 57.39 | 57.42 | 56.76 | 56.78 | 13670.0 |
| 2018-06-17 22:00:00 | CL | Futures | 56.79 | 57.02 | 56.78 | 56.99 | 7931.0 |
| 2018-06-17 23:00:00 | CL | Futures | 56.99 | 57.01 | 56.9 | 56.97 | 3516.0 |
| 2018-06-17 18:00:00 | GC | Futures | 1682.1 | 1684.2 | 1680.5 | 1683.9 | 2334.0 |
| 2018-06-17 19:00:00 | GC | Futures | 1683.9 | 1685.8 | 1683.2 | 1685.4 | 4137.0 |
| 2018-06-17 20:00:00 | GC | Futures | 1685.3 | 1686.6 | 1685.3 | 1685.6 | 5685.0 |
| 2018-06-17 21:00:00 | GC | Futures | 1685.8 | 1687.1 | 1685.1 | 1687.1 | 5728.0 |
| 2018-06-17 22:00:00 | GC | Futures | 1687.0 | 1687.1 | 1683.0 | 1683.3 | 7941.0 |
| 2018-06-17 23:00:00 | GC | Futures | 1683.3 | 1684.6 | 1682.6 | 1684.3 | 4415.0 |
| 2018-06-17 18:00:00 | ZN | Futures | 120.306608 | 120.369472 | 120.290892 | 120.33804 | 7396.0 |
| 2018-06-17 19:00:00 | ZN | Futures | 120.33804 | 120.33804 | 120.306608 | 120.322324 | 1973.0 |
| 2018-06-17 20:00:00 | ZN | Futures | 120.322324 | 120.385188 | 120.306608 | 120.353756 | 14501.0 |
| 2018-06-17 21:00:00 | ZN | Futures | 120.353756 | 120.432337 | 120.353756 | 120.432337 | 15794.0 |
| 2018-06-17 22:00:00 | ZN | Futures | 120.432337 | 120.448053 | 120.385188 | 120.416621 | 8110.0 |
| 2018-06-17 23:00:00 | ZN | Futures | 120.400905 | 120.432337 | 120.400905 | 120.416621 | 1759.0 |
> showing 36 of 304 rows — these rows as CSV