PREVIEW / futures_1hour / 2014-06-15
file: by_date/futures_1hour/2014/2014-06-15.parquet size: 14 KB rows: 256
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-06-15 18:00:00 | ES | Futures | 2009.86 | 2010.12 | 2007.51 | 2007.77 | 4334.0 |
| 2014-06-15 19:00:00 | ES | Futures | 2007.51 | 2007.77 | 2003.08 | 2004.64 | 9482.0 |
| 2014-06-15 20:00:00 | ES | Futures | 2004.64 | 2004.64 | 2000.47 | 2003.6 | 11505.0 |
| 2014-06-15 21:00:00 | ES | Futures | 2003.6 | 2003.86 | 2001.25 | 2003.86 | 6719.0 |
| 2014-06-15 22:00:00 | ES | Futures | 2003.86 | 2004.38 | 2003.08 | 2004.12 | 2989.0 |
| 2014-06-15 23:00:00 | ES | Futures | 2004.12 | 2004.64 | 2002.56 | 2002.82 | 2428.0 |
| 2014-06-15 18:00:00 | NQ | Futures | 4400.08 | 4404.75 | 4398.03 | 4398.03 | 1028.0 |
| 2014-06-15 19:00:00 | NQ | Futures | 4398.03 | 4398.03 | 4387.52 | 4391.02 | 791.0 |
| 2014-06-15 20:00:00 | NQ | Futures | 4391.02 | 4391.32 | 4380.51 | 4388.4 | 1478.0 |
| 2014-06-15 21:00:00 | NQ | Futures | 4388.1 | 4389.27 | 4383.14 | 4389.27 | 980.0 |
| 2014-06-15 22:00:00 | NQ | Futures | 4389.27 | 4391.32 | 4388.4 | 4389.86 | 471.0 |
| 2014-06-15 23:00:00 | NQ | Futures | 4390.44 | 4391.61 | 4386.94 | 4387.52 | 373.0 |
| 2014-06-15 18:00:00 | YM | Futures | 17275.2 | 17275.2 | 17252.5 | 17252.5 | 741.0 |
| 2014-06-15 19:00:00 | YM | Futures | 17254.5 | 17254.5 | 17219.4 | 17231.8 | 748.0 |
| 2014-06-15 20:00:00 | YM | Futures | 17231.8 | 17231.8 | 17197.6 | 17224.5 | 2430.0 |
| 2014-06-15 21:00:00 | YM | Futures | 17224.5 | 17227.6 | 17208.0 | 17225.6 | 1344.0 |
| 2014-06-15 22:00:00 | YM | Futures | 17225.6 | 17232.8 | 17222.5 | 17230.7 | 528.0 |
| 2014-06-15 23:00:00 | YM | Futures | 17230.7 | 17234.9 | 17220.4 | 17221.4 | 356.0 |
| 2014-06-15 18:00:00 | CL | Futures | 172.71 | 173.65 | 172.64 | 173.37 | 758.0 |
| 2014-06-15 19:00:00 | CL | Futures | 173.37 | 173.64 | 173.2 | 173.42 | 361.0 |
| 2014-06-15 20:00:00 | CL | Futures | 173.41 | 173.7 | 173.29 | 173.47 | 811.0 |
| 2014-06-15 21:00:00 | CL | Futures | 173.47 | 173.54 | 173.08 | 173.16 | 642.0 |
| 2014-06-15 22:00:00 | CL | Futures | 173.15 | 173.33 | 172.79 | 173.33 | 819.0 |
| 2014-06-15 23:00:00 | CL | Futures | 173.31 | 173.49 | 173.28 | 173.36 | 226.0 |
| 2014-06-15 18:00:00 | GC | Futures | 1748.8 | 1750.9 | 1748.4 | 1749.8 | 1352.0 |
| 2014-06-15 19:00:00 | GC | Futures | 1749.8 | 1752.2 | 1749.8 | 1751.3 | 1339.0 |
| 2014-06-15 20:00:00 | GC | Futures | 1751.4 | 1752.9 | 1751.1 | 1752.2 | 1341.0 |
| 2014-06-15 21:00:00 | GC | Futures | 1752.1 | 1757.4 | 1752.0 | 1755.5 | 6424.0 |
| 2014-06-15 22:00:00 | GC | Futures | 1755.5 | 1756.6 | 1754.4 | 1755.5 | 1497.0 |
| 2014-06-15 23:00:00 | GC | Futures | 1755.7 | 1756.1 | 1754.4 | 1755.5 | 1216.0 |
| 2014-06-15 18:00:00 | ZN | Futures | 117.230298 | 117.245033 | 117.127154 | 117.186094 | 3960.0 |
| 2014-06-15 19:00:00 | ZN | Futures | 117.186094 | 117.215563 | 117.171359 | 117.215563 | 3782.0 |
| 2014-06-15 20:00:00 | ZN | Futures | 117.215563 | 117.303972 | 117.215563 | 117.289237 | 9596.0 |
| 2014-06-15 21:00:00 | ZN | Futures | 117.289237 | 117.348177 | 117.289237 | 117.318707 | 8830.0 |
| 2014-06-15 22:00:00 | ZN | Futures | 117.318707 | 117.333442 | 117.289237 | 117.289237 | 5343.0 |
| 2014-06-15 23:00:00 | ZN | Futures | 117.303972 | 117.333442 | 117.289237 | 117.333442 | 4121.0 |
> showing 36 of 256 rows — these rows as CSV