PREVIEW / futures_1hour / 2018-07-01
file: by_date/futures_1hour/2018/2018-07-01.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 |
|---|---|---|---|---|---|---|---|
| 2018-07-01 18:00:00 | ES | Futures | 2965.52 | 2970.16 | 2956.26 | 2967.16 | 13989.0 |
| 2018-07-01 19:00:00 | ES | Futures | 2967.16 | 2969.61 | 2964.16 | 2967.43 | 5163.0 |
| 2018-07-01 20:00:00 | ES | Futures | 2967.43 | 2969.34 | 2963.07 | 2966.07 | 9677.0 |
| 2018-07-01 21:00:00 | ES | Futures | 2966.07 | 2973.15 | 2965.52 | 2971.52 | 8910.0 |
| 2018-07-01 22:00:00 | ES | Futures | 2971.52 | 2972.61 | 2966.89 | 2967.43 | 5423.0 |
| 2018-07-01 23:00:00 | ES | Futures | 2967.7 | 2967.98 | 2960.35 | 2961.98 | 9128.0 |
| 2018-07-01 18:00:00 | NQ | Futures | 8324.08 | 8338.81 | 8296.7 | 8327.03 | 3445.0 |
| 2018-07-01 19:00:00 | NQ | Futures | 8326.73 | 8333.51 | 8317.61 | 8327.62 | 1938.0 |
| 2018-07-01 20:00:00 | NQ | Futures | 8327.62 | 8332.03 | 8314.96 | 8322.61 | 2964.0 |
| 2018-07-01 21:00:00 | NQ | Futures | 8322.91 | 8347.34 | 8320.55 | 8340.57 | 3263.0 |
| 2018-07-01 22:00:00 | NQ | Futures | 8340.57 | 8345.28 | 8327.32 | 8329.68 | 1777.0 |
| 2018-07-01 23:00:00 | NQ | Futures | 8329.38 | 8332.03 | 8312.31 | 8316.72 | 2627.0 |
| 2018-07-01 18:00:00 | YM | Futures | 26389.2 | 26432.7 | 26291.4 | 26376.2 | 3078.0 |
| 2018-07-01 19:00:00 | YM | Futures | 26376.2 | 26409.9 | 26356.6 | 26382.7 | 1080.0 |
| 2018-07-01 20:00:00 | YM | Futures | 26384.9 | 26399.0 | 26345.7 | 26366.4 | 2977.0 |
| 2018-07-01 21:00:00 | YM | Futures | 26366.4 | 26443.6 | 26361.0 | 26427.3 | 4156.0 |
| 2018-07-01 22:00:00 | YM | Futures | 26428.4 | 26437.1 | 26361.0 | 26362.0 | 2895.0 |
| 2018-07-01 23:00:00 | YM | Futures | 26362.0 | 26362.0 | 26263.1 | 26277.2 | 4347.0 |
| 2018-07-01 18:00:00 | CL | Futures | 65.91 | 65.95 | 64.91 | 65.82 | 18154.0 |
| 2018-07-01 19:00:00 | CL | Futures | 65.82 | 66.19 | 65.74 | 65.79 | 6459.0 |
| 2018-07-01 20:00:00 | CL | Futures | 65.8 | 65.92 | 65.66 | 65.76 | 7603.0 |
| 2018-07-01 21:00:00 | CL | Futures | 65.76 | 65.88 | 65.68 | 65.73 | 8373.0 |
| 2018-07-01 22:00:00 | CL | Futures | 65.74 | 65.77 | 65.45 | 65.53 | 13765.0 |
| 2018-07-01 23:00:00 | CL | Futures | 65.53 | 65.63 | 65.47 | 65.55 | 6617.0 |
| 2018-07-01 18:00:00 | GC | Futures | 1645.7 | 1648.2 | 1645.1 | 1646.9 | 2150.0 |
| 2018-07-01 19:00:00 | GC | Futures | 1647.0 | 1648.6 | 1646.8 | 1647.4 | 3097.0 |
| 2018-07-01 20:00:00 | GC | Futures | 1647.3 | 1647.8 | 1644.9 | 1645.1 | 3322.0 |
| 2018-07-01 21:00:00 | GC | Futures | 1645.1 | 1646.0 | 1644.2 | 1644.8 | 5565.0 |
| 2018-07-01 22:00:00 | GC | Futures | 1644.8 | 1646.0 | 1643.6 | 1644.2 | 5374.0 |
| 2018-07-01 23:00:00 | GC | Futures | 1644.0 | 1644.9 | 1643.6 | 1644.2 | 2829.0 |
| 2018-07-01 18:00:00 | ZN | Futures | 120.825239 | 120.888103 | 120.793807 | 120.872387 | 10673.0 |
| 2018-07-01 19:00:00 | ZN | Futures | 120.856671 | 120.872387 | 120.825239 | 120.856671 | 5714.0 |
| 2018-07-01 20:00:00 | ZN | Futures | 120.856671 | 120.888103 | 120.840955 | 120.872387 | 5192.0 |
| 2018-07-01 21:00:00 | ZN | Futures | 120.872387 | 120.888103 | 120.809523 | 120.825239 | 13317.0 |
| 2018-07-01 22:00:00 | ZN | Futures | 120.825239 | 120.840955 | 120.809523 | 120.825239 | 7069.0 |
| 2018-07-01 23:00:00 | ZN | Futures | 120.825239 | 120.888103 | 120.825239 | 120.872387 | 8304.0 |
> showing 36 of 302 rows — these rows as CSV