PREVIEW / futures_daily / 2016-08-29
file: by_date/futures_daily/2016/2016-08-29.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 |
|---|---|---|---|---|---|---|---|
| 2016-08-29 | ES | Futures | 2340.5 | 2356.16 | 2336.99 | 2352.92 | 1245215.0 |
| 2016-08-29 | NQ | Futures | 5641.43 | 5664.71 | 5627.28 | 5649.97 | 146925.0 |
| 2016-08-29 | YM | Futures | 19198.2 | 19326.7 | 19169.0 | 19312.1 | 105443.0 |
| 2016-08-29 | CL | Futures | 52.48 | 52.55 | 51.82 | 52.22 | 309254.0 |
| 2016-08-29 | GC | Futures | 1698.5 | 1704.5 | 1690.0 | 1702.7 | 142232.0 |
| 2016-08-29 | ZN | Futures | 126.882943 | 127.486572 | 126.807489 | 127.4413 | 1642229.0 |
| 2016-08-29 | A6 | Futures | 0.76826 | 0.771 | 0.7651 | 0.77039 | 91474.0 |
| 2016-08-29 | AD | Futures | 0.78707 | 0.78743 | 0.78436 | 0.7861 | 45734.0 |
| 2016-08-29 | ALI | Futures | 2126.78 | 2126.78 | 2126.78 | 2126.78 | 0.0 |
| 2016-08-29 | B | Futures | 39.13 | 39.18 | 38.64 | 38.88 | 112615.0 |
| 2016-08-29 | B6 | Futures | 1.3832 | 1.3858 | 1.3773 | 1.3824 | 42238.0 |
| 2016-08-29 | BFX | Futures | 4090.5 | 4090.5 | 4072.1 | 4081.9 | 3.0 |
| 2016-08-29 | BR | Futures | 0.20342 | 0.20592 | 0.20342 | 0.20592 | 1531.0 |
| 2016-08-29 | BZ | Futures | 38.99 | 39.0 | 38.49 | 38.71 | 8723.0 |
| 2016-08-29 | CB | Futures | 257.938 | 258.527 | 257.938 | 257.938 | 17.0 |
| 2016-08-29 | CC | Futures | 2225.0 | 2225.0 | 2157.0 | 2163.0 | 20144.0 |
| 2016-08-29 | CSC | Futures | 3.824 | 3.859 | 3.824 | 3.859 | 63.0 |
| 2016-08-29 | CT | Futures | 75.9 | 76.0 | 75.28 | 75.55 | 19.0 |
| 2016-08-29 | DC | Futures | 30.49 | 30.6 | 30.3 | 30.55 | 177.0 |
| 2016-08-29 | DX | Futures | 88.867 | 89.104 | 88.769 | 88.86 | 17793.0 |
| 2016-08-29 | E1 | Futures | 1.28093 | 1.28356 | 1.2783 | 1.2813 | 16371.0 |
| 2016-08-29 | E6 | Futures | 1.30348 | 1.30587 | 1.30005 | 1.30336 | 115729.0 |
| 2016-08-29 | E7 | Futures | 1.2966 | 1.2988 | 1.2932 | 1.2965 | 2856.0 |
| 2016-08-29 | EBM | Futures | 189.45 | 189.45 | 184.94 | 185.24 | 6309.0 |
| 2016-08-29 | ED | Futures | 95.593 | 95.6147 | 95.5906 | 95.6147 | 222958.0 |
| 2016-08-29 | ER | Futures | 98.298 | 98.303 | 98.298 | 98.298 | 8748.0 |
| 2016-08-29 | EW | Futures | 1650.8 | 1668.6 | 1649.6 | 1664.4 | 16222.0 |
| 2016-08-29 | FBON | Futures | 124.57 | 125.04 | 124.52 | 125.04 | 199.0 |
| 2016-08-29 | FBTP | Futures | 110.51 | 110.84 | 110.28 | 110.82 | 42704.0 |
| 2016-08-29 | FBTS | Futures | 101.347 | 101.365 | 101.338 | 101.356 | 4703.0 |
| 2016-08-29 | FCE | Futures | 3861.1 | 3877.7 | 3833.1 | 3864.6 | 54557.0 |
| 2016-08-29 | FDAX | Futures | 11193.7 | 11250.6 | 11105.3 | 11220.8 | 64413.0 |
| 2016-08-29 | FDXM | Futures | 10911.9 | 10967.9 | 10825.8 | 10937.3 | 19990.0 |
| 2016-08-29 | FESX | Futures | 2342.4 | 2356.5 | 2328.3 | 2349.4 | 586001.0 |
| 2016-08-29 | FGBL | Futures | 150.23 | 150.94 | 149.86 | 150.78 | 351011.0 |
| 2016-08-29 | FGBM | Futures | 128.71 | 128.98 | 128.62 | 128.92 | 243430.0 |
| 2016-08-29 | FGBS | Futures | 111.857 | 111.897 | 111.842 | 111.887 | 105044.0 |
| 2016-08-29 | FGBX | Futures | 187.01 | 188.65 | 186.58 | 188.26 | 17699.0 |
| 2016-08-29 | FMWO | Futures | 5745.2 | 5776.8 | 5745.2 | 5775.6 | 84.0 |
| 2016-08-29 | FOAT | Futures | 138.03 | 138.51 | 137.68 | 138.49 | 53006.0 |
| 2016-08-29 | FTDX | Futures | 1657.8 | 1662.1 | 1648.6 | 1662.1 | 90.0 |
| 2016-08-29 | FTI | Futures | 406.63 | 409.34 | 404.51 | 407.99 | 16540.0 |
| 2016-08-29 | FVSA | Futures | 1908.24 | 1951.51 | 1882.28 | 1895.26 | 4627.0 |
| 2016-08-29 | FXXP | Futures | 276.9 | 278.3 | 275.4 | 277.7 | 9938.0 |
| 2016-08-29 | GF | Futures | 280.607 | 281.412 | 278.243 | 280.003 | 3317.0 |
| 2016-08-29 | GSCI | Futures | 509.16 | 510.65 | 508.73 | 509.37 | 54.0 |
| 2016-08-29 | HE | Futures | 84.985 | 85.712 | 84.155 | 84.916 | 11263.0 |
| 2016-08-29 | HG | Futures | 2.5866 | 2.6053 | 2.586 | 2.5898 | 29972.0 |
| 2016-08-29 | HH | Futures | 26.279 | 26.279 | 25.855 | 26.125 | 1682.0 |
| 2016-08-29 | HO | Futures | 1.0672 | 1.0676 | 1.0524 | 1.0611 | 10083.0 |
> showing 50 of 103 rows — these rows as CSV