PREVIEW / futures_daily / 2016-10-11
file: by_date/futures_daily/2016/2016-10-11.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-11 | ES | Futures | 2335.71 | 2337.06 | 2294.88 | 2308.67 | 2243746.0 |
| 2016-10-11 | NQ | Futures | 5765.46 | 5771.65 | 5654.68 | 5688.85 | 316603.0 |
| 2016-10-11 | YM | Futures | 19178.1 | 19190.7 | 18867.2 | 18974.4 | 190865.0 |
| 2016-10-11 | CL | Futures | 56.35 | 56.83 | 55.56 | 56.01 | 765608.0 |
| 2016-10-11 | GC | Futures | 1618.8 | 1621.7 | 1609.3 | 1611.3 | 141054.0 |
| 2016-10-11 | ZN | Futures | 126.283672 | 126.496475 | 126.16207 | 126.359673 | 1116008.0 |
| 2016-10-11 | A6 | Futures | 0.7751 | 0.7754 | 0.76734 | 0.76846 | 95419.0 |
| 2016-10-11 | AD | Futures | 0.77816 | 0.77837 | 0.77197 | 0.77371 | 68517.0 |
| 2016-10-11 | ALI | Futures | 2226.18 | 2238.89 | 2226.18 | 2238.89 | 35.0 |
| 2016-10-11 | B | Futures | 41.1 | 41.27 | 40.34 | 40.56 | 373849.0 |
| 2016-10-11 | B6 | Futures | 1.3026 | 1.3031 | 1.2741 | 1.2788 | 210350.0 |
| 2016-10-11 | BFX | Futures | 4191.4 | 4191.4 | 4187.8 | 4187.8 | 1.0 |
| 2016-10-11 | BR | Futures | 0.21164 | 0.21164 | 0.20965 | 0.21075 | 45.0 |
| 2016-10-11 | BZ | Futures | 40.78 | 41.02 | 40.11 | 40.33 | 33630.0 |
| 2016-10-11 | C | Futures | 2385.0 | 2403.0 | 2372.0 | 2399.0 | 8956.0 |
| 2016-10-11 | CB | Futures | 233.543 | 233.543 | 231.094 | 233.047 | 7.0 |
| 2016-10-11 | CC | Futures | 1976.0 | 1980.0 | 1941.0 | 1971.0 | 19205.0 |
| 2016-10-11 | CNH | Futures | 7.2554 | 7.2756 | 7.2554 | 7.267 | 39.0 |
| 2016-10-11 | CSC | Futures | 3.705 | 3.714 | 3.626 | 3.645 | 98.0 |
| 2016-10-11 | CT | Futures | 75.84 | 76.22 | 75.08 | 75.22 | 12379.0 |
| 2016-10-11 | DC | Futures | 29.04 | 29.09 | 28.35 | 28.52 | 359.0 |
| 2016-10-11 | DX | Futures | 90.215 | 90.973 | 90.215 | 90.924 | 29645.0 |
| 2016-10-11 | E1 | Futures | 1.27235 | 1.27309 | 1.26363 | 1.264 | 24727.0 |
| 2016-10-11 | E6 | Futures | 1.29475 | 1.29521 | 1.2842 | 1.28443 | 186158.0 |
| 2016-10-11 | E7 | Futures | 1.2875 | 1.2881 | 1.2772 | 1.2775 | 2281.0 |
| 2016-10-11 | EBM | Futures | 185.94 | 186.52 | 185.35 | 185.94 | 13357.0 |
| 2016-10-11 | ED | Futures | 95.6152 | 95.62 | 95.6104 | 95.6152 | 201542.0 |
| 2016-10-11 | ER | Futures | 98.269 | 98.274 | 98.264 | 98.269 | 54532.0 |
| 2016-10-11 | EW | Futures | 1642.7 | 1643.5 | 1607.8 | 1614.9 | 25779.0 |
| 2016-10-11 | FBON | Futures | 124.39 | 124.48 | 123.94 | 124.35 | 724.0 |
| 2016-10-11 | FBTP | Futures | 108.32 | 108.54 | 108.18 | 108.39 | 87960.0 |
| 2016-10-11 | FBTS | Futures | 101.239 | 101.266 | 101.239 | 101.257 | 13570.0 |
| 2016-10-11 | FCE | Futures | 3984.0 | 4017.4 | 3959.1 | 3972.9 | 84249.0 |
| 2016-10-11 | FDAX | Futures | 11187.8 | 11290.8 | 11134.4 | 11161.3 | 99193.0 |
| 2016-10-11 | FDXM | Futures | 11166.8 | 11265.9 | 11110.9 | 11137.2 | 33188.0 |
| 2016-10-11 | FESX | Futures | 2413.4 | 2435.0 | 2400.5 | 2408.6 | 895791.0 |
| 2016-10-11 | FEU3 | Futures | 98.952 | 98.952 | 98.952 | 98.952 | 5.0 |
| 2016-10-11 | FGBL | Futures | 149.3 | 149.67 | 149.19 | 149.48 | 777310.0 |
| 2016-10-11 | FGBM | Futures | 128.8 | 128.87 | 128.75 | 128.81 | 359648.0 |
| 2016-10-11 | FGBS | Futures | 111.937 | 111.947 | 111.927 | 111.942 | 180579.0 |
| 2016-10-11 | FGBX | Futures | 180.05 | 181.61 | 179.82 | 180.88 | 48803.0 |
| 2016-10-11 | FMWO | Futures | 5719.5 | 5721.9 | 5673.5 | 5673.5 | 5.0 |
| 2016-10-11 | FOAT | Futures | 137.0 | 137.34 | 136.92 | 137.19 | 117403.0 |
| 2016-10-11 | FTDX | Futures | 1768.5 | 1779.8 | 1765.6 | 1771.0 | 91.0 |
| 2016-10-11 | FTI | Futures | 418.22 | 418.22 | 411.6 | 413.07 | 12.0 |
| 2016-10-11 | FTUK | Futures | 5966.8 | 5987.9 | 5923.4 | 5931.4 | 106737.0 |
| 2016-10-11 | FVSA | Futures | 1462.15 | 1515.77 | 1426.4 | 1487.17 | 14784.0 |
| 2016-10-11 | FXXP | Futures | 280.1 | 282.0 | 278.2 | 279.3 | 32997.0 |
| 2016-10-11 | G | Futures | 113.65 | 114.12 | 113.64 | 113.89 | 235776.0 |
| 2016-10-11 | GF | Futures | 256.628 | 261.299 | 255.017 | 256.789 | 5461.0 |
> showing 50 of 109 rows — these rows as CSV