PREVIEW / futures_daily / 2020-09-16
file: by_date/futures_daily/2020/2020-09-16.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-09-16 | ES | Futures | 3815.06 | 3841.74 | 3790.34 | 3796.8 | 1787505.0 |
| 2020-09-16 | NQ | Futures | 13256.06 | 13358.8 | 12993.84 | 13030.01 | 613797.0 |
| 2020-09-16 | YM | Futures | 30047.3 | 30414.4 | 29978.4 | 30076.4 | 149813.0 |
| 2020-09-16 | CL | Futures | 27.75 | 29.14 | 27.73 | 29.01 | 283420.0 |
| 2020-09-16 | GC | Futures | 2316.4 | 2342.9 | 2311.5 | 2327.2 | 298385.0 |
| 2020-09-16 | ZN | Futures | 138.342191 | 138.543653 | 138.187221 | 138.311197 | 872530.0 |
| 2020-09-16 | A6 | Futures | 0.7497 | 0.75422 | 0.74734 | 0.74919 | 86760.0 |
| 2020-09-16 | AD | Futures | 0.7688 | 0.7721 | 0.76784 | 0.76956 | 64576.0 |
| 2020-09-16 | ALI | Futures | 2162.93 | 2163.53 | 2142.14 | 2147.78 | 245.0 |
| 2020-09-16 | B | Futures | 25.96 | 27.05 | 25.87 | 26.91 | 237248.0 |
| 2020-09-16 | B6 | Futures | 1.3075 | 1.3195 | 1.3062 | 1.3138 | 103722.0 |
| 2020-09-16 | BR | Futures | 0.14793 | 0.15005 | 0.14793 | 0.14989 | 6.0 |
| 2020-09-16 | BTC | Futures | 14703.4 | 15054.4 | 14433.4 | 14872.2 | 7056.0 |
| 2020-09-16 | BZ | Futures | 25.41 | 26.47 | 25.31 | 26.33 | 29327.0 |
| 2020-09-16 | C | Futures | 1691.0 | 1706.0 | 1636.0 | 1637.0 | 11026.0 |
| 2020-09-16 | CB | Futures | 168.06 | 168.746 | 168.06 | 168.746 | 6.0 |
| 2020-09-16 | CC | Futures | 1766.0 | 1770.0 | 1702.0 | 1709.0 | 24393.0 |
| 2020-09-16 | CNH | Futures | 6.6736 | 6.6736 | 6.6382 | 6.6489 | 718.0 |
| 2020-09-16 | CSC | Futures | 3.269 | 3.269 | 3.269 | 3.269 | 5.0 |
| 2020-09-16 | CT | Futures | 66.17 | 66.17 | 65.71 | 65.71 | 11.0 |
| 2020-09-16 | DC | Futures | 26.42 | 27.01 | 26.42 | 26.57 | 140.0 |
| 2020-09-16 | DX | Futures | 89.96 | 90.124 | 89.641 | 90.058 | 35510.0 |
| 2020-09-16 | E1 | Futures | 1.25043 | 1.25371 | 1.24601 | 1.24681 | 21982.0 |
| 2020-09-16 | E6 | Futures | 1.27163 | 1.27527 | 1.26504 | 1.26627 | 201295.0 |
| 2020-09-16 | E7 | Futures | 1.2651 | 1.2688 | 1.2586 | 1.2598 | 9797.0 |
| 2020-09-16 | EBM | Futures | 224.83 | 226.94 | 224.83 | 226.64 | 24799.0 |
| 2020-09-16 | ED | Futures | 96.4455 | 96.4697 | 96.4455 | 96.46 | 249354.0 |
| 2020-09-16 | ER | Futures | 98.421 | 98.435 | 98.421 | 98.426 | 136447.0 |
| 2020-09-16 | ESG | Futures | 315.62 | 316.57 | 313.01 | 313.08 | 267.0 |
| 2020-09-16 | EW | Futures | 2017.3 | 2049.5 | 2015.1 | 2024.0 | 13416.0 |
| 2020-09-16 | FBON | Futures | 147.66 | 147.98 | 147.66 | 147.7 | 253.0 |
| 2020-09-16 | FBTP | Futures | 133.93 | 134.29 | 133.81 | 134.09 | 88496.0 |
| 2020-09-16 | FBTS | Futures | 109.132 | 109.209 | 109.132 | 109.17 | 66564.0 |
| 2020-09-16 | FCE | Futures | 4901.4 | 4928.1 | 4867.0 | 4911.6 | 60272.0 |
| 2020-09-16 | FDAX | Futures | 14015.0 | 14107.4 | 13992.7 | 14060.7 | 80912.0 |
| 2020-09-16 | FDXM | Futures | 13978.1 | 14066.1 | 13962.2 | 14021.1 | 3706.0 |
| 2020-09-16 | FESX | Futures | 3061.0 | 3085.1 | 3048.1 | 3070.3 | 960630.0 |
| 2020-09-16 | FGBL | Futures | 169.33 | 169.5 | 169.06 | 169.14 | 456792.0 |
| 2020-09-16 | FGBM | Futures | 135.03 | 135.08 | 134.89 | 134.92 | 328049.0 |
| 2020-09-16 | FGBS | Futures | 112.739 | 112.759 | 112.724 | 112.729 | 372261.0 |
| 2020-09-16 | FGBX | Futures | 229.82 | 230.53 | 228.96 | 229.46 | 53228.0 |
| 2020-09-16 | FMWO | Futures | 8492.4 | 8529.1 | 8433.1 | 8510.2 | 9400.0 |
| 2020-09-16 | FOAT | Futures | 157.37 | 157.63 | 157.24 | 157.33 | 110135.0 |
| 2020-09-16 | FTDX | Futures | 3181.0 | 3206.2 | 3181.0 | 3197.0 | 398.0 |
| 2020-09-16 | FTI | Futures | 518.09 | 521.54 | 517.06 | 520.06 | 16923.0 |
| 2020-09-16 | FTUK | Futures | 5801.0 | 5821.5 | 5759.4 | 5782.8 | 147166.0 |
| 2020-09-16 | FVSA | Futures | 192.04 | 196.87 | 190.93 | 191.3 | 17769.0 |
| 2020-09-16 | FXXP | Futures | 342.4 | 344.6 | 342.1 | 344.0 | 107561.0 |
| 2020-09-16 | G | Futures | 126.91 | 127.11 | 126.82 | 126.88 | 193313.0 |
| 2020-09-16 | GF | Futures | 273.613 | 273.803 | 270.285 | 270.808 | 4155.0 |
> showing 50 of 119 rows — these rows as CSV