PREVIEW / futures_daily / 2016-05-06
file: by_date/futures_daily/2016/2016-05-06.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-05-06 | ES | Futures | 2194.14 | 2205.95 | 2180.18 | 2204.07 | 1813432.0 |
| 2016-05-06 | NQ | Futures | 5051.65 | 5092.19 | 5018.46 | 5085.72 | 262686.0 |
| 2016-05-06 | YM | Futures | 18267.4 | 18388.0 | 18169.7 | 18373.5 | 161221.0 |
| 2016-05-06 | CL | Futures | 53.04 | 54.01 | 51.87 | 53.2 | 695306.0 |
| 2016-05-06 | GC | Futures | 1648.9 | 1672.6 | 1644.9 | 1667.9 | 257613.0 |
| 2016-05-06 | ZN | Futures | 126.249175 | 126.686702 | 125.962519 | 126.037955 | 1515455.0 |
| 2016-05-06 | A6 | Futures | 0.75442 | 0.75583 | 0.74166 | 0.74399 | 124943.0 |
| 2016-05-06 | AD | Futures | 0.79496 | 0.79701 | 0.78944 | 0.79046 | 86378.0 |
| 2016-05-06 | ALI | Futures | 2162.56 | 2162.56 | 2155.13 | 2157.07 | 11.0 |
| 2016-05-06 | B | Futures | 37.49 | 38.28 | 36.68 | 37.66 | 283651.0 |
| 2016-05-06 | B6 | Futures | 1.5252 | 1.5325 | 1.518 | 1.5185 | 91111.0 |
| 2016-05-06 | BFX | Futures | 3890.2 | 3893.8 | 3866.7 | 3890.2 | 10.0 |
| 2016-05-06 | BR | Futures | 0.18249 | 0.18464 | 0.18087 | 0.18448 | 1613.0 |
| 2016-05-06 | BZ | Futures | 37.37 | 38.15 | 36.55 | 37.54 | 24512.0 |
| 2016-05-06 | C | Futures | 2397.0 | 2397.0 | 2338.0 | 2347.0 | 12241.0 |
| 2016-05-06 | CC | Futures | 2304.0 | 2306.0 | 2243.0 | 2249.0 | 25307.0 |
| 2016-05-06 | CNH | Futures | 7.095 | 7.095 | 7.082 | 7.0899 | 8.0 |
| 2016-05-06 | CSC | Futures | 3.429 | 3.429 | 3.389 | 3.415 | 99.0 |
| 2016-05-06 | CT | Futures | 70.55 | 70.75 | 70.14 | 70.33 | 12709.0 |
| 2016-05-06 | DC | Futures | 26.81 | 26.81 | 26.48 | 26.69 | 322.0 |
| 2016-05-06 | DX | Futures | 87.404 | 87.596 | 86.784 | 87.528 | 21437.0 |
| 2016-05-06 | E1 | Futures | 1.30032 | 1.30409 | 1.29328 | 1.29466 | 21060.0 |
| 2016-05-06 | E6 | Futures | 1.3315 | 1.34094 | 1.32934 | 1.33068 | 188664.0 |
| 2016-05-06 | E7 | Futures | 1.324 | 1.3331 | 1.3222 | 1.3235 | 2728.0 |
| 2016-05-06 | EBM | Futures | 191.56 | 193.96 | 191.26 | 193.06 | 8211.0 |
| 2016-05-06 | ED | Futures | 95.7401 | 95.7593 | 95.7304 | 95.7401 | 308101.0 |
| 2016-05-06 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.259 | 29316.0 |
| 2016-05-06 | EW | Futures | 1526.2 | 1534.7 | 1516.3 | 1533.6 | 14056.0 |
| 2016-05-06 | FBON | Futures | 117.84 | 118.19 | 117.76 | 118.1 | 270.0 |
| 2016-05-06 | FBTP | Futures | 106.04 | 106.2 | 105.64 | 106.03 | 96982.0 |
| 2016-05-06 | FBTS | Futures | 101.06 | 101.087 | 101.033 | 101.06 | 18580.0 |
| 2016-05-06 | FCE | Futures | 3630.4 | 3654.6 | 3585.8 | 3634.2 | 93168.0 |
| 2016-05-06 | FDAX | Futures | 10542.2 | 10668.4 | 10458.4 | 10609.4 | 107525.0 |
| 2016-05-06 | FDXM | Futures | 10154.4 | 10271.3 | 10070.6 | 10216.5 | 22796.0 |
| 2016-05-06 | FESX | Futures | 2251.1 | 2275.2 | 2226.9 | 2262.0 | 1381948.0 |
| 2016-05-06 | FGBL | Futures | 146.51 | 146.62 | 146.17 | 146.52 | 597664.0 |
| 2016-05-06 | FGBM | Futures | 127.71 | 127.75 | 127.61 | 127.73 | 418795.0 |
| 2016-05-06 | FGBS | Futures | 111.673 | 111.693 | 111.663 | 111.683 | 141867.0 |
| 2016-05-06 | FGBX | Futures | 173.93 | 174.26 | 172.61 | 173.64 | 31322.0 |
| 2016-05-06 | FMWO | Futures | 5560.6 | 5561.9 | 5537.0 | 5560.6 | 528.0 |
| 2016-05-06 | FOAT | Futures | 133.63 | 133.67 | 133.31 | 133.64 | 80734.0 |
| 2016-05-06 | FTDX | Futures | 1521.4 | 1531.4 | 1521.4 | 1525.7 | 114.0 |
| 2016-05-06 | FTI | Futures | 386.01 | 389.49 | 382.17 | 387.32 | 28927.0 |
| 2016-05-06 | FTUK | Futures | 5017.6 | 5050.6 | 4963.6 | 5023.8 | 108469.0 |
| 2016-05-06 | FVSA | Futures | 2765.11 | 2833.32 | 2665.42 | 2712.64 | 10753.0 |
| 2016-05-06 | FXXP | Futures | 263.9 | 265.9 | 261.4 | 264.0 | 28005.0 |
| 2016-05-06 | G | Futures | 108.44 | 108.8 | 108.42 | 108.72 | 184237.0 |
| 2016-05-06 | GF | Futures | 295.529 | 297.127 | 293.532 | 294.381 | 2654.0 |
| 2016-05-06 | GSCI | Futures | 506.96 | 516.43 | 506.59 | 512.76 | 1551.0 |
| 2016-05-06 | HE | Futures | 100.108 | 100.108 | 98.617 | 98.921 | 20886.0 |
> showing 50 of 108 rows — these rows as CSV