PREVIEW / futures_daily / 2014-04-07
file: by_date/futures_daily/2014/2014-04-07.parquet size: 9 KB rows: 103
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-04-07 | ES | Futures | 1925.46 | 1926.24 | 1898.04 | 1901.66 | 2179083.0 |
| 2014-04-07 | NQ | Futures | 4074.34 | 4078.08 | 3999.51 | 4028.0 | 511929.0 |
| 2014-04-07 | YM | Futures | 16421.0 | 16430.1 | 16233.3 | 16244.3 | 202695.0 |
| 2014-04-07 | CL | Futures | 180.08 | 180.81 | 178.31 | 179.24 | 254884.0 |
| 2014-04-07 | GC | Futures | 1718.1 | 1719.2 | 1707.3 | 1710.6 | 80277.0 |
| 2014-04-07 | ZN | Futures | 114.649481 | 114.968194 | 114.620508 | 114.837811 | 1123125.0 |
| 2014-04-07 | A6 | Futures | 0.8878 | 0.88866 | 0.88473 | 0.88636 | 47641.0 |
| 2014-04-07 | AD | Futures | 0.92171 | 0.92363 | 0.91937 | 0.92282 | 46146.0 |
| 2014-04-07 | B | Futures | 109.78 | 110.09 | 108.56 | 109.29 | 198756.0 |
| 2014-04-07 | B6 | Futures | 1.7408 | 1.7463 | 1.7401 | 1.7448 | 48181.0 |
| 2014-04-07 | BR | Futures | 0.23176 | 0.23457 | 0.23104 | 0.23457 | 547.0 |
| 2014-04-07 | BZ | Futures | 111.67 | 112.18 | 110.64 | 111.38 | 8607.0 |
| 2014-04-07 | C | Futures | 1966.0 | 1975.0 | 1958.0 | 1960.0 | 5952.0 |
| 2014-04-07 | CB | Futures | 93.923 | 93.923 | 93.593 | 93.669 | 32.0 |
| 2014-04-07 | CC | Futures | 2193.0 | 2208.0 | 2181.0 | 2192.0 | 16941.0 |
| 2014-04-07 | CNH | Futures | 7.1349 | 7.1364 | 7.1328 | 7.1328 | 40.0 |
| 2014-04-07 | CSC | Futures | 4.444 | 4.459 | 4.408 | 4.446 | 37.0 |
| 2014-04-07 | CT | Futures | 103.85 | 104.37 | 101.75 | 101.85 | 17399.0 |
| 2014-04-07 | DC | Futures | 35.48 | 35.67 | 35.23 | 35.46 | 234.0 |
| 2014-04-07 | DX | Futures | 76.544 | 76.567 | 76.297 | 76.339 | 10474.0 |
| 2014-04-07 | E1 | Futures | 1.43943 | 1.44713 | 1.43892 | 1.44649 | 22327.0 |
| 2014-04-07 | E6 | Futures | 1.61711 | 1.62289 | 1.61663 | 1.62171 | 104869.0 |
| 2014-04-07 | E7 | Futures | 1.6061 | 1.6121 | 1.6059 | 1.6109 | 2040.0 |
| 2014-04-07 | EBM | Futures | 292.4 | 294.52 | 291.7 | 292.05 | 14164.0 |
| 2014-04-07 | ED | Futures | 95.4043 | 95.4091 | 95.3995 | 95.4043 | 80912.0 |
| 2014-04-07 | ER | Futures | 97.832 | 97.862 | 97.822 | 97.837 | 62828.0 |
| 2014-04-07 | EW | Futures | 1408.4 | 1408.5 | 1377.9 | 1383.1 | 21286.0 |
| 2014-04-07 | FBTP | Futures | 88.22 | 88.35 | 87.89 | 88.04 | 57680.0 |
| 2014-04-07 | FBTS | Futures | 97.566 | 97.619 | 97.522 | 97.557 | 9853.0 |
| 2014-04-07 | FCE | Futures | 3459.0 | 3471.4 | 3436.1 | 3452.4 | 119080.0 |
| 2014-04-07 | FDAX | Futures | 10633.4 | 10647.8 | 10458.4 | 10517.5 | 131724.0 |
| 2014-04-07 | FESX | Futures | 2253.5 | 2261.4 | 2229.1 | 2242.7 | 1063558.0 |
| 2014-04-07 | FGBL | Futures | 123.98 | 124.08 | 123.69 | 123.98 | 555997.0 |
| 2014-04-07 | FGBM | Futures | 119.81 | 119.85 | 119.64 | 119.75 | 380444.0 |
| 2014-04-07 | FGBS | Futures | 110.513 | 110.523 | 110.478 | 110.493 | 240054.0 |
| 2014-04-07 | FGBX | Futures | 126.52 | 126.7 | 125.83 | 126.48 | 19228.0 |
| 2014-04-07 | FMWO | Futures | 5509.0 | 5509.0 | 5502.7 | 5502.7 | 50.0 |
| 2014-04-07 | FOAT | Futures | 113.38 | 113.38 | 112.93 | 113.14 | 52198.0 |
| 2014-04-07 | FTDX | Futures | 1181.7 | 1181.7 | 1157.3 | 1159.7 | 185.0 |
| 2014-04-07 | FTI | Futures | 345.39 | 346.8 | 343.64 | 345.01 | 28302.0 |
| 2014-04-07 | FTUK | Futures | 5032.6 | 5047.8 | 4979.6 | 5005.9 | 109148.0 |
| 2014-04-07 | FVSA | Futures | 1770.45 | 1820.6 | 1750.39 | 1800.54 | 7333.0 |
| 2014-04-07 | FXXP | Futures | 248.8 | 249.4 | 246.7 | 247.9 | 6762.0 |
| 2014-04-07 | G | Futures | 93.86 | 94.03 | 93.76 | 93.96 | 96641.0 |
| 2014-04-07 | GF | Futures | 284.398 | 284.719 | 283.038 | 284.158 | 635.0 |
| 2014-04-07 | GSCI | Futures | 1062.98 | 1067.94 | 1057.52 | 1062.81 | 1525.0 |
| 2014-04-07 | HE | Futures | 139.164 | 140.972 | 137.181 | 140.855 | 371.0 |
| 2014-04-07 | HG | Futures | 3.8342 | 3.8716 | 3.7721 | 3.8519 | 50556.0 |
| 2014-04-07 | HH | Futures | 56.706 | 57.212 | 56.503 | 56.655 | 127.0 |
| 2014-04-07 | HO | Futures | 2.3128 | 2.3175 | 2.2856 | 2.3006 | 22740.0 |
> showing 50 of 103 rows — these rows as CSV