PREVIEW / futures_daily / 2021-11-02
file: by_date/futures_daily/2021/2021-11-02.parquet size: 10 KB rows: 123
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-11-02 | ES | Futures | 5180.97 | 5204.87 | 5166.91 | 5200.94 | 980833.0 |
| 2021-11-02 | NQ | Futures | 18324.63 | 18427.55 | 18276.78 | 18405.64 | 418550.0 |
| 2021-11-02 | YM | Futures | 38948.3 | 39137.6 | 38837.3 | 39101.7 | 120742.0 |
| 2021-11-02 | CL | Futures | 62.14 | 62.54 | 61.44 | 62.17 | 429608.0 |
| 2021-11-02 | GC | Futures | 2093.9 | 2097.4 | 2085.3 | 2087.6 | 145786.0 |
| 2021-11-02 | ZN | Futures | 132.955119 | 133.36827 | 132.859777 | 133.193475 | 1502792.0 |
| 2021-11-02 | A6 | Futures | 0.771 | 0.77233 | 0.76085 | 0.76141 | 103007.0 |
| 2021-11-02 | AD | Futures | 0.82054 | 0.82075 | 0.81704 | 0.81826 | 66894.0 |
| 2021-11-02 | ALI | Futures | 2995.29 | 3049.77 | 2993.35 | 3021.14 | 1303.0 |
| 2021-11-02 | B | Futures | 57.73 | 58.26 | 57.26 | 57.91 | 317069.0 |
| 2021-11-02 | B6 | Futures | 1.3872 | 1.3873 | 1.381 | 1.3823 | 79105.0 |
| 2021-11-02 | BFX | Futures | 4369.7 | 4402.3 | 4369.7 | 4402.3 | 39.0 |
| 2021-11-02 | BR | Futures | 0.14236 | 0.14293 | 0.14139 | 0.14216 | 1565.0 |
| 2021-11-02 | BTC | Futures | 80370.8 | 85185.6 | 80225.9 | 84329.4 | 5238.0 |
| 2021-11-02 | BZ | Futures | 56.36 | 56.89 | 55.92 | 56.56 | 40105.0 |
| 2021-11-02 | C | Futures | 1457.0 | 1457.0 | 1429.0 | 1434.0 | 12094.0 |
| 2021-11-02 | CB | Futures | 152.871 | 152.871 | 152.674 | 152.674 | 9.0 |
| 2021-11-02 | CC | Futures | 1642.0 | 1643.0 | 1576.0 | 1578.0 | 27303.0 |
| 2021-11-02 | CNH | Futures | 6.1442 | 6.1488 | 6.1418 | 6.1485 | 204.0 |
| 2021-11-02 | CSC | Futures | 2.528 | 2.53 | 2.46 | 2.466 | 137.0 |
| 2021-11-02 | CT | Futures | 112.34 | 113.56 | 108.9 | 109.43 | 26534.0 |
| 2021-11-02 | DC | Futures | 24.05 | 24.16 | 23.46 | 23.53 | 374.0 |
| 2021-11-02 | DX | Futures | 90.762 | 90.955 | 90.641 | 90.901 | 22142.0 |
| 2021-11-02 | E1 | Futures | 1.23333 | 1.23344 | 1.22527 | 1.2265 | 26084.0 |
| 2021-11-02 | E6 | Futures | 1.23401 | 1.23491 | 1.23082 | 1.23151 | 130888.0 |
| 2021-11-02 | E7 | Futures | 1.2273 | 1.2281 | 1.224 | 1.2248 | 2480.0 |
| 2021-11-02 | EBM | Futures | 430.22 | 436.47 | 428.75 | 430.22 | 20474.0 |
| 2021-11-02 | ED | Futures | 96.5054 | 96.515 | 96.4957 | 96.5054 | 302174.0 |
| 2021-11-02 | ER | Futures | 98.475 | 98.489 | 98.475 | 98.484 | 56720.0 |
| 2021-11-02 | ESG | Futures | 432.17 | 434.6 | 431.26 | 434.03 | 270.0 |
| 2021-11-02 | EW | Futures | 3062.8 | 3078.5 | 3049.9 | 3070.3 | 17141.0 |
| 2021-11-02 | FBON | Futures | 146.96 | 147.99 | 146.88 | 147.95 | 1376.0 |
| 2021-11-02 | FBTP | Futures | 135.07 | 136.64 | 134.94 | 136.56 | 183665.0 |
| 2021-11-02 | FBTS | Futures | 109.798 | 110.177 | 109.779 | 110.118 | 90650.0 |
| 2021-11-02 | FCE | Futures | 6964.4 | 7009.4 | 6954.3 | 7002.8 | 40293.0 |
| 2021-11-02 | FDAX | Futures | 16892.0 | 17048.1 | 16845.0 | 17035.3 | 61051.0 |
| 2021-11-02 | FDIV | Futures | 185.49 | 186.13 | 185.49 | 186.13 | 20.0 |
| 2021-11-02 | FDXM | Futures | 16938.0 | 17099.8 | 16892.9 | 17083.7 | 38131.0 |
| 2021-11-02 | FDXS | Futures | 16772.2 | 16940.0 | 16737.2 | 16925.1 | 14455.0 |
| 2021-11-02 | FESX | Futures | 4093.9 | 4110.7 | 4081.4 | 4106.8 | 468922.0 |
| 2021-11-02 | FGBL | Futures | 165.9 | 166.86 | 165.82 | 166.83 | 875011.0 |
| 2021-11-02 | FGBM | Futures | 133.72 | 134.24 | 133.7 | 134.22 | 508509.0 |
| 2021-11-02 | FGBS | Futures | 112.478 | 112.584 | 112.473 | 112.579 | 394180.0 |
| 2021-11-02 | FGBX | Futures | 224.94 | 225.31 | 223.86 | 224.79 | 111730.0 |
| 2021-11-02 | FMWO | Futures | 11322.7 | 11369.9 | 11318.0 | 11354.6 | 4126.0 |
| 2021-11-02 | FOAT | Futures | 153.34 | 154.55 | 153.31 | 154.48 | 230101.0 |
| 2021-11-02 | FTDX | Futures | 3972.4 | 3991.9 | 3972.4 | 3986.2 | 52.0 |
| 2021-11-02 | FTI | Futures | 772.74 | 775.75 | 771.11 | 774.89 | 11076.0 |
| 2021-11-02 | FTUK | Futures | 7191.4 | 7195.4 | 7130.7 | 7165.3 | 84449.0 |
| 2021-11-02 | FVSA | Futures | 65.83 | 65.83 | 63.42 | 63.76 | 14131.0 |
> showing 50 of 123 rows — these rows as CSV