PREVIEW / futures_daily / 2013-08-07
file: by_date/futures_daily/2013/2013-08-07.parquet size: 9 KB rows: 101
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-08-07 | ES | Futures | 1743.47 | 1744.24 | 1730.85 | 1738.84 | 1384518.0 |
| 2013-08-07 | NQ | Futures | 3606.46 | 3608.48 | 3575.22 | 3604.43 | 228788.0 |
| 2013-08-07 | YM | Futures | 15325.3 | 15329.2 | 15239.0 | 15305.5 | 106888.0 |
| 2013-08-07 | CL | Futures | 184.57 | 184.73 | 181.81 | 182.28 | 294242.0 |
| 2013-08-07 | GC | Futures | 1694.4 | 1704.8 | 1682.0 | 1699.9 | 113264.0 |
| 2013-08-07 | ZN | Futures | 113.517447 | 113.868372 | 113.489372 | 113.770113 | 946211.0 |
| 2013-08-07 | A6 | Futures | 0.84049 | 0.84462 | 0.83458 | 0.84124 | 78173.0 |
| 2013-08-07 | AD | Futures | 0.97026 | 0.97086 | 0.96361 | 0.96573 | 66820.0 |
| 2013-08-07 | B | Futures | 104.78 | 104.97 | 103.83 | 104.13 | 189762.0 |
| 2013-08-07 | B6 | Futures | 1.6091 | 1.6281 | 1.5937 | 1.6243 | 227361.0 |
| 2013-08-07 | BR | Futures | 0.2139 | 0.2146 | 0.21271 | 0.21331 | 150.0 |
| 2013-08-07 | BZ | Futures | 105.42 | 105.6 | 104.61 | 104.89 | 7486.0 |
| 2013-08-07 | C | Futures | 1712.0 | 1754.0 | 1707.0 | 1744.0 | 10070.0 |
| 2013-08-07 | CC | Futures | 1779.0 | 1839.0 | 1770.0 | 1832.0 | 28923.0 |
| 2013-08-07 | CNH | Futures | 7.1037 | 7.1037 | 7.0983 | 7.0983 | 10.0 |
| 2013-08-07 | CSC | Futures | 3.395 | 3.398 | 3.395 | 3.398 | 1.0 |
| 2013-08-07 | CT | Futures | 102.66 | 105.47 | 102.66 | 105.43 | 27.0 |
| 2013-08-07 | DC | Futures | 25.51 | 26.24 | 25.48 | 26.11 | 461.0 |
| 2013-08-07 | DX | Futures | 78.009 | 78.252 | 77.669 | 77.72 | 39514.0 |
| 2013-08-07 | E1 | Futures | 1.38841 | 1.39638 | 1.38416 | 1.39496 | 28622.0 |
| 2013-08-07 | E6 | Futures | 1.57049 | 1.57533 | 1.56566 | 1.57356 | 209744.0 |
| 2013-08-07 | E7 | Futures | 1.5605 | 1.5649 | 1.5554 | 1.5633 | 4028.0 |
| 2013-08-07 | ED | Futures | 95.3012 | 95.306 | 95.2964 | 95.2964 | 80559.0 |
| 2013-08-07 | ER | Futures | 97.817 | 97.827 | 97.817 | 97.822 | 23737.0 |
| 2013-08-07 | EW | Futures | 1261.6 | 1262.3 | 1248.9 | 1252.6 | 16076.0 |
| 2013-08-07 | FBTP | Futures | 78.54 | 78.67 | 78.43 | 78.54 | 17811.0 |
| 2013-08-07 | FBTS | Futures | 93.221 | 93.272 | 93.195 | 93.229 | 2751.0 |
| 2013-08-07 | FCE | Futures | 3105.7 | 3129.7 | 3100.7 | 3122.7 | 70813.0 |
| 2013-08-07 | FDAX | Futures | 9155.3 | 9194.7 | 9135.8 | 9160.3 | 75813.0 |
| 2013-08-07 | FESX | Futures | 1947.8 | 1964.6 | 1947.1 | 1958.3 | 656984.0 |
| 2013-08-07 | FGBL | Futures | 119.01 | 119.36 | 118.76 | 119.12 | 583788.0 |
| 2013-08-07 | FGBM | Futures | 116.93 | 117.18 | 116.87 | 117.02 | 385989.0 |
| 2013-08-07 | FGBS | Futures | 110.263 | 110.308 | 110.258 | 110.273 | 200786.0 |
| 2013-08-07 | FGBX | Futures | 123.31 | 123.84 | 122.9 | 123.44 | 9100.0 |
| 2013-08-07 | FMWO | Futures | 4977.5 | 4977.5 | 4977.5 | 4977.5 | 0.0 |
| 2013-08-07 | FOAT | Futures | 106.46 | 106.76 | 106.38 | 106.67 | 26940.0 |
| 2013-08-07 | FTDX | Futures | 950.3 | 957.4 | 949.9 | 954.6 | 91.0 |
| 2013-08-07 | FTI | Futures | 322.52 | 323.96 | 322.03 | 322.78 | 30783.0 |
| 2013-08-07 | FTUK | Futures | 4914.4 | 4947.0 | 4839.4 | 4864.2 | 111032.0 |
| 2013-08-07 | FVSA | Futures | 2659.72 | 2695.28 | 2617.05 | 2681.06 | 2461.0 |
| 2013-08-07 | FXXP | Futures | 222.8 | 223.3 | 221.4 | 222.7 | 7473.0 |
| 2013-08-07 | G | Futures | 93.99 | 94.32 | 93.18 | 93.91 | 180920.0 |
| 2013-08-07 | GF | Futures | 259.894 | 259.978 | 256.609 | 257.072 | 2279.0 |
| 2013-08-07 | GSCI | Futures | 1034.98 | 1037.36 | 1030.24 | 1031.8 | 1772.0 |
| 2013-08-07 | HE | Futures | 104.641 | 105.246 | 102.615 | 102.736 | 26313.0 |
| 2013-08-07 | HG | Futures | 3.9867 | 4.0463 | 3.9696 | 4.026 | 61239.0 |
| 2013-08-07 | HH | Futures | 35.97 | 35.97 | 35.705 | 35.771 | 5607.0 |
| 2013-08-07 | HO | Futures | 2.4159 | 2.4189 | 2.3771 | 2.3805 | 66260.0 |
| 2013-08-07 | HRC | Futures | 2238.5 | 2238.5 | 2238.5 | 2238.5 | 0.0 |
| 2013-08-07 | J1 | Futures | 0.012871 | 0.0130673 | 0.012871 | 0.0130585 | 167597.0 |
> showing 50 of 101 rows — these rows as CSV