PREVIEW / futures_daily / 2016-06-06
file: by_date/futures_daily/2016/2016-06-06.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 |
|---|---|---|---|---|---|---|---|
| 2016-06-06 | ES | Futures | 2252.12 | 2267.96 | 2248.36 | 2263.67 | 1272974.0 |
| 2016-06-06 | NQ | Futures | 5300.46 | 5330.42 | 5292.23 | 5317.49 | 164530.0 |
| 2016-06-06 | YM | Futures | 18515.9 | 18652.1 | 18485.8 | 18627.2 | 119862.0 |
| 2016-06-06 | CL | Futures | 57.3 | 58.5 | 57.1 | 58.25 | 450472.0 |
| 2016-06-06 | GC | Futures | 1602.4 | 1609.8 | 1598.0 | 1604.8 | 162935.0 |
| 2016-06-06 | ZN | Futures | 126.490569 | 126.490569 | 126.143565 | 126.354785 | 40491.0 |
| 2016-06-06 | A6 | Futures | 0.74531 | 0.74683 | 0.74015 | 0.74652 | 103514.0 |
| 2016-06-06 | AD | Futures | 0.78995 | 0.79854 | 0.7876 | 0.79803 | 67305.0 |
| 2016-06-06 | ALI | Futures | 2084.33 | 2084.33 | 2076.29 | 2076.29 | 13.0 |
| 2016-06-06 | B | Futures | 40.39 | 41.2 | 40.3 | 40.97 | 223756.0 |
| 2016-06-06 | B6 | Futures | 1.5248 | 1.5252 | 1.5111 | 1.5225 | 151865.0 |
| 2016-06-06 | BR | Futures | 0.18373 | 0.18572 | 0.18373 | 0.18572 | 168.0 |
| 2016-06-06 | BZ | Futures | 40.28 | 41.09 | 40.2 | 40.87 | 22446.0 |
| 2016-06-06 | C | Futures | 2344.0 | 2379.0 | 2344.0 | 2362.0 | 9938.0 |
| 2016-06-06 | CB | Futures | 264.362 | 264.977 | 261.988 | 264.977 | 18.0 |
| 2016-06-06 | CC | Futures | 2217.0 | 2257.0 | 2202.0 | 2238.0 | 17757.0 |
| 2016-06-06 | CNH | Futures | 7.1222 | 7.1386 | 7.1194 | 7.1194 | 39.0 |
| 2016-06-06 | CSC | Futures | 3.405 | 3.513 | 3.405 | 3.479 | 104.0 |
| 2016-06-06 | CT | Futures | 72.63 | 74.96 | 72.58 | 74.56 | 29937.0 |
| 2016-06-06 | DC | Futures | 27.12 | 27.79 | 27.12 | 27.61 | 325.0 |
| 2016-06-06 | DX | Futures | 87.586 | 87.885 | 87.395 | 87.535 | 30339.0 |
| 2016-06-06 | E1 | Futures | 1.28851 | 1.29806 | 1.28562 | 1.29605 | 33008.0 |
| 2016-06-06 | E6 | Futures | 1.32572 | 1.32893 | 1.32112 | 1.32672 | 196056.0 |
| 2016-06-06 | E7 | Futures | 1.3187 | 1.3217 | 1.3141 | 1.3195 | 2127.0 |
| 2016-06-06 | EBM | Futures | 205.69 | 209.3 | 205.39 | 205.99 | 19249.0 |
| 2016-06-06 | ED | Futures | 95.7401 | 95.7497 | 95.7328 | 95.7473 | 241210.0 |
| 2016-06-06 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.269 | 19607.0 |
| 2016-06-06 | EW | Futures | 1585.8 | 1601.7 | 1582.5 | 1599.2 | 16757.0 |
| 2016-06-06 | FBON | Futures | 119.61 | 119.61 | 119.21 | 119.26 | 1657.0 |
| 2016-06-06 | FBTP | Futures | 107.46 | 107.62 | 106.86 | 107.05 | 168308.0 |
| 2016-06-06 | FBTS | Futures | 101.167 | 101.194 | 101.15 | 101.158 | 39869.0 |
| 2016-06-06 | FCE | Futures | 3801.3 | 3815.1 | 3785.4 | 3803.9 | 85858.0 |
| 2016-06-06 | FDAX | Futures | 10879.0 | 10906.4 | 10840.9 | 10884.4 | 81265.0 |
| 2016-06-06 | FDXM | Futures | 10470.9 | 10502.0 | 10438.9 | 10481.3 | 12528.0 |
| 2016-06-06 | FESX | Futures | 2338.4 | 2347.8 | 2326.7 | 2340.8 | 988321.0 |
| 2016-06-06 | FGBL | Futures | 147.67 | 147.75 | 147.44 | 147.52 | 892829.0 |
| 2016-06-06 | FGBM | Futures | 127.92 | 127.92 | 127.82 | 127.84 | 915103.0 |
| 2016-06-06 | FGBS | Futures | 111.713 | 111.723 | 111.693 | 111.708 | 652351.0 |
| 2016-06-06 | FGBX | Futures | 177.22 | 177.5 | 176.52 | 176.72 | 58555.0 |
| 2016-06-06 | FMWO | Futures | 5729.8 | 5752.2 | 5722.3 | 5748.4 | 217.0 |
| 2016-06-06 | FOAT | Futures | 135.05 | 135.17 | 134.8 | 134.88 | 128535.0 |
| 2016-06-06 | FTDX | Futures | 1611.8 | 1612.8 | 1603.3 | 1603.3 | 140.0 |
| 2016-06-06 | FTI | Futures | 400.39 | 402.14 | 399.13 | 400.75 | 20855.0 |
| 2016-06-06 | FTUK | Futures | 5128.2 | 5194.2 | 5128.2 | 5179.4 | 119630.0 |
| 2016-06-06 | FVSA | Futures | 2406.3 | 2429.57 | 2383.02 | 2406.3 | 4453.0 |
| 2016-06-06 | FXXP | Futures | 273.8 | 275.4 | 272.6 | 275.1 | 20770.0 |
| 2016-06-06 | G | Futures | 110.27 | 110.35 | 110.02 | 110.1 | 148611.0 |
| 2016-06-06 | GF | Futures | 294.932 | 296.579 | 285.597 | 290.589 | 4943.0 |
| 2016-06-06 | GSCI | Futures | 548.37 | 549.82 | 546.93 | 547.29 | 423.0 |
| 2016-06-06 | HE | Futures | 103.755 | 105.168 | 103.153 | 104.446 | 17744.0 |
> showing 50 of 108 rows — these rows as CSV