PREVIEW / futures_daily / 2020-07-28
file: by_date/futures_daily/2020/2020-07-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-07-28 | ES | Futures | 3641.27 | 3654.5 | 3610.88 | 3616.51 | 1375293.0 |
| 2020-07-28 | NQ | Futures | 12398.53 | 12486.74 | 12202.96 | 12233.14 | 445252.0 |
| 2020-07-28 | YM | Futures | 28412.7 | 28505.9 | 28134.0 | 28182.3 | 147516.0 |
| 2020-07-28 | CL | Futures | 30.39 | 30.6 | 29.81 | 29.95 | 276804.0 |
| 2020-07-28 | GC | Futures | 2318.6 | 2362.0 | 2276.4 | 2319.4 | 161576.0 |
| 2020-07-28 | ZN | Futures | 138.171553 | 138.481251 | 138.00122 | 138.450281 | 855554.0 |
| 2020-07-28 | A6 | Futures | 0.7353 | 0.73839 | 0.73191 | 0.73685 | 81173.0 |
| 2020-07-28 | AD | Futures | 0.75982 | 0.76149 | 0.75723 | 0.75977 | 62595.0 |
| 2020-07-28 | ALI | Futures | 2081.01 | 2108.63 | 2081.01 | 2107.72 | 381.0 |
| 2020-07-28 | B | Futures | 28.38 | 28.58 | 27.98 | 28.11 | 179134.0 |
| 2020-07-28 | B6 | Futures | 1.3092 | 1.3156 | 1.3041 | 1.3149 | 107920.0 |
| 2020-07-28 | BR | Futures | 0.15328 | 0.15403 | 0.15213 | 0.15396 | 9159.0 |
| 2020-07-28 | BTC | Futures | 15541.3 | 15958.5 | 14747.8 | 15342.9 | 4004.0 |
| 2020-07-28 | BZ | Futures | 27.76 | 27.9 | 27.33 | 27.45 | 14301.0 |
| 2020-07-28 | C | Futures | 1420.0 | 1420.0 | 1405.0 | 1418.0 | 3449.0 |
| 2020-07-28 | CB | Futures | 188.3 | 188.3 | 188.032 | 188.032 | 16.0 |
| 2020-07-28 | CC | Futures | 1505.0 | 1513.0 | 1478.0 | 1503.0 | 13486.0 |
| 2020-07-28 | CNH | Futures | 6.913 | 6.9249 | 6.9023 | 6.92 | 277.0 |
| 2020-07-28 | CSC | Futures | 4.221 | 4.279 | 4.17 | 4.186 | 101.0 |
| 2020-07-28 | CT | Futures | 61.23 | 61.64 | 60.8 | 61.28 | 75.0 |
| 2020-07-28 | DC | Futures | 34.83 | 35.3 | 34.08 | 34.26 | 444.0 |
| 2020-07-28 | DX | Futures | 90.305 | 90.764 | 90.266 | 90.457 | 23582.0 |
| 2020-07-28 | E1 | Futures | 1.23614 | 1.24227 | 1.2325 | 1.23966 | 26188.0 |
| 2020-07-28 | E6 | Futures | 1.26224 | 1.26466 | 1.25666 | 1.25929 | 211331.0 |
| 2020-07-28 | E7 | Futures | 1.2558 | 1.2582 | 1.2504 | 1.253 | 8043.0 |
| 2020-07-28 | EBM | Futures | 218.85 | 219.45 | 215.86 | 216.46 | 15096.0 |
| 2020-07-28 | ED | Futures | 96.433 | 96.4378 | 96.4282 | 96.4282 | 79916.0 |
| 2020-07-28 | ER | Futures | 98.372 | 98.377 | 98.367 | 98.377 | 52756.0 |
| 2020-07-28 | ESG | Futures | 292.34 | 293.21 | 291.03 | 291.2 | 184.0 |
| 2020-07-28 | EW | Futures | 1983.1 | 1988.8 | 1960.9 | 1962.5 | 9146.0 |
| 2020-07-28 | FBON | Futures | 146.47 | 146.47 | 146.2 | 146.3 | 40.0 |
| 2020-07-28 | FBTP | Futures | 132.88 | 133.13 | 132.8 | 132.85 | 68668.0 |
| 2020-07-28 | FBTS | Futures | 108.783 | 108.871 | 108.783 | 108.822 | 58457.0 |
| 2020-07-28 | FCE | Futures | 4768.7 | 4783.2 | 4725.2 | 4761.5 | 55248.0 |
| 2020-07-28 | FDAX | Futures | 13717.5 | 13782.3 | 13529.5 | 13637.8 | 77608.0 |
| 2020-07-28 | FDXM | Futures | 13659.6 | 13731.5 | 13480.7 | 13588.6 | 43456.0 |
| 2020-07-28 | FESX | Futures | 3054.6 | 3069.4 | 3022.3 | 3048.1 | 681719.0 |
| 2020-07-28 | FGBL | Futures | 168.65 | 169.35 | 168.63 | 169.24 | 494779.0 |
| 2020-07-28 | FGBM | Futures | 134.76 | 135.04 | 134.76 | 135.01 | 394646.0 |
| 2020-07-28 | FGBS | Futures | 112.719 | 112.78 | 112.709 | 112.774 | 319198.0 |
| 2020-07-28 | FGBX | Futures | 229.04 | 231.41 | 228.73 | 230.97 | 38203.0 |
| 2020-07-28 | FMWO | Futures | 8144.0 | 8144.0 | 8051.5 | 8098.9 | 937.0 |
| 2020-07-28 | FOAT | Futures | 156.25 | 156.6 | 156.19 | 156.51 | 113175.0 |
| 2020-07-28 | FTDX | Futures | 3142.0 | 3143.6 | 3110.9 | 3117.5 | 46.0 |
| 2020-07-28 | FTI | Futures | 527.12 | 528.81 | 522.73 | 527.14 | 19256.0 |
| 2020-07-28 | FTUK | Futures | 5766.3 | 5793.2 | 5716.7 | 5766.7 | 91226.0 |
| 2020-07-28 | FVSA | Futures | 232.56 | 242.06 | 228.04 | 230.3 | 12871.0 |
| 2020-07-28 | FXXP | Futures | 337.9 | 338.9 | 335.7 | 338.7 | 51018.0 |
| 2020-07-28 | G | Futures | 127.74 | 128.05 | 127.65 | 127.94 | 213532.0 |
| 2020-07-28 | GF | Futures | 270.66 | 274.488 | 270.369 | 272.744 | 2829.0 |
> showing 50 of 118 rows — these rows as CSV