PREVIEW / futures_1hour / 2016-02-21
file: by_date/futures_1hour/2016/2016-02-21.parquet size: 15 KB rows: 286
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-21 18:00:00 | ES | Futures | 2054.01 | 2054.01 | 2051.06 | 2052.94 | 9981.0 |
| 2016-02-21 19:00:00 | ES | Futures | 2052.94 | 2059.39 | 2052.67 | 2059.12 | 13492.0 |
| 2016-02-21 20:00:00 | ES | Futures | 2059.12 | 2067.45 | 2058.85 | 2063.69 | 18492.0 |
| 2016-02-21 21:00:00 | ES | Futures | 2063.95 | 2065.57 | 2061.8 | 2064.76 | 6871.0 |
| 2016-02-21 22:00:00 | ES | Futures | 2065.03 | 2069.6 | 2065.03 | 2069.06 | 8682.0 |
| 2016-02-21 23:00:00 | ES | Futures | 2069.06 | 2070.67 | 2066.91 | 2069.87 | 6931.0 |
| 2016-02-21 18:00:00 | NQ | Futures | 4935.3 | 4935.3 | 4924.9 | 4927.87 | 1388.0 |
| 2016-02-21 19:00:00 | NQ | Futures | 4927.58 | 4945.99 | 4927.58 | 4945.39 | 2181.0 |
| 2016-02-21 20:00:00 | NQ | Futures | 4945.99 | 4967.36 | 4944.8 | 4959.05 | 3359.0 |
| 2016-02-21 21:00:00 | NQ | Futures | 4958.75 | 4962.32 | 4952.52 | 4960.83 | 1307.0 |
| 2016-02-21 22:00:00 | NQ | Futures | 4960.83 | 4973.3 | 4960.83 | 4972.12 | 1078.0 |
| 2016-02-21 23:00:00 | NQ | Futures | 4972.41 | 4976.87 | 4967.07 | 4975.68 | 808.0 |
| 2016-02-21 18:00:00 | YM | Futures | 17396.8 | 17396.8 | 17368.0 | 17382.9 | 1023.0 |
| 2016-02-21 19:00:00 | YM | Futures | 17385.1 | 17433.0 | 17384.0 | 17430.8 | 2264.0 |
| 2016-02-21 20:00:00 | YM | Futures | 17430.8 | 17495.8 | 17428.7 | 17467.0 | 3087.0 |
| 2016-02-21 21:00:00 | YM | Futures | 17467.0 | 17481.9 | 17451.1 | 17474.5 | 1342.0 |
| 2016-02-21 22:00:00 | YM | Futures | 17478.7 | 17513.9 | 17478.7 | 17507.5 | 1200.0 |
| 2016-02-21 23:00:00 | YM | Futures | 17507.5 | 17520.2 | 17489.4 | 17516.0 | 926.0 |
| 2016-02-21 18:00:00 | CL | Futures | 36.94 | 37.0 | 36.54 | 36.76 | 3315.0 |
| 2016-02-21 19:00:00 | CL | Futures | 36.77 | 36.97 | 36.7 | 36.89 | 3908.0 |
| 2016-02-21 20:00:00 | CL | Futures | 36.9 | 37.19 | 36.89 | 37.12 | 3882.0 |
| 2016-02-21 21:00:00 | CL | Futures | 37.12 | 37.29 | 37.06 | 37.27 | 2872.0 |
| 2016-02-21 22:00:00 | CL | Futures | 37.27 | 37.54 | 37.23 | 37.39 | 4385.0 |
| 2016-02-21 23:00:00 | CL | Futures | 37.41 | 37.46 | 37.28 | 37.37 | 1921.0 |
| 2016-02-21 18:00:00 | GC | Futures | 1674.8 | 1674.8 | 1671.0 | 1673.7 | 1921.0 |
| 2016-02-21 19:00:00 | GC | Futures | 1673.7 | 1674.7 | 1671.0 | 1673.5 | 3352.0 |
| 2016-02-21 20:00:00 | GC | Futures | 1673.3 | 1674.7 | 1668.4 | 1670.2 | 5620.0 |
| 2016-02-21 21:00:00 | GC | Futures | 1670.2 | 1671.3 | 1669.0 | 1669.9 | 2888.0 |
| 2016-02-21 22:00:00 | GC | Futures | 1669.9 | 1670.2 | 1660.5 | 1661.5 | 6250.0 |
| 2016-02-21 23:00:00 | GC | Futures | 1661.5 | 1663.6 | 1659.0 | 1660.4 | 3564.0 |
| 2016-02-21 18:00:00 | ZN | Futures | 126.966548 | 127.042349 | 126.966548 | 127.012029 | 4708.0 |
| 2016-02-21 19:00:00 | ZN | Futures | 127.027189 | 127.042349 | 126.860427 | 126.860427 | 14536.0 |
| 2016-02-21 20:00:00 | ZN | Futures | 126.860427 | 126.905907 | 126.784626 | 126.890747 | 12491.0 |
| 2016-02-21 21:00:00 | ZN | Futures | 126.890747 | 126.921068 | 126.830106 | 126.845267 | 4422.0 |
| 2016-02-21 22:00:00 | ZN | Futures | 126.830106 | 126.860427 | 126.799786 | 126.799786 | 5277.0 |
| 2016-02-21 23:00:00 | ZN | Futures | 126.814946 | 126.830106 | 126.784626 | 126.799786 | 4129.0 |
> showing 36 of 286 rows — these rows as CSV