PREVIEW / futures_daily / 2015-10-14
file: by_date/futures_daily/2015/2015-10-14.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-14 | ES | Futures | 2118.46 | 2129.37 | 2108.89 | 2110.48 | 1780661.0 |
| 2015-10-14 | NQ | Futures | 5067.64 | 5103.89 | 5048.06 | 5058.58 | 284807.0 |
| 2015-10-14 | YM | Futures | 17489.7 | 17557.8 | 17326.6 | 17356.6 | 163381.0 |
| 2015-10-14 | CL | Futures | 74.94 | 75.34 | 73.78 | 74.88 | 191873.0 |
| 2015-10-14 | GC | Futures | 1508.0 | 1536.0 | 1500.7 | 1523.0 | 199965.0 |
| 2015-10-14 | ZN | Futures | 123.51193 | 124.170501 | 123.481995 | 124.095663 | 1215022.0 |
| 2015-10-14 | A6 | Futures | 0.71923 | 0.72953 | 0.71763 | 0.72663 | 101712.0 |
| 2015-10-14 | AD | Futures | 0.78582 | 0.79309 | 0.78572 | 0.79176 | 49754.0 |
| 2015-10-14 | ALI | Futures | 2150.98 | 2150.98 | 2150.98 | 2150.98 | 0.0 |
| 2015-10-14 | B | Futures | 44.22 | 44.78 | 44.05 | 44.48 | 253545.0 |
| 2015-10-14 | B6 | Futures | 1.6054 | 1.6312 | 1.6053 | 1.6299 | 122716.0 |
| 2015-10-14 | BFX | Futures | 4096.5 | 4136.0 | 4096.5 | 4099.0 | 182.0 |
| 2015-10-14 | BR | Futures | 0.15774 | 0.15887 | 0.1558 | 0.15777 | 390.0 |
| 2015-10-14 | BZ | Futures | 44.2 | 44.52 | 43.81 | 44.23 | 22984.0 |
| 2015-10-14 | C | Futures | 2282.0 | 2283.0 | 2239.0 | 2247.0 | 9419.0 |
| 2015-10-14 | CB | Futures | 183.316 | 184.57 | 183.316 | 184.57 | 4.0 |
| 2015-10-14 | CC | Futures | 2292.0 | 2308.0 | 2270.0 | 2280.0 | 14841.0 |
| 2015-10-14 | CNH | Futures | 7.0829 | 7.0919 | 7.0725 | 7.0725 | 48.0 |
| 2015-10-14 | CSC | Futures | 4.35 | 4.363 | 4.35 | 4.355 | 26.0 |
| 2015-10-14 | CT | Futures | 76.61 | 76.87 | 76.07 | 76.49 | 16794.0 |
| 2015-10-14 | DC | Futures | 35.19 | 35.19 | 34.97 | 35.01 | 69.0 |
| 2015-10-14 | DX | Futures | 88.653 | 88.658 | 87.784 | 87.874 | 36034.0 |
| 2015-10-14 | E1 | Futures | 1.32704 | 1.34023 | 1.3259 | 1.33947 | 16734.0 |
| 2015-10-14 | E6 | Futures | 1.33462 | 1.34715 | 1.33426 | 1.34586 | 200428.0 |
| 2015-10-14 | E7 | Futures | 1.327 | 1.3397 | 1.3269 | 1.3384 | 4152.0 |
| 2015-10-14 | EBM | Futures | 263.07 | 264.17 | 259.05 | 259.42 | 20646.0 |
| 2015-10-14 | ED | Futures | 95.7448 | 95.7688 | 95.74 | 95.764 | 338555.0 |
| 2015-10-14 | ER | Futures | 98.146 | 98.146 | 98.141 | 98.146 | 22788.0 |
| 2015-10-14 | EW | Futures | 1499.6 | 1508.1 | 1487.3 | 1488.0 | 17699.0 |
| 2015-10-14 | FBTP | Futures | 103.12 | 103.41 | 103.12 | 103.35 | 78373.0 |
| 2015-10-14 | FBTS | Futures | 100.382 | 100.4 | 100.373 | 100.373 | 10112.0 |
| 2015-10-14 | FCE | Futures | 3849.4 | 3889.0 | 3818.1 | 3843.1 | 105288.0 |
| 2015-10-14 | FDAX | Futures | 10980.6 | 11056.6 | 10887.6 | 10934.4 | 106519.0 |
| 2015-10-14 | FESX | Futures | 2392.3 | 2414.0 | 2376.6 | 2391.5 | 981559.0 |
| 2015-10-14 | FEU3 | Futures | 98.794 | 98.794 | 98.789 | 98.794 | 7.0 |
| 2015-10-14 | FGBL | Futures | 139.17 | 139.71 | 139.17 | 139.6 | 561794.0 |
| 2015-10-14 | FGBM | Futures | 125.3 | 125.46 | 125.29 | 125.44 | 358658.0 |
| 2015-10-14 | FGBS | Futures | 111.288 | 111.318 | 111.288 | 111.308 | 181120.0 |
| 2015-10-14 | FGBX | Futures | 158.2 | 159.59 | 158.2 | 159.22 | 30289.0 |
| 2015-10-14 | FMWO | Futures | 5533.4 | 5543.3 | 5508.7 | 5516.1 | 975.0 |
| 2015-10-14 | FOAT | Futures | 127.5 | 128.02 | 127.5 | 127.86 | 79798.0 |
| 2015-10-14 | FTDX | Futures | 1618.7 | 1618.7 | 1604.5 | 1607.3 | 446.0 |
| 2015-10-14 | FTI | Futures | 378.14 | 380.54 | 374.39 | 377.14 | 24567.0 |
| 2015-10-14 | FTUK | Futures | 5037.7 | 5055.8 | 5007.5 | 5025.6 | 94047.0 |
| 2015-10-14 | FVSA | Futures | 2283.78 | 2329.73 | 2233.23 | 2302.16 | 5334.0 |
| 2015-10-14 | FXXP | Futures | 276.5 | 278.8 | 275.4 | 276.7 | 22399.0 |
| 2015-10-14 | G | Futures | 105.07 | 105.51 | 105.02 | 105.43 | 162743.0 |
| 2015-10-14 | GF | Futures | 336.979 | 341.315 | 335.488 | 337.792 | 5990.0 |
| 2015-10-14 | GSCI | Futures | 595.59 | 595.67 | 593.24 | 595.59 | 1454.0 |
| 2015-10-14 | HE | Futures | 101.105 | 101.815 | 99.31 | 99.946 | 15531.0 |
> showing 50 of 107 rows — these rows as CSV