PREVIEW / futures_1hour / 2014-12-28
file: by_date/futures_1hour/2014/2014-12-28.parquet size: 14 KB rows: 264
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-12-28 18:00:00 | ES | Futures | 2195.74 | 2196.0 | 2193.11 | 2194.42 | 3698.0 |
| 2014-12-28 19:00:00 | ES | Futures | 2194.69 | 2195.48 | 2194.69 | 2194.69 | 1096.0 |
| 2014-12-28 20:00:00 | ES | Futures | 2194.95 | 2197.05 | 2194.95 | 2196.53 | 2369.0 |
| 2014-12-28 21:00:00 | ES | Futures | 2196.53 | 2196.79 | 2194.95 | 2195.48 | 2007.0 |
| 2014-12-28 22:00:00 | ES | Futures | 2195.74 | 2197.05 | 2195.21 | 2196.53 | 2123.0 |
| 2014-12-28 23:00:00 | ES | Futures | 2196.53 | 2196.79 | 2194.16 | 2195.48 | 2889.0 |
| 2014-12-28 18:00:00 | NQ | Futures | 5069.06 | 5070.24 | 5065.54 | 5068.47 | 435.0 |
| 2014-12-28 19:00:00 | NQ | Futures | 5068.77 | 5069.94 | 5068.18 | 5069.36 | 205.0 |
| 2014-12-28 20:00:00 | NQ | Futures | 5069.65 | 5074.64 | 5069.65 | 5074.35 | 410.0 |
| 2014-12-28 21:00:00 | NQ | Futures | 5074.35 | 5075.23 | 5070.53 | 5071.12 | 413.0 |
| 2014-12-28 22:00:00 | NQ | Futures | 5071.7 | 5075.82 | 5070.82 | 5074.35 | 340.0 |
| 2014-12-28 23:00:00 | NQ | Futures | 5074.05 | 5074.35 | 5070.24 | 5073.47 | 605.0 |
| 2014-12-28 18:00:00 | YM | Futures | 18814.8 | 18819.0 | 18798.1 | 18806.5 | 401.0 |
| 2014-12-28 19:00:00 | YM | Futures | 18806.5 | 18812.8 | 18806.5 | 18809.6 | 134.0 |
| 2014-12-28 20:00:00 | YM | Futures | 18810.7 | 18827.4 | 18810.7 | 18824.2 | 396.0 |
| 2014-12-28 21:00:00 | YM | Futures | 18827.4 | 18827.4 | 18807.5 | 18813.8 | 388.0 |
| 2014-12-28 22:00:00 | YM | Futures | 18815.9 | 18827.4 | 18812.8 | 18824.2 | 251.0 |
| 2014-12-28 23:00:00 | YM | Futures | 18823.2 | 18823.2 | 18803.4 | 18811.7 | 382.0 |
| 2014-12-28 18:00:00 | CL | Futures | 93.69 | 94.24 | 93.5 | 93.95 | 2476.0 |
| 2014-12-28 19:00:00 | CL | Futures | 93.95 | 94.87 | 93.95 | 94.18 | 3206.0 |
| 2014-12-28 20:00:00 | CL | Futures | 94.18 | 94.44 | 93.96 | 94.39 | 1620.0 |
| 2014-12-28 21:00:00 | CL | Futures | 94.41 | 94.42 | 94.0 | 94.08 | 1275.0 |
| 2014-12-28 22:00:00 | CL | Futures | 94.08 | 94.27 | 93.66 | 94.05 | 2791.0 |
| 2014-12-28 23:00:00 | CL | Futures | 94.01 | 94.15 | 93.86 | 94.12 | 1233.0 |
| 2014-12-28 18:00:00 | GC | Futures | 1634.7 | 1636.7 | 1633.2 | 1633.3 | 1088.0 |
| 2014-12-28 19:00:00 | GC | Futures | 1633.3 | 1634.0 | 1631.2 | 1632.1 | 1201.0 |
| 2014-12-28 20:00:00 | GC | Futures | 1632.2 | 1637.3 | 1631.2 | 1635.9 | 3583.0 |
| 2014-12-28 21:00:00 | GC | Futures | 1635.8 | 1638.2 | 1634.9 | 1636.6 | 1439.0 |
| 2014-12-28 22:00:00 | GC | Futures | 1636.7 | 1637.1 | 1633.8 | 1634.1 | 1265.0 |
| 2014-12-28 23:00:00 | GC | Futures | 1634.1 | 1635.8 | 1633.8 | 1635.1 | 611.0 |
| 2014-12-28 18:00:00 | ZN | Futures | 119.814684 | 119.859258 | 119.784968 | 119.859258 | 4805.0 |
| 2014-12-28 19:00:00 | ZN | Futures | 119.8444 | 119.874116 | 119.8444 | 119.8444 | 1972.0 |
| 2014-12-28 20:00:00 | ZN | Futures | 119.8444 | 119.874116 | 119.829542 | 119.8444 | 1642.0 |
| 2014-12-28 21:00:00 | ZN | Futures | 119.829542 | 119.8444 | 119.829542 | 119.8444 | 1898.0 |
| 2014-12-28 22:00:00 | ZN | Futures | 119.8444 | 119.859258 | 119.784968 | 119.814684 | 3254.0 |
| 2014-12-28 23:00:00 | ZN | Futures | 119.814684 | 119.859258 | 119.814684 | 119.8444 | 1653.0 |
> showing 36 of 264 rows — these rows as CSV