PREVIEW / futures_daily / 2013-11-07
file: by_date/futures_daily/2013/2013-11-07.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-07 | ES | Futures | 1811.77 | 1822.81 | 1789.68 | 1792.77 | 2463701.0 |
| 2013-11-07 | NQ | Futures | 3875.13 | 3890.06 | 3806.51 | 3812.53 | 404482.0 |
| 2013-11-07 | YM | Futures | 15599.5 | 15700.0 | 15461.2 | 15489.1 | 209613.0 |
| 2013-11-07 | CL | Futures | 168.87 | 169.58 | 166.9 | 167.61 | 260597.0 |
| 2013-11-07 | GC | Futures | 1742.5 | 1753.7 | 1714.0 | 1730.5 | 188109.0 |
| 2013-11-07 | ZN | Futures | 115.022669 | 115.49001 | 114.980183 | 115.235097 | 1270096.0 |
| 2013-11-07 | A6 | Futures | 0.89709 | 0.89765 | 0.88934 | 0.89123 | 116341.0 |
| 2013-11-07 | AD | Futures | 0.96844 | 0.97005 | 0.9647 | 0.96642 | 48787.0 |
| 2013-11-07 | B | Futures | 105.04 | 105.28 | 103.41 | 103.56 | 225426.0 |
| 2013-11-07 | B6 | Futures | 1.6873 | 1.6911 | 1.68 | 1.6883 | 123824.0 |
| 2013-11-07 | BR | Futures | 0.2212 | 0.2228 | 0.21906 | 0.21965 | 1220.0 |
| 2013-11-07 | BZ | Futures | 105.89 | 105.96 | 104.1 | 104.25 | 10881.0 |
| 2013-11-07 | C | Futures | 1843.0 | 1845.0 | 1806.0 | 1819.0 | 4755.0 |
| 2013-11-07 | CB | Futures | 72.032 | 72.416 | 72.008 | 72.044 | 14.0 |
| 2013-11-07 | CC | Futures | 2034.0 | 2037.0 | 1974.0 | 1999.0 | 25720.0 |
| 2013-11-07 | CSC | Futures | 3.426 | 3.426 | 3.426 | 3.426 | 1.0 |
| 2013-11-07 | CT | Futures | 90.41 | 91.2 | 89.41 | 90.05 | 14536.0 |
| 2013-11-07 | DC | Futures | 26.07 | 26.15 | 25.89 | 26.07 | 168.0 |
| 2013-11-07 | DX | Futures | 76.819 | 77.715 | 76.719 | 77.037 | 42947.0 |
| 2013-11-07 | E1 | Futures | 1.40935 | 1.41128 | 1.3884 | 1.40331 | 62516.0 |
| 2013-11-07 | E6 | Futures | 1.59504 | 1.59669 | 1.56884 | 1.58465 | 437521.0 |
| 2013-11-07 | E7 | Futures | 1.5848 | 1.5864 | 1.5588 | 1.5744 | 8353.0 |
| 2013-11-07 | ED | Futures | 95.3638 | 95.3686 | 95.359 | 95.3638 | 102665.0 |
| 2013-11-07 | ER | Futures | 97.876 | 97.93 | 97.876 | 97.901 | 189605.0 |
| 2013-11-07 | EW | Futures | 1311.1 | 1321.4 | 1289.3 | 1291.0 | 26275.0 |
| 2013-11-07 | FBTP | Futures | 80.71 | 81.85 | 80.68 | 81.49 | 61631.0 |
| 2013-11-07 | FBTS | Futures | 94.837 | 95.269 | 94.828 | 95.148 | 10827.0 |
| 2013-11-07 | FCE | Futures | 3312.9 | 3373.0 | 3283.8 | 3314.1 | 198441.0 |
| 2013-11-07 | FDAX | Futures | 10022.6 | 10206.2 | 9990.4 | 10081.9 | 167174.0 |
| 2013-11-07 | FESX | Futures | 2135.8 | 2175.7 | 2109.8 | 2131.5 | 1546842.0 |
| 2013-11-07 | FEU3 | Futures | 98.527 | 98.527 | 98.522 | 98.522 | 22.0 |
| 2013-11-07 | FGBL | Futures | 120.23 | 121.0 | 120.11 | 120.77 | 803496.0 |
| 2013-11-07 | FGBM | Futures | 118.26 | 118.91 | 118.21 | 118.68 | 775331.0 |
| 2013-11-07 | FGBS | Futures | 110.528 | 110.698 | 110.513 | 110.618 | 538396.0 |
| 2013-11-07 | FGBX | Futures | 120.74 | 121.44 | 120.35 | 121.24 | 23957.0 |
| 2013-11-07 | FMWO | Futures | 5245.9 | 5245.9 | 5245.9 | 5245.9 | 0.0 |
| 2013-11-07 | FOAT | Futures | 108.19 | 108.87 | 108.02 | 108.65 | 103888.0 |
| 2013-11-07 | FTDX | Futures | 1080.3 | 1085.5 | 1073.7 | 1076.1 | 519.0 |
| 2013-11-07 | FTI | Futures | 339.23 | 343.46 | 336.42 | 339.1 | 40201.0 |
| 2013-11-07 | FTUK | Futures | 5041.9 | 5073.1 | 4970.3 | 5008.6 | 101727.0 |
| 2013-11-07 | FVSA | Futures | 2081.43 | 2105.77 | 2008.39 | 2093.6 | 7357.0 |
| 2013-11-07 | FXXP | Futures | 235.5 | 239.2 | 233.9 | 235.6 | 5072.0 |
| 2013-11-07 | G | Futures | 92.43 | 92.83 | 92.26 | 92.75 | 168683.0 |
| 2013-11-07 | GF | Futures | 265.713 | 266.237 | 264.825 | 265.551 | 1140.0 |
| 2013-11-07 | GSCI | Futures | 1015.1 | 1015.1 | 1007.26 | 1007.26 | 2138.0 |
| 2013-11-07 | HE | Futures | 110.876 | 111.383 | 110.149 | 110.813 | 27082.0 |
| 2013-11-07 | HG | Futures | 4.1082 | 4.1246 | 4.0841 | 4.1133 | 59483.0 |
| 2013-11-07 | HH | Futures | 36.832 | 36.945 | 35.95 | 36.104 | 1162.0 |
| 2013-11-07 | HO | Futures | 2.2971 | 2.305 | 2.2655 | 2.2741 | 56633.0 |
| 2013-11-07 | HRC | Futures | 2367.6 | 2367.6 | 2367.6 | 2367.6 | 0.0 |
> showing 50 of 102 rows — these rows as CSV