PREVIEW / futures_daily / 2015-06-16
file: by_date/futures_daily/2015/2015-06-16.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-06-16 | ES | Futures | 2199.39 | 2215.02 | 2185.34 | 2213.96 | 1657466.0 |
| 2015-06-16 | NQ | Futures | 5169.48 | 5203.05 | 5132.12 | 5197.5 | 219413.0 |
| 2015-06-16 | YM | Futures | 18187.5 | 18320.0 | 18078.7 | 18307.7 | 119889.0 |
| 2015-06-16 | CL | Futures | 100.23 | 101.57 | 100.01 | 100.96 | 129301.0 |
| 2015-06-16 | GC | Futures | 1548.0 | 1550.7 | 1535.1 | 1542.2 | 100203.0 |
| 2015-06-16 | ZN | Futures | 119.81096 | 120.168649 | 119.781153 | 120.094131 | 917900.0 |
| 2015-06-16 | A6 | Futures | 0.76506 | 0.76704 | 0.76119 | 0.76337 | 54457.0 |
| 2015-06-16 | AD | Futures | 0.82854 | 0.83119 | 0.8269 | 0.82905 | 41316.0 |
| 2015-06-16 | ALI | Futures | 2350.56 | 2350.56 | 2350.56 | 2350.56 | 10.0 |
| 2015-06-16 | B | Futures | 60.02 | 60.6 | 59.67 | 59.93 | 279742.0 |
| 2015-06-16 | B6 | Futures | 1.6408 | 1.6466 | 1.6347 | 1.6459 | 74964.0 |
| 2015-06-16 | BFX | Futures | 4299.3 | 4344.1 | 4286.6 | 4344.1 | 47.0 |
| 2015-06-16 | BR | Futures | 0.18653 | 0.18899 | 0.18653 | 0.18899 | 79.0 |
| 2015-06-16 | BZ | Futures | 60.23 | 60.71 | 59.79 | 60.05 | 22148.0 |
| 2015-06-16 | C | Futures | 2302.0 | 2322.0 | 2302.0 | 2320.0 | 5154.0 |
| 2015-06-16 | CB | Futures | 160.473 | 160.473 | 158.852 | 159.258 | 54.0 |
| 2015-06-16 | CC | Futures | 2361.0 | 2383.0 | 2357.0 | 2379.0 | 14083.0 |
| 2015-06-16 | CNH | Futures | 7.0166 | 7.0166 | 7.0158 | 7.0158 | 1.0 |
| 2015-06-16 | CSC | Futures | 4.619 | 4.627 | 4.617 | 4.617 | 38.0 |
| 2015-06-16 | CT | Futures | 79.75 | 81.89 | 79.02 | 81.16 | 12311.0 |
| 2015-06-16 | DC | Futures | 37.19 | 37.38 | 37.17 | 37.36 | 37.0 |
| 2015-06-16 | DX | Futures | 89.041 | 89.396 | 88.751 | 89.174 | 35494.0 |
| 2015-06-16 | E1 | Futures | 1.36986 | 1.37418 | 1.36414 | 1.36656 | 11746.0 |
| 2015-06-16 | E6 | Futures | 1.32715 | 1.33267 | 1.31787 | 1.3221 | 189470.0 |
| 2015-06-16 | E7 | Futures | 1.3196 | 1.3252 | 1.3107 | 1.3148 | 5282.0 |
| 2015-06-16 | EBM | Futures | 291.02 | 291.84 | 289.38 | 289.79 | 6634.0 |
| 2015-06-16 | ED | Futures | 95.5599 | 95.5743 | 95.5599 | 95.5695 | 153275.0 |
| 2015-06-16 | ER | Futures | 98.043 | 98.058 | 98.038 | 98.048 | 125606.0 |
| 2015-06-16 | EW | Futures | 1589.1 | 1604.8 | 1578.9 | 1603.8 | 33043.0 |
| 2015-06-16 | FBTP | Futures | 95.42 | 96.25 | 94.46 | 96.06 | 155368.0 |
| 2015-06-16 | FBTS | Futures | 99.011 | 99.172 | 98.824 | 99.145 | 40111.0 |
| 2015-06-16 | FCE | Futures | 4009.1 | 4041.2 | 3948.7 | 4024.9 | 123594.0 |
| 2015-06-16 | FDAX | Futures | 12201.8 | 12288.9 | 11980.0 | 12260.6 | 176616.0 |
| 2015-06-16 | FESX | Futures | 2539.2 | 2561.4 | 2500.0 | 2552.5 | 1468127.0 |
| 2015-06-16 | FGBL | Futures | 135.11 | 135.8 | 134.97 | 135.1 | 787121.0 |
| 2015-06-16 | FGBM | Futures | 123.63 | 123.85 | 123.59 | 123.67 | 537758.0 |
| 2015-06-16 | FGBS | Futures | 111.138 | 111.153 | 111.128 | 111.148 | 244259.0 |
| 2015-06-16 | FGBX | Futures | 152.72 | 154.53 | 152.19 | 152.4 | 29773.0 |
| 2015-06-16 | FMWO | Futures | 5790.3 | 5836.0 | 5783.0 | 5832.3 | 3447.0 |
| 2015-06-16 | FOAT | Futures | 122.39 | 123.05 | 121.87 | 122.79 | 136962.0 |
| 2015-06-16 | FTDX | Futures | 1518.9 | 1546.3 | 1510.0 | 1543.0 | 931.0 |
| 2015-06-16 | FTI | Futures | 412.41 | 416.03 | 407.3 | 414.81 | 22587.0 |
| 2015-06-16 | FTUK | Futures | 5298.8 | 5305.2 | 5249.5 | 5294.4 | 155107.0 |
| 2015-06-16 | FVSA | Futures | 1923.75 | 1976.07 | 1879.48 | 1903.63 | 22696.0 |
| 2015-06-16 | FXXP | Futures | 292.3 | 295.8 | 290.5 | 295.3 | 76190.0 |
| 2015-06-16 | G | Futures | 101.44 | 101.91 | 101.25 | 101.55 | 162279.0 |
| 2015-06-16 | GF | Futures | 381.268 | 382.671 | 380.121 | 382.288 | 2794.0 |
| 2015-06-16 | GSCI | Futures | 724.65 | 727.57 | 723.15 | 726.82 | 21.0 |
| 2015-06-16 | HE | Futures | 83.754 | 84.624 | 83.564 | 83.917 | 12757.0 |
| 2015-06-16 | HG | Futures | 3.3168 | 3.3319 | 3.2754 | 3.2817 | 43312.0 |
> showing 50 of 105 rows — these rows as CSV