PREVIEW / futures_daily / 2016-02-19
file: by_date/futures_daily/2016/2016-02-19.parquet size: 9 KB rows: 109
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-19 | ES | Futures | 2048.15 | 2053.76 | 2027.86 | 2044.95 | 1616647.0 |
| 2016-02-19 | NQ | Futures | 4872.4 | 4894.38 | 4830.2 | 4877.97 | 229019.0 |
| 2016-02-19 | YM | Futures | 16963.5 | 17014.2 | 16810.3 | 16927.3 | 142405.0 |
| 2016-02-19 | CL | Futures | 41.09 | 41.45 | 39.38 | 39.89 | 510897.0 |
| 2016-02-19 | GC | Futures | 1582.0 | 1587.3 | 1568.4 | 1581.5 | 184247.0 |
| 2016-02-19 | ZN | Futures | 126.19881 | 126.379309 | 125.762605 | 126.018311 | 1320422.0 |
| 2016-02-19 | A6 | Futures | 0.71602 | 0.71632 | 0.70761 | 0.71532 | 79305.0 |
| 2016-02-19 | AD | Futures | 0.74486 | 0.74496 | 0.73842 | 0.74251 | 45837.0 |
| 2016-02-19 | ALI | Futures | 2090.52 | 2090.52 | 2090.52 | 2090.52 | 0.0 |
| 2016-02-19 | B | Futures | 28.47 | 28.96 | 27.46 | 27.74 | 287089.0 |
| 2016-02-19 | B6 | Futures | 1.508 | 1.5167 | 1.499 | 1.511 | 98320.0 |
| 2016-02-19 | BFX | Futures | 3931.8 | 3931.8 | 3890.2 | 3899.6 | 4.0 |
| 2016-02-19 | BR | Futures | 0.15494 | 0.15601 | 0.15416 | 0.15507 | 1095.0 |
| 2016-02-19 | BZ | Futures | 28.39 | 28.72 | 27.26 | 27.53 | 32381.0 |
| 2016-02-19 | C | Futures | 2209.0 | 2234.0 | 2162.0 | 2166.0 | 4047.0 |
| 2016-02-19 | CB | Futures | 258.246 | 258.524 | 258.215 | 258.524 | 9.0 |
| 2016-02-19 | CC | Futures | 2121.0 | 2138.0 | 2079.0 | 2092.0 | 20486.0 |
| 2016-02-19 | CNH | Futures | 7.1869 | 7.1917 | 7.1858 | 7.1858 | 6.0 |
| 2016-02-19 | CSC | Futures | 3.743 | 3.745 | 3.743 | 3.745 | 8.0 |
| 2016-02-19 | CT | Futures | 70.4 | 70.77 | 70.05 | 70.29 | 4733.0 |
| 2016-02-19 | DC | Futures | 29.61 | 29.74 | 29.61 | 29.68 | 298.0 |
| 2016-02-19 | DX | Futures | 90.379 | 90.855 | 90.215 | 90.242 | 17971.0 |
| 2016-02-19 | E1 | Futures | 1.27157 | 1.27776 | 1.26779 | 1.27738 | 18438.0 |
| 2016-02-19 | E6 | Futures | 1.29987 | 1.3032 | 1.29385 | 1.30279 | 171382.0 |
| 2016-02-19 | E7 | Futures | 1.2924 | 1.2959 | 1.2874 | 1.2955 | 3087.0 |
| 2016-02-19 | EBM | Futures | 214.7 | 215.41 | 214.0 | 214.7 | 15756.0 |
| 2016-02-19 | ED | Futures | 95.6434 | 95.6458 | 95.6313 | 95.6385 | 152884.0 |
| 2016-02-19 | ER | Futures | 98.303 | 98.308 | 98.298 | 98.303 | 46811.0 |
| 2016-02-19 | EW | Futures | 1378.0 | 1382.6 | 1361.1 | 1376.1 | 13513.0 |
| 2016-02-19 | FBON | Futures | 116.28 | 116.28 | 115.81 | 115.91 | 361.0 |
| 2016-02-19 | FBTP | Futures | 105.44 | 105.56 | 104.96 | 105.14 | 78398.0 |
| 2016-02-19 | FBTS | Futures | 100.819 | 100.837 | 100.775 | 100.802 | 25339.0 |
| 2016-02-19 | FCE | Futures | 3526.9 | 3544.4 | 3481.1 | 3515.6 | 106672.0 |
| 2016-02-19 | FDAX | Futures | 10256.0 | 10273.3 | 10102.0 | 10152.4 | 96433.0 |
| 2016-02-19 | FDXM | Futures | 9805.2 | 9823.8 | 9658.0 | 9706.7 | 22014.0 |
| 2016-02-19 | FESX | Futures | 2198.2 | 2207.3 | 2160.9 | 2176.1 | 1480051.0 |
| 2016-02-19 | FGBL | Futures | 145.52 | 145.84 | 145.3 | 145.59 | 673649.0 |
| 2016-02-19 | FGBM | Futures | 127.52 | 127.66 | 127.45 | 127.55 | 461554.0 |
| 2016-02-19 | FGBS | Futures | 111.778 | 111.822 | 111.768 | 111.793 | 283278.0 |
| 2016-02-19 | FGBX | Futures | 172.19 | 172.92 | 171.38 | 172.14 | 33780.0 |
| 2016-02-19 | FMWO | Futures | 5229.4 | 5229.4 | 5162.1 | 5198.2 | 547.0 |
| 2016-02-19 | FOAT | Futures | 132.11 | 132.39 | 131.94 | 132.21 | 101244.0 |
| 2016-02-19 | FTDX | Futures | 1551.0 | 1556.8 | 1532.3 | 1543.4 | 363.0 |
| 2016-02-19 | FTI | Futures | 366.55 | 368.28 | 361.73 | 364.61 | 34479.0 |
| 2016-02-19 | FTUK | Futures | 4841.0 | 4873.6 | 4802.6 | 4823.4 | 99143.0 |
| 2016-02-19 | FVSA | Futures | 3378.7 | 3478.07 | 3355.32 | 3437.16 | 6277.0 |
| 2016-02-19 | FXXP | Futures | 257.8 | 258.9 | 254.5 | 256.0 | 16946.0 |
| 2016-02-19 | G | Futures | 108.64 | 108.86 | 108.34 | 108.63 | 179064.0 |
| 2016-02-19 | GF | Futures | 306.899 | 308.519 | 303.856 | 306.065 | 2205.0 |
| 2016-02-19 | GSCI | Futures | 453.33 | 453.33 | 446.85 | 447.77 | 158.0 |
> showing 50 of 109 rows — these rows as CSV