PREVIEW / futures_daily / 2011-11-02
file: by_date/futures_daily/2011/2011-11-02.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-02 | ES | Futures | 1221.35 | 1236.58 | 1214.37 | 1232.09 | 2264238.0 |
| 2011-11-02 | NQ | Futures | 2628.77 | 2659.31 | 2617.64 | 2641.9 | 285448.0 |
| 2011-11-02 | YM | Futures | 11215.7 | 11353.1 | 11160.0 | 11305.0 | 119672.0 |
| 2011-11-02 | CL | Futures | 171.84 | 175.95 | 170.66 | 173.55 | 265626.0 |
| 2011-11-02 | GC | Futures | 2324.3 | 2356.8 | 2316.2 | 2335.2 | 148068.0 |
| 2011-11-02 | ZN | Futures | 111.777532 | 111.99205 | 111.308272 | 111.817754 | 1077246.0 |
| 2011-11-02 | A6 | Futures | 0.90321 | 0.9121 | 0.89908 | 0.90427 | 136591.0 |
| 2011-11-02 | AD | Futures | 0.98054 | 0.98895 | 0.97764 | 0.98555 | 70023.0 |
| 2011-11-02 | B | Futures | 95.26 | 97.39 | 95.04 | 95.73 | 156729.0 |
| 2011-11-02 | B6 | Futures | 1.6647 | 1.6744 | 1.6604 | 1.6652 | 104116.0 |
| 2011-11-02 | BFX | Futures | 2491.1 | 2491.1 | 2463.4 | 2488.0 | 20.0 |
| 2011-11-02 | BR | Futures | 0.25724 | 0.25724 | 0.25724 | 0.25724 | 12.0 |
| 2011-11-02 | BZ | Futures | 102.58 | 102.58 | 101.08 | 101.08 | 1245.0 |
| 2011-11-02 | C | Futures | 1733.0 | 1757.0 | 1725.0 | 1751.0 | 6374.0 |
| 2011-11-02 | CB | Futures | 92.601 | 92.601 | 92.464 | 92.601 | 18.0 |
| 2011-11-02 | CC | Futures | 2039.0 | 2098.0 | 2036.0 | 2090.0 | 19636.0 |
| 2011-11-02 | CSC | Futures | 4.195 | 4.195 | 4.166 | 4.195 | 12.0 |
| 2011-11-02 | CT | Futures | 128.28 | 129.82 | 126.34 | 126.78 | 11510.0 |
| 2011-11-02 | DC | Futures | 29.81 | 29.88 | 29.52 | 29.82 | 170.0 |
| 2011-11-02 | DX | Futures | 76.201 | 76.225 | 75.445 | 75.77 | 29160.0 |
| 2011-11-02 | E1 | Futures | 1.48115 | 1.49335 | 1.47511 | 1.48732 | 18430.0 |
| 2011-11-02 | E6 | Futures | 1.6366 | 1.65238 | 1.62943 | 1.64425 | 300005.0 |
| 2011-11-02 | E7 | Futures | 1.6229 | 1.6381 | 1.6155 | 1.6302 | 5157.0 |
| 2011-11-02 | ED | Futures | 94.965 | 94.9936 | 94.9602 | 94.9746 | 155785.0 |
| 2011-11-02 | ER | Futures | 97.273 | 97.297 | 97.253 | 97.287 | 169599.0 |
| 2011-11-02 | EW | Futures | 865.2 | 882.5 | 862.0 | 876.9 | 35678.0 |
| 2011-11-02 | FBTP | Futures | 60.16 | 60.75 | 59.68 | 60.03 | 6959.0 |
| 2011-11-02 | FBTS | Futures | 80.531 | 80.82 | 80.178 | 80.443 | 2833.0 |
| 2011-11-02 | FCE | Futures | 2239.1 | 2247.0 | 2183.8 | 2230.1 | 98686.0 |
| 2011-11-02 | FDAX | Futures | 6450.8 | 6513.8 | 6315.1 | 6488.3 | 166075.0 |
| 2011-11-02 | FESX | Futures | 1523.2 | 1533.1 | 1483.9 | 1519.2 | 1255058.0 |
| 2011-11-02 | FEU3 | Futures | 97.826 | 97.846 | 97.821 | 97.846 | 40.0 |
| 2011-11-02 | FGBL | Futures | 111.57 | 111.65 | 110.97 | 111.3 | 803812.0 |
| 2011-11-02 | FGBM | Futures | 111.8 | 111.86 | 111.46 | 111.69 | 509777.0 |
| 2011-11-02 | FGBS | Futures | 109.292 | 109.307 | 109.203 | 109.278 | 479979.0 |
| 2011-11-02 | FGBX | Futures | 113.52 | 113.81 | 111.96 | 112.84 | 7894.0 |
| 2011-11-02 | FTDX | Futures | 634.8 | 634.8 | 622.4 | 624.7 | 328.0 |
| 2011-11-02 | FTI | Futures | 247.88 | 248.17 | 242.01 | 246.39 | 45102.0 |
| 2011-11-02 | FTUK | Futures | 3898.8 | 3944.4 | 3855.1 | 3934.4 | 146133.0 |
| 2011-11-02 | FVSA | Futures | 15918.1 | 17209.88 | 15751.42 | 16605.66 | 4516.0 |
| 2011-11-02 | FXXP | Futures | 165.3 | 165.7 | 162.5 | 165.4 | 966.0 |
| 2011-11-02 | G | Futures | 92.13 | 92.25 | 91.66 | 92.05 | 150786.0 |
| 2011-11-02 | GF | Futures | 315.248 | 315.967 | 313.478 | 314.916 | 642.0 |
| 2011-11-02 | GSCI | Futures | 1014.63 | 1019.96 | 1002.18 | 1004.45 | 199.0 |
| 2011-11-02 | HE | Futures | 113.114 | 113.339 | 111.508 | 111.668 | 15343.0 |
| 2011-11-02 | HG | Futures | 4.6361 | 4.8029 | 4.6017 | 4.7387 | 38032.0 |
| 2011-11-02 | HO | Futures | 2.4332 | 2.4609 | 2.4049 | 2.4103 | 74438.0 |
| 2011-11-02 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-02 | J1 | Futures | 0.0160496 | 0.0161338 | 0.0160421 | 0.0161099 | 57556.0 |
| 2011-11-02 | J7 | Futures | 0.015953 | 0.016035 | 0.015953 | 0.016012 | 227.0 |
> showing 50 of 98 rows — these rows as CSV