PREVIEW / futures_1hour / 2016-05-22
file: by_date/futures_1hour/2016/2016-05-22.parquet size: 14 KB rows: 278
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-22 18:00:00 | ES | Futures | 2217.35 | 2217.62 | 2214.11 | 2214.65 | 5264.0 |
| 2016-05-22 19:00:00 | ES | Futures | 2214.65 | 2215.19 | 2213.84 | 2214.11 | 2742.0 |
| 2016-05-22 20:00:00 | ES | Futures | 2214.38 | 2215.19 | 2209.79 | 2210.6 | 10135.0 |
| 2016-05-22 21:00:00 | ES | Futures | 2210.87 | 2213.57 | 2208.17 | 2213.03 | 11083.0 |
| 2016-05-22 22:00:00 | ES | Futures | 2213.03 | 2214.92 | 2212.49 | 2214.38 | 4148.0 |
| 2016-05-22 23:00:00 | ES | Futures | 2214.11 | 2217.89 | 2213.57 | 2216.81 | 4322.0 |
| 2016-05-22 18:00:00 | NQ | Futures | 5198.14 | 5204.69 | 5193.98 | 5196.65 | 884.0 |
| 2016-05-22 19:00:00 | NQ | Futures | 5196.06 | 5199.03 | 5195.17 | 5196.06 | 736.0 |
| 2016-05-22 20:00:00 | NQ | Futures | 5196.36 | 5197.55 | 5185.05 | 5187.13 | 1427.0 |
| 2016-05-22 21:00:00 | NQ | Futures | 5186.84 | 5194.57 | 5180.88 | 5193.08 | 1469.0 |
| 2016-05-22 22:00:00 | NQ | Futures | 5193.08 | 5197.55 | 5192.19 | 5196.65 | 1082.0 |
| 2016-05-22 23:00:00 | NQ | Futures | 5196.95 | 5205.28 | 5195.46 | 5203.2 | 724.0 |
| 2016-05-22 18:00:00 | YM | Futures | 18736.1 | 18746.8 | 18715.8 | 18719.0 | 794.0 |
| 2016-05-22 19:00:00 | YM | Futures | 18715.8 | 18726.5 | 18713.6 | 18716.8 | 485.0 |
| 2016-05-22 20:00:00 | YM | Futures | 18717.9 | 18724.3 | 18680.4 | 18687.9 | 1609.0 |
| 2016-05-22 21:00:00 | YM | Futures | 18687.9 | 18715.8 | 18670.8 | 18710.4 | 2083.0 |
| 2016-05-22 22:00:00 | YM | Futures | 18711.5 | 18726.5 | 18708.3 | 18721.1 | 1126.0 |
| 2016-05-22 23:00:00 | YM | Futures | 18721.1 | 18750.0 | 18717.9 | 18742.5 | 1004.0 |
| 2016-05-22 18:00:00 | CL | Futures | 51.41 | 51.46 | 51.16 | 51.18 | 3079.0 |
| 2016-05-22 19:00:00 | CL | Futures | 51.17 | 51.29 | 51.02 | 51.19 | 3676.0 |
| 2016-05-22 20:00:00 | CL | Futures | 51.19 | 51.19 | 51.02 | 51.09 | 3254.0 |
| 2016-05-22 21:00:00 | CL | Futures | 51.08 | 51.16 | 51.06 | 51.08 | 3258.0 |
| 2016-05-22 22:00:00 | CL | Futures | 51.08 | 51.16 | 51.05 | 51.11 | 2006.0 |
| 2016-05-22 23:00:00 | CL | Futures | 51.11 | 51.12 | 51.04 | 51.08 | 2446.0 |
| 2016-05-22 18:00:00 | GC | Futures | 1707.1 | 1709.2 | 1703.1 | 1708.1 | 2273.0 |
| 2016-05-22 19:00:00 | GC | Futures | 1708.1 | 1709.1 | 1707.0 | 1708.6 | 734.0 |
| 2016-05-22 20:00:00 | GC | Futures | 1708.5 | 1711.2 | 1707.1 | 1711.0 | 3022.0 |
| 2016-05-22 21:00:00 | GC | Futures | 1710.8 | 1714.1 | 1710.3 | 1712.7 | 4018.0 |
| 2016-05-22 22:00:00 | GC | Futures | 1712.9 | 1713.0 | 1710.7 | 1711.8 | 3864.0 |
| 2016-05-22 23:00:00 | GC | Futures | 1711.5 | 1713.3 | 1711.4 | 1711.8 | 1232.0 |
| 2016-05-22 18:00:00 | ZN | Futures | 126.316856 | 126.392933 | 126.301641 | 126.392933 | 3464.0 |
| 2016-05-22 19:00:00 | ZN | Futures | 126.392933 | 126.408148 | 126.347287 | 126.392933 | 2860.0 |
| 2016-05-22 20:00:00 | ZN | Futures | 126.392933 | 126.453793 | 126.377717 | 126.408148 | 9969.0 |
| 2016-05-22 21:00:00 | ZN | Futures | 126.423363 | 126.453793 | 126.392933 | 126.408148 | 7903.0 |
| 2016-05-22 22:00:00 | ZN | Futures | 126.408148 | 126.408148 | 126.377717 | 126.408148 | 3453.0 |
| 2016-05-22 23:00:00 | ZN | Futures | 126.408148 | 126.423363 | 126.377717 | 126.392933 | 3841.0 |
> showing 36 of 278 rows — these rows as CSV