PREVIEW / futures_1hour / 2014-10-12
file: by_date/futures_1hour/2014/2014-10-12.parquet size: 14 KB rows: 275
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-12 18:00:00 | ES | Futures | 1982.57 | 1982.83 | 1970.52 | 1972.61 | 73474.0 |
| 2014-10-12 19:00:00 | ES | Futures | 1972.61 | 1976.54 | 1972.61 | 1976.28 | 18127.0 |
| 2014-10-12 20:00:00 | ES | Futures | 1976.02 | 1977.07 | 1974.71 | 1976.28 | 19634.0 |
| 2014-10-12 21:00:00 | ES | Futures | 1976.02 | 1977.85 | 1974.97 | 1977.33 | 12811.0 |
| 2014-10-12 22:00:00 | ES | Futures | 1977.33 | 1978.12 | 1973.92 | 1975.23 | 18790.0 |
| 2014-10-12 23:00:00 | ES | Futures | 1975.23 | 1975.5 | 1973.14 | 1973.66 | 8918.0 |
| 2014-10-12 18:00:00 | NQ | Futures | 4510.53 | 4512.29 | 4484.75 | 4490.31 | 5111.0 |
| 2014-10-12 19:00:00 | NQ | Futures | 4490.31 | 4499.4 | 4489.43 | 4498.81 | 1921.0 |
| 2014-10-12 20:00:00 | NQ | Futures | 4497.93 | 4500.27 | 4493.83 | 4497.05 | 3283.0 |
| 2014-10-12 21:00:00 | NQ | Futures | 4496.47 | 4500.86 | 4494.41 | 4499.4 | 2738.0 |
| 2014-10-12 22:00:00 | NQ | Futures | 4499.4 | 4501.15 | 4489.73 | 4491.19 | 4439.0 |
| 2014-10-12 23:00:00 | NQ | Futures | 4490.9 | 4492.66 | 4485.04 | 4485.62 | 2781.0 |
| 2014-10-12 18:00:00 | YM | Futures | 17072.9 | 17080.2 | 16983.5 | 16998.0 | 7108.0 |
| 2014-10-12 19:00:00 | YM | Futures | 16999.1 | 17031.3 | 16999.1 | 17030.3 | 1373.0 |
| 2014-10-12 20:00:00 | YM | Futures | 17028.2 | 17033.4 | 17015.7 | 17027.2 | 2834.0 |
| 2014-10-12 21:00:00 | YM | Futures | 17027.2 | 17040.7 | 17019.9 | 17036.5 | 1509.0 |
| 2014-10-12 22:00:00 | YM | Futures | 17036.5 | 17042.8 | 17004.3 | 17011.6 | 2859.0 |
| 2014-10-12 23:00:00 | YM | Futures | 17011.6 | 17016.8 | 16991.8 | 16993.9 | 1565.0 |
| 2014-10-12 18:00:00 | CL | Futures | 141.93 | 142.65 | 140.35 | 140.75 | 4659.0 |
| 2014-10-12 19:00:00 | CL | Futures | 140.72 | 141.52 | 140.58 | 141.32 | 1781.0 |
| 2014-10-12 20:00:00 | CL | Futures | 141.27 | 141.32 | 140.78 | 140.87 | 2514.0 |
| 2014-10-12 21:00:00 | CL | Futures | 140.88 | 141.55 | 140.82 | 141.38 | 1760.0 |
| 2014-10-12 22:00:00 | CL | Futures | 141.35 | 141.55 | 141.17 | 141.37 | 1221.0 |
| 2014-10-12 23:00:00 | CL | Futures | 141.37 | 141.43 | 140.92 | 140.97 | 1139.0 |
| 2014-10-12 18:00:00 | GC | Futures | 1676.7 | 1685.9 | 1675.0 | 1684.1 | 5089.0 |
| 2014-10-12 19:00:00 | GC | Futures | 1684.1 | 1687.4 | 1684.1 | 1685.4 | 2224.0 |
| 2014-10-12 20:00:00 | GC | Futures | 1685.6 | 1685.9 | 1683.1 | 1684.1 | 2236.0 |
| 2014-10-12 21:00:00 | GC | Futures | 1684.4 | 1691.6 | 1683.0 | 1688.5 | 6886.0 |
| 2014-10-12 22:00:00 | GC | Futures | 1688.5 | 1690.1 | 1687.6 | 1688.9 | 2368.0 |
| 2014-10-12 23:00:00 | GC | Futures | 1688.7 | 1689.6 | 1687.6 | 1687.8 | 895.0 |
| 2014-10-12 18:00:00 | ZN | Futures | 119.961396 | 120.316267 | 119.90225 | 120.271908 | 31409.0 |
| 2014-10-12 19:00:00 | ZN | Futures | 120.286695 | 120.286695 | 120.227549 | 120.227549 | 6179.0 |
| 2014-10-12 20:00:00 | ZN | Futures | 120.227549 | 120.257122 | 120.212763 | 120.242336 | 4879.0 |
| 2014-10-12 21:00:00 | ZN | Futures | 120.242336 | 120.271908 | 120.242336 | 120.257122 | 4975.0 |
| 2014-10-12 22:00:00 | ZN | Futures | 120.257122 | 120.286695 | 120.212763 | 120.257122 | 5291.0 |
| 2014-10-12 23:00:00 | ZN | Futures | 120.242336 | 120.257122 | 120.242336 | 120.257122 | 1432.0 |
> showing 36 of 275 rows — these rows as CSV