PREVIEW / futures_daily / 2016-08-10
file: by_date/futures_daily/2016/2016-08-10.parquet size: 9 KB rows: 107
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-10 | ES | Futures | 2351.57 | 2355.35 | 2340.5 | 2345.9 | 1371937.0 |
| 2016-08-10 | NQ | Futures | 5650.27 | 5658.22 | 5619.33 | 5636.12 | 141495.0 |
| 2016-08-10 | YM | Futures | 19292.2 | 19337.2 | 19236.9 | 19273.4 | 96005.0 |
| 2016-08-10 | CL | Futures | 48.44 | 49.18 | 46.95 | 47.28 | 676148.0 |
| 2016-08-10 | GC | Futures | 1728.2 | 1749.5 | 1726.5 | 1734.5 | 191322.0 |
| 2016-08-10 | ZN | Futures | 127.788387 | 128.241109 | 127.788387 | 128.195837 | 1027376.0 |
| 2016-08-10 | A6 | Futures | 0.77945 | 0.7883 | 0.77874 | 0.78352 | 97178.0 |
| 2016-08-10 | AD | Futures | 0.78022 | 0.7881 | 0.78006 | 0.78395 | 85743.0 |
| 2016-08-10 | ALI | Futures | 2160.43 | 2160.43 | 2157.57 | 2157.89 | 7.0 |
| 2016-08-10 | B | Futures | 35.5 | 36.11 | 34.63 | 34.82 | 284858.0 |
| 2016-08-10 | B6 | Futures | 1.3709 | 1.3814 | 1.3704 | 1.3726 | 74777.0 |
| 2016-08-10 | BR | Futures | 0.21102 | 0.21232 | 0.21029 | 0.21188 | 930.0 |
| 2016-08-10 | BZ | Futures | 35.39 | 35.92 | 34.46 | 34.64 | 24646.0 |
| 2016-08-10 | C | Futures | 2546.0 | 2589.0 | 2521.0 | 2577.0 | 7540.0 |
| 2016-08-10 | CB | Futures | 266.911 | 269.607 | 266.091 | 266.091 | 12.0 |
| 2016-08-10 | CC | Futures | 2188.0 | 2234.0 | 2171.0 | 2223.0 | 27831.0 |
| 2016-08-10 | CNH | Futures | 7.2015 | 7.2015 | 7.1913 | 7.1915 | 5.0 |
| 2016-08-10 | CSC | Futures | 3.849 | 3.855 | 3.834 | 3.855 | 15.0 |
| 2016-08-10 | CT | Futures | 81.56 | 81.88 | 80.45 | 80.61 | 53.0 |
| 2016-08-10 | DC | Futures | 31.1 | 31.12 | 30.67 | 30.9 | 152.0 |
| 2016-08-10 | DX | Futures | 89.355 | 89.355 | 88.709 | 88.921 | 16389.0 |
| 2016-08-10 | E1 | Futures | 1.27817 | 1.28731 | 1.2778 | 1.28631 | 14213.0 |
| 2016-08-10 | E6 | Futures | 1.29597 | 1.30476 | 1.29591 | 1.3029 | 140949.0 |
| 2016-08-10 | E7 | Futures | 1.2893 | 1.2977 | 1.289 | 1.296 | 1774.0 |
| 2016-08-10 | EBM | Futures | 198.48 | 200.88 | 197.87 | 200.58 | 8954.0 |
| 2016-08-10 | ED | Futures | 95.6026 | 95.6316 | 95.5978 | 95.6267 | 283604.0 |
| 2016-08-10 | ER | Futures | 98.313 | 98.313 | 98.308 | 98.313 | 13746.0 |
| 2016-08-10 | EW | Futures | 1653.0 | 1656.0 | 1645.1 | 1647.5 | 12883.0 |
| 2016-08-10 | FBON | Futures | 124.39 | 124.76 | 124.34 | 124.69 | 267.0 |
| 2016-08-10 | FBTP | Futures | 110.67 | 111.07 | 110.61 | 110.95 | 59500.0 |
| 2016-08-10 | FBTS | Futures | 101.338 | 101.365 | 101.32 | 101.356 | 14474.0 |
| 2016-08-10 | FCE | Futures | 3888.6 | 3899.1 | 3875.1 | 3886.5 | 53319.0 |
| 2016-08-10 | FDAX | Futures | 11382.6 | 11401.2 | 11312.3 | 11337.3 | 72138.0 |
| 2016-08-10 | FDXM | Futures | 11091.3 | 11107.9 | 11026.0 | 11050.9 | 17690.0 |
| 2016-08-10 | FESX | Futures | 2368.2 | 2373.7 | 2358.8 | 2363.5 | 702212.0 |
| 2016-08-10 | FGBL | Futures | 150.81 | 151.17 | 150.71 | 151.02 | 492783.0 |
| 2016-08-10 | FGBM | Futures | 128.99 | 129.14 | 128.94 | 129.06 | 307827.0 |
| 2016-08-10 | FGBS | Futures | 111.892 | 111.922 | 111.877 | 111.902 | 150431.0 |
| 2016-08-10 | FGBX | Futures | 189.64 | 190.99 | 189.29 | 190.31 | 24113.0 |
| 2016-08-10 | FMWO | Futures | 5773.2 | 5773.2 | 5769.5 | 5769.5 | 79.0 |
| 2016-08-10 | FOAT | Futures | 138.79 | 139.11 | 138.68 | 139.02 | 60026.0 |
| 2016-08-10 | FTDX | Futures | 1667.4 | 1669.3 | 1653.4 | 1667.4 | 34.0 |
| 2016-08-10 | FTI | Futures | 406.68 | 407.45 | 405.91 | 406.09 | 53.0 |
| 2016-08-10 | FTUK | Futures | 5667.8 | 5689.9 | 5648.2 | 5683.3 | 101791.0 |
| 2016-08-10 | FVSA | Futures | 1888.72 | 1976.57 | 1849.68 | 1971.69 | 13870.0 |
| 2016-08-10 | FXXP | Futures | 277.9 | 278.4 | 277.0 | 277.5 | 17666.0 |
| 2016-08-10 | G | Futures | 117.25 | 117.57 | 117.04 | 117.26 | 197247.0 |
| 2016-08-10 | GF | Futures | 299.874 | 301.534 | 297.661 | 298.818 | 3851.0 |
| 2016-08-10 | GSCI | Futures | 492.71 | 495.26 | 484.34 | 484.91 | 2586.0 |
| 2016-08-10 | HE | Futures | 80.246 | 81.976 | 79.728 | 81.595 | 14306.0 |
> showing 50 of 107 rows — these rows as CSV