PREVIEW / futures_daily / 2016-12-22
file: by_date/futures_daily/2016/2016-12-22.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-22 | ES | Futures | 2448.17 | 2451.15 | 2440.85 | 2448.71 | 847626.0 |
| 2016-12-22 | NQ | Futures | 5831.75 | 5837.65 | 5795.22 | 5818.2 | 110522.0 |
| 2016-12-22 | YM | Futures | 20934.3 | 20959.6 | 20886.9 | 20932.2 | 71706.0 |
| 2016-12-22 | CL | Futures | 56.2 | 56.92 | 55.73 | 56.66 | 393487.0 |
| 2016-12-22 | GC | Futures | 1455.3 | 1458.2 | 1449.3 | 1452.0 | 120321.0 |
| 2016-12-22 | ZN | Futures | 120.651647 | 120.712775 | 120.346006 | 120.559954 | 585524.0 |
| 2016-12-22 | A6 | Futures | 0.739 | 0.74186 | 0.73562 | 0.73685 | 65932.0 |
| 2016-12-22 | AD | Futures | 0.761 | 0.76208 | 0.75626 | 0.75789 | 54235.0 |
| 2016-12-22 | ALI | Futures | 2355.87 | 2355.87 | 2355.87 | 2355.87 | 0.0 |
| 2016-12-22 | B | Futures | 40.64 | 41.15 | 40.27 | 41.01 | 194658.0 |
| 2016-12-22 | B6 | Futures | 1.2988 | 1.3012 | 1.2906 | 1.2915 | 73066.0 |
| 2016-12-22 | BR | Futures | 0.2095 | 0.21156 | 0.2095 | 0.21156 | 2.0 |
| 2016-12-22 | BZ | Futures | 40.37 | 40.84 | 39.97 | 40.71 | 30938.0 |
| 2016-12-22 | C | Futures | 1917.0 | 1920.0 | 1864.0 | 1868.0 | 15213.0 |
| 2016-12-22 | CB | Futures | 277.651 | 280.733 | 276.461 | 277.376 | 52.0 |
| 2016-12-22 | CC | Futures | 1734.0 | 1738.0 | 1662.0 | 1666.0 | 13927.0 |
| 2016-12-22 | CNH | Futures | 7.4412 | 7.4564 | 7.4412 | 7.4465 | 33.0 |
| 2016-12-22 | CSC | Futures | 4.034 | 4.034 | 4.013 | 4.031 | 18.0 |
| 2016-12-22 | CT | Futures | 80.56 | 81.3 | 80.14 | 80.64 | 10233.0 |
| 2016-12-22 | DC | Futures | 33.03 | 33.07 | 32.86 | 33.01 | 254.0 |
| 2016-12-22 | DX | Futures | 95.874 | 96.042 | 95.52 | 95.991 | 22637.0 |
| 2016-12-22 | E1 | Futures | 1.21422 | 1.21917 | 1.21322 | 1.21459 | 14901.0 |
| 2016-12-22 | E6 | Futures | 1.20936 | 1.21785 | 1.20907 | 1.2104 | 140543.0 |
| 2016-12-22 | E7 | Futures | 1.2034 | 1.2115 | 1.2028 | 1.2042 | 3918.0 |
| 2016-12-22 | EBM | Futures | 191.14 | 191.14 | 189.43 | 190.57 | 12488.0 |
| 2016-12-22 | ED | Futures | 95.5762 | 95.581 | 95.5713 | 95.5713 | 88108.0 |
| 2016-12-22 | ER | Futures | 98.279 | 98.283 | 98.279 | 98.283 | 37639.0 |
| 2016-12-22 | EW | Futures | 1785.9 | 1788.9 | 1771.8 | 1777.1 | 9452.0 |
| 2016-12-22 | FBON | Futures | 122.88 | 122.92 | 122.4 | 122.55 | 189.0 |
| 2016-12-22 | FBTP | Futures | 107.05 | 107.05 | 106.46 | 106.66 | 39195.0 |
| 2016-12-22 | FBTS | Futures | 101.945 | 101.945 | 101.855 | 101.864 | 12426.0 |
| 2016-12-22 | FCE | Futures | 4249.3 | 4259.9 | 4238.8 | 4253.3 | 54535.0 |
| 2016-12-22 | FDAX | Futures | 12084.7 | 12116.9 | 12063.6 | 12081.0 | 44684.0 |
| 2016-12-22 | FDXM | Futures | 12038.1 | 12068.6 | 12016.1 | 12032.4 | 10693.0 |
| 2016-12-22 | FESX | Futures | 2602.3 | 2613.5 | 2599.1 | 2604.7 | 548801.0 |
| 2016-12-22 | FEU3 | Futures | 98.942 | 98.952 | 98.942 | 98.952 | 190.0 |
| 2016-12-22 | FGBL | Futures | 147.3 | 147.41 | 146.89 | 147.15 | 316552.0 |
| 2016-12-22 | FGBM | Futures | 128.94 | 128.96 | 128.81 | 128.88 | 200726.0 |
| 2016-12-22 | FGBS | Futures | 112.162 | 112.167 | 112.132 | 112.152 | 129318.0 |
| 2016-12-22 | FGBX | Futures | 171.61 | 171.83 | 169.97 | 170.62 | 19693.0 |
| 2016-12-22 | FMWO | Futures | 5875.6 | 5881.6 | 5869.5 | 5869.5 | 61.0 |
| 2016-12-22 | FOAT | Futures | 133.79 | 133.82 | 133.14 | 133.36 | 45517.0 |
| 2016-12-22 | FTDX | Futures | 1750.4 | 1750.4 | 1737.7 | 1741.6 | 37.0 |
| 2016-12-22 | FTI | Futures | 439.28 | 439.42 | 437.78 | 438.96 | 16448.0 |
| 2016-12-22 | FTUK | Futures | 5908.8 | 5935.9 | 5897.7 | 5925.7 | 62084.0 |
| 2016-12-22 | FVSA | Futures | 1044.13 | 1055.09 | 1041.39 | 1049.61 | 12880.0 |
| 2016-12-22 | FXXP | Futures | 297.1 | 297.6 | 296.0 | 296.7 | 10688.0 |
| 2016-12-22 | G | Futures | 110.86 | 111.11 | 110.74 | 111.03 | 90237.0 |
| 2016-12-22 | GF | Futures | 290.617 | 292.681 | 289.446 | 292.514 | 2707.0 |
| 2016-12-22 | GSCI | Futures | 515.09 | 519.59 | 515.09 | 519.19 | 66.0 |
> showing 50 of 109 rows — these rows as CSV