PREVIEW / futures_daily / 2019-06-05
file: by_date/futures_daily/2019/2019-06-05.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 |
|---|---|---|---|---|---|---|---|
| 2019-06-05 | ES | Futures | 3031.51 | 3056.36 | 3025.57 | 3054.46 | 1743779.0 |
| 2019-06-05 | NQ | Futures | 8283.2 | 8348.01 | 8238.55 | 8328.71 | 534798.0 |
| 2019-06-05 | YM | Futures | 26757.3 | 26993.8 | 26752.0 | 26977.9 | 219206.0 |
| 2019-06-05 | CL | Futures | 54.25 | 54.82 | 51.93 | 53.04 | 943186.0 |
| 2019-06-05 | GC | Futures | 1655.6 | 1678.9 | 1654.5 | 1659.8 | 413470.0 |
| 2019-06-05 | ZN | Futures | 125.745474 | 126.367053 | 125.714395 | 125.947487 | 75356.0 |
| 2019-06-05 | A6 | Futures | 0.72127 | 0.72302 | 0.71797 | 0.71838 | 116879.0 |
| 2019-06-05 | AD | Futures | 0.75504 | 0.75676 | 0.75307 | 0.75332 | 90401.0 |
| 2019-06-05 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-05 | B | Futures | 45.84 | 46.35 | 44.25 | 45.13 | 428010.0 |
| 2019-06-05 | B6 | Futures | 1.3016 | 1.3061 | 1.2996 | 1.3009 | 99882.0 |
| 2019-06-05 | BR | Futures | 0.20591 | 0.20631 | 0.20447 | 0.20447 | 124.0 |
| 2019-06-05 | BTC | Futures | 11563.3 | 12247.1 | 11425.0 | 12039.7 | 2851.0 |
| 2019-06-05 | BZ | Futures | 45.18 | 45.75 | 43.69 | 44.55 | 67012.0 |
| 2019-06-05 | C | Futures | 1723.0 | 1737.0 | 1706.0 | 1728.0 | 11876.0 |
| 2019-06-05 | CC | Futures | 1587.0 | 1603.0 | 1569.0 | 1602.0 | 20840.0 |
| 2019-06-05 | CNH | Futures | 6.9304 | 6.9403 | 6.9261 | 6.9402 | 907.0 |
| 2019-06-05 | CSC | Futures | 2.981 | 2.996 | 2.974 | 2.996 | 57.0 |
| 2019-06-05 | CT | Futures | 72.54 | 72.88 | 71.62 | 71.95 | 16640.0 |
| 2019-06-05 | DC | Futures | 25.1 | 25.3 | 25.01 | 25.29 | 115.0 |
| 2019-06-05 | DX | Futures | 93.029 | 93.269 | 92.646 | 93.217 | 25318.0 |
| 2019-06-05 | E1 | Futures | 1.17741 | 1.18546 | 1.17403 | 1.17484 | 60818.0 |
| 2019-06-05 | E6 | Futures | 1.23629 | 1.24216 | 1.23256 | 1.23333 | 268165.0 |
| 2019-06-05 | E7 | Futures | 1.23 | 1.2359 | 1.2265 | 1.2273 | 4231.0 |
| 2019-06-05 | EBM | Futures | 206.99 | 207.56 | 205.55 | 206.13 | 25051.0 |
| 2019-06-05 | ED | Futures | 95.26 | 95.2991 | 95.2551 | 95.2722 | 479064.0 |
| 2019-06-05 | ER | Futures | 98.435 | 98.445 | 98.43 | 98.44 | 155479.0 |
| 2019-06-05 | EW | Futures | 1981.2 | 1993.8 | 1966.7 | 1988.9 | 12213.0 |
| 2019-06-05 | FBON | Futures | 140.26 | 140.53 | 140.14 | 140.33 | 1067.0 |
| 2019-06-05 | FBTP | Futures | 116.44 | 116.92 | 115.42 | 116.57 | 181109.0 |
| 2019-06-05 | FBTS | Futures | 105.855 | 105.951 | 105.587 | 105.865 | 156495.0 |
| 2019-06-05 | FCE | Futures | 4772.1 | 4804.4 | 4765.3 | 4790.7 | 80040.0 |
| 2019-06-05 | FDAX | Futures | 12625.3 | 12692.2 | 12552.2 | 12611.1 | 118489.0 |
| 2019-06-05 | FDIV | Futures | 144.14 | 144.14 | 144.1 | 144.1 | 4.0 |
| 2019-06-05 | FDXM | Futures | 12518.0 | 12580.6 | 12443.9 | 12501.8 | 60723.0 |
| 2019-06-05 | FESX | Futures | 2916.5 | 2929.6 | 2903.3 | 2915.6 | 955809.0 |
| 2019-06-05 | FGBL | Futures | 162.59 | 162.89 | 162.45 | 162.75 | 914429.0 |
| 2019-06-05 | FGBM | Futures | 133.89 | 134.11 | 133.85 | 134.03 | 727642.0 |
| 2019-06-05 | FGBS | Futures | 112.885 | 112.95 | 112.87 | 112.925 | 441936.0 |
| 2019-06-05 | FGBX | Futures | 203.1 | 204.19 | 203.04 | 203.26 | 76561.0 |
| 2019-06-05 | FMWO | Futures | 7011.3 | 7051.8 | 6999.8 | 7021.7 | 2347.0 |
| 2019-06-05 | FOAT | Futures | 149.11 | 149.4 | 148.98 | 149.27 | 171414.0 |
| 2019-06-05 | FTDX | Futures | 2708.1 | 2751.1 | 2708.1 | 2731.8 | 179.0 |
| 2019-06-05 | FTI | Futures | 511.83 | 514.8 | 510.55 | 512.79 | 29314.0 |
| 2019-06-05 | FTUK | Futures | 6628.4 | 6650.0 | 6595.4 | 6611.9 | 78957.0 |
| 2019-06-05 | FVSA | Futures | 230.96 | 235.95 | 226.68 | 230.96 | 33292.0 |
| 2019-06-05 | FXXP | Futures | 333.4 | 335.1 | 332.7 | 334.1 | 65146.0 |
| 2019-06-05 | G | Futures | 119.39 | 119.8 | 119.24 | 119.53 | 218500.0 |
| 2019-06-05 | GF | Futures | 270.86 | 274.049 | 269.045 | 273.656 | 7364.0 |
| 2019-06-05 | GSCI | Futures | 456.62 | 456.62 | 451.07 | 451.07 | 96.0 |
> showing 50 of 119 rows — these rows as CSV