PREVIEW / futures_1hour / 2018-12-16
file: by_date/futures_1hour/2018/2018-12-16.parquet size: 15 KB rows: 330
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-12-16 18:00:00 | ES | Futures | 2819.59 | 2834.26 | 2819.59 | 2833.71 | 6956.0 |
| 2018-12-16 19:00:00 | ES | Futures | 2833.71 | 2836.97 | 2830.73 | 2833.98 | 6196.0 |
| 2018-12-16 20:00:00 | ES | Futures | 2833.98 | 2842.13 | 2833.98 | 2838.6 | 7983.0 |
| 2018-12-16 21:00:00 | ES | Futures | 2838.33 | 2842.68 | 2836.43 | 2841.86 | 8163.0 |
| 2018-12-16 22:00:00 | ES | Futures | 2841.59 | 2842.13 | 2837.24 | 2838.33 | 4484.0 |
| 2018-12-16 23:00:00 | ES | Futures | 2838.33 | 2840.5 | 2837.52 | 2840.23 | 2305.0 |
| 2018-12-16 18:00:00 | NQ | Futures | 7712.92 | 7755.0 | 7711.46 | 7755.0 | 2011.0 |
| 2018-12-16 19:00:00 | NQ | Futures | 7754.41 | 7766.39 | 7750.32 | 7754.7 | 1768.0 |
| 2018-12-16 20:00:00 | NQ | Futures | 7755.0 | 7777.5 | 7755.0 | 7766.68 | 2969.0 |
| 2018-12-16 21:00:00 | NQ | Futures | 7766.39 | 7779.25 | 7760.55 | 7777.5 | 3792.0 |
| 2018-12-16 22:00:00 | NQ | Futures | 7777.79 | 7778.96 | 7765.81 | 7767.56 | 1964.0 |
| 2018-12-16 23:00:00 | NQ | Futures | 7767.85 | 7775.16 | 7765.22 | 7775.16 | 1144.0 |
| 2018-12-16 18:00:00 | YM | Futures | 26076.5 | 26228.5 | 26068.9 | 26223.1 | 1360.0 |
| 2018-12-16 19:00:00 | YM | Futures | 26223.1 | 26265.4 | 26198.1 | 26243.7 | 1376.0 |
| 2018-12-16 20:00:00 | YM | Futures | 26241.5 | 26318.6 | 26239.4 | 26282.8 | 2167.0 |
| 2018-12-16 21:00:00 | YM | Futures | 26279.5 | 26312.1 | 26253.5 | 26301.2 | 2500.0 |
| 2018-12-16 22:00:00 | YM | Futures | 26299.1 | 26304.5 | 26257.8 | 26264.3 | 1304.0 |
| 2018-12-16 23:00:00 | YM | Futures | 26266.5 | 26291.5 | 26254.6 | 26291.5 | 829.0 |
| 2018-12-16 18:00:00 | CL | Futures | 47.03 | 47.16 | 47.03 | 47.08 | 1050.0 |
| 2018-12-16 19:00:00 | CL | Futures | 47.09 | 47.24 | 46.98 | 47.2 | 1860.0 |
| 2018-12-16 20:00:00 | CL | Futures | 47.19 | 47.26 | 47.04 | 47.07 | 3886.0 |
| 2018-12-16 21:00:00 | CL | Futures | 47.06 | 47.13 | 46.93 | 47.08 | 4349.0 |
| 2018-12-16 22:00:00 | CL | Futures | 47.08 | 47.14 | 47.04 | 47.06 | 2025.0 |
| 2018-12-16 23:00:00 | CL | Futures | 47.07 | 47.17 | 47.06 | 47.16 | 1621.0 |
| 2018-12-16 18:00:00 | GC | Futures | 1610.0 | 1610.1 | 1606.1 | 1607.5 | 2123.0 |
| 2018-12-16 19:00:00 | GC | Futures | 1607.4 | 1608.4 | 1605.6 | 1606.5 | 1899.0 |
| 2018-12-16 20:00:00 | GC | Futures | 1606.5 | 1608.5 | 1606.2 | 1608.2 | 3572.0 |
| 2018-12-16 21:00:00 | GC | Futures | 1608.2 | 1608.5 | 1607.3 | 1608.3 | 2911.0 |
| 2018-12-16 22:00:00 | GC | Futures | 1608.3 | 1608.5 | 1607.8 | 1608.2 | 1654.0 |
| 2018-12-16 23:00:00 | GC | Futures | 1608.2 | 1608.4 | 1607.0 | 1607.1 | 1348.0 |
| 2018-12-16 18:00:00 | ZN | Futures | 121.282099 | 121.313581 | 121.250618 | 121.266358 | 6490.0 |
| 2018-12-16 19:00:00 | ZN | Futures | 121.266358 | 121.282099 | 121.234877 | 121.266358 | 4104.0 |
| 2018-12-16 20:00:00 | ZN | Futures | 121.266358 | 121.282099 | 121.234877 | 121.266358 | 6287.0 |
| 2018-12-16 21:00:00 | ZN | Futures | 121.250618 | 121.266358 | 121.219136 | 121.234877 | 7959.0 |
| 2018-12-16 22:00:00 | ZN | Futures | 121.234877 | 121.250618 | 121.234877 | 121.250618 | 4759.0 |
| 2018-12-16 23:00:00 | ZN | Futures | 121.250618 | 121.282099 | 121.234877 | 121.266358 | 3767.0 |
> showing 36 of 330 rows — these rows as CSV