PREVIEW / futures_1hour / 2018-03-18
file: by_date/futures_1hour/2018/2018-03-18.parquet size: 15 KB rows: 298
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-03-18 18:00:00 | ES | Futures | 3008.81 | 3009.08 | 3003.08 | 3005.54 | 10373.0 |
| 2018-03-18 19:00:00 | ES | Futures | 3005.54 | 3007.17 | 3004.72 | 3005.81 | 2864.0 |
| 2018-03-18 20:00:00 | ES | Futures | 3006.08 | 3008.54 | 3002.81 | 3003.63 | 7850.0 |
| 2018-03-18 21:00:00 | ES | Futures | 3003.35 | 3003.63 | 2997.62 | 3000.62 | 15143.0 |
| 2018-03-18 22:00:00 | ES | Futures | 3000.62 | 3004.17 | 3000.62 | 3001.44 | 7464.0 |
| 2018-03-18 23:00:00 | ES | Futures | 3001.44 | 3002.53 | 3000.62 | 3001.44 | 3460.0 |
| 2018-03-18 18:00:00 | NQ | Futures | 8325.73 | 8325.73 | 8311.84 | 8317.46 | 3767.0 |
| 2018-03-18 19:00:00 | NQ | Futures | 8317.46 | 8324.55 | 8314.21 | 8318.64 | 1411.0 |
| 2018-03-18 20:00:00 | NQ | Futures | 8318.93 | 8323.96 | 8297.66 | 8300.32 | 4297.0 |
| 2018-03-18 21:00:00 | NQ | Futures | 8300.02 | 8301.2 | 8276.67 | 8285.54 | 9045.0 |
| 2018-03-18 22:00:00 | NQ | Futures | 8285.54 | 8294.11 | 8283.17 | 8283.47 | 4012.0 |
| 2018-03-18 23:00:00 | NQ | Futures | 8284.36 | 8287.02 | 8279.04 | 8281.99 | 2485.0 |
| 2018-03-18 18:00:00 | YM | Futures | 27124.5 | 27133.2 | 27071.3 | 27082.2 | 1786.0 |
| 2018-03-18 19:00:00 | YM | Futures | 27085.4 | 27095.2 | 27071.3 | 27084.3 | 786.0 |
| 2018-03-18 20:00:00 | YM | Futures | 27086.5 | 27109.3 | 27038.7 | 27046.3 | 2707.0 |
| 2018-03-18 21:00:00 | YM | Futures | 27044.2 | 27047.4 | 26995.3 | 27030.0 | 5960.0 |
| 2018-03-18 22:00:00 | YM | Futures | 27028.9 | 27062.6 | 27027.9 | 27040.9 | 3190.0 |
| 2018-03-18 23:00:00 | YM | Futures | 27042.0 | 27055.0 | 27031.1 | 27040.9 | 1291.0 |
| 2018-03-18 18:00:00 | CL | Futures | 55.58 | 55.63 | 55.51 | 55.55 | 2340.0 |
| 2018-03-18 19:00:00 | CL | Futures | 55.56 | 55.56 | 55.47 | 55.48 | 1942.0 |
| 2018-03-18 20:00:00 | CL | Futures | 55.49 | 55.55 | 55.41 | 55.44 | 3694.0 |
| 2018-03-18 21:00:00 | CL | Futures | 55.44 | 55.44 | 55.36 | 55.41 | 5870.0 |
| 2018-03-18 22:00:00 | CL | Futures | 55.41 | 55.46 | 55.4 | 55.41 | 3038.0 |
| 2018-03-18 23:00:00 | CL | Futures | 55.4 | 55.43 | 55.39 | 55.39 | 1827.0 |
| 2018-03-18 18:00:00 | GC | Futures | 1737.4 | 1739.4 | 1737.3 | 1737.7 | 1646.0 |
| 2018-03-18 19:00:00 | GC | Futures | 1737.7 | 1738.4 | 1737.0 | 1737.5 | 1615.0 |
| 2018-03-18 20:00:00 | GC | Futures | 1737.5 | 1737.5 | 1735.1 | 1735.4 | 6340.0 |
| 2018-03-18 21:00:00 | GC | Futures | 1735.4 | 1735.8 | 1733.5 | 1735.4 | 9239.0 |
| 2018-03-18 22:00:00 | GC | Futures | 1735.3 | 1736.1 | 1735.0 | 1735.7 | 4548.0 |
| 2018-03-18 23:00:00 | GC | Futures | 1735.7 | 1736.1 | 1735.1 | 1735.8 | 2294.0 |
| 2018-03-18 18:00:00 | ZN | Futures | 120.698435 | 120.714108 | 120.667089 | 120.682762 | 5938.0 |
| 2018-03-18 19:00:00 | ZN | Futures | 120.698435 | 120.698435 | 120.635743 | 120.635743 | 18246.0 |
| 2018-03-18 20:00:00 | ZN | Futures | 120.651416 | 120.667089 | 120.62007 | 120.667089 | 15195.0 |
| 2018-03-18 21:00:00 | ZN | Futures | 120.667089 | 120.682762 | 120.635743 | 120.651416 | 11978.0 |
| 2018-03-18 22:00:00 | ZN | Futures | 120.651416 | 120.682762 | 120.635743 | 120.651416 | 10128.0 |
| 2018-03-18 23:00:00 | ZN | Futures | 120.651416 | 120.667089 | 120.635743 | 120.651416 | 3292.0 |
> showing 36 of 298 rows — these rows as CSV