PREVIEW / futures_daily / 2020-12-15
file: by_date/futures_daily/2020/2020-12-15.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-15 | ES | Futures | 4087.57 | 4134.08 | 4075.52 | 4132.4 | 1909018.0 |
| 2020-12-15 | NQ | Futures | 14386.02 | 14543.17 | 14328.93 | 14528.47 | 401624.0 |
| 2020-12-15 | YM | Futures | 32225.9 | 32567.1 | 32128.7 | 32520.7 | 156823.0 |
| 2020-12-15 | CL | Futures | 33.31 | 33.81 | 32.98 | 33.73 | 219989.0 |
| 2020-12-15 | GC | Futures | 2153.0 | 2186.9 | 2150.7 | 2182.2 | 173607.0 |
| 2020-12-15 | ZN | Futures | 137.335806 | 137.382429 | 137.071609 | 137.118232 | 979197.0 |
| 2020-12-15 | A6 | Futures | 0.77336 | 0.77741 | 0.77079 | 0.77582 | 72914.0 |
| 2020-12-15 | AD | Futures | 0.79434 | 0.79864 | 0.79348 | 0.79819 | 71031.0 |
| 2020-12-15 | ALI | Futures | 2397.75 | 2397.75 | 2397.75 | 2397.75 | 0.0 |
| 2020-12-15 | B | Futures | 31.79 | 32.16 | 31.46 | 32.08 | 190547.0 |
| 2020-12-15 | B6 | Futures | 1.3548 | 1.369 | 1.3496 | 1.3653 | 128613.0 |
| 2020-12-15 | BR | Futures | 0.15266 | 0.15426 | 0.15238 | 0.15344 | 11.0 |
| 2020-12-15 | BTC | Futures | 25195.1 | 25631.5 | 24908.5 | 25481.7 | 5817.0 |
| 2020-12-15 | BZ | Futures | 31.11 | 31.45 | 30.78 | 31.37 | 24071.0 |
| 2020-12-15 | C | Futures | 1492.0 | 1515.0 | 1461.0 | 1462.0 | 6086.0 |
| 2020-12-15 | CB | Futures | 149.961 | 154.114 | 149.961 | 153.191 | 81.0 |
| 2020-12-15 | CC | Futures | 1712.0 | 1731.0 | 1665.0 | 1670.0 | 15954.0 |
| 2020-12-15 | CNH | Futures | 6.4012 | 6.4168 | 6.3927 | 6.395 | 679.0 |
| 2020-12-15 | CSC | Futures | 3.129 | 3.151 | 3.129 | 3.143 | 74.0 |
| 2020-12-15 | CT | Futures | 72.14 | 73.12 | 72.03 | 73.03 | 15183.0 |
| 2020-12-15 | DC | Futures | 26.4 | 26.75 | 26.4 | 26.64 | 155.0 |
| 2020-12-15 | DX | Futures | 87.591 | 87.77 | 87.35 | 87.411 | 22407.0 |
| 2020-12-15 | E1 | Futures | 1.27646 | 1.27906 | 1.27443 | 1.27861 | 16123.0 |
| 2020-12-15 | E6 | Futures | 1.29983 | 1.30239 | 1.29716 | 1.30122 | 146856.0 |
| 2020-12-15 | E7 | Futures | 1.2934 | 1.2959 | 1.2907 | 1.2947 | 7757.0 |
| 2020-12-15 | EBM | Futures | 255.45 | 257.3 | 253.6 | 255.45 | 21690.0 |
| 2020-12-15 | ED | Futures | 96.5228 | 96.5276 | 96.518 | 96.5228 | 110187.0 |
| 2020-12-15 | ER | Futures | 98.48 | 98.48 | 98.475 | 98.475 | 24035.0 |
| 2020-12-15 | ESG | Futures | 339.28 | 341.66 | 338.94 | 341.66 | 3798.0 |
| 2020-12-15 | EW | Futures | 2392.7 | 2446.4 | 2387.3 | 2443.8 | 25846.0 |
| 2020-12-15 | FBON | Futures | 151.28 | 151.52 | 151.28 | 151.45 | 63.0 |
| 2020-12-15 | FBTP | Futures | 139.33 | 139.56 | 139.25 | 139.47 | 81574.0 |
| 2020-12-15 | FBTS | Futures | 110.117 | 110.165 | 110.107 | 110.146 | 31653.0 |
| 2020-12-15 | FCE | Futures | 5353.8 | 5400.0 | 5347.5 | 5364.5 | 60189.0 |
| 2020-12-15 | FDAX | Futures | 14094.3 | 14317.6 | 14052.7 | 14256.8 | 89381.0 |
| 2020-12-15 | FDXM | Futures | 14033.5 | 14267.4 | 14015.4 | 14205.7 | 6776.0 |
| 2020-12-15 | FESX | Futures | 3236.5 | 3277.4 | 3233.7 | 3265.3 | 1300104.0 |
| 2020-12-15 | FGBL | Futures | 170.9 | 171.09 | 170.7 | 170.8 | 441155.0 |
| 2020-12-15 | FGBM | Futures | 135.54 | 135.59 | 135.45 | 135.48 | 219810.0 |
| 2020-12-15 | FGBS | Futures | 112.82 | 112.825 | 112.795 | 112.805 | 235575.0 |
| 2020-12-15 | FGBX | Futures | 237.99 | 238.6 | 237.14 | 237.55 | 41562.0 |
| 2020-12-15 | FMWO | Futures | 9242.1 | 9339.2 | 9226.7 | 9282.3 | 22566.0 |
| 2020-12-15 | FOAT | Futures | 159.31 | 159.44 | 159.15 | 159.25 | 100865.0 |
| 2020-12-15 | FTDX | Futures | 3187.1 | 3209.8 | 3187.1 | 3207.2 | 530.0 |
| 2020-12-15 | FTI | Futures | 571.23 | 579.78 | 570.81 | 576.37 | 13581.0 |
| 2020-12-15 | FTUK | Futures | 6224.5 | 6266.9 | 6192.7 | 6227.9 | 405608.0 |
| 2020-12-15 | FVSA | Futures | 175.15 | 176.66 | 167.23 | 170.62 | 29908.0 |
| 2020-12-15 | FXXP | Futures | 362.4 | 366.3 | 362.1 | 364.8 | 193176.0 |
| 2020-12-15 | G | Futures | 127.01 | 127.15 | 126.3 | 126.57 | 240659.0 |
| 2020-12-15 | GF | Futures | 272.199 | 274.248 | 272.101 | 273.418 | 3651.0 |
> showing 50 of 119 rows — these rows as CSV