PREVIEW / futures_daily / 2018-05-16
file: by_date/futures_daily/2018/2018-05-16.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-16 | ES | Futures | 2948.4 | 2966.61 | 2941.06 | 2961.18 | 1057687.0 |
| 2018-05-16 | NQ | Futures | 8070.72 | 8138.61 | 8047.31 | 8119.59 | 274261.0 |
| 2018-05-16 | YM | Futures | 25993.7 | 26101.2 | 25928.4 | 26061.1 | 137023.0 |
| 2018-05-16 | CL | Futures | 71.6 | 72.14 | 71.21 | 72.03 | 320924.0 |
| 2018-05-16 | GC | Futures | 1647.0 | 1655.1 | 1641.4 | 1648.8 | 333614.0 |
| 2018-05-16 | ZN | Futures | 117.787681 | 117.91175 | 117.555052 | 117.663612 | 1803123.0 |
| 2018-05-16 | A6 | Futures | 0.76841 | 0.77365 | 0.76584 | 0.77293 | 125878.0 |
| 2018-05-16 | AD | Futures | 0.78621 | 0.79234 | 0.78611 | 0.79168 | 79674.0 |
| 2018-05-16 | B | Futures | 57.23 | 58.15 | 56.87 | 58.1 | 336573.0 |
| 2018-05-16 | B6 | Futures | 1.4009 | 1.4023 | 1.3955 | 1.3985 | 110385.0 |
| 2018-05-16 | BFX | Futures | 4423.7 | 4429.5 | 4423.7 | 4429.5 | 3.0 |
| 2018-05-16 | BR | Futures | 0.20746 | 0.20788 | 0.20574 | 0.20658 | 3162.0 |
| 2018-05-16 | BTC | Futures | 11901.3 | 11999.6 | 11395.7 | 11585.3 | 4978.0 |
| 2018-05-16 | BZ | Futures | 56.67 | 57.54 | 56.31 | 57.5 | 31226.0 |
| 2018-05-16 | C | Futures | 1700.0 | 1730.0 | 1678.0 | 1724.0 | 10127.0 |
| 2018-05-16 | CB | Futures | 298.975 | 299.593 | 297.555 | 297.74 | 31.0 |
| 2018-05-16 | CC | Futures | 1932.0 | 1998.0 | 1917.0 | 1990.0 | 24203.0 |
| 2018-05-16 | CNH | Futures | 6.4678 | 6.4678 | 6.4461 | 6.4461 | 21.0 |
| 2018-05-16 | CSC | Futures | 3.58 | 3.584 | 3.526 | 3.547 | 115.0 |
| 2018-05-16 | CT | Futures | 95.35 | 97.07 | 95.07 | 95.89 | 15890.0 |
| 2018-05-16 | DC | Futures | 28.86 | 28.89 | 28.5 | 28.68 | 445.0 |
| 2018-05-16 | DX | Futures | 87.919 | 88.197 | 87.725 | 87.976 | 28237.0 |
| 2018-05-16 | E1 | Futures | 1.2061 | 1.20948 | 1.20526 | 1.2061 | 21748.0 |
| 2018-05-16 | E6 | Futures | 1.33686 | 1.33849 | 1.32819 | 1.33247 | 381691.0 |
| 2018-05-16 | E7 | Futures | 1.3296 | 1.3313 | 1.3212 | 1.3253 | 5311.0 |
| 2018-05-16 | EBM | Futures | 179.16 | 179.94 | 178.63 | 179.42 | 10006.0 |
| 2018-05-16 | ED | Futures | 95.0205 | 95.0254 | 94.9816 | 94.9913 | 447860.0 |
| 2018-05-16 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 69273.0 |
| 2018-05-16 | EW | Futures | 2047.4 | 2066.3 | 2043.0 | 2059.4 | 13738.0 |
| 2018-05-16 | FBON | Futures | 128.71 | 128.8 | 128.09 | 128.27 | 1203.0 |
| 2018-05-16 | FBTP | Futures | 113.89 | 113.92 | 112.43 | 112.57 | 332153.0 |
| 2018-05-16 | FBTS | Futures | 104.028 | 104.028 | 103.622 | 103.751 | 251076.0 |
| 2018-05-16 | FCE | Futures | 4936.3 | 4961.5 | 4922.8 | 4948.0 | 149736.0 |
| 2018-05-16 | FDAX | Futures | 13513.3 | 13546.1 | 13467.6 | 13503.5 | 94681.0 |
| 2018-05-16 | FDIV | Futures | 157.35 | 157.35 | 157.31 | 157.31 | 3.0 |
| 2018-05-16 | FDXM | Futures | 13391.0 | 13426.0 | 13347.7 | 13383.2 | 29488.0 |
| 2018-05-16 | FESX | Futures | 2942.2 | 2946.4 | 2928.1 | 2938.9 | 958293.0 |
| 2018-05-16 | FGBL | Futures | 148.59 | 149.16 | 148.53 | 148.85 | 1087206.0 |
| 2018-05-16 | FGBM | Futures | 129.26 | 129.56 | 129.26 | 129.43 | 583167.0 |
| 2018-05-16 | FGBS | Futures | 112.477 | 112.527 | 112.472 | 112.497 | 644147.0 |
| 2018-05-16 | FGBX | Futures | 167.39 | 168.63 | 167.26 | 167.88 | 72333.0 |
| 2018-05-16 | FMWO | Futures | 7049.5 | 7058.9 | 7032.0 | 7043.7 | 1625.0 |
| 2018-05-16 | FOAT | Futures | 137.79 | 138.15 | 137.73 | 137.89 | 192355.0 |
| 2018-05-16 | FTDX | Futures | 2745.8 | 2758.2 | 2738.4 | 2754.7 | 50.0 |
| 2018-05-16 | FTI | Futures | 518.89 | 522.03 | 518.61 | 520.6 | 31790.0 |
| 2018-05-16 | FTUK | Futures | 6797.7 | 6835.7 | 6793.3 | 6821.1 | 98312.0 |
| 2018-05-16 | FVSA | Futures | 300.72 | 308.24 | 296.42 | 308.24 | 39592.0 |
| 2018-05-16 | FXXP | Futures | 337.4 | 338.9 | 336.8 | 338.2 | 36105.0 |
| 2018-05-16 | G | Futures | 113.22 | 113.31 | 113.01 | 113.13 | 217722.0 |
| 2018-05-16 | GF | Futures | 286.084 | 287.741 | 282.873 | 283.235 | 7068.0 |
> showing 50 of 113 rows — these rows as CSV