PREVIEW / futures_daily / 2021-12-17
file: by_date/futures_daily/2021/2021-12-17.parquet size: 10 KB rows: 126
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-12-17 | ES | Futures | 5252.96 | 5257.47 | 5169.62 | 5192.15 | 2472118.0 |
| 2021-12-17 | NQ | Futures | 18302.81 | 18393.3 | 18042.01 | 18199.07 | 800579.0 |
| 2021-12-17 | YM | Futures | 39091.3 | 39137.2 | 38360.4 | 38456.4 | 271461.0 |
| 2021-12-17 | CL | Futures | 54.29 | 54.48 | 52.7 | 53.48 | 351303.0 |
| 2021-12-17 | GC | Futures | 2101.7 | 2118.3 | 2095.9 | 2105.7 | 156607.0 |
| 2021-12-17 | ZN | Futures | 134.055653 | 134.359127 | 133.863985 | 134.087598 | 1175627.0 |
| 2021-12-17 | A6 | Futures | 0.73609 | 0.73629 | 0.73009 | 0.73137 | 69566.0 |
| 2021-12-17 | AD | Futures | 0.79405 | 0.79415 | 0.78629 | 0.78776 | 66491.0 |
| 2021-12-17 | ALI | Futures | 2954.6 | 2988.66 | 2947.74 | 2977.95 | 1122.0 |
| 2021-12-17 | B | Futures | 51.68 | 52.01 | 50.39 | 51.0 | 231412.0 |
| 2021-12-17 | B6 | Futures | 1.3513 | 1.3526 | 1.3415 | 1.3435 | 86291.0 |
| 2021-12-17 | BR | Futures | 0.1431 | 0.14385 | 0.14269 | 0.14339 | 1093.0 |
| 2021-12-17 | BTC | Futures | 62730.3 | 62913.7 | 59513.2 | 60607.4 | 4533.0 |
| 2021-12-17 | BZ | Futures | 49.74 | 50.04 | 48.48 | 49.08 | 26087.0 |
| 2021-12-17 | C | Futures | 1366.0 | 1374.0 | 1359.0 | 1362.0 | 4958.0 |
| 2021-12-17 | CB | Futures | 162.694 | 163.279 | 162.108 | 162.304 | 37.0 |
| 2021-12-17 | CC | Futures | 1598.0 | 1604.0 | 1559.0 | 1571.0 | 15934.0 |
| 2021-12-17 | CNH | Futures | 6.0997 | 6.115 | 6.0968 | 6.1087 | 637.0 |
| 2021-12-17 | CSC | Futures | 2.572 | 2.589 | 2.572 | 2.574 | 18.0 |
| 2021-12-17 | CT | Futures | 106.08 | 106.26 | 103.87 | 104.22 | 12205.0 |
| 2021-12-17 | DC | Futures | 24.76 | 24.82 | 24.69 | 24.71 | 145.0 |
| 2021-12-17 | DX | Futures | 92.754 | 93.407 | 92.624 | 93.303 | 13484.0 |
| 2021-12-17 | E1 | Futures | 1.21718 | 1.21975 | 1.21038 | 1.21138 | 17154.0 |
| 2021-12-17 | E6 | Futures | 1.20345 | 1.2053 | 1.19312 | 1.19492 | 139763.0 |
| 2021-12-17 | E7 | Futures | 1.1965 | 1.1985 | 1.1864 | 1.1882 | 4319.0 |
| 2021-12-17 | EBM | Futures | 398.0 | 400.5 | 395.49 | 398.71 | 18385.0 |
| 2021-12-17 | ED | Futures | 96.5059 | 96.5204 | 96.4768 | 96.4914 | 167521.0 |
| 2021-12-17 | ER | Futures | 98.519 | 98.529 | 98.514 | 98.524 | 52306.0 |
| 2021-12-17 | ESG | Futures | 434.35 | 436.71 | 429.09 | 431.68 | 1910.0 |
| 2021-12-17 | EW | Futures | 2945.3 | 2965.2 | 2906.3 | 2934.3 | 19377.0 |
| 2021-12-17 | FBON | Futures | 150.55 | 150.93 | 150.34 | 150.85 | 67.0 |
| 2021-12-17 | FBTP | Futures | 137.83 | 138.58 | 137.74 | 138.36 | 82413.0 |
| 2021-12-17 | FBTS | Futures | 110.312 | 110.429 | 110.303 | 110.39 | 31078.0 |
| 2021-12-17 | FCE | Futures | 7017.1 | 7062.5 | 6931.9 | 6974.7 | 74671.0 |
| 2021-12-17 | FDAX | Futures | 16717.8 | 16742.5 | 16531.1 | 16665.2 | 84379.0 |
| 2021-12-17 | FDXM | Futures | 16789.1 | 16816.1 | 16603.7 | 16738.5 | 57581.0 |
| 2021-12-17 | FDXS | Futures | 16633.2 | 16661.0 | 16453.8 | 16586.2 | 21174.0 |
| 2021-12-17 | FESX | Futures | 4014.8 | 4018.2 | 3952.3 | 3986.0 | 906743.0 |
| 2021-12-17 | FEU3 | Futures | 99.208 | 99.218 | 99.208 | 99.218 | 40.0 |
| 2021-12-17 | FGBL | Futures | 169.78 | 170.18 | 169.61 | 169.95 | 405405.0 |
| 2021-12-17 | FGBM | Futures | 135.01 | 135.17 | 134.94 | 135.12 | 272905.0 |
| 2021-12-17 | FGBS | Futures | 112.769 | 112.845 | 112.759 | 112.825 | 240458.0 |
| 2021-12-17 | FGBX | Futures | 232.84 | 234.56 | 232.52 | 233.82 | 46180.0 |
| 2021-12-17 | FMWO | Futures | 11247.3 | 11247.3 | 11135.2 | 11135.2 | 743.0 |
| 2021-12-17 | FOAT | Futures | 157.14 | 157.62 | 157.08 | 157.45 | 88342.0 |
| 2021-12-17 | FSMX | Futures | 36143.3 | 36143.3 | 35947.1 | 36132.8 | 775.0 |
| 2021-12-17 | FTDX | Futures | 3931.1 | 3944.6 | 3892.9 | 3936.3 | 56.0 |
| 2021-12-17 | FTI | Futures | 744.43 | 746.4 | 734.07 | 740.15 | 27615.0 |
| 2021-12-17 | FTUK | Futures | 7156.3 | 7192.6 | 7132.4 | 7175.7 | 105394.0 |
| 2021-12-17 | FVSA | Futures | 74.35 | 77.78 | 73.57 | 75.28 | 27567.0 |
> showing 50 of 126 rows — these rows as CSV