PREVIEW / futures_daily / 2016-06-02
file: by_date/futures_daily/2016/2016-06-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 |
|---|---|---|---|---|---|---|---|
| 2016-06-02 | ES | Futures | 2251.32 | 2259.91 | 2240.58 | 2258.83 | 1299962.0 |
| 2016-06-02 | NQ | Futures | 5311.62 | 5326.31 | 5271.38 | 5325.43 | 179288.0 |
| 2016-06-02 | YM | Futures | 18481.6 | 18541.9 | 18395.3 | 18533.6 | 113523.0 |
| 2016-06-02 | CL | Futures | 57.32 | 57.99 | 56.23 | 57.64 | 564846.0 |
| 2016-06-02 | GC | Futures | 1564.3 | 1569.5 | 1559.3 | 1560.0 | 112599.0 |
| 2016-06-02 | ZN | Futures | 125.208162 | 125.555166 | 125.177988 | 125.449556 | 122717.0 |
| 2016-06-02 | A6 | Futures | 0.73377 | 0.73559 | 0.72851 | 0.73073 | 90239.0 |
| 2016-06-02 | AD | Futures | 0.78177 | 0.7831 | 0.77779 | 0.77973 | 58416.0 |
| 2016-06-02 | ALI | Futures | 2064.71 | 2064.71 | 2064.71 | 2064.71 | 0.0 |
| 2016-06-02 | B | Futures | 40.23 | 40.77 | 39.59 | 40.56 | 270116.0 |
| 2016-06-02 | B6 | Futures | 1.5176 | 1.524 | 1.517 | 1.5193 | 74882.0 |
| 2016-06-02 | BR | Futures | 0.18033 | 0.18086 | 0.17973 | 0.18086 | 24.0 |
| 2016-06-02 | BZ | Futures | 40.22 | 40.67 | 39.5 | 40.46 | 28156.0 |
| 2016-06-02 | C | Futures | 2335.0 | 2363.0 | 2328.0 | 2352.0 | 8310.0 |
| 2016-06-02 | CB | Futures | 257.035 | 261.754 | 257.035 | 261.314 | 20.0 |
| 2016-06-02 | CC | Futures | 2216.0 | 2251.0 | 2211.0 | 2236.0 | 15924.0 |
| 2016-06-02 | CNH | Futures | 7.1546 | 7.1571 | 7.1522 | 7.1571 | 33.0 |
| 2016-06-02 | CSC | Futures | 3.312 | 3.38 | 3.308 | 3.365 | 54.0 |
| 2016-06-02 | CT | Futures | 71.86 | 72.42 | 71.45 | 71.51 | 16307.0 |
| 2016-06-02 | DC | Futures | 26.14 | 26.62 | 26.14 | 26.62 | 261.0 |
| 2016-06-02 | DX | Futures | 88.943 | 89.111 | 88.71 | 89.098 | 17539.0 |
| 2016-06-02 | E1 | Futures | 1.27192 | 1.27494 | 1.26815 | 1.2684 | 17054.0 |
| 2016-06-02 | E6 | Futures | 1.30508 | 1.30893 | 1.30018 | 1.30071 | 168309.0 |
| 2016-06-02 | E7 | Futures | 1.2975 | 1.3018 | 1.2933 | 1.2936 | 2770.0 |
| 2016-06-02 | EBM | Futures | 198.78 | 202.08 | 198.78 | 201.78 | 9650.0 |
| 2016-06-02 | ED | Futures | 95.6895 | 95.6967 | 95.6846 | 95.6846 | 233298.0 |
| 2016-06-02 | ER | Futures | 98.269 | 98.269 | 98.264 | 98.269 | 46479.0 |
| 2016-06-02 | EW | Futures | 1583.6 | 1594.1 | 1575.2 | 1593.8 | 18004.0 |
| 2016-06-02 | FBON | Futures | 119.25 | 119.48 | 118.95 | 119.36 | 1085.0 |
| 2016-06-02 | FBTP | Futures | 107.11 | 107.21 | 106.74 | 107.11 | 155469.0 |
| 2016-06-02 | FBTS | Futures | 101.15 | 101.167 | 101.123 | 101.167 | 33573.0 |
| 2016-06-02 | FCE | Futures | 3822.8 | 3851.7 | 3815.1 | 3831.9 | 73083.0 |
| 2016-06-02 | FDAX | Futures | 10933.8 | 11019.2 | 10905.8 | 10978.4 | 79269.0 |
| 2016-06-02 | FDXM | Futures | 10524.7 | 10611.6 | 10502.0 | 10571.3 | 14931.0 |
| 2016-06-02 | FESX | Futures | 2356.4 | 2375.9 | 2352.5 | 2364.2 | 1079660.0 |
| 2016-06-02 | FGBL | Futures | 146.81 | 147.21 | 146.57 | 147.12 | 1182069.0 |
| 2016-06-02 | FGBM | Futures | 127.78 | 127.82 | 127.63 | 127.79 | 1023701.0 |
| 2016-06-02 | FGBS | Futures | 111.678 | 111.693 | 111.658 | 111.683 | 559050.0 |
| 2016-06-02 | FGBX | Futures | 174.15 | 175.27 | 173.49 | 175.0 | 84011.0 |
| 2016-06-02 | FMWO | Futures | 5695.0 | 5695.0 | 5670.1 | 5686.2 | 123.0 |
| 2016-06-02 | FOAT | Futures | 134.27 | 134.59 | 133.98 | 134.5 | 232589.0 |
| 2016-06-02 | FTDX | Futures | 1618.5 | 1623.7 | 1614.2 | 1620.4 | 232.0 |
| 2016-06-02 | FTI | Futures | 400.25 | 403.94 | 400.21 | 401.83 | 25446.0 |
| 2016-06-02 | FTUK | Futures | 5114.6 | 5127.4 | 5086.1 | 5104.3 | 128056.0 |
| 2016-06-02 | FVSA | Futures | 2383.02 | 2429.57 | 2345.79 | 2383.02 | 6213.0 |
| 2016-06-02 | FXXP | Futures | 275.3 | 277.1 | 275.2 | 276.3 | 18874.0 |
| 2016-06-02 | G | Futures | 109.25 | 109.6 | 109.05 | 109.49 | 177449.0 |
| 2016-06-02 | GF | Futures | 292.087 | 294.433 | 290.639 | 292.336 | 2805.0 |
| 2016-06-02 | GSCI | Futures | 536.66 | 542.95 | 534.57 | 540.78 | 517.0 |
| 2016-06-02 | HE | Futures | 99.874 | 101.649 | 99.784 | 101.619 | 17487.0 |
> showing 50 of 108 rows — these rows as CSV