PREVIEW / futures_daily / 2020-10-02
file: by_date/futures_daily/2020/2020-10-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 |
|---|---|---|---|---|---|---|---|
| 2020-10-02 | ES | Futures | 3782.76 | 3792.31 | 3707.77 | 3751.58 | 2028921.0 |
| 2020-10-02 | NQ | Futures | 13390.93 | 13434.92 | 12971.55 | 13004.83 | 806629.0 |
| 2020-10-02 | YM | Futures | 29799.7 | 29865.4 | 29185.0 | 29675.9 | 281065.0 |
| 2020-10-02 | CL | Futures | 27.71 | 27.75 | 26.3 | 26.6 | 391428.0 |
| 2020-10-02 | GC | Futures | 2256.9 | 2271.8 | 2238.3 | 2252.9 | 212728.0 |
| 2020-10-02 | ZN | Futures | 138.373186 | 138.636636 | 138.218215 | 138.2957 | 1444042.0 |
| 2020-10-02 | A6 | Futures | 0.73779 | 0.7382 | 0.73225 | 0.73512 | 99354.0 |
| 2020-10-02 | AD | Futures | 0.76298 | 0.76313 | 0.76029 | 0.76181 | 66404.0 |
| 2020-10-02 | ALI | Futures | 2088.66 | 2137.38 | 2088.66 | 2133.22 | 253.0 |
| 2020-10-02 | B | Futures | 25.65 | 25.73 | 24.48 | 24.78 | 337414.0 |
| 2020-10-02 | B6 | Futures | 1.307 | 1.3139 | 1.3019 | 1.312 | 147762.0 |
| 2020-10-02 | BR | Futures | 0.13904 | 0.1399 | 0.13798 | 0.1388 | 18.0 |
| 2020-10-02 | BTC | Futures | 14262.7 | 14383.7 | 13987.3 | 14175.4 | 5867.0 |
| 2020-10-02 | BZ | Futures | 25.24 | 25.26 | 24.0 | 24.3 | 37290.0 |
| 2020-10-02 | C | Futures | 1566.0 | 1567.0 | 1517.0 | 1540.0 | 8545.0 |
| 2020-10-02 | CB | Futures | 167.705 | 167.705 | 166.688 | 166.688 | 9.0 |
| 2020-10-02 | CC | Futures | 1629.0 | 1645.0 | 1604.0 | 1630.0 | 20761.0 |
| 2020-10-02 | CNH | Futures | 6.6488 | 6.6599 | 6.6374 | 6.641 | 598.0 |
| 2020-10-02 | CSC | Futures | 3.445 | 3.456 | 3.441 | 3.456 | 104.0 |
| 2020-10-02 | CT | Futures | 65.08 | 65.23 | 64.1 | 65.05 | 15183.0 |
| 2020-10-02 | DC | Futures | 28.22 | 28.51 | 28.22 | 28.44 | 174.0 |
| 2020-10-02 | DX | Futures | 90.607 | 90.888 | 90.545 | 90.713 | 21820.0 |
| 2020-10-02 | E1 | Futures | 1.23526 | 1.23594 | 1.23073 | 1.23254 | 20437.0 |
| 2020-10-02 | E6 | Futures | 1.26022 | 1.26032 | 1.25465 | 1.25652 | 185166.0 |
| 2020-10-02 | E7 | Futures | 1.2537 | 1.2538 | 1.2483 | 1.2501 | 6987.0 |
| 2020-10-02 | EBM | Futures | 236.89 | 237.49 | 234.47 | 237.19 | 33397.0 |
| 2020-10-02 | ED | Futures | 96.489 | 96.4939 | 96.4842 | 96.489 | 98857.0 |
| 2020-10-02 | ER | Futures | 98.44 | 98.445 | 98.435 | 98.445 | 51268.0 |
| 2020-10-02 | ESG | Futures | 309.0 | 311.93 | 307.59 | 310.08 | 134.0 |
| 2020-10-02 | EW | Futures | 2006.3 | 2036.9 | 1965.7 | 2028.8 | 14852.0 |
| 2020-10-02 | FBON | Futures | 148.07 | 148.55 | 148.07 | 148.4 | 377.0 |
| 2020-10-02 | FBTP | Futures | 135.86 | 136.29 | 135.72 | 136.15 | 107981.0 |
| 2020-10-02 | FBTS | Futures | 109.431 | 109.566 | 109.411 | 109.479 | 63081.0 |
| 2020-10-02 | FCE | Futures | 4624.5 | 4695.8 | 4609.0 | 4676.9 | 68725.0 |
| 2020-10-02 | FDAX | Futures | 13515.3 | 13566.5 | 13349.5 | 13499.9 | 74315.0 |
| 2020-10-02 | FDIV | Futures | 144.98 | 145.73 | 144.98 | 145.5 | 310.0 |
| 2020-10-02 | FDXM | Futures | 13454.1 | 13496.5 | 13281.1 | 13431.8 | 61242.0 |
| 2020-10-02 | FESX | Futures | 2938.1 | 2953.8 | 2899.2 | 2938.1 | 951464.0 |
| 2020-10-02 | FGBL | Futures | 169.81 | 170.16 | 169.8 | 169.86 | 527372.0 |
| 2020-10-02 | FGBM | Futures | 135.15 | 135.28 | 135.15 | 135.19 | 272575.0 |
| 2020-10-02 | FGBS | Futures | 112.764 | 112.795 | 112.764 | 112.775 | 273390.0 |
| 2020-10-02 | FGBX | Futures | 232.97 | 233.91 | 232.35 | 232.53 | 52792.0 |
| 2020-10-02 | FMWO | Futures | 8282.7 | 8356.1 | 8236.5 | 8336.0 | 4446.0 |
| 2020-10-02 | FOAT | Futures | 158.02 | 158.15 | 157.86 | 157.96 | 122223.0 |
| 2020-10-02 | FTDX | Futures | 3189.2 | 3189.2 | 3149.1 | 3162.5 | 35.0 |
| 2020-10-02 | FTI | Futures | 508.21 | 517.2 | 505.55 | 515.36 | 26774.0 |
| 2020-10-02 | FTUK | Futures | 5593.1 | 5629.4 | 5511.9 | 5603.1 | 91697.0 |
| 2020-10-02 | FVSA | Futures | 219.9 | 228.44 | 205.04 | 208.76 | 21085.0 |
| 2020-10-02 | FXXP | Futures | 329.7 | 336.1 | 329.7 | 334.6 | 41085.0 |
| 2020-10-02 | G | Futures | 126.84 | 126.92 | 126.46 | 126.49 | 213111.0 |
> showing 50 of 120 rows — these rows as CSV