PREVIEW / futures_daily / 2016-12-02
file: by_date/futures_daily/2016/2016-12-02.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-02 | ES | Futures | 2369.24 | 2376.54 | 2362.48 | 2370.86 | 1682042.0 |
| 2016-12-02 | NQ | Futures | 5581.02 | 5608.71 | 5547.72 | 5584.55 | 235325.0 |
| 2016-12-02 | YM | Futures | 20149.4 | 20153.6 | 20090.6 | 20116.8 | 136560.0 |
| 2016-12-02 | CL | Futures | 55.04 | 55.82 | 54.15 | 55.76 | 667099.0 |
| 2016-12-02 | GC | Futures | 1508.0 | 1515.7 | 1500.5 | 1512.5 | 175970.0 |
| 2016-12-02 | ZN | Futures | 121.343591 | 121.966801 | 121.343591 | 121.829999 | 42433.0 |
| 2016-12-02 | A6 | Futures | 0.75612 | 0.76173 | 0.75489 | 0.75938 | 84435.0 |
| 2016-12-02 | AD | Futures | 0.76915 | 0.77289 | 0.76915 | 0.77033 | 63559.0 |
| 2016-12-02 | ALI | Futures | 2367.85 | 2367.85 | 2367.85 | 2367.85 | 0.0 |
| 2016-12-02 | B | Futures | 40.14 | 40.6 | 39.37 | 40.57 | 312780.0 |
| 2016-12-02 | B6 | Futures | 1.3265 | 1.3414 | 1.3237 | 1.3383 | 98879.0 |
| 2016-12-02 | BFX | Futures | 4068.1 | 4076.4 | 4068.1 | 4076.4 | 1.0 |
| 2016-12-02 | BR | Futures | 0.19975 | 0.20057 | 0.19975 | 0.20018 | 82.0 |
| 2016-12-02 | BZ | Futures | 39.84 | 40.3 | 39.09 | 40.27 | 39305.0 |
| 2016-12-02 | C | Futures | 2080.0 | 2080.0 | 2020.0 | 2028.0 | 9442.0 |
| 2016-12-02 | CB | Futures | 261.997 | 265.689 | 261.997 | 264.865 | 18.0 |
| 2016-12-02 | CC | Futures | 1832.0 | 1835.0 | 1783.0 | 1823.0 | 19483.0 |
| 2016-12-02 | CNH | Futures | 7.4096 | 7.4128 | 7.3982 | 7.3982 | 100.0 |
| 2016-12-02 | CSC | Futures | 3.953 | 4.027 | 3.953 | 3.983 | 17.0 |
| 2016-12-02 | CT | Futures | 81.07 | 82.54 | 80.47 | 81.61 | 16718.0 |
| 2016-12-02 | DC | Futures | 32.04 | 32.96 | 32.04 | 32.33 | 489.0 |
| 2016-12-02 | DX | Futures | 93.956 | 94.166 | 93.728 | 93.873 | 41184.0 |
| 2016-12-02 | E1 | Futures | 1.2336 | 1.24157 | 1.23173 | 1.23335 | 26837.0 |
| 2016-12-02 | E6 | Futures | 1.23655 | 1.23991 | 1.23232 | 1.23626 | 195184.0 |
| 2016-12-02 | E7 | Futures | 1.2297 | 1.2332 | 1.2259 | 1.2296 | 3379.0 |
| 2016-12-02 | EBM | Futures | 189.17 | 189.47 | 187.7 | 188.29 | 9059.0 |
| 2016-12-02 | ED | Futures | 95.5838 | 95.5935 | 95.5838 | 95.5886 | 217949.0 |
| 2016-12-02 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 57982.0 |
| 2016-12-02 | EW | Futures | 1727.9 | 1734.7 | 1722.1 | 1727.8 | 15250.0 |
| 2016-12-02 | FBON | Futures | 120.09 | 120.29 | 119.96 | 120.2 | 1067.0 |
| 2016-12-02 | FBTP | Futures | 103.19 | 104.65 | 103.19 | 104.45 | 188237.0 |
| 2016-12-02 | FBTS | Futures | 100.691 | 100.862 | 100.682 | 100.817 | 41444.0 |
| 2016-12-02 | FCE | Futures | 4003.1 | 4012.0 | 3961.2 | 3996.5 | 115572.0 |
| 2016-12-02 | FDAX | Futures | 11065.2 | 11143.4 | 10990.2 | 11124.4 | 107288.0 |
| 2016-12-02 | FDXM | Futures | 11049.7 | 11120.4 | 10965.4 | 11100.3 | 23723.0 |
| 2016-12-02 | FESX | Futures | 2411.0 | 2422.2 | 2388.5 | 2416.6 | 1221854.0 |
| 2016-12-02 | FEU3 | Futures | 98.961 | 98.961 | 98.956 | 98.956 | 1.0 |
| 2016-12-02 | FGBL | Futures | 146.05 | 147.12 | 145.91 | 147.0 | 1084699.0 |
| 2016-12-02 | FGBM | Futures | 128.34 | 128.68 | 128.32 | 128.56 | 877768.0 |
| 2016-12-02 | FGBS | Futures | 112.117 | 112.177 | 112.097 | 112.122 | 803405.0 |
| 2016-12-02 | FGBX | Futures | 169.06 | 172.44 | 168.57 | 171.65 | 79120.0 |
| 2016-12-02 | FMWO | Futures | 5690.5 | 5724.3 | 5690.5 | 5724.3 | 117.0 |
| 2016-12-02 | FOAT | Futures | 131.8 | 133.0 | 131.68 | 132.84 | 169160.0 |
| 2016-12-02 | FTDX | Futures | 1641.6 | 1653.9 | 1633.8 | 1651.4 | 166.0 |
| 2016-12-02 | FTI | Futures | 410.36 | 410.91 | 406.03 | 409.73 | 42296.0 |
| 2016-12-02 | FTUK | Futures | 5670.5 | 5693.3 | 5635.5 | 5689.1 | 98013.0 |
| 2016-12-02 | FVSA | Futures | 1391.88 | 1413.87 | 1329.04 | 1344.75 | 44223.0 |
| 2016-12-02 | FXXP | Futures | 278.6 | 280.7 | 277.5 | 280.2 | 29849.0 |
| 2016-12-02 | G | Futures | 109.68 | 110.78 | 109.65 | 110.67 | 184166.0 |
| 2016-12-02 | GF | Futures | 285.04 | 285.765 | 277.065 | 277.958 | 5319.0 |
> showing 50 of 110 rows — these rows as CSV