PREVIEW / futures_daily / 2014-06-05
file: by_date/futures_daily/2014/2014-06-05.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-05 | ES | Futures | 1992.19 | 2007.97 | 1987.54 | 2005.64 | 1676659.0 |
| 2014-06-05 | NQ | Futures | 4309.16 | 4353.48 | 4298.23 | 4346.86 | 283290.0 |
| 2014-06-05 | YM | Futures | 16789.5 | 16906.0 | 16764.4 | 16886.9 | 157899.0 |
| 2014-06-05 | CL | Futures | 186.21 | 186.79 | 184.81 | 186.41 | 200402.0 |
| 2014-06-05 | GC | Futures | 1639.5 | 1657.4 | 1635.4 | 1651.3 | 125573.0 |
| 2014-06-05 | ZN | Futures | 116.083686 | 116.387912 | 115.808435 | 116.228556 | 37798.0 |
| 2014-06-05 | A6 | Futures | 0.89068 | 0.8975 | 0.88895 | 0.89654 | 85493.0 |
| 2014-06-05 | AD | Futures | 0.92647 | 0.9286 | 0.92475 | 0.92779 | 63344.0 |
| 2014-06-05 | ALI | Futures | 2768.73 | 2768.73 | 2768.73 | 2768.73 | 20.0 |
| 2014-06-05 | B | Futures | 112.44 | 113.32 | 112.11 | 113.15 | 156260.0 |
| 2014-06-05 | B6 | Futures | 1.759 | 1.7683 | 1.7574 | 1.7672 | 130875.0 |
| 2014-06-05 | BFX | Futures | 3804.4 | 3837.3 | 3804.4 | 3818.5 | 27.0 |
| 2014-06-05 | BR | Futures | 0.22646 | 0.22759 | 0.22585 | 0.22709 | 23.0 |
| 2014-06-05 | BZ | Futures | 113.38 | 114.29 | 113.1 | 114.14 | 15842.0 |
| 2014-06-05 | C | Futures | 2034.0 | 2039.0 | 2019.0 | 2031.0 | 11095.0 |
| 2014-06-05 | CB | Futures | 109.554 | 109.834 | 109.275 | 109.554 | 13.0 |
| 2014-06-05 | CC | Futures | 2270.0 | 2280.0 | 2256.0 | 2268.0 | 15237.0 |
| 2014-06-05 | CNH | Futures | 7.1742 | 7.1793 | 7.1699 | 7.1699 | 1.0 |
| 2014-06-05 | CSC | Futures | 4.41 | 4.455 | 4.41 | 4.45 | 17.0 |
| 2014-06-05 | CT | Futures | 96.93 | 97.23 | 96.21 | 96.27 | 13254.0 |
| 2014-06-05 | DC | Futures | 34.92 | 35.25 | 34.89 | 35.25 | 41.0 |
| 2014-06-05 | DX | Futures | 76.653 | 77.014 | 76.33 | 76.385 | 53912.0 |
| 2014-06-05 | E1 | Futures | 1.43058 | 1.44072 | 1.42005 | 1.43943 | 81208.0 |
| 2014-06-05 | E6 | Futures | 1.60554 | 1.61392 | 1.59397 | 1.61238 | 505682.0 |
| 2014-06-05 | E7 | Futures | 1.5948 | 1.603 | 1.5833 | 1.6016 | 6220.0 |
| 2014-06-05 | ED | Futures | 95.4138 | 95.4138 | 95.4091 | 95.4138 | 83660.0 |
| 2014-06-05 | ER | Futures | 97.891 | 97.921 | 97.867 | 97.906 | 476181.0 |
| 2014-06-05 | EW | Futures | 1431.7 | 1447.6 | 1427.1 | 1446.6 | 15985.0 |
| 2014-06-05 | FBTP | Futures | 89.48 | 90.12 | 89.41 | 89.96 | 106172.0 |
| 2014-06-05 | FBTS | Futures | 97.627 | 97.965 | 97.547 | 97.876 | 29096.0 |
| 2014-06-05 | FCE | Futures | 3595.6 | 3655.1 | 3579.6 | 3629.1 | 156490.0 |
| 2014-06-05 | FDAX | Futures | 10970.2 | 11061.9 | 10928.3 | 10986.2 | 135231.0 |
| 2014-06-05 | FDIV | Futures | 150.94 | 151.19 | 150.94 | 151.19 | 20.0 |
| 2014-06-05 | FESX | Futures | 2327.5 | 2365.6 | 2316.7 | 2346.2 | 1561720.0 |
| 2014-06-05 | FEU3 | Futures | 98.517 | 98.527 | 98.507 | 98.527 | 148.0 |
| 2014-06-05 | FGBL | Futures | 125.93 | 126.28 | 125.24 | 126.09 | 1211601.0 |
| 2014-06-05 | FGBM | Futures | 120.78 | 121.06 | 120.58 | 120.98 | 908570.0 |
| 2014-06-05 | FGBS | Futures | 110.748 | 110.783 | 110.683 | 110.728 | 685368.0 |
| 2014-06-05 | FGBX | Futures | 130.1 | 130.4 | 128.06 | 129.9 | 54880.0 |
| 2014-06-05 | FMWO | Futures | 5703.3 | 5728.5 | 5703.3 | 5728.5 | 33.0 |
| 2014-06-05 | FOAT | Futures | 115.28 | 115.77 | 114.94 | 115.59 | 142752.0 |
| 2014-06-05 | FTDX | Futures | 1224.8 | 1230.0 | 1219.2 | 1223.4 | 2540.0 |
| 2014-06-05 | FTI | Futures | 352.22 | 356.89 | 350.84 | 354.9 | 41309.0 |
| 2014-06-05 | FTUK | Futures | 5193.4 | 5216.3 | 5174.8 | 5188.9 | 94938.0 |
| 2014-06-05 | FVSA | Futures | 1554.99 | 1569.0 | 1461.6 | 1470.94 | 22162.0 |
| 2014-06-05 | FXXP | Futures | 257.5 | 260.7 | 256.9 | 258.7 | 5752.0 |
| 2014-06-05 | G | Futures | 93.45 | 93.84 | 93.14 | 93.53 | 173942.0 |
| 2014-06-05 | GF | Futures | 304.986 | 306.826 | 304.603 | 306.251 | 3343.0 |
| 2014-06-05 | GSCI | Futures | 1067.16 | 1072.05 | 1065.67 | 1070.39 | 403.0 |
| 2014-06-05 | HE | Futures | 127.814 | 129.103 | 126.578 | 128.55 | 16616.0 |
> showing 50 of 107 rows — these rows as CSV