PREVIEW / futures_1hour / 2018-05-27
file: by_date/futures_1hour/2018/2018-05-27.parquet size: 14 KB rows: 269
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-05-27 18:00:00 | ES | Futures | 2979.06 | 2981.25 | 2975.79 | 2975.79 | 8126.0 |
| 2018-05-27 19:00:00 | ES | Futures | 2976.06 | 2980.16 | 2975.79 | 2979.61 | 3254.0 |
| 2018-05-27 20:00:00 | ES | Futures | 2979.61 | 2981.25 | 2977.97 | 2978.52 | 4585.0 |
| 2018-05-27 21:00:00 | ES | Futures | 2978.52 | 2981.25 | 2976.88 | 2978.25 | 4143.0 |
| 2018-05-27 22:00:00 | ES | Futures | 2977.97 | 2980.43 | 2977.7 | 2979.34 | 2505.0 |
| 2018-05-27 23:00:00 | ES | Futures | 2979.06 | 2980.16 | 2978.25 | 2978.79 | 1893.0 |
| 2018-05-27 18:00:00 | NQ | Futures | 8261.9 | 8274.9 | 8250.37 | 8252.14 | 1829.0 |
| 2018-05-27 19:00:00 | NQ | Futures | 8253.03 | 8266.92 | 8252.74 | 8264.56 | 1471.0 |
| 2018-05-27 20:00:00 | NQ | Futures | 8264.26 | 8271.94 | 8264.26 | 8268.4 | 1803.0 |
| 2018-05-27 21:00:00 | NQ | Futures | 8268.1 | 8274.6 | 8259.83 | 8267.51 | 1745.0 |
| 2018-05-27 22:00:00 | NQ | Futures | 8267.22 | 8274.01 | 8266.33 | 8273.42 | 775.0 |
| 2018-05-27 23:00:00 | NQ | Futures | 8273.42 | 8274.9 | 8265.15 | 8269.28 | 743.0 |
| 2018-05-27 18:00:00 | YM | Futures | 26960.5 | 26974.6 | 26934.5 | 26935.5 | 1392.0 |
| 2018-05-27 19:00:00 | YM | Futures | 26937.7 | 26969.2 | 26937.7 | 26963.8 | 470.0 |
| 2018-05-27 20:00:00 | YM | Futures | 26962.7 | 26976.8 | 26937.7 | 26945.3 | 1342.0 |
| 2018-05-27 21:00:00 | YM | Futures | 26944.2 | 26967.0 | 26923.6 | 26938.8 | 1331.0 |
| 2018-05-27 22:00:00 | YM | Futures | 26936.6 | 26956.2 | 26935.5 | 26948.6 | 600.0 |
| 2018-05-27 23:00:00 | YM | Futures | 26949.7 | 26955.1 | 26941.0 | 26947.5 | 496.0 |
| 2018-05-27 18:00:00 | CL | Futures | 60.4 | 60.4 | 59.91 | 60.19 | 11151.0 |
| 2018-05-27 19:00:00 | CL | Futures | 60.18 | 60.24 | 60.03 | 60.23 | 4150.0 |
| 2018-05-27 20:00:00 | CL | Futures | 60.24 | 60.28 | 59.96 | 59.97 | 5887.0 |
| 2018-05-27 21:00:00 | CL | Futures | 59.98 | 60.05 | 58.84 | 59.12 | 49949.0 |
| 2018-05-27 22:00:00 | CL | Futures | 59.11 | 59.35 | 59.01 | 59.19 | 19060.0 |
| 2018-05-27 23:00:00 | CL | Futures | 59.19 | 59.28 | 59.14 | 59.22 | 4497.0 |
| 2018-05-27 18:00:00 | GC | Futures | 1714.4 | 1714.4 | 1709.0 | 1709.9 | 2065.0 |
| 2018-05-27 19:00:00 | GC | Futures | 1710.1 | 1712.6 | 1709.1 | 1711.8 | 881.0 |
| 2018-05-27 20:00:00 | GC | Futures | 1711.6 | 1712.0 | 1710.5 | 1711.8 | 1411.0 |
| 2018-05-27 21:00:00 | GC | Futures | 1711.8 | 1713.0 | 1709.5 | 1711.2 | 2095.0 |
| 2018-05-27 22:00:00 | GC | Futures | 1711.1 | 1711.6 | 1709.7 | 1710.3 | 1734.0 |
| 2018-05-27 23:00:00 | GC | Futures | 1710.3 | 1712.2 | 1709.8 | 1711.4 | 1681.0 |
| 2018-05-27 18:00:00 | ZN | Futures | 120.196896 | 120.228243 | 120.087185 | 120.134204 | 33309.0 |
| 2018-05-27 19:00:00 | ZN | Futures | 120.134204 | 120.149877 | 120.118531 | 120.134204 | 5891.0 |
| 2018-05-27 20:00:00 | ZN | Futures | 120.134204 | 120.181223 | 120.118531 | 120.181223 | 15048.0 |
| 2018-05-27 21:00:00 | ZN | Futures | 120.16555 | 120.181223 | 120.149877 | 120.181223 | 5067.0 |
| 2018-05-27 22:00:00 | ZN | Futures | 120.181223 | 120.181223 | 120.149877 | 120.149877 | 1686.0 |
| 2018-05-27 23:00:00 | ZN | Futures | 120.149877 | 120.181223 | 120.149877 | 120.16555 | 6003.0 |
> showing 36 of 269 rows — these rows as CSV