PREVIEW / futures_daily / 2015-08-20
file: by_date/futures_daily/2015/2015-08-20.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-20 | ES | Futures | 2197.53 | 2202.04 | 2145.6 | 2146.66 | 2583142.0 |
| 2015-08-20 | NQ | Futures | 5256.46 | 5269.01 | 5090.38 | 5097.68 | 449728.0 |
| 2015-08-20 | YM | Futures | 17757.2 | 17788.0 | 17364.9 | 17374.1 | 240919.0 |
| 2015-08-20 | CL | Futures | 66.84 | 68.19 | 66.06 | 67.39 | 380433.0 |
| 2015-08-20 | GC | Futures | 1463.0 | 1489.3 | 1461.4 | 1488.7 | 187177.0 |
| 2015-08-20 | ZN | Futures | 122.150843 | 122.553244 | 122.121036 | 122.404207 | 1086808.0 |
| 2015-08-20 | A6 | Futures | 0.72702 | 0.7295 | 0.72068 | 0.72603 | 85292.0 |
| 2015-08-20 | AD | Futures | 0.77915 | 0.78283 | 0.77588 | 0.78078 | 67394.0 |
| 2015-08-20 | ALI | Futures | 2137.56 | 2149.14 | 2134.98 | 2149.14 | 10.0 |
| 2015-08-20 | B | Futures | 43.53 | 43.86 | 42.61 | 43.15 | 221543.0 |
| 2015-08-20 | B6 | Futures | 1.6502 | 1.6525 | 1.6423 | 1.6498 | 87359.0 |
| 2015-08-20 | BFX | Futures | 4339.3 | 4339.3 | 4280.6 | 4284.7 | 27.0 |
| 2015-08-20 | BR | Futures | 0.17125 | 0.17293 | 0.16964 | 0.17281 | 1921.0 |
| 2015-08-20 | BZ | Futures | 43.51 | 43.8 | 42.57 | 43.11 | 21904.0 |
| 2015-08-20 | C | Futures | 2200.0 | 2220.0 | 2189.0 | 2215.0 | 2238.0 |
| 2015-08-20 | CB | Futures | 188.029 | 198.16 | 188.029 | 197.35 | 52.0 |
| 2015-08-20 | CC | Futures | 2267.0 | 2304.0 | 2259.0 | 2299.0 | 14719.0 |
| 2015-08-20 | CNH | Futures | 7.2571 | 7.2635 | 7.2571 | 7.2624 | 37.0 |
| 2015-08-20 | CSC | Futures | 4.503 | 4.546 | 4.478 | 4.533 | 161.0 |
| 2015-08-20 | CT | Futures | 82.53 | 82.87 | 81.99 | 82.8 | 9.0 |
| 2015-08-20 | DC | Futures | 36.05 | 36.57 | 35.88 | 36.4 | 397.0 |
| 2015-08-20 | DX | Futures | 90.304 | 90.417 | 89.598 | 89.866 | 47784.0 |
| 2015-08-20 | E1 | Futures | 1.31665 | 1.32592 | 1.31399 | 1.32135 | 20449.0 |
| 2015-08-20 | E6 | Futures | 1.30706 | 1.32151 | 1.30518 | 1.31599 | 247056.0 |
| 2015-08-20 | E7 | Futures | 1.2998 | 1.3141 | 1.2981 | 1.3087 | 4692.0 |
| 2015-08-20 | EBM | Futures | 279.54 | 279.95 | 272.17 | 277.08 | 10121.0 |
| 2015-08-20 | ED | Futures | 95.6462 | 95.6558 | 95.639 | 95.6486 | 204004.0 |
| 2015-08-20 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.126 | 7521.0 |
| 2015-08-20 | EW | Futures | 1556.7 | 1561.3 | 1517.9 | 1518.8 | 28185.0 |
| 2015-08-20 | FBTP | Futures | 101.34 | 101.63 | 101.08 | 101.14 | 71495.0 |
| 2015-08-20 | FBTS | Futures | 100.115 | 100.159 | 100.062 | 100.062 | 13690.0 |
| 2015-08-20 | FCE | Futures | 4090.0 | 4093.8 | 3964.8 | 4005.0 | 74108.0 |
| 2015-08-20 | FDAX | Futures | 11782.5 | 11782.5 | 11386.7 | 11530.5 | 149154.0 |
| 2015-08-20 | FDIV | Futures | 143.9 | 143.9 | 141.17 | 141.17 | 12.0 |
| 2015-08-20 | FESX | Futures | 2534.8 | 2537.0 | 2454.8 | 2483.7 | 1595078.0 |
| 2015-08-20 | FEU3 | Futures | 98.769 | 98.769 | 98.764 | 98.769 | 71.0 |
| 2015-08-20 | FGBL | Futures | 138.69 | 138.97 | 138.51 | 138.81 | 544906.0 |
| 2015-08-20 | FGBM | Futures | 125.07 | 125.18 | 125.03 | 125.12 | 371684.0 |
| 2015-08-20 | FGBS | Futures | 111.288 | 111.298 | 111.278 | 111.293 | 143555.0 |
| 2015-08-20 | FGBX | Futures | 160.05 | 160.72 | 159.21 | 160.29 | 20763.0 |
| 2015-08-20 | FMWO | Futures | 5671.1 | 5671.1 | 5652.6 | 5655.1 | 160.0 |
| 2015-08-20 | FOAT | Futures | 126.44 | 126.7 | 126.3 | 126.42 | 53760.0 |
| 2015-08-20 | FTDX | Futures | 1648.5 | 1648.5 | 1559.0 | 1590.5 | 646.0 |
| 2015-08-20 | FTI | Futures | 403.62 | 403.71 | 390.89 | 394.72 | 22837.0 |
| 2015-08-20 | FTUK | Futures | 5079.4 | 5089.8 | 5010.3 | 5058.0 | 135834.0 |
| 2015-08-20 | FVSA | Futures | 1929.56 | 1989.33 | 1886.88 | 1942.37 | 12952.0 |
| 2015-08-20 | FXXP | Futures | 292.2 | 292.2 | 284.3 | 287.0 | 29722.0 |
| 2015-08-20 | G | Futures | 103.54 | 103.95 | 103.44 | 103.83 | 218539.0 |
| 2015-08-20 | GF | Futures | 355.778 | 357.33 | 354.312 | 356.597 | 1634.0 |
| 2015-08-20 | GSCI | Futures | 584.84 | 584.84 | 583.03 | 584.52 | 52.0 |
> showing 50 of 108 rows — these rows as CSV