PREVIEW / futures_daily / 2016-10-13
file: by_date/futures_daily/2016/2016-10-13.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-10-13 | ES | Futures | 2301.37 | 2306.23 | 2279.73 | 2299.74 | 2195134.0 |
| 2016-10-13 | NQ | Futures | 5662.63 | 5672.35 | 5603.41 | 5652.32 | 297938.0 |
| 2016-10-13 | YM | Futures | 18920.8 | 18953.4 | 18762.2 | 18922.9 | 185060.0 |
| 2016-10-13 | CL | Futures | 55.13 | 55.78 | 54.43 | 55.62 | 740676.0 |
| 2016-10-13 | GC | Futures | 1612.9 | 1621.6 | 1609.8 | 1613.5 | 150097.0 |
| 2016-10-13 | ZN | Futures | 126.359673 | 126.724479 | 126.344473 | 126.648478 | 1124596.0 |
| 2016-10-13 | A6 | Futures | 0.77091 | 0.77244 | 0.76469 | 0.77193 | 111053.0 |
| 2016-10-13 | AD | Futures | 0.77212 | 0.77714 | 0.77002 | 0.77688 | 71074.0 |
| 2016-10-13 | ALI | Futures | 2228.72 | 2239.85 | 2228.72 | 2233.49 | 43.0 |
| 2016-10-13 | B | Futures | 39.93 | 40.36 | 39.41 | 40.27 | 310648.0 |
| 2016-10-13 | B6 | Futures | 1.2848 | 1.2935 | 1.2785 | 1.2917 | 127872.0 |
| 2016-10-13 | BR | Futures | 0.21171 | 0.21239 | 0.21136 | 0.21226 | 22.0 |
| 2016-10-13 | BZ | Futures | 39.8 | 40.13 | 39.2 | 40.04 | 25642.0 |
| 2016-10-13 | C | Futures | 2386.0 | 2409.0 | 2377.0 | 2401.0 | 8209.0 |
| 2016-10-13 | CB | Futures | 228.149 | 228.149 | 224.739 | 224.739 | 123.0 |
| 2016-10-13 | CC | Futures | 1955.0 | 2002.0 | 1950.0 | 1994.0 | 24234.0 |
| 2016-10-13 | CNH | Futures | 7.2694 | 7.28 | 7.2694 | 7.2707 | 19.0 |
| 2016-10-13 | CSC | Futures | 3.7 | 3.707 | 3.684 | 3.695 | 49.0 |
| 2016-10-13 | CT | Futures | 76.98 | 78.48 | 76.63 | 77.65 | 17900.0 |
| 2016-10-13 | DC | Futures | 28.96 | 29.13 | 28.84 | 28.98 | 185.0 |
| 2016-10-13 | DX | Futures | 91.211 | 91.322 | 90.755 | 90.762 | 28204.0 |
| 2016-10-13 | E1 | Futures | 1.26126 | 1.26799 | 1.26126 | 1.26774 | 20494.0 |
| 2016-10-13 | E6 | Futures | 1.27921 | 1.2853 | 1.27678 | 1.28489 | 183857.0 |
| 2016-10-13 | E7 | Futures | 1.2724 | 1.2783 | 1.27 | 1.2779 | 2721.0 |
| 2016-10-13 | EBM | Futures | 186.82 | 190.06 | 186.82 | 189.76 | 27078.0 |
| 2016-10-13 | ED | Futures | 95.6249 | 95.6345 | 95.62 | 95.6345 | 192203.0 |
| 2016-10-13 | ER | Futures | 98.279 | 98.279 | 98.274 | 98.279 | 24084.0 |
| 2016-10-13 | EW | Futures | 1615.0 | 1618.6 | 1599.0 | 1613.9 | 14088.0 |
| 2016-10-13 | FBON | Futures | 124.32 | 124.35 | 123.99 | 124.13 | 602.0 |
| 2016-10-13 | FBTP | Futures | 108.45 | 108.61 | 108.32 | 108.45 | 113587.0 |
| 2016-10-13 | FBTS | Futures | 101.266 | 101.275 | 101.221 | 101.239 | 24378.0 |
| 2016-10-13 | FCE | Futures | 3946.6 | 3946.6 | 3890.5 | 3919.9 | 1278.0 |
| 2016-10-13 | FDAX | Futures | 11046.2 | 11059.9 | 10923.6 | 10987.0 | 117662.0 |
| 2016-10-13 | FDXM | Futures | 11025.5 | 11032.8 | 10900.0 | 10963.3 | 37772.0 |
| 2016-10-13 | FESX | Futures | 2387.7 | 2390.1 | 2358.1 | 2373.3 | 1214014.0 |
| 2016-10-13 | FEU3 | Futures | 98.956 | 98.956 | 98.956 | 98.956 | 17.0 |
| 2016-10-13 | FGBL | Futures | 149.47 | 149.7 | 149.26 | 149.52 | 667698.0 |
| 2016-10-13 | FGBM | Futures | 128.84 | 128.87 | 128.73 | 128.78 | 401162.0 |
| 2016-10-13 | FGBS | Futures | 111.947 | 111.957 | 111.917 | 111.927 | 184638.0 |
| 2016-10-13 | FGBX | Futures | 180.17 | 182.21 | 179.88 | 181.76 | 45377.0 |
| 2016-10-13 | FMWO | Futures | 5613.0 | 5627.5 | 5598.5 | 5626.3 | 1542.0 |
| 2016-10-13 | FOAT | Futures | 137.11 | 137.37 | 136.98 | 137.2 | 112421.0 |
| 2016-10-13 | FTDX | Futures | 1734.7 | 1745.5 | 1728.8 | 1735.7 | 239.0 |
| 2016-10-13 | FTI | Futures | 409.57 | 410.31 | 405.48 | 407.55 | 149.0 |
| 2016-10-13 | FTUK | Futures | 5910.3 | 5910.3 | 5817.8 | 5861.7 | 141314.0 |
| 2016-10-13 | FVSA | Futures | 1515.0 | 1530.46 | 1477.9 | 1502.63 | 13657.0 |
| 2016-10-13 | FXXP | Futures | 276.8 | 277.3 | 274.4 | 275.9 | 36622.0 |
| 2016-10-13 | G | Futures | 113.66 | 113.98 | 113.48 | 113.67 | 241774.0 |
| 2016-10-13 | GF | Futures | 251.796 | 252.601 | 246.212 | 246.588 | 6477.0 |
| 2016-10-13 | GSCI | Futures | 516.83 | 520.71 | 516.35 | 520.16 | 2950.0 |
> showing 50 of 108 rows — these rows as CSV