PREVIEW / futures_daily / 2014-03-24
file: by_date/futures_daily/2014/2014-03-24.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-24 | ES | Futures | 1919.77 | 1930.63 | 1905.03 | 1913.56 | 1835881.0 |
| 2014-03-24 | NQ | Futures | 4190.31 | 4209.59 | 4115.78 | 4156.64 | 400180.0 |
| 2014-03-24 | YM | Futures | 16280.5 | 16369.8 | 16200.1 | 16268.4 | 183020.0 |
| 2014-03-24 | CL | Futures | 177.55 | 178.97 | 176.76 | 177.74 | 151710.0 |
| 2014-03-24 | GC | Futures | 1759.8 | 1760.7 | 1724.9 | 1728.4 | 178475.0 |
| 2014-03-24 | ZN | Futures | 114.475638 | 114.533586 | 114.113465 | 114.432178 | 1183796.0 |
| 2014-03-24 | A6 | Futures | 0.86897 | 0.87406 | 0.86426 | 0.87195 | 83708.0 |
| 2014-03-24 | AD | Futures | 0.90163 | 0.90487 | 0.89991 | 0.90406 | 43960.0 |
| 2014-03-24 | B | Futures | 110.09 | 110.59 | 109.51 | 109.88 | 142787.0 |
| 2014-03-24 | B6 | Futures | 1.7306 | 1.737 | 1.7295 | 1.7325 | 68147.0 |
| 2014-03-24 | BFX | Futures | 3715.8 | 3715.8 | 3693.8 | 3693.8 | 101.0 |
| 2014-03-24 | BR | Futures | 0.22351 | 0.22351 | 0.22196 | 0.22272 | 4680.0 |
| 2014-03-24 | BZ | Futures | 112.03 | 112.8 | 111.71 | 112.09 | 5090.0 |
| 2014-03-24 | C | Futures | 1972.0 | 1985.0 | 1958.0 | 1964.0 | 6836.0 |
| 2014-03-24 | CB | Futures | 94.938 | 94.938 | 94.938 | 94.938 | 21.0 |
| 2014-03-24 | CC | Futures | 2201.0 | 2217.0 | 2175.0 | 2183.0 | 19079.0 |
| 2014-03-24 | CNH | Futures | 7.1195 | 7.1195 | 7.0993 | 7.0993 | 40.0 |
| 2014-03-24 | CSC | Futures | 4.529 | 4.542 | 4.522 | 4.529 | 57.0 |
| 2014-03-24 | CT | Futures | 104.88 | 105.37 | 100.98 | 101.86 | 23630.0 |
| 2014-03-24 | DC | Futures | 36.26 | 36.38 | 35.96 | 36.12 | 348.0 |
| 2014-03-24 | DX | Futures | 76.259 | 76.43 | 75.907 | 76.077 | 18275.0 |
| 2014-03-24 | E1 | Futures | 1.45624 | 1.46151 | 1.44842 | 1.45778 | 35531.0 |
| 2014-03-24 | E6 | Futures | 1.62891 | 1.638 | 1.62419 | 1.63351 | 192093.0 |
| 2014-03-24 | E7 | Futures | 1.6176 | 1.6271 | 1.6134 | 1.6226 | 4362.0 |
| 2014-03-24 | EBM | Futures | 299.8 | 301.56 | 297.69 | 301.21 | 13944.0 |
| 2014-03-24 | ED | Futures | 95.3804 | 95.3851 | 95.3804 | 95.3851 | 70529.0 |
| 2014-03-24 | ER | Futures | 97.798 | 97.813 | 97.788 | 97.813 | 115247.0 |
| 2014-03-24 | EW | Futures | 1418.8 | 1429.9 | 1400.6 | 1407.9 | 22960.0 |
| 2014-03-24 | FBTP | Futures | 86.47 | 86.5 | 86.24 | 86.38 | 32148.0 |
| 2014-03-24 | FBTS | Futures | 97.038 | 97.038 | 96.976 | 96.985 | 7530.0 |
| 2014-03-24 | FCE | Futures | 3349.7 | 3368.0 | 3315.1 | 3322.9 | 125128.0 |
| 2014-03-24 | FDAX | Futures | 10310.4 | 10360.1 | 10156.9 | 10164.6 | 130574.0 |
| 2014-03-24 | FESX | Futures | 2163.0 | 2178.8 | 2139.3 | 2142.9 | 1063778.0 |
| 2014-03-24 | FGBL | Futures | 122.86 | 123.56 | 122.73 | 123.43 | 731421.0 |
| 2014-03-24 | FGBM | Futures | 119.24 | 119.58 | 119.17 | 119.5 | 467454.0 |
| 2014-03-24 | FGBS | Futures | 110.418 | 110.473 | 110.403 | 110.458 | 282462.0 |
| 2014-03-24 | FGBX | Futures | 125.42 | 126.62 | 125.34 | 126.4 | 19793.0 |
| 2014-03-24 | FMWO | Futures | 5423.2 | 5423.2 | 5414.4 | 5418.1 | 446.0 |
| 2014-03-24 | FOAT | Futures | 111.81 | 112.35 | 111.81 | 112.26 | 48905.0 |
| 2014-03-24 | FTDX | Futures | 1158.3 | 1158.3 | 1128.7 | 1132.0 | 262.0 |
| 2014-03-24 | FTI | Futures | 333.06 | 334.85 | 330.29 | 331.27 | 30661.0 |
| 2014-03-24 | FTUK | Futures | 4923.5 | 4964.7 | 4914.7 | 4922.0 | 105779.0 |
| 2014-03-24 | FVSA | Futures | 1820.6 | 1925.93 | 1810.57 | 1925.93 | 12074.0 |
| 2014-03-24 | FXXP | Futures | 241.3 | 242.8 | 238.9 | 239.3 | 8709.0 |
| 2014-03-24 | G | Futures | 93.22 | 93.76 | 92.99 | 93.63 | 155750.0 |
| 2014-03-24 | GF | Futures | 280.036 | 282.958 | 279.756 | 282.237 | 1276.0 |
| 2014-03-24 | GSCI | Futures | 1062.07 | 1064.22 | 1059.76 | 1060.33 | 30.0 |
| 2014-03-24 | HE | Futures | 147.067 | 147.067 | 144.296 | 145.579 | 256.0 |
| 2014-03-24 | HG | Futures | 3.7347 | 3.7626 | 3.7018 | 3.7328 | 43416.0 |
| 2014-03-24 | HH | Futures | 56.122 | 56.122 | 55.587 | 55.744 | 19012.0 |
> showing 50 of 104 rows — these rows as CSV