PREVIEW / futures_1hour / 2015-02-08
file: by_date/futures_1hour/2015/2015-02-08.parquet size: 14 KB rows: 280
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-08 18:00:00 | ES | Futures | 2157.85 | 2158.37 | 2149.16 | 2152.06 | 20774.0 |
| 2015-02-08 19:00:00 | ES | Futures | 2152.06 | 2155.21 | 2150.48 | 2152.32 | 7346.0 |
| 2015-02-08 20:00:00 | ES | Futures | 2152.32 | 2152.85 | 2148.37 | 2149.95 | 7970.0 |
| 2015-02-08 21:00:00 | ES | Futures | 2149.69 | 2152.58 | 2149.42 | 2152.58 | 5166.0 |
| 2015-02-08 22:00:00 | ES | Futures | 2152.58 | 2152.58 | 2151.53 | 2152.06 | 1894.0 |
| 2015-02-08 23:00:00 | ES | Futures | 2152.06 | 2153.11 | 2150.74 | 2151.0 | 1643.0 |
| 2015-02-08 18:00:00 | NQ | Futures | 4965.1 | 4965.39 | 4943.36 | 4948.94 | 1816.0 |
| 2015-02-08 19:00:00 | NQ | Futures | 4949.24 | 4956.29 | 4945.13 | 4948.94 | 1353.0 |
| 2015-02-08 20:00:00 | NQ | Futures | 4948.94 | 4949.82 | 4939.25 | 4943.95 | 1918.0 |
| 2015-02-08 21:00:00 | NQ | Futures | 4944.24 | 4951.88 | 4944.24 | 4950.71 | 1009.0 |
| 2015-02-08 22:00:00 | NQ | Futures | 4951.0 | 4951.59 | 4948.36 | 4950.12 | 363.0 |
| 2015-02-08 23:00:00 | NQ | Futures | 4949.82 | 4952.47 | 4946.59 | 4947.18 | 321.0 |
| 2015-02-08 18:00:00 | YM | Futures | 18549.7 | 18549.7 | 18480.8 | 18497.5 | 1408.0 |
| 2015-02-08 19:00:00 | YM | Futures | 18498.5 | 18525.7 | 18487.1 | 18504.8 | 783.0 |
| 2015-02-08 20:00:00 | YM | Futures | 18501.7 | 18505.9 | 18458.9 | 18476.6 | 1302.0 |
| 2015-02-08 21:00:00 | YM | Futures | 18478.7 | 18500.6 | 18477.7 | 18499.6 | 415.0 |
| 2015-02-08 22:00:00 | YM | Futures | 18498.5 | 18500.6 | 18493.3 | 18495.4 | 140.0 |
| 2015-02-08 23:00:00 | YM | Futures | 18496.5 | 18504.8 | 18490.2 | 18490.2 | 257.0 |
| 2015-02-08 18:00:00 | CL | Futures | 87.33 | 89.66 | 87.33 | 88.52 | 6429.0 |
| 2015-02-08 19:00:00 | CL | Futures | 88.48 | 88.69 | 87.75 | 87.83 | 3073.0 |
| 2015-02-08 20:00:00 | CL | Futures | 87.83 | 87.95 | 87.53 | 87.68 | 2705.0 |
| 2015-02-08 21:00:00 | CL | Futures | 87.7 | 88.17 | 87.58 | 87.85 | 2343.0 |
| 2015-02-08 22:00:00 | CL | Futures | 87.86 | 87.96 | 87.63 | 87.88 | 1717.0 |
| 2015-02-08 23:00:00 | CL | Futures | 87.85 | 87.93 | 87.49 | 87.51 | 1562.0 |
| 2015-02-08 18:00:00 | GC | Futures | 1689.1 | 1693.4 | 1687.0 | 1692.1 | 2742.0 |
| 2015-02-08 19:00:00 | GC | Futures | 1692.2 | 1692.3 | 1688.2 | 1691.2 | 1620.0 |
| 2015-02-08 20:00:00 | GC | Futures | 1691.4 | 1694.0 | 1689.2 | 1693.2 | 3648.0 |
| 2015-02-08 21:00:00 | GC | Futures | 1693.2 | 1693.7 | 1691.9 | 1692.5 | 2907.0 |
| 2015-02-08 22:00:00 | GC | Futures | 1692.5 | 1692.6 | 1689.5 | 1691.0 | 2013.0 |
| 2015-02-08 23:00:00 | GC | Futures | 1691.0 | 1691.2 | 1690.0 | 1691.2 | 546.0 |
| 2015-02-08 18:00:00 | ZN | Futures | 122.295966 | 122.414829 | 122.281108 | 122.370256 | 13984.0 |
| 2015-02-08 19:00:00 | ZN | Futures | 122.370256 | 122.518835 | 122.355398 | 122.489119 | 16730.0 |
| 2015-02-08 20:00:00 | ZN | Futures | 122.489119 | 122.503977 | 122.444545 | 122.444545 | 5891.0 |
| 2015-02-08 21:00:00 | ZN | Futures | 122.444545 | 122.533693 | 122.444545 | 122.489119 | 8288.0 |
| 2015-02-08 22:00:00 | ZN | Futures | 122.489119 | 122.518835 | 122.474261 | 122.518835 | 4154.0 |
| 2015-02-08 23:00:00 | ZN | Futures | 122.518835 | 122.518835 | 122.429687 | 122.444545 | 5249.0 |
> showing 36 of 280 rows — these rows as CSV