PREVIEW / futures_daily / 2014-06-17
file: by_date/futures_daily/2014/2014-06-17.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-06-17 | ES | Futures | 2003.84 | 2010.85 | 1998.38 | 2008.77 | 1817231.0 |
| 2014-06-17 | NQ | Futures | 4352.92 | 4368.21 | 4341.67 | 4352.34 | 263920.0 |
| 2014-06-17 | YM | Futures | 16850.0 | 16910.6 | 16803.6 | 16879.3 | 144366.0 |
| 2014-06-17 | CL | Futures | 193.66 | 194.87 | 192.62 | 193.39 | 203712.0 |
| 2014-06-17 | GC | Futures | 1675.7 | 1678.0 | 1657.5 | 1676.0 | 112826.0 |
| 2014-06-17 | ZN | Futures | 116.083483 | 116.141838 | 115.631228 | 115.645817 | 1108389.0 |
| 2014-06-17 | A6 | Futures | 0.90282 | 0.90291 | 0.89605 | 0.89673 | 66149.0 |
| 2014-06-17 | AD | Futures | 0.93449 | 0.9347 | 0.93185 | 0.93256 | 31664.0 |
| 2014-06-17 | ALI | Futures | 2754.68 | 2754.68 | 2754.68 | 2754.68 | 0.0 |
| 2014-06-17 | B | Futures | 118.24 | 119.11 | 117.39 | 118.74 | 240515.0 |
| 2014-06-17 | B6 | Futures | 1.7838 | 1.7847 | 1.7793 | 1.7812 | 79080.0 |
| 2014-06-17 | BFX | Futures | 3829.3 | 3832.2 | 3804.1 | 3827.6 | 44.0 |
| 2014-06-17 | BR | Futures | 0.22925 | 0.22954 | 0.22807 | 0.22954 | 174.0 |
| 2014-06-17 | BZ | Futures | 119.2 | 120.15 | 118.4 | 119.78 | 10642.0 |
| 2014-06-17 | C | Futures | 2030.0 | 2047.0 | 2030.0 | 2044.0 | 2404.0 |
| 2014-06-17 | CB | Futures | 115.703 | 117.114 | 115.703 | 116.961 | 35.0 |
| 2014-06-17 | CC | Futures | 2282.0 | 2295.0 | 2271.0 | 2284.0 | 7035.0 |
| 2014-06-17 | CNH | Futures | 7.1777 | 7.1809 | 7.1777 | 7.1809 | 5.0 |
| 2014-06-17 | CSC | Futures | 4.573 | 4.625 | 4.571 | 4.62 | 19.0 |
| 2014-06-17 | CT | Futures | 98.7 | 101.76 | 98.66 | 101.41 | 17262.0 |
| 2014-06-17 | DC | Futures | 36.14 | 36.74 | 36.1 | 36.64 | 273.0 |
| 2014-06-17 | DX | Futures | 76.465 | 76.66 | 76.399 | 76.618 | 10822.0 |
| 2014-06-17 | E1 | Futures | 1.42994 | 1.43109 | 1.42455 | 1.42583 | 21735.0 |
| 2014-06-17 | E6 | Futures | 1.60211 | 1.60388 | 1.59775 | 1.59846 | 112626.0 |
| 2014-06-17 | E7 | Futures | 1.5918 | 1.5934 | 1.5875 | 1.588 | 1520.0 |
| 2014-06-17 | ED | Futures | 95.4019 | 95.4067 | 95.3971 | 95.4067 | 125863.0 |
| 2014-06-17 | ER | Futures | 97.93 | 97.93 | 97.911 | 97.916 | 44368.0 |
| 2014-06-17 | EW | Futures | 1453.3 | 1472.2 | 1449.3 | 1463.1 | 33869.0 |
| 2014-06-17 | FBTP | Futures | 91.11 | 91.11 | 90.64 | 90.74 | 53403.0 |
| 2014-06-17 | FBTS | Futures | 98.019 | 98.028 | 97.894 | 97.921 | 15033.0 |
| 2014-06-17 | FCE | Futures | 3606.8 | 3621.9 | 3594.0 | 3616.0 | 114607.0 |
| 2014-06-17 | FDAX | Futures | 10933.8 | 11004.3 | 10868.3 | 10934.9 | 71252.0 |
| 2014-06-17 | FESX | Futures | 2349.7 | 2358.4 | 2336.1 | 2350.5 | 1188069.0 |
| 2014-06-17 | FGBL | Futures | 126.66 | 126.71 | 126.1 | 126.13 | 562286.0 |
| 2014-06-17 | FGBM | Futures | 121.16 | 121.18 | 120.89 | 120.91 | 411396.0 |
| 2014-06-17 | FGBS | Futures | 110.753 | 110.763 | 110.708 | 110.718 | 241616.0 |
| 2014-06-17 | FGBX | Futures | 130.3 | 130.36 | 129.31 | 129.47 | 19003.0 |
| 2014-06-17 | FMWO | Futures | 5758.8 | 5758.8 | 5743.7 | 5743.7 | 1488.0 |
| 2014-06-17 | FOAT | Futures | 116.21 | 116.26 | 115.74 | 115.79 | 59190.0 |
| 2014-06-17 | FTDX | Futures | 1226.7 | 1231.9 | 1224.4 | 1228.6 | 1189.0 |
| 2014-06-17 | FTI | Futures | 357.88 | 359.09 | 356.97 | 358.44 | 32612.0 |
| 2014-06-17 | FTUK | Futures | 5176.5 | 5182.3 | 5143.1 | 5165.8 | 213120.0 |
| 2014-06-17 | FVSA | Futures | 1405.4 | 1422.59 | 1375.32 | 1375.32 | 15522.0 |
| 2014-06-17 | FXXP | Futures | 260.1 | 260.7 | 259.0 | 260.1 | 26052.0 |
| 2014-06-17 | G | Futures | 93.01 | 93.18 | 92.76 | 92.86 | 121217.0 |
| 2014-06-17 | GF | Futures | 319.968 | 322.305 | 316.902 | 318.55 | 4533.0 |
| 2014-06-17 | GSCI | Futures | 1100.91 | 1106.66 | 1100.5 | 1102.83 | 100.0 |
| 2014-06-17 | HE | Futures | 131.523 | 132.259 | 130.471 | 131.444 | 14348.0 |
| 2014-06-17 | HG | Futures | 3.8947 | 3.9183 | 3.8864 | 3.9113 | 30933.0 |
| 2014-06-17 | HH | Futures | 59.287 | 59.959 | 59.287 | 59.693 | 4257.0 |
> showing 50 of 104 rows — these rows as CSV