PREVIEW / futures_daily / 2018-06-11
file: by_date/futures_daily/2018/2018-06-11.parquet size: 9 KB rows: 110
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-11 | ES | Futures | 3013.37 | 3034.58 | 3012.83 | 3026.42 | 1218834.0 |
| 2018-06-11 | NQ | Futures | 8351.04 | 8414.25 | 8339.34 | 8392.3 | 173772.0 |
| 2018-06-11 | YM | Futures | 26658.4 | 26782.8 | 26613.1 | 26709.0 | 145524.0 |
| 2018-06-11 | CL | Futures | 65.99 | 66.78 | 65.27 | 66.53 | 558281.0 |
| 2018-06-11 | GC | Futures | 1664.2 | 1668.6 | 1656.9 | 1663.8 | 211583.0 |
| 2018-06-11 | ZN | Futures | 118.904056 | 118.950673 | 118.686511 | 118.779744 | 1175545.0 |
| 2018-06-11 | A6 | Futures | 0.78157 | 0.78445 | 0.78136 | 0.7826 | 14251.0 |
| 2018-06-11 | AD | Futures | 0.78227 | 0.78338 | 0.77903 | 0.78146 | 19716.0 |
| 2018-06-11 | B | Futures | 55.87 | 56.27 | 55.3 | 55.99 | 231283.0 |
| 2018-06-11 | B6 | Futures | 1.3895 | 1.3931 | 1.3832 | 1.3867 | 37180.0 |
| 2018-06-11 | BR | Futures | 0.20551 | 0.20551 | 0.20117 | 0.20266 | 274.0 |
| 2018-06-11 | BTC | Futures | 10118.5 | 10118.5 | 9393.7 | 9592.6 | 3861.0 |
| 2018-06-11 | BZ | Futures | 55.41 | 55.73 | 54.79 | 55.47 | 22516.0 |
| 2018-06-11 | C | Futures | 1528.0 | 1529.0 | 1479.0 | 1525.0 | 7568.0 |
| 2018-06-11 | CB | Futures | 293.841 | 293.871 | 293.061 | 293.061 | 5.0 |
| 2018-06-11 | CC | Futures | 1720.0 | 1733.0 | 1684.0 | 1726.0 | 35552.0 |
| 2018-06-11 | CNH | Futures | 6.4902 | 6.4934 | 6.4867 | 6.4899 | 73.0 |
| 2018-06-11 | CSC | Futures | 3.486 | 3.494 | 3.466 | 3.466 | 32.0 |
| 2018-06-11 | CT | Futures | 108.62 | 109.7 | 106.85 | 107.71 | 22047.0 |
| 2018-06-11 | DC | Futures | 28.09 | 28.16 | 27.96 | 28.01 | 25.0 |
| 2018-06-11 | DX | Futures | 88.218 | 88.322 | 88.0 | 88.237 | 7781.0 |
| 2018-06-11 | E1 | Futures | 1.22333 | 1.22464 | 1.2207 | 1.22357 | 10228.0 |
| 2018-06-11 | E6 | Futures | 1.32667 | 1.33192 | 1.32639 | 1.32818 | 65357.0 |
| 2018-06-11 | E7 | Futures | 1.3196 | 1.325 | 1.3196 | 1.3214 | 923.0 |
| 2018-06-11 | EBM | Futures | 190.67 | 191.71 | 189.1 | 189.36 | 9237.0 |
| 2018-06-11 | ED | Futures | 94.9718 | 94.9718 | 94.9523 | 94.9621 | 138995.0 |
| 2018-06-11 | ER | Futures | 98.332 | 98.347 | 98.332 | 98.342 | 103802.0 |
| 2018-06-11 | EW | Futures | 2119.8 | 2130.8 | 2117.2 | 2123.8 | 50085.0 |
| 2018-06-11 | FBON | Futures | 128.39 | 128.49 | 127.59 | 127.78 | 393.0 |
| 2018-06-11 | FBTP | Futures | 103.96 | 106.23 | 103.96 | 105.84 | 105363.0 |
| 2018-06-11 | FBTS | Futures | 100.63 | 101.845 | 100.63 | 101.743 | 62851.0 |
| 2018-06-11 | FCE | Futures | 4896.3 | 4940.4 | 4886.0 | 4918.8 | 157912.0 |
| 2018-06-11 | FDAX | Futures | 13253.6 | 13398.5 | 13238.5 | 13351.8 | 137784.0 |
| 2018-06-11 | FDXM | Futures | 13135.0 | 13286.7 | 13131.9 | 13240.3 | 1565.0 |
| 2018-06-11 | FESX | Futures | 2865.6 | 2907.3 | 2862.2 | 2899.8 | 1227934.0 |
| 2018-06-11 | FGBL | Futures | 150.97 | 150.97 | 150.34 | 150.52 | 623118.0 |
| 2018-06-11 | FGBM | Futures | 130.39 | 130.4 | 130.08 | 130.14 | 407846.0 |
| 2018-06-11 | FGBS | Futures | 112.729 | 112.729 | 112.623 | 112.628 | 360671.0 |
| 2018-06-11 | FGBX | Futures | 173.05 | 173.25 | 171.35 | 171.79 | 57872.0 |
| 2018-06-11 | FMWO | Futures | 7132.5 | 7147.6 | 7120.8 | 7139.5 | 9272.0 |
| 2018-06-11 | FOAT | Futures | 138.27 | 138.42 | 137.86 | 138.0 | 119045.0 |
| 2018-06-11 | FTDX | Futures | 2773.0 | 2787.2 | 2773.0 | 2787.2 | 516.0 |
| 2018-06-11 | FTI | Futures | 517.55 | 523.6 | 517.32 | 521.01 | 7641.0 |
| 2018-06-11 | FTUK | Futures | 6785.3 | 6859.3 | 6785.3 | 6839.7 | 244301.0 |
| 2018-06-11 | FVSA | Futures | 316.83 | 316.83 | 294.27 | 296.42 | 22987.0 |
| 2018-06-11 | FXXP | Futures | 332.6 | 335.0 | 332.3 | 333.9 | 170874.0 |
| 2018-06-11 | G | Futures | 113.95 | 114.28 | 113.9 | 114.16 | 154130.0 |
| 2018-06-11 | GF | Futures | 306.178 | 307.473 | 301.051 | 302.346 | 6137.0 |
| 2018-06-11 | GSCI | Futures | 534.33 | 534.72 | 532.53 | 533.49 | 2505.0 |
| 2018-06-11 | HE | Futures | 83.099 | 83.74 | 80.662 | 81.457 | 26819.0 |
> showing 50 of 110 rows — these rows as CSV