PREVIEW / futures_daily / 2016-08-24
file: by_date/futures_daily/2016/2016-08-24.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-08-24 | ES | Futures | 2359.93 | 2362.09 | 2341.58 | 2348.33 | 1508048.0 |
| 2016-08-24 | NQ | Futures | 5679.74 | 5685.63 | 5623.45 | 5641.72 | 190472.0 |
| 2016-08-24 | YM | Futures | 19362.2 | 19369.5 | 19247.3 | 19294.3 | 111882.0 |
| 2016-08-24 | CL | Futures | 52.9 | 53.06 | 51.63 | 51.98 | 603495.0 |
| 2016-08-24 | GC | Futures | 1722.1 | 1724.5 | 1702.6 | 1706.0 | 225487.0 |
| 2016-08-24 | ZN | Futures | 127.758206 | 127.833659 | 127.592207 | 127.697843 | 1300976.0 |
| 2016-08-24 | A6 | Futures | 0.77457 | 0.77619 | 0.77162 | 0.77375 | 68753.0 |
| 2016-08-24 | AD | Futures | 0.7925 | 0.79327 | 0.78984 | 0.79122 | 48119.0 |
| 2016-08-24 | ALI | Futures | 2126.46 | 2128.98 | 2126.46 | 2128.98 | 2.0 |
| 2016-08-24 | B | Futures | 39.18 | 39.42 | 38.48 | 38.77 | 280915.0 |
| 2016-08-24 | B6 | Futures | 1.3921 | 1.3999 | 1.3881 | 1.3953 | 68809.0 |
| 2016-08-24 | BR | Futures | 0.20559 | 0.20633 | 0.20443 | 0.20623 | 589.0 |
| 2016-08-24 | BZ | Futures | 38.9 | 39.21 | 38.28 | 38.57 | 41304.0 |
| 2016-08-24 | C | Futures | 2595.0 | 2612.0 | 2546.0 | 2571.0 | 3512.0 |
| 2016-08-24 | CB | Futures | 257.907 | 258.713 | 257.907 | 257.907 | 15.0 |
| 2016-08-24 | CC | Futures | 2257.0 | 2276.0 | 2211.0 | 2231.0 | 20013.0 |
| 2016-08-24 | CNH | Futures | 7.2124 | 7.2207 | 7.2124 | 7.2204 | 3.0 |
| 2016-08-24 | CSC | Futures | 3.963 | 3.976 | 3.906 | 3.919 | 113.0 |
| 2016-08-24 | CT | Futures | 77.12 | 77.12 | 76.24 | 76.36 | 15.0 |
| 2016-08-24 | DC | Futures | 31.89 | 31.93 | 31.3 | 31.39 | 623.0 |
| 2016-08-24 | DX | Futures | 87.937 | 88.235 | 87.863 | 88.12 | 13896.0 |
| 2016-08-24 | E1 | Futures | 1.30196 | 1.30246 | 1.2947 | 1.2962 | 19254.0 |
| 2016-08-24 | E6 | Futures | 1.31763 | 1.31815 | 1.31047 | 1.31245 | 121460.0 |
| 2016-08-24 | E7 | Futures | 1.3105 | 1.3111 | 1.3034 | 1.3055 | 2009.0 |
| 2016-08-24 | EBM | Futures | 186.75 | 191.26 | 186.45 | 190.66 | 8947.0 |
| 2016-08-24 | ED | Futures | 95.6195 | 95.6388 | 95.6195 | 95.634 | 178399.0 |
| 2016-08-24 | ER | Futures | 98.308 | 98.308 | 98.298 | 98.303 | 76992.0 |
| 2016-08-24 | EW | Futures | 1662.9 | 1665.9 | 1650.1 | 1652.9 | 13366.0 |
| 2016-08-24 | FBON | Futures | 124.87 | 124.99 | 124.69 | 124.88 | 198.0 |
| 2016-08-24 | FBTP | Futures | 110.6 | 110.72 | 110.42 | 110.58 | 57455.0 |
| 2016-08-24 | FBTS | Futures | 101.356 | 101.365 | 101.338 | 101.347 | 9804.0 |
| 2016-08-24 | FCE | Futures | 3846.7 | 3891.2 | 3826.6 | 3874.2 | 69947.0 |
| 2016-08-24 | FDAX | Futures | 11232.0 | 11336.8 | 11187.8 | 11302.2 | 76645.0 |
| 2016-08-24 | FDXM | Futures | 10964.8 | 11049.8 | 10903.6 | 11016.6 | 21108.0 |
| 2016-08-24 | FESX | Futures | 2334.5 | 2363.5 | 2323.6 | 2354.9 | 911202.0 |
| 2016-08-24 | FGBL | Futures | 150.87 | 150.93 | 150.66 | 150.77 | 401916.0 |
| 2016-08-24 | FGBM | Futures | 128.94 | 128.96 | 128.87 | 128.89 | 319547.0 |
| 2016-08-24 | FGBS | Futures | 111.882 | 111.882 | 111.867 | 111.872 | 178713.0 |
| 2016-08-24 | FGBX | Futures | 189.97 | 190.11 | 188.84 | 189.23 | 18967.0 |
| 2016-08-24 | FMWO | Futures | 5798.7 | 5821.8 | 5798.7 | 5802.4 | 212.0 |
| 2016-08-24 | FOAT | Futures | 138.69 | 138.77 | 138.45 | 138.56 | 60314.0 |
| 2016-08-24 | FTDX | Futures | 1656.8 | 1668.4 | 1654.9 | 1666.9 | 46.0 |
| 2016-08-24 | FTI | Futures | 406.86 | 409.75 | 404.33 | 407.94 | 24916.0 |
| 2016-08-24 | FTUK | Futures | 5726.2 | 5727.5 | 5680.3 | 5697.4 | 77961.0 |
| 2016-08-24 | FVSA | Futures | 1964.5 | 1964.5 | 1899.59 | 1912.57 | 7669.0 |
| 2016-08-24 | FXXP | Futures | 277.1 | 279.6 | 276.2 | 278.9 | 17218.0 |
| 2016-08-24 | G | Futures | 117.25 | 117.36 | 116.99 | 117.08 | 394790.0 |
| 2016-08-24 | GF | Futures | 289.813 | 290.568 | 285.939 | 287.75 | 2737.0 |
| 2016-08-24 | GSCI | Futures | 514.55 | 518.45 | 512.28 | 512.64 | 65.0 |
| 2016-08-24 | HE | Futures | 84.017 | 84.12 | 82.91 | 83.463 | 9528.0 |
> showing 50 of 108 rows — these rows as CSV