PREVIEW / futures_daily / 2016-08-12
file: by_date/futures_daily/2016/2016-08-12.parquet size: 9 KB rows: 107
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-08-12 | ES | Futures | 2355.62 | 2358.04 | 2348.87 | 2354.0 | 1270055.0 |
| 2016-08-12 | NQ | Futures | 5657.93 | 5665.89 | 5642.61 | 5662.94 | 131960.0 |
| 2016-08-12 | YM | Futures | 19391.5 | 19412.4 | 19309.0 | 19347.6 | 90678.0 |
| 2016-08-12 | CL | Futures | 49.26 | 50.76 | 49.09 | 50.43 | 536081.0 |
| 2016-08-12 | GC | Futures | 1725.3 | 1748.1 | 1717.1 | 1723.3 | 239554.0 |
| 2016-08-12 | ZN | Futures | 127.577117 | 128.361835 | 127.516754 | 127.999657 | 1188034.0 |
| 2016-08-12 | A6 | Futures | 0.78281 | 0.78515 | 0.77711 | 0.77741 | 89235.0 |
| 2016-08-12 | AD | Futures | 0.78794 | 0.79199 | 0.78784 | 0.7902 | 60831.0 |
| 2016-08-12 | ALI | Futures | 2162.34 | 2163.61 | 2162.34 | 2163.61 | 2.0 |
| 2016-08-12 | B | Futures | 36.5 | 37.35 | 36.15 | 37.12 | 258003.0 |
| 2016-08-12 | B6 | Futures | 1.3667 | 1.375 | 1.361 | 1.3625 | 73717.0 |
| 2016-08-12 | BR | Futures | 0.20989 | 0.21015 | 0.20726 | 0.20792 | 897.0 |
| 2016-08-12 | BZ | Futures | 36.31 | 37.16 | 35.99 | 36.94 | 23652.0 |
| 2016-08-12 | C | Futures | 2565.0 | 2582.0 | 2557.0 | 2577.0 | 5149.0 |
| 2016-08-12 | CB | Futures | 268.142 | 274.296 | 268.142 | 274.296 | 27.0 |
| 2016-08-12 | CC | Futures | 2212.0 | 2228.0 | 2190.0 | 2205.0 | 15503.0 |
| 2016-08-12 | CNH | Futures | 7.2005 | 7.2067 | 7.191 | 7.2014 | 44.0 |
| 2016-08-12 | CSC | Futures | 3.826 | 3.84 | 3.8 | 3.824 | 33.0 |
| 2016-08-12 | CT | Futures | 80.78 | 81.44 | 79.07 | 79.16 | 45.0 |
| 2016-08-12 | DC | Futures | 30.74 | 31.05 | 30.43 | 30.76 | 281.0 |
| 2016-08-12 | DX | Futures | 89.192 | 89.248 | 88.532 | 88.99 | 19043.0 |
| 2016-08-12 | E1 | Futures | 1.28606 | 1.29232 | 1.28443 | 1.28644 | 11031.0 |
| 2016-08-12 | E6 | Futures | 1.29859 | 1.3082 | 1.29766 | 1.30127 | 138571.0 |
| 2016-08-12 | E7 | Futures | 1.2917 | 1.3011 | 1.2908 | 1.2944 | 3014.0 |
| 2016-08-12 | EBM | Futures | 200.88 | 201.48 | 197.87 | 197.87 | 9228.0 |
| 2016-08-12 | ED | Futures | 95.6219 | 95.6653 | 95.6219 | 95.6509 | 337020.0 |
| 2016-08-12 | ER | Futures | 98.308 | 98.313 | 98.308 | 98.308 | 10737.0 |
| 2016-08-12 | EW | Futures | 1652.9 | 1654.4 | 1644.7 | 1648.9 | 12583.0 |
| 2016-08-12 | FBON | Futures | 124.77 | 124.94 | 124.64 | 124.79 | 87.0 |
| 2016-08-12 | FBTP | Futures | 111.1 | 111.31 | 110.96 | 111.18 | 57389.0 |
| 2016-08-12 | FBTS | Futures | 101.347 | 101.374 | 101.338 | 101.365 | 11650.0 |
| 2016-08-12 | FCE | Futures | 3931.4 | 3939.7 | 3921.8 | 3930.1 | 14963.0 |
| 2016-08-12 | FDAX | Futures | 11410.8 | 11423.0 | 11365.0 | 11404.4 | 59122.0 |
| 2016-08-12 | FDXM | Futures | 11121.4 | 11134.9 | 11078.9 | 11116.2 | 17292.0 |
| 2016-08-12 | FESX | Futures | 2385.4 | 2387.8 | 2376.8 | 2385.4 | 657057.0 |
| 2016-08-12 | FGBL | Futures | 150.74 | 151.14 | 150.63 | 150.97 | 374590.0 |
| 2016-08-12 | FGBM | Futures | 128.94 | 129.07 | 128.91 | 129.02 | 227186.0 |
| 2016-08-12 | FGBS | Futures | 111.877 | 111.902 | 111.872 | 111.887 | 123632.0 |
| 2016-08-12 | FGBX | Futures | 189.19 | 190.03 | 188.69 | 189.62 | 20479.0 |
| 2016-08-12 | FMWO | Futures | 5797.5 | 5806.0 | 5796.3 | 5804.8 | 187.0 |
| 2016-08-12 | FOAT | Futures | 138.73 | 139.04 | 138.63 | 138.88 | 56767.0 |
| 2016-08-12 | FTDX | Futures | 1681.9 | 1681.9 | 1670.3 | 1676.1 | 151.0 |
| 2016-08-12 | FTI | Futures | 410.15 | 410.65 | 408.85 | 409.07 | 157.0 |
| 2016-08-12 | FTUK | Futures | 5755.0 | 5775.0 | 5745.0 | 5765.9 | 84178.0 |
| 2016-08-12 | FVSA | Futures | 1908.24 | 1908.24 | 1873.63 | 1886.61 | 10270.0 |
| 2016-08-12 | FXXP | Futures | 280.6 | 280.6 | 277.1 | 280.0 | 14861.0 |
| 2016-08-12 | G | Futures | 117.2 | 117.61 | 116.95 | 117.51 | 140448.0 |
| 2016-08-12 | GF | Futures | 295.749 | 298.516 | 293.284 | 296.906 | 2455.0 |
| 2016-08-12 | GSCI | Futures | 494.2 | 500.08 | 494.2 | 500.08 | 1215.0 |
| 2016-08-12 | HE | Futures | 81.042 | 83.463 | 80.039 | 83.014 | 14044.0 |
> showing 50 of 107 rows — these rows as CSV