PREVIEW / futures_daily / 2021-11-04
file: by_date/futures_daily/2021/2021-11-04.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-11-04 | ES | Futures | 5232.43 | 5260.28 | 5231.59 | 5256.9 | 1169886.0 |
| 2021-11-04 | NQ | Futures | 18599.66 | 18883.91 | 18599.66 | 18831.73 | 524361.0 |
| 2021-11-04 | YM | Futures | 39198.5 | 39251.9 | 39022.3 | 39179.0 | 133199.0 |
| 2021-11-04 | CL | Futures | 59.41 | 61.81 | 57.98 | 58.4 | 701119.0 |
| 2021-11-04 | GC | Futures | 2064.9 | 2100.3 | 2064.2 | 2092.4 | 222609.0 |
| 2021-11-04 | ZN | Futures | 132.812105 | 133.670188 | 132.780325 | 133.543065 | 1713598.0 |
| 2021-11-04 | A6 | Futures | 0.76387 | 0.76602 | 0.75695 | 0.75869 | 84912.0 |
| 2021-11-04 | AD | Futures | 0.81938 | 0.82014 | 0.81394 | 0.81471 | 63116.0 |
| 2021-11-04 | ALI | Futures | 2993.35 | 2995.85 | 2839.91 | 2867.15 | 1013.0 |
| 2021-11-04 | B | Futures | 55.77 | 57.76 | 54.82 | 55.06 | 472428.0 |
| 2021-11-04 | B6 | Futures | 1.3892 | 1.3905 | 1.3674 | 1.3698 | 168846.0 |
| 2021-11-04 | BFX | Futures | 4456.4 | 4469.7 | 4449.3 | 4469.7 | 35.0 |
| 2021-11-04 | BR | Futures | 0.14492 | 0.14553 | 0.14358 | 0.14374 | 3507.0 |
| 2021-11-04 | BTC | Futures | 83585.1 | 83618.0 | 80173.2 | 80831.8 | 5009.0 |
| 2021-11-04 | BZ | Futures | 54.29 | 56.41 | 53.53 | 53.77 | 72626.0 |
| 2021-11-04 | C | Futures | 1430.0 | 1450.0 | 1424.0 | 1441.0 | 6036.0 |
| 2021-11-04 | CB | Futures | 152.674 | 153.265 | 152.359 | 152.871 | 40.0 |
| 2021-11-04 | CC | Futures | 1557.0 | 1579.0 | 1553.0 | 1562.0 | 25258.0 |
| 2021-11-04 | CNH | Futures | 6.1379 | 6.1459 | 6.1379 | 6.1412 | 355.0 |
| 2021-11-04 | CSC | Futures | 2.457 | 2.473 | 2.406 | 2.411 | 114.0 |
| 2021-11-04 | CT | Futures | 110.68 | 110.68 | 108.44 | 108.7 | 20157.0 |
| 2021-11-04 | DC | Futures | 23.17 | 23.56 | 22.91 | 22.97 | 535.0 |
| 2021-11-04 | DX | Futures | 90.651 | 91.279 | 90.651 | 91.154 | 21384.0 |
| 2021-11-04 | E1 | Futures | 1.2293 | 1.23042 | 1.22583 | 1.22829 | 22322.0 |
| 2021-11-04 | E6 | Futures | 1.23465 | 1.23512 | 1.22556 | 1.22832 | 172189.0 |
| 2021-11-04 | E7 | Futures | 1.2279 | 1.2284 | 1.2187 | 1.2216 | 3776.0 |
| 2021-11-04 | EBM | Futures | 428.02 | 429.49 | 425.08 | 426.18 | 13478.0 |
| 2021-11-04 | ED | Futures | 96.5199 | 96.5392 | 96.5199 | 96.5392 | 183321.0 |
| 2021-11-04 | ER | Futures | 98.499 | 98.499 | 98.494 | 98.499 | 36637.0 |
| 2021-11-04 | ESG | Futures | 437.4 | 440.0 | 437.37 | 440.0 | 1256.0 |
| 2021-11-04 | EW | Futures | 3105.7 | 3125.9 | 3087.1 | 3094.6 | 15162.0 |
| 2021-11-04 | FBON | Futures | 148.07 | 149.19 | 148.06 | 149.06 | 1060.0 |
| 2021-11-04 | FBTP | Futures | 136.89 | 138.41 | 136.89 | 138.26 | 165904.0 |
| 2021-11-04 | FBTS | Futures | 110.128 | 110.351 | 110.128 | 110.332 | 109567.0 |
| 2021-11-04 | FCE | Futures | 7066.6 | 7077.7 | 7038.7 | 7065.0 | 44202.0 |
| 2021-11-04 | FDAX | Futures | 17127.2 | 17160.3 | 17085.5 | 17127.2 | 56462.0 |
| 2021-11-04 | FDIV | Futures | 186.86 | 186.86 | 186.52 | 186.52 | 15.0 |
| 2021-11-04 | FDXM | Futures | 17172.7 | 17209.1 | 17134.1 | 17175.9 | 38751.0 |
| 2021-11-04 | FDXS | Futures | 17014.3 | 17048.3 | 16974.0 | 17016.4 | 16527.0 |
| 2021-11-04 | FESX | Futures | 4141.8 | 4149.4 | 4131.2 | 4140.3 | 567464.0 |
| 2021-11-04 | FGBL | Futures | 166.67 | 167.81 | 166.53 | 167.7 | 894289.0 |
| 2021-11-04 | FGBM | Futures | 134.19 | 134.77 | 134.13 | 134.68 | 654843.0 |
| 2021-11-04 | FGBS | Futures | 112.569 | 112.704 | 112.559 | 112.664 | 381018.0 |
| 2021-11-04 | FGBX | Futures | 224.38 | 225.98 | 223.86 | 225.4 | 106186.0 |
| 2021-11-04 | FMWO | Futures | 11432.4 | 11465.4 | 11423.0 | 11444.2 | 4018.0 |
| 2021-11-04 | FOAT | Futures | 154.41 | 155.56 | 154.29 | 155.44 | 251780.0 |
| 2021-11-04 | FTDX | Futures | 4030.9 | 4048.3 | 4021.1 | 4046.8 | 80.0 |
| 2021-11-04 | FTI | Futures | 782.92 | 785.5 | 781.25 | 783.58 | 16641.0 |
| 2021-11-04 | FTUK | Futures | 7158.8 | 7186.5 | 7140.1 | 7181.6 | 94155.0 |
| 2021-11-04 | FVSA | Futures | 60.32 | 61.35 | 59.11 | 60.49 | 23054.0 |
> showing 50 of 126 rows — these rows as CSV