PREVIEW / futures_daily / 2016-12-05
file: by_date/futures_daily/2016/2016-12-05.parquet size: 9 KB rows: 109
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-12-05 | ES | Futures | 2362.21 | 2388.98 | 2356.8 | 2384.11 | 1663731.0 |
| 2016-12-05 | NQ | Futures | 5561.57 | 5652.02 | 5540.95 | 5634.05 | 207428.0 |
| 2016-12-05 | YM | Futures | 20066.4 | 20240.7 | 20038.1 | 20171.4 | 141710.0 |
| 2016-12-05 | CL | Futures | 55.53 | 56.56 | 54.96 | 55.88 | 600782.0 |
| 2016-12-05 | GC | Futures | 1518.7 | 1528.5 | 1487.9 | 1510.9 | 221458.0 |
| 2016-12-05 | ZN | Futures | 122.194805 | 122.346807 | 121.343591 | 121.784398 | 52882.0 |
| 2016-12-05 | A6 | Futures | 0.75724 | 0.76489 | 0.75632 | 0.76275 | 94732.0 |
| 2016-12-05 | AD | Futures | 0.76833 | 0.77402 | 0.767 | 0.77222 | 62586.0 |
| 2016-12-05 | ALI | Futures | 2390.95 | 2390.95 | 2390.95 | 2390.95 | 0.0 |
| 2016-12-05 | B | Futures | 40.53 | 41.22 | 40.06 | 40.93 | 288551.0 |
| 2016-12-05 | B6 | Futures | 1.3322 | 1.3421 | 1.3301 | 1.3399 | 113563.0 |
| 2016-12-05 | BFX | Futures | 4114.5 | 4122.9 | 4114.5 | 4118.7 | 2.0 |
| 2016-12-05 | BR | Futures | 0.20011 | 0.20274 | 0.20011 | 0.20274 | 10.0 |
| 2016-12-05 | BZ | Futures | 40.1 | 40.92 | 39.79 | 40.63 | 33656.0 |
| 2016-12-05 | C | Futures | 2023.0 | 2023.0 | 1967.0 | 1985.0 | 4718.0 |
| 2016-12-05 | CB | Futures | 261.265 | 263.309 | 261.203 | 262.088 | 21.0 |
| 2016-12-05 | CC | Futures | 1819.0 | 1821.0 | 1789.0 | 1802.0 | 16954.0 |
| 2016-12-05 | CNH | Futures | 7.41 | 7.4101 | 7.3778 | 7.3778 | 121.0 |
| 2016-12-05 | CSC | Futures | 3.981 | 3.992 | 3.962 | 3.967 | 111.0 |
| 2016-12-05 | CT | Futures | 81.7 | 82.42 | 81.33 | 81.57 | 11052.0 |
| 2016-12-05 | DC | Futures | 32.29 | 32.34 | 31.94 | 32.13 | 165.0 |
| 2016-12-05 | DX | Futures | 94.519 | 94.747 | 92.951 | 93.176 | 80454.0 |
| 2016-12-05 | E1 | Futures | 1.22675 | 1.24045 | 1.22263 | 1.23871 | 39825.0 |
| 2016-12-05 | E6 | Futures | 1.22299 | 1.2522 | 1.21835 | 1.24901 | 304739.0 |
| 2016-12-05 | E7 | Futures | 1.2153 | 1.2454 | 1.2119 | 1.2423 | 7942.0 |
| 2016-12-05 | EBM | Futures | 188.29 | 188.58 | 184.3 | 184.87 | 25673.0 |
| 2016-12-05 | ED | Futures | 95.5911 | 95.5935 | 95.5838 | 95.5886 | 192584.0 |
| 2016-12-05 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 44169.0 |
| 2016-12-05 | EW | Futures | 1724.2 | 1749.0 | 1719.7 | 1746.6 | 13125.0 |
| 2016-12-05 | FBON | Futures | 120.2 | 120.73 | 120.13 | 120.51 | 795.0 |
| 2016-12-05 | FBTP | Futures | 104.45 | 105.41 | 104.41 | 104.87 | 110415.0 |
| 2016-12-05 | FBTS | Futures | 100.817 | 100.952 | 100.808 | 100.916 | 33137.0 |
| 2016-12-05 | FCE | Futures | 3960.8 | 4066.7 | 3947.1 | 4037.6 | 147100.0 |
| 2016-12-05 | FDAX | Futures | 11036.6 | 11351.0 | 11011.3 | 11302.9 | 135437.0 |
| 2016-12-05 | FDXM | Futures | 11019.1 | 11324.9 | 10990.7 | 11278.5 | 37638.0 |
| 2016-12-05 | FESX | Futures | 2390.1 | 2460.6 | 2382.1 | 2445.4 | 1631737.0 |
| 2016-12-05 | FGBL | Futures | 147.0 | 147.05 | 145.41 | 145.95 | 852971.0 |
| 2016-12-05 | FGBM | Futures | 128.56 | 128.56 | 127.89 | 128.06 | 636920.0 |
| 2016-12-05 | FGBS | Futures | 112.122 | 112.127 | 111.962 | 111.992 | 524747.0 |
| 2016-12-05 | FGBX | Futures | 171.65 | 172.07 | 167.97 | 169.24 | 58244.0 |
| 2016-12-05 | FMWO | Futures | 5734.0 | 5758.2 | 5734.0 | 5758.2 | 69.0 |
| 2016-12-05 | FOAT | Futures | 132.84 | 133.25 | 131.79 | 132.28 | 178981.0 |
| 2016-12-05 | FTDX | Futures | 1629.8 | 1680.8 | 1629.8 | 1667.1 | 179.0 |
| 2016-12-05 | FTI | Futures | 405.72 | 417.38 | 405.44 | 414.19 | 56610.0 |
| 2016-12-05 | FTUK | Futures | 5652.4 | 5740.2 | 5640.1 | 5703.0 | 133310.0 |
| 2016-12-05 | FVSA | Futures | 1347.89 | 1347.89 | 1203.36 | 1222.21 | 34875.0 |
| 2016-12-05 | FXXP | Futures | 278.8 | 284.7 | 278.4 | 281.8 | 30645.0 |
| 2016-12-05 | G | Futures | 110.58 | 110.67 | 109.81 | 110.48 | 184006.0 |
| 2016-12-05 | GF | Futures | 278.348 | 279.965 | 276.675 | 277.344 | 3259.0 |
| 2016-12-05 | GSCI | Futures | 530.89 | 532.6 | 529.94 | 530.14 | 183.0 |
> showing 50 of 109 rows — these rows as CSV