PREVIEW / futures_daily / 2021-07-28
file: by_date/futures_daily/2021/2021-07-28.parquet size: 10 KB rows: 124
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-28 | ES | Futures | 4923.44 | 4954.64 | 4920.63 | 4938.9 | 1221313.0 |
| 2021-07-28 | NQ | Futures | 17161.96 | 17391.26 | 17150.71 | 17318.57 | 577186.0 |
| 2021-07-28 | YM | Futures | 37782.0 | 37970.7 | 37695.3 | 37771.2 | 146913.0 |
| 2021-07-28 | CL | Futures | 52.04 | 52.55 | 51.9 | 52.39 | 318911.0 |
| 2021-07-28 | GC | Futures | 2102.8 | 2116.2 | 2094.8 | 2105.3 | 198595.0 |
| 2021-07-28 | ZN | Futures | 136.018237 | 136.192193 | 135.701952 | 135.891723 | 1555292.0 |
| 2021-07-28 | A6 | Futures | 0.75495 | 0.75716 | 0.75049 | 0.75577 | 92155.0 |
| 2021-07-28 | AD | Futures | 0.80455 | 0.81008 | 0.80435 | 0.80911 | 77728.0 |
| 2021-07-28 | ALI | Futures | 2870.76 | 2942.16 | 2870.76 | 2926.74 | 101.0 |
| 2021-07-28 | B | Futures | 49.15 | 49.51 | 48.96 | 49.2 | 251801.0 |
| 2021-07-28 | B6 | Futures | 1.4097 | 1.4129 | 1.4057 | 1.4122 | 91409.0 |
| 2021-07-28 | BFX | Futures | 4293.8 | 4322.4 | 4293.8 | 4322.4 | 6.0 |
| 2021-07-28 | BR | Futures | 0.15386 | 0.15615 | 0.15366 | 0.15559 | 14206.0 |
| 2021-07-28 | BTC | Futures | 51329.0 | 54909.2 | 51268.7 | 54245.4 | 4516.0 |
| 2021-07-28 | BZ | Futures | 47.93 | 48.31 | 47.78 | 48.02 | 28718.0 |
| 2021-07-28 | C | Futures | 1439.0 | 1467.0 | 1437.0 | 1455.0 | 8561.0 |
| 2021-07-28 | CB | Futures | 130.777 | 130.777 | 130.376 | 130.376 | 19.0 |
| 2021-07-28 | CC | Futures | 1565.0 | 1604.0 | 1558.0 | 1592.0 | 20621.0 |
| 2021-07-28 | CNH | Futures | 6.319 | 6.319 | 6.2813 | 6.2831 | 805.0 |
| 2021-07-28 | CSC | Futures | 2.437 | 2.437 | 2.409 | 2.411 | 129.0 |
| 2021-07-28 | CT | Futures | 84.16 | 84.63 | 83.97 | 84.08 | 41.0 |
| 2021-07-28 | DC | Futures | 21.72 | 21.73 | 21.47 | 21.52 | 352.0 |
| 2021-07-28 | DX | Futures | 89.371 | 89.685 | 89.153 | 89.232 | 28214.0 |
| 2021-07-28 | E1 | Futures | 1.22987 | 1.2356 | 1.22639 | 1.23414 | 22916.0 |
| 2021-07-28 | E6 | Futures | 1.25829 | 1.26164 | 1.25334 | 1.26041 | 192120.0 |
| 2021-07-28 | E7 | Futures | 1.2521 | 1.2555 | 1.2472 | 1.2541 | 5804.0 |
| 2021-07-28 | EBM | Futures | 313.34 | 318.49 | 313.34 | 318.12 | 19810.0 |
| 2021-07-28 | ED | Futures | 96.5345 | 96.5393 | 96.5345 | 96.5345 | 88449.0 |
| 2021-07-28 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.465 | 20889.0 |
| 2021-07-28 | ESG | Futures | 409.21 | 409.21 | 406.53 | 407.75 | 477.0 |
| 2021-07-28 | EW | Futures | 2852.9 | 2890.1 | 2834.5 | 2874.7 | 8495.0 |
| 2021-07-28 | FBON | Futures | 151.13 | 151.13 | 150.76 | 150.87 | 265.0 |
| 2021-07-28 | FBTP | Futures | 140.98 | 141.14 | 140.84 | 141.04 | 89674.0 |
| 2021-07-28 | FBTS | Futures | 110.36 | 110.39 | 110.341 | 110.39 | 35705.0 |
| 2021-07-28 | FCE | Futures | 6538.8 | 6599.1 | 6513.3 | 6592.6 | 43838.0 |
| 2021-07-28 | FDAX | Futures | 16648.0 | 16686.6 | 16576.3 | 16669.5 | 57298.0 |
| 2021-07-28 | FDIV | Futures | 186.23 | 186.32 | 186.23 | 186.32 | 20.0 |
| 2021-07-28 | FDXM | Futures | 16551.6 | 16604.9 | 16494.0 | 16586.8 | 40397.0 |
| 2021-07-28 | FDXS | Futures | 16486.7 | 16495.2 | 16393.5 | 16481.4 | 6622.0 |
| 2021-07-28 | FESX | Futures | 3858.9 | 3886.3 | 3842.3 | 3883.5 | 511731.0 |
| 2021-07-28 | FGBL | Futures | 170.75 | 171.13 | 170.68 | 170.89 | 628190.0 |
| 2021-07-28 | FGBM | Futures | 135.71 | 135.87 | 135.68 | 135.8 | 392497.0 |
| 2021-07-28 | FGBS | Futures | 112.754 | 112.785 | 112.749 | 112.775 | 330388.0 |
| 2021-07-28 | FGBX | Futures | 228.96 | 229.73 | 228.32 | 228.84 | 78973.0 |
| 2021-07-28 | FMWO | Futures | 10839.7 | 10859.7 | 10798.6 | 10837.4 | 1889.0 |
| 2021-07-28 | FOAT | Futures | 157.79 | 157.98 | 157.7 | 157.83 | 145826.0 |
| 2021-07-28 | FTDX | Futures | 3727.6 | 3753.8 | 3719.4 | 3753.8 | 4.0 |
| 2021-07-28 | FTI | Futures | 704.87 | 713.53 | 703.81 | 712.72 | 16963.0 |
| 2021-07-28 | FTUK | Futures | 6825.8 | 6848.9 | 6797.7 | 6844.0 | 73510.0 |
| 2021-07-28 | FVSA | Futures | 90.0 | 91.69 | 85.99 | 88.74 | 28186.0 |
> showing 50 of 124 rows — these rows as CSV