PREVIEW / futures_daily / 2017-08-02
file: by_date/futures_daily/2017/2017-08-02.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-08-02 | ES | Futures | 2688.8 | 2690.97 | 2677.12 | 2688.26 | 1304650.0 |
| 2017-08-02 | NQ | Futures | 6974.49 | 6991.53 | 6884.26 | 6948.33 | 389618.0 |
| 2017-08-02 | YM | Futures | 23184.5 | 23282.8 | 23163.4 | 23210.9 | 98542.0 |
| 2017-08-02 | CL | Futures | 50.2 | 51.07 | 49.94 | 51.01 | 847722.0 |
| 2017-08-02 | GC | Futures | 1622.6 | 1627.4 | 1614.6 | 1626.6 | 210975.0 |
| 2017-08-02 | ZN | Futures | 124.288538 | 124.365487 | 124.073079 | 124.211588 | 1337711.0 |
| 2017-08-02 | A6 | Futures | 0.81821 | 0.82067 | 0.81533 | 0.81821 | 82640.0 |
| 2017-08-02 | AD | Futures | 0.81179 | 0.81209 | 0.80823 | 0.81041 | 76795.0 |
| 2017-08-02 | ALI | Futures | 2540.71 | 2540.71 | 2540.71 | 2540.71 | 0.0 |
| 2017-08-02 | B | Futures | 35.94 | 36.67 | 35.8 | 36.63 | 406415.0 |
| 2017-08-02 | B6 | Futures | 1.3826 | 1.3871 | 1.3805 | 1.3846 | 78386.0 |
| 2017-08-02 | BR | Futures | 0.23611 | 0.23711 | 0.23551 | 0.237 | 1962.0 |
| 2017-08-02 | BZ | Futures | 35.76 | 36.35 | 35.5 | 36.31 | 34625.0 |
| 2017-08-02 | C | Futures | 1553.0 | 1594.0 | 1549.0 | 1592.0 | 8498.0 |
| 2017-08-02 | CB | Futures | 331.841 | 333.453 | 331.841 | 332.084 | 10.0 |
| 2017-08-02 | CC | Futures | 1524.0 | 1571.0 | 1516.0 | 1560.0 | 23296.0 |
| 2017-08-02 | CNH | Futures | 6.9721 | 6.9721 | 6.9646 | 6.9646 | 12.0 |
| 2017-08-02 | CSC | Futures | 3.655 | 3.666 | 3.55 | 3.577 | 97.0 |
| 2017-08-02 | CT | Futures | 83.06 | 83.86 | 83.06 | 83.74 | 12.0 |
| 2017-08-02 | DC | Futures | 30.52 | 30.63 | 29.55 | 29.72 | 750.0 |
| 2017-08-02 | DX | Futures | 86.752 | 86.868 | 86.271 | 86.559 | 20522.0 |
| 2017-08-02 | E1 | Futures | 1.27579 | 1.27653 | 1.26805 | 1.26965 | 33548.0 |
| 2017-08-02 | E6 | Futures | 1.35586 | 1.36794 | 1.35454 | 1.36222 | 260660.0 |
| 2017-08-02 | E7 | Futures | 1.3489 | 1.3607 | 1.3474 | 1.3551 | 5286.0 |
| 2017-08-02 | EBM | Futures | 184.83 | 185.11 | 183.44 | 183.72 | 14258.0 |
| 2017-08-02 | ED | Futures | 95.5935 | 95.5983 | 95.5886 | 95.5935 | 136826.0 |
| 2017-08-02 | ER | Futures | 98.337 | 98.342 | 98.337 | 98.337 | 18040.0 |
| 2017-08-02 | EW | Futures | 1871.7 | 1873.8 | 1852.9 | 1860.2 | 15845.0 |
| 2017-08-02 | FBON | Futures | 124.82 | 124.89 | 124.56 | 124.76 | 202.0 |
| 2017-08-02 | FBTP | Futures | 109.17 | 109.36 | 108.88 | 109.24 | 70090.0 |
| 2017-08-02 | FBTS | Futures | 102.963 | 102.991 | 102.936 | 102.972 | 32004.0 |
| 2017-08-02 | FCE | Futures | 4608.2 | 4612.7 | 4572.8 | 4584.0 | 62668.0 |
| 2017-08-02 | FDAX | Futures | 12906.1 | 12925.0 | 12786.0 | 12810.3 | 76627.0 |
| 2017-08-02 | FDXM | Futures | 12831.4 | 12845.0 | 12706.8 | 12731.4 | 26016.0 |
| 2017-08-02 | FESX | Futures | 2838.1 | 2839.8 | 2812.0 | 2818.5 | 741783.0 |
| 2017-08-02 | FGBL | Futures | 147.98 | 148.05 | 147.74 | 147.95 | 493767.0 |
| 2017-08-02 | FGBM | Futures | 129.12 | 129.15 | 129.06 | 129.1 | 315066.0 |
| 2017-08-02 | FGBS | Futures | 112.322 | 112.327 | 112.297 | 112.307 | 256835.0 |
| 2017-08-02 | FGBX | Futures | 166.2 | 166.2 | 165.39 | 165.9 | 29690.0 |
| 2017-08-02 | FMWO | Futures | 6581.7 | 6581.7 | 6565.0 | 6567.4 | 3775.0 |
| 2017-08-02 | FOAT | Futures | 135.76 | 135.78 | 135.54 | 135.7 | 98984.0 |
| 2017-08-02 | FTDX | Futures | 2278.7 | 2295.7 | 2265.1 | 2266.7 | 523.0 |
| 2017-08-02 | FTI | Futures | 485.24 | 486.17 | 481.59 | 482.65 | 21484.0 |
| 2017-08-02 | FTUK | Futures | 6373.6 | 6376.6 | 6328.2 | 6346.3 | 74745.0 |
| 2017-08-02 | FVSA | Futures | 421.25 | 430.15 | 416.8 | 424.22 | 18742.0 |
| 2017-08-02 | FXXP | Futures | 323.2 | 323.2 | 320.8 | 321.3 | 29836.0 |
| 2017-08-02 | G | Futures | 114.46 | 114.59 | 114.1 | 114.36 | 186904.0 |
| 2017-08-02 | GF | Futures | 327.741 | 330.814 | 323.186 | 329.827 | 3456.0 |
| 2017-08-02 | GSCI | Futures | 465.23 | 468.44 | 465.23 | 468.44 | 311.0 |
| 2017-08-02 | HE | Futures | 90.139 | 93.428 | 89.754 | 92.693 | 24196.0 |
> showing 50 of 108 rows — these rows as CSV