PREVIEW / futures_1hour / 2018-08-12
file: by_date/futures_1hour/2018/2018-08-12.parquet size: 16 KB rows: 322
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-08-12 18:00:00 | ES | Futures | 3090.59 | 3090.59 | 3082.41 | 3086.77 | 15004.0 |
| 2018-08-12 19:00:00 | ES | Futures | 3086.77 | 3088.41 | 3085.95 | 3085.95 | 5766.0 |
| 2018-08-12 20:00:00 | ES | Futures | 3086.23 | 3087.04 | 3081.87 | 3082.14 | 10658.0 |
| 2018-08-12 21:00:00 | ES | Futures | 3082.41 | 3082.96 | 3078.87 | 3078.87 | 17306.0 |
| 2018-08-12 22:00:00 | ES | Futures | 3078.87 | 3081.87 | 3076.96 | 3077.78 | 12645.0 |
| 2018-08-12 23:00:00 | ES | Futures | 3077.78 | 3079.41 | 3076.69 | 3077.23 | 7597.0 |
| 2018-08-12 18:00:00 | NQ | Futures | 8744.81 | 8747.16 | 8715.07 | 8729.79 | 3148.0 |
| 2018-08-12 19:00:00 | NQ | Futures | 8729.79 | 8737.74 | 8727.44 | 8728.32 | 1522.0 |
| 2018-08-12 20:00:00 | NQ | Futures | 8729.2 | 8734.8 | 8717.43 | 8718.6 | 2509.0 |
| 2018-08-12 21:00:00 | NQ | Futures | 8718.6 | 8720.96 | 8708.3 | 8708.89 | 4108.0 |
| 2018-08-12 22:00:00 | NQ | Futures | 8709.48 | 8719.19 | 8701.23 | 8706.53 | 2817.0 |
| 2018-08-12 23:00:00 | NQ | Futures | 8706.53 | 8711.54 | 8698.88 | 8701.53 | 2162.0 |
| 2018-08-12 18:00:00 | YM | Futures | 27540.5 | 27540.5 | 27436.1 | 27481.8 | 1887.0 |
| 2018-08-12 19:00:00 | YM | Futures | 27481.8 | 27503.5 | 27476.4 | 27479.6 | 806.0 |
| 2018-08-12 20:00:00 | YM | Futures | 27480.7 | 27486.1 | 27435.0 | 27436.1 | 1665.0 |
| 2018-08-12 21:00:00 | YM | Futures | 27437.2 | 27451.4 | 27405.7 | 27405.7 | 3250.0 |
| 2018-08-12 22:00:00 | YM | Futures | 27405.7 | 27420.9 | 27378.5 | 27385.0 | 2587.0 |
| 2018-08-12 23:00:00 | YM | Futures | 27388.3 | 27410.0 | 27377.4 | 27385.0 | 1267.0 |
| 2018-08-12 18:00:00 | CL | Futures | 61.61 | 61.75 | 61.44 | 61.71 | 3602.0 |
| 2018-08-12 19:00:00 | CL | Futures | 61.71 | 61.76 | 61.62 | 61.63 | 1941.0 |
| 2018-08-12 20:00:00 | CL | Futures | 61.62 | 61.65 | 61.54 | 61.55 | 4732.0 |
| 2018-08-12 21:00:00 | CL | Futures | 61.56 | 61.58 | 61.5 | 61.51 | 5030.0 |
| 2018-08-12 22:00:00 | CL | Futures | 61.51 | 61.56 | 61.44 | 61.46 | 3754.0 |
| 2018-08-12 23:00:00 | CL | Futures | 61.46 | 61.46 | 61.4 | 61.41 | 3273.0 |
| 2018-08-12 18:00:00 | GC | Futures | 1587.4 | 1590.7 | 1587.4 | 1589.6 | 3387.0 |
| 2018-08-12 19:00:00 | GC | Futures | 1589.7 | 1591.3 | 1589.0 | 1589.4 | 2712.0 |
| 2018-08-12 20:00:00 | GC | Futures | 1589.4 | 1589.7 | 1584.5 | 1585.1 | 11820.0 |
| 2018-08-12 21:00:00 | GC | Futures | 1585.2 | 1586.0 | 1583.4 | 1584.4 | 12654.0 |
| 2018-08-12 22:00:00 | GC | Futures | 1584.5 | 1585.8 | 1583.7 | 1583.9 | 6227.0 |
| 2018-08-12 23:00:00 | GC | Futures | 1583.9 | 1584.4 | 1582.7 | 1583.4 | 5357.0 |
| 2018-08-12 18:00:00 | ZN | Futures | 121.013832 | 121.13956 | 121.013832 | 121.06098 | 20698.0 |
| 2018-08-12 19:00:00 | ZN | Futures | 121.06098 | 121.076696 | 120.966683 | 120.998116 | 15885.0 |
| 2018-08-12 20:00:00 | ZN | Futures | 120.998116 | 121.06098 | 120.950967 | 121.06098 | 23217.0 |
| 2018-08-12 21:00:00 | ZN | Futures | 121.045264 | 121.13956 | 121.045264 | 121.108128 | 37412.0 |
| 2018-08-12 22:00:00 | ZN | Futures | 121.108128 | 121.13956 | 121.092412 | 121.108128 | 16211.0 |
| 2018-08-12 23:00:00 | ZN | Futures | 121.108128 | 121.155276 | 121.06098 | 121.076696 | 15407.0 |
> showing 36 of 322 rows — these rows as CSV