PREVIEW / futures_daily / 2014-02-24
file: by_date/futures_daily/2014/2014-02-24.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-02-24 | ES | Futures | 1891.88 | 1914.04 | 1885.69 | 1902.96 | 1612323.0 |
| 2014-02-24 | NQ | Futures | 4214.17 | 4255.27 | 4201.82 | 4239.75 | 206372.0 |
| 2014-02-24 | YM | Futures | 16073.6 | 16255.3 | 16013.7 | 16160.5 | 133871.0 |
| 2014-02-24 | CL | Futures | 182.02 | 184.09 | 181.45 | 182.97 | 177861.0 |
| 2014-02-24 | GC | Futures | 1747.3 | 1765.3 | 1738.3 | 1763.7 | 129769.0 |
| 2014-02-24 | ZN | Futures | 115.020769 | 115.14954 | 114.791844 | 114.891998 | 1200898.0 |
| 2014-02-24 | A6 | Futures | 0.85368 | 0.86121 | 0.85053 | 0.86016 | 67678.0 |
| 2014-02-24 | AD | Futures | 0.91137 | 0.91572 | 0.90833 | 0.91511 | 41227.0 |
| 2014-02-24 | B | Futures | 112.8 | 113.51 | 112.23 | 113.37 | 131713.0 |
| 2014-02-24 | B6 | Futures | 1.747 | 1.7518 | 1.7419 | 1.7504 | 86139.0 |
| 2014-02-24 | BFX | Futures | 3662.6 | 3683.4 | 3658.0 | 3680.7 | 8.0 |
| 2014-02-24 | BR | Futures | 0.21948 | 0.22056 | 0.21916 | 0.2199 | 64.0 |
| 2014-02-24 | BZ | Futures | 115.08 | 115.76 | 114.49 | 115.64 | 7967.0 |
| 2014-02-24 | C | Futures | 1942.0 | 1956.0 | 1933.0 | 1942.0 | 3159.0 |
| 2014-02-24 | CB | Futures | 87.831 | 87.881 | 87.831 | 87.831 | 3.0 |
| 2014-02-24 | CC | Futures | 2183.0 | 2209.0 | 2176.0 | 2196.0 | 8215.0 |
| 2014-02-24 | CNH | Futures | 7.0203 | 7.0305 | 7.0203 | 7.0208 | 30.0 |
| 2014-02-24 | CSC | Futures | 4.323 | 4.379 | 4.323 | 4.354 | 27.0 |
| 2014-02-24 | CT | Futures | 99.3 | 101.65 | 98.81 | 100.37 | 17553.0 |
| 2014-02-24 | DC | Futures | 34.11 | 34.82 | 34.11 | 34.73 | 142.0 |
| 2014-02-24 | DX | Futures | 76.338 | 76.457 | 76.195 | 76.291 | 11978.0 |
| 2014-02-24 | E1 | Futures | 1.447 | 1.45072 | 1.44071 | 1.4443 | 22814.0 |
| 2014-02-24 | E6 | Futures | 1.62183 | 1.62584 | 1.61817 | 1.62136 | 121043.0 |
| 2014-02-24 | E7 | Futures | 1.6113 | 1.6172 | 1.6075 | 1.6108 | 3647.0 |
| 2014-02-24 | EBM | Futures | 275.65 | 276.35 | 274.26 | 276.35 | 8844.0 |
| 2014-02-24 | ED | Futures | 95.3829 | 95.3853 | 95.3829 | 95.3853 | 29460.0 |
| 2014-02-24 | ER | Futures | 97.881 | 97.886 | 97.871 | 97.876 | 33776.0 |
| 2014-02-24 | EW | Futures | 1385.0 | 1400.3 | 1380.0 | 1390.4 | 15210.0 |
| 2014-02-24 | FBTP | Futures | 85.38 | 85.52 | 85.11 | 85.2 | 33317.0 |
| 2014-02-24 | FBTS | Futures | 96.704 | 96.731 | 96.634 | 96.661 | 7463.0 |
| 2014-02-24 | FCE | Futures | 3390.5 | 3428.8 | 3388.2 | 3423.0 | 89051.0 |
| 2014-02-24 | FDAX | Futures | 10679.2 | 10799.0 | 10651.5 | 10746.3 | 90425.0 |
| 2014-02-24 | FESX | Futures | 2197.8 | 2225.9 | 2194.3 | 2217.5 | 828243.0 |
| 2014-02-24 | FEU3 | Futures | 98.497 | 98.497 | 98.488 | 98.492 | 45.0 |
| 2014-02-24 | FGBL | Futures | 122.51 | 122.56 | 122.13 | 122.27 | 460859.0 |
| 2014-02-24 | FGBM | Futures | 119.33 | 119.35 | 119.13 | 119.19 | 322166.0 |
| 2014-02-24 | FGBS | Futures | 110.618 | 110.623 | 110.593 | 110.608 | 170635.0 |
| 2014-02-24 | FGBX | Futures | 124.08 | 124.16 | 123.43 | 123.63 | 15707.0 |
| 2014-02-24 | FMWO | Futures | 5501.3 | 5501.3 | 5501.3 | 5501.3 | 0.0 |
| 2014-02-24 | FOAT | Futures | 110.94 | 111.01 | 110.69 | 110.83 | 34908.0 |
| 2014-02-24 | FTDX | Futures | 1187.3 | 1198.1 | 1185.4 | 1195.8 | 127.0 |
| 2014-02-24 | FTI | Futures | 340.95 | 343.73 | 340.78 | 343.09 | 21690.0 |
| 2014-02-24 | FTUK | Futures | 5140.7 | 5191.0 | 5122.9 | 5172.9 | 108697.0 |
| 2014-02-24 | FVSA | Futures | 1791.77 | 1801.73 | 1756.93 | 1766.89 | 6928.0 |
| 2014-02-24 | FXXP | Futures | 245.6 | 249.2 | 245.4 | 247.7 | 3911.0 |
| 2014-02-24 | G | Futures | 92.8 | 92.88 | 92.69 | 92.8 | 188925.0 |
| 2014-02-24 | GF | Futures | 275.537 | 276.262 | 274.327 | 274.408 | 1986.0 |
| 2014-02-24 | GSCI | Futures | 1067.8 | 1074.62 | 1067.8 | 1071.42 | 78.0 |
| 2014-02-24 | HE | Futures | 120.168 | 120.56 | 119.775 | 119.866 | 16415.0 |
| 2014-02-24 | HG | Futures | 4.1288 | 4.1301 | 4.0604 | 4.106 | 24614.0 |
> showing 50 of 105 rows — these rows as CSV