PREVIEW / futures_daily / 2020-09-10
file: by_date/futures_daily/2020/2020-09-10.parquet size: 10 KB rows: 117
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-10 | ES | Futures | 3822.49 | 3854.29 | 3745.11 | 3760.02 | 2332667.0 |
| 2020-09-10 | NQ | Futures | 13205.47 | 13424.83 | 12869.17 | 12973.92 | 885270.0 |
| 2020-09-10 | YM | Futures | 29977.3 | 30179.7 | 29404.6 | 29526.3 | 16844.0 |
| 2020-09-10 | CL | Futures | 27.34 | 27.61 | 26.71 | 26.97 | 367555.0 |
| 2020-09-10 | GC | Futures | 2309.2 | 2332.7 | 2301.3 | 2319.9 | 271478.0 |
| 2020-09-10 | ZN | Futures | 138.156227 | 138.357689 | 138.016753 | 138.2957 | 1177605.0 |
| 2020-09-10 | A6 | Futures | 0.74796 | 0.75206 | 0.74416 | 0.74621 | 49133.0 |
| 2020-09-10 | AD | Futures | 0.77108 | 0.77266 | 0.76774 | 0.76896 | 67406.0 |
| 2020-09-10 | ALI | Futures | 2131.38 | 2148.06 | 2118.88 | 2143.89 | 337.0 |
| 2020-09-10 | B | Futures | 25.87 | 26.11 | 25.31 | 25.54 | 208856.0 |
| 2020-09-10 | B6 | Futures | 1.3191 | 1.3225 | 1.2956 | 1.2987 | 118276.0 |
| 2020-09-10 | BR | Futures | 0.14875 | 0.14875 | 0.14785 | 0.14785 | 1.0 |
| 2020-09-10 | BTC | Futures | 13886.5 | 14264.6 | 13792.0 | 13927.1 | 7860.0 |
| 2020-09-10 | BZ | Futures | 25.34 | 25.54 | 24.77 | 24.98 | 24171.0 |
| 2020-09-10 | C | Futures | 1584.0 | 1604.0 | 1579.0 | 1581.0 | 18469.0 |
| 2020-09-10 | CB | Futures | 167.755 | 169.255 | 167.755 | 169.255 | 35.0 |
| 2020-09-10 | CC | Futures | 1686.0 | 1696.0 | 1661.0 | 1666.0 | 12027.0 |
| 2020-09-10 | CNH | Futures | 6.7303 | 6.7392 | 6.7197 | 6.7367 | 832.0 |
| 2020-09-10 | CSC | Futures | 3.256 | 3.256 | 3.24 | 3.245 | 27.0 |
| 2020-09-10 | CT | Futures | 65.1 | 65.18 | 64.69 | 64.69 | 9.0 |
| 2020-09-10 | DC | Futures | 26.33 | 26.55 | 26.2 | 26.25 | 145.0 |
| 2020-09-10 | DX | Futures | 90.081 | 90.264 | 89.525 | 90.14 | 34051.0 |
| 2020-09-10 | E1 | Futures | 1.24466 | 1.25473 | 1.24432 | 1.24794 | 33953.0 |
| 2020-09-10 | E6 | Futures | 1.26713 | 1.27918 | 1.2667 | 1.26938 | 362370.0 |
| 2020-09-10 | E7 | Futures | 1.2608 | 1.2726 | 1.2604 | 1.2629 | 6561.0 |
| 2020-09-10 | EBM | Futures | 227.54 | 230.26 | 227.54 | 228.75 | 39558.0 |
| 2020-09-10 | ED | Futures | 96.4261 | 96.4358 | 96.4261 | 96.431 | 92464.0 |
| 2020-09-10 | ER | Futures | 98.411 | 98.416 | 98.406 | 98.406 | 107396.0 |
| 2020-09-10 | ESG | Futures | 309.52 | 309.52 | 309.52 | 309.52 | 4.0 |
| 2020-09-10 | EW | Futures | 1998.6 | 2026.1 | 1976.1 | 1977.9 | 9568.0 |
| 2020-09-10 | FBON | Futures | 146.87 | 147.2 | 146.5 | 146.66 | 362.0 |
| 2020-09-10 | FBTP | Futures | 133.13 | 133.34 | 132.84 | 133.03 | 121806.0 |
| 2020-09-10 | FBTS | Futures | 109.006 | 109.054 | 108.958 | 108.996 | 73699.0 |
| 2020-09-10 | FCE | Futures | 4934.0 | 4936.0 | 4846.4 | 4890.7 | 64063.0 |
| 2020-09-10 | FDAX | Futures | 14098.9 | 14138.2 | 13909.3 | 14041.0 | 86897.0 |
| 2020-09-10 | FDXM | Futures | 14025.8 | 14087.4 | 13869.9 | 14000.4 | 325.0 |
| 2020-09-10 | FESX | Futures | 3074.0 | 3079.5 | 3023.1 | 3053.6 | 283962.0 |
| 2020-09-10 | FGBL | Futures | 168.84 | 169.13 | 168.3 | 168.35 | 668123.0 |
| 2020-09-10 | FGBM | Futures | 134.92 | 135.0 | 134.69 | 134.71 | 460851.0 |
| 2020-09-10 | FGBS | Futures | 112.759 | 112.759 | 112.679 | 112.694 | 423744.0 |
| 2020-09-10 | FGBX | Futures | 227.92 | 229.15 | 226.31 | 226.69 | 49441.0 |
| 2020-09-10 | FMWO | Futures | 8417.7 | 8479.3 | 8294.5 | 8441.4 | 3356.0 |
| 2020-09-10 | FOAT | Futures | 156.61 | 156.9 | 156.12 | 156.19 | 169637.0 |
| 2020-09-10 | FTDX | Futures | 3160.9 | 3160.9 | 3155.3 | 3155.3 | 2.0 |
| 2020-09-10 | FTI | Futures | 514.41 | 515.24 | 510.68 | 512.69 | 140.0 |
| 2020-09-10 | FTUK | Futures | 5696.8 | 5730.7 | 5663.8 | 5720.2 | 20148.0 |
| 2020-09-10 | FVSA | Futures | 207.9 | 214.54 | 199.6 | 205.83 | 25271.0 |
| 2020-09-10 | FXXP | Futures | 341.6 | 342.1 | 337.2 | 339.5 | 20171.0 |
| 2020-09-10 | G | Futures | 126.67 | 126.97 | 126.47 | 126.64 | 226617.0 |
| 2020-09-10 | GF | Futures | 263.44 | 268.051 | 263.155 | 265.437 | 5912.0 |
> showing 50 of 117 rows — these rows as CSV