PREVIEW / futures_daily / 2021-07-07
file: by_date/futures_daily/2021/2021-07-07.parquet size: 10 KB rows: 123
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-07-07 | ES | Futures | 4864.99 | 4893.37 | 4856.28 | 4889.44 | 1221078.0 |
| 2021-07-07 | NQ | Futures | 17033.61 | 17171.19 | 16989.48 | 17077.16 | 471450.0 |
| 2021-07-07 | YM | Futures | 37294.1 | 37512.0 | 37214.9 | 37482.8 | 136380.0 |
| 2021-07-07 | CL | Futures | 52.98 | 53.7 | 50.98 | 51.79 | 607971.0 |
| 2021-07-07 | GC | Futures | 2101.8 | 2117.3 | 2098.4 | 2107.8 | 171075.0 |
| 2021-07-07 | ZN | Futures | 134.958683 | 135.32241 | 134.816355 | 135.164268 | 1846518.0 |
| 2021-07-07 | A6 | Futures | 0.769 | 0.7729 | 0.76557 | 0.76803 | 87035.0 |
| 2021-07-07 | AD | Futures | 0.81378 | 0.81611 | 0.80977 | 0.81261 | 80120.0 |
| 2021-07-07 | ALI | Futures | 2914.49 | 2937.74 | 2880.92 | 2898.43 | 850.0 |
| 2021-07-07 | B | Futures | 49.31 | 50.17 | 47.93 | 48.48 | 387427.0 |
| 2021-07-07 | B6 | Futures | 1.4012 | 1.4057 | 1.3966 | 1.4014 | 93973.0 |
| 2021-07-07 | BFX | Futures | 4259.8 | 4268.5 | 4259.8 | 4268.5 | 2.0 |
| 2021-07-07 | BR | Futures | 0.15206 | 0.15362 | 0.15038 | 0.15178 | 1093.0 |
| 2021-07-07 | BTC | Futures | 48151.8 | 50060.8 | 47973.8 | 49434.0 | 3868.0 |
| 2021-07-07 | BZ | Futures | 48.38 | 49.04 | 46.85 | 47.39 | 51166.0 |
| 2021-07-07 | C | Futures | 1439.0 | 1447.0 | 1411.0 | 1424.0 | 3169.0 |
| 2021-07-07 | CB | Futures | 136.393 | 139.201 | 136.393 | 139.201 | 26.0 |
| 2021-07-07 | CC | Futures | 1506.0 | 1516.0 | 1493.0 | 1506.0 | 15736.0 |
| 2021-07-07 | CNH | Futures | 6.2767 | 6.2797 | 6.265 | 6.2713 | 366.0 |
| 2021-07-07 | CSC | Futures | 2.472 | 2.509 | 2.467 | 2.508 | 101.0 |
| 2021-07-07 | CT | Futures | 81.57 | 81.74 | 80.62 | 81.46 | 30.0 |
| 2021-07-07 | DC | Futures | 22.3 | 22.5 | 22.19 | 22.38 | 362.0 |
| 2021-07-07 | DX | Futures | 89.448 | 89.738 | 89.327 | 89.549 | 23689.0 |
| 2021-07-07 | E1 | Futures | 1.21673 | 1.21977 | 1.2137 | 1.21606 | 24485.0 |
| 2021-07-07 | E6 | Futures | 1.25903 | 1.26084 | 1.25483 | 1.25743 | 158339.0 |
| 2021-07-07 | E7 | Futures | 1.2529 | 1.2545 | 1.2485 | 1.2512 | 4392.0 |
| 2021-07-07 | EBM | Futures | 293.48 | 295.32 | 292.38 | 294.22 | 17678.0 |
| 2021-07-07 | ED | Futures | 96.5297 | 96.5442 | 96.5297 | 96.5442 | 132430.0 |
| 2021-07-07 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 23340.0 |
| 2021-07-07 | ESG | Futures | 403.62 | 404.8 | 402.34 | 404.47 | 284.0 |
| 2021-07-07 | EW | Futures | 2870.2 | 2888.2 | 2847.8 | 2875.9 | 9799.0 |
| 2021-07-07 | FBON | Futures | 149.11 | 149.33 | 148.97 | 149.14 | 620.0 |
| 2021-07-07 | FBTP | Futures | 139.35 | 139.67 | 139.26 | 139.39 | 115344.0 |
| 2021-07-07 | FBTS | Futures | 110.263 | 110.292 | 110.234 | 110.244 | 48990.0 |
| 2021-07-07 | FCE | Futures | 6482.6 | 6524.9 | 6471.2 | 6502.5 | 50169.0 |
| 2021-07-07 | FDAX | Futures | 16589.1 | 16818.4 | 16563.4 | 16784.1 | 71773.0 |
| 2021-07-07 | FDIV | Futures | 187.11 | 187.21 | 186.13 | 187.21 | 45.0 |
| 2021-07-07 | FDXM | Futures | 16512.2 | 16737.1 | 16481.2 | 16700.8 | 52402.0 |
| 2021-07-07 | FDXS | Futures | 16404.1 | 16626.5 | 16400.9 | 16594.7 | 5337.0 |
| 2021-07-07 | FESX | Futures | 3823.3 | 3862.6 | 3817.6 | 3853.2 | 579750.0 |
| 2021-07-07 | FGBL | Futures | 168.16 | 168.81 | 168.03 | 168.57 | 782430.0 |
| 2021-07-07 | FGBM | Futures | 134.85 | 135.02 | 134.81 | 134.94 | 429321.0 |
| 2021-07-07 | FGBS | Futures | 112.599 | 112.614 | 112.594 | 112.604 | 247593.0 |
| 2021-07-07 | FGBX | Futures | 220.48 | 222.77 | 219.9 | 221.98 | 93636.0 |
| 2021-07-07 | FMWO | Futures | 10724.6 | 10775.1 | 10694.0 | 10742.2 | 4557.0 |
| 2021-07-07 | FOAT | Futures | 155.85 | 156.45 | 155.81 | 156.22 | 157477.0 |
| 2021-07-07 | FTDX | Futures | 3694.8 | 3740.4 | 3683.5 | 3728.1 | 60.0 |
| 2021-07-07 | FTI | Futures | 697.43 | 703.28 | 696.62 | 702.23 | 19428.0 |
| 2021-07-07 | FTUK | Futures | 6917.8 | 6981.8 | 6910.5 | 6970.5 | 79665.0 |
| 2021-07-07 | FVSA | Futures | 82.98 | 84.58 | 80.46 | 82.75 | 24452.0 |
> showing 50 of 123 rows — these rows as CSV