PREVIEW / futures_daily / 2018-06-01
file: by_date/futures_daily/2018/2018-06-01.parquet size: 10 KB rows: 116
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-01 | ES | Futures | 2944.32 | 2976.4 | 2942.69 | 2972.87 | 1241171.0 |
| 2018-06-01 | NQ | Futures | 8172.55 | 8298.96 | 8166.41 | 8290.18 | 335020.0 |
| 2018-06-01 | YM | Futures | 25745.1 | 25996.9 | 25723.0 | 25944.2 | 180922.0 |
| 2018-06-01 | CL | Futures | 67.51 | 67.78 | 65.94 | 66.24 | 781103.0 |
| 2018-06-01 | GC | Futures | 1663.5 | 1665.8 | 1650.9 | 1658.8 | 318565.0 |
| 2018-06-01 | ZN | Futures | 119.648711 | 119.648711 | 119.012859 | 119.276505 | 126455.0 |
| 2018-06-01 | A6 | Futures | 0.77818 | 0.77879 | 0.77262 | 0.77838 | 93695.0 |
| 2018-06-01 | AD | Futures | 0.78116 | 0.78262 | 0.77797 | 0.78024 | 70635.0 |
| 2018-06-01 | B | Futures | 56.9 | 57.08 | 55.91 | 56.23 | 296571.0 |
| 2018-06-01 | B6 | Futures | 1.3776 | 1.3847 | 1.3734 | 1.383 | 120783.0 |
| 2018-06-01 | BFX | Futures | 4394.8 | 4405.8 | 4394.8 | 4405.8 | 43.0 |
| 2018-06-01 | BR | Futures | 0.20201 | 0.20209 | 0.19969 | 0.20068 | 113.0 |
| 2018-06-01 | BTC | Futures | 10729.6 | 10829.0 | 10374.3 | 10573.2 | 2197.0 |
| 2018-06-01 | BZ | Futures | 56.36 | 56.54 | 55.39 | 55.7 | 35684.0 |
| 2018-06-01 | C | Futures | 1610.0 | 1617.0 | 1582.0 | 1601.0 | 13574.0 |
| 2018-06-01 | CB | Futures | 298.039 | 298.039 | 295.04 | 295.04 | 49.0 |
| 2018-06-01 | CC | Futures | 1786.0 | 1801.0 | 1759.0 | 1792.0 | 36079.0 |
| 2018-06-01 | CNH | Futures | 6.4987 | 6.5078 | 6.4982 | 6.5013 | 37.0 |
| 2018-06-01 | CSC | Futures | 3.494 | 3.506 | 3.494 | 3.498 | 95.0 |
| 2018-06-01 | CT | Futures | 105.9 | 107.41 | 105.4 | 106.06 | 25665.0 |
| 2018-06-01 | DC | Futures | 28.31 | 28.36 | 28.18 | 28.26 | 163.0 |
| 2018-06-01 | DX | Futures | 88.617 | 89.065 | 88.518 | 88.814 | 28831.0 |
| 2018-06-01 | E1 | Futures | 1.22309 | 1.22513 | 1.21622 | 1.21947 | 26475.0 |
| 2018-06-01 | E6 | Futures | 1.31861 | 1.32137 | 1.30994 | 1.31523 | 347073.0 |
| 2018-06-01 | E7 | Futures | 1.3116 | 1.3142 | 1.303 | 1.3082 | 7574.0 |
| 2018-06-01 | EBM | Futures | 190.4 | 191.71 | 189.62 | 189.88 | 12621.0 |
| 2018-06-01 | ED | Futures | 94.9792 | 94.9889 | 94.9646 | 94.9792 | 255869.0 |
| 2018-06-01 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 42835.0 |
| 2018-06-01 | EW | Futures | 2064.1 | 2079.9 | 2064.1 | 2073.8 | 13326.0 |
| 2018-06-01 | FBON | Futures | 127.54 | 129.05 | 127.41 | 128.3 | 1363.0 |
| 2018-06-01 | FBTP | Futures | 106.41 | 108.15 | 105.68 | 106.46 | 218889.0 |
| 2018-06-01 | FBTS | Futures | 102.077 | 102.678 | 101.615 | 101.791 | 115540.0 |
| 2018-06-01 | FCE | Futures | 4848.3 | 4913.0 | 4848.3 | 4894.5 | 105950.0 |
| 2018-06-01 | FDAX | Futures | 13116.9 | 13297.2 | 13116.9 | 13190.7 | 101168.0 |
| 2018-06-01 | FDXM | Futures | 13001.7 | 13178.8 | 13001.7 | 13073.2 | 36220.0 |
| 2018-06-01 | FESX | Futures | 2844.8 | 2884.7 | 2843.9 | 2868.1 | 1320776.0 |
| 2018-06-01 | FEU3 | Futures | 99.021 | 99.026 | 99.021 | 99.021 | 149.0 |
| 2018-06-01 | FGBL | Futures | 152.14 | 152.29 | 151.5 | 151.94 | 1227052.0 |
| 2018-06-01 | FGBM | Futures | 130.8 | 130.87 | 130.49 | 130.66 | 909996.0 |
| 2018-06-01 | FGBS | Futures | 112.703 | 112.728 | 112.663 | 112.688 | 861958.0 |
| 2018-06-01 | FGBX | Futures | 175.89 | 176.14 | 174.26 | 175.48 | 139384.0 |
| 2018-06-01 | FMWO | Futures | 6987.7 | 7026.2 | 6987.7 | 7013.3 | 2956.0 |
| 2018-06-01 | FOAT | Futures | 140.1 | 140.32 | 139.5 | 139.77 | 238256.0 |
| 2018-06-01 | FTDX | Futures | 2765.6 | 2784.4 | 2750.3 | 2759.2 | 312.0 |
| 2018-06-01 | FTI | Futures | 511.59 | 517.83 | 511.59 | 516.21 | 30677.0 |
| 2018-06-01 | FTUK | Futures | 6781.4 | 6835.3 | 6779.6 | 6790.2 | 110396.0 |
| 2018-06-01 | FVSA | Futures | 359.79 | 359.79 | 327.57 | 330.79 | 32147.0 |
| 2018-06-01 | FXXP | Futures | 331.6 | 335.1 | 331.6 | 333.7 | 46845.0 |
| 2018-06-01 | G | Futures | 115.45 | 115.56 | 114.98 | 115.32 | 253700.0 |
| 2018-06-01 | GF | Futures | 305.039 | 306.178 | 302.19 | 303.123 | 6833.0 |
> showing 50 of 116 rows — these rows as CSV