PREVIEW / futures_daily / 2018-05-14
file: by_date/futures_daily/2018/2018-05-14.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-14 | ES | Futures | 2965.8 | 2981.02 | 2962.53 | 2969.88 | 945963.0 |
| 2018-05-14 | NQ | Futures | 8144.17 | 8208.83 | 8140.95 | 8162.6 | 255900.0 |
| 2018-05-14 | YM | Futures | 26135.9 | 26304.5 | 26135.9 | 26214.9 | 134517.0 |
| 2018-05-14 | CL | Futures | 70.96 | 71.7 | 70.7 | 71.45 | 243623.0 |
| 2018-05-14 | GC | Futures | 1683.0 | 1688.3 | 1676.0 | 1682.9 | 241225.0 |
| 2018-05-14 | ZN | Futures | 118.485567 | 118.594127 | 118.252939 | 118.361499 | 924286.0 |
| 2018-05-14 | A6 | Futures | 0.77561 | 0.77787 | 0.77375 | 0.77396 | 80806.0 |
| 2018-05-14 | AD | Futures | 0.79168 | 0.794 | 0.78996 | 0.79092 | 46230.0 |
| 2018-05-14 | B | Futures | 56.46 | 57.55 | 56.1 | 57.33 | 290126.0 |
| 2018-05-14 | B6 | Futures | 1.405 | 1.4114 | 1.4043 | 1.4069 | 76872.0 |
| 2018-05-14 | BR | Futures | 0.2118 | 0.21283 | 0.20894 | 0.21005 | 3025.0 |
| 2018-05-14 | BTC | Futures | 12161.1 | 12498.1 | 11634.5 | 12294.5 | 5754.0 |
| 2018-05-14 | BZ | Futures | 55.92 | 56.95 | 55.52 | 56.74 | 29917.0 |
| 2018-05-14 | C | Futures | 1770.0 | 1781.0 | 1736.0 | 1753.0 | 14732.0 |
| 2018-05-14 | CB | Futures | 296.504 | 296.504 | 296.504 | 296.504 | 6.0 |
| 2018-05-14 | CC | Futures | 2046.0 | 2077.0 | 2014.0 | 2026.0 | 13136.0 |
| 2018-05-14 | CNH | Futures | 6.4247 | 6.4326 | 6.4247 | 6.4326 | 31.0 |
| 2018-05-14 | CSC | Futures | 3.563 | 3.578 | 3.549 | 3.578 | 71.0 |
| 2018-05-14 | CT | Futures | 96.28 | 96.51 | 94.92 | 95.15 | 15145.0 |
| 2018-05-14 | DC | Futures | 28.5 | 28.84 | 28.46 | 28.8 | 397.0 |
| 2018-05-14 | DX | Futures | 87.169 | 87.287 | 86.877 | 87.204 | 17871.0 |
| 2018-05-14 | E1 | Futures | 1.20743 | 1.21273 | 1.20659 | 1.20755 | 24580.0 |
| 2018-05-14 | E6 | Futures | 1.34937 | 1.35466 | 1.34661 | 1.34863 | 201921.0 |
| 2018-05-14 | E7 | Futures | 1.3419 | 1.3473 | 1.3395 | 1.3415 | 3084.0 |
| 2018-05-14 | EBM | Futures | 179.16 | 179.16 | 177.85 | 178.37 | 12077.0 |
| 2018-05-14 | ED | Futures | 94.9938 | 95.0302 | 94.9913 | 95.0181 | 522274.0 |
| 2018-05-14 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.332 | 116263.0 |
| 2018-05-14 | EW | Futures | 2053.9 | 2063.1 | 2046.9 | 2050.4 | 12350.0 |
| 2018-05-14 | FBON | Futures | 129.73 | 129.73 | 129.06 | 129.08 | 478.0 |
| 2018-05-14 | FBTP | Futures | 115.15 | 115.19 | 114.35 | 114.53 | 84384.0 |
| 2018-05-14 | FBTS | Futures | 104.213 | 104.213 | 104.121 | 104.139 | 42166.0 |
| 2018-05-14 | FCE | Futures | 4938.6 | 4938.6 | 4909.4 | 4923.3 | 105535.0 |
| 2018-05-14 | FDAX | Futures | 13542.9 | 13544.0 | 13431.2 | 13488.4 | 70489.0 |
| 2018-05-14 | FDXM | Futures | 13414.6 | 13423.9 | 13311.7 | 13368.3 | 24198.0 |
| 2018-05-14 | FESX | Futures | 2947.2 | 2947.2 | 2929.7 | 2940.6 | 692949.0 |
| 2018-05-14 | FGBL | Futures | 149.61 | 149.64 | 148.8 | 148.82 | 747329.0 |
| 2018-05-14 | FGBM | Futures | 129.64 | 129.66 | 129.32 | 129.34 | 465590.0 |
| 2018-05-14 | FGBS | Futures | 112.517 | 112.527 | 112.457 | 112.462 | 426163.0 |
| 2018-05-14 | FGBX | Futures | 169.62 | 169.73 | 168.11 | 168.15 | 48028.0 |
| 2018-05-14 | FMWO | Futures | 7207.2 | 7207.2 | 7105.6 | 7110.3 | 3511.0 |
| 2018-05-14 | FOAT | Futures | 138.72 | 138.77 | 138.03 | 138.06 | 131771.0 |
| 2018-05-14 | FTDX | Futures | 2756.7 | 2756.7 | 2729.0 | 2740.9 | 388.0 |
| 2018-05-14 | FTI | Futures | 518.29 | 519.03 | 517.09 | 518.94 | 9974.0 |
| 2018-05-14 | FTUK | Futures | 6810.1 | 6810.1 | 6771.2 | 6791.5 | 82154.0 |
| 2018-05-14 | FVSA | Futures | 299.64 | 302.87 | 293.2 | 298.57 | 35690.0 |
| 2018-05-14 | FXXP | Futures | 337.7 | 337.7 | 335.8 | 336.9 | 38376.0 |
| 2018-05-14 | G | Futures | 113.65 | 113.7 | 113.22 | 113.33 | 185313.0 |
| 2018-05-14 | GF | Futures | 294.94 | 296.235 | 290.227 | 290.797 | 6861.0 |
| 2018-05-14 | GSCI | Futures | 545.22 | 547.18 | 545.22 | 546.79 | 807.0 |
| 2018-05-14 | HE | Futures | 79.353 | 80.377 | 79.169 | 80.009 | 17095.0 |
> showing 50 of 113 rows — these rows as CSV