PREVIEW / futures_daily / 2016-12-30
file: by_date/futures_daily/2016/2016-12-30.parquet size: 9 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-12-30 | ES | Futures | 2435.16 | 2442.21 | 2415.37 | 2424.32 | 1281987.0 |
| 2016-12-30 | NQ | Futures | 5799.34 | 5822.32 | 5716.25 | 5732.75 | 197659.0 |
| 2016-12-30 | YM | Futures | 20823.7 | 20873.2 | 20708.9 | 20771.0 | 109475.0 |
| 2016-12-30 | CL | Futures | 57.65 | 57.88 | 57.16 | 57.49 | 271094.0 |
| 2016-12-30 | GC | Futures | 1489.0 | 1495.2 | 1477.2 | 1479.0 | 143849.0 |
| 2016-12-30 | ZN | Futures | 121.247646 | 121.599133 | 121.140672 | 121.553287 | 786367.0 |
| 2016-12-30 | A6 | Futures | 0.73808 | 0.74084 | 0.73562 | 0.73756 | 52756.0 |
| 2016-12-30 | AD | Futures | 0.75702 | 0.76284 | 0.75677 | 0.76009 | 46713.0 |
| 2016-12-30 | ALI | Futures | 2310.0 | 2310.0 | 2310.0 | 2310.0 | 0.0 |
| 2016-12-30 | B | Futures | 42.47 | 42.61 | 42.06 | 42.33 | 129096.0 |
| 2016-12-30 | B6 | Futures | 1.2881 | 1.3016 | 1.2865 | 1.2963 | 104045.0 |
| 2016-12-30 | BFX | Futures | 4306.7 | 4317.5 | 4306.7 | 4317.5 | 1.0 |
| 2016-12-30 | BR | Futures | 0.21611 | 0.21661 | 0.21362 | 0.21362 | 12.0 |
| 2016-12-30 | BZ | Futures | 42.11 | 42.31 | 41.75 | 42.02 | 13775.0 |
| 2016-12-30 | C | Futures | 1822.0 | 1844.0 | 1786.0 | 1796.0 | 13404.0 |
| 2016-12-30 | CB | Futures | 277.712 | 277.712 | 275.85 | 277.712 | 22.0 |
| 2016-12-30 | CC | Futures | 1638.0 | 1670.0 | 1615.0 | 1618.0 | 17035.0 |
| 2016-12-30 | CNH | Futures | 7.4894 | 7.5101 | 7.4887 | 7.4887 | 15.0 |
| 2016-12-30 | CSC | Futures | 4.029 | 4.029 | 4.029 | 4.029 | 4.0 |
| 2016-12-30 | CT | Futures | 81.19 | 82.66 | 80.91 | 81.16 | 15466.0 |
| 2016-12-30 | DC | Futures | 33.23 | 33.3 | 33.11 | 33.11 | 49.0 |
| 2016-12-30 | DX | Futures | 95.194 | 95.558 | 94.924 | 95.237 | 38079.0 |
| 2016-12-30 | E1 | Futures | 1.21707 | 1.2431 | 1.2162 | 1.22289 | 23973.0 |
| 2016-12-30 | E6 | Futures | 1.21606 | 1.23518 | 1.21514 | 1.22138 | 175634.0 |
| 2016-12-30 | E7 | Futures | 1.2099 | 1.2284 | 1.209 | 1.2151 | 7442.0 |
| 2016-12-30 | EBM | Futures | 191.42 | 191.99 | 190.85 | 191.42 | 5074.0 |
| 2016-12-30 | ED | Futures | 95.5955 | 95.6003 | 95.5858 | 95.6003 | 105274.0 |
| 2016-12-30 | ER | Futures | 98.288 | 98.293 | 98.288 | 98.293 | 26020.0 |
| 2016-12-30 | EW | Futures | 1774.6 | 1782.1 | 1762.8 | 1766.6 | 12806.0 |
| 2016-12-30 | FBON | Futures | 123.22 | 123.26 | 122.53 | 122.59 | 556.0 |
| 2016-12-30 | FBTP | Futures | 107.33 | 107.35 | 106.92 | 107.03 | 30042.0 |
| 2016-12-30 | FBTS | Futures | 101.918 | 101.927 | 101.891 | 101.909 | 9690.0 |
| 2016-12-30 | FCE | Futures | 4256.3 | 4278.8 | 4242.3 | 4277.0 | 59114.0 |
| 2016-12-30 | FDAX | Futures | 12093.2 | 12124.9 | 12037.2 | 12102.7 | 45783.0 |
| 2016-12-30 | FDXM | Futures | 12047.6 | 12077.0 | 11989.8 | 12053.9 | 8983.0 |
| 2016-12-30 | FESX | Futures | 2611.1 | 2628.7 | 2600.7 | 2621.5 | 554709.0 |
| 2016-12-30 | FEU3 | Futures | 98.961 | 98.961 | 98.961 | 98.961 | 1.0 |
| 2016-12-30 | FGBL | Futures | 148.4 | 148.41 | 147.98 | 148.04 | 295633.0 |
| 2016-12-30 | FGBM | Futures | 129.28 | 129.28 | 129.13 | 129.16 | 158109.0 |
| 2016-12-30 | FGBS | Futures | 112.172 | 112.182 | 112.147 | 112.157 | 91981.0 |
| 2016-12-30 | FGBX | Futures | 173.57 | 173.61 | 171.24 | 171.53 | 20366.0 |
| 2016-12-30 | FMWO | Futures | 5865.9 | 5882.8 | 5861.1 | 5861.1 | 92.0 |
| 2016-12-30 | FOAT | Futures | 134.33 | 134.36 | 133.66 | 133.9 | 53766.0 |
| 2016-12-30 | FTDX | Futures | 1779.3 | 1781.3 | 1772.5 | 1779.3 | 124.0 |
| 2016-12-30 | FTI | Futures | 438.83 | 439.92 | 436.83 | 439.51 | 19634.0 |
| 2016-12-30 | FTUK | Futures | 5969.0 | 6000.8 | 5956.7 | 5977.9 | 52096.0 |
| 2016-12-30 | FVSA | Futures | 1079.76 | 1107.16 | 1077.02 | 1090.72 | 7381.0 |
| 2016-12-30 | FXXP | Futures | 297.4 | 299.0 | 296.3 | 297.8 | 13655.0 |
| 2016-12-30 | G | Futures | 112.36 | 112.65 | 112.21 | 112.5 | 59556.0 |
| 2016-12-30 | GF | Futures | 294.075 | 296.529 | 289.112 | 291.008 | 2426.0 |
> showing 50 of 110 rows — these rows as CSV