PREVIEW / futures_daily / 2021-11-26
file: by_date/futures_daily/2021/2021-11-26.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-11-26 | ES | Futures | 5287.55 | 5306.11 | 5148.91 | 5169.72 | 2068167.0 |
| 2021-11-26 | NQ | Futures | 18865.46 | 18953.1 | 18436.49 | 18509.14 | 680753.0 |
| 2021-11-26 | YM | Futures | 38927.6 | 39060.4 | 37674.2 | 37926.6 | 307938.0 |
| 2021-11-26 | CL | Futures | 58.92 | 59.16 | 50.69 | 51.26 | 844630.0 |
| 2021-11-26 | GC | Futures | 2091.0 | 2122.5 | 2078.5 | 2086.1 | 180641.0 |
| 2021-11-26 | ZN | Futures | 132.049365 | 133.558955 | 131.954023 | 133.400051 | 2089384.0 |
| 2021-11-26 | A6 | Futures | 0.73763 | 0.73906 | 0.72912 | 0.73071 | 141294.0 |
| 2021-11-26 | AD | Futures | 0.80156 | 0.80308 | 0.79313 | 0.7946 | 114952.0 |
| 2021-11-26 | ALI | Futures | 3052.42 | 3052.42 | 2900.67 | 2925.55 | 23.0 |
| 2021-11-26 | B | Futures | 55.75 | 55.78 | 49.24 | 49.66 | 575459.0 |
| 2021-11-26 | B6 | Futures | 1.3528 | 1.3555 | 1.3477 | 1.3534 | 131747.0 |
| 2021-11-26 | BFX | Futures | 4220.3 | 4220.3 | 4204.5 | 4204.5 | 1.0 |
| 2021-11-26 | BR | Futures | 0.14501 | 0.14501 | 0.14501 | 0.14501 | 915.0 |
| 2021-11-26 | BTC | Futures | 75212.1 | 78507.8 | 70239.0 | 71326.7 | 11541.0 |
| 2021-11-26 | BZ | Futures | 54.15 | 54.31 | 47.4 | 47.79 | 65769.0 |
| 2021-11-26 | C | Futures | 1439.0 | 1441.0 | 1398.0 | 1407.0 | 5473.0 |
| 2021-11-26 | CC | Futures | 1562.0 | 1566.0 | 1502.0 | 1507.0 | 35340.0 |
| 2021-11-26 | CNH | Futures | 6.1313 | 6.1375 | 6.1226 | 6.1333 | 774.0 |
| 2021-11-26 | CT | Futures | 111.18 | 111.2 | 107.62 | 108.57 | 22290.0 |
| 2021-11-26 | DX | Futures | 93.463 | 93.501 | 92.767 | 92.858 | 22016.0 |
| 2021-11-26 | E1 | Futures | 1.19928 | 1.2153 | 1.19682 | 1.21418 | 41635.0 |
| 2021-11-26 | E6 | Futures | 1.19029 | 1.20325 | 1.19029 | 1.20123 | 272394.0 |
| 2021-11-26 | E7 | Futures | 1.1839 | 1.1966 | 1.1839 | 1.1947 | 9371.0 |
| 2021-11-26 | EBM | Futures | 444.92 | 444.92 | 437.2 | 439.77 | 5599.0 |
| 2021-11-26 | ED | Futures | 96.5005 | 96.5247 | 96.4981 | 96.5175 | 230310.0 |
| 2021-11-26 | ER | Futures | 98.509 | 98.514 | 98.504 | 98.509 | 62655.0 |
| 2021-11-26 | ESG | Futures | 446.05 | 446.05 | 432.65 | 433.77 | 542.0 |
| 2021-11-26 | EW | Futures | 3090.1 | 3102.5 | 2952.1 | 2987.1 | 15496.0 |
| 2021-11-26 | FBON | Futures | 149.0 | 149.85 | 148.94 | 149.59 | 352.0 |
| 2021-11-26 | FBTP | Futures | 137.53 | 138.23 | 137.35 | 138.15 | 163481.0 |
| 2021-11-26 | FBTS | Futures | 110.371 | 110.477 | 110.371 | 110.468 | 59277.0 |
| 2021-11-26 | FCE | Futures | 7020.0 | 7020.5 | 6731.0 | 6812.5 | 115647.0 |
| 2021-11-26 | FDAX | Futures | 16939.1 | 16939.1 | 16055.1 | 16292.4 | 161284.0 |
| 2021-11-26 | FDIV | Futures | 178.73 | 179.07 | 176.27 | 176.27 | 160.0 |
| 2021-11-26 | FDXM | Futures | 17006.6 | 17006.6 | 16099.7 | 16338.8 | 108969.0 |
| 2021-11-26 | FDXS | Futures | 16863.5 | 16863.5 | 15952.4 | 16187.1 | 55276.0 |
| 2021-11-26 | FESX | Futures | 4090.1 | 4090.5 | 3861.2 | 3911.0 | 1704217.0 |
| 2021-11-26 | FGBL | Futures | 168.66 | 169.91 | 168.61 | 169.79 | 879093.0 |
| 2021-11-26 | FGBM | Futures | 134.96 | 135.41 | 134.96 | 135.37 | 497699.0 |
| 2021-11-26 | FGBS | Futures | 112.845 | 112.94 | 112.84 | 112.88 | 398429.0 |
| 2021-11-26 | FGBX | Futures | 229.63 | 233.38 | 229.52 | 232.8 | 112559.0 |
| 2021-11-26 | FMWO | Futures | 11301.5 | 11313.3 | 11099.9 | 11109.3 | 8997.0 |
| 2021-11-26 | FOAT | Futures | 155.81 | 156.92 | 155.81 | 156.87 | 180986.0 |
| 2021-11-26 | FTDX | Futures | 3879.5 | 3984.2 | 3873.9 | 3918.0 | 186.0 |
| 2021-11-26 | FTI | Futures | 755.95 | 756.47 | 737.63 | 745.51 | 34451.0 |
| 2021-11-26 | FTUK | Futures | 7165.3 | 7177.6 | 6904.0 | 6952.9 | 182029.0 |
| 2021-11-26 | FVSA | Futures | 65.85 | 90.07 | 65.85 | 81.52 | 118278.0 |
| 2021-11-26 | FXXP | Futures | 458.3 | 458.3 | 436.9 | 441.9 | 140186.0 |
| 2021-11-26 | G | Futures | 121.78 | 122.75 | 121.66 | 122.69 | 245477.0 |
| 2021-11-26 | GF | Futures | 249.254 | 255.482 | 249.14 | 253.925 | 5536.0 |
> showing 50 of 121 rows — these rows as CSV