PREVIEW / futures_daily / 2015-02-02
file: by_date/futures_daily/2015/2015-02-02.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-02-02 | ES | Futures | 2086.3 | 2115.65 | 2068.74 | 2114.07 | 2038824.0 |
| 2015-02-02 | NQ | Futures | 4807.67 | 4859.3 | 4740.37 | 4856.4 | 353848.0 |
| 2015-02-02 | YM | Futures | 17424.1 | 17634.9 | 17275.4 | 17618.6 | 229318.0 |
| 2015-02-02 | CL | Futures | 91.45 | 97.16 | 89.69 | 95.26 | 511409.0 |
| 2015-02-02 | GC | Futures | 1677.5 | 1678.7 | 1656.0 | 1669.5 | 119882.0 |
| 2015-02-02 | ZN | Futures | 123.471003 | 123.52989 | 123.01463 | 123.353229 | 1255126.0 |
| 2015-02-02 | A6 | Futures | 0.75879 | 0.76506 | 0.75869 | 0.76261 | 77411.0 |
| 2015-02-02 | AD | Futures | 0.8021 | 0.81066 | 0.79701 | 0.80883 | 85192.0 |
| 2015-02-02 | ALI | Futures | 2887.83 | 2887.83 | 2887.83 | 2887.83 | 0.0 |
| 2015-02-02 | B | Futures | 53.41 | 55.87 | 51.83 | 55.18 | 211577.0 |
| 2015-02-02 | B6 | Futures | 1.5857 | 1.5863 | 1.5772 | 1.5806 | 92744.0 |
| 2015-02-02 | BFX | Futures | 4277.4 | 4277.4 | 4243.6 | 4266.5 | 14.0 |
| 2015-02-02 | BR | Futures | 0.20519 | 0.20538 | 0.20088 | 0.20232 | 5659.0 |
| 2015-02-02 | BZ | Futures | 52.29 | 55.77 | 51.75 | 55.04 | 29844.0 |
| 2015-02-02 | C | Futures | 2077.0 | 2082.0 | 2064.0 | 2066.0 | 9493.0 |
| 2015-02-02 | CB | Futures | 151.938 | 151.938 | 149.247 | 151.178 | 34.0 |
| 2015-02-02 | CC | Futures | 1987.0 | 1992.0 | 1974.0 | 1976.0 | 14710.0 |
| 2015-02-02 | CNH | Futures | 7.1574 | 7.1574 | 7.1557 | 7.1557 | 2.0 |
| 2015-02-02 | CSC | Futures | 4.526 | 4.583 | 4.475 | 4.486 | 116.0 |
| 2015-02-02 | CT | Futures | 75.48 | 76.73 | 75.2 | 76.49 | 20568.0 |
| 2015-02-02 | DC | Futures | 36.56 | 37.38 | 36.35 | 36.58 | 353.0 |
| 2015-02-02 | DX | Futures | 89.834 | 90.019 | 89.56 | 89.673 | 23094.0 |
| 2015-02-02 | E1 | Futures | 1.38699 | 1.39082 | 1.36911 | 1.37907 | 13419.0 |
| 2015-02-02 | E6 | Futures | 1.33081 | 1.33705 | 1.3287 | 1.33505 | 205388.0 |
| 2015-02-02 | E7 | Futures | 1.3228 | 1.3291 | 1.3209 | 1.3271 | 3604.0 |
| 2015-02-02 | EBM | Futures | 301.7 | 302.11 | 296.43 | 296.84 | 21098.0 |
| 2015-02-02 | ED | Futures | 95.4498 | 95.4546 | 95.4402 | 95.4546 | 119390.0 |
| 2015-02-02 | ER | Futures | 98.028 | 98.038 | 98.023 | 98.033 | 130580.0 |
| 2015-02-02 | EW | Futures | 1496.9 | 1513.1 | 1480.1 | 1512.0 | 34102.0 |
| 2015-02-02 | FBTP | Futures | 101.21 | 101.54 | 100.71 | 100.87 | 88758.0 |
| 2015-02-02 | FBTS | Futures | 99.111 | 99.182 | 99.085 | 99.111 | 18779.0 |
| 2015-02-02 | FCE | Futures | 3760.4 | 3797.5 | 3738.4 | 3775.9 | 122668.0 |
| 2015-02-02 | FDAX | Futures | 11877.9 | 12083.3 | 11857.9 | 11999.5 | 119258.0 |
| 2015-02-02 | FESX | Futures | 2412.3 | 2446.2 | 2397.9 | 2426.0 | 1029256.0 |
| 2015-02-02 | FEU3 | Futures | 98.645 | 98.65 | 98.645 | 98.65 | 5001.0 |
| 2015-02-02 | FGBL | Futures | 139.54 | 139.65 | 139.35 | 139.52 | 484028.0 |
| 2015-02-02 | FGBM | Futures | 124.39 | 124.5 | 124.37 | 124.46 | 297727.0 |
| 2015-02-02 | FGBS | Futures | 111.153 | 111.158 | 111.123 | 111.153 | 265215.0 |
| 2015-02-02 | FGBX | Futures | 168.93 | 169.89 | 168.42 | 169.21 | 29747.0 |
| 2015-02-02 | FMWO | Futures | 5516.0 | 5561.8 | 5506.1 | 5544.4 | 473.0 |
| 2015-02-02 | FOAT | Futures | 128.07 | 128.14 | 127.93 | 128.07 | 52023.0 |
| 2015-02-02 | FTDX | Futures | 1405.9 | 1407.3 | 1380.1 | 1391.8 | 208.0 |
| 2015-02-02 | FTI | Futures | 389.04 | 390.81 | 385.06 | 388.95 | 36961.0 |
| 2015-02-02 | FTUK | Futures | 5243.0 | 5265.2 | 5202.8 | 5234.0 | 112870.0 |
| 2015-02-02 | FVSA | Futures | 2139.24 | 2212.42 | 2096.2 | 2139.24 | 7818.0 |
| 2015-02-02 | FXXP | Futures | 277.9 | 277.9 | 274.5 | 276.7 | 8943.0 |
| 2015-02-02 | G | Futures | 106.73 | 106.84 | 106.27 | 106.45 | 189005.0 |
| 2015-02-02 | GF | Futures | 344.184 | 346.082 | 338.575 | 338.575 | 4926.0 |
| 2015-02-02 | GSCI | Futures | 677.88 | 685.98 | 673.14 | 682.62 | 209.0 |
| 2015-02-02 | HE | Futures | 96.324 | 97.263 | 94.982 | 95.15 | 17996.0 |
> showing 50 of 107 rows — these rows as CSV