PREVIEW / futures_daily / 2016-05-18
file: by_date/futures_daily/2016/2016-05-18.parquet size: 10 KB rows: 110
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-18 | ES | Futures | 2194.41 | 2209.44 | 2180.45 | 2191.99 | 2085972.0 |
| 2016-05-18 | NQ | Futures | 5077.21 | 5121.86 | 5053.71 | 5090.42 | 305289.0 |
| 2016-05-18 | YM | Futures | 18192.5 | 18308.0 | 18074.0 | 18173.8 | 232529.0 |
| 2016-05-18 | CL | Futures | 57.66 | 58.1 | 56.63 | 57.18 | 522016.0 |
| 2016-05-18 | GC | Futures | 1650.6 | 1654.3 | 1618.9 | 1642.6 | 233583.0 |
| 2016-05-18 | ZN | Futures | 125.811648 | 125.887083 | 124.876245 | 124.921507 | 1932669.0 |
| 2016-05-18 | A6 | Futures | 0.74055 | 0.74075 | 0.73013 | 0.73164 | 128243.0 |
| 2016-05-18 | AD | Futures | 0.79241 | 0.79292 | 0.78423 | 0.7875 | 79262.0 |
| 2016-05-18 | ALI | Futures | 2087.55 | 2087.55 | 2087.55 | 2087.55 | 0.0 |
| 2016-05-18 | B | Futures | 40.97 | 41.38 | 40.22 | 40.61 | 319810.0 |
| 2016-05-18 | B6 | Futures | 1.5228 | 1.5412 | 1.5168 | 1.5371 | 145690.0 |
| 2016-05-18 | BFX | Futures | 3912.0 | 3932.6 | 3910.8 | 3932.6 | 5.0 |
| 2016-05-18 | BR | Futures | 0.1849 | 0.1849 | 0.18087 | 0.18282 | 428.0 |
| 2016-05-18 | BZ | Futures | 40.89 | 41.23 | 40.09 | 40.48 | 33480.0 |
| 2016-05-18 | C | Futures | 2235.0 | 2249.0 | 2215.0 | 2239.0 | 15375.0 |
| 2016-05-18 | CB | Futures | 253.951 | 254.988 | 253.646 | 254.561 | 6.0 |
| 2016-05-18 | CC | Futures | 2122.0 | 2152.0 | 2114.0 | 2144.0 | 20632.0 |
| 2016-05-18 | CNH | Futures | 7.1239 | 7.1559 | 7.1239 | 7.1559 | 6.0 |
| 2016-05-18 | CSC | Futures | 3.257 | 3.281 | 3.246 | 3.279 | 95.0 |
| 2016-05-18 | CT | Futures | 70.63 | 71.53 | 69.84 | 70.58 | 16511.0 |
| 2016-05-18 | DC | Futures | 25.51 | 25.68 | 25.3 | 25.55 | 281.0 |
| 2016-05-18 | DX | Futures | 88.127 | 88.784 | 88.113 | 88.629 | 24264.0 |
| 2016-05-18 | E1 | Futures | 1.28285 | 1.28361 | 1.2728 | 1.27494 | 23307.0 |
| 2016-05-18 | E6 | Futures | 1.32036 | 1.32071 | 1.30881 | 1.31056 | 181767.0 |
| 2016-05-18 | E7 | Futures | 1.313 | 1.3135 | 1.3016 | 1.3035 | 2684.0 |
| 2016-05-18 | EBM | Futures | 197.57 | 198.17 | 196.67 | 197.27 | 10338.0 |
| 2016-05-18 | ED | Futures | 95.7328 | 95.7377 | 95.6846 | 95.6895 | 567005.0 |
| 2016-05-18 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.264 | 20579.0 |
| 2016-05-18 | EW | Futures | 1519.2 | 1531.0 | 1506.8 | 1513.6 | 18888.0 |
| 2016-05-18 | FBON | Futures | 118.23 | 118.43 | 117.97 | 118.12 | 215.0 |
| 2016-05-18 | FBTP | Futures | 106.3 | 106.59 | 106.08 | 106.23 | 121959.0 |
| 2016-05-18 | FBTS | Futures | 101.096 | 101.114 | 101.078 | 101.096 | 23176.0 |
| 2016-05-18 | FCE | Futures | 3642.5 | 3686.8 | 3631.7 | 3677.4 | 168772.0 |
| 2016-05-18 | FDAX | Futures | 10565.3 | 10699.1 | 10517.5 | 10680.3 | 103648.0 |
| 2016-05-18 | FDXM | Futures | 10167.9 | 10303.4 | 10129.6 | 10283.7 | 18284.0 |
| 2016-05-18 | FESX | Futures | 2258.9 | 2292.4 | 2251.8 | 2286.2 | 1357054.0 |
| 2016-05-18 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.912 | 20.0 |
| 2016-05-18 | FGBL | Futures | 146.6 | 146.65 | 145.93 | 146.35 | 714864.0 |
| 2016-05-18 | FGBM | Futures | 127.71 | 127.74 | 127.54 | 127.65 | 442790.0 |
| 2016-05-18 | FGBS | Futures | 111.663 | 111.678 | 111.648 | 111.663 | 186034.0 |
| 2016-05-18 | FGBX | Futures | 173.37 | 173.68 | 171.62 | 172.61 | 40602.0 |
| 2016-05-18 | FMWO | Futures | 5600.4 | 5600.4 | 5596.7 | 5597.9 | 19.0 |
| 2016-05-18 | FOAT | Futures | 134.09 | 134.17 | 133.65 | 133.87 | 79458.0 |
| 2016-05-18 | FTDX | Futures | 1574.7 | 1589.9 | 1574.7 | 1582.8 | 253.0 |
| 2016-05-18 | FTI | Futures | 384.62 | 389.25 | 383.32 | 388.31 | 24902.0 |
| 2016-05-18 | FTUK | Futures | 5043.6 | 5068.4 | 5018.0 | 5063.8 | 137989.0 |
| 2016-05-18 | FVSA | Futures | 2597.12 | 2597.12 | 2504.04 | 2508.69 | 12252.0 |
| 2016-05-18 | FXXP | Futures | 266.0 | 270.3 | 265.8 | 269.7 | 17948.0 |
| 2016-05-18 | G | Futures | 108.92 | 109.04 | 108.44 | 108.58 | 243238.0 |
| 2016-05-18 | GF | Futures | 297.228 | 299.075 | 296.23 | 298.227 | 2809.0 |
> showing 50 of 110 rows — these rows as CSV