PREVIEW / futures_daily / 2016-10-06
file: by_date/futures_daily/2016/2016-10-06.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-06 | ES | Futures | 2328.95 | 2333.27 | 2318.13 | 2332.46 | 1209239.0 |
| 2016-10-06 | NQ | Futures | 5744.25 | 5752.49 | 5710.66 | 5741.89 | 187196.0 |
| 2016-10-06 | YM | Futures | 19102.5 | 19135.0 | 18980.7 | 19109.8 | 130210.0 |
| 2016-10-06 | CL | Futures | 54.75 | 55.83 | 54.4 | 55.62 | 547915.0 |
| 2016-10-06 | GC | Futures | 1629.0 | 1631.5 | 1606.1 | 1607.6 | 190188.0 |
| 2016-10-06 | ZN | Futures | 126.694079 | 126.846081 | 126.405274 | 126.420474 | 1299055.0 |
| 2016-10-06 | A6 | Futures | 0.77561 | 0.77652 | 0.7704 | 0.77193 | 90540.0 |
| 2016-10-06 | AD | Futures | 0.77735 | 0.7777 | 0.7734 | 0.77453 | 63008.0 |
| 2016-10-06 | ALI | Futures | 2221.73 | 2225.22 | 2220.14 | 2223.32 | 25.0 |
| 2016-10-06 | B | Futures | 40.06 | 40.82 | 39.72 | 40.64 | 293868.0 |
| 2016-10-06 | B6 | Futures | 1.3431 | 1.3447 | 1.3282 | 1.3283 | 124908.0 |
| 2016-10-06 | BFX | Futures | 4228.9 | 4228.9 | 4222.4 | 4222.4 | 6.0 |
| 2016-10-06 | BR | Futures | 0.2076 | 0.20934 | 0.2076 | 0.20921 | 6.0 |
| 2016-10-06 | BZ | Futures | 39.77 | 40.57 | 39.51 | 40.41 | 25994.0 |
| 2016-10-06 | C | Futures | 2463.0 | 2463.0 | 2414.0 | 2431.0 | 11598.0 |
| 2016-10-06 | CB | Futures | 235.588 | 235.588 | 233.791 | 233.791 | 12.0 |
| 2016-10-06 | CC | Futures | 2092.0 | 2095.0 | 2041.0 | 2061.0 | 18743.0 |
| 2016-10-06 | CNH | Futures | 7.2256 | 7.2462 | 7.2256 | 7.245 | 26.0 |
| 2016-10-06 | CSC | Futures | 3.711 | 3.758 | 3.711 | 3.755 | 108.0 |
| 2016-10-06 | CT | Futures | 75.62 | 76.18 | 74.89 | 75.62 | 15393.0 |
| 2016-10-06 | DC | Futures | 29.09 | 29.49 | 29.04 | 29.47 | 160.0 |
| 2016-10-06 | DX | Futures | 89.475 | 90.08 | 89.456 | 90.068 | 26140.0 |
| 2016-10-06 | E1 | Futures | 1.28356 | 1.28431 | 1.27334 | 1.27372 | 19804.0 |
| 2016-10-06 | E6 | Futures | 1.30309 | 1.3035 | 1.29498 | 1.29515 | 159827.0 |
| 2016-10-06 | E7 | Futures | 1.2957 | 1.2964 | 1.2881 | 1.2882 | 2552.0 |
| 2016-10-06 | EBM | Futures | 189.47 | 190.06 | 185.64 | 186.23 | 16121.0 |
| 2016-10-06 | ED | Futures | 95.6297 | 95.6297 | 95.6249 | 95.6249 | 178680.0 |
| 2016-10-06 | ER | Futures | 98.269 | 98.274 | 98.264 | 98.274 | 55665.0 |
| 2016-10-06 | EW | Futures | 1635.9 | 1642.4 | 1628.3 | 1639.8 | 13251.0 |
| 2016-10-06 | FBON | Futures | 124.26 | 124.63 | 124.06 | 124.32 | 679.0 |
| 2016-10-06 | FBTP | Futures | 108.65 | 109.02 | 108.44 | 108.6 | 129598.0 |
| 2016-10-06 | FBTS | Futures | 101.275 | 101.284 | 101.23 | 101.248 | 23045.0 |
| 2016-10-06 | FCE | Futures | 3994.7 | 4008.9 | 3970.2 | 3980.5 | 70703.0 |
| 2016-10-06 | FDAX | Futures | 11190.9 | 11240.6 | 11121.7 | 11184.6 | 87139.0 |
| 2016-10-06 | FDXM | Futures | 11168.9 | 11215.3 | 11097.2 | 11160.4 | 36885.0 |
| 2016-10-06 | FESX | Futures | 2419.0 | 2430.2 | 2406.2 | 2418.2 | 962091.0 |
| 2016-10-06 | FGBL | Futures | 150.09 | 150.53 | 149.78 | 149.9 | 1066393.0 |
| 2016-10-06 | FGBM | Futures | 129.0 | 129.1 | 128.9 | 128.94 | 539638.0 |
| 2016-10-06 | FGBS | Futures | 111.962 | 111.972 | 111.922 | 111.942 | 302767.0 |
| 2016-10-06 | FGBX | Futures | 183.31 | 184.87 | 182.02 | 182.33 | 63392.0 |
| 2016-10-06 | FMWO | Futures | 5747.3 | 5747.3 | 5728.0 | 5731.6 | 280.0 |
| 2016-10-06 | FOAT | Futures | 137.44 | 138.01 | 137.25 | 137.57 | 240855.0 |
| 2016-10-06 | FTDX | Futures | 1779.8 | 1785.7 | 1764.6 | 1773.4 | 98.0 |
| 2016-10-06 | FTI | Futures | 418.89 | 419.58 | 416.78 | 417.01 | 25343.0 |
| 2016-10-06 | FTUK | Futures | 5906.5 | 5928.8 | 5878.2 | 5889.6 | 110221.0 |
| 2016-10-06 | FVSA | Futures | 1497.9 | 1519.35 | 1480.02 | 1494.32 | 6985.0 |
| 2016-10-06 | FXXP | Futures | 283.5 | 284.1 | 281.6 | 282.4 | 25205.0 |
| 2016-10-06 | G | Futures | 115.62 | 115.86 | 114.64 | 114.99 | 303355.0 |
| 2016-10-06 | GF | Futures | 262.408 | 265.142 | 259.933 | 263.698 | 2657.0 |
| 2016-10-06 | GSCI | Futures | 528.72 | 530.92 | 528.29 | 530.21 | 864.0 |
> showing 50 of 109 rows — these rows as CSV