PREVIEW / futures_daily / 2014-12-29
file: by_date/futures_daily/2014/2014-12-29.parquet size: 9 KB rows: 105
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-12-29 | ES | Futures | 2186.4 | 2189.28 | 2175.91 | 2186.13 | 636345.0 |
| 2014-12-29 | NQ | Futures | 5006.66 | 5013.33 | 4987.22 | 5002.02 | 102425.0 |
| 2014-12-29 | YM | Futures | 18357.0 | 18369.2 | 18272.5 | 18314.2 | 56821.0 |
| 2014-12-29 | CL | Futures | 107.82 | 109.17 | 103.61 | 105.0 | 241378.0 |
| 2014-12-29 | GC | Futures | 1564.0 | 1567.4 | 1542.7 | 1547.0 | 85907.0 |
| 2014-12-29 | ZN | Futures | 118.71589 | 119.172263 | 118.686446 | 119.083932 | 434205.0 |
| 2014-12-29 | A6 | Futures | 0.79072 | 0.79523 | 0.79004 | 0.7919 | 35348.0 |
| 2014-12-29 | AD | Futures | 0.87452 | 0.87615 | 0.87279 | 0.87401 | 22708.0 |
| 2014-12-29 | ALI | Futures | 2831.89 | 2831.89 | 2831.89 | 2831.89 | 0.0 |
| 2014-12-29 | B | Futures | 62.3 | 62.46 | 59.39 | 59.9 | 62437.0 |
| 2014-12-29 | B6 | Futures | 1.6349 | 1.6379 | 1.6296 | 1.631 | 45392.0 |
| 2014-12-29 | BFX | Futures | 4012.8 | 4016.4 | 3995.8 | 4016.4 | 3.0 |
| 2014-12-29 | BR | Futures | 0.2035 | 0.20353 | 0.20063 | 0.20099 | 68.0 |
| 2014-12-29 | BZ | Futures | 62.28 | 62.76 | 59.77 | 60.23 | 12211.0 |
| 2014-12-29 | C | Futures | 2164.0 | 2182.0 | 2143.0 | 2164.0 | 6526.0 |
| 2014-12-29 | CB | Futures | 132.263 | 132.694 | 130.62 | 132.448 | 13.0 |
| 2014-12-29 | CC | Futures | 2186.0 | 2204.0 | 2166.0 | 2187.0 | 9194.0 |
| 2014-12-29 | CSC | Futures | 4.455 | 4.518 | 4.455 | 4.503 | 58.0 |
| 2014-12-29 | CT | Futures | 78.61 | 79.56 | 78.37 | 79.2 | 7780.0 |
| 2014-12-29 | DC | Futures | 35.23 | 35.51 | 35.06 | 35.39 | 86.0 |
| 2014-12-29 | DX | Futures | 85.485 | 85.764 | 85.267 | 85.661 | 22567.0 |
| 2014-12-29 | E1 | Futures | 1.2948 | 1.29926 | 1.29084 | 1.2925 | 22942.0 |
| 2014-12-29 | E6 | Futures | 1.43374 | 1.43856 | 1.42927 | 1.43091 | 32318.0 |
| 2014-12-29 | E7 | Futures | 1.4252 | 1.4297 | 1.4207 | 1.4224 | 1740.0 |
| 2014-12-29 | EBM | Futures | 324.41 | 330.09 | 323.2 | 325.63 | 8755.0 |
| 2014-12-29 | ED | Futures | 95.4354 | 95.4402 | 95.4354 | 95.4354 | 61643.0 |
| 2014-12-29 | ER | Futures | 98.009 | 98.019 | 98.009 | 98.014 | 39229.0 |
| 2014-12-29 | EW | Futures | 1534.5 | 1543.5 | 1526.6 | 1540.8 | 13059.0 |
| 2014-12-29 | FBTP | Futures | 98.65 | 98.65 | 97.82 | 98.26 | 34740.0 |
| 2014-12-29 | FBTS | Futures | 98.606 | 98.615 | 98.464 | 98.597 | 3987.0 |
| 2014-12-29 | FCE | Futures | 3533.7 | 3537.4 | 3471.3 | 3529.2 | 86717.0 |
| 2014-12-29 | FDAX | Futures | 11044.7 | 11055.8 | 10870.4 | 11039.2 | 75815.0 |
| 2014-12-29 | FESX | Futures | 2306.3 | 2315.0 | 2253.7 | 2294.8 | 643519.0 |
| 2014-12-29 | FGBL | Futures | 135.83 | 136.48 | 135.76 | 136.43 | 238135.0 |
| 2014-12-29 | FGBM | Futures | 123.62 | 123.89 | 123.56 | 123.85 | 144177.0 |
| 2014-12-29 | FGBS | Futures | 110.973 | 110.998 | 110.968 | 110.998 | 94472.0 |
| 2014-12-29 | FGBX | Futures | 153.75 | 155.23 | 153.35 | 155.13 | 5834.0 |
| 2014-12-29 | FMWO | Futures | 5681.7 | 5701.5 | 5676.8 | 5701.5 | 278.0 |
| 2014-12-29 | FOAT | Futures | 125.28 | 125.74 | 125.16 | 125.7 | 24292.0 |
| 2014-12-29 | FTDX | Futures | 1288.1 | 1303.6 | 1278.7 | 1286.2 | 72.0 |
| 2014-12-29 | FTI | Futures | 370.82 | 371.21 | 366.19 | 369.74 | 25906.0 |
| 2014-12-29 | FTUK | Futures | 5148.7 | 5156.9 | 5098.8 | 5131.9 | 61162.0 |
| 2014-12-29 | FVSA | Futures | 1734.13 | 1862.16 | 1734.13 | 1854.4 | 3726.0 |
| 2014-12-29 | FXXP | Futures | 260.8 | 261.2 | 257.3 | 259.5 | 2839.0 |
| 2014-12-29 | G | Futures | 102.19 | 102.65 | 102.05 | 102.56 | 59085.0 |
| 2014-12-29 | GF | Futures | 344.925 | 350.139 | 344.925 | 348.896 | 1784.0 |
| 2014-12-29 | GSCI | Futures | 738.17 | 738.17 | 718.39 | 721.97 | 47.0 |
| 2014-12-29 | HE | Futures | 110.142 | 110.31 | 109.136 | 109.74 | 10980.0 |
| 2014-12-29 | HG | Futures | 3.5746 | 3.6165 | 3.5009 | 3.5848 | 36593.0 |
| 2014-12-29 | HH | Futures | 37.139 | 38.424 | 37.115 | 38.424 | 1013.0 |
> showing 50 of 105 rows — these rows as CSV