PREVIEW / futures_daily / 2016-09-08
file: by_date/futures_daily/2016/2016-09-08.parquet size: 10 KB rows: 110
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-09-08 | ES | Futures | 2358.58 | 2363.71 | 2349.14 | 2351.03 | 2105651.0 |
| 2016-09-08 | NQ | Futures | 5690.64 | 5701.54 | 5645.55 | 5653.22 | 251333.0 |
| 2016-09-08 | YM | Futures | 19339.2 | 19373.7 | 19258.8 | 19280.8 | 149567.0 |
| 2016-09-08 | CL | Futures | 51.26 | 53.07 | 50.87 | 52.93 | 761943.0 |
| 2016-09-08 | GC | Futures | 1730.9 | 1737.1 | 1718.1 | 1721.3 | 182893.0 |
| 2016-09-08 | ZN | Futures | 127.773296 | 127.864498 | 127.119686 | 127.165286 | 1255997.0 |
| 2016-09-08 | A6 | Futures | 0.78057 | 0.78647 | 0.7768 | 0.77741 | 118084.0 |
| 2016-09-08 | AD | Futures | 0.79424 | 0.79634 | 0.79086 | 0.79219 | 70088.0 |
| 2016-09-08 | ALI | Futures | 2068.22 | 2068.22 | 2068.22 | 2068.22 | 0.0 |
| 2016-09-08 | B | Futures | 38.17 | 39.42 | 37.9 | 39.3 | 327242.0 |
| 2016-09-08 | B6 | Futures | 1.4061 | 1.4102 | 1.4004 | 1.4023 | 88489.0 |
| 2016-09-08 | BFX | Futures | 4183.4 | 4193.2 | 4175.3 | 4175.3 | 2.0 |
| 2016-09-08 | BR | Futures | 0.21143 | 0.21188 | 0.20797 | 0.20917 | 10.0 |
| 2016-09-08 | BZ | Futures | 38.02 | 39.25 | 37.74 | 39.14 | 30011.0 |
| 2016-09-08 | C | Futures | 2423.0 | 2431.0 | 2412.0 | 2421.0 | 9227.0 |
| 2016-09-08 | CB | Futures | 255.738 | 255.738 | 253.599 | 253.909 | 11.0 |
| 2016-09-08 | CC | Futures | 2143.0 | 2161.0 | 2110.0 | 2134.0 | 16918.0 |
| 2016-09-08 | CNH | Futures | 7.2197 | 7.2286 | 7.2158 | 7.2282 | 29.0 |
| 2016-09-08 | CSC | Futures | 3.937 | 3.937 | 3.909 | 3.909 | 20.0 |
| 2016-09-08 | CT | Futures | 78.39 | 78.49 | 78.06 | 78.45 | 18.0 |
| 2016-09-08 | DC | Futures | 31.56 | 31.58 | 31.06 | 31.08 | 97.0 |
| 2016-09-08 | DX | Futures | 88.346 | 88.481 | 87.835 | 88.403 | 33161.0 |
| 2016-09-08 | E1 | Futures | 1.2917 | 1.29808 | 1.28631 | 1.28756 | 25604.0 |
| 2016-09-08 | E6 | Futures | 1.30889 | 1.31914 | 1.3082 | 1.31111 | 259421.0 |
| 2016-09-08 | E7 | Futures | 1.3017 | 1.312 | 1.3014 | 1.3041 | 5061.0 |
| 2016-09-08 | EBM | Futures | 187.41 | 188.29 | 186.52 | 188.0 | 13573.0 |
| 2016-09-08 | ED | Futures | 95.6509 | 95.6509 | 95.6147 | 95.6171 | 384509.0 |
| 2016-09-08 | ER | Futures | 98.313 | 98.313 | 98.298 | 98.303 | 150352.0 |
| 2016-09-08 | EW | Futures | 1674.4 | 1678.4 | 1666.0 | 1668.1 | 26734.0 |
| 2016-09-08 | FBON | Futures | 125.0 | 125.22 | 124.31 | 124.41 | 1380.0 |
| 2016-09-08 | FBTP | Futures | 111.09 | 111.35 | 110.23 | 110.34 | 150336.0 |
| 2016-09-08 | FBTS | Futures | 101.383 | 101.419 | 101.284 | 101.32 | 29535.0 |
| 2016-09-08 | FCE | Futures | 3977.3 | 3992.1 | 3916.6 | 3967.7 | 111884.0 |
| 2016-09-08 | FDAX | Futures | 11440.6 | 11471.9 | 11243.7 | 11357.5 | 117379.0 |
| 2016-09-08 | FDXM | Futures | 11148.4 | 11182.6 | 10959.6 | 11070.6 | 37180.0 |
| 2016-09-08 | FESX | Futures | 2419.9 | 2429.3 | 2381.5 | 2415.2 | 1613899.0 |
| 2016-09-08 | FGBL | Futures | 151.11 | 151.22 | 150.18 | 150.42 | 911686.0 |
| 2016-09-08 | FGBM | Futures | 129.19 | 129.24 | 128.89 | 128.94 | 707858.0 |
| 2016-09-08 | FGBS | Futures | 111.952 | 111.962 | 111.867 | 111.887 | 391882.0 |
| 2016-09-08 | FGBX | Futures | 189.46 | 189.74 | 185.32 | 186.34 | 80409.0 |
| 2016-09-08 | FMWO | Futures | 5853.4 | 5858.3 | 5830.3 | 5838.9 | 296.0 |
| 2016-09-08 | FOAT | Futures | 139.08 | 139.19 | 138.16 | 138.36 | 187194.0 |
| 2016-09-08 | FTDX | Futures | 1703.1 | 1704.0 | 1688.1 | 1699.2 | 77.0 |
| 2016-09-08 | FTI | Futures | 417.42 | 417.92 | 410.43 | 414.67 | 33656.0 |
| 2016-09-08 | FTUK | Futures | 5707.0 | 5748.3 | 5688.3 | 5722.9 | 197941.0 |
| 2016-09-08 | FVSA | Futures | 1687.56 | 1717.85 | 1652.95 | 1661.6 | 14783.0 |
| 2016-09-08 | FXXP | Futures | 283.8 | 284.7 | 280.4 | 282.9 | 45229.0 |
| 2016-09-08 | G | Futures | 116.88 | 116.97 | 115.91 | 116.09 | 203506.0 |
| 2016-09-08 | GF | Futures | 268.232 | 269.741 | 262.094 | 264.811 | 2320.0 |
| 2016-09-08 | GSCI | Futures | 504.41 | 512.28 | 502.85 | 512.28 | 1710.0 |
> showing 50 of 110 rows — these rows as CSV