PREVIEW / futures_1hour / 2017-01-08
file: by_date/futures_1hour/2017/2017-01-08.parquet size: 15 KB rows: 296
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 |
|---|---|---|---|---|---|---|---|
| 2017-01-08 18:00:00 | ES | Futures | 2478.11 | 2480.02 | 2477.29 | 2480.02 | 5188.0 |
| 2017-01-08 19:00:00 | ES | Futures | 2480.02 | 2480.56 | 2479.47 | 2480.29 | 3473.0 |
| 2017-01-08 20:00:00 | ES | Futures | 2480.29 | 2481.11 | 2479.47 | 2480.83 | 3898.0 |
| 2017-01-08 21:00:00 | ES | Futures | 2480.83 | 2481.65 | 2480.56 | 2480.56 | 2553.0 |
| 2017-01-08 22:00:00 | ES | Futures | 2480.83 | 2481.11 | 2480.29 | 2480.83 | 932.0 |
| 2017-01-08 23:00:00 | ES | Futures | 2480.56 | 2481.65 | 2480.56 | 2481.38 | 1448.0 |
| 2017-01-08 18:00:00 | NQ | Futures | 5971.77 | 5978.93 | 5969.38 | 5978.63 | 1298.0 |
| 2017-01-08 19:00:00 | NQ | Futures | 5978.63 | 5980.42 | 5976.54 | 5978.93 | 797.0 |
| 2017-01-08 20:00:00 | NQ | Futures | 5979.22 | 5981.01 | 5976.24 | 5980.72 | 726.0 |
| 2017-01-08 21:00:00 | NQ | Futures | 5980.72 | 5982.8 | 5979.82 | 5980.72 | 481.0 |
| 2017-01-08 22:00:00 | NQ | Futures | 5981.01 | 5981.91 | 5980.42 | 5981.61 | 390.0 |
| 2017-01-08 23:00:00 | NQ | Futures | 5981.61 | 5982.51 | 5981.01 | 5982.21 | 344.0 |
| 2017-01-08 18:00:00 | YM | Futures | 21572.7 | 21594.4 | 21567.3 | 21593.4 | 1266.0 |
| 2017-01-08 19:00:00 | YM | Futures | 21593.4 | 21600.9 | 21587.9 | 21597.7 | 566.0 |
| 2017-01-08 20:00:00 | YM | Futures | 21597.7 | 21604.2 | 21590.1 | 21602.0 | 891.0 |
| 2017-01-08 21:00:00 | YM | Futures | 21602.0 | 21607.5 | 21598.8 | 21603.1 | 559.0 |
| 2017-01-08 22:00:00 | YM | Futures | 21604.2 | 21605.3 | 21597.7 | 21598.8 | 310.0 |
| 2017-01-08 23:00:00 | YM | Futures | 21598.8 | 21605.3 | 21598.8 | 21602.0 | 349.0 |
| 2017-01-08 18:00:00 | CL | Futures | 51.71 | 51.79 | 51.69 | 51.75 | 1426.0 |
| 2017-01-08 19:00:00 | CL | Futures | 51.74 | 51.79 | 51.71 | 51.78 | 1052.0 |
| 2017-01-08 20:00:00 | CL | Futures | 51.78 | 51.79 | 51.62 | 51.67 | 2673.0 |
| 2017-01-08 21:00:00 | CL | Futures | 51.67 | 51.76 | 51.67 | 51.74 | 1353.0 |
| 2017-01-08 22:00:00 | CL | Futures | 51.74 | 51.77 | 51.7 | 51.71 | 1219.0 |
| 2017-01-08 23:00:00 | CL | Futures | 51.71 | 51.72 | 51.67 | 51.71 | 1116.0 |
| 2017-01-08 18:00:00 | GC | Futures | 1583.1 | 1585.0 | 1582.2 | 1584.7 | 1558.0 |
| 2017-01-08 19:00:00 | GC | Futures | 1584.9 | 1585.8 | 1583.1 | 1585.3 | 3307.0 |
| 2017-01-08 20:00:00 | GC | Futures | 1585.1 | 1587.7 | 1584.7 | 1586.9 | 5065.0 |
| 2017-01-08 21:00:00 | GC | Futures | 1586.9 | 1588.4 | 1586.2 | 1586.6 | 3520.0 |
| 2017-01-08 22:00:00 | GC | Futures | 1586.6 | 1587.3 | 1585.3 | 1585.8 | 2351.0 |
| 2017-01-08 23:00:00 | GC | Futures | 1585.8 | 1586.2 | 1585.0 | 1585.5 | 1315.0 |
| 2017-01-08 18:00:00 | ZN | Futures | 122.770817 | 122.786238 | 122.724552 | 122.770817 | 8262.0 |
| 2017-01-08 19:00:00 | ZN | Futures | 122.770817 | 122.786238 | 122.739974 | 122.770817 | 4197.0 |
| 2017-01-08 20:00:00 | ZN | Futures | 122.770817 | 122.80166 | 122.755395 | 122.786238 | 3854.0 |
| 2017-01-08 21:00:00 | ZN | Futures | 122.786238 | 122.80166 | 122.739974 | 122.755395 | 4998.0 |
| 2017-01-08 22:00:00 | ZN | Futures | 122.755395 | 122.755395 | 122.724552 | 122.724552 | 3731.0 |
| 2017-01-08 23:00:00 | ZN | Futures | 122.739974 | 122.739974 | 122.693709 | 122.693709 | 5383.0 |
> showing 36 of 296 rows — these rows as CSV