PREVIEW / futures_daily / 2021-07-27
file: by_date/futures_daily/2021/2021-07-27.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-27 | ES | Futures | 4963.63 | 4963.91 | 4906.3 | 4939.74 | 1575473.0 |
| 2021-07-27 | NQ | Futures | 17449.8 | 17457.02 | 17044.86 | 17245.03 | 671793.0 |
| 2021-07-27 | YM | Futures | 37993.5 | 37994.6 | 37693.1 | 37900.2 | 167090.0 |
| 2021-07-27 | CL | Futures | 52.27 | 52.35 | 51.45 | 51.86 | 333123.0 |
| 2021-07-27 | GC | Futures | 2101.7 | 2111.1 | 2096.4 | 2104.6 | 77687.0 |
| 2021-07-27 | ZN | Futures | 135.73358 | 136.192193 | 135.717766 | 136.097308 | 1204331.0 |
| 2021-07-27 | A6 | Futures | 0.75716 | 0.75793 | 0.75259 | 0.75505 | 82679.0 |
| 2021-07-27 | AD | Futures | 0.80815 | 0.8086 | 0.80435 | 0.80516 | 61284.0 |
| 2021-07-27 | ALI | Futures | 2886.75 | 2895.89 | 2871.04 | 2879.04 | 196.0 |
| 2021-07-27 | B | Futures | 49.2 | 49.41 | 48.67 | 48.96 | 251731.0 |
| 2021-07-27 | B6 | Futures | 1.4035 | 1.4111 | 1.398 | 1.4102 | 105537.0 |
| 2021-07-27 | BFX | Futures | 4304.0 | 4304.0 | 4293.8 | 4298.4 | 4.0 |
| 2021-07-27 | BR | Futures | 0.15326 | 0.15467 | 0.15282 | 0.15386 | 17157.0 |
| 2021-07-27 | BTC | Futures | 49934.5 | 51999.4 | 48915.4 | 50826.2 | 2389.0 |
| 2021-07-27 | BZ | Futures | 48.06 | 48.22 | 47.5 | 47.79 | 35038.0 |
| 2021-07-27 | C | Futures | 1435.0 | 1453.0 | 1430.0 | 1444.0 | 7916.0 |
| 2021-07-27 | CB | Futures | 133.184 | 133.184 | 132.381 | 132.381 | 38.0 |
| 2021-07-27 | CC | Futures | 1563.0 | 1579.0 | 1556.0 | 1569.0 | 17661.0 |
| 2021-07-27 | CNH | Futures | 6.2754 | 6.3213 | 6.27 | 6.319 | 1205.0 |
| 2021-07-27 | CSC | Futures | 2.446 | 2.446 | 2.422 | 2.438 | 161.0 |
| 2021-07-27 | CT | Futures | 83.88 | 84.16 | 83.65 | 83.92 | 35.0 |
| 2021-07-27 | DC | Futures | 21.98 | 21.98 | 21.64 | 21.73 | 236.0 |
| 2021-07-27 | DX | Futures | 89.53 | 89.743 | 89.235 | 89.347 | 21088.0 |
| 2021-07-27 | E1 | Futures | 1.22774 | 1.23156 | 1.22381 | 1.22998 | 19258.0 |
| 2021-07-27 | E6 | Futures | 1.25658 | 1.26073 | 1.25307 | 1.25876 | 164998.0 |
| 2021-07-27 | E7 | Futures | 1.2503 | 1.2544 | 1.2468 | 1.2525 | 4999.0 |
| 2021-07-27 | EBM | Futures | 313.71 | 315.55 | 310.4 | 311.87 | 15682.0 |
| 2021-07-27 | ED | Futures | 96.5345 | 96.5393 | 96.5297 | 96.5345 | 82039.0 |
| 2021-07-27 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.465 | 15724.0 |
| 2021-07-27 | ESG | Futures | 408.9 | 410.1 | 405.51 | 408.29 | 461.0 |
| 2021-07-27 | EW | Futures | 2869.8 | 2869.8 | 2832.5 | 2852.0 | 8721.0 |
| 2021-07-27 | FBON | Futures | 150.82 | 151.1 | 150.82 | 150.96 | 66.0 |
| 2021-07-27 | FBTP | Futures | 140.83 | 141.07 | 140.8 | 140.93 | 73584.0 |
| 2021-07-27 | FBTS | Futures | 110.351 | 110.36 | 110.331 | 110.341 | 36961.0 |
| 2021-07-27 | FCE | Futures | 6558.2 | 6563.2 | 6499.8 | 6515.8 | 55165.0 |
| 2021-07-27 | FDAX | Futures | 16726.2 | 16737.0 | 16504.5 | 16621.3 | 73743.0 |
| 2021-07-27 | FDIV | Futures | 185.44 | 186.27 | 185.44 | 186.27 | 10.0 |
| 2021-07-27 | FDXM | Futures | 16645.4 | 16655.0 | 16419.4 | 16538.8 | 57417.0 |
| 2021-07-27 | FDXS | Futures | 16524.8 | 16524.8 | 16319.4 | 16433.7 | 13006.0 |
| 2021-07-27 | FESX | Futures | 3882.6 | 3886.8 | 3837.0 | 3848.9 | 647272.0 |
| 2021-07-27 | FGBL | Futures | 170.37 | 170.85 | 170.32 | 170.74 | 503698.0 |
| 2021-07-27 | FGBM | Futures | 135.57 | 135.74 | 135.55 | 135.7 | 276110.0 |
| 2021-07-27 | FGBS | Futures | 112.719 | 112.759 | 112.714 | 112.749 | 266805.0 |
| 2021-07-27 | FGBX | Futures | 227.66 | 229.29 | 227.58 | 228.79 | 59781.0 |
| 2021-07-27 | FMWO | Futures | 10860.9 | 10860.9 | 10765.7 | 10791.5 | 4498.0 |
| 2021-07-27 | FOAT | Futures | 157.71 | 157.98 | 157.6 | 157.8 | 119932.0 |
| 2021-07-27 | FTDX | Futures | 3722.5 | 3722.5 | 3712.7 | 3714.8 | 6.0 |
| 2021-07-27 | FTI | Futures | 708.93 | 709.32 | 700.03 | 702.72 | 20700.0 |
| 2021-07-27 | FTUK | Futures | 6850.4 | 6857.3 | 6751.9 | 6820.9 | 90959.0 |
| 2021-07-27 | FVSA | Futures | 86.41 | 94.65 | 86.41 | 93.59 | 37959.0 |
> showing 50 of 124 rows — these rows as CSV