PREVIEW / futures_daily / 2020-09-28
file: by_date/futures_daily/2020/2020-09-28.parquet size: 10 KB rows: 118
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-09-28 | ES | Futures | 3697.38 | 3765.06 | 3693.44 | 3759.17 | 1495804.0 |
| 2020-09-28 | NQ | Futures | 12902.67 | 13202.51 | 12897.17 | 13191.8 | 568217.0 |
| 2020-09-28 | YM | Futures | 29132.2 | 29713.6 | 29132.2 | 29586.6 | 181940.0 |
| 2020-09-28 | CL | Futures | 28.77 | 29.29 | 28.56 | 29.15 | 226425.0 |
| 2020-09-28 | GC | Futures | 2199.9 | 2230.0 | 2186.2 | 2223.0 | 235915.0 |
| 2020-09-28 | ZN | Futures | 138.497162 | 138.543653 | 138.373186 | 138.481665 | 719441.0 |
| 2020-09-28 | A6 | Futures | 0.72209 | 0.7264 | 0.72198 | 0.72578 | 72905.0 |
| 2020-09-28 | AD | Futures | 0.75776 | 0.75908 | 0.75624 | 0.75806 | 50189.0 |
| 2020-09-28 | ALI | Futures | 2116.59 | 2150.75 | 2116.59 | 2141.25 | 24.0 |
| 2020-09-28 | B | Futures | 26.63 | 27.15 | 26.47 | 27.05 | 222771.0 |
| 2020-09-28 | B6 | Futures | 1.2942 | 1.3115 | 1.2935 | 1.3019 | 109989.0 |
| 2020-09-28 | BR | Futures | 0.13872 | 0.13916 | 0.13872 | 0.13916 | 8.0 |
| 2020-09-28 | BTC | Futures | 14511.3 | 14887.5 | 14504.6 | 14726.3 | 4100.0 |
| 2020-09-28 | BZ | Futures | 26.18 | 26.63 | 25.96 | 26.52 | 21160.0 |
| 2020-09-28 | C | Futures | 1659.0 | 1675.0 | 1641.0 | 1645.0 | 12481.0 |
| 2020-09-28 | CC | Futures | 1694.0 | 1734.0 | 1692.0 | 1699.0 | 14832.0 |
| 2020-09-28 | CNH | Futures | 6.7248 | 6.7281 | 6.7059 | 6.7059 | 369.0 |
| 2020-09-28 | CSC | Futures | 3.423 | 3.423 | 3.386 | 3.386 | 29.0 |
| 2020-09-28 | CT | Futures | 65.18 | 65.82 | 64.43 | 64.92 | 14015.0 |
| 2020-09-28 | DC | Futures | 28.05 | 28.06 | 27.71 | 27.74 | 60.0 |
| 2020-09-28 | DX | Futures | 91.409 | 91.448 | 90.97 | 91.092 | 20236.0 |
| 2020-09-28 | E1 | Futures | 1.22099 | 1.2279 | 1.22088 | 1.22722 | 24312.0 |
| 2020-09-28 | E6 | Futures | 1.24768 | 1.25325 | 1.24629 | 1.25149 | 152658.0 |
| 2020-09-28 | E7 | Futures | 1.241 | 1.2468 | 1.24 | 1.2451 | 6383.0 |
| 2020-09-28 | EBM | Futures | 231.16 | 233.27 | 230.26 | 232.97 | 26443.0 |
| 2020-09-28 | ED | Futures | 96.4697 | 96.4842 | 96.4697 | 96.4793 | 143892.0 |
| 2020-09-28 | ER | Futures | 98.435 | 98.44 | 98.431 | 98.435 | 49618.0 |
| 2020-09-28 | ESG | Futures | 310.11 | 311.15 | 309.74 | 310.67 | 27.0 |
| 2020-09-28 | EW | Futures | 1941.0 | 1987.8 | 1937.7 | 1981.5 | 11996.0 |
| 2020-09-28 | FBON | Futures | 148.0 | 148.1 | 147.77 | 148.0 | 313.0 |
| 2020-09-28 | FBTP | Futures | 135.16 | 135.29 | 134.96 | 135.17 | 88365.0 |
| 2020-09-28 | FBTS | Futures | 109.325 | 109.344 | 109.305 | 109.325 | 41967.0 |
| 2020-09-28 | FCE | Futures | 4651.2 | 4704.1 | 4640.5 | 4695.3 | 73190.0 |
| 2020-09-28 | FDAX | Futures | 13379.9 | 13717.9 | 13373.0 | 13699.2 | 74379.0 |
| 2020-09-28 | FDIV | Futures | 145.64 | 147.87 | 145.64 | 147.87 | 720.0 |
| 2020-09-28 | FDXM | Futures | 13319.3 | 13648.2 | 13305.5 | 13630.1 | 37769.0 |
| 2020-09-28 | FESX | Futures | 2917.7 | 2977.8 | 2915.0 | 2975.0 | 842590.0 |
| 2020-09-28 | FGBL | Futures | 169.78 | 169.88 | 169.52 | 169.82 | 428141.0 |
| 2020-09-28 | FGBM | Futures | 135.15 | 135.17 | 135.06 | 135.15 | 227824.0 |
| 2020-09-28 | FGBS | Futures | 112.775 | 112.78 | 112.749 | 112.769 | 259678.0 |
| 2020-09-28 | FGBX | Futures | 232.07 | 232.66 | 231.14 | 232.39 | 44590.0 |
| 2020-09-28 | FMWO | Futures | 8244.8 | 8328.9 | 8238.9 | 8311.1 | 1814.0 |
| 2020-09-28 | FOAT | Futures | 157.81 | 157.87 | 157.55 | 157.86 | 96606.0 |
| 2020-09-28 | FTDX | Futures | 3140.4 | 3165.6 | 3140.4 | 3157.3 | 38.0 |
| 2020-09-28 | FTI | Futures | 510.12 | 515.48 | 507.88 | 513.95 | 27545.0 |
| 2020-09-28 | FTUK | Futures | 5593.1 | 5663.8 | 5585.9 | 5652.4 | 90920.0 |
| 2020-09-28 | FVSA | Futures | 200.59 | 207.64 | 200.59 | 206.53 | 10351.0 |
| 2020-09-28 | FXXP | Futures | 333.2 | 336.2 | 332.4 | 335.8 | 40748.0 |
| 2020-09-28 | G | Futures | 127.09 | 127.27 | 126.81 | 127.05 | 147451.0 |
| 2020-09-28 | GF | Futures | 265.246 | 268.194 | 264.723 | 267.956 | 3347.0 |
> showing 50 of 118 rows — these rows as CSV