PREVIEW / futures_daily / 2019-12-02
file: by_date/futures_daily/2019/2019-12-02.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-02 | ES | Futures | 3406.03 | 3418.75 | 3367.06 | 3371.39 | 1927030.0 |
| 2019-12-02 | NQ | Futures | 9708.57 | 9746.31 | 9538.01 | 9583.53 | 559474.0 |
| 2019-12-02 | YM | Futures | 29480.2 | 29601.0 | 29154.8 | 29172.6 | 226061.0 |
| 2019-12-02 | CL | Futures | 56.64 | 57.87 | 56.59 | 57.14 | 616423.0 |
| 2019-12-02 | GC | Futures | 1808.9 | 1810.6 | 1796.0 | 1807.5 | 316575.0 |
| 2019-12-02 | ZN | Futures | 128.009634 | 128.040603 | 127.545102 | 127.730915 | 108406.0 |
| 2019-12-02 | A6 | Futures | 0.69445 | 0.7006 | 0.69404 | 0.70019 | 110315.0 |
| 2019-12-02 | AD | Futures | 0.75834 | 0.75884 | 0.75688 | 0.75758 | 71204.0 |
| 2019-12-02 | ALI | Futures | 2170.32 | 2193.4 | 2161.81 | 2192.49 | 168.0 |
| 2019-12-02 | B | Futures | 48.98 | 50.08 | 48.97 | 49.13 | 297874.0 |
| 2019-12-02 | B6 | Futures | 1.3136 | 1.3171 | 1.3117 | 1.3166 | 94094.0 |
| 2019-12-02 | BR | Futures | 0.19044 | 0.19174 | 0.19044 | 0.19174 | 83.0 |
| 2019-12-02 | BTC | Futures | 11232.0 | 11367.4 | 10825.7 | 11036.4 | 4334.0 |
| 2019-12-02 | BZ | Futures | 48.38 | 49.4 | 48.14 | 48.48 | 39023.0 |
| 2019-12-02 | C | Futures | 1758.0 | 1785.0 | 1743.0 | 1747.0 | 4938.0 |
| 2019-12-02 | CB | Futures | 249.074 | 249.369 | 248.19 | 249.074 | 59.0 |
| 2019-12-02 | CC | Futures | 1677.0 | 1690.0 | 1654.0 | 1664.0 | 21818.0 |
| 2019-12-02 | CNH | Futures | 7.0173 | 7.0338 | 7.0158 | 7.0315 | 523.0 |
| 2019-12-02 | CSC | Futures | 3.431 | 3.437 | 3.422 | 3.437 | 48.0 |
| 2019-12-02 | CT | Futures | 62.17 | 62.76 | 61.59 | 61.64 | 21627.0 |
| 2019-12-02 | DC | Futures | 28.72 | 28.87 | 28.59 | 28.87 | 104.0 |
| 2019-12-02 | DX | Futures | 94.923 | 95.029 | 94.478 | 94.518 | 23023.0 |
| 2019-12-02 | E1 | Futures | 1.15162 | 1.16174 | 1.15047 | 1.16128 | 47163.0 |
| 2019-12-02 | E6 | Futures | 1.19545 | 1.20309 | 1.19355 | 1.20185 | 251056.0 |
| 2019-12-02 | E7 | Futures | 1.1892 | 1.197 | 1.1875 | 1.1957 | 2994.0 |
| 2019-12-02 | EBM | Futures | 202.75 | 204.94 | 202.75 | 203.85 | 14324.0 |
| 2019-12-02 | ED | Futures | 95.3253 | 95.3375 | 95.3229 | 95.3326 | 217219.0 |
| 2019-12-02 | ER | Futures | 98.396 | 98.401 | 98.396 | 98.396 | 31635.0 |
| 2019-12-02 | ESG | Futures | 280.5 | 280.5 | 277.18 | 277.18 | 65.0 |
| 2019-12-02 | EW | Futures | 2112.2 | 2124.3 | 2095.2 | 2096.1 | 15694.0 |
| 2019-12-02 | FBON | Futures | 142.8 | 142.83 | 142.16 | 142.18 | 1913.0 |
| 2019-12-02 | FBTP | Futures | 128.22 | 128.51 | 127.21 | 127.42 | 234247.0 |
| 2019-12-02 | FBTS | Futures | 108.038 | 108.095 | 107.883 | 107.96 | 141683.0 |
| 2019-12-02 | FCE | Futures | 5349.8 | 5380.6 | 5227.6 | 5233.5 | 115354.0 |
| 2019-12-02 | FDAX | Futures | 13989.8 | 14074.2 | 13662.2 | 13693.3 | 154556.0 |
| 2019-12-02 | FDIV | Futures | 161.31 | 161.82 | 158.2 | 158.2 | 134.0 |
| 2019-12-02 | FDXM | Futures | 13804.5 | 13889.9 | 13483.8 | 13514.5 | 68061.0 |
| 2019-12-02 | FESX | Futures | 3248.3 | 3268.4 | 3173.7 | 3180.7 | 1505451.0 |
| 2019-12-02 | FGBL | Futures | 165.18 | 165.19 | 164.08 | 164.14 | 1684294.0 |
| 2019-12-02 | FGBM | Futures | 133.85 | 133.85 | 133.51 | 133.57 | 1227385.0 |
| 2019-12-02 | FGBS | Futures | 112.674 | 112.674 | 112.619 | 112.659 | 1148158.0 |
| 2019-12-02 | FGBX | Futures | 215.9 | 215.92 | 212.0 | 212.06 | 152659.0 |
| 2019-12-02 | FMWO | Futures | 7670.2 | 7680.4 | 7564.4 | 7575.8 | 3990.0 |
| 2019-12-02 | FOAT | Futures | 152.37 | 152.4 | 151.46 | 151.54 | 388069.0 |
| 2019-12-02 | FTDX | Futures | 3036.8 | 3038.3 | 2949.5 | 2956.9 | 156.0 |
| 2019-12-02 | FTI | Futures | 573.39 | 576.46 | 560.66 | 561.88 | 46236.0 |
| 2019-12-02 | FTUK | Futures | 6833.4 | 6861.7 | 6743.5 | 6752.3 | 109995.0 |
| 2019-12-02 | FVSA | Futures | 130.75 | 145.96 | 128.73 | 144.94 | 61389.0 |
| 2019-12-02 | FXXP | Futures | 369.2 | 370.9 | 362.1 | 362.6 | 111843.0 |
| 2019-12-02 | G | Futures | 120.62 | 120.8 | 120.39 | 120.6 | 232854.0 |
> showing 50 of 120 rows — these rows as CSV