PREVIEW / futures_daily / 2015-01-12
file: by_date/futures_daily/2015/2015-01-12.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-01-12 | ES | Futures | 2132.42 | 2146.83 | 2112.24 | 2119.84 | 1622204.0 |
| 2015-01-12 | NQ | Futures | 4874.67 | 4905.13 | 4816.37 | 4834.35 | 319438.0 |
| 2015-01-12 | YM | Futures | 17973.1 | 18081.0 | 17814.2 | 17895.6 | 178160.0 |
| 2015-01-12 | CL | Futures | 94.38 | 94.38 | 89.35 | 90.23 | 394946.0 |
| 2015-01-12 | GC | Futures | 1600.8 | 1617.8 | 1593.6 | 1613.6 | 138523.0 |
| 2015-01-12 | ZN | Futures | 121.336354 | 121.674954 | 121.100807 | 121.601345 | 840490.0 |
| 2015-01-12 | A6 | Futures | 0.80159 | 0.80493 | 0.79278 | 0.79601 | 82146.0 |
| 2015-01-12 | AD | Futures | 0.85812 | 0.85935 | 0.84937 | 0.85049 | 50981.0 |
| 2015-01-12 | ALI | Futures | 2804.72 | 2804.72 | 2804.72 | 2804.72 | 0.0 |
| 2015-01-12 | B | Futures | 52.17 | 52.2 | 49.47 | 49.73 | 291126.0 |
| 2015-01-12 | B6 | Futures | 1.5962 | 1.597 | 1.5869 | 1.5953 | 79325.0 |
| 2015-01-12 | BFX | Futures | 3935.2 | 3935.2 | 3926.8 | 3926.8 | 8.0 |
| 2015-01-12 | BR | Futures | 0.20416 | 0.20458 | 0.2037 | 0.20458 | 132.0 |
| 2015-01-12 | BZ | Futures | 52.45 | 52.46 | 49.76 | 50.0 | 33175.0 |
| 2015-01-12 | C | Futures | 2216.0 | 2244.0 | 2212.0 | 2243.0 | 6019.0 |
| 2015-01-12 | CB | Futures | 135.138 | 135.138 | 135.138 | 135.138 | 4.0 |
| 2015-01-12 | CC | Futures | 2178.0 | 2215.0 | 2164.0 | 2209.0 | 8381.0 |
| 2015-01-12 | CNH | Futures | 7.0911 | 7.0932 | 7.085 | 7.085 | 9.0 |
| 2015-01-12 | CSC | Futures | 4.361 | 4.384 | 4.359 | 4.367 | 36.0 |
| 2015-01-12 | CT | Futures | 77.53 | 77.59 | 76.01 | 76.29 | 15911.0 |
| 2015-01-12 | DC | Futures | 34.15 | 34.34 | 33.87 | 34.22 | 139.0 |
| 2015-01-12 | DX | Futures | 87.122 | 87.586 | 86.957 | 87.259 | 32137.0 |
| 2015-01-12 | E1 | Futures | 1.26313 | 1.26338 | 1.25457 | 1.26019 | 31305.0 |
| 2015-01-12 | E6 | Futures | 1.39621 | 1.39715 | 1.38704 | 1.39351 | 288184.0 |
| 2015-01-12 | E7 | Futures | 1.3883 | 1.3887 | 1.3786 | 1.3852 | 4761.0 |
| 2015-01-12 | EBM | Futures | 317.92 | 318.33 | 312.25 | 314.68 | 16857.0 |
| 2015-01-12 | ED | Futures | 95.4498 | 95.4546 | 95.4498 | 95.4498 | 129262.0 |
| 2015-01-12 | ER | Futures | 98.033 | 98.033 | 98.023 | 98.033 | 26939.0 |
| 2015-01-12 | EW | Futures | 1502.2 | 1510.7 | 1487.0 | 1496.0 | 15575.0 |
| 2015-01-12 | FBTP | Futures | 98.67 | 99.36 | 98.66 | 99.28 | 63106.0 |
| 2015-01-12 | FBTS | Futures | 98.703 | 98.792 | 98.677 | 98.774 | 12434.0 |
| 2015-01-12 | FCE | Futures | 3408.8 | 3467.2 | 3397.4 | 3448.0 | 44530.0 |
| 2015-01-12 | FDAX | Futures | 10726.1 | 10905.4 | 10685.6 | 10864.9 | 131412.0 |
| 2015-01-12 | FESX | Futures | 2193.9 | 2228.5 | 2180.9 | 2217.7 | 1122580.0 |
| 2015-01-12 | FEU3 | Futures | 98.645 | 98.65 | 98.645 | 98.65 | 1.0 |
| 2015-01-12 | FGBL | Futures | 137.04 | 137.37 | 136.85 | 137.21 | 484348.0 |
| 2015-01-12 | FGBM | Futures | 123.91 | 123.95 | 123.77 | 123.88 | 363907.0 |
| 2015-01-12 | FGBS | Futures | 111.003 | 111.013 | 110.983 | 111.008 | 238667.0 |
| 2015-01-12 | FGBX | Futures | 159.4 | 160.68 | 159.3 | 160.18 | 24027.0 |
| 2015-01-12 | FMWO | Futures | 5540.7 | 5540.7 | 5485.1 | 5512.3 | 426.0 |
| 2015-01-12 | FOAT | Futures | 126.0 | 126.42 | 125.96 | 126.31 | 49981.0 |
| 2015-01-12 | FTDX | Futures | 1326.6 | 1336.0 | 1322.8 | 1330.8 | 234.0 |
| 2015-01-12 | FTI | Futures | 359.66 | 363.55 | 357.23 | 360.96 | 6592.0 |
| 2015-01-12 | FTUK | Futures | 5036.0 | 5053.2 | 4976.4 | 5013.0 | 83741.0 |
| 2015-01-12 | FVSA | Futures | 2083.29 | 2208.11 | 2057.46 | 2134.94 | 6102.0 |
| 2015-01-12 | FXXP | Futures | 254.5 | 257.1 | 253.3 | 255.8 | 11012.0 |
| 2015-01-12 | G | Futures | 104.3 | 104.8 | 104.27 | 104.64 | 117337.0 |
| 2015-01-12 | GF | Futures | 356.878 | 366.663 | 356.794 | 359.83 | 5289.0 |
| 2015-01-12 | GSCI | Futures | 672.7 | 672.7 | 664.86 | 665.03 | 2559.0 |
| 2015-01-12 | HE | Futures | 105.648 | 105.648 | 102.529 | 102.831 | 29596.0 |
> showing 50 of 106 rows — these rows as CSV