PREVIEW / futures_daily / 2016-01-15
file: by_date/futures_daily/2016/2016-01-15.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-01-15 | ES | Futures | 2043.88 | 2051.89 | 1975.25 | 2002.76 | 3441956.0 |
| 2016-01-15 | NQ | Futures | 4988.17 | 5004.29 | 4778.03 | 4854.23 | 567530.0 |
| 2016-01-15 | YM | Futures | 16834.1 | 16899.3 | 16296.0 | 16465.7 | 357593.0 |
| 2016-01-15 | CL | Futures | 46.26 | 46.28 | 43.3 | 43.78 | 358984.0 |
| 2016-01-15 | GC | Futures | 1391.8 | 1415.4 | 1387.7 | 1406.7 | 173457.0 |
| 2016-01-15 | ZN | Futures | 123.115287 | 124.09299 | 123.04008 | 123.656784 | 1912986.0 |
| 2016-01-15 | A6 | Futures | 0.69789 | 0.69959 | 0.68226 | 0.68556 | 162529.0 |
| 2016-01-15 | AD | Futures | 0.71235 | 0.71286 | 0.70253 | 0.70325 | 115479.0 |
| 2016-01-15 | ALI | Futures | 2063.33 | 2063.33 | 2063.33 | 2063.33 | 0.0 |
| 2016-01-15 | B | Futures | 26.71 | 26.73 | 24.84 | 24.94 | 344461.0 |
| 2016-01-15 | B6 | Futures | 1.517 | 1.518 | 1.4995 | 1.5006 | 97202.0 |
| 2016-01-15 | BFX | Futures | 4174.4 | 4175.6 | 4045.7 | 4066.2 | 128.0 |
| 2016-01-15 | BR | Futures | 0.15372 | 0.15466 | 0.15274 | 0.15331 | 26.0 |
| 2016-01-15 | BZ | Futures | 26.42 | 26.47 | 24.59 | 24.68 | 37163.0 |
| 2016-01-15 | C | Futures | 2179.0 | 2228.0 | 2179.0 | 2226.0 | 16900.0 |
| 2016-01-15 | CB | Futures | 280.79 | 293.468 | 280.79 | 290.376 | 99.0 |
| 2016-01-15 | CC | Futures | 2120.0 | 2152.0 | 2117.0 | 2142.0 | 16128.0 |
| 2016-01-15 | CNH | Futures | 7.357 | 7.377 | 7.3522 | 7.3556 | 63.0 |
| 2016-01-15 | CSC | Futures | 3.826 | 3.846 | 3.799 | 3.826 | 63.0 |
| 2016-01-15 | CT | Futures | 72.52 | 72.65 | 71.85 | 71.93 | 13348.0 |
| 2016-01-15 | DC | Futures | 30.17 | 30.62 | 30.02 | 30.34 | 198.0 |
| 2016-01-15 | DX | Futures | 92.593 | 92.663 | 91.934 | 92.499 | 46070.0 |
| 2016-01-15 | E1 | Futures | 1.2592 | 1.27056 | 1.25769 | 1.26261 | 20427.0 |
| 2016-01-15 | E6 | Futures | 1.27221 | 1.2863 | 1.27104 | 1.27742 | 272693.0 |
| 2016-01-15 | E7 | Futures | 1.2651 | 1.2791 | 1.264 | 1.2703 | 8807.0 |
| 2016-01-15 | EBM | Futures | 234.12 | 234.12 | 232.36 | 233.42 | 17984.0 |
| 2016-01-15 | ED | Futures | 95.6025 | 95.641 | 95.5976 | 95.6169 | 481381.0 |
| 2016-01-15 | ER | Futures | 98.225 | 98.234 | 98.225 | 98.234 | 69827.0 |
| 2016-01-15 | EW | Futures | 1359.8 | 1359.8 | 1310.1 | 1336.7 | 30015.0 |
| 2016-01-15 | FBON | Futures | 115.33 | 115.84 | 115.33 | 115.57 | 553.0 |
| 2016-01-15 | FBTP | Futures | 105.14 | 105.63 | 105.02 | 105.21 | 119154.0 |
| 2016-01-15 | FBTS | Futures | 100.828 | 100.882 | 100.828 | 100.873 | 20218.0 |
| 2016-01-15 | FCE | Futures | 3610.9 | 3621.8 | 3477.0 | 3528.6 | 182186.0 |
| 2016-01-15 | FDAX | Futures | 10611.7 | 10663.7 | 10203.9 | 10311.8 | 166585.0 |
| 2016-01-15 | FDXM | Futures | 10149.4 | 10194.0 | 9755.4 | 9859.1 | 38927.0 |
| 2016-01-15 | FESX | Futures | 2293.2 | 2299.3 | 2205.0 | 2232.4 | 2276345.0 |
| 2016-01-15 | FGBL | Futures | 140.99 | 141.48 | 140.87 | 141.37 | 755905.0 |
| 2016-01-15 | FGBM | Futures | 126.06 | 126.3 | 126.06 | 126.24 | 430845.0 |
| 2016-01-15 | FGBS | Futures | 111.518 | 111.568 | 111.513 | 111.553 | 252658.0 |
| 2016-01-15 | FGBX | Futures | 159.43 | 160.7 | 159.22 | 160.21 | 38355.0 |
| 2016-01-15 | FMWO | Futures | 5168.3 | 5168.3 | 5094.9 | 5109.8 | 590.0 |
| 2016-01-15 | FOAT | Futures | 128.63 | 129.07 | 128.5 | 128.87 | 102878.0 |
| 2016-01-15 | FTDX | Futures | 1598.1 | 1619.2 | 1532.8 | 1543.8 | 861.0 |
| 2016-01-15 | FTI | Futures | 364.42 | 365.17 | 350.79 | 355.57 | 61650.0 |
| 2016-01-15 | FTUK | Futures | 4826.3 | 4826.3 | 4635.0 | 4678.6 | 189602.0 |
| 2016-01-15 | FVSA | Futures | 2828.05 | 3067.46 | 2773.18 | 2982.67 | 15731.0 |
| 2016-01-15 | FXXP | Futures | 264.3 | 266.4 | 254.5 | 257.7 | 51430.0 |
| 2016-01-15 | G | Futures | 105.96 | 106.73 | 105.87 | 106.5 | 204343.0 |
| 2016-01-15 | GF | Futures | 299.929 | 300.174 | 295.069 | 295.069 | 3456.0 |
| 2016-01-15 | GSCI | Futures | 439.33 | 439.95 | 435.89 | 436.43 | 889.0 |
> showing 50 of 109 rows — these rows as CSV