PREVIEW / futures_daily / 2020-12-17
file: by_date/futures_daily/2020/2020-12-17.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-12-17 | ES | Futures | 4143.61 | 4166.58 | 4138.0 | 4161.26 | 1227753.0 |
| 2020-12-17 | NQ | Futures | 14626.8 | 14725.41 | 14616.13 | 14707.25 | 388925.0 |
| 2020-12-17 | YM | Futures | 32491.6 | 32665.4 | 32464.6 | 32615.7 | 117925.0 |
| 2020-12-17 | CL | Futures | 33.94 | 34.45 | 33.89 | 34.27 | 243856.0 |
| 2020-12-17 | GC | Futures | 2197.6 | 2237.1 | 2194.6 | 2223.5 | 219866.0 |
| 2020-12-17 | ZN | Futures | 137.164855 | 137.382429 | 136.978363 | 137.118232 | 1275693.0 |
| 2020-12-17 | A6 | Futures | 0.77761 | 0.78449 | 0.777 | 0.78249 | 77009.0 |
| 2020-12-17 | AD | Futures | 0.79535 | 0.7988 | 0.79485 | 0.79632 | 57801.0 |
| 2020-12-17 | ALI | Futures | 2406.5 | 2437.96 | 2406.5 | 2413.2 | 256.0 |
| 2020-12-17 | B | Futures | 32.3 | 32.8 | 32.28 | 32.54 | 233882.0 |
| 2020-12-17 | B6 | Futures | 1.3721 | 1.3855 | 1.3719 | 1.3799 | 105767.0 |
| 2020-12-17 | BFX | Futures | 3864.4 | 3874.9 | 3864.4 | 3874.9 | 42.0 |
| 2020-12-17 | BR | Futures | 0.15406 | 0.15461 | 0.1534 | 0.1534 | 12.0 |
| 2020-12-17 | BTC | Futures | 27956.9 | 31155.1 | 27774.5 | 29793.8 | 16832.0 |
| 2020-12-17 | BZ | Futures | 31.57 | 32.07 | 31.53 | 31.83 | 24947.0 |
| 2020-12-17 | C | Futures | 1438.0 | 1455.0 | 1427.0 | 1444.0 | 5628.0 |
| 2020-12-17 | CB | Futures | 153.653 | 153.653 | 151.807 | 153.653 | 4.0 |
| 2020-12-17 | CC | Futures | 1667.0 | 1684.0 | 1650.0 | 1670.0 | 13736.0 |
| 2020-12-17 | CNH | Futures | 6.3849 | 6.3906 | 6.3754 | 6.3898 | 821.0 |
| 2020-12-17 | CSC | Futures | 3.054 | 3.054 | 3.003 | 3.028 | 124.0 |
| 2020-12-17 | CT | Futures | 73.09 | 74.79 | 72.96 | 74.58 | 19056.0 |
| 2020-12-17 | DC | Futures | 25.91 | 25.91 | 25.35 | 25.62 | 434.0 |
| 2020-12-17 | DX | Futures | 87.176 | 87.19 | 86.668 | 86.766 | 29477.0 |
| 2020-12-17 | E1 | Futures | 1.27883 | 1.28323 | 1.27804 | 1.27928 | 21424.0 |
| 2020-12-17 | E6 | Futures | 1.3057 | 1.31366 | 1.30469 | 1.31259 | 192614.0 |
| 2020-12-17 | E7 | Futures | 1.2991 | 1.3072 | 1.2981 | 1.3061 | 8668.0 |
| 2020-12-17 | EBM | Futures | 254.22 | 255.76 | 252.99 | 255.45 | 14877.0 |
| 2020-12-17 | ED | Futures | 96.5228 | 96.5228 | 96.5131 | 96.5228 | 79982.0 |
| 2020-12-17 | ER | Futures | 98.46 | 98.47 | 98.46 | 98.465 | 52121.0 |
| 2020-12-17 | ESG | Futures | 344.38 | 345.73 | 343.21 | 343.84 | 509.0 |
| 2020-12-17 | EW | Futures | 2439.7 | 2459.1 | 2435.8 | 2455.6 | 17017.0 |
| 2020-12-17 | FBON | Futures | 150.93 | 151.26 | 150.88 | 150.97 | 196.0 |
| 2020-12-17 | FBTP | Futures | 139.18 | 139.57 | 139.06 | 139.18 | 83746.0 |
| 2020-12-17 | FBTS | Futures | 110.107 | 110.156 | 110.097 | 110.127 | 28897.0 |
| 2020-12-17 | FCE | Futures | 5400.0 | 5421.4 | 5372.3 | 5384.4 | 47381.0 |
| 2020-12-17 | FDAX | Futures | 14457.8 | 14632.7 | 14438.6 | 14579.9 | 45087.0 |
| 2020-12-17 | FDXM | Futures | 14417.3 | 14590.5 | 14394.9 | 14539.0 | 5161.0 |
| 2020-12-17 | FESX | Futures | 3278.4 | 3308.1 | 3278.4 | 3297.0 | 746407.0 |
| 2020-12-17 | FGBL | Futures | 170.16 | 170.52 | 169.91 | 170.24 | 520239.0 |
| 2020-12-17 | FGBM | Futures | 135.23 | 135.32 | 135.14 | 135.22 | 268017.0 |
| 2020-12-17 | FGBS | Futures | 112.719 | 112.749 | 112.714 | 112.724 | 225284.0 |
| 2020-12-17 | FGBX | Futures | 235.44 | 236.65 | 234.56 | 235.73 | 51515.0 |
| 2020-12-17 | FMWO | Futures | 9423.3 | 9432.8 | 9411.4 | 9420.9 | 8712.0 |
| 2020-12-17 | FOAT | Futures | 158.65 | 159.06 | 158.51 | 158.76 | 122863.0 |
| 2020-12-17 | FTDX | Futures | 3261.4 | 3262.4 | 3227.3 | 3257.2 | 689.0 |
| 2020-12-17 | FTI | Futures | 581.27 | 585.24 | 581.27 | 583.25 | 13235.0 |
| 2020-12-17 | FTUK | Futures | 6279.9 | 6317.9 | 6259.7 | 6268.3 | 98779.0 |
| 2020-12-17 | FVSA | Futures | 161.94 | 163.83 | 158.54 | 161.56 | 15109.0 |
| 2020-12-17 | FXXP | Futures | 368.4 | 369.6 | 367.7 | 368.8 | 66015.0 |
| 2020-12-17 | G | Futures | 126.25 | 126.74 | 126.19 | 126.44 | 173588.0 |
> showing 50 of 119 rows — these rows as CSV