PREVIEW / futures_1hour / 2018-10-07
file: by_date/futures_1hour/2018/2018-10-07.parquet size: 15 KB rows: 300
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-10-07 18:00:00 | ES | Futures | 3152.46 | 3153.28 | 3146.75 | 3149.2 | 11799.0 |
| 2018-10-07 19:00:00 | ES | Futures | 3149.2 | 3150.56 | 3142.4 | 3145.66 | 12884.0 |
| 2018-10-07 20:00:00 | ES | Futures | 3145.93 | 3150.56 | 3144.84 | 3149.2 | 13001.0 |
| 2018-10-07 21:00:00 | ES | Futures | 3149.2 | 3152.73 | 3148.38 | 3148.38 | 12178.0 |
| 2018-10-07 22:00:00 | ES | Futures | 3148.38 | 3150.01 | 3146.2 | 3147.02 | 7934.0 |
| 2018-10-07 23:00:00 | ES | Futures | 3147.02 | 3150.83 | 3146.48 | 3148.65 | 4762.0 |
| 2018-10-07 18:00:00 | NQ | Futures | 8732.84 | 8744.57 | 8712.31 | 8725.51 | 4502.0 |
| 2018-10-07 19:00:00 | NQ | Futures | 8725.51 | 8729.62 | 8697.06 | 8709.38 | 3240.0 |
| 2018-10-07 20:00:00 | NQ | Futures | 8709.08 | 8726.98 | 8704.98 | 8721.4 | 4339.0 |
| 2018-10-07 21:00:00 | NQ | Futures | 8721.99 | 8735.78 | 8719.06 | 8719.06 | 5305.0 |
| 2018-10-07 22:00:00 | NQ | Futures | 8718.76 | 8724.34 | 8708.5 | 8712.31 | 6008.0 |
| 2018-10-07 23:00:00 | NQ | Futures | 8712.31 | 8731.08 | 8709.67 | 8717.88 | 4420.0 |
| 2018-10-07 18:00:00 | YM | Futures | 28814.3 | 28838.2 | 28758.9 | 28788.2 | 1966.0 |
| 2018-10-07 19:00:00 | YM | Futures | 28788.2 | 28804.5 | 28728.5 | 28760.0 | 2239.0 |
| 2018-10-07 20:00:00 | YM | Futures | 28758.9 | 28811.0 | 28751.3 | 28791.5 | 2222.0 |
| 2018-10-07 21:00:00 | YM | Futures | 28792.6 | 28835.0 | 28781.7 | 28783.9 | 2986.0 |
| 2018-10-07 22:00:00 | YM | Futures | 28782.8 | 28794.8 | 28755.6 | 28765.4 | 1958.0 |
| 2018-10-07 23:00:00 | YM | Futures | 28763.2 | 28803.4 | 28756.7 | 28781.7 | 1439.0 |
| 2018-10-07 18:00:00 | CL | Futures | 68.54 | 68.7 | 67.73 | 68.08 | 9484.0 |
| 2018-10-07 19:00:00 | CL | Futures | 68.08 | 68.26 | 67.96 | 68.05 | 4165.0 |
| 2018-10-07 20:00:00 | CL | Futures | 68.04 | 68.17 | 67.95 | 67.97 | 5519.0 |
| 2018-10-07 21:00:00 | CL | Futures | 67.97 | 68.17 | 67.87 | 67.95 | 7835.0 |
| 2018-10-07 22:00:00 | CL | Futures | 67.95 | 67.97 | 67.86 | 67.93 | 3621.0 |
| 2018-10-07 23:00:00 | CL | Futures | 67.93 | 68.0 | 67.89 | 67.98 | 2673.0 |
| 2018-10-07 18:00:00 | GC | Futures | 1572.2 | 1573.8 | 1571.8 | 1572.7 | 1360.0 |
| 2018-10-07 19:00:00 | GC | Futures | 1572.7 | 1573.8 | 1572.4 | 1573.5 | 1471.0 |
| 2018-10-07 20:00:00 | GC | Futures | 1573.5 | 1573.8 | 1571.2 | 1571.2 | 4791.0 |
| 2018-10-07 21:00:00 | GC | Futures | 1571.1 | 1571.2 | 1563.4 | 1564.9 | 20848.0 |
| 2018-10-07 22:00:00 | GC | Futures | 1564.9 | 1565.0 | 1561.9 | 1563.2 | 11292.0 |
| 2018-10-07 23:00:00 | GC | Futures | 1563.0 | 1564.2 | 1562.6 | 1563.7 | 3657.0 |
| 2018-10-07 18:00:00 | ZN | Futures | 118.480674 | 118.496412 | 118.40198 | 118.40198 | 12614.0 |
| 2018-10-07 19:00:00 | ZN | Futures | 118.417719 | 118.417719 | 118.276071 | 118.323287 | 28361.0 |
| 2018-10-07 20:00:00 | ZN | Futures | 118.323287 | 118.386242 | 118.323287 | 118.370503 | 4787.0 |
| 2018-10-07 21:00:00 | ZN | Futures | 118.370503 | 118.386242 | 118.323287 | 118.370503 | 6932.0 |
| 2018-10-07 22:00:00 | ZN | Futures | 118.386242 | 118.417719 | 118.370503 | 118.40198 | 6978.0 |
| 2018-10-07 23:00:00 | ZN | Futures | 118.40198 | 118.40198 | 118.370503 | 118.370503 | 1261.0 |
> showing 36 of 300 rows — these rows as CSV