PREVIEW / futures_daily / 2015-08-10
file: by_date/futures_daily/2015/2015-08-10.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-08-10 | ES | Futures | 2195.94 | 2226.94 | 2195.68 | 2225.35 | 1198912.0 |
| 2015-08-10 | NQ | Futures | 5270.18 | 5347.24 | 5268.72 | 5330.89 | 199353.0 |
| 2015-08-10 | YM | Futures | 17777.7 | 18047.8 | 17767.5 | 18027.3 | 128190.0 |
| 2015-08-10 | CL | Futures | 72.36 | 74.73 | 71.98 | 74.65 | 491433.0 |
| 2015-08-10 | GC | Futures | 1412.2 | 1430.9 | 1405.8 | 1425.3 | 148926.0 |
| 2015-08-10 | ZN | Futures | 121.61431 | 121.629213 | 121.09268 | 121.152295 | 673537.0 |
| 2015-08-10 | A6 | Futures | 0.73267 | 0.73386 | 0.72692 | 0.73237 | 76959.0 |
| 2015-08-10 | AD | Futures | 0.77854 | 0.78692 | 0.77557 | 0.78641 | 58527.0 |
| 2015-08-10 | ALI | Futures | 2218.72 | 2218.72 | 2218.72 | 2218.72 | 0.0 |
| 2015-08-10 | B | Futures | 45.36 | 47.3 | 45.26 | 47.23 | 182847.0 |
| 2015-08-10 | B6 | Futures | 1.63 | 1.6422 | 1.6266 | 1.6419 | 90497.0 |
| 2015-08-10 | BR | Futures | 0.16958 | 0.17299 | 0.1688 | 0.17158 | 1079.0 |
| 2015-08-10 | BZ | Futures | 45.38 | 47.24 | 45.21 | 47.18 | 17052.0 |
| 2015-08-10 | C | Futures | 2222.0 | 2222.0 | 2195.0 | 2210.0 | 4977.0 |
| 2015-08-10 | CC | Futures | 2272.0 | 2286.0 | 2262.0 | 2280.0 | 24074.0 |
| 2015-08-10 | CNH | Futures | 7.0041 | 7.0041 | 6.9976 | 6.999 | 2.0 |
| 2015-08-10 | CSC | Futures | 4.434 | 4.495 | 4.434 | 4.48 | 65.0 |
| 2015-08-10 | CT | Futures | 76.81 | 77.71 | 76.36 | 77.24 | 32.0 |
| 2015-08-10 | DC | Futures | 35.58 | 35.99 | 35.47 | 35.9 | 171.0 |
| 2015-08-10 | DX | Futures | 91.418 | 91.713 | 90.875 | 90.99 | 34738.0 |
| 2015-08-10 | E1 | Futures | 1.29202 | 1.29672 | 1.28516 | 1.29227 | 15918.0 |
| 2015-08-10 | E6 | Futures | 1.28815 | 1.29778 | 1.28404 | 1.29508 | 166160.0 |
| 2015-08-10 | E7 | Futures | 1.2813 | 1.2905 | 1.2771 | 1.2879 | 3588.0 |
| 2015-08-10 | EBM | Futures | 295.94 | 301.27 | 295.12 | 300.04 | 12516.0 |
| 2015-08-10 | ED | Futures | 95.6031 | 95.6079 | 95.5887 | 95.6031 | 144212.0 |
| 2015-08-10 | ER | Futures | 98.122 | 98.122 | 98.117 | 98.117 | 10149.0 |
| 2015-08-10 | EW | Futures | 1556.0 | 1582.2 | 1556.0 | 1580.1 | 17964.0 |
| 2015-08-10 | FBTP | Futures | 101.29 | 101.29 | 100.85 | 101.08 | 31105.0 |
| 2015-08-10 | FBTS | Futures | 100.159 | 100.168 | 100.124 | 100.133 | 4607.0 |
| 2015-08-10 | FCE | Futures | 4319.6 | 4335.9 | 4280.0 | 4332.1 | 60000.0 |
| 2015-08-10 | FDAX | Futures | 12762.0 | 12847.7 | 12636.0 | 12823.9 | 75788.0 |
| 2015-08-10 | FDIV | Futures | 157.65 | 157.69 | 157.65 | 157.69 | 1.0 |
| 2015-08-10 | FESX | Futures | 2706.4 | 2724.9 | 2681.3 | 2719.8 | 670451.0 |
| 2015-08-10 | FEU3 | Futures | 98.759 | 98.764 | 98.759 | 98.764 | 26.0 |
| 2015-08-10 | FGBL | Futures | 137.78 | 137.8 | 137.27 | 137.34 | 274055.0 |
| 2015-08-10 | FGBM | Futures | 124.84 | 124.84 | 124.74 | 124.76 | 192816.0 |
| 2015-08-10 | FGBS | Futures | 111.283 | 111.303 | 111.273 | 111.293 | 116983.0 |
| 2015-08-10 | FGBX | Futures | 156.8 | 156.8 | 155.38 | 155.66 | 13853.0 |
| 2015-08-10 | FMWO | Futures | 5799.0 | 5845.8 | 5799.0 | 5845.8 | 78.0 |
| 2015-08-10 | FOAT | Futures | 125.96 | 126.01 | 125.57 | 125.61 | 32932.0 |
| 2015-08-10 | FTDX | Futures | 1672.0 | 1680.5 | 1660.2 | 1677.2 | 232.0 |
| 2015-08-10 | FTI | Futures | 427.68 | 430.0 | 422.43 | 429.05 | 39.0 |
| 2015-08-10 | FTUK | Futures | 5330.6 | 5341.7 | 5251.9 | 5314.3 | 96248.0 |
| 2015-08-10 | FVSA | Futures | 1675.58 | 1715.06 | 1631.72 | 1636.11 | 8009.0 |
| 2015-08-10 | FXXP | Futures | 305.9 | 307.0 | 302.6 | 306.5 | 7529.0 |
| 2015-08-10 | G | Futures | 102.93 | 103.07 | 102.37 | 102.43 | 104131.0 |
| 2015-08-10 | GF | Futures | 364.054 | 364.657 | 361.08 | 362.718 | 2160.0 |
| 2015-08-10 | GSCI | Futures | 608.59 | 619.15 | 608.59 | 619.15 | 4186.0 |
| 2015-08-10 | HE | Futures | 88.2 | 88.337 | 85.738 | 86.114 | 14965.0 |
| 2015-08-10 | HG | Futures | 2.8953 | 3.0089 | 2.8797 | 2.9952 | 71154.0 |
> showing 50 of 105 rows — these rows as CSV