PREVIEW / futures_daily / 2015-07-17
file: by_date/futures_daily/2015/2015-07-17.parquet size: 9 KB rows: 105
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-07-17 | ES | Futures | 2243.63 | 2246.81 | 2239.13 | 2245.49 | 903686.0 |
| 2015-07-17 | NQ | Futures | 5381.97 | 5433.63 | 5379.05 | 5428.96 | 187930.0 |
| 2015-07-17 | YM | Futures | 18491.5 | 18511.0 | 18437.1 | 18483.3 | 73288.0 |
| 2015-07-17 | CL | Futures | 85.04 | 85.59 | 83.85 | 85.03 | 188364.0 |
| 2015-07-17 | GC | Futures | 1494.4 | 1494.7 | 1475.2 | 1478.3 | 161004.0 |
| 2015-07-17 | ZN | Futures | 120.317687 | 120.481627 | 120.079227 | 120.302783 | 758364.0 |
| 2015-07-17 | A6 | Futures | 0.73128 | 0.73247 | 0.72742 | 0.72851 | 46863.0 |
| 2015-07-17 | AD | Futures | 0.78845 | 0.78917 | 0.78569 | 0.78682 | 46634.0 |
| 2015-07-17 | ALI | Futures | 2292.44 | 2292.44 | 2292.44 | 2292.44 | 0.0 |
| 2015-07-17 | B | Futures | 52.98 | 53.37 | 52.48 | 53.13 | 157126.0 |
| 2015-07-17 | B6 | Futures | 1.642 | 1.6491 | 1.6364 | 1.6426 | 63023.0 |
| 2015-07-17 | BFX | Futures | 4644.1 | 4653.1 | 4630.2 | 4635.0 | 10.0 |
| 2015-07-17 | BR | Futures | 0.18644 | 0.18665 | 0.18426 | 0.18491 | 1751.0 |
| 2015-07-17 | BZ | Futures | 53.14 | 53.34 | 52.44 | 53.1 | 18931.0 |
| 2015-07-17 | C | Futures | 2372.0 | 2385.0 | 2360.0 | 2376.0 | 9415.0 |
| 2015-07-17 | CB | Futures | 151.963 | 153.989 | 151.963 | 152.774 | 27.0 |
| 2015-07-17 | CC | Futures | 2454.0 | 2470.0 | 2447.0 | 2460.0 | 9735.0 |
| 2015-07-17 | CSC | Futures | 4.28 | 4.283 | 4.277 | 4.283 | 16.0 |
| 2015-07-17 | CT | Futures | 79.91 | 80.66 | 79.91 | 80.61 | 33.0 |
| 2015-07-17 | DC | Futures | 34.33 | 34.53 | 34.31 | 34.42 | 145.0 |
| 2015-07-17 | DX | Futures | 91.507 | 91.83 | 91.306 | 91.726 | 27096.0 |
| 2015-07-17 | E1 | Futures | 1.32859 | 1.331 | 1.32199 | 1.32402 | 10745.0 |
| 2015-07-17 | E6 | Futures | 1.27863 | 1.28239 | 1.273 | 1.27546 | 148275.0 |
| 2015-07-17 | E7 | Futures | 1.2716 | 1.2752 | 1.264 | 1.2684 | 2996.0 |
| 2015-07-17 | EBM | Futures | 317.66 | 318.89 | 314.79 | 316.02 | 14041.0 |
| 2015-07-17 | ED | Futures | 95.6414 | 95.6462 | 95.627 | 95.6366 | 131199.0 |
| 2015-07-17 | ER | Futures | 98.107 | 98.112 | 98.107 | 98.107 | 20189.0 |
| 2015-07-17 | EW | Futures | 1588.4 | 1589.1 | 1573.5 | 1575.0 | 13847.0 |
| 2015-07-17 | FBTP | Futures | 99.57 | 100.25 | 99.54 | 100.09 | 54667.0 |
| 2015-07-17 | FBTS | Futures | 99.866 | 99.964 | 99.866 | 99.946 | 14960.0 |
| 2015-07-17 | FCE | Futures | 4269.2 | 4290.0 | 4261.3 | 4275.0 | 72505.0 |
| 2015-07-17 | FDAX | Futures | 12975.9 | 13008.5 | 12879.7 | 12906.8 | 70033.0 |
| 2015-07-17 | FESX | Futures | 2723.5 | 2733.8 | 2708.7 | 2717.5 | 998906.0 |
| 2015-07-17 | FGBL | Futures | 135.81 | 136.4 | 135.81 | 136.19 | 423860.0 |
| 2015-07-17 | FGBM | Futures | 124.14 | 124.33 | 124.12 | 124.25 | 338711.0 |
| 2015-07-17 | FGBS | Futures | 111.193 | 111.208 | 111.188 | 111.198 | 114097.0 |
| 2015-07-17 | FGBX | Futures | 152.09 | 153.59 | 152.07 | 153.23 | 24453.0 |
| 2015-07-17 | FMWO | Futures | 5891.3 | 5892.6 | 5887.7 | 5887.7 | 46.0 |
| 2015-07-17 | FOAT | Futures | 124.24 | 124.81 | 124.21 | 124.64 | 68134.0 |
| 2015-07-17 | FTDX | Futures | 1706.4 | 1706.9 | 1689.4 | 1695.1 | 296.0 |
| 2015-07-17 | FTI | Futures | 430.05 | 431.39 | 429.02 | 429.71 | 27629.0 |
| 2015-07-17 | FTUK | Futures | 5354.9 | 5368.4 | 5335.0 | 5342.9 | 59799.0 |
| 2015-07-17 | FVSA | Futures | 1754.54 | 1794.01 | 1736.99 | 1780.86 | 10649.0 |
| 2015-07-17 | FXXP | Futures | 311.6 | 312.2 | 310.6 | 311.4 | 5624.0 |
| 2015-07-17 | G | Futures | 101.1 | 101.28 | 100.85 | 101.03 | 105219.0 |
| 2015-07-17 | GF | Futures | 364.564 | 368.602 | 362.736 | 365.881 | 4912.0 |
| 2015-07-17 | GSCI | Futures | 671.65 | 676.15 | 669.65 | 674.24 | 217.0 |
| 2015-07-17 | HE | Futures | 85.034 | 85.146 | 84.168 | 84.531 | 11275.0 |
| 2015-07-17 | HG | Futures | 3.1412 | 3.1618 | 3.09 | 3.115 | 38740.0 |
| 2015-07-17 | HH | Futures | 34.646 | 35.009 | 34.199 | 34.731 | 2428.0 |
> showing 50 of 105 rows — these rows as CSV