PREVIEW / futures_daily / 2018-06-06
file: by_date/futures_daily/2018/2018-06-06.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-06-06 | ES | Futures | 2991.62 | 3017.45 | 2988.36 | 3014.73 | 1326401.0 |
| 2018-06-06 | NQ | Futures | 8405.76 | 8453.16 | 8359.53 | 8444.68 | 300300.0 |
| 2018-06-06 | YM | Futures | 26153.8 | 26504.6 | 26137.0 | 26482.5 | 181641.0 |
| 2018-06-06 | CL | Futures | 65.94 | 66.39 | 64.69 | 65.15 | 708829.0 |
| 2018-06-06 | GC | Futures | 1660.4 | 1667.5 | 1656.7 | 1661.5 | 252054.0 |
| 2018-06-06 | ZN | Futures | 119.059385 | 119.074893 | 118.687179 | 118.733705 | 51286.0 |
| 2018-06-06 | A6 | Futures | 0.78321 | 0.78949 | 0.78311 | 0.78815 | 100595.0 |
| 2018-06-06 | AD | Futures | 0.78004 | 0.78707 | 0.78004 | 0.78161 | 109803.0 |
| 2018-06-06 | B | Futures | 55.06 | 55.84 | 54.52 | 55.18 | 365652.0 |
| 2018-06-06 | B6 | Futures | 1.3883 | 1.3929 | 1.3881 | 1.3894 | 107798.0 |
| 2018-06-06 | BR | Futures | 0.19721 | 0.19972 | 0.19656 | 0.19778 | 20.0 |
| 2018-06-06 | BTC | Futures | 10807.7 | 10935.6 | 10637.2 | 10715.3 | 1450.0 |
| 2018-06-06 | BZ | Futures | 54.47 | 55.32 | 54.02 | 54.67 | 37262.0 |
| 2018-06-06 | C | Futures | 1489.0 | 1514.0 | 1469.0 | 1498.0 | 14455.0 |
| 2018-06-06 | CB | Futures | 289.103 | 292.042 | 289.103 | 292.042 | 9.0 |
| 2018-06-06 | CC | Futures | 1689.0 | 1717.0 | 1668.0 | 1690.0 | 37279.0 |
| 2018-06-06 | CNH | Futures | 6.4744 | 6.4744 | 6.471 | 6.4724 | 33.0 |
| 2018-06-06 | CSC | Futures | 3.415 | 3.452 | 3.411 | 3.452 | 63.0 |
| 2018-06-06 | CT | Futures | 102.02 | 104.25 | 101.57 | 103.39 | 17261.0 |
| 2018-06-06 | DC | Futures | 27.38 | 27.86 | 27.38 | 27.79 | 111.0 |
| 2018-06-06 | DX | Futures | 88.471 | 88.527 | 88.074 | 88.309 | 25222.0 |
| 2018-06-06 | E1 | Futures | 1.22453 | 1.22562 | 1.21935 | 1.22272 | 23861.0 |
| 2018-06-06 | E6 | Futures | 1.32098 | 1.32988 | 1.32064 | 1.32678 | 328571.0 |
| 2018-06-06 | E7 | Futures | 1.314 | 1.3228 | 1.3137 | 1.3197 | 8210.0 |
| 2018-06-06 | EBM | Futures | 190.67 | 193.54 | 190.4 | 191.45 | 15447.0 |
| 2018-06-06 | ED | Futures | 94.9719 | 94.9743 | 94.967 | 94.9719 | 186613.0 |
| 2018-06-06 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.337 | 44395.0 |
| 2018-06-06 | EW | Futures | 2091.6 | 2109.2 | 2088.8 | 2107.2 | 10562.0 |
| 2018-06-06 | FBON | Futures | 128.35 | 128.35 | 126.89 | 127.27 | 869.0 |
| 2018-06-06 | FBTP | Futures | 106.25 | 106.85 | 104.83 | 105.28 | 182836.0 |
| 2018-06-06 | FBTS | Futures | 101.733 | 101.733 | 100.435 | 100.834 | 154175.0 |
| 2018-06-06 | FCE | Futures | 4909.4 | 4919.7 | 4860.4 | 4894.5 | 97961.0 |
| 2018-06-06 | FDAX | Futures | 13315.9 | 13403.2 | 13221.3 | 13334.6 | 106201.0 |
| 2018-06-06 | FDXM | Futures | 13196.3 | 13284.9 | 13103.6 | 13215.9 | 40714.0 |
| 2018-06-06 | FESX | Futures | 2882.2 | 2893.9 | 2855.6 | 2878.1 | 1406699.0 |
| 2018-06-06 | FGBL | Futures | 151.77 | 152.0 | 150.6 | 150.91 | 1529481.0 |
| 2018-06-06 | FGBM | Futures | 130.71 | 130.77 | 130.16 | 130.27 | 976778.0 |
| 2018-06-06 | FGBS | Futures | 112.729 | 112.729 | 112.618 | 112.628 | 816420.0 |
| 2018-06-06 | FGBX | Futures | 174.47 | 174.97 | 172.43 | 173.07 | 127414.0 |
| 2018-06-06 | FMWO | Futures | 7076.4 | 7116.1 | 7065.9 | 7085.7 | 20615.0 |
| 2018-06-06 | FOAT | Futures | 139.4 | 139.54 | 138.37 | 138.54 | 272628.0 |
| 2018-06-06 | FTDX | Futures | 2820.0 | 2829.4 | 2795.3 | 2813.6 | 113.0 |
| 2018-06-06 | FTI | Futures | 520.14 | 522.31 | 515.79 | 519.49 | 28528.0 |
| 2018-06-06 | FTUK | Futures | 6783.6 | 6832.2 | 6767.7 | 6806.1 | 153620.0 |
| 2018-06-06 | FVSA | Futures | 311.46 | 334.01 | 310.38 | 317.9 | 24209.0 |
| 2018-06-06 | FXXP | Futures | 334.6 | 335.6 | 332.0 | 334.2 | 32933.0 |
| 2018-06-06 | G | Futures | 115.1 | 115.1 | 114.29 | 114.38 | 259462.0 |
| 2018-06-06 | GF | Futures | 303.278 | 305.298 | 302.605 | 304.003 | 5498.0 |
| 2018-06-06 | GSCI | Futures | 528.72 | 530.85 | 527.88 | 529.17 | 617.0 |
| 2018-06-06 | HE | Futures | 79.072 | 82.098 | 79.046 | 82.021 | 27439.0 |
> showing 50 of 112 rows — these rows as CSV