PREVIEW / futures_daily / 2021-08-04
file: by_date/futures_daily/2021/2021-08-04.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-08-04 | ES | Futures | 4956.88 | 4962.79 | 4936.09 | 4940.02 | 1047251.0 |
| 2021-08-04 | NQ | Futures | 17349.15 | 17429.9 | 17301.84 | 17390.1 | 445703.0 |
| 2021-08-04 | YM | Futures | 37907.8 | 37951.2 | 37597.7 | 37615.0 | 145613.0 |
| 2021-08-04 | CL | Futures | 50.9 | 51.25 | 49.11 | 49.33 | 582924.0 |
| 2021-08-04 | GC | Futures | 2116.0 | 2141.9 | 2109.7 | 2116.9 | 244683.0 |
| 2021-08-04 | ZN | Futures | 136.619178 | 137.07779 | 136.25545 | 136.461035 | 1722812.0 |
| 2021-08-04 | A6 | Futures | 0.75839 | 0.76177 | 0.75598 | 0.75721 | 83159.0 |
| 2021-08-04 | AD | Futures | 0.80866 | 0.81008 | 0.80698 | 0.80779 | 60356.0 |
| 2021-08-04 | ALI | Futures | 2993.86 | 2995.0 | 2955.59 | 2960.44 | 1998.0 |
| 2021-08-04 | B | Futures | 48.17 | 48.5 | 46.69 | 46.87 | 370132.0 |
| 2021-08-04 | B6 | Futures | 1.413 | 1.4173 | 1.4098 | 1.4103 | 66033.0 |
| 2021-08-04 | BFX | Futures | 4335.7 | 4355.1 | 4335.7 | 4355.1 | 4.0 |
| 2021-08-04 | BR | Futures | 0.15322 | 0.15443 | 0.15206 | 0.15366 | 10634.0 |
| 2021-08-04 | BTC | Futures | 51308.9 | 53561.6 | 50236.2 | 53420.8 | 3669.0 |
| 2021-08-04 | BZ | Futures | 47.02 | 47.34 | 45.58 | 45.75 | 44616.0 |
| 2021-08-04 | C | Futures | 1452.0 | 1464.0 | 1439.0 | 1443.0 | 6667.0 |
| 2021-08-04 | CB | Futures | 130.857 | 132.381 | 130.797 | 131.178 | 39.0 |
| 2021-08-04 | CC | Futures | 1597.0 | 1615.0 | 1565.0 | 1569.0 | 27184.0 |
| 2021-08-04 | CNH | Futures | 6.2567 | 6.2568 | 6.2433 | 6.2499 | 840.0 |
| 2021-08-04 | CSC | Futures | 2.353 | 2.392 | 2.347 | 2.362 | 119.0 |
| 2021-08-04 | CT | Futures | 83.87 | 84.18 | 83.64 | 83.9 | 39.0 |
| 2021-08-04 | DC | Futures | 20.75 | 21.44 | 20.73 | 20.92 | 296.0 |
| 2021-08-04 | DX | Futures | 88.969 | 89.23 | 88.752 | 89.191 | 16069.0 |
| 2021-08-04 | E1 | Futures | 1.24335 | 1.24649 | 1.23841 | 1.24032 | 20538.0 |
| 2021-08-04 | E6 | Futures | 1.26281 | 1.26674 | 1.25956 | 1.2602 | 153353.0 |
| 2021-08-04 | E7 | Futures | 1.2566 | 1.2605 | 1.2533 | 1.2539 | 4604.0 |
| 2021-08-04 | EBM | Futures | 338.35 | 340.93 | 329.16 | 329.89 | 33344.0 |
| 2021-08-04 | ED | Futures | 96.549 | 96.549 | 96.5442 | 96.549 | 87313.0 |
| 2021-08-04 | ER | Futures | 98.465 | 98.47 | 98.46 | 98.465 | 63155.0 |
| 2021-08-04 | ESG | Futures | 409.99 | 409.99 | 408.51 | 408.51 | 541.0 |
| 2021-08-04 | EW | Futures | 2899.8 | 2907.1 | 2872.1 | 2875.4 | 9235.0 |
| 2021-08-04 | FBON | Futures | 151.59 | 151.81 | 151.37 | 151.46 | 145.0 |
| 2021-08-04 | FBTP | Futures | 141.75 | 142.07 | 141.52 | 141.66 | 97876.0 |
| 2021-08-04 | FBTS | Futures | 110.468 | 110.516 | 110.458 | 110.487 | 35821.0 |
| 2021-08-04 | FCE | Futures | 6732.4 | 6752.3 | 6715.4 | 6731.4 | 45642.0 |
| 2021-08-04 | FDAX | Futures | 16653.4 | 16820.5 | 16649.1 | 16789.4 | 72868.0 |
| 2021-08-04 | FDIV | Futures | 185.49 | 185.59 | 184.61 | 185.15 | 30.0 |
| 2021-08-04 | FDXM | Futures | 16575.0 | 16739.2 | 16568.6 | 16706.1 | 45046.0 |
| 2021-08-04 | FDXS | Futures | 16482.5 | 16630.7 | 16466.6 | 16600.0 | 12048.0 |
| 2021-08-04 | FESX | Futures | 3899.1 | 3929.5 | 3899.1 | 3922.8 | 516674.0 |
| 2021-08-04 | FGBL | Futures | 171.47 | 171.96 | 171.31 | 171.4 | 661170.0 |
| 2021-08-04 | FGBM | Futures | 135.92 | 136.05 | 135.86 | 135.91 | 436388.0 |
| 2021-08-04 | FGBS | Futures | 112.805 | 112.83 | 112.795 | 112.805 | 293909.0 |
| 2021-08-04 | FGBX | Futures | 231.76 | 234.01 | 231.0 | 231.66 | 86818.0 |
| 2021-08-04 | FMWO | Futures | 10920.8 | 10927.8 | 10878.5 | 10885.5 | 2917.0 |
| 2021-08-04 | FOAT | Futures | 158.52 | 158.88 | 158.35 | 158.43 | 157966.0 |
| 2021-08-04 | FTDX | Futures | 3825.6 | 3871.8 | 3825.6 | 3871.8 | 129.0 |
| 2021-08-04 | FTI | Futures | 728.03 | 731.67 | 727.12 | 730.59 | 14749.0 |
| 2021-08-04 | FTUK | Futures | 6927.2 | 6963.6 | 6926.2 | 6943.4 | 60717.0 |
| 2021-08-04 | FVSA | Futures | 89.16 | 90.21 | 87.05 | 88.52 | 21732.0 |
> showing 50 of 125 rows — these rows as CSV