PREVIEW / futures_daily / 2017-02-24
file: by_date/futures_daily/2017/2017-02-24.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-24 | ES | Futures | 2560.1 | 2564.71 | 2547.09 | 2563.9 | 1551959.0 |
| 2017-02-24 | NQ | Futures | 6281.1 | 6299.07 | 6245.44 | 6297.6 | 211944.0 |
| 2017-02-24 | YM | Futures | 21891.7 | 21907.5 | 21798.0 | 21894.9 | 138230.0 |
| 2017-02-24 | CL | Futures | 57.65 | 57.84 | 57.04 | 57.29 | 395258.0 |
| 2017-02-24 | GC | Futures | 1597.6 | 1611.2 | 1595.3 | 1607.5 | 220127.0 |
| 2017-02-24 | ZN | Futures | 122.40908 | 122.913387 | 122.33267 | 122.852259 | 2291354.0 |
| 2017-02-24 | A6 | Futures | 0.78979 | 0.79041 | 0.78467 | 0.78549 | 77306.0 |
| 2017-02-24 | AD | Futures | 0.7798 | 0.78322 | 0.77868 | 0.7799 | 66689.0 |
| 2017-02-24 | ALI | Futures | 2546.04 | 2546.04 | 2546.04 | 2546.04 | 0.0 |
| 2017-02-24 | B | Futures | 41.35 | 41.56 | 40.95 | 41.12 | 330680.0 |
| 2017-02-24 | B6 | Futures | 1.3167 | 1.3189 | 1.3059 | 1.3071 | 121331.0 |
| 2017-02-24 | BR | Futures | 0.22999 | 0.23118 | 0.22785 | 0.22785 | 789.0 |
| 2017-02-24 | BZ | Futures | 41.23 | 41.36 | 40.77 | 40.93 | 30201.0 |
| 2017-02-24 | C | Futures | 1678.0 | 1678.0 | 1644.0 | 1649.0 | 4788.0 |
| 2017-02-24 | CB | Futures | 276.461 | 277.071 | 275.85 | 276.461 | 18.0 |
| 2017-02-24 | CC | Futures | 1542.0 | 1551.0 | 1517.0 | 1522.0 | 13065.0 |
| 2017-02-24 | CNH | Futures | 7.2426 | 7.2472 | 7.241 | 7.2422 | 13.0 |
| 2017-02-24 | CSC | Futures | 3.804 | 3.813 | 3.799 | 3.799 | 64.0 |
| 2017-02-24 | CT | Futures | 84.88 | 86.04 | 84.82 | 85.35 | 11616.0 |
| 2017-02-24 | DC | Futures | 31.64 | 31.64 | 31.15 | 31.25 | 149.0 |
| 2017-02-24 | DX | Futures | 94.077 | 94.18 | 93.705 | 94.124 | 35987.0 |
| 2017-02-24 | E1 | Futures | 1.23194 | 1.23752 | 1.23045 | 1.23144 | 17865.0 |
| 2017-02-24 | E6 | Futures | 1.22253 | 1.22715 | 1.21999 | 1.22086 | 207934.0 |
| 2017-02-24 | E7 | Futures | 1.2166 | 1.2209 | 1.2137 | 1.2146 | 3603.0 |
| 2017-02-24 | EBM | Futures | 195.98 | 196.55 | 195.7 | 196.27 | 7403.0 |
| 2017-02-24 | ED | Futures | 95.5496 | 95.5593 | 95.5423 | 95.5496 | 321107.0 |
| 2017-02-24 | ER | Futures | 98.308 | 98.308 | 98.303 | 98.303 | 60217.0 |
| 2017-02-24 | EW | Futures | 1844.1 | 1848.7 | 1829.4 | 1848.0 | 11134.0 |
| 2017-02-24 | FBON | Futures | 120.19 | 121.16 | 120.19 | 121.06 | 1251.0 |
| 2017-02-24 | FBTP | Futures | 103.96 | 104.38 | 103.8 | 104.3 | 106554.0 |
| 2017-02-24 | FBTS | Futures | 101.467 | 101.548 | 101.439 | 101.521 | 51552.0 |
| 2017-02-24 | FCE | Futures | 4302.0 | 4302.9 | 4227.2 | 4262.0 | 155615.0 |
| 2017-02-24 | FDAX | Futures | 12596.2 | 12598.8 | 12370.8 | 12468.5 | 105756.0 |
| 2017-02-24 | FDXM | Futures | 12542.8 | 12549.1 | 12319.9 | 12418.2 | 35651.0 |
| 2017-02-24 | FESX | Futures | 2663.9 | 2665.5 | 2623.1 | 2645.5 | 1344190.0 |
| 2017-02-24 | FGBL | Futures | 149.45 | 150.07 | 149.35 | 149.9 | 841297.0 |
| 2017-02-24 | FGBM | Futures | 130.19 | 130.38 | 130.16 | 130.33 | 487407.0 |
| 2017-02-24 | FGBS | Futures | 112.562 | 112.617 | 112.532 | 112.607 | 490990.0 |
| 2017-02-24 | FGBX | Futures | 170.92 | 173.43 | 170.62 | 172.74 | 62309.0 |
| 2017-02-24 | FMWO | Futures | 6162.6 | 6162.6 | 6130.1 | 6148.2 | 347.0 |
| 2017-02-24 | FOAT | Futures | 131.19 | 132.09 | 131.08 | 131.95 | 169686.0 |
| 2017-02-24 | FTDX | Futures | 1872.0 | 1872.5 | 1834.2 | 1848.9 | 198.0 |
| 2017-02-24 | FTI | Futures | 451.61 | 452.07 | 446.21 | 449.61 | 33474.0 |
| 2017-02-24 | FTUK | Futures | 6159.3 | 6159.3 | 6084.7 | 6136.4 | 109476.0 |
| 2017-02-24 | FVSA | Futures | 726.12 | 767.97 | 726.12 | 734.49 | 18334.0 |
| 2017-02-24 | FXXP | Futures | 308.6 | 308.8 | 304.6 | 306.8 | 40688.0 |
| 2017-02-24 | G | Futures | 113.95 | 114.79 | 113.91 | 114.61 | 214782.0 |
| 2017-02-24 | GF | Futures | 284.91 | 285.195 | 276.988 | 277.444 | 7069.0 |
| 2017-02-24 | GSCI | Futures | 516.71 | 517.99 | 516.32 | 517.09 | 287.0 |
| 2017-02-24 | HE | Futures | 85.075 | 87.021 | 84.597 | 86.766 | 19905.0 |
> showing 50 of 108 rows — these rows as CSV