PREVIEW / futures_daily / 2015-07-16
file: by_date/futures_daily/2015/2015-07-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-07-16 | ES | Futures | 2229.86 | 2245.22 | 2228.53 | 2243.63 | 1107382.0 |
| 2015-07-16 | NQ | Futures | 5294.12 | 5385.18 | 5290.03 | 5367.96 | 192220.0 |
| 2015-07-16 | YM | Futures | 18475.1 | 18563.4 | 18463.8 | 18506.9 | 93486.0 |
| 2015-07-16 | CL | Futures | 86.26 | 87.24 | 84.94 | 85.08 | 205857.0 |
| 2015-07-16 | GC | Futures | 1496.9 | 1499.5 | 1489.6 | 1493.9 | 125703.0 |
| 2015-07-16 | ZN | Futures | 120.422013 | 120.481627 | 120.04942 | 120.347494 | 896853.0 |
| 2015-07-16 | A6 | Futures | 0.72861 | 0.73435 | 0.72564 | 0.73098 | 68950.0 |
| 2015-07-16 | AD | Futures | 0.79121 | 0.79193 | 0.78784 | 0.78804 | 53303.0 |
| 2015-07-16 | ALI | Futures | 2293.08 | 2293.08 | 2293.08 | 2293.08 | 0.0 |
| 2015-07-16 | B | Futures | 53.38 | 53.97 | 52.91 | 52.97 | 246843.0 |
| 2015-07-16 | B6 | Futures | 1.6452 | 1.6466 | 1.637 | 1.6418 | 60917.0 |
| 2015-07-16 | BFX | Futures | 4612.0 | 4644.7 | 4607.2 | 4637.4 | 15.0 |
| 2015-07-16 | BR | Futures | 0.18773 | 0.18839 | 0.18674 | 0.18734 | 1428.0 |
| 2015-07-16 | BZ | Futures | 53.42 | 53.93 | 52.89 | 52.93 | 29371.0 |
| 2015-07-16 | C | Futures | 2383.0 | 2389.0 | 2375.0 | 2380.0 | 6024.0 |
| 2015-07-16 | CB | Futures | 153.584 | 153.584 | 150.322 | 150.727 | 34.0 |
| 2015-07-16 | CC | Futures | 2467.0 | 2473.0 | 2451.0 | 2465.0 | 7454.0 |
| 2015-07-16 | CSC | Futures | 4.28 | 4.293 | 4.267 | 4.293 | 112.0 |
| 2015-07-16 | CT | Futures | 80.17 | 80.17 | 79.38 | 79.91 | 18.0 |
| 2015-07-16 | DC | Futures | 34.63 | 34.63 | 34.29 | 34.5 | 274.0 |
| 2015-07-16 | DX | Futures | 91.128 | 91.657 | 91.091 | 91.555 | 39390.0 |
| 2015-07-16 | E1 | Futures | 1.33634 | 1.33697 | 1.32719 | 1.32846 | 12858.0 |
| 2015-07-16 | E6 | Futures | 1.28674 | 1.28897 | 1.27628 | 1.27852 | 227379.0 |
| 2015-07-16 | E7 | Futures | 1.2798 | 1.2816 | 1.2691 | 1.2715 | 3830.0 |
| 2015-07-16 | EBM | Futures | 314.38 | 323.81 | 313.56 | 318.89 | 20124.0 |
| 2015-07-16 | ED | Futures | 95.6462 | 95.6462 | 95.6318 | 95.6414 | 93489.0 |
| 2015-07-16 | ER | Futures | 98.112 | 98.112 | 98.107 | 98.112 | 17037.0 |
| 2015-07-16 | EW | Futures | 1584.8 | 1594.2 | 1583.2 | 1588.7 | 13396.0 |
| 2015-07-16 | FBTP | Futures | 99.64 | 99.67 | 99.27 | 99.56 | 73227.0 |
| 2015-07-16 | FBTS | Futures | 99.866 | 99.892 | 99.83 | 99.866 | 23406.0 |
| 2015-07-16 | FCE | Futures | 4232.9 | 4293.4 | 4227.1 | 4270.0 | 62322.0 |
| 2015-07-16 | FDAX | Futures | 12849.3 | 13035.6 | 12827.8 | 12968.2 | 89493.0 |
| 2015-07-16 | FESX | Futures | 2697.6 | 2735.3 | 2693.9 | 2721.2 | 1278230.0 |
| 2015-07-16 | FGBL | Futures | 135.88 | 136.09 | 135.26 | 135.68 | 575409.0 |
| 2015-07-16 | FGBM | Futures | 124.19 | 124.25 | 124.01 | 124.1 | 391618.0 |
| 2015-07-16 | FGBS | Futures | 111.223 | 111.223 | 111.178 | 111.198 | 248874.0 |
| 2015-07-16 | FGBX | Futures | 151.48 | 152.21 | 149.84 | 151.6 | 24779.0 |
| 2015-07-16 | FMWO | Futures | 5877.8 | 5898.7 | 5877.8 | 5891.3 | 569.0 |
| 2015-07-16 | FOAT | Futures | 124.13 | 124.4 | 123.71 | 124.07 | 75268.0 |
| 2015-07-16 | FTDX | Futures | 1681.9 | 1700.3 | 1681.4 | 1691.8 | 448.0 |
| 2015-07-16 | FTI | Futures | 428.8 | 432.47 | 428.32 | 430.05 | 19511.0 |
| 2015-07-16 | FTUK | Futures | 5340.9 | 5368.4 | 5325.8 | 5356.0 | 78553.0 |
| 2015-07-16 | FVSA | Futures | 1824.72 | 1824.72 | 1658.04 | 1758.92 | 18133.0 |
| 2015-07-16 | FXXP | Futures | 308.3 | 312.0 | 308.2 | 311.1 | 18171.0 |
| 2015-07-16 | G | Futures | 100.76 | 101.11 | 100.41 | 101.05 | 144444.0 |
| 2015-07-16 | GF | Futures | 364.989 | 365.286 | 362.481 | 364.649 | 4188.0 |
| 2015-07-16 | GSCI | Futures | 681.9 | 683.23 | 675.4 | 675.99 | 516.0 |
| 2015-07-16 | HE | Futures | 84.308 | 85.341 | 83.805 | 84.894 | 16065.0 |
| 2015-07-16 | HG | Futures | 3.1381 | 3.1755 | 3.1293 | 3.1487 | 36275.0 |
| 2015-07-16 | HH | Futures | 35.348 | 35.421 | 34.392 | 34.537 | 3117.0 |
> showing 50 of 105 rows — these rows as CSV