PREVIEW / futures_daily / 2016-04-18
file: by_date/futures_daily/2016/2016-04-18.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-04-18 | ES | Futures | 2216.42 | 2242.73 | 2210.25 | 2240.58 | 1400343.0 |
| 2016-04-18 | NQ | Futures | 5309.56 | 5359.5 | 5288.71 | 5342.17 | 179869.0 |
| 2016-04-18 | YM | Futures | 18439.0 | 18648.0 | 18395.3 | 18640.7 | 128805.0 |
| 2016-04-18 | CL | Futures | 47.53 | 49.63 | 46.46 | 49.07 | 609487.0 |
| 2016-04-18 | GC | Futures | 1593.5 | 1602.5 | 1587.6 | 1591.8 | 148658.0 |
| 2016-04-18 | ZN | Futures | 126.354785 | 126.384959 | 125.887083 | 126.007781 | 899723.0 |
| 2016-04-18 | A6 | Futures | 0.77405 | 0.78336 | 0.77041 | 0.78194 | 96613.0 |
| 2016-04-18 | AD | Futures | 0.78965 | 0.80048 | 0.78709 | 0.79834 | 80717.0 |
| 2016-04-18 | ALI | Futures | 2133.48 | 2133.48 | 2133.48 | 2133.48 | 0.0 |
| 2016-04-18 | B | Futures | 34.81 | 36.17 | 33.4 | 35.74 | 383372.0 |
| 2016-04-18 | B6 | Futures | 1.4934 | 1.5051 | 1.4882 | 1.5034 | 81199.0 |
| 2016-04-18 | BFX | Futures | 3984.3 | 3991.9 | 3984.3 | 3991.9 | 2.0 |
| 2016-04-18 | BR | Futures | 0.18152 | 0.18152 | 0.17836 | 0.17979 | 43.0 |
| 2016-04-18 | BZ | Futures | 34.42 | 35.79 | 33.03 | 35.37 | 39238.0 |
| 2016-04-18 | C | Futures | 2296.0 | 2334.0 | 2285.0 | 2333.0 | 6593.0 |
| 2016-04-18 | CC | Futures | 2175.0 | 2228.0 | 2160.0 | 2224.0 | 18971.0 |
| 2016-04-18 | CNH | Futures | 7.0662 | 7.0713 | 7.0603 | 7.0603 | 19.0 |
| 2016-04-18 | CSC | Futures | 3.618 | 3.632 | 3.618 | 3.632 | 14.0 |
| 2016-04-18 | CT | Futures | 68.68 | 71.4 | 68.46 | 71.38 | 14481.0 |
| 2016-04-18 | DC | Futures | 28.73 | 28.92 | 28.59 | 28.88 | 95.0 |
| 2016-04-18 | DX | Futures | 88.281 | 88.393 | 87.978 | 88.066 | 14290.0 |
| 2016-04-18 | E1 | Futures | 1.30271 | 1.30811 | 1.3012 | 1.3056 | 14445.0 |
| 2016-04-18 | E6 | Futures | 1.31937 | 1.3238 | 1.31698 | 1.32158 | 102535.0 |
| 2016-04-18 | E7 | Futures | 1.3122 | 1.3165 | 1.3098 | 1.3144 | 2167.0 |
| 2016-04-18 | EBM | Futures | 195.27 | 195.92 | 191.73 | 194.31 | 36725.0 |
| 2016-04-18 | ED | Futures | 95.7256 | 95.7304 | 95.7208 | 95.7208 | 175841.0 |
| 2016-04-18 | ER | Futures | 98.264 | 98.264 | 98.254 | 98.254 | 38501.0 |
| 2016-04-18 | EW | Futures | 1535.8 | 1552.6 | 1532.4 | 1550.6 | 11158.0 |
| 2016-04-18 | FBON | Futures | 118.62 | 118.78 | 118.31 | 118.68 | 301.0 |
| 2016-04-18 | FBTP | Futures | 107.09 | 107.14 | 106.4 | 106.93 | 73529.0 |
| 2016-04-18 | FBTS | Futures | 100.997 | 101.033 | 100.97 | 101.024 | 12537.0 |
| 2016-04-18 | FCE | Futures | 3719.6 | 3778.3 | 3697.5 | 3768.9 | 79254.0 |
| 2016-04-18 | FDAX | Futures | 10712.5 | 10939.1 | 10675.4 | 10920.9 | 103766.0 |
| 2016-04-18 | FDXM | Futures | 10317.9 | 10533.0 | 10279.6 | 10515.4 | 19091.0 |
| 2016-04-18 | FESX | Futures | 2300.2 | 2342.3 | 2289.3 | 2339.2 | 1027178.0 |
| 2016-04-18 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.912 | 35.0 |
| 2016-04-18 | FGBL | Futures | 146.76 | 146.84 | 146.11 | 146.22 | 589284.0 |
| 2016-04-18 | FGBM | Futures | 127.74 | 127.76 | 127.58 | 127.62 | 357167.0 |
| 2016-04-18 | FGBS | Futures | 111.688 | 111.693 | 111.658 | 111.668 | 157492.0 |
| 2016-04-18 | FGBX | Futures | 175.1 | 175.39 | 173.21 | 173.64 | 30227.0 |
| 2016-04-18 | FMWO | Futures | 5646.4 | 5688.7 | 5646.4 | 5686.2 | 7.0 |
| 2016-04-18 | FOAT | Futures | 134.26 | 134.31 | 133.72 | 133.84 | 84102.0 |
| 2016-04-18 | FTDX | Futures | 1553.8 | 1578.0 | 1549.5 | 1578.0 | 51.0 |
| 2016-04-18 | FTI | Futures | 396.94 | 402.17 | 395.13 | 401.23 | 28069.0 |
| 2016-04-18 | FTUK | Futures | 5179.4 | 5207.8 | 5127.8 | 5203.3 | 88100.0 |
| 2016-04-18 | FVSA | Futures | 2633.94 | 2649.68 | 2460.79 | 2492.27 | 12150.0 |
| 2016-04-18 | FXXP | Futures | 268.0 | 273.0 | 267.2 | 272.6 | 25792.0 |
| 2016-04-18 | G | Futures | 108.69 | 108.86 | 108.1 | 108.2 | 152158.0 |
| 2016-04-18 | GF | Futures | 300.773 | 300.823 | 291.734 | 291.734 | 7285.0 |
| 2016-04-18 | GSCI | Futures | 485.69 | 495.0 | 484.66 | 492.95 | 296.0 |
> showing 50 of 109 rows — these rows as CSV