PREVIEW / futures_1hour / 2017-03-05
file: by_date/futures_1hour/2017/2017-03-05.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 |
|---|---|---|---|---|---|---|---|
| 2017-03-05 18:00:00 | ES | Futures | 2597.03 | 2597.58 | 2586.67 | 2587.21 | 26711.0 |
| 2017-03-05 19:00:00 | ES | Futures | 2586.94 | 2589.4 | 2586.4 | 2588.58 | 9994.0 |
| 2017-03-05 20:00:00 | ES | Futures | 2588.58 | 2590.21 | 2588.3 | 2588.85 | 4668.0 |
| 2017-03-05 21:00:00 | ES | Futures | 2588.85 | 2589.67 | 2588.03 | 2589.12 | 4128.0 |
| 2017-03-05 22:00:00 | ES | Futures | 2588.85 | 2589.94 | 2588.58 | 2589.4 | 3165.0 |
| 2017-03-05 23:00:00 | ES | Futures | 2589.4 | 2589.67 | 2588.85 | 2589.4 | 2226.0 |
| 2017-03-05 18:00:00 | NQ | Futures | 6406.72 | 6413.28 | 6381.66 | 6382.55 | 3863.0 |
| 2017-03-05 19:00:00 | NQ | Futures | 6382.55 | 6391.5 | 6380.76 | 6390.01 | 2355.0 |
| 2017-03-05 20:00:00 | NQ | Futures | 6390.31 | 6395.38 | 6390.01 | 6392.1 | 1496.0 |
| 2017-03-05 21:00:00 | NQ | Futures | 6391.5 | 6393.29 | 6388.52 | 6390.61 | 882.0 |
| 2017-03-05 22:00:00 | NQ | Futures | 6391.2 | 6393.29 | 6389.71 | 6390.91 | 779.0 |
| 2017-03-05 23:00:00 | NQ | Futures | 6390.61 | 6392.99 | 6389.71 | 6392.7 | 474.0 |
| 2017-03-05 18:00:00 | YM | Futures | 22753.0 | 22758.4 | 22671.6 | 22673.8 | 4149.0 |
| 2017-03-05 19:00:00 | YM | Futures | 22673.8 | 22698.7 | 22665.1 | 22685.7 | 2086.0 |
| 2017-03-05 20:00:00 | YM | Futures | 22686.8 | 22705.2 | 22685.7 | 22694.4 | 1513.0 |
| 2017-03-05 21:00:00 | YM | Futures | 22693.3 | 22700.9 | 22683.5 | 22697.6 | 1245.0 |
| 2017-03-05 22:00:00 | YM | Futures | 22697.6 | 22704.2 | 22694.4 | 22700.9 | 641.0 |
| 2017-03-05 23:00:00 | YM | Futures | 22700.9 | 22704.2 | 22698.7 | 22703.1 | 356.0 |
| 2017-03-05 18:00:00 | CL | Futures | 49.98 | 50.16 | 49.97 | 50.06 | 3902.0 |
| 2017-03-05 19:00:00 | CL | Futures | 50.06 | 50.06 | 49.94 | 49.96 | 2938.0 |
| 2017-03-05 20:00:00 | CL | Futures | 49.96 | 49.97 | 49.89 | 49.94 | 2320.0 |
| 2017-03-05 21:00:00 | CL | Futures | 49.94 | 49.97 | 49.9 | 49.93 | 1493.0 |
| 2017-03-05 22:00:00 | CL | Futures | 49.92 | 49.95 | 49.89 | 49.9 | 971.0 |
| 2017-03-05 23:00:00 | CL | Futures | 49.9 | 49.91 | 49.86 | 49.88 | 1865.0 |
| 2017-03-05 18:00:00 | GC | Futures | 1661.7 | 1666.3 | 1660.5 | 1666.1 | 5089.0 |
| 2017-03-05 19:00:00 | GC | Futures | 1666.0 | 1666.1 | 1663.2 | 1664.1 | 4011.0 |
| 2017-03-05 20:00:00 | GC | Futures | 1664.1 | 1664.1 | 1660.6 | 1661.4 | 7099.0 |
| 2017-03-05 21:00:00 | GC | Futures | 1661.4 | 1663.1 | 1661.4 | 1662.1 | 3519.0 |
| 2017-03-05 22:00:00 | GC | Futures | 1662.2 | 1662.8 | 1661.4 | 1661.8 | 2351.0 |
| 2017-03-05 23:00:00 | GC | Futures | 1662.0 | 1662.5 | 1661.2 | 1661.2 | 2875.0 |
| 2017-03-05 18:00:00 | ZN | Futures | 122.524072 | 122.662866 | 122.524072 | 122.647444 | 5.0 |
| 2017-03-05 19:00:00 | ZN | Futures | 122.678288 | 122.724552 | 122.662866 | 122.724552 | 89.0 |
| 2017-03-05 20:00:00 | ZN | Futures | 122.739974 | 122.739974 | 122.693709 | 122.693709 | 82.0 |
| 2017-03-05 21:00:00 | ZN | Futures | 122.693709 | 122.724552 | 122.678288 | 122.678288 | 74.0 |
| 2017-03-05 22:00:00 | ZN | Futures | 122.709131 | 122.709131 | 122.693709 | 122.693709 | 2.0 |
> showing 35 of 275 rows — these rows as CSV