PREVIEW / futures_daily / 2015-10-15
file: by_date/futures_daily/2015/2015-10-15.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-15 | ES | Futures | 2112.35 | 2148.25 | 2111.55 | 2147.71 | 1731138.0 |
| 2015-10-15 | NQ | Futures | 5068.81 | 5158.55 | 5065.6 | 5158.26 | 275986.0 |
| 2015-10-15 | YM | Futures | 17360.7 | 17614.5 | 17359.7 | 17611.4 | 152438.0 |
| 2015-10-15 | CL | Futures | 74.32 | 75.47 | 72.71 | 74.42 | 276935.0 |
| 2015-10-15 | GC | Futures | 1528.4 | 1538.4 | 1515.4 | 1532.9 | 192307.0 |
| 2015-10-15 | ZN | Futures | 124.140566 | 124.170501 | 123.646638 | 123.69154 | 1079901.0 |
| 2015-10-15 | A6 | Futures | 0.72853 | 0.73424 | 0.72443 | 0.73184 | 104610.0 |
| 2015-10-15 | AD | Futures | 0.79217 | 0.79801 | 0.79084 | 0.79719 | 67983.0 |
| 2015-10-15 | ALI | Futures | 2150.98 | 2150.98 | 2150.98 | 2150.98 | 0.0 |
| 2015-10-15 | B | Futures | 44.4 | 45.07 | 43.59 | 44.52 | 321415.0 |
| 2015-10-15 | B6 | Futures | 1.63 | 1.6328 | 1.6229 | 1.631 | 91259.0 |
| 2015-10-15 | BFX | Futures | 4122.0 | 4128.7 | 4120.2 | 4126.3 | 36.0 |
| 2015-10-15 | BR | Futures | 0.15974 | 0.16014 | 0.15654 | 0.15897 | 419.0 |
| 2015-10-15 | BZ | Futures | 44.03 | 44.75 | 43.36 | 44.27 | 26703.0 |
| 2015-10-15 | C | Futures | 2246.0 | 2246.0 | 2226.0 | 2240.0 | 7286.0 |
| 2015-10-15 | CB | Futures | 185.973 | 185.997 | 185.973 | 185.997 | 9.0 |
| 2015-10-15 | CC | Futures | 2281.0 | 2286.0 | 2255.0 | 2276.0 | 14460.0 |
| 2015-10-15 | CNH | Futures | 7.0793 | 7.0821 | 7.072 | 7.0821 | 40.0 |
| 2015-10-15 | CSC | Futures | 4.373 | 4.373 | 4.345 | 4.35 | 47.0 |
| 2015-10-15 | CT | Futures | 76.47 | 76.49 | 75.76 | 76.1 | 12926.0 |
| 2015-10-15 | DC | Futures | 35.08 | 35.08 | 34.74 | 34.83 | 118.0 |
| 2015-10-15 | DX | Futures | 87.896 | 88.499 | 87.755 | 88.317 | 33342.0 |
| 2015-10-15 | E1 | Futures | 1.33935 | 1.34099 | 1.33034 | 1.33668 | 20040.0 |
| 2015-10-15 | E6 | Futures | 1.34621 | 1.34774 | 1.33216 | 1.33473 | 235481.0 |
| 2015-10-15 | E7 | Futures | 1.3388 | 1.3403 | 1.3249 | 1.3274 | 5368.0 |
| 2015-10-15 | EBM | Futures | 259.42 | 260.88 | 258.32 | 259.42 | 10388.0 |
| 2015-10-15 | ED | Futures | 95.764 | 95.7688 | 95.7496 | 95.7544 | 219472.0 |
| 2015-10-15 | ER | Futures | 98.146 | 98.171 | 98.141 | 98.156 | 152638.0 |
| 2015-10-15 | EW | Futures | 1489.2 | 1511.6 | 1484.0 | 1511.3 | 16790.0 |
| 2015-10-15 | FBTP | Futures | 103.26 | 103.46 | 103.17 | 103.23 | 95917.0 |
| 2015-10-15 | FBTS | Futures | 100.382 | 100.409 | 100.382 | 100.4 | 19011.0 |
| 2015-10-15 | FCE | Futures | 3873.6 | 3929.0 | 3852.3 | 3897.4 | 63159.0 |
| 2015-10-15 | FDAX | Futures | 10991.6 | 11177.2 | 10965.2 | 11079.2 | 101432.0 |
| 2015-10-15 | FESX | Futures | 2404.3 | 2442.5 | 2398.3 | 2423.0 | 1005130.0 |
| 2015-10-15 | FEU3 | Futures | 98.798 | 98.803 | 98.798 | 98.803 | 1552.0 |
| 2015-10-15 | FGBL | Futures | 139.57 | 139.81 | 139.39 | 139.48 | 476774.0 |
| 2015-10-15 | FGBM | Futures | 125.43 | 125.51 | 125.34 | 125.37 | 342761.0 |
| 2015-10-15 | FGBS | Futures | 111.318 | 111.333 | 111.298 | 111.303 | 213312.0 |
| 2015-10-15 | FGBX | Futures | 159.14 | 159.73 | 158.77 | 159.1 | 22520.0 |
| 2015-10-15 | FMWO | Futures | 5564.3 | 5570.5 | 5561.8 | 5563.1 | 250.0 |
| 2015-10-15 | FOAT | Futures | 127.83 | 128.08 | 127.66 | 127.74 | 85847.0 |
| 2015-10-15 | FTDX | Futures | 1610.2 | 1648.6 | 1609.2 | 1638.1 | 94.0 |
| 2015-10-15 | FTI | Futures | 380.19 | 388.03 | 379.53 | 385.07 | 15505.0 |
| 2015-10-15 | FTUK | Futures | 5020.4 | 5120.5 | 5016.3 | 5076.3 | 103840.0 |
| 2015-10-15 | FVSA | Futures | 2219.45 | 2279.18 | 2191.88 | 2247.02 | 5071.0 |
| 2015-10-15 | FXXP | Futures | 277.7 | 282.8 | 277.7 | 280.5 | 21334.0 |
| 2015-10-15 | G | Futures | 105.41 | 105.61 | 105.17 | 105.33 | 165961.0 |
| 2015-10-15 | GF | Futures | 337.701 | 339.373 | 333.997 | 335.895 | 4192.0 |
| 2015-10-15 | GSCI | Futures | 591.63 | 594.62 | 590.66 | 593.97 | 417.0 |
| 2015-10-15 | HE | Futures | 100.133 | 100.395 | 98.936 | 99.946 | 12640.0 |
> showing 50 of 107 rows — these rows as CSV