PREVIEW / futures_1hour / 2016-10-30
file: by_date/futures_1hour/2016/2016-10-30.parquet size: 15 KB rows: 288
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-10-30 18:00:00 | ES | Futures | 2307.23 | 2309.41 | 2301.52 | 2307.5 | 14680.0 |
| 2016-10-30 19:00:00 | ES | Futures | 2307.77 | 2309.41 | 2306.14 | 2307.5 | 5269.0 |
| 2016-10-30 20:00:00 | ES | Futures | 2307.5 | 2308.32 | 2306.14 | 2306.96 | 6033.0 |
| 2016-10-30 21:00:00 | ES | Futures | 2306.96 | 2310.22 | 2305.87 | 2309.13 | 8666.0 |
| 2016-10-30 22:00:00 | ES | Futures | 2309.13 | 2312.67 | 2308.86 | 2312.4 | 8447.0 |
| 2016-10-30 23:00:00 | ES | Futures | 2312.4 | 2316.75 | 2312.4 | 2314.85 | 12302.0 |
| 2016-10-30 18:00:00 | NQ | Futures | 5722.36 | 5732.21 | 5714.01 | 5729.22 | 2270.0 |
| 2016-10-30 19:00:00 | NQ | Futures | 5728.93 | 5733.7 | 5728.33 | 5731.01 | 1685.0 |
| 2016-10-30 20:00:00 | NQ | Futures | 5730.72 | 5731.91 | 5724.15 | 5725.35 | 2096.0 |
| 2016-10-30 21:00:00 | NQ | Futures | 5725.05 | 5736.09 | 5722.36 | 5734.0 | 1402.0 |
| 2016-10-30 22:00:00 | NQ | Futures | 5734.0 | 5745.33 | 5732.8 | 5745.33 | 1810.0 |
| 2016-10-30 23:00:00 | NQ | Futures | 5745.33 | 5756.37 | 5745.04 | 5753.09 | 3466.0 |
| 2016-10-30 18:00:00 | YM | Futures | 19524.0 | 19546.7 | 19488.3 | 19530.5 | 2012.0 |
| 2016-10-30 19:00:00 | YM | Futures | 19530.5 | 19545.6 | 19522.9 | 19530.5 | 1228.0 |
| 2016-10-30 20:00:00 | YM | Futures | 19530.5 | 19536.9 | 19519.7 | 19525.1 | 1053.0 |
| 2016-10-30 21:00:00 | YM | Futures | 19525.1 | 19551.0 | 19515.3 | 19540.2 | 1670.0 |
| 2016-10-30 22:00:00 | YM | Futures | 19541.3 | 19568.3 | 19536.9 | 19567.2 | 1727.0 |
| 2016-10-30 23:00:00 | YM | Futures | 19568.3 | 19597.5 | 19568.3 | 19587.7 | 2850.0 |
| 2016-10-30 18:00:00 | CL | Futures | 48.11 | 48.31 | 48.03 | 48.17 | 6789.0 |
| 2016-10-30 19:00:00 | CL | Futures | 48.17 | 48.26 | 48.16 | 48.21 | 2251.0 |
| 2016-10-30 20:00:00 | CL | Futures | 48.2 | 48.26 | 48.12 | 48.25 | 3203.0 |
| 2016-10-30 21:00:00 | CL | Futures | 48.24 | 48.41 | 48.22 | 48.39 | 6601.0 |
| 2016-10-30 22:00:00 | CL | Futures | 48.39 | 48.39 | 48.23 | 48.35 | 4095.0 |
| 2016-10-30 23:00:00 | CL | Futures | 48.34 | 48.38 | 48.31 | 48.36 | 1444.0 |
| 2016-10-30 18:00:00 | GC | Futures | 1729.5 | 1732.5 | 1728.0 | 1729.9 | 2418.0 |
| 2016-10-30 19:00:00 | GC | Futures | 1729.8 | 1731.5 | 1729.2 | 1731.4 | 954.0 |
| 2016-10-30 20:00:00 | GC | Futures | 1731.4 | 1732.3 | 1728.4 | 1729.1 | 3072.0 |
| 2016-10-30 21:00:00 | GC | Futures | 1729.2 | 1732.5 | 1728.0 | 1728.8 | 5417.0 |
| 2016-10-30 22:00:00 | GC | Futures | 1728.8 | 1729.8 | 1727.7 | 1728.8 | 3330.0 |
| 2016-10-30 23:00:00 | GC | Futures | 1728.9 | 1729.1 | 1728.1 | 1728.7 | 1441.0 |
| 2016-10-30 18:00:00 | ZN | Futures | 127.110457 | 127.171759 | 127.095131 | 127.156434 | 7996.0 |
| 2016-10-30 19:00:00 | ZN | Futures | 127.171759 | 127.171759 | 127.110457 | 127.110457 | 7674.0 |
| 2016-10-30 20:00:00 | ZN | Futures | 127.125783 | 127.141108 | 127.06448 | 127.06448 | 12557.0 |
| 2016-10-30 21:00:00 | ZN | Futures | 127.079806 | 127.095131 | 127.049155 | 127.06448 | 10396.0 |
| 2016-10-30 22:00:00 | ZN | Futures | 127.06448 | 127.06448 | 127.033829 | 127.049155 | 5024.0 |
| 2016-10-30 23:00:00 | ZN | Futures | 127.049155 | 127.06448 | 127.049155 | 127.06448 | 4919.0 |
> showing 36 of 288 rows — these rows as CSV