PREVIEW / futures_daily / 2018-05-25
file: by_date/futures_daily/2018/2018-05-25.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-05-25 | ES | Futures | 2965.25 | 2977.22 | 2951.12 | 2956.01 | 993783.0 |
| 2018-05-25 | NQ | Futures | 8140.36 | 8197.42 | 8125.73 | 8146.51 | 317340.0 |
| 2018-05-25 | YM | Futures | 26128.6 | 26236.0 | 25991.6 | 26050.6 | 179845.0 |
| 2018-05-25 | CL | Futures | 71.11 | 71.26 | 67.86 | 68.32 | 955354.0 |
| 2018-05-25 | GC | Futures | 1671.2 | 1675.8 | 1665.6 | 1671.2 | 96671.0 |
| 2018-05-25 | ZN | Futures | 118.594127 | 119.121419 | 118.501076 | 118.966333 | 2761228.0 |
| 2018-05-25 | A6 | Futures | 0.7792 | 0.78054 | 0.77561 | 0.77694 | 85082.0 |
| 2018-05-25 | AD | Futures | 0.78586 | 0.78606 | 0.77928 | 0.77994 | 83631.0 |
| 2018-05-25 | B | Futures | 57.74 | 57.81 | 55.69 | 56.0 | 284118.0 |
| 2018-05-25 | B6 | Futures | 1.387 | 1.3878 | 1.378 | 1.3803 | 108961.0 |
| 2018-05-25 | BR | Futures | 0.20871 | 0.20871 | 0.2057 | 0.20631 | 4308.0 |
| 2018-05-25 | BTC | Futures | 10694.0 | 10907.2 | 10416.9 | 10573.2 | 2069.0 |
| 2018-05-25 | BZ | Futures | 57.15 | 57.24 | 55.18 | 55.47 | 33219.0 |
| 2018-05-25 | C | Futures | 1700.0 | 1714.0 | 1676.0 | 1678.0 | 7871.0 |
| 2018-05-25 | CC | Futures | 1898.0 | 1918.0 | 1861.0 | 1863.0 | 23751.0 |
| 2018-05-25 | CNH | Futures | 6.4774 | 6.4829 | 6.4738 | 6.4829 | 51.0 |
| 2018-05-25 | CSC | Futures | 3.492 | 3.492 | 3.48 | 3.482 | 41.0 |
| 2018-05-25 | CT | Futures | 99.68 | 101.96 | 99.07 | 101.41 | 24977.0 |
| 2018-05-25 | DC | Futures | 28.21 | 28.21 | 28.11 | 28.19 | 46.0 |
| 2018-05-25 | DX | Futures | 88.405 | 88.881 | 88.362 | 88.777 | 23154.0 |
| 2018-05-25 | E1 | Futures | 1.21755 | 1.21971 | 1.21417 | 1.21658 | 25413.0 |
| 2018-05-25 | E6 | Futures | 1.32233 | 1.32391 | 1.31388 | 1.31574 | 363578.0 |
| 2018-05-25 | E7 | Futures | 1.3154 | 1.3167 | 1.3069 | 1.3088 | 5910.0 |
| 2018-05-25 | EBM | Futures | 189.36 | 191.45 | 188.83 | 190.93 | 16460.0 |
| 2018-05-25 | ED | Futures | 95.0084 | 95.0181 | 95.0011 | 95.0059 | 196175.0 |
| 2018-05-25 | ER | Futures | 98.332 | 98.337 | 98.323 | 98.328 | 221235.0 |
| 2018-05-25 | EW | Futures | 2068.3 | 2075.4 | 2057.1 | 2062.2 | 10872.0 |
| 2018-05-25 | FBON | Futures | 128.19 | 128.49 | 126.95 | 127.77 | 2568.0 |
| 2018-05-25 | FBTP | Futures | 109.83 | 110.01 | 108.46 | 109.48 | 231352.0 |
| 2018-05-25 | FBTS | Futures | 103.326 | 103.353 | 102.503 | 102.91 | 257673.0 |
| 2018-05-25 | FCE | Futures | 4969.1 | 4978.1 | 4913.9 | 4935.0 | 82247.0 |
| 2018-05-25 | FDAX | Futures | 13430.2 | 13508.1 | 13351.8 | 13437.5 | 117728.0 |
| 2018-05-25 | FDXM | Futures | 13304.4 | 13388.9 | 13234.4 | 13317.8 | 43247.0 |
| 2018-05-25 | FESX | Futures | 2932.2 | 2940.6 | 2890.6 | 2909.7 | 1247471.0 |
| 2018-05-25 | FEU3 | Futures | 99.016 | 99.016 | 99.011 | 99.011 | 205.0 |
| 2018-05-25 | FGBL | Futures | 150.65 | 151.83 | 150.61 | 151.53 | 1335820.0 |
| 2018-05-25 | FGBM | Futures | 130.24 | 130.72 | 130.21 | 130.59 | 699142.0 |
| 2018-05-25 | FGBS | Futures | 112.643 | 112.718 | 112.638 | 112.688 | 740604.0 |
| 2018-05-25 | FGBX | Futures | 171.53 | 173.76 | 171.42 | 173.22 | 102329.0 |
| 2018-05-25 | FMWO | Futures | 7044.9 | 7057.7 | 7004.0 | 7021.5 | 861.0 |
| 2018-05-25 | FOAT | Futures | 138.99 | 139.77 | 138.94 | 139.64 | 291299.0 |
| 2018-05-25 | FTDX | Futures | 2788.3 | 2859.6 | 2781.4 | 2789.3 | 134.0 |
| 2018-05-25 | FTI | Futures | 521.25 | 521.48 | 516.21 | 518.89 | 30925.0 |
| 2018-05-25 | FTUK | Futures | 6826.0 | 6850.7 | 6792.0 | 6822.0 | 108776.0 |
| 2018-05-25 | FVSA | Futures | 312.53 | 340.46 | 310.38 | 327.57 | 43939.0 |
| 2018-05-25 | FXXP | Futures | 338.4 | 338.6 | 335.8 | 337.1 | 49335.0 |
| 2018-05-25 | G | Futures | 114.17 | 115.09 | 114.17 | 114.79 | 454895.0 |
| 2018-05-25 | GF | Futures | 297.219 | 301.569 | 295.561 | 300.222 | 5531.0 |
| 2018-05-25 | GSCI | Futures | 543.53 | 543.53 | 540.28 | 540.61 | 37.0 |
| 2018-05-25 | HE | Futures | 78.459 | 78.643 | 77.829 | 77.96 | 6167.0 |
> showing 50 of 112 rows — these rows as CSV