PREVIEW / futures_daily / 2016-06-21
file: by_date/futures_daily/2016/2016-06-21.parquet size: 9 KB rows: 107
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-21 | ES | Futures | 2244.68 | 2252.23 | 2239.28 | 2246.3 | 1400709.0 |
| 2016-06-21 | NQ | Futures | 5184.67 | 5205.0 | 5172.59 | 5186.73 | 194521.0 |
| 2016-06-21 | YM | Futures | 18542.3 | 18586.2 | 18490.1 | 18526.6 | 125876.0 |
| 2016-06-21 | CL | Futures | 57.85 | 58.54 | 56.74 | 57.91 | 475407.0 |
| 2016-06-21 | GC | Futures | 1662.8 | 1669.1 | 1630.1 | 1637.1 | 207162.0 |
| 2016-06-21 | ZN | Futures | 126.82258 | 127.064032 | 126.641491 | 126.762217 | 981927.0 |
| 2016-06-21 | A6 | Futures | 0.75595 | 0.76185 | 0.75513 | 0.75757 | 89763.0 |
| 2016-06-21 | AD | Futures | 0.79925 | 0.80202 | 0.79802 | 0.79966 | 43757.0 |
| 2016-06-21 | ALI | Futures | 2158.57 | 2158.57 | 2158.57 | 2158.57 | 0.0 |
| 2016-06-21 | B | Futures | 40.88 | 41.42 | 40.09 | 41.03 | 256951.0 |
| 2016-06-21 | B6 | Futures | 1.5485 | 1.5596 | 1.5416 | 1.5469 | 165826.0 |
| 2016-06-21 | BR | Futures | 0.19295 | 0.19295 | 0.19211 | 0.19211 | 619.0 |
| 2016-06-21 | BZ | Futures | 40.8 | 41.32 | 40.01 | 40.93 | 29249.0 |
| 2016-06-21 | C | Futures | 2371.0 | 2375.0 | 2348.0 | 2374.0 | 4727.0 |
| 2016-06-21 | CB | Futures | 284.846 | 284.846 | 280.802 | 280.948 | 23.0 |
| 2016-06-21 | CC | Futures | 2297.0 | 2309.0 | 2274.0 | 2307.0 | 12722.0 |
| 2016-06-21 | CSC | Futures | 3.623 | 3.635 | 3.568 | 3.623 | 50.0 |
| 2016-06-21 | CT | Futures | 73.44 | 73.58 | 71.04 | 71.49 | 5346.0 |
| 2016-06-21 | DC | Futures | 29.18 | 29.39 | 28.71 | 29.21 | 233.0 |
| 2016-06-21 | DX | Futures | 87.072 | 87.607 | 86.932 | 87.482 | 19213.0 |
| 2016-06-21 | E1 | Futures | 1.30797 | 1.31436 | 1.3071 | 1.3086 | 23988.0 |
| 2016-06-21 | E6 | Futures | 1.32112 | 1.32554 | 1.31268 | 1.31483 | 145831.0 |
| 2016-06-21 | E7 | Futures | 1.3139 | 1.3185 | 1.306 | 1.3078 | 2923.0 |
| 2016-06-21 | EBM | Futures | 196.97 | 197.87 | 194.87 | 195.47 | 7859.0 |
| 2016-06-21 | ED | Futures | 95.7473 | 95.7666 | 95.7473 | 95.7522 | 195649.0 |
| 2016-06-21 | ER | Futures | 98.269 | 98.274 | 98.264 | 98.269 | 52189.0 |
| 2016-06-21 | EW | Futures | 1581.7 | 1587.8 | 1573.5 | 1579.7 | 16298.0 |
| 2016-06-21 | FBON | Futures | 119.7 | 119.74 | 119.31 | 119.42 | 515.0 |
| 2016-06-21 | FBTP | Futures | 107.43 | 107.47 | 107.02 | 107.3 | 89764.0 |
| 2016-06-21 | FBTS | Futures | 101.087 | 101.087 | 101.042 | 101.069 | 22890.0 |
| 2016-06-21 | FCE | Futures | 3782.5 | 3842.2 | 3760.3 | 3801.2 | 83684.0 |
| 2016-06-21 | FDAX | Futures | 10607.3 | 10760.0 | 10553.6 | 10672.8 | 97277.0 |
| 2016-06-21 | FDXM | Futures | 10336.2 | 10486.6 | 10286.4 | 10403.1 | 21870.0 |
| 2016-06-21 | FESX | Futures | 2300.9 | 2343.1 | 2290.7 | 2323.6 | 1408280.0 |
| 2016-06-21 | FGBL | Futures | 147.9 | 148.1 | 147.64 | 147.97 | 532514.0 |
| 2016-06-21 | FGBM | Futures | 128.3 | 128.34 | 128.23 | 128.28 | 459862.0 |
| 2016-06-21 | FGBS | Futures | 111.793 | 111.803 | 111.778 | 111.788 | 160453.0 |
| 2016-06-21 | FGBX | Futures | 180.77 | 181.28 | 179.15 | 180.71 | 38506.0 |
| 2016-06-21 | FMWO | Futures | 5570.1 | 5575.0 | 5559.2 | 5568.9 | 645.0 |
| 2016-06-21 | FOAT | Futures | 135.12 | 135.34 | 134.88 | 135.23 | 84376.0 |
| 2016-06-21 | FTDX | Futures | 1555.6 | 1565.2 | 1545.5 | 1556.6 | 105.0 |
| 2016-06-21 | FTI | Futures | 392.6 | 399.44 | 390.4 | 395.71 | 29345.0 |
| 2016-06-21 | FTUK | Futures | 5093.0 | 5194.4 | 5086.4 | 5166.4 | 129808.0 |
| 2016-06-21 | FVSA | Futures | 2690.1 | 2710.32 | 2568.74 | 2629.42 | 15099.0 |
| 2016-06-21 | FXXP | Futures | 271.9 | 276.2 | 270.3 | 274.4 | 43009.0 |
| 2016-06-21 | G | Futures | 110.42 | 110.57 | 110.01 | 110.24 | 157980.0 |
| 2016-06-21 | GF | Futures | 273.566 | 278.957 | 272.018 | 278.109 | 4280.0 |
| 2016-06-21 | GSCI | Futures | 547.76 | 551.39 | 546.89 | 551.39 | 26.0 |
| 2016-06-21 | HE | Futures | 104.085 | 104.477 | 103.544 | 103.724 | 4574.0 |
| 2016-06-21 | HG | Futures | 2.6229 | 2.6693 | 2.5985 | 2.6517 | 27077.0 |
> showing 50 of 107 rows — these rows as CSV