PREVIEW / futures_daily / 2018-05-30
file: by_date/futures_daily/2018/2018-05-30.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-30 | ES | Futures | 2928.82 | 2967.97 | 2920.67 | 2962.81 | 1424364.0 |
| 2018-05-30 | NQ | Futures | 8132.17 | 8186.89 | 8097.64 | 8178.11 | 303797.0 |
| 2018-05-30 | YM | Futures | 25700.9 | 26034.8 | 25624.0 | 25986.4 | 220229.0 |
| 2018-05-30 | CL | Futures | 67.29 | 69.12 | 66.78 | 68.65 | 726886.0 |
| 2018-05-30 | GC | Futures | 1663.6 | 1670.9 | 1659.7 | 1668.0 | 338847.0 |
| 2018-05-30 | ZN | Futures | 120.331089 | 120.486174 | 119.369556 | 119.710745 | 2189691.0 |
| 2018-05-30 | A6 | Futures | 0.7716 | 0.77992 | 0.76882 | 0.7789 | 133479.0 |
| 2018-05-30 | AD | Futures | 0.77741 | 0.78849 | 0.77615 | 0.78586 | 138060.0 |
| 2018-05-30 | B | Futures | 55.29 | 57.09 | 54.85 | 56.91 | 435257.0 |
| 2018-05-30 | B6 | Futures | 1.374 | 1.3793 | 1.3725 | 1.3764 | 137241.0 |
| 2018-05-30 | BR | Futures | 0.20132 | 0.2022 | 0.20087 | 0.2022 | 51.0 |
| 2018-05-30 | BTC | Futures | 10665.6 | 10829.0 | 10331.6 | 10402.7 | 2471.0 |
| 2018-05-30 | BZ | Futures | 54.9 | 56.58 | 54.33 | 56.38 | 44996.0 |
| 2018-05-30 | C | Futures | 1656.0 | 1666.0 | 1645.0 | 1657.0 | 9339.0 |
| 2018-05-30 | CB | Futures | 302.206 | 303.466 | 302.206 | 302.206 | 9.0 |
| 2018-05-30 | CC | Futures | 1821.0 | 1853.0 | 1818.0 | 1844.0 | 26540.0 |
| 2018-05-30 | CNH | Futures | 6.516 | 6.5233 | 6.4984 | 6.4984 | 38.0 |
| 2018-05-30 | CSC | Futures | 3.514 | 3.516 | 3.502 | 3.504 | 64.0 |
| 2018-05-30 | CT | Futures | 107.09 | 109.58 | 103.69 | 105.14 | 46735.0 |
| 2018-05-30 | DC | Futures | 28.38 | 28.44 | 28.34 | 28.41 | 80.0 |
| 2018-05-30 | DX | Futures | 89.409 | 89.527 | 88.64 | 88.763 | 37620.0 |
| 2018-05-30 | E1 | Futures | 1.2173 | 1.22104 | 1.21417 | 1.21935 | 34297.0 |
| 2018-05-30 | E6 | Futures | 1.30205 | 1.31709 | 1.29929 | 1.31444 | 504707.0 |
| 2018-05-30 | E7 | Futures | 1.2951 | 1.31 | 1.2924 | 1.3074 | 9777.0 |
| 2018-05-30 | EBM | Futures | 191.71 | 191.71 | 188.31 | 188.57 | 21243.0 |
| 2018-05-30 | ED | Futures | 95.0108 | 95.0181 | 95.0011 | 95.0132 | 372302.0 |
| 2018-05-30 | ER | Futures | 98.313 | 98.332 | 98.313 | 98.323 | 96441.0 |
| 2018-05-30 | EW | Futures | 2058.3 | 2091.7 | 2051.3 | 2086.2 | 18308.0 |
| 2018-05-30 | FBON | Futures | 125.56 | 126.69 | 125.22 | 126.09 | 1256.0 |
| 2018-05-30 | FBTP | Futures | 102.47 | 105.66 | 102.25 | 104.0 | 243275.0 |
| 2018-05-30 | FBTS | Futures | 98.379 | 100.589 | 98.129 | 99.895 | 167489.0 |
| 2018-05-30 | FCE | Futures | 4845.6 | 4885.6 | 4821.7 | 4859.5 | 118688.0 |
| 2018-05-30 | FDAX | Futures | 13145.5 | 13331.5 | 13130.4 | 13240.6 | 111560.0 |
| 2018-05-30 | FDXM | Futures | 13027.4 | 13211.8 | 13013.0 | 13122.7 | 46602.0 |
| 2018-05-30 | FESX | Futures | 2838.9 | 2873.9 | 2831.4 | 2850.6 | 1551566.0 |
| 2018-05-30 | FEU3 | Futures | 99.006 | 99.016 | 99.006 | 99.011 | 598.0 |
| 2018-05-30 | FGBL | Futures | 153.43 | 153.45 | 151.89 | 152.47 | 1631498.0 |
| 2018-05-30 | FGBM | Futures | 131.63 | 131.65 | 130.78 | 131.11 | 961653.0 |
| 2018-05-30 | FGBS | Futures | 112.909 | 112.925 | 112.713 | 112.799 | 1010770.0 |
| 2018-05-30 | FGBX | Futures | 178.02 | 178.02 | 174.36 | 175.52 | 119242.0 |
| 2018-05-30 | FMWO | Futures | 6944.5 | 7005.2 | 6928.1 | 6974.8 | 443.0 |
| 2018-05-30 | FOAT | Futures | 140.57 | 140.62 | 139.67 | 139.96 | 266083.0 |
| 2018-05-30 | FTDX | Futures | 2735.9 | 2773.5 | 2735.9 | 2765.6 | 108.0 |
| 2018-05-30 | FTI | Futures | 510.85 | 516.72 | 510.48 | 514.55 | 35270.0 |
| 2018-05-30 | FTUK | Futures | 6720.0 | 6809.2 | 6709.3 | 6763.7 | 119675.0 |
| 2018-05-30 | FVSA | Futures | 384.49 | 384.49 | 352.27 | 364.08 | 33251.0 |
| 2018-05-30 | FXXP | Futures | 331.0 | 333.8 | 330.4 | 331.5 | 80435.0 |
| 2018-05-30 | G | Futures | 116.0 | 116.0 | 115.34 | 115.8 | 354857.0 |
| 2018-05-30 | GF | Futures | 299.187 | 308.302 | 298.565 | 307.732 | 10907.0 |
| 2018-05-30 | GSCI | Futures | 534.78 | 543.81 | 534.78 | 542.75 | 1081.0 |
> showing 50 of 113 rows — these rows as CSV