PREVIEW / futures_daily / 2018-05-11
file: by_date/futures_daily/2018/2018-05-11.parquet size: 10 KB rows: 112
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-11 | ES | Futures | 2953.84 | 2971.51 | 2953.84 | 2968.24 | 1066248.0 |
| 2018-05-11 | NQ | Futures | 8133.93 | 8169.04 | 8109.05 | 8146.22 | 263016.0 |
| 2018-05-11 | YM | Futures | 25994.8 | 26173.9 | 25992.7 | 26148.6 | 146145.0 |
| 2018-05-11 | CL | Futures | 71.71 | 71.89 | 70.71 | 70.96 | 634145.0 |
| 2018-05-11 | GC | Futures | 1687.5 | 1693.3 | 1681.4 | 1686.1 | 263471.0 |
| 2018-05-11 | ZN | Futures | 118.532093 | 118.640653 | 118.423533 | 118.516584 | 1018534.0 |
| 2018-05-11 | A6 | Futures | 0.77468 | 0.77807 | 0.77345 | 0.77571 | 93567.0 |
| 2018-05-11 | AD | Futures | 0.79284 | 0.79537 | 0.79087 | 0.79163 | 73645.0 |
| 2018-05-11 | B | Futures | 56.83 | 56.87 | 56.39 | 56.52 | 261802.0 |
| 2018-05-11 | B6 | Futures | 1.4022 | 1.4102 | 1.4004 | 1.4051 | 103459.0 |
| 2018-05-11 | BR | Futures | 0.215 | 0.2153 | 0.2105 | 0.21127 | 5481.0 |
| 2018-05-11 | BTC | Futures | 12793.0 | 12814.1 | 11767.9 | 12111.9 | 4980.0 |
| 2018-05-11 | BZ | Futures | 56.15 | 56.28 | 55.81 | 55.94 | 25651.0 |
| 2018-05-11 | C | Futures | 1748.0 | 1781.0 | 1740.0 | 1771.0 | 8068.0 |
| 2018-05-11 | CB | Futures | 296.752 | 296.752 | 294.868 | 295.269 | 19.0 |
| 2018-05-11 | CC | Futures | 2003.0 | 2079.0 | 2003.0 | 2045.0 | 19431.0 |
| 2018-05-11 | CNH | Futures | 6.4367 | 6.4367 | 6.4193 | 6.431 | 22.0 |
| 2018-05-11 | CSC | Futures | 3.536 | 3.544 | 3.517 | 3.532 | 68.0 |
| 2018-05-11 | CT | Futures | 96.12 | 96.58 | 94.92 | 96.19 | 19111.0 |
| 2018-05-11 | DC | Futures | 28.46 | 28.52 | 28.34 | 28.39 | 290.0 |
| 2018-05-11 | DX | Futures | 87.339 | 87.438 | 86.99 | 87.156 | 20262.0 |
| 2018-05-11 | E1 | Futures | 1.20394 | 1.21068 | 1.20297 | 1.20659 | 23817.0 |
| 2018-05-11 | E6 | Futures | 1.34576 | 1.35151 | 1.34289 | 1.34875 | 223015.0 |
| 2018-05-11 | E7 | Futures | 1.3386 | 1.3444 | 1.3358 | 1.3416 | 3536.0 |
| 2018-05-11 | EBM | Futures | 180.47 | 180.47 | 179.42 | 179.68 | 11377.0 |
| 2018-05-11 | ED | Futures | 94.9549 | 94.9986 | 94.95 | 94.9938 | 482208.0 |
| 2018-05-11 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.337 | 97100.0 |
| 2018-05-11 | EW | Futures | 2051.6 | 2060.8 | 2048.1 | 2053.8 | 11632.0 |
| 2018-05-11 | FBON | Futures | 129.18 | 129.81 | 129.18 | 129.5 | 541.0 |
| 2018-05-11 | FBTP | Futures | 114.42 | 115.09 | 114.42 | 114.83 | 133892.0 |
| 2018-05-11 | FBTS | Futures | 104.121 | 104.223 | 104.112 | 104.195 | 73095.0 |
| 2018-05-11 | FCE | Futures | 4934.1 | 4941.2 | 4919.0 | 4938.6 | 63532.0 |
| 2018-05-11 | FDAX | Futures | 13565.3 | 13565.3 | 13470.2 | 13510.7 | 73122.0 |
| 2018-05-11 | FDXM | Futures | 13439.4 | 13439.4 | 13349.8 | 13390.4 | 23081.0 |
| 2018-05-11 | FESX | Futures | 2948.0 | 2948.9 | 2932.2 | 2940.6 | 630917.0 |
| 2018-05-11 | FGBL | Futures | 149.55 | 149.78 | 149.43 | 149.48 | 421439.0 |
| 2018-05-11 | FGBM | Futures | 129.66 | 129.73 | 129.6 | 129.61 | 247062.0 |
| 2018-05-11 | FGBS | Futures | 112.522 | 112.532 | 112.507 | 112.512 | 171985.0 |
| 2018-05-11 | FGBX | Futures | 169.52 | 170.0 | 169.23 | 169.35 | 41593.0 |
| 2018-05-11 | FMWO | Futures | 7067.1 | 7096.3 | 7067.1 | 7085.7 | 2872.0 |
| 2018-05-11 | FOAT | Futures | 138.56 | 138.81 | 138.55 | 138.62 | 69701.0 |
| 2018-05-11 | FTDX | Futures | 2767.6 | 2767.6 | 2745.3 | 2752.2 | 323.0 |
| 2018-05-11 | FTI | Futures | 517.18 | 518.34 | 516.21 | 517.73 | 1217.0 |
| 2018-05-11 | FTUK | Futures | 6794.6 | 6809.2 | 6774.7 | 6807.4 | 108330.0 |
| 2018-05-11 | FVSA | Futures | 309.98 | 309.98 | 297.35 | 299.64 | 16601.0 |
| 2018-05-11 | FXXP | Futures | 337.1 | 337.5 | 336.3 | 337.2 | 29839.0 |
| 2018-05-11 | G | Futures | 113.86 | 113.92 | 113.58 | 113.64 | 159320.0 |
| 2018-05-11 | GF | Futures | 298.306 | 298.72 | 295.354 | 298.099 | 5211.0 |
| 2018-05-11 | GSCI | Futures | 545.27 | 545.27 | 543.14 | 543.36 | 2139.0 |
| 2018-05-11 | HE | Futures | 81.27 | 81.401 | 78.696 | 78.906 | 29031.0 |
> showing 50 of 112 rows — these rows as CSV