PREVIEW / futures_daily / 2014-07-02
file: by_date/futures_daily/2014/2014-07-02.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-07-02 | ES | Futures | 2042.53 | 2046.43 | 2040.72 | 2044.09 | 920982.0 |
| 2014-07-02 | NQ | Futures | 4483.01 | 4495.7 | 4480.12 | 4487.91 | 150116.0 |
| 2014-07-02 | YM | Futures | 17031.7 | 17062.9 | 17024.6 | 17050.8 | 74313.0 |
| 2014-07-02 | CL | Futures | 192.18 | 192.77 | 190.16 | 190.85 | 240067.0 |
| 2014-07-02 | GC | Futures | 1748.6 | 1756.6 | 1742.0 | 1753.6 | 114091.0 |
| 2014-07-02 | ZN | Futures | 116.579503 | 116.696214 | 116.127249 | 116.141838 | 1074349.0 |
| 2014-07-02 | A6 | Futures | 0.91287 | 0.91316 | 0.90668 | 0.90746 | 72635.0 |
| 2014-07-02 | AD | Futures | 0.95338 | 0.95399 | 0.95003 | 0.95034 | 38616.0 |
| 2014-07-02 | ALI | Futures | 2834.67 | 2834.67 | 2834.67 | 2834.67 | 0.0 |
| 2014-07-02 | B | Futures | 117.75 | 118.04 | 116.61 | 116.96 | 254536.0 |
| 2014-07-02 | B6 | Futures | 1.802 | 1.8049 | 1.8008 | 1.8032 | 71572.0 |
| 2014-07-02 | BFX | Futures | 3830.5 | 3840.0 | 3829.6 | 3840.0 | 16.0 |
| 2014-07-02 | BR | Futures | 0.23466 | 0.23471 | 0.23305 | 0.23339 | 2201.0 |
| 2014-07-02 | BZ | Futures | 118.52 | 118.77 | 117.36 | 117.7 | 20191.0 |
| 2014-07-02 | C | Futures | 2037.0 | 2041.0 | 2009.0 | 2030.0 | 4264.0 |
| 2014-07-02 | CB | Futures | 120.733 | 120.873 | 120.733 | 120.733 | 36.0 |
| 2014-07-02 | CC | Futures | 2291.0 | 2308.0 | 2264.0 | 2290.0 | 15822.0 |
| 2014-07-02 | CNH | Futures | 7.1528 | 7.1541 | 7.1528 | 7.1538 | 4.0 |
| 2014-07-02 | CSC | Futures | 4.424 | 4.424 | 4.357 | 4.381 | 25.0 |
| 2014-07-02 | CT | Futures | 91.76 | 92.06 | 90.64 | 91.16 | 84.0 |
| 2014-07-02 | DC | Futures | 35.43 | 35.55 | 34.73 | 35.04 | 355.0 |
| 2014-07-02 | DX | Futures | 75.805 | 75.962 | 75.782 | 75.924 | 15146.0 |
| 2014-07-02 | E1 | Futures | 1.44532 | 1.44557 | 1.44134 | 1.4425 | 28351.0 |
| 2014-07-02 | E6 | Futures | 1.6145 | 1.61497 | 1.60978 | 1.61155 | 106287.0 |
| 2014-07-02 | E7 | Futures | 1.6042 | 1.6043 | 1.5993 | 1.601 | 1660.0 |
| 2014-07-02 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4115 | 68994.0 |
| 2014-07-02 | ER | Futures | 97.925 | 97.925 | 97.916 | 97.916 | 44153.0 |
| 2014-07-02 | EW | Futures | 1496.0 | 1499.0 | 1486.9 | 1488.4 | 12940.0 |
| 2014-07-02 | FBTP | Futures | 91.7 | 91.75 | 91.04 | 91.13 | 61710.0 |
| 2014-07-02 | FBTS | Futures | 98.214 | 98.223 | 98.108 | 98.134 | 12929.0 |
| 2014-07-02 | FCE | Futures | 3558.1 | 3568.9 | 3540.5 | 3547.7 | 75453.0 |
| 2014-07-02 | FDAX | Futures | 10912.3 | 10951.4 | 10898.5 | 10927.2 | 63007.0 |
| 2014-07-02 | FESX | Futures | 2338.9 | 2345.4 | 2328.2 | 2337.5 | 573662.0 |
| 2014-07-02 | FGBL | Futures | 127.83 | 128.04 | 127.43 | 127.52 | 615452.0 |
| 2014-07-02 | FGBM | Futures | 121.52 | 121.59 | 121.36 | 121.4 | 418796.0 |
| 2014-07-02 | FGBS | Futures | 110.778 | 110.788 | 110.758 | 110.763 | 156039.0 |
| 2014-07-02 | FGBX | Futures | 132.93 | 133.07 | 132.08 | 132.28 | 18900.0 |
| 2014-07-02 | FMWO | Futures | 5834.3 | 5839.3 | 5831.8 | 5836.8 | 12.0 |
| 2014-07-02 | FOAT | Futures | 117.62 | 117.75 | 117.16 | 117.25 | 74214.0 |
| 2014-07-02 | FTDX | Futures | 1242.2 | 1243.1 | 1237.5 | 1239.4 | 169.0 |
| 2014-07-02 | FTI | Futures | 359.13 | 360.6 | 358.74 | 359.43 | 17990.0 |
| 2014-07-02 | FTUK | Futures | 5191.5 | 5217.3 | 5187.3 | 5208.1 | 61706.0 |
| 2014-07-02 | FVSA | Futures | 1267.87 | 1272.17 | 1246.38 | 1250.68 | 3118.0 |
| 2014-07-02 | FXXP | Futures | 259.3 | 260.3 | 259.2 | 259.8 | 4443.0 |
| 2014-07-02 | G | Futures | 93.53 | 93.68 | 93.14 | 93.19 | 141095.0 |
| 2014-07-02 | GF | Futures | 331.194 | 335.294 | 330.083 | 331.347 | 5744.0 |
| 2014-07-02 | GSCI | Futures | 1096.83 | 1096.83 | 1089.74 | 1090.33 | 68.0 |
| 2014-07-02 | HE | Futures | 136.424 | 137.972 | 135.899 | 136.791 | 19772.0 |
| 2014-07-02 | HG | Futures | 4.0954 | 4.1752 | 4.0685 | 4.1733 | 52819.0 |
| 2014-07-02 | HH | Futures | 55.499 | 55.499 | 54.93 | 55.094 | 2420.0 |
> showing 50 of 103 rows — these rows as CSV