PREVIEW / futures_daily / 2015-08-04
file: by_date/futures_daily/2015/2015-08-04.parquet size: 9 KB rows: 106
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-04 | ES | Futures | 2215.55 | 2221.64 | 2206.01 | 2207.6 | 1327878.0 |
| 2015-08-04 | NQ | Futures | 5336.15 | 5348.7 | 5304.62 | 5314.25 | 253010.0 |
| 2015-08-04 | YM | Futures | 17985.2 | 18031.4 | 17894.8 | 17925.6 | 125478.0 |
| 2015-08-04 | CL | Futures | 75.3 | 76.76 | 75.2 | 75.94 | 285786.0 |
| 2015-08-04 | GC | Futures | 1401.0 | 1412.7 | 1394.4 | 1408.0 | 114103.0 |
| 2015-08-04 | ZN | Futures | 121.89748 | 121.971999 | 121.211909 | 121.390754 | 1020055.0 |
| 2015-08-04 | A6 | Futures | 0.7192 | 0.73425 | 0.71781 | 0.7298 | 131438.0 |
| 2015-08-04 | AD | Futures | 0.777 | 0.77997 | 0.77424 | 0.77526 | 58974.0 |
| 2015-08-04 | ALI | Futures | 2203.01 | 2203.01 | 2203.01 | 2203.01 | 0.0 |
| 2015-08-04 | B | Futures | 46.79 | 47.32 | 46.52 | 46.86 | 150000.0 |
| 2015-08-04 | B6 | Futures | 1.64 | 1.6451 | 1.637 | 1.638 | 85405.0 |
| 2015-08-04 | BFX | Futures | 4589.0 | 4595.1 | 4589.0 | 4595.1 | 1.0 |
| 2015-08-04 | BR | Futures | 0.17017 | 0.17263 | 0.16958 | 0.17107 | 4730.0 |
| 2015-08-04 | BZ | Futures | 46.55 | 47.26 | 46.55 | 46.82 | 17646.0 |
| 2015-08-04 | C | Futures | 2262.0 | 2272.0 | 2252.0 | 2253.0 | 10892.0 |
| 2015-08-04 | CB | Futures | 161.892 | 161.892 | 158.042 | 158.873 | 7.0 |
| 2015-08-04 | CC | Futures | 2327.0 | 2344.0 | 2320.0 | 2327.0 | 26662.0 |
| 2015-08-04 | CNH | Futures | 7.0065 | 7.0065 | 7.005 | 7.0057 | 29.0 |
| 2015-08-04 | CSC | Futures | 4.493 | 4.508 | 4.432 | 4.493 | 43.0 |
| 2015-08-04 | CT | Futures | 79.85 | 80.14 | 79.43 | 79.43 | 10.0 |
| 2015-08-04 | DC | Futures | 36.12 | 36.35 | 35.51 | 36.07 | 217.0 |
| 2015-08-04 | DX | Futures | 91.372 | 91.835 | 91.091 | 91.759 | 37132.0 |
| 2015-08-04 | E1 | Futures | 1.31132 | 1.31513 | 1.29837 | 1.29888 | 17997.0 |
| 2015-08-04 | E6 | Futures | 1.28744 | 1.29156 | 1.27875 | 1.28016 | 171599.0 |
| 2015-08-04 | E7 | Futures | 1.2807 | 1.2844 | 1.2717 | 1.2731 | 4063.0 |
| 2015-08-04 | EBM | Futures | 293.89 | 294.71 | 291.84 | 292.25 | 11330.0 |
| 2015-08-04 | ED | Futures | 95.6366 | 95.6462 | 95.6031 | 95.6127 | 206041.0 |
| 2015-08-04 | ER | Futures | 98.117 | 98.122 | 98.117 | 98.122 | 18452.0 |
| 2015-08-04 | EW | Futures | 1566.6 | 1576.1 | 1561.1 | 1561.5 | 14228.0 |
| 2015-08-04 | FBTP | Futures | 101.26 | 101.72 | 101.26 | 101.33 | 55694.0 |
| 2015-08-04 | FBTS | Futures | 100.106 | 100.142 | 100.106 | 100.124 | 9932.0 |
| 2015-08-04 | FCE | Futures | 4261.3 | 4268.3 | 4232.9 | 4261.7 | 63463.0 |
| 2015-08-04 | FDAX | Futures | 12631.5 | 12691.8 | 12582.4 | 12669.7 | 73252.0 |
| 2015-08-04 | FESX | Futures | 2684.2 | 2687.9 | 2665.0 | 2677.6 | 663306.0 |
| 2015-08-04 | FGBL | Futures | 137.95 | 138.37 | 137.54 | 137.9 | 479366.0 |
| 2015-08-04 | FGBM | Futures | 124.8 | 124.89 | 124.7 | 124.81 | 333091.0 |
| 2015-08-04 | FGBS | Futures | 111.243 | 111.263 | 111.238 | 111.253 | 157836.0 |
| 2015-08-04 | FGBX | Futures | 158.52 | 159.6 | 156.86 | 157.77 | 27949.0 |
| 2015-08-04 | FMWO | Futures | 5818.7 | 5827.3 | 5818.7 | 5827.3 | 499.0 |
| 2015-08-04 | FOAT | Futures | 126.22 | 126.63 | 125.91 | 126.05 | 75452.0 |
| 2015-08-04 | FTDX | Futures | 1699.3 | 1712.0 | 1693.2 | 1698.4 | 242.0 |
| 2015-08-04 | FTI | Futures | 428.67 | 430.27 | 426.6 | 429.1 | 20976.0 |
| 2015-08-04 | FTUK | Futures | 5260.7 | 5297.6 | 5237.6 | 5270.6 | 75150.0 |
| 2015-08-04 | FVSA | Futures | 1684.36 | 1728.22 | 1666.81 | 1671.2 | 9805.0 |
| 2015-08-04 | FXXP | Futures | 305.5 | 306.8 | 304.3 | 306.0 | 7527.0 |
| 2015-08-04 | G | Futures | 102.87 | 103.1 | 102.67 | 102.8 | 157967.0 |
| 2015-08-04 | GF | Futures | 364.691 | 365.881 | 363.161 | 363.756 | 2505.0 |
| 2015-08-04 | GSCI | Futures | 620.59 | 621.01 | 617.42 | 617.92 | 299.0 |
| 2015-08-04 | HE | Futures | 90.251 | 92.576 | 89.328 | 92.097 | 19610.0 |
| 2015-08-04 | HG | Futures | 2.9222 | 2.9634 | 2.9053 | 2.9478 | 45914.0 |
> showing 50 of 106 rows — these rows as CSV