PREVIEW / futures_daily / 2016-06-22
file: by_date/futures_daily/2016/2016-06-22.parquet size: 9 KB rows: 108
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-06-22 | ES | Futures | 2244.95 | 2257.9 | 2240.63 | 2242.25 | 1419838.0 |
| 2016-06-22 | NQ | Futures | 5183.19 | 5226.51 | 5175.83 | 5179.95 | 190665.0 |
| 2016-06-22 | YM | Futures | 18518.3 | 18618.5 | 18459.8 | 18475.4 | 129606.0 |
| 2016-06-22 | CL | Futures | 58.34 | 58.71 | 56.22 | 57.07 | 569939.0 |
| 2016-06-22 | GC | Futures | 1635.7 | 1638.4 | 1625.9 | 1633.9 | 132682.0 |
| 2016-06-22 | ZN | Futures | 126.716945 | 126.928215 | 126.671672 | 126.852761 | 916892.0 |
| 2016-06-22 | A6 | Futures | 0.75584 | 0.76327 | 0.75462 | 0.76124 | 74264.0 |
| 2016-06-22 | AD | Futures | 0.79895 | 0.80324 | 0.79629 | 0.79792 | 52357.0 |
| 2016-06-22 | ALI | Futures | 2151.91 | 2151.91 | 2151.91 | 2151.91 | 0.0 |
| 2016-06-22 | B | Futures | 41.39 | 41.53 | 39.86 | 40.43 | 282721.0 |
| 2016-06-22 | B6 | Futures | 1.5461 | 1.5584 | 1.5443 | 1.5494 | 144319.0 |
| 2016-06-22 | BZ | Futures | 41.21 | 41.42 | 39.77 | 40.33 | 34368.0 |
| 2016-06-22 | C | Futures | 2376.0 | 2390.0 | 2373.0 | 2386.0 | 8038.0 |
| 2016-06-22 | CB | Futures | 280.157 | 285.256 | 280.157 | 281.329 | 15.0 |
| 2016-06-22 | CC | Futures | 2308.0 | 2317.0 | 2299.0 | 2314.0 | 10447.0 |
| 2016-06-22 | CNH | Futures | 7.1579 | 7.1601 | 7.1416 | 7.1416 | 18.0 |
| 2016-06-22 | CSC | Futures | 3.623 | 3.667 | 3.623 | 3.657 | 21.0 |
| 2016-06-22 | CT | Futures | 71.47 | 72.17 | 71.13 | 71.59 | 3565.0 |
| 2016-06-22 | DC | Futures | 29.27 | 29.68 | 29.12 | 29.5 | 212.0 |
| 2016-06-22 | DX | Futures | 87.537 | 87.593 | 86.96 | 87.2 | 15474.0 |
| 2016-06-22 | E1 | Futures | 1.3076 | 1.31749 | 1.30672 | 1.31273 | 21631.0 |
| 2016-06-22 | E6 | Futures | 1.31361 | 1.32426 | 1.31227 | 1.32089 | 128010.0 |
| 2016-06-22 | E7 | Futures | 1.3068 | 1.3172 | 1.3054 | 1.3138 | 3130.0 |
| 2016-06-22 | EBM | Futures | 195.47 | 195.47 | 193.66 | 194.27 | 10455.0 |
| 2016-06-22 | ED | Futures | 95.757 | 95.7714 | 95.757 | 95.7666 | 132189.0 |
| 2016-06-22 | ER | Futures | 98.269 | 98.278 | 98.269 | 98.274 | 50915.0 |
| 2016-06-22 | EW | Futures | 1578.4 | 1589.4 | 1574.7 | 1575.8 | 16737.0 |
| 2016-06-22 | FBON | Futures | 119.34 | 119.67 | 119.32 | 119.45 | 571.0 |
| 2016-06-22 | FBTP | Futures | 107.23 | 107.63 | 107.18 | 107.42 | 82778.0 |
| 2016-06-22 | FBTS | Futures | 101.051 | 101.069 | 101.042 | 101.06 | 24612.0 |
| 2016-06-22 | FCE | Futures | 3836.5 | 3845.6 | 3796.8 | 3813.0 | 76455.0 |
| 2016-06-22 | FDAX | Futures | 10745.1 | 10792.0 | 10676.0 | 10779.2 | 94124.0 |
| 2016-06-22 | FDXM | Futures | 10470.0 | 10518.8 | 10406.7 | 10506.8 | 20730.0 |
| 2016-06-22 | FESX | Futures | 2340.0 | 2346.3 | 2316.5 | 2343.1 | 1327784.0 |
| 2016-06-22 | FEU3 | Futures | 98.927 | 98.927 | 98.927 | 98.927 | 24.0 |
| 2016-06-22 | FGBL | Futures | 147.91 | 148.17 | 147.72 | 147.78 | 500129.0 |
| 2016-06-22 | FGBM | Futures | 128.27 | 128.33 | 128.17 | 128.19 | 458135.0 |
| 2016-06-22 | FGBS | Futures | 111.788 | 111.808 | 111.768 | 111.783 | 195956.0 |
| 2016-06-22 | FGBX | Futures | 180.4 | 181.3 | 179.64 | 180.13 | 45717.0 |
| 2016-06-22 | FMWO | Futures | 5566.5 | 5596.9 | 5556.8 | 5595.7 | 1136.0 |
| 2016-06-22 | FOAT | Futures | 135.14 | 135.38 | 134.99 | 135.16 | 70529.0 |
| 2016-06-22 | FTDX | Futures | 1561.9 | 1573.4 | 1552.7 | 1573.4 | 67.0 |
| 2016-06-22 | FTI | Futures | 398.45 | 399.49 | 394.99 | 396.47 | 25040.0 |
| 2016-06-22 | FTUK | Futures | 5157.3 | 5225.3 | 5143.9 | 5215.3 | 146482.0 |
| 2016-06-22 | FVSA | Futures | 2629.42 | 2679.98 | 2583.91 | 2588.96 | 24445.0 |
| 2016-06-22 | FXXP | Futures | 275.6 | 276.6 | 273.0 | 276.3 | 42363.0 |
| 2016-06-22 | G | Futures | 109.95 | 110.11 | 109.8 | 109.84 | 128055.0 |
| 2016-06-22 | GF | Futures | 278.558 | 280.954 | 273.616 | 279.906 | 4869.0 |
| 2016-06-22 | GSCI | Futures | 554.0 | 554.65 | 546.09 | 546.6 | 239.0 |
| 2016-06-22 | HE | Futures | 104.326 | 104.567 | 101.528 | 101.649 | 11082.0 |
> showing 50 of 108 rows — these rows as CSV