PREVIEW / futures_daily / 2021-09-20
file: by_date/futures_daily/2021/2021-09-20.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-09-20 | ES | Futures | 4962.74 | 4969.77 | 4830.0 | 4891.31 | 1006857.0 |
| 2021-09-20 | NQ | Futures | 17624.67 | 17687.23 | 17075.2 | 17308.14 | 451735.0 |
| 2021-09-20 | YM | Futures | 37428.3 | 37442.5 | 36425.2 | 36817.9 | 122202.0 |
| 2021-09-20 | CL | Futures | 52.88 | 52.97 | 51.33 | 51.65 | 364797.0 |
| 2021-09-20 | GC | Futures | 2046.5 | 2063.1 | 2032.7 | 2057.7 | 174076.0 |
| 2021-09-20 | ZN | Futures | 135.036764 | 135.624709 | 135.004983 | 135.529367 | 1709628.0 |
| 2021-09-20 | A6 | Futures | 0.74485 | 0.74537 | 0.74034 | 0.74219 | 78225.0 |
| 2021-09-20 | AD | Futures | 0.79537 | 0.79557 | 0.78714 | 0.79131 | 63706.0 |
| 2021-09-20 | ALI | Futures | 3242.7 | 3281.01 | 3230.59 | 3256.78 | 7.0 |
| 2021-09-20 | B | Futures | 50.72 | 50.77 | 49.5 | 49.77 | 313752.0 |
| 2021-09-20 | B6 | Futures | 1.3938 | 1.3944 | 1.3848 | 1.3853 | 77172.0 |
| 2021-09-20 | BFX | Futures | 4251.9 | 4251.9 | 4133.4 | 4162.5 | 38.0 |
| 2021-09-20 | BR | Futures | 0.15076 | 0.15149 | 0.1493 | 0.14954 | 826.0 |
| 2021-09-20 | BTC | Futures | 63136.0 | 63408.9 | 56411.6 | 58295.7 | 8330.0 |
| 2021-09-20 | BZ | Futures | 49.46 | 49.46 | 48.23 | 48.49 | 28251.0 |
| 2021-09-20 | C | Futures | 1575.0 | 1579.0 | 1557.0 | 1559.0 | 6572.0 |
| 2021-09-20 | CB | Futures | 142.292 | 144.951 | 141.248 | 141.248 | 16.0 |
| 2021-09-20 | CC | Futures | 1702.0 | 1702.0 | 1656.0 | 1665.0 | 24454.0 |
| 2021-09-20 | CNH | Futures | 6.2474 | 6.2557 | 6.2409 | 6.2532 | 382.0 |
| 2021-09-20 | CSC | Futures | 2.452 | 2.459 | 2.431 | 2.434 | 151.0 |
| 2021-09-20 | CT | Futures | 85.43 | 85.87 | 83.13 | 83.13 | 56.0 |
| 2021-09-20 | DC | Futures | 22.28 | 22.33 | 21.99 | 22.14 | 375.0 |
| 2021-09-20 | DX | Futures | 90.081 | 90.288 | 90.023 | 90.106 | 21368.0 |
| 2021-09-20 | E1 | Futures | 1.20399 | 1.21048 | 1.20253 | 1.20959 | 20812.0 |
| 2021-09-20 | E6 | Futures | 1.24798 | 1.24904 | 1.24516 | 1.24777 | 132831.0 |
| 2021-09-20 | E7 | Futures | 1.2407 | 1.2421 | 1.2383 | 1.2409 | 3496.0 |
| 2021-09-20 | EBM | Futures | 362.62 | 362.99 | 359.68 | 361.15 | 18928.0 |
| 2021-09-20 | ED | Futures | 96.5441 | 96.5489 | 96.5392 | 96.5441 | 142231.0 |
| 2021-09-20 | ER | Futures | 98.48 | 98.48 | 98.475 | 98.48 | 26882.0 |
| 2021-09-20 | ESG | Futures | 406.18 | 406.18 | 398.53 | 403.41 | 671.0 |
| 2021-09-20 | EW | Futures | 2868.8 | 2868.8 | 2790.5 | 2827.5 | 10504.0 |
| 2021-09-20 | FBON | Futures | 150.14 | 150.42 | 150.04 | 150.25 | 1067.0 |
| 2021-09-20 | FBTP | Futures | 139.93 | 140.35 | 139.72 | 140.03 | 119546.0 |
| 2021-09-20 | FBTS | Futures | 110.409 | 110.458 | 110.371 | 110.429 | 62721.0 |
| 2021-09-20 | FCE | Futures | 6501.9 | 6510.4 | 6387.1 | 6454.8 | 88543.0 |
| 2021-09-20 | FDAX | Futures | 16530.8 | 16559.6 | 16030.5 | 16139.6 | 124549.0 |
| 2021-09-20 | FDIV | Futures | 179.51 | 179.51 | 177.89 | 178.24 | 127.0 |
| 2021-09-20 | FDXM | Futures | 16573.5 | 16612.1 | 16075.1 | 16185.5 | 121769.0 |
| 2021-09-20 | FDXS | Futures | 16414.3 | 16453.6 | 15925.8 | 16035.2 | 35714.0 |
| 2021-09-20 | FESX | Futures | 3925.8 | 3928.7 | 3805.6 | 3843.9 | 1189970.0 |
| 2021-09-20 | FEU3 | Futures | 99.203 | 99.208 | 99.203 | 99.208 | 2.0 |
| 2021-09-20 | FGBL | Futures | 168.48 | 169.3 | 168.46 | 169.02 | 703180.0 |
| 2021-09-20 | FGBM | Futures | 134.97 | 135.2 | 134.96 | 135.13 | 441264.0 |
| 2021-09-20 | FGBS | Futures | 112.669 | 112.714 | 112.669 | 112.699 | 304975.0 |
| 2021-09-20 | FGBX | Futures | 222.16 | 225.07 | 222.14 | 223.99 | 69541.0 |
| 2021-09-20 | FMWO | Futures | 10964.3 | 10985.5 | 10674.2 | 10799.2 | 3678.0 |
| 2021-09-20 | FOAT | Futures | 156.21 | 156.86 | 156.21 | 156.61 | 149961.0 |
| 2021-09-20 | FTDX | Futures | 3928.8 | 3941.1 | 3884.6 | 3922.6 | 97.0 |
| 2021-09-20 | FTI | Futures | 746.56 | 747.7 | 733.05 | 741.23 | 30164.0 |
| 2021-09-20 | FTUK | Futures | 6854.6 | 6862.0 | 6708.0 | 6783.0 | 139700.0 |
> showing 50 of 126 rows — these rows as CSV