PREVIEW / futures_daily / 2019-05-31
file: by_date/futures_daily/2019/2019-05-31.parquet size: 10 KB rows: 118
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-31 | ES | Futures | 3012.34 | 3014.77 | 2970.48 | 2973.18 | 2211587.0 |
| 2019-05-31 | NQ | Futures | 8355.5 | 8360.4 | 8214.36 | 8219.25 | 540433.0 |
| 2019-05-31 | YM | Futures | 26576.8 | 26590.5 | 26166.2 | 26198.9 | 276429.0 |
| 2019-05-31 | CL | Futures | 57.95 | 58.1 | 54.45 | 54.91 | 1031488.0 |
| 2019-05-31 | GC | Futures | 1609.5 | 1632.8 | 1608.7 | 1631.8 | 341175.0 |
| 2019-05-31 | ZN | Futures | 125.061736 | 125.807632 | 125.046197 | 125.683316 | 403790.0 |
| 2019-05-31 | A6 | Futures | 0.71281 | 0.71611 | 0.71168 | 0.7157 | 133458.0 |
| 2019-05-31 | AD | Futures | 0.74923 | 0.74953 | 0.74554 | 0.74796 | 123578.0 |
| 2019-05-31 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-31 | B | Futures | 48.28 | 48.32 | 45.7 | 46.14 | 511742.0 |
| 2019-05-31 | B6 | Futures | 1.292 | 1.2962 | 1.2874 | 1.2951 | 125356.0 |
| 2019-05-31 | BTC | Futures | 12784.9 | 13238.2 | 12516.0 | 13115.3 | 8559.0 |
| 2019-05-31 | BZ | Futures | 47.92 | 48.03 | 45.11 | 45.55 | 67969.0 |
| 2019-05-31 | C | Futures | 1748.0 | 1761.0 | 1727.0 | 1733.0 | 8825.0 |
| 2019-05-31 | CB | Futures | 282.993 | 283.576 | 282.993 | 283.576 | 12.0 |
| 2019-05-31 | CC | Futures | 1635.0 | 1646.0 | 1611.0 | 1616.0 | 15882.0 |
| 2019-05-31 | CNH | Futures | 6.9421 | 6.9556 | 6.9342 | 6.9427 | 1166.0 |
| 2019-05-31 | CSC | Futures | 2.986 | 3.011 | 2.986 | 3.01 | 16.0 |
| 2019-05-31 | CT | Futures | 72.73 | 72.95 | 71.18 | 71.26 | 13822.0 |
| 2019-05-31 | DC | Futures | 25.14 | 25.33 | 25.07 | 25.28 | 71.0 |
| 2019-05-31 | DX | Futures | 94.016 | 94.016 | 93.58 | 93.615 | 19068.0 |
| 2019-05-31 | E1 | Futures | 1.15921 | 1.16854 | 1.15921 | 1.16796 | 37368.0 |
| 2019-05-31 | E6 | Futures | 1.22312 | 1.22855 | 1.22252 | 1.22778 | 258132.0 |
| 2019-05-31 | E7 | Futures | 1.217 | 1.2223 | 1.2166 | 1.2217 | 3502.0 |
| 2019-05-31 | EBM | Futures | 213.61 | 214.19 | 211.02 | 213.32 | 23412.0 |
| 2019-05-31 | ED | Futures | 95.199 | 95.2576 | 95.199 | 95.238 | 609135.0 |
| 2019-05-31 | ER | Futures | 98.43 | 98.44 | 98.43 | 98.435 | 76163.0 |
| 2019-05-31 | EW | Futures | 1940.4 | 1940.7 | 1911.5 | 1921.0 | 15719.0 |
| 2019-05-31 | FBON | Futures | 139.19 | 139.79 | 139.06 | 139.66 | 1213.0 |
| 2019-05-31 | FBTP | Futures | 115.28 | 115.61 | 114.37 | 115.34 | 242905.0 |
| 2019-05-31 | FBTS | Futures | 105.684 | 105.684 | 105.274 | 105.598 | 164160.0 |
| 2019-05-31 | FCE | Futures | 4706.7 | 4714.5 | 4665.9 | 4708.6 | 107670.0 |
| 2019-05-31 | FDAX | Futures | 12475.3 | 12475.3 | 12271.7 | 12343.2 | 141139.0 |
| 2019-05-31 | FDIV | Futures | 140.57 | 140.66 | 140.15 | 140.48 | 102.0 |
| 2019-05-31 | FDXM | Futures | 12376.1 | 12376.1 | 12165.3 | 12236.3 | 59363.0 |
| 2019-05-31 | FESX | Futures | 2879.7 | 2879.7 | 2841.3 | 2862.3 | 1265949.0 |
| 2019-05-31 | FGBL | Futures | 162.46 | 162.75 | 162.43 | 162.47 | 1330914.0 |
| 2019-05-31 | FGBM | Futures | 133.94 | 134.06 | 133.93 | 133.95 | 1117209.0 |
| 2019-05-31 | FGBS | Futures | 112.91 | 112.965 | 112.91 | 112.93 | 975415.0 |
| 2019-05-31 | FGBX | Futures | 201.09 | 202.59 | 201.07 | 201.87 | 97566.0 |
| 2019-05-31 | FMWO | Futures | 6885.2 | 6904.9 | 6863.2 | 6904.9 | 1235.0 |
| 2019-05-31 | FOAT | Futures | 148.73 | 148.89 | 148.58 | 148.85 | 226214.0 |
| 2019-05-31 | FTDX | Futures | 2726.9 | 2726.9 | 2674.6 | 2710.1 | 238.0 |
| 2019-05-31 | FTI | Futures | 509.61 | 510.5 | 506.92 | 509.82 | 32759.0 |
| 2019-05-31 | FTUK | Futures | 6585.8 | 6594.5 | 6530.7 | 6558.3 | 118894.0 |
| 2019-05-31 | FVSA | Futures | 242.36 | 253.05 | 241.65 | 243.07 | 38449.0 |
| 2019-05-31 | FXXP | Futures | 330.1 | 330.3 | 327.4 | 329.7 | 69286.0 |
| 2019-05-31 | G | Futures | 119.53 | 119.67 | 119.19 | 119.22 | 254330.0 |
| 2019-05-31 | GF | Futures | 270.86 | 272.724 | 259.331 | 261.244 | 11222.0 |
| 2019-05-31 | GSCI | Futures | 470.2 | 470.88 | 459.28 | 461.2 | 73.0 |
> showing 50 of 118 rows — these rows as CSV