PREVIEW / futures_daily / 2016-04-08
file: by_date/futures_daily/2016/2016-04-08.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-04-08 | ES | Futures | 2184.48 | 2205.68 | 2179.92 | 2191.19 | 1768420.0 |
| 2016-04-08 | NQ | Futures | 5249.34 | 5298.99 | 5230.54 | 5249.05 | 232565.0 |
| 2016-04-08 | YM | Futures | 18154.1 | 18309.0 | 18114.6 | 18180.1 | 157032.0 |
| 2016-04-08 | CL | Futures | 45.54 | 48.36 | 45.46 | 48.22 | 817230.0 |
| 2016-04-08 | GC | Futures | 1600.6 | 1604.2 | 1586.7 | 1603.2 | 132368.0 |
| 2016-04-08 | ZN | Futures | 126.716876 | 126.74705 | 126.339698 | 126.520743 | 783757.0 |
| 2016-04-08 | A6 | Futures | 0.75745 | 0.76494 | 0.75684 | 0.76251 | 80288.0 |
| 2016-04-08 | AD | Futures | 0.77748 | 0.78944 | 0.77717 | 0.78719 | 79626.0 |
| 2016-04-08 | ALI | Futures | 2066.58 | 2066.58 | 2066.58 | 2066.58 | 0.0 |
| 2016-04-08 | B | Futures | 33.05 | 34.99 | 33.0 | 34.93 | 340222.0 |
| 2016-04-08 | B6 | Futures | 1.4802 | 1.4892 | 1.4786 | 1.4871 | 78604.0 |
| 2016-04-08 | BR | Futures | 0.17527 | 0.17752 | 0.17527 | 0.17752 | 13.0 |
| 2016-04-08 | BZ | Futures | 32.75 | 34.62 | 32.66 | 34.57 | 32319.0 |
| 2016-04-08 | C | Futures | 2238.0 | 2262.0 | 2236.0 | 2253.0 | 4827.0 |
| 2016-04-08 | CB | Futures | 263.981 | 268.249 | 263.677 | 268.249 | 29.0 |
| 2016-04-08 | CC | Futures | 2101.0 | 2122.0 | 2099.0 | 2117.0 | 24253.0 |
| 2016-04-08 | CNH | Futures | 7.0743 | 7.0743 | 7.0661 | 7.0661 | 1.0 |
| 2016-04-08 | CSC | Futures | 3.623 | 3.635 | 3.623 | 3.63 | 14.0 |
| 2016-04-08 | CT | Futures | 68.01 | 69.58 | 67.82 | 68.99 | 29968.0 |
| 2016-04-08 | DC | Futures | 28.44 | 28.77 | 28.44 | 28.65 | 77.0 |
| 2016-04-08 | DX | Futures | 88.183 | 88.29 | 87.721 | 87.872 | 19260.0 |
| 2016-04-08 | E1 | Futures | 1.31766 | 1.32268 | 1.31477 | 1.32105 | 15851.0 |
| 2016-04-08 | E6 | Futures | 1.32882 | 1.33418 | 1.32602 | 1.33173 | 157386.0 |
| 2016-04-08 | E7 | Futures | 1.3216 | 1.3269 | 1.3188 | 1.3245 | 2560.0 |
| 2016-04-08 | EBM | Futures | 197.2 | 199.13 | 196.88 | 198.49 | 16121.0 |
| 2016-04-08 | ED | Futures | 95.7352 | 95.7352 | 95.7112 | 95.7208 | 163237.0 |
| 2016-04-08 | ER | Futures | 98.264 | 98.264 | 98.249 | 98.254 | 87737.0 |
| 2016-04-08 | EW | Futures | 1492.3 | 1514.8 | 1492.3 | 1504.5 | 16353.0 |
| 2016-04-08 | FBON | Futures | 117.67 | 118.32 | 117.65 | 118.29 | 279.0 |
| 2016-04-08 | FBTP | Futures | 106.63 | 107.26 | 106.6 | 107.17 | 81742.0 |
| 2016-04-08 | FBTS | Futures | 100.881 | 100.979 | 100.881 | 100.979 | 20531.0 |
| 2016-04-08 | FCE | Futures | 3542.6 | 3595.5 | 3539.7 | 3584.7 | 90505.0 |
| 2016-04-08 | FDAX | Futures | 10290.3 | 10427.8 | 10280.1 | 10366.6 | 96664.0 |
| 2016-04-08 | FDXM | Futures | 9904.1 | 10041.7 | 9896.9 | 9982.7 | 18484.0 |
| 2016-04-08 | FESX | Futures | 2187.9 | 2223.8 | 2184.0 | 2213.6 | 1210157.0 |
| 2016-04-08 | FEU3 | Futures | 98.912 | 98.912 | 98.907 | 98.907 | 15.0 |
| 2016-04-08 | FGBL | Futures | 146.85 | 147.03 | 146.73 | 146.86 | 409244.0 |
| 2016-04-08 | FGBM | Futures | 127.71 | 127.81 | 127.7 | 127.76 | 278327.0 |
| 2016-04-08 | FGBS | Futures | 111.668 | 111.703 | 111.668 | 111.698 | 169956.0 |
| 2016-04-08 | FGBX | Futures | 176.87 | 177.16 | 175.74 | 176.09 | 28649.0 |
| 2016-04-08 | FMWO | Futures | 5529.5 | 5556.9 | 5520.8 | 5547.0 | 129.0 |
| 2016-04-08 | FOAT | Futures | 134.45 | 134.63 | 134.37 | 134.49 | 65183.0 |
| 2016-04-08 | FTDX | Futures | 1543.3 | 1559.0 | 1543.3 | 1556.1 | 82.0 |
| 2016-04-08 | FTI | Futures | 380.71 | 385.5 | 380.71 | 385.01 | 29720.0 |
| 2016-04-08 | FTUK | Futures | 5001.9 | 5088.6 | 5001.9 | 5076.2 | 103918.0 |
| 2016-04-08 | FVSA | Futures | 2826.94 | 2826.94 | 2710.99 | 2744.12 | 5071.0 |
| 2016-04-08 | FXXP | Futures | 259.6 | 262.7 | 259.6 | 262.0 | 28600.0 |
| 2016-04-08 | G | Futures | 109.33 | 109.37 | 108.97 | 109.05 | 136050.0 |
| 2016-04-08 | GF | Futures | 305.281 | 309.403 | 305.281 | 306.066 | 1432.0 |
| 2016-04-08 | GSCI | Futures | 481.44 | 492.1 | 481.44 | 490.6 | 1871.0 |
> showing 50 of 109 rows — these rows as CSV