PREVIEW / futures_1hour / 2014-08-10
file: by_date/futures_1hour/2014/2014-08-10.parquet size: 14 KB rows: 272
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-10 18:00:00 | ES | Futures | 2005.16 | 2011.42 | 2004.9 | 2008.55 | 13347.0 |
| 2014-08-10 19:00:00 | ES | Futures | 2008.55 | 2009.59 | 2008.03 | 2009.33 | 3031.0 |
| 2014-08-10 20:00:00 | ES | Futures | 2009.33 | 2009.33 | 2007.77 | 2008.81 | 5621.0 |
| 2014-08-10 21:00:00 | ES | Futures | 2008.81 | 2009.33 | 2005.95 | 2008.55 | 8570.0 |
| 2014-08-10 22:00:00 | ES | Futures | 2008.81 | 2009.86 | 2008.29 | 2009.86 | 4565.0 |
| 2014-08-10 23:00:00 | ES | Futures | 2009.59 | 2009.86 | 2008.29 | 2008.55 | 1317.0 |
| 2014-08-10 18:00:00 | NQ | Futures | 4525.06 | 4538.2 | 4524.77 | 4533.24 | 1175.0 |
| 2014-08-10 19:00:00 | NQ | Futures | 4532.94 | 4535.86 | 4532.94 | 4534.99 | 481.0 |
| 2014-08-10 20:00:00 | NQ | Futures | 4534.7 | 4534.7 | 4531.78 | 4533.53 | 507.0 |
| 2014-08-10 21:00:00 | NQ | Futures | 4533.24 | 4534.7 | 4527.69 | 4534.4 | 1380.0 |
| 2014-08-10 22:00:00 | NQ | Futures | 4534.7 | 4536.74 | 4533.24 | 4536.74 | 565.0 |
| 2014-08-10 23:00:00 | NQ | Futures | 4536.74 | 4536.74 | 4533.53 | 4534.11 | 161.0 |
| 2014-08-10 18:00:00 | YM | Futures | 17047.6 | 17099.4 | 17042.5 | 17077.6 | 1473.0 |
| 2014-08-10 19:00:00 | YM | Futures | 17078.7 | 17088.0 | 17074.5 | 17084.9 | 302.0 |
| 2014-08-10 20:00:00 | YM | Futures | 17084.9 | 17084.9 | 17072.5 | 17078.7 | 611.0 |
| 2014-08-10 21:00:00 | YM | Futures | 17079.7 | 17081.8 | 17058.0 | 17078.7 | 1257.0 |
| 2014-08-10 22:00:00 | YM | Futures | 17079.7 | 17088.0 | 17076.6 | 17088.0 | 708.0 |
| 2014-08-10 23:00:00 | YM | Futures | 17086.9 | 17086.9 | 17075.6 | 17077.6 | 266.0 |
| 2014-08-10 18:00:00 | CL | Futures | 159.41 | 159.76 | 159.14 | 159.69 | 1477.0 |
| 2014-08-10 19:00:00 | CL | Futures | 159.68 | 159.74 | 159.58 | 159.59 | 444.0 |
| 2014-08-10 20:00:00 | CL | Futures | 159.59 | 159.81 | 159.59 | 159.79 | 401.0 |
| 2014-08-10 21:00:00 | CL | Futures | 159.79 | 160.2 | 159.72 | 160.2 | 1404.0 |
| 2014-08-10 22:00:00 | CL | Futures | 160.22 | 160.28 | 160.07 | 160.17 | 1065.0 |
| 2014-08-10 23:00:00 | CL | Futures | 160.18 | 160.23 | 159.86 | 160.0 | 864.0 |
| 2014-08-10 00:00:00 | GC | Futures | 1790.7 | 1790.7 | 1790.7 | 1790.7 | 1.0 |
| 2014-08-10 18:00:00 | GC | Futures | 1793.9 | 1797.3 | 1793.2 | 1796.6 | 766.0 |
| 2014-08-10 19:00:00 | GC | Futures | 1796.5 | 1797.2 | 1794.4 | 1794.7 | 905.0 |
| 2014-08-10 20:00:00 | GC | Futures | 1794.6 | 1794.7 | 1792.1 | 1793.3 | 1860.0 |
| 2014-08-10 21:00:00 | GC | Futures | 1793.5 | 1794.0 | 1790.4 | 1792.0 | 2365.0 |
| 2014-08-10 22:00:00 | GC | Futures | 1792.0 | 1792.1 | 1788.4 | 1789.8 | 2199.0 |
| 2014-08-10 23:00:00 | GC | Futures | 1789.8 | 1791.1 | 1789.6 | 1790.9 | 706.0 |
| 2014-08-10 18:00:00 | ZN | Futures | 118.659576 | 118.718516 | 118.630107 | 118.674311 | 7369.0 |
| 2014-08-10 19:00:00 | ZN | Futures | 118.674311 | 118.689046 | 118.644842 | 118.659576 | 4191.0 |
| 2014-08-10 20:00:00 | ZN | Futures | 118.644842 | 118.718516 | 118.644842 | 118.689046 | 5360.0 |
| 2014-08-10 21:00:00 | ZN | Futures | 118.689046 | 118.703781 | 118.615372 | 118.630107 | 11940.0 |
| 2014-08-10 22:00:00 | ZN | Futures | 118.630107 | 118.630107 | 118.585902 | 118.615372 | 4926.0 |
| 2014-08-10 23:00:00 | ZN | Futures | 118.615372 | 118.630107 | 118.600637 | 118.615372 | 2900.0 |
> showing 37 of 272 rows — these rows as CSV