PREVIEW / futures_daily / 2021-11-29
file: by_date/futures_daily/2021/2021-11-29.parquet size: 10 KB rows: 125
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-29 | ES | Futures | 5162.13 | 5252.96 | 5161.85 | 5231.87 | 2014967.0 |
| 2021-11-29 | NQ | Futures | 18503.95 | 18955.12 | 18494.15 | 18900.92 | 597936.0 |
| 2021-11-29 | YM | Futures | 37799.3 | 38348.8 | 37798.2 | 38164.9 | 251023.0 |
| 2021-11-29 | CL | Futures | 52.07 | 54.85 | 51.79 | 52.61 | 675090.0 |
| 2021-11-29 | GC | Futures | 2094.4 | 2101.7 | 2079.0 | 2082.7 | 151365.0 |
| 2021-11-29 | ZN | Futures | 133.193475 | 133.558955 | 132.859777 | 133.272927 | 908346.0 |
| 2021-11-29 | A6 | Futures | 0.7303 | 0.73394 | 0.72927 | 0.73076 | 91887.0 |
| 2021-11-29 | AD | Futures | 0.79481 | 0.79806 | 0.79349 | 0.79491 | 84005.0 |
| 2021-11-29 | ALI | Futures | 2964.11 | 2965.23 | 2937.28 | 2937.28 | 7.0 |
| 2021-11-29 | B | Futures | 50.39 | 52.67 | 50.05 | 50.79 | 494405.0 |
| 2021-11-29 | B6 | Futures | 1.3532 | 1.3564 | 1.3487 | 1.3492 | 86326.0 |
| 2021-11-29 | BFX | Futures | 4243.2 | 4243.2 | 4217.7 | 4217.7 | 54.0 |
| 2021-11-29 | BR | Futures | 0.14695 | 0.14695 | 0.14377 | 0.14455 | 218.0 |
| 2021-11-29 | BTC | Futures | 73764.1 | 77688.8 | 73764.1 | 76620.8 | 5946.0 |
| 2021-11-29 | BZ | Futures | 47.7 | 50.7 | 47.7 | 48.88 | 57740.0 |
| 2021-11-29 | C | Futures | 1421.0 | 1425.0 | 1397.0 | 1399.0 | 1855.0 |
| 2021-11-29 | CB | Futures | 156.061 | 157.232 | 156.061 | 157.232 | 8.0 |
| 2021-11-29 | CC | Futures | 1512.0 | 1526.0 | 1492.0 | 1496.0 | 25414.0 |
| 2021-11-29 | CNH | Futures | 6.1301 | 6.1307 | 6.1178 | 6.1234 | 639.0 |
| 2021-11-29 | CSC | Futures | 2.452 | 2.475 | 2.452 | 2.471 | 64.0 |
| 2021-11-29 | CT | Futures | 109.91 | 110.32 | 107.92 | 108.21 | 15046.0 |
| 2021-11-29 | DC | Futures | 23.64 | 23.64 | 23.29 | 23.49 | 66.0 |
| 2021-11-29 | DX | Futures | 92.931 | 93.192 | 92.897 | 93.084 | 15614.0 |
| 2021-11-29 | E1 | Futures | 1.21396 | 1.21418 | 1.20824 | 1.21149 | 21954.0 |
| 2021-11-29 | E6 | Futures | 1.20059 | 1.20102 | 1.1965 | 1.19804 | 149519.0 |
| 2021-11-29 | E7 | Futures | 1.1943 | 1.1943 | 1.1899 | 1.1915 | 3885.0 |
| 2021-11-29 | EBM | Futures | 441.61 | 444.55 | 420.67 | 421.77 | 7638.0 |
| 2021-11-29 | ED | Futures | 96.5175 | 96.5271 | 96.5102 | 96.5223 | 234700.0 |
| 2021-11-29 | ER | Futures | 98.504 | 98.509 | 98.504 | 98.509 | 63323.0 |
| 2021-11-29 | ESG | Futures | 436.59 | 441.17 | 436.59 | 439.59 | 2018.0 |
| 2021-11-29 | EW | Futures | 3005.6 | 3029.2 | 2971.5 | 2989.9 | 15854.0 |
| 2021-11-29 | FBON | Futures | 149.58 | 149.58 | 149.02 | 149.5 | 214.0 |
| 2021-11-29 | FBTP | Futures | 138.04 | 138.26 | 137.54 | 137.91 | 117936.0 |
| 2021-11-29 | FBTS | Futures | 110.477 | 110.487 | 110.38 | 110.439 | 39312.0 |
| 2021-11-29 | FCE | Futures | 6922.3 | 6937.0 | 6832.7 | 6849.4 | 94954.0 |
| 2021-11-29 | FDAX | Futures | 16405.7 | 16523.3 | 16279.6 | 16326.6 | 102448.0 |
| 2021-11-29 | FDIV | Futures | 177.26 | 178.53 | 176.52 | 176.52 | 65.0 |
| 2021-11-29 | FDXM | Futures | 16448.1 | 16573.5 | 16325.9 | 16373.1 | 59269.0 |
| 2021-11-29 | FDXS | Futures | 16258.2 | 16415.4 | 16176.5 | 16221.1 | 43093.0 |
| 2021-11-29 | FESX | Futures | 3950.2 | 3991.4 | 3918.6 | 3932.1 | 1206132.0 |
| 2021-11-29 | FGBL | Futures | 169.49 | 169.83 | 169.11 | 169.48 | 671180.0 |
| 2021-11-29 | FGBM | Futures | 135.28 | 135.37 | 135.07 | 135.25 | 429070.0 |
| 2021-11-29 | FGBS | Futures | 112.855 | 112.89 | 112.825 | 112.865 | 268362.0 |
| 2021-11-29 | FGBX | Futures | 231.96 | 232.88 | 231.22 | 232.58 | 85173.0 |
| 2021-11-29 | FMWO | Futures | 11208.3 | 11269.7 | 11165.9 | 11193.0 | 12117.0 |
| 2021-11-29 | FOAT | Futures | 156.56 | 156.94 | 156.31 | 156.62 | 178123.0 |
| 2021-11-29 | FTDX | Futures | 3961.6 | 3961.6 | 3918.0 | 3944.7 | 160.0 |
| 2021-11-29 | FTI | Futures | 755.14 | 758.0 | 749.7 | 750.7 | 22133.0 |
| 2021-11-29 | FTUK | Futures | 7041.3 | 7069.5 | 6991.9 | 7027.5 | 128167.0 |
| 2021-11-29 | FVSA | Futures | 79.15 | 81.05 | 73.45 | 78.04 | 64783.0 |
> showing 50 of 125 rows — these rows as CSV