PREVIEW / futures_daily / 2016-03-07
file: by_date/futures_daily/2016/2016-03-07.parquet size: 9 KB rows: 110
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-03-07 | ES | Futures | 2130.4 | 2141.08 | 2119.72 | 2135.2 | 1633347.0 |
| 2016-03-07 | NQ | Futures | 5065.54 | 5076.09 | 5004.29 | 5040.92 | 246815.0 |
| 2016-03-07 | YM | Futures | 17562.6 | 17674.4 | 17486.1 | 17641.3 | 130845.0 |
| 2016-03-07 | CL | Futures | 45.48 | 47.88 | 45.34 | 47.62 | 709870.0 |
| 2016-03-07 | GC | Futures | 1619.6 | 1637.1 | 1615.7 | 1624.1 | 212786.0 |
| 2016-03-07 | ZN | Futures | 124.739777 | 124.739777 | 124.438946 | 124.514154 | 44401.0 |
| 2016-03-07 | A6 | Futures | 0.74358 | 0.74969 | 0.74057 | 0.74829 | 84214.0 |
| 2016-03-07 | AD | Futures | 0.76756 | 0.77094 | 0.76429 | 0.77002 | 62125.0 |
| 2016-03-07 | ALI | Futures | 2165.99 | 2165.99 | 2165.99 | 2165.99 | 0.0 |
| 2016-03-07 | B | Futures | 32.38 | 34.18 | 32.37 | 34.01 | 341913.0 |
| 2016-03-07 | B6 | Futures | 1.4966 | 1.503 | 1.4871 | 1.5008 | 93203.0 |
| 2016-03-07 | BFX | Futures | 3966.3 | 3974.5 | 3966.3 | 3974.5 | 7.0 |
| 2016-03-07 | BR | Futures | 0.16935 | 0.16938 | 0.16782 | 0.16782 | 1434.0 |
| 2016-03-07 | BZ | Futures | 32.14 | 33.83 | 32.05 | 33.67 | 33230.0 |
| 2016-03-07 | C | Futures | 2329.0 | 2347.0 | 2315.0 | 2331.0 | 3783.0 |
| 2016-03-07 | CB | Futures | 254.805 | 254.866 | 251.634 | 252.915 | 10.0 |
| 2016-03-07 | CC | Futures | 2187.0 | 2209.0 | 2184.0 | 2204.0 | 11241.0 |
| 2016-03-07 | CNH | Futures | 7.1557 | 7.1557 | 7.1324 | 7.1324 | 9.0 |
| 2016-03-07 | CSC | Futures | 3.58 | 3.58 | 3.563 | 3.565 | 46.0 |
| 2016-03-07 | CT | Futures | 65.68 | 66.5 | 65.58 | 65.9 | 15501.0 |
| 2016-03-07 | DC | Futures | 28.13 | 28.2 | 28.05 | 28.16 | 173.0 |
| 2016-03-07 | DX | Futures | 90.925 | 91.266 | 90.654 | 90.691 | 14487.0 |
| 2016-03-07 | E1 | Futures | 1.27044 | 1.27183 | 1.26122 | 1.26943 | 17267.0 |
| 2016-03-07 | E6 | Futures | 1.28572 | 1.28952 | 1.27941 | 1.28841 | 159325.0 |
| 2016-03-07 | E7 | Futures | 1.2789 | 1.2822 | 1.2723 | 1.2812 | 2746.0 |
| 2016-03-07 | EBM | Futures | 198.81 | 199.45 | 197.2 | 198.17 | 22098.0 |
| 2016-03-07 | ED | Futures | 95.6289 | 95.6289 | 95.6265 | 95.6265 | 136893.0 |
| 2016-03-07 | ER | Futures | 98.298 | 98.298 | 98.288 | 98.293 | 39261.0 |
| 2016-03-07 | EW | Futures | 1474.4 | 1485.9 | 1467.7 | 1484.5 | 19824.0 |
| 2016-03-07 | FBON | Futures | 117.54 | 117.54 | 116.9 | 116.96 | 1188.0 |
| 2016-03-07 | FBTP | Futures | 106.1 | 106.34 | 105.87 | 105.99 | 137632.0 |
| 2016-03-07 | FBTS | Futures | 101.051 | 101.096 | 101.015 | 101.033 | 32121.0 |
| 2016-03-07 | FCE | Futures | 3703.8 | 3713.0 | 3668.4 | 3698.8 | 71440.0 |
| 2016-03-07 | FDAX | Futures | 10612.2 | 10637.1 | 10503.2 | 10597.0 | 85613.0 |
| 2016-03-07 | FDXM | Futures | 10153.5 | 10170.1 | 10039.5 | 10132.8 | 16673.0 |
| 2016-03-07 | FESX | Futures | 2302.3 | 2306.9 | 2277.2 | 2294.7 | 1277834.0 |
| 2016-03-07 | FGBL | Futures | 145.32 | 145.58 | 145.18 | 145.4 | 859174.0 |
| 2016-03-07 | FGBM | Futures | 127.66 | 127.75 | 127.61 | 127.7 | 599688.0 |
| 2016-03-07 | FGBS | Futures | 111.797 | 111.822 | 111.778 | 111.797 | 369102.0 |
| 2016-03-07 | FGBX | Futures | 169.08 | 169.76 | 167.45 | 168.46 | 66557.0 |
| 2016-03-07 | FMWO | Futures | 5412.4 | 5436.1 | 5401.2 | 5436.1 | 547.0 |
| 2016-03-07 | FOAT | Futures | 131.98 | 132.27 | 131.9 | 132.14 | 114332.0 |
| 2016-03-07 | FTDX | Futures | 1587.0 | 1587.0 | 1568.8 | 1572.6 | 813.0 |
| 2016-03-07 | FTI | Futures | 386.57 | 388.29 | 383.29 | 385.99 | 25932.0 |
| 2016-03-07 | FTUK | Futures | 5031.4 | 5060.0 | 4985.7 | 5029.8 | 99821.0 |
| 2016-03-07 | FVSA | Futures | 2981.21 | 3039.66 | 2940.29 | 3016.28 | 24312.0 |
| 2016-03-07 | FXXP | Futures | 268.6 | 269.5 | 266.4 | 268.3 | 27219.0 |
| 2016-03-07 | G | Futures | 107.9 | 108.18 | 107.85 | 108.01 | 140180.0 |
| 2016-03-07 | GF | Futures | 309.599 | 311.219 | 307.881 | 310.139 | 1754.0 |
| 2016-03-07 | GSCI | Futures | 482.98 | 492.89 | 482.37 | 492.89 | 1533.0 |
> showing 50 of 110 rows — these rows as CSV