PREVIEW / futures_daily / 2020-12-04
file: by_date/futures_daily/2020/2020-12-04.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-04 | ES | Futures | 4121.21 | 4156.88 | 4118.12 | 4154.63 | 991860.0 |
| 2020-12-04 | NQ | Futures | 14456.31 | 14512.75 | 14411.74 | 14501.46 | 321796.0 |
| 2020-12-04 | YM | Futures | 32238.2 | 32529.9 | 32227.4 | 32510.5 | 120262.0 |
| 2020-12-04 | CL | Futures | 32.46 | 33.2 | 32.44 | 32.9 | 335453.0 |
| 2020-12-04 | GC | Futures | 2169.7 | 2179.1 | 2154.8 | 2164.2 | 171259.0 |
| 2020-12-04 | ZN | Futures | 137.009445 | 137.071433 | 136.56003 | 136.684007 | 11150.0 |
| 2020-12-04 | A6 | Futures | 0.76366 | 0.76428 | 0.76079 | 0.76376 | 87133.0 |
| 2020-12-04 | AD | Futures | 0.78755 | 0.79343 | 0.7872 | 0.79302 | 79637.0 |
| 2020-12-04 | ALI | Futures | 2425.16 | 2426.93 | 2407.77 | 2420.15 | 122.0 |
| 2020-12-04 | B | Futures | 30.94 | 31.55 | 30.86 | 31.12 | 253637.0 |
| 2020-12-04 | B6 | Futures | 1.3642 | 1.3729 | 1.3597 | 1.3632 | 164304.0 |
| 2020-12-04 | BR | Futures | 0.15223 | 0.15324 | 0.15063 | 0.15199 | 86.0 |
| 2020-12-04 | BTC | Futures | 25638.0 | 25729.2 | 24530.7 | 24882.4 | 7567.0 |
| 2020-12-04 | BZ | Futures | 30.18 | 30.82 | 30.14 | 30.44 | 31658.0 |
| 2020-12-04 | C | Futures | 1535.0 | 1544.0 | 1514.0 | 1526.0 | 497.0 |
| 2020-12-04 | CB | Futures | 155.037 | 156.883 | 154.552 | 155.198 | 30.0 |
| 2020-12-04 | CC | Futures | 1735.0 | 1758.0 | 1723.0 | 1744.0 | 11731.0 |
| 2020-12-04 | CNH | Futures | 6.3993 | 6.4058 | 6.3755 | 6.3762 | 1011.0 |
| 2020-12-04 | CSC | Futures | 3.066 | 3.066 | 3.01 | 3.01 | 39.0 |
| 2020-12-04 | CT | Futures | 68.77 | 69.82 | 68.7 | 69.15 | 13862.0 |
| 2020-12-04 | DC | Futures | 25.5 | 25.79 | 25.27 | 25.35 | 138.0 |
| 2020-12-04 | DX | Futures | 87.565 | 87.777 | 87.391 | 87.607 | 32945.0 |
| 2020-12-04 | E1 | Futures | 1.27115 | 1.27466 | 1.26934 | 1.27194 | 25402.0 |
| 2020-12-04 | E6 | Futures | 1.30087 | 1.30462 | 1.29744 | 1.30039 | 231778.0 |
| 2020-12-04 | E7 | Futures | 1.2942 | 1.298 | 1.2908 | 1.2938 | 7990.0 |
| 2020-12-04 | EBM | Futures | 250.75 | 251.65 | 246.23 | 247.13 | 2286.0 |
| 2020-12-04 | ED | Futures | 96.4963 | 96.4963 | 96.489 | 96.489 | 158744.0 |
| 2020-12-04 | ER | Futures | 98.465 | 98.47 | 98.46 | 98.47 | 49536.0 |
| 2020-12-04 | ESG | Futures | 340.46 | 341.84 | 340.46 | 341.84 | 2265.0 |
| 2020-12-04 | EW | Futures | 2356.1 | 2401.2 | 2356.0 | 2399.3 | 10447.0 |
| 2020-12-04 | FBON | Futures | 150.54 | 150.62 | 150.2 | 150.23 | 1683.0 |
| 2020-12-04 | FBTP | Futures | 138.69 | 138.84 | 138.36 | 138.43 | 182239.0 |
| 2020-12-04 | FBTS | Futures | 110.029 | 110.087 | 109.991 | 110.01 | 134432.0 |
| 2020-12-04 | FCE | Futures | 5425.7 | 5474.9 | 5421.3 | 5466.6 | 50952.0 |
| 2020-12-04 | FDAX | Futures | 14075.1 | 14195.5 | 14072.4 | 14160.9 | 60675.0 |
| 2020-12-04 | FDIV | Futures | 159.38 | 159.38 | 159.24 | 159.24 | 7.0 |
| 2020-12-04 | FDXM | Futures | 14011.0 | 14124.5 | 14002.5 | 14089.5 | 40815.0 |
| 2020-12-04 | FESX | Futures | 3236.7 | 3271.8 | 3234.8 | 3266.3 | 765129.0 |
| 2020-12-04 | FGBL | Futures | 170.34 | 170.4 | 170.0 | 170.01 | 774204.0 |
| 2020-12-04 | FGBM | Futures | 135.35 | 135.39 | 135.28 | 135.3 | 543397.0 |
| 2020-12-04 | FGBS | Futures | 112.79 | 112.805 | 112.775 | 112.785 | 433031.0 |
| 2020-12-04 | FGBX | Futures | 234.93 | 235.69 | 233.95 | 234.0 | 85891.0 |
| 2020-12-04 | FMWO | Futures | 9250.4 | 9301.3 | 9210.1 | 9290.6 | 9438.0 |
| 2020-12-04 | FOAT | Futures | 158.82 | 158.95 | 158.57 | 158.6 | 263576.0 |
| 2020-12-04 | FTDX | Futures | 3178.4 | 3203.1 | 3178.4 | 3203.1 | 26.0 |
| 2020-12-04 | FTI | Futures | 570.04 | 575.93 | 569.85 | 575.24 | 17481.0 |
| 2020-12-04 | FTUK | Futures | 6179.5 | 6268.9 | 6179.5 | 6252.2 | 112631.0 |
| 2020-12-04 | FVSA | Futures | 154.31 | 155.05 | 149.13 | 149.87 | 16281.0 |
| 2020-12-04 | FXXP | Futures | 362.5 | 365.8 | 362.1 | 364.9 | 48754.0 |
| 2020-12-04 | G | Futures | 125.91 | 126.02 | 125.5 | 125.61 | 229020.0 |
> showing 50 of 121 rows — these rows as CSV