PREVIEW / futures_daily / 2021-07-02
file: by_date/futures_daily/2021/2021-07-02.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 |
|---|---|---|---|---|---|---|---|
| 2021-07-02 | ES | Futures | 4844.48 | 4886.35 | 4842.51 | 4881.57 | 999780.0 |
| 2021-07-02 | NQ | Futures | 16778.94 | 16992.66 | 16743.75 | 16975.06 | 392168.0 |
| 2021-07-02 | YM | Futures | 37419.9 | 37641.1 | 37399.3 | 37600.9 | 102663.0 |
| 2021-07-02 | CL | Futures | 53.81 | 54.24 | 53.38 | 53.92 | 377531.0 |
| 2021-07-02 | GC | Futures | 2079.0 | 2100.5 | 2075.4 | 2085.8 | 205858.0 |
| 2021-07-02 | ZN | Futures | 133.9782 | 134.405185 | 133.835872 | 134.278671 | 1303525.0 |
| 2021-07-02 | A6 | Futures | 0.76608 | 0.7728 | 0.76357 | 0.76946 | 96022.0 |
| 2021-07-02 | AD | Futures | 0.81494 | 0.82361 | 0.81433 | 0.82133 | 78327.0 |
| 2021-07-02 | ALI | Futures | 2918.8 | 2970.74 | 2918.8 | 2969.3 | 421.0 |
| 2021-07-02 | B | Futures | 49.94 | 50.46 | 49.66 | 50.29 | 236220.0 |
| 2021-07-02 | B6 | Futures | 1.3975 | 1.406 | 1.3944 | 1.4019 | 89514.0 |
| 2021-07-02 | BR | Futures | 0.15731 | 0.15939 | 0.15691 | 0.15719 | 1310.0 |
| 2021-07-02 | BTC | Futures | 47667.5 | 48429.6 | 46470.8 | 47418.2 | 3489.0 |
| 2021-07-02 | BZ | Futures | 48.78 | 49.33 | 48.55 | 49.16 | 31167.0 |
| 2021-07-02 | C | Futures | 1449.0 | 1450.0 | 1433.0 | 1435.0 | 1598.0 |
| 2021-07-02 | CB | Futures | 141.688 | 141.688 | 141.006 | 141.327 | 11.0 |
| 2021-07-02 | CC | Futures | 1544.0 | 1558.0 | 1517.0 | 1521.0 | 22939.0 |
| 2021-07-02 | CNH | Futures | 6.2733 | 6.2908 | 6.2702 | 6.2781 | 553.0 |
| 2021-07-02 | CSC | Futures | 2.5 | 2.506 | 2.496 | 2.496 | 147.0 |
| 2021-07-02 | CT | Futures | 80.61 | 80.93 | 80.33 | 80.93 | 5.0 |
| 2021-07-02 | DC | Futures | 22.5 | 22.68 | 22.5 | 22.54 | 232.0 |
| 2021-07-02 | DX | Futures | 89.482 | 89.661 | 89.09 | 89.325 | 24557.0 |
| 2021-07-02 | E1 | Futures | 1.2155 | 1.22269 | 1.21292 | 1.21932 | 29459.0 |
| 2021-07-02 | E6 | Futures | 1.26211 | 1.26483 | 1.25765 | 1.26158 | 189619.0 |
| 2021-07-02 | E7 | Futures | 1.2558 | 1.2584 | 1.2514 | 1.2553 | 5366.0 |
| 2021-07-02 | EBM | Futures | 307.83 | 309.3 | 300.47 | 301.57 | 13971.0 |
| 2021-07-02 | ED | Futures | 96.5248 | 96.5345 | 96.5248 | 96.5297 | 82399.0 |
| 2021-07-02 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.465 | 27375.0 |
| 2021-07-02 | ESG | Futures | 400.13 | 403.75 | 400.02 | 403.47 | 228.0 |
| 2021-07-02 | EW | Futures | 2916.6 | 2928.5 | 2895.8 | 2906.4 | 8725.0 |
| 2021-07-02 | FBON | Futures | 148.24 | 148.74 | 148.24 | 148.62 | 294.0 |
| 2021-07-02 | FBTP | Futures | 138.7 | 139.13 | 138.6 | 138.96 | 114649.0 |
| 2021-07-02 | FBTS | Futures | 110.205 | 110.263 | 110.195 | 110.244 | 49970.0 |
| 2021-07-02 | FCE | Futures | 6540.9 | 6555.8 | 6511.5 | 6524.9 | 38872.0 |
| 2021-07-02 | FDAX | Futures | 16727.3 | 16811.9 | 16693.0 | 16728.4 | 54513.0 |
| 2021-07-02 | FDIV | Futures | 188.82 | 188.82 | 188.14 | 188.14 | 50.0 |
| 2021-07-02 | FDXM | Futures | 16643.3 | 16727.5 | 16610.2 | 16645.4 | 34002.0 |
| 2021-07-02 | FDXS | Futures | 16536.5 | 16620.2 | 16504.7 | 16539.7 | 4527.0 |
| 2021-07-02 | FESX | Futures | 3863.6 | 3876.4 | 3851.7 | 3856.0 | 469333.0 |
| 2021-07-02 | FGBL | Futures | 167.22 | 167.77 | 167.14 | 167.67 | 692345.0 |
| 2021-07-02 | FGBM | Futures | 134.63 | 134.79 | 134.62 | 134.74 | 364037.0 |
| 2021-07-02 | FGBS | Futures | 112.589 | 112.599 | 112.579 | 112.589 | 152301.0 |
| 2021-07-02 | FGBX | Futures | 216.72 | 218.56 | 216.42 | 218.15 | 71890.0 |
| 2021-07-02 | FMWO | Futures | 10688.2 | 10759.8 | 10669.4 | 10716.3 | 2230.0 |
| 2021-07-02 | FOAT | Futures | 155.21 | 155.62 | 155.13 | 155.52 | 155096.0 |
| 2021-07-02 | FTDX | Futures | 3659.4 | 3660.9 | 3648.1 | 3651.1 | 75.0 |
| 2021-07-02 | FTI | Futures | 697.57 | 701.14 | 696.24 | 698.13 | 17068.0 |
| 2021-07-02 | FTUK | Futures | 6966.1 | 6986.3 | 6931.6 | 6939.0 | 75104.0 |
| 2021-07-02 | FVSA | Futures | 82.06 | 82.29 | 78.62 | 79.08 | 32863.0 |
| 2021-07-02 | FXXP | Futures | 433.4 | 434.7 | 432.3 | 433.0 | 64566.0 |
> showing 50 of 121 rows — these rows as CSV