PREVIEW / futures_1hour / 2014-11-02
file: by_date/futures_1hour/2014/2014-11-02.parquet size: 15 KB rows: 279
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-11-02 18:00:00 | ES | Futures | 2107.53 | 2108.84 | 2105.17 | 2107.53 | 8085.0 |
| 2014-11-02 19:00:00 | ES | Futures | 2107.53 | 2108.58 | 2106.22 | 2107.79 | 5167.0 |
| 2014-11-02 20:00:00 | ES | Futures | 2107.79 | 2108.05 | 2105.96 | 2105.96 | 2673.0 |
| 2014-11-02 21:00:00 | ES | Futures | 2106.22 | 2106.74 | 2105.43 | 2105.96 | 1984.0 |
| 2014-11-02 22:00:00 | ES | Futures | 2105.96 | 2107.0 | 2105.43 | 2105.69 | 1468.0 |
| 2014-11-02 23:00:00 | ES | Futures | 2105.96 | 2105.96 | 2104.38 | 2104.65 | 1749.0 |
| 2014-11-02 18:00:00 | NQ | Futures | 4864.19 | 4868.29 | 4858.62 | 4863.31 | 896.0 |
| 2014-11-02 19:00:00 | NQ | Futures | 4863.31 | 4866.53 | 4860.67 | 4864.77 | 1021.0 |
| 2014-11-02 20:00:00 | NQ | Futures | 4863.89 | 4865.07 | 4860.96 | 4861.26 | 594.0 |
| 2014-11-02 21:00:00 | NQ | Futures | 4861.26 | 4863.31 | 4860.38 | 4861.55 | 379.0 |
| 2014-11-02 22:00:00 | NQ | Futures | 4861.84 | 4863.31 | 4860.38 | 4861.26 | 417.0 |
| 2014-11-02 23:00:00 | NQ | Futures | 4861.26 | 4861.26 | 4856.28 | 4857.16 | 491.0 |
| 2014-11-02 18:00:00 | YM | Futures | 18000.4 | 18003.5 | 17979.6 | 17994.1 | 658.0 |
| 2014-11-02 19:00:00 | YM | Futures | 17994.1 | 18001.4 | 17983.7 | 17996.2 | 701.0 |
| 2014-11-02 20:00:00 | YM | Futures | 17997.3 | 17997.3 | 17982.7 | 17983.7 | 394.0 |
| 2014-11-02 21:00:00 | YM | Futures | 17984.8 | 17991.0 | 17981.7 | 17983.7 | 240.0 |
| 2014-11-02 22:00:00 | YM | Futures | 17983.7 | 17988.9 | 17979.6 | 17981.7 | 239.0 |
| 2014-11-02 23:00:00 | YM | Futures | 17981.7 | 17982.7 | 17966.1 | 17969.2 | 500.0 |
| 2014-11-02 18:00:00 | CL | Futures | 135.59 | 135.78 | 135.21 | 135.49 | 1287.0 |
| 2014-11-02 19:00:00 | CL | Futures | 135.49 | 135.66 | 135.22 | 135.27 | 892.0 |
| 2014-11-02 20:00:00 | CL | Futures | 135.26 | 135.64 | 135.22 | 135.41 | 1060.0 |
| 2014-11-02 21:00:00 | CL | Futures | 135.37 | 135.46 | 135.14 | 135.27 | 1172.0 |
| 2014-11-02 22:00:00 | CL | Futures | 135.27 | 135.27 | 135.05 | 135.15 | 619.0 |
| 2014-11-02 23:00:00 | CL | Futures | 135.14 | 135.21 | 134.95 | 135.02 | 1000.0 |
| 2014-11-02 18:00:00 | GC | Futures | 1603.2 | 1603.3 | 1592.2 | 1596.1 | 5444.0 |
| 2014-11-02 19:00:00 | GC | Futures | 1596.1 | 1596.9 | 1592.0 | 1593.3 | 2544.0 |
| 2014-11-02 20:00:00 | GC | Futures | 1593.5 | 1599.2 | 1589.3 | 1596.9 | 6792.0 |
| 2014-11-02 21:00:00 | GC | Futures | 1596.9 | 1600.2 | 1595.9 | 1597.3 | 3106.0 |
| 2014-11-02 22:00:00 | GC | Futures | 1597.4 | 1598.2 | 1595.9 | 1597.2 | 1739.0 |
| 2014-11-02 23:00:00 | GC | Futures | 1597.3 | 1602.6 | 1597.2 | 1599.9 | 2698.0 |
| 2014-11-02 18:00:00 | ZN | Futures | 119.636097 | 119.636097 | 119.532592 | 119.562165 | 7003.0 |
| 2014-11-02 19:00:00 | ZN | Futures | 119.562165 | 119.591738 | 119.532592 | 119.576951 | 2665.0 |
| 2014-11-02 20:00:00 | ZN | Futures | 119.562165 | 119.636097 | 119.562165 | 119.636097 | 4070.0 |
| 2014-11-02 21:00:00 | ZN | Futures | 119.62131 | 119.650883 | 119.606524 | 119.636097 | 3574.0 |
| 2014-11-02 22:00:00 | ZN | Futures | 119.650883 | 119.665669 | 119.636097 | 119.650883 | 1206.0 |
| 2014-11-02 23:00:00 | ZN | Futures | 119.650883 | 119.665669 | 119.62131 | 119.62131 | 1695.0 |
> showing 36 of 279 rows — these rows as CSV