PREVIEW / futures_daily / 2016-08-30
file: by_date/futures_daily/2016/2016-08-30.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-30 | ES | Futures | 2353.73 | 2355.35 | 2341.31 | 2348.6 | 1372345.0 |
| 2016-08-30 | NQ | Futures | 5652.04 | 5656.16 | 5610.49 | 5629.64 | 186259.0 |
| 2016-08-30 | YM | Futures | 19316.3 | 19339.2 | 19220.2 | 19265.1 | 114677.0 |
| 2016-08-30 | CL | Futures | 52.22 | 52.78 | 51.36 | 51.52 | 464449.0 |
| 2016-08-30 | GC | Futures | 1702.6 | 1705.0 | 1683.3 | 1689.1 | 159325.0 |
| 2016-08-30 | ZN | Futures | 127.456391 | 127.516754 | 127.184757 | 127.380937 | 986143.0 |
| 2016-08-30 | A6 | Futures | 0.7705 | 0.7708 | 0.76266 | 0.76368 | 101564.0 |
| 2016-08-30 | AD | Futures | 0.78626 | 0.78667 | 0.78104 | 0.78232 | 59188.0 |
| 2016-08-30 | ALI | Futures | 2108.2 | 2108.2 | 2107.89 | 2107.89 | 4.0 |
| 2016-08-30 | B | Futures | 38.88 | 39.23 | 38.12 | 38.31 | 300287.0 |
| 2016-08-30 | B6 | Futures | 1.382 | 1.3837 | 1.3772 | 1.3798 | 66694.0 |
| 2016-08-30 | BR | Futures | 0.20691 | 0.20691 | 0.20486 | 0.20561 | 1303.0 |
| 2016-08-30 | BZ | Futures | 38.82 | 39.05 | 37.96 | 38.15 | 26397.0 |
| 2016-08-30 | C | Futures | 2560.0 | 2567.0 | 2510.0 | 2514.0 | 7409.0 |
| 2016-08-30 | CB | Futures | 257.907 | 260.387 | 257.907 | 260.387 | 32.0 |
| 2016-08-30 | CC | Futures | 2183.0 | 2183.0 | 2134.0 | 2137.0 | 21051.0 |
| 2016-08-30 | CNH | Futures | 7.2388 | 7.2461 | 7.2388 | 7.2431 | 6.0 |
| 2016-08-30 | CSC | Futures | 3.833 | 3.889 | 3.833 | 3.868 | 25.0 |
| 2016-08-30 | CT | Futures | 75.07 | 75.07 | 74.45 | 74.73 | 11.0 |
| 2016-08-30 | DC | Futures | 30.7 | 30.91 | 30.64 | 30.74 | 164.0 |
| 2016-08-30 | DX | Futures | 88.839 | 89.402 | 88.825 | 89.324 | 20772.0 |
| 2016-08-30 | E1 | Futures | 1.2813 | 1.28218 | 1.27329 | 1.27404 | 21421.0 |
| 2016-08-30 | E6 | Futures | 1.30325 | 1.30395 | 1.29696 | 1.29801 | 129704.0 |
| 2016-08-30 | E7 | Futures | 1.2965 | 1.2968 | 1.2901 | 1.2911 | 2057.0 |
| 2016-08-30 | EBM | Futures | 185.54 | 187.95 | 184.64 | 187.35 | 5417.0 |
| 2016-08-30 | ED | Futures | 95.6123 | 95.6195 | 95.605 | 95.6099 | 193704.0 |
| 2016-08-30 | ER | Futures | 98.303 | 98.303 | 98.298 | 98.298 | 28085.0 |
| 2016-08-30 | EW | Futures | 1664.0 | 1667.6 | 1656.3 | 1663.5 | 11766.0 |
| 2016-08-30 | FBON | Futures | 124.94 | 124.94 | 124.75 | 124.82 | 814.0 |
| 2016-08-30 | FBTP | Futures | 110.79 | 110.97 | 110.65 | 110.89 | 85951.0 |
| 2016-08-30 | FBTS | Futures | 101.347 | 101.365 | 101.338 | 101.347 | 14284.0 |
| 2016-08-30 | FCE | Futures | 3874.6 | 3909.1 | 3874.2 | 3893.4 | 68809.0 |
| 2016-08-30 | FDAX | Futures | 11247.4 | 11375.6 | 11246.3 | 11348.0 | 75851.0 |
| 2016-08-30 | FDXM | Futures | 10968.9 | 11090.3 | 10962.7 | 11061.2 | 22154.0 |
| 2016-08-30 | FESX | Futures | 2355.7 | 2382.3 | 2354.9 | 2375.3 | 866339.0 |
| 2016-08-30 | FGBL | Futures | 150.81 | 151.04 | 150.6 | 150.93 | 530082.0 |
| 2016-08-30 | FGBM | Futures | 128.94 | 128.98 | 128.88 | 128.94 | 361398.0 |
| 2016-08-30 | FGBS | Futures | 111.887 | 111.892 | 111.867 | 111.882 | 209214.0 |
| 2016-08-30 | FGBX | Futures | 188.22 | 189.86 | 187.48 | 189.31 | 28310.0 |
| 2016-08-30 | FMWO | Futures | 5770.8 | 5772.0 | 5769.5 | 5770.8 | 81.0 |
| 2016-08-30 | FOAT | Futures | 138.46 | 138.78 | 138.33 | 138.63 | 76726.0 |
| 2016-08-30 | FTDX | Futures | 1671.3 | 1687.6 | 1671.3 | 1678.5 | 73.0 |
| 2016-08-30 | FTI | Futures | 409.16 | 413.09 | 408.89 | 411.33 | 26067.0 |
| 2016-08-30 | FTUK | Futures | 5706.2 | 5716.6 | 5678.7 | 5694.9 | 93998.0 |
| 2016-08-30 | FVSA | Futures | 1886.61 | 1886.61 | 1830.36 | 1839.01 | 6372.0 |
| 2016-08-30 | FXXP | Futures | 278.0 | 279.9 | 277.9 | 279.2 | 15066.0 |
| 2016-08-30 | G | Futures | 117.0 | 117.58 | 116.95 | 117.3 | 189178.0 |
| 2016-08-30 | GF | Futures | 280.355 | 288.505 | 275.677 | 286.795 | 4429.0 |
| 2016-08-30 | GSCI | Futures | 510.86 | 510.86 | 504.76 | 504.76 | 331.0 |
| 2016-08-30 | HE | Futures | 84.916 | 86.196 | 84.466 | 85.85 | 11339.0 |
> showing 50 of 108 rows — these rows as CSV