PREVIEW / futures_1hour / 2015-01-18
file: by_date/futures_1hour/2015/2015-01-18.parquet size: 14 KB rows: 246
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-01-18 18:00:00 | ES | Futures | 2119.43 | 2119.95 | 2113.9 | 2116.53 | 7163.0 |
| 2015-01-18 19:00:00 | ES | Futures | 2116.27 | 2130.21 | 2116.0 | 2124.69 | 18014.0 |
| 2015-01-18 20:00:00 | ES | Futures | 2124.95 | 2126.0 | 2115.74 | 2119.69 | 12208.0 |
| 2015-01-18 21:00:00 | ES | Futures | 2119.69 | 2122.32 | 2117.32 | 2119.95 | 3686.0 |
| 2015-01-18 22:00:00 | ES | Futures | 2119.95 | 2119.95 | 2114.69 | 2117.06 | 4737.0 |
| 2015-01-18 23:00:00 | ES | Futures | 2117.06 | 2119.43 | 2115.74 | 2119.16 | 2773.0 |
| 2015-01-18 18:00:00 | NQ | Futures | 4862.01 | 4862.01 | 4844.98 | 4849.38 | 1164.0 |
| 2015-01-18 19:00:00 | NQ | Futures | 4848.8 | 4881.1 | 4848.5 | 4868.47 | 3027.0 |
| 2015-01-18 20:00:00 | NQ | Futures | 4868.18 | 4871.41 | 4848.5 | 4855.84 | 2454.0 |
| 2015-01-18 21:00:00 | NQ | Futures | 4855.55 | 4864.95 | 4851.14 | 4858.49 | 951.0 |
| 2015-01-18 22:00:00 | NQ | Futures | 4859.37 | 4859.37 | 4845.86 | 4852.32 | 1042.0 |
| 2015-01-18 23:00:00 | NQ | Futures | 4852.91 | 4855.26 | 4847.62 | 4854.38 | 571.0 |
| 2015-01-18 18:00:00 | YM | Futures | 18207.3 | 18207.3 | 18156.2 | 18178.1 | 791.0 |
| 2015-01-18 19:00:00 | YM | Futures | 18177.0 | 18292.9 | 18171.8 | 18251.2 | 3133.0 |
| 2015-01-18 20:00:00 | YM | Futures | 18253.2 | 18259.5 | 18177.0 | 18207.3 | 1989.0 |
| 2015-01-18 21:00:00 | YM | Futures | 18205.2 | 18230.3 | 18190.6 | 18209.4 | 607.0 |
| 2015-01-18 22:00:00 | YM | Futures | 18209.4 | 18212.5 | 18159.3 | 18182.3 | 807.0 |
| 2015-01-18 23:00:00 | YM | Futures | 18184.3 | 18200.0 | 18168.7 | 18197.9 | 481.0 |
| 2015-01-18 18:00:00 | CL | Futures | 82.61 | 82.61 | 81.89 | 82.0 | 1623.0 |
| 2015-01-18 19:00:00 | CL | Futures | 81.99 | 82.61 | 81.99 | 82.27 | 1924.0 |
| 2015-01-18 20:00:00 | CL | Futures | 82.27 | 82.31 | 81.67 | 81.73 | 3009.0 |
| 2015-01-18 21:00:00 | CL | Futures | 81.73 | 82.09 | 81.7 | 81.89 | 1796.0 |
| 2015-01-18 22:00:00 | CL | Futures | 81.87 | 82.32 | 81.72 | 82.14 | 2190.0 |
| 2015-01-18 23:00:00 | CL | Futures | 82.12 | 82.42 | 81.95 | 82.04 | 1387.0 |
| 2015-01-18 18:00:00 | GC | Futures | 1752.0 | 1753.8 | 1745.1 | 1749.7 | 4135.0 |
| 2015-01-18 19:00:00 | GC | Futures | 1749.7 | 1750.5 | 1747.9 | 1749.4 | 2710.0 |
| 2015-01-18 20:00:00 | GC | Futures | 1749.4 | 1749.9 | 1745.2 | 1745.5 | 3657.0 |
| 2015-01-18 21:00:00 | GC | Futures | 1745.3 | 1748.5 | 1744.5 | 1748.1 | 2496.0 |
| 2015-01-18 22:00:00 | GC | Futures | 1748.1 | 1748.3 | 1746.4 | 1746.6 | 1278.0 |
| 2015-01-18 23:00:00 | GC | Futures | 1746.7 | 1746.8 | 1745.3 | 1746.0 | 837.0 |
| 2015-01-18 18:00:00 | ZN | Futures | 123.44003 | 123.469745 | 123.425172 | 123.454888 | 4339.0 |
| 2015-01-18 19:00:00 | ZN | Futures | 123.454888 | 123.454888 | 123.336024 | 123.425172 | 6836.0 |
| 2015-01-18 20:00:00 | ZN | Futures | 123.410314 | 123.544035 | 123.395456 | 123.484603 | 7009.0 |
| 2015-01-18 21:00:00 | ZN | Futures | 123.484603 | 123.588609 | 123.484603 | 123.558893 | 2618.0 |
| 2015-01-18 22:00:00 | ZN | Futures | 123.558893 | 123.677757 | 123.558893 | 123.648041 | 5175.0 |
| 2015-01-18 23:00:00 | ZN | Futures | 123.662899 | 123.662899 | 123.558893 | 123.633183 | 3440.0 |
> showing 36 of 246 rows — these rows as CSV