PREVIEW / futures_daily / 2015-01-07
file: by_date/futures_daily/2015/2015-01-07.parquet size: 9 KB rows: 107
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-01-07 | ES | Futures | 2092.59 | 2121.15 | 2091.8 | 2116.69 | 1760658.0 |
| 2015-01-07 | NQ | Futures | 4763.58 | 4830.58 | 4760.39 | 4816.95 | 328184.0 |
| 2015-01-07 | YM | Futures | 17628.8 | 17847.8 | 17619.6 | 17830.5 | 183550.0 |
| 2015-01-07 | CL | Futures | 94.01 | 96.58 | 91.72 | 95.28 | 460083.0 |
| 2015-01-07 | GC | Futures | 1595.6 | 1596.1 | 1582.6 | 1584.7 | 117085.0 |
| 2015-01-07 | ZN | Futures | 121.071364 | 121.248024 | 120.61499 | 121.04192 | 1481757.0 |
| 2015-01-07 | A6 | Futures | 0.78729 | 0.78866 | 0.78298 | 0.78768 | 79658.0 |
| 2015-01-07 | AD | Futures | 0.85904 | 0.86087 | 0.85639 | 0.86037 | 67609.0 |
| 2015-01-07 | ALI | Futures | 2766.68 | 2766.68 | 2766.68 | 2766.68 | 27.0 |
| 2015-01-07 | B | Futures | 53.24 | 53.92 | 51.73 | 53.28 | 250471.0 |
| 2015-01-07 | B6 | Futures | 1.5915 | 1.5928 | 1.582 | 1.5892 | 96222.0 |
| 2015-01-07 | BFX | Futures | 3880.7 | 3881.9 | 3865.0 | 3869.8 | 17.0 |
| 2015-01-07 | BR | Futures | 0.20303 | 0.20331 | 0.20094 | 0.20201 | 48.0 |
| 2015-01-07 | BZ | Futures | 53.33 | 54.2 | 52.04 | 53.57 | 33906.0 |
| 2015-01-07 | C | Futures | 2183.0 | 2205.0 | 2183.0 | 2201.0 | 6317.0 |
| 2015-01-07 | CB | Futures | 131.441 | 133.084 | 131.236 | 132.673 | 22.0 |
| 2015-01-07 | CC | Futures | 2148.0 | 2157.0 | 2139.0 | 2149.0 | 7453.0 |
| 2015-01-07 | CNH | Futures | 7.111 | 7.1133 | 7.111 | 7.1122 | 16.0 |
| 2015-01-07 | CSC | Futures | 4.376 | 4.438 | 4.361 | 4.415 | 28.0 |
| 2015-01-07 | CT | Futures | 76.76 | 77.3 | 76.43 | 77.18 | 9599.0 |
| 2015-01-07 | DC | Futures | 34.57 | 35.27 | 34.34 | 34.9 | 329.0 |
| 2015-01-07 | DX | Futures | 87.085 | 87.567 | 86.99 | 87.193 | 43831.0 |
| 2015-01-07 | E1 | Futures | 1.26428 | 1.26645 | 1.25636 | 1.26147 | 44032.0 |
| 2015-01-07 | E6 | Futures | 1.39786 | 1.40021 | 1.38904 | 1.39468 | 241318.0 |
| 2015-01-07 | E7 | Futures | 1.3894 | 1.3919 | 1.3807 | 1.3864 | 6259.0 |
| 2015-01-07 | EBM | Futures | 328.47 | 329.28 | 324.41 | 324.82 | 18498.0 |
| 2015-01-07 | ED | Futures | 95.4498 | 95.4546 | 95.445 | 95.4498 | 155245.0 |
| 2015-01-07 | ER | Futures | 98.033 | 98.033 | 98.023 | 98.028 | 29250.0 |
| 2015-01-07 | EW | Futures | 1472.2 | 1493.3 | 1472.2 | 1491.3 | 18757.0 |
| 2015-01-07 | FBTP | Futures | 99.06 | 99.3 | 98.41 | 98.46 | 82931.0 |
| 2015-01-07 | FBTS | Futures | 98.686 | 98.81 | 98.632 | 98.641 | 19041.0 |
| 2015-01-07 | FCE | Futures | 3352.9 | 3391.7 | 3328.9 | 3355.4 | 127293.0 |
| 2015-01-07 | FDAX | Futures | 10557.9 | 10670.6 | 10505.7 | 10549.6 | 116841.0 |
| 2015-01-07 | FESX | Futures | 2171.6 | 2203.3 | 2157.9 | 2172.3 | 1197850.0 |
| 2015-01-07 | FEU3 | Futures | 98.65 | 98.65 | 98.645 | 98.645 | 4.0 |
| 2015-01-07 | FGBL | Futures | 137.33 | 137.69 | 137.03 | 137.23 | 759121.0 |
| 2015-01-07 | FGBM | Futures | 123.9 | 123.97 | 123.85 | 123.92 | 372114.0 |
| 2015-01-07 | FGBS | Futures | 110.998 | 111.008 | 110.988 | 110.998 | 237439.0 |
| 2015-01-07 | FGBX | Futures | 160.89 | 163.91 | 159.28 | 160.14 | 54861.0 |
| 2015-01-07 | FMWO | Futures | 5445.5 | 5478.9 | 5441.8 | 5449.2 | 641.0 |
| 2015-01-07 | FOAT | Futures | 126.39 | 126.68 | 126.03 | 126.15 | 82763.0 |
| 2015-01-07 | FTDX | Futures | 1282.5 | 1293.7 | 1279.7 | 1282.9 | 87.0 |
| 2015-01-07 | FTI | Futures | 354.77 | 359.4 | 353.6 | 356.02 | 34839.0 |
| 2015-01-07 | FTUK | Futures | 4942.9 | 4988.1 | 4913.6 | 4947.9 | 101295.0 |
| 2015-01-07 | FVSA | Futures | 2145.36 | 2153.12 | 2071.65 | 2114.32 | 6697.0 |
| 2015-01-07 | FXXP | Futures | 250.2 | 252.7 | 249.5 | 250.4 | 20962.0 |
| 2015-01-07 | G | Futures | 104.62 | 104.72 | 104.12 | 104.36 | 197266.0 |
| 2015-01-07 | GF | Futures | 362.293 | 363.055 | 358.041 | 362.053 | 2144.0 |
| 2015-01-07 | GSCI | Futures | 678.67 | 682.59 | 671.0 | 676.8 | 489.0 |
| 2015-01-07 | HE | Futures | 105.447 | 107.157 | 104.843 | 106.419 | 16126.0 |
> showing 50 of 107 rows — these rows as CSV