PREVIEW / futures_1hour / 2013-12-08
file: by_date/futures_1hour/2013/2013-12-08.parquet size: 14 KB rows: 257
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-08 18:00:00 | ES | Futures | 1864.02 | 1866.86 | 1864.02 | 1865.05 | 10816.0 |
| 2013-12-08 19:00:00 | ES | Futures | 1864.8 | 1865.05 | 1864.02 | 1864.28 | 3454.0 |
| 2013-12-08 20:00:00 | ES | Futures | 1864.28 | 1865.05 | 1863.76 | 1864.8 | 2755.0 |
| 2013-12-08 21:00:00 | ES | Futures | 1865.05 | 1865.31 | 1864.28 | 1864.54 | 2448.0 |
| 2013-12-08 22:00:00 | ES | Futures | 1864.28 | 1864.8 | 1864.02 | 1864.54 | 1850.0 |
| 2013-12-08 23:00:00 | ES | Futures | 1864.8 | 1865.57 | 1864.54 | 1865.31 | 2396.0 |
| 2013-12-08 18:00:00 | NQ | Futures | 4071.86 | 4082.03 | 4071.86 | 4080.58 | 1362.0 |
| 2013-12-08 19:00:00 | NQ | Futures | 4080.29 | 4080.58 | 4078.25 | 4078.83 | 502.0 |
| 2013-12-08 20:00:00 | NQ | Futures | 4078.83 | 4079.42 | 4077.67 | 4079.42 | 370.0 |
| 2013-12-08 21:00:00 | NQ | Futures | 4079.42 | 4079.71 | 4077.67 | 4078.54 | 244.0 |
| 2013-12-08 22:00:00 | NQ | Futures | 4078.54 | 4078.54 | 4077.38 | 4078.54 | 179.0 |
| 2013-12-08 23:00:00 | NQ | Futures | 4078.25 | 4079.71 | 4077.96 | 4079.71 | 216.0 |
| 2013-12-08 18:00:00 | YM | Futures | 16359.4 | 16389.0 | 16359.4 | 16375.7 | 1214.0 |
| 2013-12-08 19:00:00 | YM | Futures | 16376.7 | 16377.7 | 16369.6 | 16372.6 | 480.0 |
| 2013-12-08 20:00:00 | YM | Futures | 16372.6 | 16377.7 | 16369.6 | 16376.7 | 527.0 |
| 2013-12-08 21:00:00 | YM | Futures | 16377.7 | 16380.8 | 16373.7 | 16375.7 | 291.0 |
| 2013-12-08 22:00:00 | YM | Futures | 16375.7 | 16377.7 | 16372.6 | 16375.7 | 172.0 |
| 2013-12-08 23:00:00 | YM | Futures | 16375.7 | 16381.8 | 16375.7 | 16379.8 | 158.0 |
| 2013-12-08 18:00:00 | CL | Futures | 154.33 | 154.53 | 154.26 | 154.41 | 693.0 |
| 2013-12-08 19:00:00 | CL | Futures | 154.41 | 154.52 | 154.33 | 154.49 | 326.0 |
| 2013-12-08 20:00:00 | CL | Futures | 154.49 | 154.66 | 154.44 | 154.63 | 553.0 |
| 2013-12-08 21:00:00 | CL | Futures | 154.64 | 154.71 | 154.53 | 154.61 | 511.0 |
| 2013-12-08 22:00:00 | CL | Futures | 154.6 | 154.64 | 154.52 | 154.56 | 269.0 |
| 2013-12-08 23:00:00 | CL | Futures | 154.58 | 154.63 | 154.56 | 154.56 | 253.0 |
| 2013-12-08 18:00:00 | GC | Futures | 1685.9 | 1688.5 | 1682.8 | 1682.8 | 936.0 |
| 2013-12-08 19:00:00 | GC | Futures | 1682.8 | 1683.4 | 1679.3 | 1681.8 | 1560.0 |
| 2013-12-08 20:00:00 | GC | Futures | 1681.8 | 1686.9 | 1678.6 | 1686.0 | 4222.0 |
| 2013-12-08 21:00:00 | GC | Futures | 1686.0 | 1686.6 | 1684.3 | 1684.9 | 1025.0 |
| 2013-12-08 22:00:00 | GC | Futures | 1684.8 | 1686.5 | 1684.7 | 1685.5 | 691.0 |
| 2013-12-08 23:00:00 | GC | Futures | 1685.5 | 1685.8 | 1684.4 | 1684.4 | 668.0 |
| 2013-12-08 18:00:00 | ZN | Futures | 114.929124 | 114.943572 | 114.84244 | 114.914677 | 13445.0 |
| 2013-12-08 19:00:00 | ZN | Futures | 114.929124 | 114.972467 | 114.914677 | 114.972467 | 5748.0 |
| 2013-12-08 20:00:00 | ZN | Futures | 114.972467 | 115.001362 | 114.958019 | 114.972467 | 4918.0 |
| 2013-12-08 21:00:00 | ZN | Futures | 114.958019 | 115.030256 | 114.958019 | 115.015809 | 3908.0 |
| 2013-12-08 22:00:00 | ZN | Futures | 115.001362 | 115.073599 | 115.001362 | 115.059151 | 5429.0 |
| 2013-12-08 23:00:00 | ZN | Futures | 115.059151 | 115.088046 | 115.030256 | 115.073599 | 4177.0 |
> showing 36 of 257 rows — these rows as CSV