PREVIEW / futures_daily / 2021-07-21
file: by_date/futures_daily/2021/2021-07-21.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-07-21 | ES | Futures | 4854.59 | 4895.62 | 4844.76 | 4890.28 | 1191429.0 |
| 2021-07-21 | NQ | Futures | 16993.52 | 17120.14 | 16922.57 | 17106.58 | 404345.0 |
| 2021-07-21 | YM | Futures | 37329.9 | 37668.2 | 37258.3 | 37614.0 | 136891.0 |
| 2021-07-21 | CL | Futures | 48.1 | 51.03 | 48.09 | 50.88 | 503030.0 |
| 2021-07-21 | GC | Futures | 2117.7 | 2122.2 | 2098.7 | 2109.3 | 218636.0 |
| 2021-07-21 | ZN | Futures | 136.160565 | 136.461035 | 135.607067 | 135.73358 | 1909685.0 |
| 2021-07-21 | A6 | Futures | 0.75167 | 0.75521 | 0.74772 | 0.75464 | 69749.0 |
| 2021-07-21 | AD | Futures | 0.79958 | 0.80937 | 0.79639 | 0.80713 | 89156.0 |
| 2021-07-21 | ALI | Futures | 2808.49 | 2850.76 | 2808.49 | 2836.48 | 1437.0 |
| 2021-07-21 | B | Futures | 45.5 | 47.79 | 45.31 | 47.69 | 306322.0 |
| 2021-07-21 | B6 | Futures | 1.3839 | 1.3936 | 1.3802 | 1.3928 | 94462.0 |
| 2021-07-21 | BFX | Futures | 4234.0 | 4287.1 | 4234.0 | 4287.1 | 3.0 |
| 2021-07-21 | BR | Futures | 0.1523 | 0.15354 | 0.15114 | 0.15314 | 759.0 |
| 2021-07-21 | BTC | Futures | 42204.1 | 46770.0 | 41933.4 | 45046.2 | 9993.0 |
| 2021-07-21 | BZ | Futures | 44.36 | 46.7 | 44.3 | 46.62 | 43341.0 |
| 2021-07-21 | C | Futures | 1377.0 | 1408.0 | 1371.0 | 1383.0 | 8959.0 |
| 2021-07-21 | CB | Futures | 139.602 | 139.602 | 139.602 | 139.602 | 6.0 |
| 2021-07-21 | CC | Futures | 1480.0 | 1499.0 | 1475.0 | 1485.0 | 14155.0 |
| 2021-07-21 | CNH | Futures | 6.2832 | 6.2832 | 6.2592 | 6.2597 | 452.0 |
| 2021-07-21 | CSC | Futures | 2.437 | 2.443 | 2.405 | 2.408 | 295.0 |
| 2021-07-21 | CT | Futures | 81.82 | 82.39 | 81.82 | 82.39 | 5.0 |
| 2021-07-21 | DC | Futures | 22.0 | 22.08 | 21.61 | 21.65 | 641.0 |
| 2021-07-21 | DX | Futures | 89.864 | 90.081 | 89.632 | 89.66 | 18577.0 |
| 2021-07-21 | E1 | Futures | 1.22078 | 1.22628 | 1.21819 | 1.22594 | 16264.0 |
| 2021-07-21 | E6 | Futures | 1.25435 | 1.25701 | 1.25132 | 1.25648 | 137004.0 |
| 2021-07-21 | E7 | Futures | 1.2483 | 1.2508 | 1.2448 | 1.2502 | 3553.0 |
| 2021-07-21 | EBM | Futures | 318.86 | 319.23 | 312.98 | 314.45 | 13401.0 |
| 2021-07-21 | ED | Futures | 96.5297 | 96.5297 | 96.5248 | 96.5297 | 76669.0 |
| 2021-07-21 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 63194.0 |
| 2021-07-21 | ESG | Futures | 403.17 | 404.71 | 401.67 | 404.64 | 634.0 |
| 2021-07-21 | EW | Futures | 2836.3 | 2881.0 | 2829.7 | 2869.3 | 11908.0 |
| 2021-07-21 | FBON | Futures | 150.08 | 150.29 | 149.84 | 149.96 | 265.0 |
| 2021-07-21 | FBTP | Futures | 140.23 | 140.29 | 139.89 | 140.08 | 101062.0 |
| 2021-07-21 | FBTS | Futures | 110.273 | 110.292 | 110.224 | 110.253 | 65668.0 |
| 2021-07-21 | FCE | Futures | 6345.6 | 6471.4 | 6340.7 | 6447.9 | 59696.0 |
| 2021-07-21 | FDAX | Futures | 16361.0 | 16551.6 | 16263.5 | 16507.7 | 83576.0 |
| 2021-07-21 | FDIV | Futures | 183.87 | 185.15 | 183.73 | 185.15 | 57.0 |
| 2021-07-21 | FDXM | Futures | 16276.6 | 16470.6 | 16180.7 | 16425.8 | 55138.0 |
| 2021-07-21 | FDXS | Futures | 16173.2 | 16364.9 | 16080.0 | 16321.5 | 11356.0 |
| 2021-07-21 | FESX | Futures | 3759.8 | 3826.6 | 3738.9 | 3810.0 | 679857.0 |
| 2021-07-21 | FGBL | Futures | 170.27 | 170.6 | 169.92 | 170.03 | 755377.0 |
| 2021-07-21 | FGBM | Futures | 135.48 | 135.57 | 135.39 | 135.44 | 428260.0 |
| 2021-07-21 | FGBS | Futures | 112.684 | 112.699 | 112.669 | 112.684 | 437967.0 |
| 2021-07-21 | FGBX | Futures | 228.45 | 229.24 | 226.31 | 226.72 | 92182.0 |
| 2021-07-21 | FMWO | Futures | 10632.9 | 10741.0 | 10610.6 | 10699.9 | 2411.0 |
| 2021-07-21 | FOAT | Futures | 157.4 | 157.68 | 157.17 | 157.24 | 176025.0 |
| 2021-07-21 | FTDX | Futures | 3659.4 | 3692.7 | 3655.8 | 3681.4 | 121.0 |
| 2021-07-21 | FTI | Futures | 691.32 | 703.53 | 690.8 | 699.29 | 23062.0 |
| 2021-07-21 | FTUK | Futures | 6745.0 | 6838.1 | 6703.2 | 6825.3 | 110577.0 |
| 2021-07-21 | FVSA | Futures | 92.75 | 95.07 | 86.83 | 89.37 | 44509.0 |
> showing 50 of 125 rows — these rows as CSV