PREVIEW / futures_daily / 2015-10-01
file: by_date/futures_daily/2015/2015-10-01.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-10-01 | ES | Futures | 2023.79 | 2052.51 | 2010.76 | 2038.95 | 2052465.0 |
| 2015-10-01 | NQ | Futures | 4856.89 | 4940.78 | 4812.75 | 4896.06 | 367790.0 |
| 2015-10-01 | YM | Futures | 16639.5 | 16864.4 | 16475.4 | 16704.5 | 220890.0 |
| 2015-10-01 | CL | Futures | 72.89 | 75.65 | 71.68 | 71.86 | 478979.0 |
| 2015-10-01 | GC | Futures | 1438.7 | 1443.9 | 1433.3 | 1437.7 | 83393.0 |
| 2015-10-01 | ZN | Futures | 123.45206 | 123.601735 | 123.167677 | 123.33232 | 1262564.0 |
| 2015-10-01 | A6 | Futures | 0.69933 | 0.70593 | 0.69733 | 0.70053 | 83288.0 |
| 2015-10-01 | AD | Futures | 0.7683 | 0.77476 | 0.7682 | 0.7724 | 73670.0 |
| 2015-10-01 | ALI | Futures | 2116.79 | 2116.79 | 2116.79 | 2116.79 | 0.0 |
| 2015-10-01 | B | Futures | 44.0 | 45.21 | 43.24 | 43.31 | 151227.0 |
| 2015-10-01 | B6 | Futures | 1.5924 | 1.5981 | 1.5903 | 1.593 | 63738.0 |
| 2015-10-01 | BFX | Futures | 4077.4 | 4077.4 | 4009.7 | 4009.7 | 3.0 |
| 2015-10-01 | BR | Futures | 0.15266 | 0.1529 | 0.15038 | 0.15093 | 782.0 |
| 2015-10-01 | BZ | Futures | 43.72 | 44.95 | 43.02 | 43.07 | 24319.0 |
| 2015-10-01 | C | Futures | 2281.0 | 2307.0 | 2266.0 | 2273.0 | 9822.0 |
| 2015-10-01 | CB | Futures | 185.973 | 191.41 | 184.078 | 191.385 | 16.0 |
| 2015-10-01 | CC | Futures | 2288.0 | 2315.0 | 2269.0 | 2277.0 | 19475.0 |
| 2015-10-01 | CNH | Futures | 7.1232 | 7.1269 | 7.1232 | 7.1269 | 1.0 |
| 2015-10-01 | CSC | Futures | 4.327 | 4.358 | 4.327 | 4.34 | 75.0 |
| 2015-10-01 | CT | Futures | 72.34 | 73.25 | 71.86 | 72.7 | 15154.0 |
| 2015-10-01 | DC | Futures | 34.57 | 35.08 | 34.5 | 34.99 | 148.0 |
| 2015-10-01 | DX | Futures | 90.159 | 90.379 | 89.869 | 90.09 | 20393.0 |
| 2015-10-01 | E1 | Futures | 1.30522 | 1.30789 | 1.29901 | 1.30066 | 14573.0 |
| 2015-10-01 | E6 | Futures | 1.31025 | 1.3147 | 1.30592 | 1.31154 | 167296.0 |
| 2015-10-01 | E7 | Futures | 1.3033 | 1.3074 | 1.2987 | 1.3043 | 3593.0 |
| 2015-10-01 | EBM | Futures | 255.76 | 259.42 | 255.4 | 257.59 | 24710.0 |
| 2015-10-01 | ED | Futures | 95.7159 | 95.7159 | 95.7063 | 95.7111 | 202440.0 |
| 2015-10-01 | ER | Futures | 98.136 | 98.146 | 98.131 | 98.141 | 37287.0 |
| 2015-10-01 | EW | Futures | 1436.3 | 1451.7 | 1420.0 | 1436.4 | 27301.0 |
| 2015-10-01 | FBTP | Futures | 102.53 | 103.03 | 102.44 | 102.89 | 103734.0 |
| 2015-10-01 | FBTS | Futures | 100.284 | 100.347 | 100.266 | 100.32 | 15278.0 |
| 2015-10-01 | FCE | Futures | 3746.6 | 3769.1 | 3662.9 | 3684.1 | 108690.0 |
| 2015-10-01 | FDAX | Futures | 10736.7 | 10779.6 | 10406.8 | 10472.9 | 132860.0 |
| 2015-10-01 | FESX | Futures | 2344.3 | 2354.1 | 2279.9 | 2294.1 | 1279529.0 |
| 2015-10-01 | FEU3 | Futures | 98.789 | 98.789 | 98.789 | 98.789 | 1.0 |
| 2015-10-01 | FGBL | Futures | 138.91 | 139.67 | 138.76 | 139.5 | 730435.0 |
| 2015-10-01 | FGBM | Futures | 125.23 | 125.46 | 125.18 | 125.41 | 482509.0 |
| 2015-10-01 | FGBS | Futures | 111.298 | 111.333 | 111.288 | 111.318 | 242141.0 |
| 2015-10-01 | FGBX | Futures | 158.26 | 160.24 | 157.69 | 159.67 | 29323.0 |
| 2015-10-01 | FMWO | Futures | 5328.2 | 5330.7 | 5268.8 | 5268.8 | 85.0 |
| 2015-10-01 | FOAT | Futures | 127.01 | 127.67 | 126.78 | 127.55 | 145583.0 |
| 2015-10-01 | FTDX | Futures | 1669.0 | 1672.8 | 1634.8 | 1637.7 | 319.0 |
| 2015-10-01 | FTI | Futures | 369.82 | 371.78 | 361.4 | 363.53 | 38598.0 |
| 2015-10-01 | FTUK | Futures | 4853.1 | 4940.0 | 4827.4 | 4861.6 | 132027.0 |
| 2015-10-01 | FVSA | Futures | 2589.12 | 2746.32 | 2575.25 | 2723.2 | 4993.0 |
| 2015-10-01 | FXXP | Futures | 273.9 | 274.5 | 267.6 | 269.4 | 18877.0 |
| 2015-10-01 | G | Futures | 105.25 | 105.63 | 105.15 | 105.46 | 182339.0 |
| 2015-10-01 | GF | Futures | 315.203 | 320.397 | 310.099 | 314.981 | 3754.0 |
| 2015-10-01 | GSCI | Futures | 591.85 | 596.59 | 582.06 | 582.06 | 183.0 |
| 2015-10-01 | HE | Futures | 99.647 | 99.647 | 95.721 | 96.506 | 23244.0 |
> showing 50 of 107 rows — these rows as CSV