PREVIEW / futures_1hour / 2014-08-03
file: by_date/futures_1hour/2014/2014-08-03.parquet size: 14 KB rows: 277
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-03 18:00:00 | ES | Futures | 2000.99 | 2004.38 | 2000.73 | 2003.86 | 9414.0 |
| 2014-08-03 19:00:00 | ES | Futures | 2003.86 | 2003.86 | 2000.99 | 2002.56 | 4971.0 |
| 2014-08-03 20:00:00 | ES | Futures | 2002.3 | 2004.9 | 2001.78 | 2004.12 | 8851.0 |
| 2014-08-03 21:00:00 | ES | Futures | 2004.38 | 2007.51 | 2004.12 | 2006.73 | 13733.0 |
| 2014-08-03 22:00:00 | ES | Futures | 2006.47 | 2007.25 | 2005.95 | 2006.47 | 4263.0 |
| 2014-08-03 23:00:00 | ES | Futures | 2006.73 | 2007.51 | 2006.21 | 2006.73 | 2610.0 |
| 2014-08-03 18:00:00 | NQ | Futures | 4523.89 | 4533.24 | 4523.89 | 4532.07 | 1023.0 |
| 2014-08-03 19:00:00 | NQ | Futures | 4531.78 | 4532.36 | 4525.64 | 4529.15 | 493.0 |
| 2014-08-03 20:00:00 | NQ | Futures | 4529.44 | 4532.36 | 4527.98 | 4532.07 | 1055.0 |
| 2014-08-03 21:00:00 | NQ | Futures | 4532.07 | 4537.03 | 4531.78 | 4535.86 | 2122.0 |
| 2014-08-03 22:00:00 | NQ | Futures | 4535.86 | 4536.16 | 4533.24 | 4534.11 | 561.0 |
| 2014-08-03 23:00:00 | NQ | Futures | 4534.11 | 4536.74 | 4532.94 | 4534.99 | 633.0 |
| 2014-08-03 18:00:00 | YM | Futures | 16995.9 | 17018.7 | 16994.9 | 17012.5 | 781.0 |
| 2014-08-03 19:00:00 | YM | Futures | 17013.5 | 17013.5 | 16998.0 | 17004.2 | 466.0 |
| 2014-08-03 20:00:00 | YM | Futures | 17006.2 | 17018.7 | 17001.1 | 17017.6 | 902.0 |
| 2014-08-03 21:00:00 | YM | Futures | 17017.6 | 17040.4 | 17015.6 | 17037.3 | 1523.0 |
| 2014-08-03 22:00:00 | YM | Futures | 17035.2 | 17040.4 | 17030.0 | 17033.1 | 520.0 |
| 2014-08-03 23:00:00 | YM | Futures | 17035.2 | 17041.4 | 17031.1 | 17034.2 | 326.0 |
| 2014-08-03 18:00:00 | CL | Futures | 159.63 | 159.82 | 159.54 | 159.71 | 849.0 |
| 2014-08-03 19:00:00 | CL | Futures | 159.71 | 159.76 | 159.63 | 159.69 | 666.0 |
| 2014-08-03 20:00:00 | CL | Futures | 159.71 | 159.97 | 159.68 | 159.95 | 1049.0 |
| 2014-08-03 21:00:00 | CL | Futures | 159.95 | 160.18 | 159.95 | 160.07 | 1092.0 |
| 2014-08-03 22:00:00 | CL | Futures | 160.08 | 160.1 | 159.9 | 159.99 | 705.0 |
| 2014-08-03 23:00:00 | CL | Futures | 159.99 | 160.1 | 159.99 | 160.08 | 241.0 |
| 2014-08-03 18:00:00 | GC | Futures | 1773.3 | 1773.5 | 1771.3 | 1771.4 | 599.0 |
| 2014-08-03 19:00:00 | GC | Futures | 1771.4 | 1773.2 | 1771.4 | 1772.9 | 352.0 |
| 2014-08-03 20:00:00 | GC | Futures | 1772.8 | 1773.1 | 1770.9 | 1771.4 | 769.0 |
| 2014-08-03 21:00:00 | GC | Futures | 1771.6 | 1773.1 | 1770.9 | 1771.1 | 1236.0 |
| 2014-08-03 22:00:00 | GC | Futures | 1771.3 | 1771.4 | 1769.4 | 1770.7 | 1246.0 |
| 2014-08-03 23:00:00 | GC | Futures | 1770.7 | 1771.7 | 1770.7 | 1771.0 | 578.0 |
| 2014-08-03 18:00:00 | ZN | Futures | 118.114388 | 118.158592 | 118.099653 | 118.143857 | 3395.0 |
| 2014-08-03 19:00:00 | ZN | Futures | 118.143857 | 118.158592 | 118.114388 | 118.143857 | 1261.0 |
| 2014-08-03 20:00:00 | ZN | Futures | 118.143857 | 118.173327 | 118.129123 | 118.129123 | 5492.0 |
| 2014-08-03 21:00:00 | ZN | Futures | 118.129123 | 118.129123 | 118.070183 | 118.070183 | 6318.0 |
| 2014-08-03 22:00:00 | ZN | Futures | 118.070183 | 118.114388 | 118.070183 | 118.114388 | 3601.0 |
| 2014-08-03 23:00:00 | ZN | Futures | 118.099653 | 118.114388 | 118.070183 | 118.084918 | 2623.0 |
> showing 36 of 277 rows — these rows as CSV