PREVIEW / futures_daily / 2015-02-17
file: by_date/futures_daily/2015/2015-02-17.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-17 | ES | Futures | 2191.9 | 2199.76 | 2180.89 | 2196.88 | 1234818.0 |
| 2015-02-17 | NQ | Futures | 5074.53 | 5091.94 | 5064.09 | 5084.11 | 194620.0 |
| 2015-02-17 | YM | Futures | 18304.1 | 18357.0 | 18221.6 | 18333.6 | 125742.0 |
| 2015-02-17 | CL | Futures | 98.99 | 101.62 | 95.55 | 100.45 | 278386.0 |
| 2015-02-17 | GC | Futures | 1605.0 | 1617.0 | 1573.3 | 1580.2 | 181844.0 |
| 2015-02-17 | ZN | Futures | 120.644434 | 121.012477 | 119.790575 | 119.893627 | 1652053.0 |
| 2015-02-17 | A6 | Futures | 0.75928 | 0.76574 | 0.75712 | 0.76496 | 105695.0 |
| 2015-02-17 | AD | Futures | 0.81748 | 0.8237 | 0.81555 | 0.82217 | 63479.0 |
| 2015-02-17 | ALI | Futures | 2746.83 | 2746.83 | 2746.83 | 2746.83 | 10.0 |
| 2015-02-17 | B | Futures | 61.06 | 62.37 | 59.67 | 61.9 | 277965.0 |
| 2015-02-17 | B6 | Futures | 1.62 | 1.6232 | 1.6101 | 1.6152 | 109037.0 |
| 2015-02-17 | BFX | Futures | 4276.8 | 4313.6 | 4275.0 | 4313.6 | 827.0 |
| 2015-02-17 | BR | Futures | 0.19522 | 0.19525 | 0.19321 | 0.19428 | 527.0 |
| 2015-02-17 | BZ | Futures | 61.01 | 62.24 | 59.53 | 61.75 | 40754.0 |
| 2015-02-17 | C | Futures | 2186.0 | 2213.0 | 2186.0 | 2209.0 | 3944.0 |
| 2015-02-17 | CB | Futures | 144.585 | 148.446 | 144.585 | 148.446 | 8.0 |
| 2015-02-17 | CC | Futures | 2167.0 | 2173.0 | 2154.0 | 2172.0 | 14661.0 |
| 2015-02-17 | CNH | Futures | 7.1173 | 7.155 | 7.1172 | 7.1451 | 68.0 |
| 2015-02-17 | CSC | Futures | 4.484 | 4.634 | 4.469 | 4.6 | 160.0 |
| 2015-02-17 | CT | Futures | 79.96 | 81.74 | 79.58 | 81.48 | 13944.0 |
| 2015-02-17 | DC | Futures | 36.44 | 38.03 | 36.44 | 37.7 | 812.0 |
| 2015-02-17 | DX | Futures | 89.465 | 89.489 | 88.822 | 89.117 | 25847.0 |
| 2015-02-17 | E1 | Futures | 1.37141 | 1.37703 | 1.36337 | 1.36464 | 16574.0 |
| 2015-02-17 | E6 | Futures | 1.34116 | 1.34705 | 1.33211 | 1.34293 | 138359.0 |
| 2015-02-17 | E7 | Futures | 1.333 | 1.339 | 1.3243 | 1.3349 | 4566.0 |
| 2015-02-17 | EBM | Futures | 307.79 | 309.41 | 302.92 | 304.95 | 15333.0 |
| 2015-02-17 | ED | Futures | 95.4474 | 95.4498 | 95.4402 | 95.445 | 187713.0 |
| 2015-02-17 | ER | Futures | 98.038 | 98.043 | 98.028 | 98.038 | 47473.0 |
| 2015-02-17 | EW | Futures | 1568.7 | 1573.9 | 1562.3 | 1568.3 | 17065.0 |
| 2015-02-17 | FBTP | Futures | 100.14 | 100.94 | 100.14 | 100.57 | 80449.0 |
| 2015-02-17 | FBTS | Futures | 99.085 | 99.271 | 99.085 | 99.209 | 22786.0 |
| 2015-02-17 | FCE | Futures | 3845.2 | 3894.3 | 3809.0 | 3866.7 | 121951.0 |
| 2015-02-17 | FDAX | Futures | 12033.9 | 12155.5 | 11951.8 | 12076.6 | 102887.0 |
| 2015-02-17 | FESX | Futures | 2448.3 | 2500.2 | 2436.8 | 2476.4 | 1071008.0 |
| 2015-02-17 | FGBL | Futures | 139.53 | 139.53 | 138.59 | 138.87 | 577446.0 |
| 2015-02-17 | FGBM | Futures | 124.68 | 124.68 | 124.44 | 124.51 | 327678.0 |
| 2015-02-17 | FGBS | Futures | 111.238 | 111.238 | 111.173 | 111.193 | 225864.0 |
| 2015-02-17 | FGBX | Futures | 169.71 | 169.71 | 165.92 | 167.38 | 21937.0 |
| 2015-02-17 | FMWO | Futures | 5758.4 | 5777.0 | 5758.4 | 5775.7 | 140.0 |
| 2015-02-17 | FOAT | Futures | 127.77 | 127.77 | 127.14 | 127.25 | 46790.0 |
| 2015-02-17 | FTDX | Futures | 1419.0 | 1429.4 | 1415.3 | 1425.6 | 252.0 |
| 2015-02-17 | FTI | Futures | 397.37 | 402.21 | 395.17 | 400.22 | 19982.0 |
| 2015-02-17 | FTUK | Futures | 5296.8 | 5356.0 | 5279.6 | 5339.3 | 97939.0 |
| 2015-02-17 | FVSA | Futures | 2108.26 | 2157.49 | 2059.02 | 2085.87 | 9615.0 |
| 2015-02-17 | FXXP | Futures | 282.4 | 285.3 | 282.0 | 284.3 | 6932.0 |
| 2015-02-17 | G | Futures | 104.06 | 104.06 | 102.92 | 103.18 | 151408.0 |
| 2015-02-17 | GF | Futures | 345.238 | 345.491 | 338.785 | 339.84 | 4124.0 |
| 2015-02-17 | GSCI | Futures | 724.04 | 737.27 | 719.92 | 733.92 | 323.0 |
| 2015-02-17 | HE | Futures | 89.247 | 89.281 | 85.524 | 85.86 | 17571.0 |
| 2015-02-17 | HG | Futures | 3.3091 | 3.332 | 3.2411 | 3.2786 | 30042.0 |
> showing 50 of 106 rows — these rows as CSV