PREVIEW / futures_daily / 2020-11-27
file: by_date/futures_daily/2020/2020-11-27.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-11-27 | ES | Futures | 4078.52 | 4092.56 | 4058.86 | 4085.54 | 639268.0 |
| 2020-11-27 | NQ | Futures | 14087.29 | 14248.5 | 14039.54 | 14190.62 | 296828.0 |
| 2020-11-27 | YM | Futures | 32148.8 | 32273.7 | 31970.1 | 32161.7 | 98409.0 |
| 2020-11-27 | CL | Futures | 32.65 | 32.78 | 31.69 | 32.38 | 365128.0 |
| 2020-11-27 | GC | Futures | 2131.4 | 2143.7 | 2089.5 | 2103.1 | 282346.0 |
| 2020-11-27 | ZN | Futures | 137.117924 | 137.412368 | 137.102427 | 137.412368 | 447966.0 |
| 2020-11-27 | A6 | Futures | 0.75596 | 0.75971 | 0.75488 | 0.75879 | 82350.0 |
| 2020-11-27 | AD | Futures | 0.77955 | 0.78127 | 0.77808 | 0.78031 | 57981.0 |
| 2020-11-27 | ALI | Futures | 2342.65 | 2342.65 | 2342.65 | 2342.65 | 0.0 |
| 2020-11-27 | B | Futures | 30.25 | 30.62 | 29.92 | 30.49 | 229254.0 |
| 2020-11-27 | B6 | Futures | 1.3574 | 1.3589 | 1.3481 | 1.3504 | 115608.0 |
| 2020-11-27 | BR | Futures | 0.14567 | 0.14595 | 0.14544 | 0.14552 | 140.0 |
| 2020-11-27 | BTC | Futures | 24869.4 | 24980.1 | 21521.3 | 22049.0 | 16490.0 |
| 2020-11-27 | BZ | Futures | 30.18 | 30.27 | 29.26 | 29.82 | 34535.0 |
| 2020-11-27 | C | Futures | 1673.0 | 1673.0 | 1630.0 | 1667.0 | 2687.0 |
| 2020-11-27 | CC | Futures | 1818.0 | 1828.0 | 1775.0 | 1818.0 | 17665.0 |
| 2020-11-27 | CNH | Futures | 6.4332 | 6.4476 | 6.4269 | 6.4364 | 1089.0 |
| 2020-11-27 | CT | Futures | 70.27 | 71.01 | 69.95 | 70.76 | 9447.0 |
| 2020-11-27 | DX | Futures | 88.869 | 88.902 | 88.617 | 88.676 | 9923.0 |
| 2020-11-27 | E1 | Futures | 1.24737 | 1.25303 | 1.24579 | 1.25168 | 26206.0 |
| 2020-11-27 | E6 | Futures | 1.27698 | 1.28186 | 1.27355 | 1.28121 | 192734.0 |
| 2020-11-27 | E7 | Futures | 1.2704 | 1.2754 | 1.2671 | 1.2747 | 9483.0 |
| 2020-11-27 | EBM | Futures | 255.27 | 257.08 | 254.67 | 254.97 | 11033.0 |
| 2020-11-27 | ED | Futures | 96.4818 | 96.4866 | 96.4793 | 96.4842 | 102615.0 |
| 2020-11-27 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 18314.0 |
| 2020-11-27 | ESG | Futures | 336.27 | 336.81 | 335.9 | 336.31 | 211.0 |
| 2020-11-27 | EW | Futures | 2357.9 | 2362.5 | 2336.6 | 2357.5 | 7127.0 |
| 2020-11-27 | FBON | Futures | 150.69 | 150.75 | 150.54 | 150.61 | 221.0 |
| 2020-11-27 | FBTP | Futures | 138.7 | 138.88 | 138.56 | 138.79 | 105081.0 |
| 2020-11-27 | FBTS | Futures | 110.058 | 110.077 | 110.039 | 110.058 | 44631.0 |
| 2020-11-27 | FCE | Futures | 5430.0 | 5470.5 | 5414.4 | 5453.5 | 49757.0 |
| 2020-11-27 | FDAX | Futures | 14140.6 | 14259.0 | 14111.8 | 14233.9 | 53374.0 |
| 2020-11-27 | FDIV | Futures | 159.43 | 159.91 | 159.43 | 159.91 | 20.0 |
| 2020-11-27 | FDXM | Futures | 14072.5 | 14182.8 | 14040.7 | 14162.1 | 29641.0 |
| 2020-11-27 | FESX | Futures | 3239.5 | 3269.0 | 3230.2 | 3265.3 | 706944.0 |
| 2020-11-27 | FEU3 | Futures | 99.193 | 99.198 | 99.193 | 99.198 | 10.0 |
| 2020-11-27 | FGBL | Futures | 170.76 | 170.82 | 170.59 | 170.68 | 360715.0 |
| 2020-11-27 | FGBM | Futures | 135.43 | 135.47 | 135.39 | 135.42 | 199972.0 |
| 2020-11-27 | FGBS | Futures | 112.82 | 112.835 | 112.81 | 112.82 | 184724.0 |
| 2020-11-27 | FGBX | Futures | 237.17 | 237.69 | 236.56 | 237.11 | 50251.0 |
| 2020-11-27 | FMWO | Futures | 9147.3 | 9176.9 | 9128.4 | 9174.6 | 3528.0 |
| 2020-11-27 | FOAT | Futures | 159.24 | 159.32 | 159.07 | 159.16 | 101654.0 |
| 2020-11-27 | FTDX | Futures | 3172.8 | 3213.4 | 3170.2 | 3207.2 | 194.0 |
| 2020-11-27 | FTI | Futures | 568.26 | 573.36 | 567.94 | 571.54 | 17046.0 |
| 2020-11-27 | FTUK | Futures | 6067.7 | 6126.0 | 6013.7 | 6080.6 | 199242.0 |
| 2020-11-27 | FVSA | Futures | 150.24 | 150.24 | 145.79 | 147.64 | 14451.0 |
| 2020-11-27 | FXXP | Futures | 363.1 | 365.4 | 362.0 | 364.2 | 45665.0 |
| 2020-11-27 | G | Futures | 126.25 | 126.36 | 126.0 | 126.17 | 173323.0 |
| 2020-11-27 | GF | Futures | 272.491 | 275.126 | 272.052 | 272.882 | 2718.0 |
| 2020-11-27 | GSCI | Futures | 366.7 | 368.22 | 366.7 | 367.74 | 7.0 |
> showing 50 of 119 rows — these rows as CSV