PREVIEW / futures_daily / 2020-05-08
file: by_date/futures_daily/2020/2020-05-08.parquet size: 10 KB rows: 114
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-05-08 | ES | Futures | 3188.89 | 3245.32 | 3186.4 | 3240.34 | 1326254.0 |
| 2020-05-08 | NQ | Futures | 10449.8 | 10590.81 | 10436.33 | 10568.17 | 362315.0 |
| 2020-05-08 | YM | Futures | 25454.5 | 25958.2 | 25448.1 | 25914.4 | 156060.0 |
| 2020-05-08 | CL | Futures | 17.38 | 18.6 | 17.32 | 18.42 | 205181.0 |
| 2020-05-08 | GC | Futures | 2094.6 | 2104.7 | 2065.4 | 2078.5 | 232810.0 |
| 2020-05-08 | ZN | Futures | 137.500532 | 137.809245 | 137.19182 | 137.268998 | 1090304.0 |
| 2020-05-08 | A6 | Futures | 0.66727 | 0.67271 | 0.66716 | 0.67055 | 65305.0 |
| 2020-05-08 | AD | Futures | 0.72465 | 0.72855 | 0.72455 | 0.72733 | 37085.0 |
| 2020-05-08 | ALI | Futures | 1796.43 | 1796.43 | 1796.43 | 1796.43 | 0.0 |
| 2020-05-08 | B | Futures | 19.55 | 20.56 | 19.43 | 20.45 | 147304.0 |
| 2020-05-08 | B6 | Futures | 1.2549 | 1.2658 | 1.2545 | 1.2599 | 49378.0 |
| 2020-05-08 | BR | Futures | 0.1405 | 0.143 | 0.14038 | 0.14247 | 4310.0 |
| 2020-05-08 | BTC | Futures | 13922.2 | 14214.3 | 13657.9 | 13950.0 | 6747.0 |
| 2020-05-08 | BZ | Futures | 18.82 | 19.9 | 18.8 | 19.8 | 20277.0 |
| 2020-05-08 | CB | Futures | 153.357 | 157.066 | 153.357 | 157.066 | 44.0 |
| 2020-05-08 | CC | Futures | 1553.0 | 1575.0 | 1547.0 | 1568.0 | 7495.0 |
| 2020-05-08 | CNH | Futures | 7.0319 | 7.0406 | 7.0214 | 7.0396 | 221.0 |
| 2020-05-08 | CSC | Futures | 2.617 | 2.679 | 2.607 | 2.677 | 55.0 |
| 2020-05-08 | CT | Futures | 53.99 | 55.61 | 53.99 | 54.85 | 12673.0 |
| 2020-05-08 | DC | Futures | 21.25 | 21.93 | 21.18 | 21.76 | 368.0 |
| 2020-05-08 | DX | Futures | 96.543 | 96.669 | 96.175 | 96.474 | 11060.0 |
| 2020-05-08 | E1 | Futures | 1.17121 | 1.17759 | 1.1711 | 1.17429 | 16032.0 |
| 2020-05-08 | E6 | Futures | 1.16499 | 1.16972 | 1.16317 | 1.16612 | 105989.0 |
| 2020-05-08 | E7 | Futures | 1.1588 | 1.1637 | 1.157 | 1.16 | 5411.0 |
| 2020-05-08 | EBM | Futures | 224.84 | 225.74 | 223.94 | 225.44 | 7296.0 |
| 2020-05-08 | ED | Futures | 96.3581 | 96.3871 | 96.3581 | 96.3629 | 267022.0 |
| 2020-05-08 | ER | Futures | 98.279 | 98.298 | 98.269 | 98.274 | 27792.0 |
| 2020-05-08 | ESG | Futures | 262.77 | 264.36 | 262.77 | 264.3 | 1795.0 |
| 2020-05-08 | EW | Futures | 1720.2 | 1778.1 | 1717.7 | 1773.6 | 9539.0 |
| 2020-05-08 | FBON | Futures | 139.69 | 140.15 | 139.65 | 139.93 | 116.0 |
| 2020-05-08 | FBTP | Futures | 122.6 | 123.8 | 122.42 | 123.57 | 56558.0 |
| 2020-05-08 | FBTS | Futures | 106.825 | 107.153 | 106.787 | 107.104 | 50267.0 |
| 2020-05-08 | FCE | Futures | 4401.3 | 4410.0 | 4369.3 | 4398.4 | 27519.0 |
| 2020-05-08 | FDAX | Futures | 11414.1 | 11555.8 | 11414.1 | 11536.8 | 53553.0 |
| 2020-05-08 | FDIV | Futures | 120.3 | 122.94 | 120.3 | 122.8 | 146.0 |
| 2020-05-08 | FDXM | Futures | 11453.7 | 11613.1 | 11453.7 | 11591.9 | 40889.0 |
| 2020-05-08 | FESX | Futures | 2632.3 | 2658.9 | 2631.4 | 2653.4 | 616618.0 |
| 2020-05-08 | FGBL | Futures | 169.01 | 169.37 | 168.67 | 168.91 | 302877.0 |
| 2020-05-08 | FGBM | Futures | 135.19 | 135.34 | 135.13 | 135.24 | 178149.0 |
| 2020-05-08 | FGBS | Futures | 113.001 | 113.046 | 112.981 | 113.016 | 147004.0 |
| 2020-05-08 | FGBX | Futures | 228.2 | 229.62 | 226.74 | 227.65 | 24023.0 |
| 2020-05-08 | FMWO | Futures | 7129.2 | 7158.6 | 7096.2 | 7137.4 | 2009.0 |
| 2020-05-08 | FOAT | Futures | 152.98 | 153.37 | 152.91 | 153.06 | 60055.0 |
| 2020-05-08 | FTDX | Futures | 3005.8 | 3025.5 | 3004.2 | 3016.9 | 58.0 |
| 2020-05-08 | FTI | Futures | 487.38 | 489.4 | 483.82 | 486.89 | 15343.0 |
| 2020-05-08 | FVSA | Futures | 288.51 | 291.21 | 265.11 | 273.66 | 9611.0 |
| 2020-05-08 | FXXP | Futures | 314.0 | 315.2 | 313.1 | 314.7 | 30493.0 |
| 2020-05-08 | GF | Futures | 270.295 | 270.71 | 265.052 | 265.571 | 1238.0 |
| 2020-05-08 | GSCI | Futures | 289.39 | 289.39 | 287.68 | 287.68 | 1046.0 |
| 2020-05-08 | HE | Futures | 44.615 | 44.668 | 43.074 | 43.214 | 18147.0 |
> showing 50 of 114 rows — these rows as CSV