PREVIEW / futures_daily / 2020-10-21
file: by_date/futures_daily/2020/2020-10-21.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-21 | ES | Futures | 3861.4 | 3885.0 | 3842.87 | 3856.35 | 1681275.0 |
| 2020-10-21 | NQ | Futures | 13516.54 | 13636.94 | 13412.06 | 13535.07 | 599851.0 |
| 2020-10-21 | YM | Futures | 30345.5 | 30551.2 | 30227.1 | 30288.5 | 170677.0 |
| 2020-10-21 | CL | Futures | 29.38 | 29.65 | 28.36 | 28.53 | 366899.0 |
| 2020-10-21 | GC | Futures | 2257.6 | 2286.4 | 2257.6 | 2278.8 | 201272.0 |
| 2020-10-21 | ZN | Futures | 137.61383 | 137.629327 | 137.272895 | 137.443362 | 1517057.0 |
| 2020-10-21 | A6 | Futures | 0.72352 | 0.73276 | 0.72352 | 0.73174 | 97962.0 |
| 2020-10-21 | AD | Futures | 0.77195 | 0.77478 | 0.77058 | 0.77184 | 67525.0 |
| 2020-10-21 | ALI | Futures | 2212.57 | 2212.86 | 2209.31 | 2209.31 | 37.0 |
| 2020-10-21 | B | Futures | 27.08 | 27.16 | 26.15 | 26.33 | 268884.0 |
| 2020-10-21 | B6 | Futures | 1.3125 | 1.3366 | 1.3125 | 1.3347 | 141674.0 |
| 2020-10-21 | BR | Futures | 0.14077 | 0.14089 | 0.13959 | 0.13994 | 369.0 |
| 2020-10-21 | BTC | Futures | 16117.0 | 17474.0 | 16069.9 | 17138.1 | 10223.0 |
| 2020-10-21 | BZ | Futures | 26.49 | 26.63 | 25.65 | 25.82 | 31681.0 |
| 2020-10-21 | C | Futures | 1466.0 | 1489.0 | 1462.0 | 1473.0 | 3547.0 |
| 2020-10-21 | CB | Futures | 156.55 | 157.566 | 156.016 | 156.524 | 23.0 |
| 2020-10-21 | CC | Futures | 1579.0 | 1615.0 | 1568.0 | 1594.0 | 12830.0 |
| 2020-10-21 | CNH | Futures | 6.5472 | 6.5483 | 6.5132 | 6.5275 | 1505.0 |
| 2020-10-21 | CSC | Futures | 3.708 | 3.727 | 3.639 | 3.655 | 79.0 |
| 2020-10-21 | CT | Futures | 69.98 | 71.28 | 69.74 | 70.21 | 19935.0 |
| 2020-10-21 | DC | Futures | 30.58 | 30.63 | 29.64 | 29.8 | 519.0 |
| 2020-10-21 | DX | Futures | 89.868 | 89.893 | 89.313 | 89.447 | 24271.0 |
| 2020-10-21 | E1 | Futures | 1.25032 | 1.25575 | 1.2502 | 1.2536 | 21311.0 |
| 2020-10-21 | E6 | Futures | 1.26777 | 1.27414 | 1.26772 | 1.27205 | 188740.0 |
| 2020-10-21 | E7 | Futures | 1.2615 | 1.2676 | 1.2614 | 1.2656 | 6072.0 |
| 2020-10-21 | EBM | Futures | 254.67 | 257.08 | 254.37 | 254.67 | 23263.0 |
| 2020-10-21 | ED | Futures | 96.4987 | 96.4987 | 96.4939 | 96.4939 | 48587.0 |
| 2020-10-21 | ER | Futures | 98.44 | 98.445 | 98.44 | 98.445 | 27171.0 |
| 2020-10-21 | ESG | Futures | 318.87 | 321.23 | 318.87 | 318.89 | 36.0 |
| 2020-10-21 | EW | Futures | 2117.7 | 2130.8 | 2102.0 | 2102.4 | 12007.0 |
| 2020-10-21 | FBON | Futures | 148.84 | 148.97 | 148.5 | 148.69 | 776.0 |
| 2020-10-21 | FBTP | Futures | 136.62 | 136.82 | 136.15 | 136.35 | 140252.0 |
| 2020-10-21 | FBTS | Futures | 109.653 | 109.691 | 109.585 | 109.614 | 85638.0 |
| 2020-10-21 | FCE | Futures | 4777.3 | 4794.3 | 4669.1 | 4688.9 | 69412.0 |
| 2020-10-21 | FDAX | Futures | 13602.2 | 13653.9 | 13349.5 | 13370.9 | 95210.0 |
| 2020-10-21 | FDIV | Futures | 144.83 | 145.92 | 144.5 | 144.5 | 125.0 |
| 2020-10-21 | FDXM | Futures | 13519.8 | 13584.5 | 13282.2 | 13303.4 | 60179.0 |
| 2020-10-21 | FESX | Futures | 2981.5 | 2998.2 | 2925.1 | 2931.6 | 885681.0 |
| 2020-10-21 | FGBL | Futures | 170.84 | 171.03 | 170.52 | 170.88 | 649897.0 |
| 2020-10-21 | FGBM | Futures | 135.63 | 135.69 | 135.53 | 135.64 | 335617.0 |
| 2020-10-21 | FGBS | Futures | 112.895 | 112.91 | 112.88 | 112.9 | 403820.0 |
| 2020-10-21 | FGBX | Futures | 236.67 | 237.46 | 235.41 | 236.69 | 65970.0 |
| 2020-10-21 | FMWO | Futures | 8567.0 | 8567.0 | 8488.8 | 8507.7 | 1393.0 |
| 2020-10-21 | FOAT | Futures | 158.62 | 158.95 | 158.49 | 158.82 | 147891.0 |
| 2020-10-21 | FTDX | Futures | 3192.8 | 3192.8 | 3140.4 | 3145.5 | 249.0 |
| 2020-10-21 | FTI | Futures | 523.48 | 525.25 | 514.48 | 515.67 | 23190.0 |
| 2020-10-21 | FTUK | Futures | 5604.6 | 5630.4 | 5476.0 | 5491.3 | 102536.0 |
| 2020-10-21 | FVSA | Futures | 184.3 | 193.25 | 183.58 | 191.82 | 21544.0 |
| 2020-10-21 | FXXP | Futures | 338.3 | 339.4 | 332.3 | 333.2 | 45150.0 |
| 2020-10-21 | G | Futures | 126.98 | 127.0 | 126.55 | 126.7 | 252196.0 |
> showing 50 of 119 rows — these rows as CSV