PREVIEW / futures_daily / 2014-10-02
file: by_date/futures_daily/2014/2014-10-02.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-02 | ES | Futures | 2027.28 | 2032.5 | 2003.78 | 2024.93 | 2721573.0 |
| 2014-10-02 | NQ | Futures | 4614.46 | 4630.11 | 4552.17 | 4610.41 | 439789.0 |
| 2014-10-02 | YM | Futures | 16977.0 | 17018.6 | 16829.9 | 16966.9 | 227010.0 |
| 2014-10-02 | CL | Futures | 170.93 | 172.43 | 166.11 | 171.44 | 449554.0 |
| 2014-10-02 | GC | Futures | 1591.6 | 1605.5 | 1585.9 | 1593.8 | 148824.0 |
| 2014-10-02 | ZN | Futures | 117.733991 | 117.821852 | 117.39719 | 117.441121 | 1771636.0 |
| 2014-10-02 | A6 | Futures | 0.8442 | 0.85353 | 0.844 | 0.85129 | 151496.0 |
| 2014-10-02 | AD | Futures | 0.90818 | 0.9159 | 0.90717 | 0.90879 | 80737.0 |
| 2014-10-02 | ALI | Futures | 2872.21 | 2872.21 | 2872.21 | 2872.21 | 0.0 |
| 2014-10-02 | B | Futures | 98.42 | 98.6 | 95.69 | 97.57 | 208983.0 |
| 2014-10-02 | B6 | Futures | 1.6999 | 1.707 | 1.6925 | 1.6961 | 122894.0 |
| 2014-10-02 | BFX | Futures | 3862.5 | 3862.5 | 3785.8 | 3785.8 | 46.0 |
| 2014-10-02 | BR | Futures | 0.21463 | 0.21499 | 0.21285 | 0.21434 | 720.0 |
| 2014-10-02 | BZ | Futures | 99.2 | 99.28 | 96.44 | 98.29 | 27585.0 |
| 2014-10-02 | C | Futures | 2159.0 | 2188.0 | 2120.0 | 2123.0 | 11420.0 |
| 2014-10-02 | CB | Futures | 135.849 | 141.36 | 135.849 | 141.36 | 8.0 |
| 2014-10-02 | CC | Futures | 2333.0 | 2340.0 | 2274.0 | 2281.0 | 20211.0 |
| 2014-10-02 | CNH | Futures | 7.0989 | 7.0989 | 7.0938 | 7.094 | 1.0 |
| 2014-10-02 | CSC | Futures | 5.148 | 5.174 | 5.114 | 5.174 | 18.0 |
| 2014-10-02 | CT | Futures | 78.83 | 79.27 | 77.61 | 78.37 | 9883.0 |
| 2014-10-02 | DC | Futures | 41.11 | 41.53 | 40.93 | 41.41 | 244.0 |
| 2014-10-02 | DX | Futures | 81.604 | 81.656 | 81.205 | 81.343 | 53062.0 |
| 2014-10-02 | E1 | Futures | 1.33747 | 1.34438 | 1.33543 | 1.34156 | 50842.0 |
| 2014-10-02 | E6 | Futures | 1.4861 | 1.49552 | 1.48551 | 1.49269 | 354219.0 |
| 2014-10-02 | E7 | Futures | 1.4772 | 1.4861 | 1.4763 | 1.4833 | 3972.0 |
| 2014-10-02 | ED | Futures | 95.4422 | 95.447 | 95.4374 | 95.4422 | 147925.0 |
| 2014-10-02 | ER | Futures | 98.019 | 98.023 | 98.014 | 98.014 | 61148.0 |
| 2014-10-02 | EW | Futures | 1405.5 | 1411.9 | 1386.9 | 1406.8 | 27858.0 |
| 2014-10-02 | FBTP | Futures | 95.83 | 95.87 | 95.21 | 95.41 | 98869.0 |
| 2014-10-02 | FBTS | Futures | 98.766 | 98.774 | 98.677 | 98.703 | 13457.0 |
| 2014-10-02 | FCE | Futures | 3464.3 | 3481.0 | 3368.7 | 3377.5 | 176654.0 |
| 2014-10-02 | FDAX | Futures | 10261.1 | 10314.7 | 10040.9 | 10095.7 | 177502.0 |
| 2014-10-02 | FESX | Futures | 2299.2 | 2309.3 | 2236.1 | 2247.0 | 1886965.0 |
| 2014-10-02 | FEU3 | Futures | 98.636 | 98.641 | 98.636 | 98.641 | 1.0 |
| 2014-10-02 | FGBL | Futures | 132.44 | 132.45 | 132.01 | 132.25 | 895834.0 |
| 2014-10-02 | FGBM | Futures | 123.11 | 123.12 | 122.9 | 123.0 | 478130.0 |
| 2014-10-02 | FGBS | Futures | 110.968 | 110.978 | 110.938 | 110.953 | 202252.0 |
| 2014-10-02 | FGBX | Futures | 143.37 | 143.55 | 142.39 | 143.07 | 29687.0 |
| 2014-10-02 | FMWO | Futures | 5563.3 | 5572.1 | 5504.4 | 5505.6 | 319.0 |
| 2014-10-02 | FOAT | Futures | 122.16 | 122.16 | 121.65 | 121.88 | 116761.0 |
| 2014-10-02 | FTDX | Futures | 1170.0 | 1170.0 | 1150.2 | 1150.2 | 247.0 |
| 2014-10-02 | FTI | Futures | 358.93 | 359.23 | 349.94 | 350.85 | 58925.0 |
| 2014-10-02 | FTUK | Futures | 5034.3 | 5050.1 | 4946.5 | 4971.6 | 156647.0 |
| 2014-10-02 | FVSA | Futures | 1538.57 | 1599.46 | 1506.09 | 1599.46 | 19002.0 |
| 2014-10-02 | FXXP | Futures | 256.6 | 256.9 | 250.4 | 251.6 | 13062.0 |
| 2014-10-02 | G | Futures | 97.48 | 97.84 | 97.42 | 97.66 | 179392.0 |
| 2014-10-02 | GF | Futures | 372.602 | 375.597 | 372.33 | 375.091 | 2686.0 |
| 2014-10-02 | GSCI | Futures | 954.24 | 962.65 | 951.38 | 961.98 | 299.0 |
| 2014-10-02 | HE | Futures | 127.356 | 128.399 | 126.01 | 127.76 | 13985.0 |
| 2014-10-02 | HG | Futures | 3.8369 | 3.8553 | 3.7868 | 3.8033 | 50418.0 |
> showing 50 of 106 rows — these rows as CSV