PREVIEW / futures_1hour / 2016-10-23
file: by_date/futures_1hour/2016/2016-10-23.parquet size: 15 KB rows: 287
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-10-23 18:00:00 | ES | Futures | 2325.73 | 2328.72 | 2324.1 | 2327.64 | 9975.0 |
| 2016-10-23 19:00:00 | ES | Futures | 2327.64 | 2328.18 | 2326.0 | 2326.28 | 2922.0 |
| 2016-10-23 20:00:00 | ES | Futures | 2326.28 | 2326.28 | 2324.92 | 2326.28 | 4802.0 |
| 2016-10-23 21:00:00 | ES | Futures | 2326.0 | 2327.36 | 2323.28 | 2323.83 | 10029.0 |
| 2016-10-23 22:00:00 | ES | Futures | 2323.83 | 2326.28 | 2323.28 | 2325.73 | 4276.0 |
| 2016-10-23 23:00:00 | ES | Futures | 2325.73 | 2326.82 | 2325.46 | 2326.28 | 3100.0 |
| 2016-10-23 18:00:00 | NQ | Futures | 5784.42 | 5790.98 | 5781.13 | 5789.49 | 1639.0 |
| 2016-10-23 19:00:00 | NQ | Futures | 5789.49 | 5789.79 | 5785.31 | 5785.91 | 551.0 |
| 2016-10-23 20:00:00 | NQ | Futures | 5785.61 | 5787.1 | 5782.92 | 5786.21 | 759.0 |
| 2016-10-23 21:00:00 | NQ | Futures | 5785.91 | 5789.19 | 5779.05 | 5780.54 | 1562.0 |
| 2016-10-23 22:00:00 | NQ | Futures | 5780.54 | 5787.7 | 5779.94 | 5786.5 | 701.0 |
| 2016-10-23 23:00:00 | NQ | Futures | 5786.5 | 5788.59 | 5785.01 | 5787.1 | 578.0 |
| 2016-10-23 18:00:00 | YM | Futures | 19540.2 | 19568.3 | 19532.6 | 19558.6 | 1345.0 |
| 2016-10-23 19:00:00 | YM | Futures | 19557.5 | 19560.7 | 19542.4 | 19547.8 | 739.0 |
| 2016-10-23 20:00:00 | YM | Futures | 19547.8 | 19547.8 | 19532.6 | 19542.4 | 951.0 |
| 2016-10-23 21:00:00 | YM | Futures | 19543.4 | 19555.3 | 19519.7 | 19525.1 | 2630.0 |
| 2016-10-23 22:00:00 | YM | Futures | 19526.1 | 19548.8 | 19524.0 | 19544.5 | 1016.0 |
| 2016-10-23 23:00:00 | YM | Futures | 19542.4 | 19554.2 | 19540.2 | 19548.8 | 730.0 |
| 2016-10-23 18:00:00 | CL | Futures | 50.7 | 50.81 | 50.36 | 50.51 | 5327.0 |
| 2016-10-23 19:00:00 | CL | Futures | 50.51 | 50.53 | 50.39 | 50.45 | 1719.0 |
| 2016-10-23 20:00:00 | CL | Futures | 50.44 | 50.54 | 50.42 | 50.5 | 1756.0 |
| 2016-10-23 21:00:00 | CL | Futures | 50.5 | 50.55 | 50.42 | 50.44 | 2993.0 |
| 2016-10-23 22:00:00 | CL | Futures | 50.43 | 50.45 | 50.26 | 50.37 | 5129.0 |
| 2016-10-23 23:00:00 | CL | Futures | 50.37 | 50.51 | 50.36 | 50.43 | 3170.0 |
| 2016-10-23 18:00:00 | GC | Futures | 1714.1 | 1714.6 | 1713.0 | 1713.8 | 1009.0 |
| 2016-10-23 19:00:00 | GC | Futures | 1713.8 | 1714.6 | 1713.5 | 1714.1 | 496.0 |
| 2016-10-23 20:00:00 | GC | Futures | 1714.1 | 1715.1 | 1713.7 | 1714.7 | 1127.0 |
| 2016-10-23 21:00:00 | GC | Futures | 1714.7 | 1714.7 | 1710.0 | 1711.1 | 4632.0 |
| 2016-10-23 22:00:00 | GC | Futures | 1711.1 | 1711.2 | 1709.3 | 1709.5 | 3053.0 |
| 2016-10-23 23:00:00 | GC | Futures | 1709.6 | 1710.5 | 1709.1 | 1710.4 | 1366.0 |
| 2016-10-23 18:00:00 | ZN | Futures | 127.861411 | 127.861411 | 127.800109 | 127.815434 | 4785.0 |
| 2016-10-23 19:00:00 | ZN | Futures | 127.815434 | 127.861411 | 127.815434 | 127.846085 | 4545.0 |
| 2016-10-23 20:00:00 | ZN | Futures | 127.846085 | 127.876737 | 127.815434 | 127.861411 | 7390.0 |
| 2016-10-23 21:00:00 | ZN | Futures | 127.861411 | 127.907388 | 127.83076 | 127.892062 | 6864.0 |
| 2016-10-23 22:00:00 | ZN | Futures | 127.907388 | 127.907388 | 127.876737 | 127.892062 | 3863.0 |
| 2016-10-23 23:00:00 | ZN | Futures | 127.892062 | 127.892062 | 127.861411 | 127.876737 | 4025.0 |
> showing 36 of 287 rows — these rows as CSV