PREVIEW / futures_1hour / 2017-11-12
file: by_date/futures_1hour/2017/2017-11-12.parquet size: 14 KB rows: 289
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-12 18:00:00 | ES | Futures | 2823.4 | 2827.5 | 2822.85 | 2827.23 | 7502.0 |
| 2017-11-12 19:00:00 | ES | Futures | 2827.23 | 2828.05 | 2824.22 | 2825.31 | 8648.0 |
| 2017-11-12 20:00:00 | ES | Futures | 2825.31 | 2826.95 | 2824.22 | 2826.68 | 6257.0 |
| 2017-11-12 21:00:00 | ES | Futures | 2826.68 | 2826.68 | 2824.77 | 2825.59 | 2735.0 |
| 2017-11-12 22:00:00 | ES | Futures | 2825.59 | 2826.13 | 2825.04 | 2826.13 | 2227.0 |
| 2017-11-12 23:00:00 | ES | Futures | 2826.13 | 2827.78 | 2825.86 | 2827.5 | 3863.0 |
| 2017-11-12 18:00:00 | NQ | Futures | 7509.77 | 7518.09 | 7508.28 | 7517.5 | 1808.0 |
| 2017-11-12 19:00:00 | NQ | Futures | 7517.5 | 7518.99 | 7507.39 | 7512.14 | 1986.0 |
| 2017-11-12 20:00:00 | NQ | Futures | 7511.85 | 7519.28 | 7507.68 | 7517.5 | 2126.0 |
| 2017-11-12 21:00:00 | NQ | Futures | 7517.8 | 7517.8 | 7512.14 | 7514.82 | 976.0 |
| 2017-11-12 22:00:00 | NQ | Futures | 7515.12 | 7517.8 | 7513.33 | 7517.5 | 560.0 |
| 2017-11-12 23:00:00 | NQ | Futures | 7517.5 | 7521.96 | 7516.01 | 7520.47 | 776.0 |
| 2017-11-12 18:00:00 | YM | Futures | 25448.5 | 25480.1 | 25446.4 | 25476.8 | 1417.0 |
| 2017-11-12 19:00:00 | YM | Futures | 25477.9 | 25483.4 | 25454.0 | 25461.6 | 1756.0 |
| 2017-11-12 20:00:00 | YM | Futures | 25461.6 | 25475.7 | 25448.5 | 25468.1 | 1497.0 |
| 2017-11-12 21:00:00 | YM | Futures | 25469.2 | 25471.4 | 25457.3 | 25467.0 | 627.0 |
| 2017-11-12 22:00:00 | YM | Futures | 25467.0 | 25472.5 | 25460.5 | 25471.4 | 488.0 |
| 2017-11-12 23:00:00 | YM | Futures | 25471.4 | 25481.2 | 25468.1 | 25479.0 | 638.0 |
| 2017-11-12 18:00:00 | CL | Futures | 50.66 | 50.77 | 50.65 | 50.66 | 2612.0 |
| 2017-11-12 19:00:00 | CL | Futures | 50.66 | 50.66 | 50.62 | 50.64 | 1520.0 |
| 2017-11-12 20:00:00 | CL | Futures | 50.64 | 50.67 | 50.58 | 50.6 | 2649.0 |
| 2017-11-12 21:00:00 | CL | Futures | 50.59 | 50.6 | 50.56 | 50.59 | 2916.0 |
| 2017-11-12 22:00:00 | CL | Futures | 50.59 | 50.61 | 50.55 | 50.58 | 1796.0 |
| 2017-11-12 23:00:00 | CL | Futures | 50.57 | 50.59 | 50.55 | 50.58 | 1360.0 |
| 2017-11-12 18:00:00 | GC | Futures | 1698.9 | 1699.7 | 1697.7 | 1699.2 | 2871.0 |
| 2017-11-12 19:00:00 | GC | Futures | 1699.2 | 1700.1 | 1698.5 | 1699.4 | 3865.0 |
| 2017-11-12 20:00:00 | GC | Futures | 1699.3 | 1700.6 | 1699.0 | 1700.4 | 5763.0 |
| 2017-11-12 21:00:00 | GC | Futures | 1700.4 | 1700.9 | 1699.8 | 1700.5 | 4332.0 |
| 2017-11-12 22:00:00 | GC | Futures | 1700.4 | 1700.5 | 1699.4 | 1699.8 | 2741.0 |
| 2017-11-12 23:00:00 | GC | Futures | 1699.7 | 1700.0 | 1699.3 | 1699.6 | 1545.0 |
| 2017-11-12 18:00:00 | ZN | Futures | 124.158441 | 124.220683 | 124.111759 | 124.189562 | 15197.0 |
| 2017-11-12 19:00:00 | ZN | Futures | 124.189562 | 124.220683 | 124.174001 | 124.205123 | 10092.0 |
| 2017-11-12 20:00:00 | ZN | Futures | 124.205123 | 124.282926 | 124.205123 | 124.236244 | 23060.0 |
| 2017-11-12 21:00:00 | ZN | Futures | 124.251805 | 124.267365 | 124.236244 | 124.251805 | 8406.0 |
| 2017-11-12 22:00:00 | ZN | Futures | 124.236244 | 124.282926 | 124.236244 | 124.251805 | 3981.0 |
| 2017-11-12 23:00:00 | ZN | Futures | 124.267365 | 124.267365 | 124.236244 | 124.251805 | 4022.0 |
> showing 36 of 289 rows — these rows as CSV