PREVIEW / futures_daily / 2016-12-06
file: by_date/futures_daily/2016/2016-12-06.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-12-06 | ES | Futures | 2384.92 | 2392.49 | 2379.78 | 2390.33 | 1483946.0 |
| 2016-12-06 | NQ | Futures | 5634.35 | 5652.91 | 5619.02 | 5641.42 | 185123.0 |
| 2016-12-06 | YM | Futures | 20175.6 | 20208.2 | 20135.7 | 20194.5 | 103826.0 |
| 2016-12-06 | CL | Futures | 55.0 | 55.68 | 54.25 | 54.96 | 642746.0 |
| 2016-12-06 | GC | Futures | 1506.1 | 1511.6 | 1500.1 | 1502.6 | 137614.0 |
| 2016-12-06 | ZN | Futures | 121.753998 | 121.936401 | 121.723597 | 121.799598 | 17022.0 |
| 2016-12-06 | A6 | Futures | 0.76244 | 0.76326 | 0.75795 | 0.76071 | 66509.0 |
| 2016-12-06 | AD | Futures | 0.77212 | 0.77299 | 0.76951 | 0.77069 | 48241.0 |
| 2016-12-06 | ALI | Futures | 2355.66 | 2356.3 | 2340.26 | 2344.43 | 106.0 |
| 2016-12-06 | B | Futures | 40.6 | 40.93 | 39.87 | 40.18 | 280650.0 |
| 2016-12-06 | B6 | Futures | 1.3408 | 1.3451 | 1.3327 | 1.335 | 96002.0 |
| 2016-12-06 | BR | Futures | 0.20249 | 0.20377 | 0.20185 | 0.20377 | 5.0 |
| 2016-12-06 | BZ | Futures | 40.09 | 40.62 | 39.58 | 39.88 | 34688.0 |
| 2016-12-06 | C | Futures | 1978.0 | 1979.0 | 1923.0 | 1952.0 | 9383.0 |
| 2016-12-06 | CB | Futures | 260.044 | 261.387 | 259.983 | 260.807 | 16.0 |
| 2016-12-06 | CC | Futures | 1806.0 | 1809.0 | 1768.0 | 1795.0 | 18704.0 |
| 2016-12-06 | CNH | Futures | 7.3915 | 7.4014 | 7.3915 | 7.4014 | 39.0 |
| 2016-12-06 | CSC | Futures | 3.96 | 3.972 | 3.953 | 3.967 | 47.0 |
| 2016-12-06 | CT | Futures | 81.57 | 82.35 | 81.39 | 81.94 | 9034.0 |
| 2016-12-06 | DC | Futures | 32.04 | 32.19 | 31.71 | 31.94 | 126.0 |
| 2016-12-06 | DX | Futures | 93.24 | 93.645 | 93.081 | 93.565 | 32299.0 |
| 2016-12-06 | E1 | Futures | 1.23871 | 1.24045 | 1.23235 | 1.23335 | 20559.0 |
| 2016-12-06 | E6 | Futures | 1.24814 | 1.25087 | 1.24073 | 1.24287 | 199821.0 |
| 2016-12-06 | E7 | Futures | 1.2411 | 1.244 | 1.2341 | 1.2362 | 4261.0 |
| 2016-12-06 | EBM | Futures | 185.16 | 186.3 | 184.87 | 185.73 | 23767.0 |
| 2016-12-06 | ED | Futures | 95.5862 | 95.5886 | 95.5838 | 95.5838 | 178063.0 |
| 2016-12-06 | ER | Futures | 98.279 | 98.283 | 98.279 | 98.283 | 35761.0 |
| 2016-12-06 | EW | Futures | 1747.1 | 1765.3 | 1744.9 | 1764.6 | 14014.0 |
| 2016-12-06 | FBON | Futures | 120.98 | 121.48 | 120.69 | 121.25 | 1012.0 |
| 2016-12-06 | FBTP | Futures | 104.94 | 105.89 | 104.91 | 105.12 | 224959.0 |
| 2016-12-06 | FBTS | Futures | 100.934 | 101.214 | 100.934 | 101.088 | 49511.0 |
| 2016-12-06 | FCE | Futures | 4048.6 | 4121.0 | 4023.9 | 4088.8 | 111775.0 |
| 2016-12-06 | FDAX | Futures | 11313.5 | 11455.1 | 11269.1 | 11389.1 | 101727.0 |
| 2016-12-06 | FDIV | Futures | 146.61 | 148.19 | 146.61 | 148.19 | 2.0 |
| 2016-12-06 | FDXM | Futures | 11288.0 | 11440.9 | 11243.7 | 11364.5 | 27201.0 |
| 2016-12-06 | FESX | Futures | 2450.2 | 2502.3 | 2439.8 | 2486.3 | 1465176.0 |
| 2016-12-06 | FGBL | Futures | 146.03 | 146.21 | 145.28 | 145.47 | 976766.0 |
| 2016-12-06 | FGBM | Futures | 128.07 | 128.17 | 127.77 | 127.86 | 826333.0 |
| 2016-12-06 | FGBS | Futures | 111.967 | 112.007 | 111.942 | 111.957 | 599798.0 |
| 2016-12-06 | FGBX | Futures | 169.24 | 170.05 | 167.16 | 167.97 | 116615.0 |
| 2016-12-06 | FMWO | Futures | 5753.4 | 5781.2 | 5750.9 | 5769.1 | 1138.0 |
| 2016-12-06 | FOAT | Futures | 132.35 | 132.99 | 132.02 | 132.14 | 254963.0 |
| 2016-12-06 | FTDX | Futures | 1667.6 | 1670.0 | 1660.7 | 1665.1 | 57.0 |
| 2016-12-06 | FTI | Futures | 414.97 | 420.8 | 413.33 | 418.57 | 34147.0 |
| 2016-12-06 | FTUK | Futures | 5693.8 | 5752.0 | 5672.2 | 5719.9 | 122952.0 |
| 2016-12-06 | FVSA | Futures | 1219.07 | 1225.35 | 1112.24 | 1168.8 | 37016.0 |
| 2016-12-06 | FXXP | Futures | 282.3 | 286.0 | 281.1 | 284.4 | 27210.0 |
| 2016-12-06 | G | Futures | 110.64 | 110.74 | 110.16 | 110.35 | 175058.0 |
| 2016-12-06 | GF | Futures | 278.181 | 284.26 | 274.221 | 282.977 | 5462.0 |
| 2016-12-06 | GSCI | Futures | 527.28 | 528.44 | 524.56 | 527.28 | 181.0 |
> showing 50 of 109 rows — these rows as CSV