PREVIEW / futures_1hour / 2015-10-18
file: by_date/futures_1hour/2015/2015-10-18.parquet size: 14 KB rows: 276
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-18 18:00:00 | ES | Futures | 2166.84 | 2168.17 | 2166.03 | 2167.37 | 4653.0 |
| 2015-10-18 19:00:00 | ES | Futures | 2167.64 | 2167.64 | 2165.23 | 2165.77 | 2907.0 |
| 2015-10-18 20:00:00 | ES | Futures | 2165.5 | 2165.77 | 2163.36 | 2163.89 | 5542.0 |
| 2015-10-18 21:00:00 | ES | Futures | 2163.62 | 2163.62 | 2160.15 | 2161.22 | 9818.0 |
| 2015-10-18 22:00:00 | ES | Futures | 2161.48 | 2165.77 | 2161.48 | 2163.36 | 12404.0 |
| 2015-10-18 23:00:00 | ES | Futures | 2163.36 | 2164.69 | 2161.48 | 2161.75 | 3823.0 |
| 2015-10-18 18:00:00 | NQ | Futures | 5259.16 | 5263.61 | 5256.19 | 5259.75 | 925.0 |
| 2015-10-18 19:00:00 | NQ | Futures | 5260.05 | 5260.05 | 5254.41 | 5255.3 | 376.0 |
| 2015-10-18 20:00:00 | NQ | Futures | 5255.3 | 5255.3 | 5249.37 | 5251.15 | 749.0 |
| 2015-10-18 21:00:00 | NQ | Futures | 5250.56 | 5250.56 | 5242.85 | 5243.74 | 1963.0 |
| 2015-10-18 22:00:00 | NQ | Futures | 5244.04 | 5256.49 | 5244.04 | 5249.08 | 2341.0 |
| 2015-10-18 23:00:00 | NQ | Futures | 5250.56 | 5253.52 | 5244.63 | 5245.22 | 804.0 |
| 2015-10-18 18:00:00 | YM | Futures | 18119.6 | 18129.1 | 18111.1 | 18121.7 | 716.0 |
| 2015-10-18 19:00:00 | YM | Futures | 18121.7 | 18122.8 | 18106.9 | 18109.0 | 682.0 |
| 2015-10-18 20:00:00 | YM | Futures | 18109.0 | 18110.1 | 18089.9 | 18093.1 | 652.0 |
| 2015-10-18 21:00:00 | YM | Futures | 18092.0 | 18092.0 | 18067.7 | 18074.0 | 1248.0 |
| 2015-10-18 22:00:00 | YM | Futures | 18075.1 | 18111.1 | 18075.1 | 18092.0 | 1826.0 |
| 2015-10-18 23:00:00 | YM | Futures | 18091.0 | 18104.8 | 18079.3 | 18082.5 | 716.0 |
| 2015-10-18 18:00:00 | CL | Futures | 67.53 | 67.8 | 67.36 | 67.76 | 895.0 |
| 2015-10-18 19:00:00 | CL | Futures | 67.74 | 67.8 | 67.56 | 67.6 | 515.0 |
| 2015-10-18 20:00:00 | CL | Futures | 67.59 | 67.6 | 67.4 | 67.47 | 1062.0 |
| 2015-10-18 21:00:00 | CL | Futures | 67.47 | 67.49 | 67.14 | 67.21 | 2209.0 |
| 2015-10-18 22:00:00 | CL | Futures | 67.23 | 67.49 | 67.23 | 67.33 | 2215.0 |
| 2015-10-18 23:00:00 | CL | Futures | 67.33 | 67.42 | 67.19 | 67.29 | 943.0 |
| 2015-10-18 18:00:00 | GC | Futures | 1606.9 | 1607.0 | 1604.5 | 1605.2 | 1066.0 |
| 2015-10-18 19:00:00 | GC | Futures | 1605.4 | 1607.7 | 1605.2 | 1607.7 | 711.0 |
| 2015-10-18 20:00:00 | GC | Futures | 1607.5 | 1608.4 | 1604.7 | 1605.1 | 1929.0 |
| 2015-10-18 21:00:00 | GC | Futures | 1605.1 | 1607.9 | 1599.9 | 1602.2 | 5115.0 |
| 2015-10-18 22:00:00 | GC | Futures | 1602.2 | 1605.4 | 1600.0 | 1601.3 | 4475.0 |
| 2015-10-18 23:00:00 | GC | Futures | 1601.1 | 1601.5 | 1598.5 | 1600.2 | 3610.0 |
| 2015-10-18 18:00:00 | ZN | Futures | 124.516957 | 124.607482 | 124.501869 | 124.577307 | 5173.0 |
| 2015-10-18 19:00:00 | ZN | Futures | 124.592394 | 124.622569 | 124.577307 | 124.592394 | 2853.0 |
| 2015-10-18 20:00:00 | ZN | Futures | 124.607482 | 124.667832 | 124.607482 | 124.652744 | 5615.0 |
| 2015-10-18 21:00:00 | ZN | Futures | 124.652744 | 124.682919 | 124.637657 | 124.652744 | 7377.0 |
| 2015-10-18 22:00:00 | ZN | Futures | 124.637657 | 124.652744 | 124.426432 | 124.44152 | 26981.0 |
| 2015-10-18 23:00:00 | ZN | Futures | 124.456607 | 124.501869 | 124.426432 | 124.501869 | 7628.0 |
> showing 36 of 276 rows — these rows as CSV