PREVIEW / futures_daily / 2019-03-08
file: by_date/futures_daily/2019/2019-03-08.parquet size: 10 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-08 | ES | Futures | 2976.26 | 2978.97 | 2947.03 | 2974.09 | 1380324.0 |
| 2019-03-08 | NQ | Futures | 8133.8 | 8143.64 | 8033.65 | 8135.24 | 312130.0 |
| 2019-03-08 | YM | Futures | 26842.9 | 26919.8 | 26593.9 | 26891.4 | 159398.0 |
| 2019-03-08 | CL | Futures | 58.33 | 58.41 | 56.36 | 57.96 | 747358.0 |
| 2019-03-08 | GC | Futures | 1608.4 | 1626.6 | 1607.0 | 1624.1 | 283843.0 |
| 2019-03-08 | ZN | Futures | 121.922761 | 122.28017 | 121.860604 | 122.093696 | 1883865.0 |
| 2019-03-08 | A6 | Futures | 0.72281 | 0.72663 | 0.72158 | 0.72611 | 100859.0 |
| 2019-03-08 | AD | Futures | 0.75271 | 0.75615 | 0.75195 | 0.75494 | 89938.0 |
| 2019-03-08 | B | Futures | 47.93 | 47.94 | 46.44 | 47.68 | 316389.0 |
| 2019-03-08 | B6 | Futures | 1.3438 | 1.3464 | 1.3343 | 1.3368 | 167163.0 |
| 2019-03-08 | BR | Futures | 0.20488 | 0.20589 | 0.20488 | 0.20569 | 3232.0 |
| 2019-03-08 | BTC | Futures | 6003.3 | 6026.4 | 5911.1 | 5980.3 | 3781.0 |
| 2019-03-08 | BZ | Futures | 47.54 | 47.55 | 46.06 | 47.3 | 49867.0 |
| 2019-03-08 | C | Futures | 1471.0 | 1497.0 | 1470.0 | 1491.0 | 3893.0 |
| 2019-03-08 | CB | Futures | 276.929 | 277.527 | 276.33 | 276.929 | 27.0 |
| 2019-03-08 | CC | Futures | 1476.0 | 1500.0 | 1476.0 | 1484.0 | 12953.0 |
| 2019-03-08 | CNH | Futures | 6.7435 | 6.7482 | 6.7378 | 6.7433 | 857.0 |
| 2019-03-08 | CSC | Futures | 2.785 | 2.787 | 2.77 | 2.773 | 100.0 |
| 2019-03-08 | CT | Futures | 77.65 | 78.32 | 76.98 | 78.02 | 14477.0 |
| 2019-03-08 | DC | Futures | 23.62 | 23.69 | 23.57 | 23.59 | 80.0 |
| 2019-03-08 | DX | Futures | 93.033 | 93.076 | 92.68 | 92.765 | 25408.0 |
| 2019-03-08 | E1 | Futures | 1.16384 | 1.16843 | 1.1629 | 1.16796 | 27927.0 |
| 2019-03-08 | E6 | Futures | 1.23768 | 1.24343 | 1.23669 | 1.24304 | 240958.0 |
| 2019-03-08 | E7 | Futures | 1.2315 | 1.2374 | 1.2307 | 1.237 | 3980.0 |
| 2019-03-08 | EBM | Futures | 195.28 | 196.34 | 193.43 | 194.48 | 21273.0 |
| 2019-03-08 | ED | Futures | 95.1013 | 95.1087 | 95.1013 | 95.1062 | 202844.0 |
| 2019-03-08 | ER | Futures | 98.411 | 98.411 | 98.406 | 98.406 | 31289.0 |
| 2019-03-08 | EW | Futures | 1985.4 | 1988.1 | 1970.7 | 1980.3 | 22968.0 |
| 2019-03-08 | FBON | Futures | 134.3 | 134.3 | 133.9 | 134.16 | 609.0 |
| 2019-03-08 | FBTP | Futures | 114.91 | 115.01 | 114.25 | 114.56 | 82485.0 |
| 2019-03-08 | FBTS | Futures | 106.131 | 106.15 | 105.865 | 105.941 | 59736.0 |
| 2019-03-08 | FCE | Futures | 4672.7 | 4686.1 | 4657.1 | 4666.5 | 95047.0 |
| 2019-03-08 | FDAX | Futures | 12063.3 | 12083.2 | 11984.5 | 12048.6 | 133314.0 |
| 2019-03-08 | FDIV | Futures | 141.64 | 141.82 | 141.41 | 141.64 | 79.0 |
| 2019-03-08 | FDXM | Futures | 12047.0 | 12054.3 | 11954.7 | 12019.2 | 56273.0 |
| 2019-03-08 | FESX | Futures | 2815.8 | 2822.6 | 2796.2 | 2809.8 | 1717046.0 |
| 2019-03-08 | FGBL | Futures | 158.71 | 159.0 | 158.58 | 158.66 | 804908.0 |
| 2019-03-08 | FGBM | Futures | 132.61 | 132.69 | 132.46 | 132.47 | 516836.0 |
| 2019-03-08 | FGBS | Futures | 112.693 | 112.703 | 112.653 | 112.663 | 330159.0 |
| 2019-03-08 | FGBX | Futures | 189.36 | 190.85 | 189.3 | 190.22 | 62453.0 |
| 2019-03-08 | FMWO | Futures | 6885.0 | 6897.8 | 6857.0 | 6882.7 | 4361.0 |
| 2019-03-08 | FOAT | Futures | 145.17 | 145.48 | 145.05 | 145.28 | 159581.0 |
| 2019-03-08 | FTDX | Futures | 2585.1 | 2613.4 | 2571.6 | 2610.9 | 270.0 |
| 2019-03-08 | FTI | Futures | 501.61 | 501.85 | 497.39 | 498.19 | 27189.0 |
| 2019-03-08 | FTUK | Futures | 6498.1 | 6504.4 | 6443.9 | 6478.0 | 191606.0 |
| 2019-03-08 | FVSA | Futures | 263.89 | 270.01 | 251.66 | 267.38 | 46790.0 |
| 2019-03-08 | FXXP | Futures | 326.7 | 327.2 | 324.9 | 326.0 | 87584.0 |
| 2019-03-08 | G | Futures | 117.38 | 117.54 | 117.12 | 117.24 | 234297.0 |
| 2019-03-08 | GF | Futures | 311.19 | 314.962 | 310.862 | 314.744 | 2375.0 |
| 2019-03-08 | GSCI | Futures | 475.95 | 482.18 | 475.95 | 481.9 | 3148.0 |
> showing 50 of 116 rows — these rows as CSV