PREVIEW / futures_1hour / 2018-10-14
file: by_date/futures_1hour/2018/2018-10-14.parquet size: 15 KB rows: 303
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-14 18:00:00 | ES | Futures | 3013.74 | 3015.1 | 2999.05 | 3005.04 | 19274.0 |
| 2018-10-14 19:00:00 | ES | Futures | 3005.04 | 3011.56 | 3004.49 | 3011.29 | 10336.0 |
| 2018-10-14 20:00:00 | ES | Futures | 3011.29 | 3012.92 | 3000.14 | 3002.04 | 18845.0 |
| 2018-10-14 21:00:00 | ES | Futures | 3002.32 | 3009.66 | 2997.69 | 3008.84 | 23097.0 |
| 2018-10-14 22:00:00 | ES | Futures | 3009.12 | 3010.2 | 3001.77 | 3005.31 | 10771.0 |
| 2018-10-14 23:00:00 | ES | Futures | 3005.31 | 3006.94 | 3001.23 | 3005.31 | 6896.0 |
| 2018-10-14 18:00:00 | NQ | Futures | 8420.17 | 8422.81 | 8371.77 | 8393.77 | 6977.0 |
| 2018-10-14 19:00:00 | NQ | Futures | 8394.65 | 8411.08 | 8388.2 | 8408.14 | 3298.0 |
| 2018-10-14 20:00:00 | NQ | Futures | 8407.85 | 8414.01 | 8374.41 | 8382.62 | 6976.0 |
| 2018-10-14 21:00:00 | NQ | Futures | 8382.33 | 8399.34 | 8364.44 | 8397.0 | 9436.0 |
| 2018-10-14 22:00:00 | NQ | Futures | 8396.41 | 8405.5 | 8369.72 | 8384.09 | 5282.0 |
| 2018-10-14 23:00:00 | NQ | Futures | 8383.8 | 8390.54 | 8371.48 | 8383.5 | 2745.0 |
| 2018-10-14 18:00:00 | YM | Futures | 27536.6 | 27536.6 | 27389.9 | 27462.7 | 3440.0 |
| 2018-10-14 19:00:00 | YM | Futures | 27465.9 | 27515.9 | 27459.4 | 27510.5 | 1555.0 |
| 2018-10-14 20:00:00 | YM | Futures | 27508.3 | 27530.1 | 27393.1 | 27413.8 | 3861.0 |
| 2018-10-14 21:00:00 | YM | Futures | 27412.7 | 27498.5 | 27370.3 | 27490.9 | 3902.0 |
| 2018-10-14 22:00:00 | YM | Futures | 27489.8 | 27498.5 | 27420.3 | 27452.9 | 2281.0 |
| 2018-10-14 23:00:00 | YM | Futures | 27451.8 | 27469.2 | 27413.8 | 27449.6 | 1946.0 |
| 2018-10-14 18:00:00 | CL | Futures | 65.87 | 66.67 | 65.83 | 66.23 | 3335.0 |
| 2018-10-14 19:00:00 | CL | Futures | 66.22 | 66.35 | 66.16 | 66.32 | 765.0 |
| 2018-10-14 20:00:00 | CL | Futures | 66.32 | 66.39 | 66.11 | 66.18 | 1101.0 |
| 2018-10-14 21:00:00 | CL | Futures | 66.17 | 66.26 | 66.09 | 66.26 | 1253.0 |
| 2018-10-14 22:00:00 | CL | Futures | 66.26 | 66.27 | 66.09 | 66.12 | 691.0 |
| 2018-10-14 23:00:00 | CL | Futures | 66.11 | 66.16 | 66.09 | 66.14 | 410.0 |
| 2018-10-14 18:00:00 | GC | Futures | 1591.0 | 1593.1 | 1590.0 | 1592.5 | 2011.0 |
| 2018-10-14 19:00:00 | GC | Futures | 1592.6 | 1594.4 | 1592.5 | 1593.0 | 2618.0 |
| 2018-10-14 20:00:00 | GC | Futures | 1593.0 | 1596.1 | 1593.0 | 1595.2 | 4654.0 |
| 2018-10-14 21:00:00 | GC | Futures | 1595.2 | 1596.1 | 1594.3 | 1595.6 | 5615.0 |
| 2018-10-14 22:00:00 | GC | Futures | 1595.6 | 1596.3 | 1595.1 | 1595.7 | 4064.0 |
| 2018-10-14 23:00:00 | GC | Futures | 1595.9 | 1596.8 | 1595.0 | 1596.4 | 3507.0 |
| 2018-10-14 18:00:00 | ZN | Futures | 119.031527 | 119.078743 | 119.015788 | 119.078743 | 7420.0 |
| 2018-10-14 19:00:00 | ZN | Futures | 119.078743 | 119.078743 | 119.047265 | 119.078743 | 6764.0 |
| 2018-10-14 20:00:00 | ZN | Futures | 119.063004 | 119.141697 | 119.047265 | 119.125959 | 16908.0 |
| 2018-10-14 21:00:00 | ZN | Futures | 119.141697 | 119.157436 | 119.078743 | 119.078743 | 23740.0 |
| 2018-10-14 22:00:00 | ZN | Futures | 119.094481 | 119.125959 | 119.078743 | 119.11022 | 6090.0 |
| 2018-10-14 23:00:00 | ZN | Futures | 119.094481 | 119.141697 | 119.094481 | 119.11022 | 6641.0 |
> showing 36 of 303 rows — these rows as CSV