PREVIEW / futures_1hour / 2015-10-04
file: by_date/futures_1hour/2015/2015-10-04.parquet size: 14 KB rows: 279
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-10-04 18:00:00 | ES | Futures | 2077.47 | 2079.07 | 2073.45 | 2073.72 | 10669.0 |
| 2015-10-04 19:00:00 | ES | Futures | 2073.72 | 2079.07 | 2073.72 | 2078.54 | 6867.0 |
| 2015-10-04 20:00:00 | ES | Futures | 2078.54 | 2079.07 | 2075.06 | 2075.86 | 9432.0 |
| 2015-10-04 21:00:00 | ES | Futures | 2075.86 | 2076.66 | 2073.72 | 2074.52 | 6887.0 |
| 2015-10-04 22:00:00 | ES | Futures | 2074.52 | 2079.61 | 2074.52 | 2078.54 | 5746.0 |
| 2015-10-04 23:00:00 | ES | Futures | 2078.54 | 2084.42 | 2078.0 | 2081.75 | 8197.0 |
| 2015-10-04 18:00:00 | NQ | Futures | 5049.54 | 5053.99 | 5040.94 | 5042.42 | 1101.0 |
| 2015-10-04 19:00:00 | NQ | Futures | 5042.72 | 5056.06 | 5042.42 | 5054.88 | 1156.0 |
| 2015-10-04 20:00:00 | NQ | Futures | 5054.58 | 5057.25 | 5046.28 | 5050.13 | 1806.0 |
| 2015-10-04 21:00:00 | NQ | Futures | 5049.84 | 5051.32 | 5043.02 | 5043.61 | 1898.0 |
| 2015-10-04 22:00:00 | NQ | Futures | 5043.91 | 5056.36 | 5043.91 | 5053.99 | 1339.0 |
| 2015-10-04 23:00:00 | NQ | Futures | 5053.69 | 5066.74 | 5052.8 | 5062.29 | 1824.0 |
| 2015-10-04 18:00:00 | YM | Futures | 17323.0 | 17340.0 | 17295.5 | 17302.9 | 971.0 |
| 2015-10-04 19:00:00 | YM | Futures | 17302.9 | 17341.0 | 17301.8 | 17338.9 | 732.0 |
| 2015-10-04 20:00:00 | YM | Futures | 17337.9 | 17341.0 | 17312.4 | 17317.7 | 1566.0 |
| 2015-10-04 21:00:00 | YM | Futures | 17316.7 | 17323.0 | 17298.7 | 17306.1 | 1187.0 |
| 2015-10-04 22:00:00 | YM | Futures | 17306.1 | 17343.2 | 17306.1 | 17335.7 | 976.0 |
| 2015-10-04 23:00:00 | YM | Futures | 17334.7 | 17378.1 | 17328.3 | 17365.4 | 1736.0 |
| 2015-10-04 18:00:00 | CL | Futures | 65.31 | 65.44 | 64.68 | 64.72 | 2425.0 |
| 2015-10-04 19:00:00 | CL | Futures | 64.72 | 65.08 | 64.69 | 65.03 | 776.0 |
| 2015-10-04 20:00:00 | CL | Futures | 65.05 | 65.46 | 65.03 | 65.26 | 2383.0 |
| 2015-10-04 21:00:00 | CL | Futures | 65.26 | 65.38 | 65.22 | 65.24 | 1378.0 |
| 2015-10-04 22:00:00 | CL | Futures | 65.24 | 65.35 | 65.24 | 65.31 | 602.0 |
| 2015-10-04 23:00:00 | CL | Futures | 65.29 | 65.74 | 65.29 | 65.59 | 1858.0 |
| 2015-10-04 18:00:00 | GC | Futures | 1552.4 | 1555.4 | 1551.4 | 1551.8 | 1346.0 |
| 2015-10-04 19:00:00 | GC | Futures | 1551.7 | 1554.2 | 1551.0 | 1551.6 | 743.0 |
| 2015-10-04 20:00:00 | GC | Futures | 1551.4 | 1552.9 | 1551.0 | 1552.0 | 1437.0 |
| 2015-10-04 21:00:00 | GC | Futures | 1551.8 | 1552.4 | 1550.7 | 1551.4 | 1253.0 |
| 2015-10-04 22:00:00 | GC | Futures | 1551.4 | 1553.6 | 1551.3 | 1552.5 | 1250.0 |
| 2015-10-04 23:00:00 | GC | Futures | 1552.5 | 1552.5 | 1551.7 | 1552.4 | 504.0 |
| 2015-10-04 18:00:00 | ZN | Futures | 124.848881 | 124.909231 | 124.818706 | 124.894144 | 3108.0 |
| 2015-10-04 19:00:00 | ZN | Futures | 124.909231 | 124.939406 | 124.879056 | 124.939406 | 2559.0 |
| 2015-10-04 20:00:00 | ZN | Futures | 124.939406 | 124.939406 | 124.894144 | 124.939406 | 4371.0 |
| 2015-10-04 21:00:00 | ZN | Futures | 124.939406 | 124.984669 | 124.909231 | 124.984669 | 4379.0 |
| 2015-10-04 22:00:00 | ZN | Futures | 124.984669 | 124.999756 | 124.954494 | 124.969581 | 3157.0 |
| 2015-10-04 23:00:00 | ZN | Futures | 124.969581 | 124.969581 | 124.924319 | 124.954494 | 4476.0 |
> showing 36 of 279 rows — these rows as CSV