PREVIEW / futures_daily / 2015-11-02
file: by_date/futures_daily/2015/2015-11-02.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-02 | ES | Futures | 2205.16 | 2233.88 | 2195.85 | 2229.09 | 1284044.0 |
| 2015-11-02 | NQ | Futures | 5430.39 | 5494.7 | 5407.59 | 5488.26 | 162655.0 |
| 2015-11-02 | YM | Futures | 18157.2 | 18328.5 | 18084.0 | 18298.6 | 102672.0 |
| 2015-11-02 | CL | Futures | 73.72 | 74.2 | 72.34 | 73.26 | 305518.0 |
| 2015-11-02 | GC | Futures | 1473.3 | 1475.1 | 1461.5 | 1466.3 | 106355.0 |
| 2015-11-02 | ZN | Futures | 122.389367 | 122.449237 | 121.985244 | 122.015179 | 983049.0 |
| 2015-11-02 | A6 | Futures | 0.71153 | 0.71513 | 0.71083 | 0.71203 | 49386.0 |
| 2015-11-02 | AD | Futures | 0.78336 | 0.78377 | 0.7807 | 0.78182 | 36119.0 |
| 2015-11-02 | ALI | Futures | 2047.73 | 2047.73 | 2047.73 | 2047.73 | 0.0 |
| 2015-11-02 | B | Futures | 44.34 | 44.49 | 43.58 | 43.76 | 139147.0 |
| 2015-11-02 | B6 | Futures | 1.6269 | 1.6317 | 1.6218 | 1.6227 | 72084.0 |
| 2015-11-02 | BFX | Futures | 4376.0 | 4409.4 | 4375.4 | 4399.1 | 27.0 |
| 2015-11-02 | BR | Futures | 0.15884 | 0.15949 | 0.15811 | 0.15866 | 101.0 |
| 2015-11-02 | BZ | Futures | 44.04 | 44.17 | 43.31 | 43.48 | 11208.0 |
| 2015-11-02 | C | Futures | 2354.0 | 2369.0 | 2334.0 | 2365.0 | 5564.0 |
| 2015-11-02 | CB | Futures | 208.632 | 208.755 | 208.632 | 208.755 | 29.0 |
| 2015-11-02 | CC | Futures | 2385.0 | 2419.0 | 2379.0 | 2416.0 | 22096.0 |
| 2015-11-02 | CNH | Futures | 7.0574 | 7.075 | 7.0515 | 7.0696 | 172.0 |
| 2015-11-02 | CSC | Futures | 4.232 | 4.24 | 4.222 | 4.222 | 40.0 |
| 2015-11-02 | CT | Futures | 75.98 | 76.1 | 74.54 | 75.92 | 16428.0 |
| 2015-11-02 | DC | Futures | 34.23 | 34.23 | 33.83 | 33.88 | 229.0 |
| 2015-11-02 | DX | Futures | 90.547 | 90.758 | 90.449 | 90.723 | 16587.0 |
| 2015-11-02 | E1 | Futures | 1.28772 | 1.29115 | 1.28391 | 1.28683 | 13588.0 |
| 2015-11-02 | E6 | Futures | 1.29291 | 1.29549 | 1.28928 | 1.29057 | 141480.0 |
| 2015-11-02 | E7 | Futures | 1.2857 | 1.2882 | 1.2822 | 1.2834 | 3168.0 |
| 2015-11-02 | EBM | Futures | 264.53 | 265.26 | 261.97 | 262.71 | 14022.0 |
| 2015-11-02 | ED | Futures | 95.7208 | 95.7256 | 95.7111 | 95.7159 | 139135.0 |
| 2015-11-02 | ER | Futures | 98.2 | 98.2 | 98.18 | 98.195 | 114647.0 |
| 2015-11-02 | EW | Futures | 1517.8 | 1544.5 | 1511.3 | 1542.3 | 13122.0 |
| 2015-11-02 | FBON | Futures | 115.33 | 115.33 | 114.86 | 114.98 | 1613.0 |
| 2015-11-02 | FBTP | Futures | 104.44 | 104.75 | 103.88 | 104.02 | 115971.0 |
| 2015-11-02 | FBTS | Futures | 100.588 | 100.588 | 100.499 | 100.516 | 19502.0 |
| 2015-11-02 | FCE | Futures | 4049.1 | 4118.8 | 4033.3 | 4099.2 | 75944.0 |
| 2015-11-02 | FDAX | Futures | 11851.8 | 12109.5 | 11814.9 | 12066.6 | 82194.0 |
| 2015-11-02 | FDXM | Futures | 11072.0 | 11312.8 | 11039.1 | 11272.7 | 6765.0 |
| 2015-11-02 | FESX | Futures | 2536.9 | 2581.9 | 2527.9 | 2572.9 | 843992.0 |
| 2015-11-02 | FGBL | Futures | 140.09 | 140.09 | 139.26 | 139.42 | 600090.0 |
| 2015-11-02 | FGBM | Futures | 125.69 | 125.7 | 125.43 | 125.49 | 442898.0 |
| 2015-11-02 | FGBS | Futures | 111.453 | 111.453 | 111.383 | 111.393 | 311250.0 |
| 2015-11-02 | FGBX | Futures | 161.18 | 161.18 | 158.83 | 159.1 | 28072.0 |
| 2015-11-02 | FMWO | Futures | 5671.9 | 5718.8 | 5671.9 | 5718.8 | 1042.0 |
| 2015-11-02 | FOAT | Futures | 128.56 | 128.64 | 127.69 | 127.76 | 84194.0 |
| 2015-11-02 | FTDX | Futures | 1689.4 | 1735.4 | 1689.4 | 1728.7 | 202.0 |
| 2015-11-02 | FTI | Futures | 399.01 | 406.38 | 397.53 | 404.03 | 29669.0 |
| 2015-11-02 | FTUK | Futures | 5065.0 | 5130.9 | 5058.2 | 5097.2 | 75513.0 |
| 2015-11-02 | FVSA | Futures | 2099.97 | 2104.57 | 1971.31 | 2031.05 | 9236.0 |
| 2015-11-02 | FXXP | Futures | 289.5 | 294.0 | 289.5 | 293.5 | 12098.0 |
| 2015-11-02 | G | Futures | 104.11 | 104.13 | 103.79 | 103.87 | 158119.0 |
| 2015-11-02 | GF | Futures | 344.206 | 348.001 | 342.761 | 347.413 | 2554.0 |
| 2015-11-02 | GSCI | Futures | 581.53 | 585.81 | 581.53 | 582.42 | 113.0 |
> showing 50 of 108 rows — these rows as CSV