PREVIEW / futures_1hour / 2017-10-29
file: by_date/futures_1hour/2017/2017-10-29.parquet size: 15 KB rows: 302
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-10-29 18:00:00 | ES | Futures | 2818.2 | 2821.21 | 2817.38 | 2818.47 | 8700.0 |
| 2017-10-29 19:00:00 | ES | Futures | 2818.47 | 2818.75 | 2816.83 | 2817.11 | 4996.0 |
| 2017-10-29 20:00:00 | ES | Futures | 2817.11 | 2819.29 | 2815.19 | 2818.75 | 13139.0 |
| 2017-10-29 21:00:00 | ES | Futures | 2818.75 | 2819.02 | 2815.74 | 2816.29 | 8549.0 |
| 2017-10-29 22:00:00 | ES | Futures | 2816.01 | 2817.11 | 2814.64 | 2816.29 | 9857.0 |
| 2017-10-29 23:00:00 | ES | Futures | 2816.29 | 2816.56 | 2814.64 | 2815.47 | 4493.0 |
| 2017-10-29 18:00:00 | NQ | Futures | 7387.23 | 7400.32 | 7383.07 | 7390.2 | 2723.0 |
| 2017-10-29 19:00:00 | NQ | Futures | 7389.91 | 7391.1 | 7383.96 | 7385.74 | 1511.0 |
| 2017-10-29 20:00:00 | NQ | Futures | 7386.04 | 7401.21 | 7380.69 | 7399.13 | 4364.0 |
| 2017-10-29 21:00:00 | NQ | Futures | 7399.13 | 7403.59 | 7389.31 | 7389.61 | 2780.0 |
| 2017-10-29 22:00:00 | NQ | Futures | 7389.31 | 7392.29 | 7382.47 | 7388.42 | 2694.0 |
| 2017-10-29 23:00:00 | NQ | Futures | 7388.42 | 7390.8 | 7384.55 | 7387.53 | 930.0 |
| 2017-10-29 18:00:00 | YM | Futures | 25409.4 | 25436.6 | 25397.4 | 25412.7 | 1337.0 |
| 2017-10-29 19:00:00 | YM | Futures | 25411.6 | 25412.7 | 25402.9 | 25404.0 | 1022.0 |
| 2017-10-29 20:00:00 | YM | Futures | 25404.0 | 25424.6 | 25390.9 | 25414.8 | 2581.0 |
| 2017-10-29 21:00:00 | YM | Futures | 25417.0 | 25419.2 | 25386.6 | 25392.0 | 1912.0 |
| 2017-10-29 22:00:00 | YM | Futures | 25392.0 | 25404.0 | 25376.8 | 25397.4 | 1889.0 |
| 2017-10-29 23:00:00 | YM | Futures | 25398.5 | 25400.7 | 25382.2 | 25389.8 | 1011.0 |
| 2017-10-29 18:00:00 | CL | Futures | 48.22 | 48.24 | 48.13 | 48.16 | 3491.0 |
| 2017-10-29 19:00:00 | CL | Futures | 48.16 | 48.16 | 48.13 | 48.14 | 1472.0 |
| 2017-10-29 20:00:00 | CL | Futures | 48.14 | 48.15 | 48.07 | 48.12 | 3418.0 |
| 2017-10-29 21:00:00 | CL | Futures | 48.12 | 48.12 | 48.03 | 48.06 | 3563.0 |
| 2017-10-29 22:00:00 | CL | Futures | 48.06 | 48.07 | 48.0 | 48.01 | 2555.0 |
| 2017-10-29 23:00:00 | CL | Futures | 48.01 | 48.05 | 47.99 | 48.05 | 2496.0 |
| 2017-10-29 18:00:00 | GC | Futures | 1697.6 | 1698.1 | 1695.8 | 1696.5 | 2139.0 |
| 2017-10-29 19:00:00 | GC | Futures | 1696.5 | 1698.4 | 1695.7 | 1696.2 | 3887.0 |
| 2017-10-29 20:00:00 | GC | Futures | 1696.4 | 1697.0 | 1693.8 | 1695.7 | 5162.0 |
| 2017-10-29 21:00:00 | GC | Futures | 1695.8 | 1696.0 | 1694.2 | 1695.0 | 4952.0 |
| 2017-10-29 22:00:00 | GC | Futures | 1695.0 | 1696.6 | 1694.1 | 1694.4 | 5966.0 |
| 2017-10-29 23:00:00 | GC | Futures | 1694.2 | 1695.6 | 1694.1 | 1695.0 | 3032.0 |
| 2017-10-29 18:00:00 | ZN | Futures | 124.220683 | 124.329608 | 124.205123 | 124.236244 | 19583.0 |
| 2017-10-29 19:00:00 | ZN | Futures | 124.236244 | 124.298487 | 124.236244 | 124.298487 | 9907.0 |
| 2017-10-29 20:00:00 | ZN | Futures | 124.282926 | 124.314047 | 124.205123 | 124.267365 | 19244.0 |
| 2017-10-29 21:00:00 | ZN | Futures | 124.267365 | 124.314047 | 124.251805 | 124.298487 | 17850.0 |
| 2017-10-29 22:00:00 | ZN | Futures | 124.298487 | 124.345169 | 124.282926 | 124.298487 | 19533.0 |
| 2017-10-29 23:00:00 | ZN | Futures | 124.298487 | 124.360729 | 124.298487 | 124.329608 | 13218.0 |
> showing 36 of 302 rows — these rows as CSV