PREVIEW / futures_daily / 2014-03-07
file: by_date/futures_daily/2014/2014-03-07.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 |
|---|---|---|---|---|---|---|---|
| 2014-03-07 | ES | Futures | 1934.14 | 1945.74 | 1926.93 | 1935.95 | 1756169.0 |
| 2014-03-07 | NQ | Futures | 4281.14 | 4300.11 | 4237.17 | 4258.43 | 303234.0 |
| 2014-03-07 | YM | Futures | 16389.1 | 16482.0 | 16363.1 | 16422.0 | 175284.0 |
| 2014-03-07 | CL | Futures | 181.45 | 183.13 | 180.74 | 182.54 | 226145.0 |
| 2014-03-07 | GC | Futures | 1780.5 | 1783.8 | 1748.7 | 1764.0 | 178466.0 |
| 2014-03-07 | ZN | Futures | 115.092308 | 115.14954 | 114.405532 | 114.591534 | 31879.0 |
| 2014-03-07 | A6 | Futures | 0.86511 | 0.87045 | 0.86311 | 0.86359 | 96405.0 |
| 2014-03-07 | AD | Futures | 0.92139 | 0.922 | 0.91197 | 0.91218 | 76843.0 |
| 2014-03-07 | B | Futures | 110.83 | 111.67 | 110.36 | 111.58 | 160055.0 |
| 2014-03-07 | B6 | Futures | 1.7582 | 1.7632 | 1.755 | 1.757 | 98719.0 |
| 2014-03-07 | BR | Futures | 0.22077 | 0.22125 | 0.21953 | 0.21969 | 299.0 |
| 2014-03-07 | BZ | Futures | 113.22 | 113.9 | 112.59 | 113.82 | 6010.0 |
| 2014-03-07 | C | Futures | 1927.0 | 1944.0 | 1924.0 | 1944.0 | 19641.0 |
| 2014-03-07 | CB | Futures | 93.161 | 93.415 | 93.161 | 93.161 | 10.0 |
| 2014-03-07 | CC | Futures | 2198.0 | 2215.0 | 2190.0 | 2213.0 | 9242.0 |
| 2014-03-07 | CNH | Futures | 7.0227 | 7.0363 | 7.0205 | 7.0363 | 45.0 |
| 2014-03-07 | CSC | Futures | 4.392 | 4.397 | 4.354 | 4.354 | 30.0 |
| 2014-03-07 | CT | Futures | 102.95 | 104.92 | 102.07 | 102.58 | 18785.0 |
| 2014-03-07 | DC | Futures | 34.82 | 34.91 | 34.58 | 34.66 | 141.0 |
| 2014-03-07 | DX | Futures | 75.767 | 75.939 | 75.544 | 75.812 | 26136.0 |
| 2014-03-07 | E1 | Futures | 1.45855 | 1.46613 | 1.45624 | 1.4633 | 43239.0 |
| 2014-03-07 | E6 | Futures | 1.63611 | 1.6426 | 1.63517 | 1.63753 | 238924.0 |
| 2014-03-07 | E7 | Futures | 1.6254 | 1.6318 | 1.6246 | 1.6268 | 4930.0 |
| 2014-03-07 | EBM | Futures | 291.7 | 299.8 | 291.7 | 295.93 | 37425.0 |
| 2014-03-07 | ED | Futures | 95.3853 | 95.3853 | 95.3829 | 95.3853 | 72144.0 |
| 2014-03-07 | ER | Futures | 97.842 | 97.842 | 97.822 | 97.822 | 178925.0 |
| 2014-03-07 | EW | Futures | 1418.7 | 1425.7 | 1411.3 | 1419.6 | 16426.0 |
| 2014-03-07 | FBTP | Futures | 86.24 | 86.36 | 86.06 | 86.26 | 35559.0 |
| 2014-03-07 | FBTS | Futures | 96.959 | 97.003 | 96.897 | 97.003 | 7590.0 |
| 2014-03-07 | FCE | Futures | 3423.4 | 3434.6 | 3379.2 | 3382.3 | 159334.0 |
| 2014-03-07 | FDAX | Futures | 10588.8 | 10598.2 | 10364.2 | 10377.5 | 131496.0 |
| 2014-03-07 | FDIV | Futures | 145.36 | 145.36 | 143.5 | 143.5 | 5.0 |
| 2014-03-07 | FESX | Futures | 2215.4 | 2217.5 | 2175.3 | 2178.8 | 1204867.0 |
| 2014-03-07 | FEU3 | Futures | 98.443 | 98.443 | 98.438 | 98.438 | 361.0 |
| 2014-03-07 | FGBL | Futures | 122.74 | 122.94 | 122.37 | 122.75 | 753312.0 |
| 2014-03-07 | FGBM | Futures | 119.33 | 119.39 | 119.08 | 119.32 | 532691.0 |
| 2014-03-07 | FGBS | Futures | 110.503 | 110.513 | 110.423 | 110.478 | 383595.0 |
| 2014-03-07 | FGBX | Futures | 125.2 | 125.63 | 124.67 | 125.34 | 31671.0 |
| 2014-03-07 | FMWO | Futures | 5566.7 | 5566.7 | 5521.4 | 5521.4 | 30.0 |
| 2014-03-07 | FOAT | Futures | 111.33 | 111.49 | 111.11 | 111.39 | 52400.0 |
| 2014-03-07 | FTDX | Futures | 1211.3 | 1212.2 | 1194.8 | 1197.2 | 180.0 |
| 2014-03-07 | FTI | Futures | 342.15 | 342.53 | 338.05 | 338.44 | 32663.0 |
| 2014-03-07 | FTUK | Futures | 5120.6 | 5133.1 | 5059.3 | 5068.8 | 124465.0 |
| 2014-03-07 | FVSA | Futures | 1806.71 | 1941.09 | 1801.73 | 1936.11 | 19262.0 |
| 2014-03-07 | FXXP | Futures | 247.9 | 248.0 | 244.5 | 244.6 | 6677.0 |
| 2014-03-07 | G | Futures | 92.92 | 93.03 | 92.34 | 92.75 | 186044.0 |
| 2014-03-07 | GF | Futures | 276.504 | 278.398 | 275.537 | 277.915 | 1297.0 |
| 2014-03-07 | GSCI | Futures | 1070.1 | 1074.04 | 1068.71 | 1072.24 | 1626.0 |
| 2014-03-07 | HE | Futures | 136.17 | 138.012 | 135.023 | 136.472 | 26995.0 |
| 2014-03-07 | HG | Futures | 4.0769 | 4.0807 | 3.8995 | 3.9064 | 94137.0 |
> showing 50 of 106 rows — these rows as CSV