PREVIEW / futures_daily / 2016-02-24
file: by_date/futures_daily/2016/2016-02-24.parquet size: 9 KB rows: 111
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-02-24 | ES | Futures | 2044.41 | 2065.51 | 2015.31 | 2061.77 | 2315370.0 |
| 2016-02-24 | NQ | Futures | 4872.7 | 4945.38 | 4788.58 | 4933.66 | 336253.0 |
| 2016-02-24 | YM | Futures | 16948.0 | 17079.4 | 16692.4 | 17046.3 | 199855.0 |
| 2016-02-24 | CL | Futures | 39.3 | 40.71 | 38.4 | 40.39 | 652245.0 |
| 2016-02-24 | GC | Futures | 1575.3 | 1611.7 | 1570.7 | 1592.1 | 274243.0 |
| 2016-02-24 | ZN | Futures | 126.228893 | 126.875681 | 126.00327 | 126.108561 | 2558613.0 |
| 2016-02-24 | A6 | Futures | 0.71973 | 0.72214 | 0.71542 | 0.72103 | 91115.0 |
| 2016-02-24 | AD | Futures | 0.74139 | 0.74752 | 0.73771 | 0.74568 | 67734.0 |
| 2016-02-24 | ALI | Futures | 2120.9 | 2120.9 | 2120.9 | 2120.9 | 0.0 |
| 2016-02-24 | B | Futures | 27.96 | 29.4 | 27.56 | 29.21 | 259300.0 |
| 2016-02-24 | B6 | Futures | 1.4758 | 1.4759 | 1.4602 | 1.4641 | 118834.0 |
| 2016-02-24 | BFX | Futures | 3843.4 | 3843.4 | 3840.5 | 3840.5 | 4.0 |
| 2016-02-24 | BR | Futures | 0.15901 | 0.15923 | 0.15842 | 0.15923 | 174.0 |
| 2016-02-24 | BZ | Futures | 27.75 | 29.09 | 27.3 | 28.91 | 19999.0 |
| 2016-02-24 | C | Futures | 2243.0 | 2294.0 | 2239.0 | 2290.0 | 5630.0 |
| 2016-02-24 | CB | Futures | 258.524 | 258.524 | 254.256 | 254.256 | 49.0 |
| 2016-02-24 | CC | Futures | 2112.0 | 2152.0 | 2088.0 | 2145.0 | 15818.0 |
| 2016-02-24 | CNH | Futures | 7.175 | 7.1937 | 7.175 | 7.1842 | 41.0 |
| 2016-02-24 | CSC | Futures | 3.627 | 3.627 | 3.572 | 3.592 | 116.0 |
| 2016-02-24 | CT | Futures | 66.61 | 66.64 | 65.76 | 65.94 | 18116.0 |
| 2016-02-24 | DC | Futures | 28.53 | 28.53 | 28.09 | 28.24 | 124.0 |
| 2016-02-24 | DX | Futures | 91.061 | 91.476 | 90.836 | 91.046 | 27974.0 |
| 2016-02-24 | E1 | Futures | 1.27385 | 1.2823 | 1.26943 | 1.2789 | 23909.0 |
| 2016-02-24 | E6 | Futures | 1.28911 | 1.29233 | 1.2818 | 1.28847 | 244186.0 |
| 2016-02-24 | E7 | Futures | 1.2819 | 1.2848 | 1.2747 | 1.2812 | 3863.0 |
| 2016-02-24 | EBM | Futures | 211.88 | 212.23 | 205.52 | 205.87 | 17613.0 |
| 2016-02-24 | ED | Futures | 95.6289 | 95.6289 | 95.6097 | 95.6145 | 196689.0 |
| 2016-02-24 | ER | Futures | 98.288 | 98.293 | 98.278 | 98.283 | 55257.0 |
| 2016-02-24 | EW | Futures | 1379.1 | 1395.5 | 1361.5 | 1393.7 | 21445.0 |
| 2016-02-24 | FBON | Futures | 116.73 | 116.8 | 116.59 | 116.76 | 220.0 |
| 2016-02-24 | FBTP | Futures | 105.53 | 105.62 | 105.23 | 105.46 | 99920.0 |
| 2016-02-24 | FBTS | Futures | 100.846 | 100.864 | 100.802 | 100.828 | 23291.0 |
| 2016-02-24 | FCE | Futures | 3514.4 | 3533.5 | 3426.9 | 3459.8 | 118242.0 |
| 2016-02-24 | FDAX | Futures | 10169.2 | 10220.2 | 9890.0 | 9920.9 | 132750.0 |
| 2016-02-24 | FDXM | Futures | 9719.1 | 9771.0 | 9450.6 | 9484.8 | 26886.0 |
| 2016-02-24 | FESX | Futures | 2182.2 | 2197.4 | 2128.2 | 2138.1 | 1720006.0 |
| 2016-02-24 | FEU3 | Futures | 98.947 | 98.947 | 98.947 | 98.947 | 20.0 |
| 2016-02-24 | FGBL | Futures | 145.94 | 146.53 | 145.88 | 146.29 | 805444.0 |
| 2016-02-24 | FGBM | Futures | 127.56 | 127.74 | 127.53 | 127.62 | 557209.0 |
| 2016-02-24 | FGBS | Futures | 111.783 | 111.802 | 111.748 | 111.768 | 365901.0 |
| 2016-02-24 | FGBX | Futures | 173.85 | 175.29 | 173.77 | 174.61 | 49731.0 |
| 2016-02-24 | FMWO | Futures | 5184.5 | 5184.5 | 5108.6 | 5117.3 | 483.0 |
| 2016-02-24 | FOAT | Futures | 132.5 | 132.91 | 132.48 | 132.73 | 86203.0 |
| 2016-02-24 | FTDX | Futures | 1547.7 | 1556.8 | 1466.6 | 1468.5 | 2106.0 |
| 2016-02-24 | FTI | Futures | 366.77 | 368.28 | 358.94 | 360.71 | 35183.0 |
| 2016-02-24 | FTUK | Futures | 4829.1 | 4841.0 | 4742.3 | 4757.3 | 136929.0 |
| 2016-02-24 | FVSA | Futures | 3378.7 | 3589.14 | 3378.7 | 3548.22 | 8121.0 |
| 2016-02-24 | FXXP | Futures | 256.3 | 257.2 | 250.0 | 251.0 | 42831.0 |
| 2016-02-24 | G | Futures | 108.61 | 109.3 | 108.59 | 109.17 | 306457.0 |
| 2016-02-24 | GF | Futures | 308.421 | 311.956 | 306.752 | 310.139 | 3370.0 |
> showing 50 of 111 rows — these rows as CSV