PREVIEW / futures_1hour / 2016-08-28
file: by_date/futures_1hour/2016/2016-08-28.parquet size: 15 KB rows: 291
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-08-28 18:00:00 | ES | Futures | 2351.46 | 2351.46 | 2347.93 | 2348.75 | 8703.0 |
| 2016-08-28 19:00:00 | ES | Futures | 2349.02 | 2351.73 | 2348.75 | 2351.46 | 3961.0 |
| 2016-08-28 20:00:00 | ES | Futures | 2351.46 | 2352.54 | 2350.64 | 2351.46 | 4829.0 |
| 2016-08-28 21:00:00 | ES | Futures | 2351.19 | 2352.0 | 2349.83 | 2351.19 | 5079.0 |
| 2016-08-28 22:00:00 | ES | Futures | 2351.19 | 2351.46 | 2349.56 | 2350.92 | 2951.0 |
| 2016-08-28 23:00:00 | ES | Futures | 2350.92 | 2351.46 | 2350.1 | 2350.37 | 1790.0 |
| 2016-08-28 18:00:00 | NQ | Futures | 5705.9 | 5708.88 | 5697.26 | 5698.15 | 1494.0 |
| 2016-08-28 19:00:00 | NQ | Futures | 5698.15 | 5700.53 | 5691.59 | 5699.94 | 2130.0 |
| 2016-08-28 20:00:00 | NQ | Futures | 5700.24 | 5702.32 | 5697.26 | 5699.34 | 1126.0 |
| 2016-08-28 21:00:00 | NQ | Futures | 5699.04 | 5699.94 | 5693.98 | 5699.64 | 1366.0 |
| 2016-08-28 22:00:00 | NQ | Futures | 5699.34 | 5700.83 | 5696.36 | 5700.53 | 684.0 |
| 2016-08-28 23:00:00 | NQ | Futures | 5700.53 | 5701.43 | 5698.15 | 5698.75 | 414.0 |
| 2016-08-28 18:00:00 | YM | Futures | 19780.6 | 19785.0 | 19757.0 | 19764.5 | 1653.0 |
| 2016-08-28 19:00:00 | YM | Futures | 19764.5 | 19780.6 | 19759.1 | 19777.4 | 522.0 |
| 2016-08-28 20:00:00 | YM | Futures | 19778.5 | 19786.0 | 19772.0 | 19777.4 | 697.0 |
| 2016-08-28 21:00:00 | YM | Futures | 19776.3 | 19782.8 | 19760.2 | 19773.1 | 1040.0 |
| 2016-08-28 22:00:00 | YM | Futures | 19773.1 | 19777.4 | 19763.4 | 19776.3 | 506.0 |
| 2016-08-28 23:00:00 | YM | Futures | 19776.3 | 19779.6 | 19772.0 | 19774.2 | 378.0 |
| 2016-08-28 18:00:00 | CL | Futures | 47.97 | 47.99 | 47.79 | 47.83 | 2570.0 |
| 2016-08-28 19:00:00 | CL | Futures | 47.84 | 47.93 | 47.79 | 47.86 | 3104.0 |
| 2016-08-28 20:00:00 | CL | Futures | 47.86 | 48.03 | 47.85 | 47.96 | 3129.0 |
| 2016-08-28 21:00:00 | CL | Futures | 47.96 | 47.97 | 47.76 | 47.78 | 3247.0 |
| 2016-08-28 22:00:00 | CL | Futures | 47.77 | 47.85 | 47.76 | 47.8 | 2159.0 |
| 2016-08-28 23:00:00 | CL | Futures | 47.79 | 47.85 | 47.78 | 47.82 | 1035.0 |
| 2016-08-28 18:00:00 | GC | Futures | 1791.0 | 1791.2 | 1787.9 | 1789.7 | 2220.0 |
| 2016-08-28 19:00:00 | GC | Futures | 1789.8 | 1792.0 | 1789.3 | 1790.9 | 2013.0 |
| 2016-08-28 20:00:00 | GC | Futures | 1790.9 | 1791.6 | 1787.9 | 1789.1 | 4300.0 |
| 2016-08-28 21:00:00 | GC | Futures | 1789.1 | 1789.4 | 1782.1 | 1785.6 | 10533.0 |
| 2016-08-28 22:00:00 | GC | Futures | 1785.6 | 1786.4 | 1783.6 | 1785.8 | 3174.0 |
| 2016-08-28 23:00:00 | GC | Futures | 1785.8 | 1787.8 | 1785.0 | 1786.8 | 3279.0 |
| 2016-08-28 18:00:00 | ZN | Futures | 127.929671 | 127.929671 | 127.853595 | 127.899241 | 9170.0 |
| 2016-08-28 19:00:00 | ZN | Futures | 127.899241 | 128.020962 | 127.899241 | 128.005747 | 9139.0 |
| 2016-08-28 20:00:00 | ZN | Futures | 128.005747 | 128.036178 | 127.990532 | 128.020962 | 9954.0 |
| 2016-08-28 21:00:00 | ZN | Futures | 128.020962 | 128.081823 | 128.020962 | 128.051393 | 9100.0 |
| 2016-08-28 22:00:00 | ZN | Futures | 128.036178 | 128.066608 | 128.036178 | 128.051393 | 2949.0 |
| 2016-08-28 23:00:00 | ZN | Futures | 128.036178 | 128.051393 | 127.975317 | 128.020962 | 5999.0 |
> showing 36 of 291 rows — these rows as CSV