PREVIEW / futures_daily / 2020-08-04
file: by_date/futures_daily/2020/2020-08-04.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-08-04 | ES | Futures | 3704.03 | 3715.0 | 3681.8 | 3714.44 | 1145269.0 |
| 2020-08-04 | NQ | Futures | 12829.71 | 12877.0 | 12747.3 | 12866.85 | 395698.0 |
| 2020-08-04 | YM | Futures | 28465.2 | 28661.3 | 28334.4 | 28632.4 | 145516.0 |
| 2020-08-04 | CL | Futures | 29.76 | 30.7 | 29.29 | 30.43 | 451575.0 |
| 2020-08-04 | GC | Futures | 2354.3 | 2406.5 | 2341.5 | 2386.8 | 274420.0 |
| 2020-08-04 | ZN | Futures | 138.775464 | 139.147101 | 138.682554 | 139.069676 | 773099.0 |
| 2020-08-04 | A6 | Futures | 0.73294 | 0.73746 | 0.73109 | 0.73613 | 76281.0 |
| 2020-08-04 | AD | Futures | 0.75774 | 0.7622 | 0.75637 | 0.76068 | 54437.0 |
| 2020-08-04 | ALI | Futures | 2168.11 | 2183.89 | 2168.11 | 2181.77 | 18.0 |
| 2020-08-04 | B | Futures | 28.26 | 28.89 | 27.87 | 28.64 | 227118.0 |
| 2020-08-04 | B6 | Futures | 1.3282 | 1.3313 | 1.3184 | 1.326 | 97162.0 |
| 2020-08-04 | BR | Futures | 0.14861 | 0.14999 | 0.14726 | 0.14924 | 5621.0 |
| 2020-08-04 | BTC | Futures | 15814.9 | 15869.6 | 15219.8 | 15554.9 | 6915.0 |
| 2020-08-04 | BZ | Futures | 27.64 | 28.22 | 27.22 | 27.97 | 27305.0 |
| 2020-08-04 | C | Futures | 1523.0 | 1531.0 | 1509.0 | 1514.0 | 6220.0 |
| 2020-08-04 | CB | Futures | 178.671 | 178.671 | 171.797 | 171.797 | 47.0 |
| 2020-08-04 | CC | Futures | 1621.0 | 1630.0 | 1599.0 | 1606.0 | 21494.0 |
| 2020-08-04 | CNH | Futures | 6.8983 | 6.903 | 6.8876 | 6.8898 | 234.0 |
| 2020-08-04 | CSC | Futures | 3.79 | 3.79 | 3.504 | 3.504 | 247.0 |
| 2020-08-04 | CT | Futures | 64.52 | 64.67 | 63.97 | 64.66 | 10.0 |
| 2020-08-04 | DC | Futures | 30.96 | 30.96 | 28.43 | 28.43 | 1044.0 |
| 2020-08-04 | DX | Futures | 90.32 | 90.619 | 90.039 | 90.197 | 18004.0 |
| 2020-08-04 | E1 | Futures | 1.23989 | 1.24534 | 1.23761 | 1.24329 | 23709.0 |
| 2020-08-04 | E6 | Futures | 1.26337 | 1.26793 | 1.25876 | 1.2653 | 194343.0 |
| 2020-08-04 | E7 | Futures | 1.257 | 1.2615 | 1.2526 | 1.259 | 5462.0 |
| 2020-08-04 | EBM | Futures | 215.86 | 216.16 | 214.66 | 215.26 | 12506.0 |
| 2020-08-04 | ED | Futures | 96.4523 | 96.462 | 96.4523 | 96.4572 | 108594.0 |
| 2020-08-04 | ER | Futures | 98.382 | 98.391 | 98.382 | 98.391 | 46026.0 |
| 2020-08-04 | ESG | Futures | 299.31 | 299.82 | 299.2 | 299.77 | 13.0 |
| 2020-08-04 | EW | Futures | 2004.0 | 2014.4 | 1991.0 | 2011.4 | 10129.0 |
| 2020-08-04 | FBON | Futures | 146.56 | 147.44 | 146.56 | 147.37 | 237.0 |
| 2020-08-04 | FBTP | Futures | 132.95 | 133.65 | 132.94 | 133.52 | 64154.0 |
| 2020-08-04 | FBTS | Futures | 108.832 | 108.909 | 108.822 | 108.88 | 47502.0 |
| 2020-08-04 | FCE | Futures | 4741.6 | 4757.1 | 4690.4 | 4723.8 | 67481.0 |
| 2020-08-04 | FDAX | Futures | 13461.5 | 13559.2 | 13298.4 | 13369.1 | 73423.0 |
| 2020-08-04 | FDXM | Futures | 13392.8 | 13510.3 | 13251.0 | 13320.8 | 45420.0 |
| 2020-08-04 | FESX | Futures | 3000.1 | 3023.2 | 2976.1 | 2997.3 | 682381.0 |
| 2020-08-04 | FGBL | Futures | 169.41 | 170.08 | 169.3 | 169.89 | 454438.0 |
| 2020-08-04 | FGBM | Futures | 135.04 | 135.26 | 135.03 | 135.2 | 304087.0 |
| 2020-08-04 | FGBS | Futures | 112.79 | 112.835 | 112.78 | 112.815 | 313518.0 |
| 2020-08-04 | FGBX | Futures | 231.04 | 233.92 | 230.6 | 233.28 | 38203.0 |
| 2020-08-04 | FMWO | Futures | 8198.5 | 8208.0 | 8135.7 | 8189.0 | 2197.0 |
| 2020-08-04 | FOAT | Futures | 156.61 | 157.17 | 156.55 | 157.1 | 124307.0 |
| 2020-08-04 | FTDX | Futures | 3121.6 | 3121.6 | 3079.7 | 3081.8 | 70.0 |
| 2020-08-04 | FTI | Futures | 521.8 | 524.65 | 516.52 | 519.72 | 24266.0 |
| 2020-08-04 | FTUK | Futures | 5653.3 | 5694.4 | 5620.7 | 5664.2 | 91909.0 |
| 2020-08-04 | FVSA | Futures | 231.66 | 234.37 | 221.7 | 225.32 | 11169.0 |
| 2020-08-04 | FXXP | Futures | 335.6 | 337.0 | 332.5 | 334.3 | 45186.0 |
| 2020-08-04 | G | Futures | 128.02 | 128.44 | 127.92 | 128.25 | 219935.0 |
| 2020-08-04 | GF | Futures | 280.837 | 281.855 | 279.286 | 280.498 | 1079.0 |
> showing 50 of 118 rows — these rows as CSV