PREVIEW / futures_daily / 2016-02-12
file: by_date/futures_daily/2016/2016-02-12.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-12 | ES | Futures | 1951.75 | 1987.53 | 1946.68 | 1984.86 | 2018154.0 |
| 2016-02-12 | NQ | Futures | 4646.15 | 4709.75 | 4634.13 | 4696.56 | 307347.0 |
| 2016-02-12 | YM | Futures | 16168.8 | 16483.3 | 16134.6 | 16466.8 | 216007.0 |
| 2016-02-12 | CL | Futures | 37.76 | 40.18 | 37.42 | 40.09 | 426183.0 |
| 2016-02-12 | GC | Futures | 1602.4 | 1604.5 | 1584.2 | 1592.5 | 191128.0 |
| 2016-02-12 | ZN | Futures | 126.920806 | 127.071222 | 126.063436 | 126.168727 | 1727313.0 |
| 2016-02-12 | A6 | Futures | 0.71292 | 0.71332 | 0.7067 | 0.71061 | 76291.0 |
| 2016-02-12 | AD | Futures | 0.73484 | 0.74026 | 0.73218 | 0.73852 | 72964.0 |
| 2016-02-12 | ALI | Futures | 2054.7 | 2055.34 | 2054.7 | 2055.34 | 9.0 |
| 2016-02-12 | B | Futures | 26.31 | 28.1 | 25.92 | 28.03 | 394479.0 |
| 2016-02-12 | B6 | Futures | 1.5237 | 1.5331 | 1.5196 | 1.5276 | 87432.0 |
| 2016-02-12 | BR | Futures | 0.15755 | 0.15768 | 0.1563 | 0.15689 | 707.0 |
| 2016-02-12 | BZ | Futures | 25.98 | 27.88 | 25.75 | 27.82 | 44770.0 |
| 2016-02-12 | C | Futures | 2120.0 | 2170.0 | 2105.0 | 2168.0 | 5501.0 |
| 2016-02-12 | CB | Futures | 268.42 | 268.42 | 263.781 | 263.781 | 55.0 |
| 2016-02-12 | CC | Futures | 2057.0 | 2108.0 | 2053.0 | 2104.0 | 27527.0 |
| 2016-02-12 | CNH | Futures | 7.2029 | 7.211 | 7.1766 | 7.1766 | 28.0 |
| 2016-02-12 | CSC | Futures | 3.777 | 3.777 | 3.777 | 3.777 | 4.0 |
| 2016-02-12 | CT | Futures | 68.35 | 69.3 | 68.12 | 68.99 | 21279.0 |
| 2016-02-12 | DC | Futures | 30.11 | 30.23 | 30.04 | 30.13 | 176.0 |
| 2016-02-12 | DX | Futures | 89.393 | 89.912 | 89.253 | 89.661 | 27582.0 |
| 2016-02-12 | E1 | Futures | 1.2996 | 1.30099 | 1.29102 | 1.29543 | 25753.0 |
| 2016-02-12 | E6 | Futures | 1.32413 | 1.32624 | 1.3122 | 1.31712 | 219133.0 |
| 2016-02-12 | E7 | Futures | 1.3166 | 1.3182 | 1.3048 | 1.3097 | 3901.0 |
| 2016-02-12 | EBM | Futures | 217.53 | 219.65 | 216.11 | 218.94 | 17313.0 |
| 2016-02-12 | ED | Futures | 95.6361 | 95.6506 | 95.6361 | 95.641 | 197857.0 |
| 2016-02-12 | ER | Futures | 98.278 | 98.293 | 98.269 | 98.278 | 88994.0 |
| 2016-02-12 | EW | Futures | 1304.3 | 1331.3 | 1303.1 | 1329.0 | 21230.0 |
| 2016-02-12 | FBON | Futures | 115.6 | 116.02 | 115.28 | 115.8 | 446.0 |
| 2016-02-12 | FBTP | Futures | 104.03 | 105.07 | 103.87 | 104.47 | 113114.0 |
| 2016-02-12 | FBTS | Futures | 100.606 | 100.757 | 100.579 | 100.713 | 37633.0 |
| 2016-02-12 | FCE | Futures | 3272.0 | 3334.5 | 3267.9 | 3325.3 | 5460.0 |
| 2016-02-12 | FDAX | Futures | 9576.1 | 9749.6 | 9549.5 | 9697.0 | 106067.0 |
| 2016-02-12 | FDXM | Futures | 9161.3 | 9319.9 | 9129.2 | 9271.2 | 23814.0 |
| 2016-02-12 | FESX | Futures | 2054.5 | 2100.8 | 2050.7 | 2088.7 | 1795477.0 |
| 2016-02-12 | FEU3 | Futures | 98.937 | 98.937 | 98.932 | 98.932 | 23.0 |
| 2016-02-12 | FGBL | Futures | 145.4 | 145.62 | 144.68 | 144.89 | 715804.0 |
| 2016-02-12 | FGBM | Futures | 127.5 | 127.59 | 127.26 | 127.34 | 490103.0 |
| 2016-02-12 | FGBS | Futures | 111.812 | 111.832 | 111.733 | 111.763 | 265472.0 |
| 2016-02-12 | FGBX | Futures | 172.21 | 173.11 | 170.6 | 171.22 | 42409.0 |
| 2016-02-12 | FMWO | Futures | 4974.1 | 5011.4 | 4971.6 | 5011.4 | 469.0 |
| 2016-02-12 | FOAT | Futures | 131.55 | 131.67 | 131.01 | 131.16 | 117992.0 |
| 2016-02-12 | FTDX | Futures | 1441.6 | 1450.7 | 1433.9 | 1449.8 | 629.0 |
| 2016-02-12 | FTI | Futures | 340.08 | 346.59 | 339.86 | 345.74 | 539.0 |
| 2016-02-12 | FTUK | Futures | 4510.6 | 4637.0 | 4496.3 | 4611.3 | 157256.0 |
| 2016-02-12 | FVSA | Futures | 3670.98 | 3706.05 | 3600.83 | 3606.67 | 10407.0 |
| 2016-02-12 | FXXP | Futures | 240.0 | 245.9 | 239.9 | 245.0 | 37597.0 |
| 2016-02-12 | G | Futures | 108.72 | 109.04 | 108.29 | 108.55 | 234217.0 |
| 2016-02-12 | GF | Futures | 297.671 | 299.144 | 293.351 | 294.578 | 3101.0 |
| 2016-02-12 | GSCI | Futures | 440.68 | 449.44 | 438.85 | 449.06 | 2007.0 |
> showing 50 of 108 rows — these rows as CSV