PREVIEW / futures_daily / 2016-05-17
file: by_date/futures_daily/2016/2016-05-17.parquet size: 9 KB rows: 109
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2016-05-17 | ES | Futures | 2214.01 | 2222.06 | 2186.89 | 2194.14 | 1988181.0 |
| 2016-05-17 | NQ | Futures | 5138.01 | 5162.69 | 5061.93 | 5075.44 | 256918.0 |
| 2016-05-17 | YM | Futures | 18361.0 | 18424.4 | 18115.6 | 18184.2 | 185539.0 |
| 2016-05-17 | CL | Futures | 56.97 | 57.94 | 56.48 | 57.43 | 313961.0 |
| 2016-05-17 | GC | Futures | 1643.3 | 1654.9 | 1637.1 | 1645.8 | 205190.0 |
| 2016-05-17 | ZN | Futures | 126.022868 | 126.128478 | 125.796561 | 125.917258 | 1127611.0 |
| 2016-05-17 | A6 | Futures | 0.73711 | 0.7448 | 0.7362 | 0.74035 | 103962.0 |
| 2016-05-17 | AD | Futures | 0.79292 | 0.7965 | 0.78924 | 0.79169 | 58865.0 |
| 2016-05-17 | ALI | Futures | 2081.76 | 2081.76 | 2081.76 | 2081.76 | 5.0 |
| 2016-05-17 | B | Futures | 40.7 | 41.3 | 40.32 | 40.91 | 262324.0 |
| 2016-05-17 | B6 | Futures | 1.5172 | 1.5295 | 1.5168 | 1.5223 | 99137.0 |
| 2016-05-17 | BFX | Futures | 3973.1 | 3974.3 | 3928.4 | 3929.6 | 70.0 |
| 2016-05-17 | BR | Futures | 0.1851 | 0.18601 | 0.18399 | 0.18542 | 726.0 |
| 2016-05-17 | BZ | Futures | 40.63 | 41.06 | 40.18 | 40.77 | 32460.0 |
| 2016-05-17 | C | Futures | 2250.0 | 2252.0 | 2227.0 | 2231.0 | 13170.0 |
| 2016-05-17 | CB | Futures | 252.427 | 253.646 | 252.427 | 252.518 | 18.0 |
| 2016-05-17 | CC | Futures | 2136.0 | 2145.0 | 2114.0 | 2121.0 | 18354.0 |
| 2016-05-17 | CNH | Futures | 7.1172 | 7.121 | 7.1171 | 7.121 | 4.0 |
| 2016-05-17 | CSC | Futures | 3.253 | 3.291 | 3.253 | 3.281 | 27.0 |
| 2016-05-17 | CT | Futures | 69.39 | 71.09 | 69.39 | 70.75 | 20498.0 |
| 2016-05-17 | DC | Futures | 25.49 | 25.8 | 25.41 | 25.61 | 269.0 |
| 2016-05-17 | DX | Futures | 88.15 | 88.327 | 87.927 | 88.133 | 11834.0 |
| 2016-05-17 | E1 | Futures | 1.28625 | 1.28976 | 1.28223 | 1.28336 | 18603.0 |
| 2016-05-17 | E6 | Futures | 1.32088 | 1.32462 | 1.31844 | 1.32088 | 123558.0 |
| 2016-05-17 | E7 | Futures | 1.3137 | 1.3173 | 1.3112 | 1.3137 | 2087.0 |
| 2016-05-17 | EBM | Futures | 196.67 | 198.48 | 194.87 | 198.17 | 11483.0 |
| 2016-05-17 | ED | Futures | 95.7545 | 95.7569 | 95.7328 | 95.7377 | 254871.0 |
| 2016-05-17 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.259 | 11617.0 |
| 2016-05-17 | EW | Futures | 1534.8 | 1540.3 | 1512.4 | 1517.8 | 18412.0 |
| 2016-05-17 | FBON | Futures | 117.93 | 118.44 | 117.89 | 118.33 | 150.0 |
| 2016-05-17 | FBTP | Futures | 106.17 | 106.48 | 106.13 | 106.4 | 78230.0 |
| 2016-05-17 | FBTS | Futures | 101.105 | 101.114 | 101.087 | 101.105 | 17372.0 |
| 2016-05-17 | FCE | Futures | 3679.5 | 3715.7 | 3633.5 | 3658.4 | 154383.0 |
| 2016-05-17 | FDAX | Futures | 10738.3 | 10827.4 | 10540.1 | 10604.0 | 116159.0 |
| 2016-05-17 | FDXM | Futures | 10340.6 | 10426.5 | 10151.3 | 10211.3 | 21903.0 |
| 2016-05-17 | FESX | Futures | 2290.1 | 2313.5 | 2255.0 | 2266.7 | 1522902.0 |
| 2016-05-17 | FGBL | Futures | 146.52 | 146.84 | 146.23 | 146.82 | 595706.0 |
| 2016-05-17 | FGBM | Futures | 127.69 | 127.76 | 127.61 | 127.75 | 426818.0 |
| 2016-05-17 | FGBS | Futures | 111.673 | 111.678 | 111.658 | 111.673 | 161888.0 |
| 2016-05-17 | FGBX | Futures | 173.29 | 174.22 | 172.42 | 174.15 | 32583.0 |
| 2016-05-17 | FMWO | Futures | 5639.0 | 5641.5 | 5594.2 | 5604.2 | 90.0 |
| 2016-05-17 | FOAT | Futures | 133.98 | 134.32 | 133.75 | 134.31 | 69355.0 |
| 2016-05-17 | FTDX | Futures | 1576.1 | 1588.0 | 1574.2 | 1581.8 | 225.0 |
| 2016-05-17 | FTI | Futures | 389.34 | 391.86 | 383.95 | 386.29 | 27613.0 |
| 2016-05-17 | FTUK | Futures | 5062.6 | 5105.1 | 5033.3 | 5058.9 | 122949.0 |
| 2016-05-17 | FVSA | Futures | 2536.62 | 2597.12 | 2471.46 | 2545.93 | 42654.0 |
| 2016-05-17 | FXXP | Futures | 268.3 | 270.8 | 266.1 | 267.0 | 25670.0 |
| 2016-05-17 | G | Futures | 108.79 | 109.21 | 108.66 | 109.18 | 187132.0 |
| 2016-05-17 | GF | Futures | 295.132 | 297.528 | 294.033 | 297.079 | 2679.0 |
| 2016-05-17 | GSCI | Futures | 531.82 | 538.18 | 531.82 | 536.01 | 83.0 |
> showing 50 of 109 rows — these rows as CSV