PREVIEW / futures_1hour / 2017-12-17
file: by_date/futures_1hour/2017/2017-12-17.parquet size: 14 KB rows: 290
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-17 18:00:00 | ES | Futures | 2933.36 | 2937.46 | 2932.81 | 2936.64 | 12956.0 |
| 2017-12-17 19:00:00 | ES | Futures | 2936.91 | 2938.0 | 2936.09 | 2936.91 | 8768.0 |
| 2017-12-17 20:00:00 | ES | Futures | 2936.91 | 2937.18 | 2935.0 | 2936.91 | 7206.0 |
| 2017-12-17 21:00:00 | ES | Futures | 2936.91 | 2937.46 | 2936.09 | 2937.46 | 5143.0 |
| 2017-12-17 22:00:00 | ES | Futures | 2937.46 | 2938.82 | 2936.91 | 2938.55 | 4517.0 |
| 2017-12-17 23:00:00 | ES | Futures | 2938.55 | 2939.64 | 2938.28 | 2938.55 | 3837.0 |
| 2017-12-17 18:00:00 | NQ | Futures | 7709.08 | 7728.65 | 7708.48 | 7726.28 | 3435.0 |
| 2017-12-17 19:00:00 | NQ | Futures | 7725.98 | 7732.21 | 7725.39 | 7728.95 | 2065.0 |
| 2017-12-17 20:00:00 | NQ | Futures | 7728.65 | 7730.73 | 7722.42 | 7730.14 | 2387.0 |
| 2017-12-17 21:00:00 | NQ | Futures | 7730.14 | 7733.7 | 7728.95 | 7731.62 | 1406.0 |
| 2017-12-17 22:00:00 | NQ | Futures | 7731.62 | 7736.07 | 7730.14 | 7735.47 | 1226.0 |
| 2017-12-17 23:00:00 | NQ | Futures | 7735.77 | 7737.85 | 7735.18 | 7736.36 | 1121.0 |
| 2017-12-17 18:00:00 | YM | Futures | 26849.2 | 26897.0 | 26838.3 | 26894.9 | 3468.0 |
| 2017-12-17 19:00:00 | YM | Futures | 26894.9 | 26910.1 | 26892.7 | 26900.3 | 1782.0 |
| 2017-12-17 20:00:00 | YM | Futures | 26901.4 | 26904.6 | 26886.2 | 26902.5 | 1689.0 |
| 2017-12-17 21:00:00 | YM | Futures | 26902.5 | 26922.0 | 26892.7 | 26902.5 | 1580.0 |
| 2017-12-17 22:00:00 | YM | Futures | 26903.5 | 26922.0 | 26900.3 | 26920.9 | 1148.0 |
| 2017-12-17 23:00:00 | YM | Futures | 26920.9 | 26944.8 | 26917.7 | 26925.3 | 1508.0 |
| 2017-12-17 18:00:00 | CL | Futures | 50.92 | 50.97 | 50.9 | 50.94 | 1904.0 |
| 2017-12-17 19:00:00 | CL | Futures | 50.94 | 50.95 | 50.88 | 50.89 | 2188.0 |
| 2017-12-17 20:00:00 | CL | Futures | 50.89 | 50.93 | 50.87 | 50.89 | 1933.0 |
| 2017-12-17 21:00:00 | CL | Futures | 50.9 | 50.94 | 50.89 | 50.9 | 2394.0 |
| 2017-12-17 22:00:00 | CL | Futures | 50.89 | 50.97 | 50.89 | 50.95 | 1817.0 |
| 2017-12-17 23:00:00 | CL | Futures | 50.96 | 50.96 | 50.92 | 50.93 | 1211.0 |
| 2017-12-17 18:00:00 | GC | Futures | 1670.4 | 1670.5 | 1668.8 | 1668.9 | 2276.0 |
| 2017-12-17 19:00:00 | GC | Futures | 1668.9 | 1669.7 | 1668.5 | 1669.5 | 3267.0 |
| 2017-12-17 20:00:00 | GC | Futures | 1669.3 | 1669.5 | 1667.1 | 1668.5 | 6171.0 |
| 2017-12-17 21:00:00 | GC | Futures | 1668.4 | 1670.9 | 1668.4 | 1669.9 | 5482.0 |
| 2017-12-17 22:00:00 | GC | Futures | 1669.9 | 1670.8 | 1669.6 | 1669.9 | 2614.0 |
| 2017-12-17 23:00:00 | GC | Futures | 1669.9 | 1671.3 | 1669.9 | 1670.8 | 2446.0 |
| 2017-12-17 18:00:00 | ZN | Futures | 124.14304 | 124.14304 | 124.049488 | 124.049488 | 14606.0 |
| 2017-12-17 19:00:00 | ZN | Futures | 124.049488 | 124.06508 | 124.018304 | 124.049488 | 13247.0 |
| 2017-12-17 20:00:00 | ZN | Futures | 124.049488 | 124.080672 | 124.033896 | 124.049488 | 5783.0 |
| 2017-12-17 21:00:00 | ZN | Futures | 124.049488 | 124.06508 | 124.033896 | 124.033896 | 5232.0 |
| 2017-12-17 22:00:00 | ZN | Futures | 124.033896 | 124.06508 | 124.018304 | 124.06508 | 6378.0 |
| 2017-12-17 23:00:00 | ZN | Futures | 124.06508 | 124.096264 | 124.049488 | 124.06508 | 7251.0 |
> showing 36 of 290 rows — these rows as CSV