PREVIEW / futures_daily / 2015-06-02
file: by_date/futures_daily/2015/2015-06-02.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 |
|---|---|---|---|---|---|---|---|
| 2015-06-02 | ES | Futures | 2219.64 | 2224.89 | 2201.76 | 2215.17 | 1442814.0 |
| 2015-06-02 | NQ | Futures | 5254.54 | 5261.51 | 5202.3 | 5228.13 | 222449.0 |
| 2015-06-02 | YM | Futures | 18454.4 | 18498.4 | 18314.3 | 18412.5 | 168133.0 |
| 2015-06-02 | CL | Futures | 101.13 | 103.49 | 100.98 | 102.95 | 344508.0 |
| 2015-06-02 | GC | Futures | 1553.5 | 1562.5 | 1548.6 | 1559.9 | 111471.0 |
| 2015-06-02 | ZN | Futures | 120.946949 | 120.946949 | 120.206941 | 120.295742 | 146453.0 |
| 2015-06-02 | A6 | Futures | 0.74974 | 0.76779 | 0.74974 | 0.7669 | 123543.0 |
| 2015-06-02 | AD | Futures | 0.81485 | 0.82537 | 0.81434 | 0.82312 | 75116.0 |
| 2015-06-02 | ALI | Futures | 2369.92 | 2369.92 | 2369.92 | 2369.92 | 0.0 |
| 2015-06-02 | B | Futures | 61.48 | 62.56 | 61.41 | 62.28 | 169533.0 |
| 2015-06-02 | B6 | Futures | 1.5992 | 1.6175 | 1.5977 | 1.6155 | 108618.0 |
| 2015-06-02 | BFX | Futures | 4481.4 | 4481.4 | 4462.6 | 4462.6 | 8.0 |
| 2015-06-02 | BR | Futures | 0.18644 | 0.18644 | 0.18557 | 0.18557 | 40.0 |
| 2015-06-02 | BZ | Futures | 61.86 | 62.67 | 61.54 | 62.41 | 11271.0 |
| 2015-06-02 | C | Futures | 2262.0 | 2285.0 | 2260.0 | 2281.0 | 6391.0 |
| 2015-06-02 | CB | Futures | 168.578 | 168.578 | 164.526 | 164.526 | 102.0 |
| 2015-06-02 | CC | Futures | 2262.0 | 2306.0 | 2262.0 | 2296.0 | 22747.0 |
| 2015-06-02 | CNH | Futures | 6.9726 | 6.9726 | 6.9693 | 6.9693 | 1.0 |
| 2015-06-02 | CSC | Futures | 4.685 | 4.698 | 4.614 | 4.614 | 62.0 |
| 2015-06-02 | CT | Futures | 80.12 | 80.99 | 79.78 | 80.12 | 14451.0 |
| 2015-06-02 | DC | Futures | 38.37 | 38.55 | 37.71 | 37.84 | 147.0 |
| 2015-06-02 | DX | Futures | 91.578 | 91.653 | 89.869 | 90.027 | 86878.0 |
| 2015-06-02 | E1 | Futures | 1.34731 | 1.36974 | 1.34731 | 1.36744 | 27792.0 |
| 2015-06-02 | E6 | Futures | 1.28458 | 1.3168 | 1.28388 | 1.31339 | 410264.0 |
| 2015-06-02 | E7 | Futures | 1.2772 | 1.3092 | 1.2766 | 1.3058 | 10666.0 |
| 2015-06-02 | EBM | Futures | 298.4 | 300.45 | 293.48 | 299.22 | 12154.0 |
| 2015-06-02 | ED | Futures | 95.5597 | 95.5645 | 95.5573 | 95.5621 | 142601.0 |
| 2015-06-02 | ER | Futures | 98.068 | 98.077 | 98.068 | 98.073 | 38243.0 |
| 2015-06-02 | EW | Futures | 1601.1 | 1606.5 | 1587.0 | 1601.2 | 13365.0 |
| 2015-06-02 | FBTP | Futures | 98.86 | 98.97 | 97.64 | 97.89 | 218437.0 |
| 2015-06-02 | FBTS | Futures | 99.723 | 99.741 | 99.652 | 99.697 | 27125.0 |
| 2015-06-02 | FCE | Futures | 4173.9 | 4183.5 | 4106.2 | 4143.6 | 109163.0 |
| 2015-06-02 | FDAX | Futures | 12723.3 | 12744.9 | 12501.4 | 12573.0 | 113420.0 |
| 2015-06-02 | FDIV | Futures | 153.07 | 153.57 | 153.07 | 153.57 | 48.0 |
| 2015-06-02 | FESX | Futures | 2641.6 | 2648.3 | 2597.4 | 2621.7 | 1167239.0 |
| 2015-06-02 | FGBL | Futures | 137.57 | 137.68 | 135.69 | 136.04 | 1679602.0 |
| 2015-06-02 | FGBM | Futures | 124.11 | 124.19 | 123.75 | 123.83 | 1283279.0 |
| 2015-06-02 | FGBS | Futures | 111.183 | 111.203 | 111.143 | 111.158 | 606625.0 |
| 2015-06-02 | FGBX | Futures | 162.64 | 163.05 | 157.11 | 158.56 | 82558.0 |
| 2015-06-02 | FMWO | Futures | 5886.5 | 5900.1 | 5870.5 | 5891.5 | 186.0 |
| 2015-06-02 | FOAT | Futures | 126.25 | 126.27 | 124.44 | 124.79 | 172234.0 |
| 2015-06-02 | FTDX | Futures | 1592.7 | 1599.2 | 1578.6 | 1587.0 | 161.0 |
| 2015-06-02 | FTI | Futures | 430.32 | 430.71 | 423.13 | 424.27 | 43925.0 |
| 2015-06-02 | FTUK | Futures | 5479.5 | 5489.3 | 5405.8 | 5449.9 | 132331.0 |
| 2015-06-02 | FVSA | Futures | 1747.15 | 1778.07 | 1727.82 | 1735.55 | 13789.0 |
| 2015-06-02 | FXXP | Futures | 307.4 | 307.9 | 303.2 | 303.9 | 16486.0 |
| 2015-06-02 | G | Futures | 102.69 | 102.69 | 101.62 | 101.95 | 257917.0 |
| 2015-06-02 | GF | Futures | 380.716 | 381.141 | 377.23 | 379.695 | 3090.0 |
| 2015-06-02 | GSCI | Futures | 747.62 | 755.02 | 746.77 | 754.42 | 326.0 |
| 2015-06-02 | HE | Futures | 91.504 | 91.83 | 90.416 | 91.15 | 14151.0 |
> showing 50 of 107 rows — these rows as CSV