PREVIEW / futures_daily / 2015-10-27
file: by_date/futures_daily/2015/2015-10-27.parquet size: 9 KB rows: 107
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-10-27 | ES | Futures | 2195.32 | 2196.38 | 2182.02 | 2191.86 | 1243601.0 |
| 2015-10-27 | NQ | Futures | 5401.45 | 5438.87 | 5379.82 | 5416.07 | 217939.0 |
| 2015-10-27 | YM | Futures | 18098.4 | 18112.9 | 18013.8 | 18069.5 | 101071.0 |
| 2015-10-27 | CL | Futures | 69.51 | 69.72 | 67.61 | 68.59 | 370825.0 |
| 2015-10-27 | GC | Futures | 1501.3 | 1508.8 | 1498.1 | 1504.9 | 91661.0 |
| 2015-10-27 | ZN | Futures | 123.197612 | 123.646638 | 123.15271 | 123.496963 | 943946.0 |
| 2015-10-27 | A6 | Futures | 0.72273 | 0.72413 | 0.71623 | 0.71763 | 59240.0 |
| 2015-10-27 | AD | Futures | 0.77803 | 0.77824 | 0.77138 | 0.77168 | 58483.0 |
| 2015-10-27 | ALI | Futures | 2035.8 | 2035.8 | 2035.8 | 2035.8 | 0.0 |
| 2015-10-27 | B | Futures | 42.53 | 42.54 | 41.59 | 41.94 | 89623.0 |
| 2015-10-27 | B6 | Futures | 1.6159 | 1.6171 | 1.609 | 1.6109 | 65696.0 |
| 2015-10-27 | BFX | Futures | 4273.3 | 4275.8 | 4265.4 | 4265.4 | 9.0 |
| 2015-10-27 | BR | Futures | 0.15549 | 0.15638 | 0.15426 | 0.15577 | 721.0 |
| 2015-10-27 | BZ | Futures | 42.04 | 42.2 | 41.32 | 41.68 | 13569.0 |
| 2015-10-27 | C | Futures | 2313.0 | 2340.0 | 2313.0 | 2338.0 | 6092.0 |
| 2015-10-27 | CB | Futures | 197.807 | 200.759 | 197.807 | 200.759 | 4.0 |
| 2015-10-27 | CC | Futures | 2332.0 | 2346.0 | 2319.0 | 2344.0 | 16745.0 |
| 2015-10-27 | CNH | Futures | 7.1153 | 7.121 | 7.1129 | 7.121 | 75.0 |
| 2015-10-27 | CSC | Futures | 4.299 | 4.299 | 4.276 | 4.276 | 33.0 |
| 2015-10-27 | CT | Futures | 74.81 | 75.79 | 74.59 | 74.78 | 11280.0 |
| 2015-10-27 | DC | Futures | 34.66 | 34.7 | 34.41 | 34.54 | 59.0 |
| 2015-10-27 | DX | Futures | 90.613 | 90.776 | 90.365 | 90.713 | 27188.0 |
| 2015-10-27 | E1 | Futures | 1.29241 | 1.29533 | 1.28607 | 1.28772 | 19224.0 |
| 2015-10-27 | E6 | Futures | 1.29561 | 1.29865 | 1.29291 | 1.29444 | 159906.0 |
| 2015-10-27 | E7 | Futures | 1.2885 | 1.2915 | 1.2859 | 1.2873 | 3070.0 |
| 2015-10-27 | EBM | Futures | 264.17 | 264.9 | 261.97 | 262.34 | 19578.0 |
| 2015-10-27 | ED | Futures | 95.74 | 95.7544 | 95.74 | 95.7496 | 186053.0 |
| 2015-10-27 | ER | Futures | 98.2 | 98.21 | 98.195 | 98.205 | 75257.0 |
| 2015-10-27 | EW | Futures | 1512.8 | 1512.9 | 1490.7 | 1499.0 | 17101.0 |
| 2015-10-27 | FBON | Futures | 116.03 | 116.6 | 115.98 | 116.44 | 936.0 |
| 2015-10-27 | FBTP | Futures | 104.58 | 105.08 | 104.51 | 104.96 | 79830.0 |
| 2015-10-27 | FBTS | Futures | 100.534 | 100.615 | 100.534 | 100.588 | 25728.0 |
| 2015-10-27 | FCE | Futures | 4080.0 | 4083.3 | 4042.1 | 4044.6 | 65831.0 |
| 2015-10-27 | FDAX | Futures | 11879.3 | 11905.2 | 11768.7 | 11799.5 | 86932.0 |
| 2015-10-27 | FESX | Futures | 2555.7 | 2557.9 | 2529.4 | 2535.4 | 907944.0 |
| 2015-10-27 | FGBL | Futures | 140.25 | 140.93 | 140.24 | 140.9 | 556810.0 |
| 2015-10-27 | FGBM | Futures | 125.78 | 125.94 | 125.77 | 125.93 | 344693.0 |
| 2015-10-27 | FGBS | Futures | 111.463 | 111.483 | 111.448 | 111.478 | 207915.0 |
| 2015-10-27 | FGBX | Futures | 160.89 | 162.91 | 160.87 | 162.75 | 26605.0 |
| 2015-10-27 | FMWO | Futures | 5665.7 | 5666.9 | 5657.0 | 5657.0 | 153.0 |
| 2015-10-27 | FOAT | Futures | 128.72 | 129.32 | 128.69 | 129.28 | 67325.0 |
| 2015-10-27 | FTDX | Futures | 1704.5 | 1704.5 | 1682.7 | 1685.6 | 133.0 |
| 2015-10-27 | FTI | Futures | 402.5 | 403.02 | 397.79 | 398.4 | 28924.0 |
| 2015-10-27 | FTUK | Futures | 5141.0 | 5141.8 | 5094.3 | 5104.8 | 70472.0 |
| 2015-10-27 | FVSA | Futures | 2067.81 | 2095.38 | 2031.05 | 2072.4 | 11757.0 |
| 2015-10-27 | FXXP | Futures | 291.9 | 292.0 | 289.2 | 289.9 | 13176.0 |
| 2015-10-27 | G | Futures | 105.03 | 105.57 | 104.95 | 105.55 | 201555.0 |
| 2015-10-27 | GF | Futures | 343.393 | 343.664 | 338.244 | 339.237 | 3979.0 |
| 2015-10-27 | GSCI | Futures | 568.69 | 568.69 | 565.62 | 567.32 | 69.0 |
| 2015-10-27 | HE | Futures | 93.627 | 94.188 | 90.972 | 91.608 | 21561.0 |
> showing 50 of 107 rows — these rows as CSV