PREVIEW / futures_daily / 2016-09-12
file: by_date/futures_daily/2016/2016-09-12.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-09-12 | ES | Futures | 2290.83 | 2335.1 | 2274.91 | 2330.51 | 1450133.0 |
| 2016-09-12 | NQ | Futures | 5505.87 | 5624.93 | 5456.37 | 5618.74 | 178342.0 |
| 2016-09-12 | YM | Futures | 18844.1 | 19192.8 | 18713.9 | 19159.2 | 312986.0 |
| 2016-09-12 | CL | Futures | 50.65 | 51.7 | 49.71 | 51.45 | 745016.0 |
| 2016-09-12 | GC | Futures | 1709.0 | 1711.3 | 1697.8 | 1700.8 | 194664.0 |
| 2016-09-12 | ZN | Futures | 126.75488 | 127.058885 | 126.633278 | 126.952483 | 1198593.0 |
| 2016-09-12 | A6 | Futures | 0.76795 | 0.7702 | 0.76285 | 0.76938 | 17062.0 |
| 2016-09-12 | AD | Futures | 0.78554 | 0.78631 | 0.78093 | 0.78569 | 19143.0 |
| 2016-09-12 | ALI | Futures | 2042.08 | 2042.08 | 2042.08 | 2042.08 | 5.0 |
| 2016-09-12 | B | Futures | 37.59 | 38.23 | 36.87 | 37.99 | 258760.0 |
| 2016-09-12 | B6 | Futures | 1.3993 | 1.4075 | 1.3958 | 1.4061 | 34819.0 |
| 2016-09-12 | BFX | Futures | 4175.3 | 4203.3 | 4175.3 | 4203.3 | 1.0 |
| 2016-09-12 | BR | Futures | 0.2028 | 0.20599 | 0.20277 | 0.20599 | 40.0 |
| 2016-09-12 | BZ | Futures | 37.41 | 38.06 | 36.73 | 37.83 | 18373.0 |
| 2016-09-12 | C | Futures | 2331.0 | 2354.0 | 2304.0 | 2349.0 | 22130.0 |
| 2016-09-12 | CB | Futures | 254.498 | 254.529 | 254.498 | 254.529 | 1.0 |
| 2016-09-12 | CC | Futures | 2045.0 | 2070.0 | 2029.0 | 2064.0 | 19240.0 |
| 2016-09-12 | CNH | Futures | 7.2488 | 7.2532 | 7.2325 | 7.2325 | 23.0 |
| 2016-09-12 | CSC | Futures | 3.903 | 3.903 | 3.87 | 3.87 | 51.0 |
| 2016-09-12 | CT | Futures | 78.05 | 78.3 | 75.75 | 75.86 | 179.0 |
| 2016-09-12 | DC | Futures | 31.06 | 31.06 | 30.6 | 30.7 | 103.0 |
| 2016-09-12 | DX | Futures | 88.661 | 88.777 | 88.288 | 88.417 | 10400.0 |
| 2016-09-12 | E1 | Futures | 1.28431 | 1.29216 | 1.28306 | 1.28854 | 4581.0 |
| 2016-09-12 | E6 | Futures | 1.3075 | 1.31173 | 1.30477 | 1.30837 | 47896.0 |
| 2016-09-12 | E7 | Futures | 1.3005 | 1.3042 | 1.2976 | 1.3013 | 531.0 |
| 2016-09-12 | EBM | Futures | 185.94 | 187.41 | 185.35 | 186.23 | 14778.0 |
| 2016-09-12 | ED | Futures | 95.6152 | 95.6393 | 95.6104 | 95.6297 | 256211.0 |
| 2016-09-12 | ER | Futures | 98.298 | 98.298 | 98.283 | 98.288 | 30869.0 |
| 2016-09-12 | EW | Futures | 1619.1 | 1643.0 | 1605.1 | 1641.4 | 46035.0 |
| 2016-09-12 | FBON | Futures | 123.23 | 123.61 | 123.07 | 123.54 | 898.0 |
| 2016-09-12 | FBTP | Futures | 109.19 | 109.32 | 108.92 | 109.24 | 123043.0 |
| 2016-09-12 | FBTS | Futures | 101.221 | 101.23 | 101.167 | 101.23 | 29268.0 |
| 2016-09-12 | FCE | Futures | 3923.5 | 3980.0 | 3892.9 | 3937.8 | 78544.0 |
| 2016-09-12 | FDAX | Futures | 11056.4 | 11223.5 | 10981.9 | 11091.0 | 174176.0 |
| 2016-09-12 | FDXM | Futures | 10961.1 | 11099.3 | 10872.6 | 10979.6 | 2431.0 |
| 2016-09-12 | FESX | Futures | 2390.1 | 2428.6 | 2375.7 | 2398.9 | 1038455.0 |
| 2016-09-12 | FEU3 | Futures | 98.966 | 98.971 | 98.966 | 98.971 | 407.0 |
| 2016-09-12 | FGBL | Futures | 149.28 | 149.46 | 148.86 | 149.15 | 833455.0 |
| 2016-09-12 | FGBM | Futures | 128.63 | 128.72 | 128.55 | 128.63 | 604615.0 |
| 2016-09-12 | FGBS | Futures | 111.852 | 111.872 | 111.827 | 111.862 | 358567.0 |
| 2016-09-12 | FGBX | Futures | 181.63 | 182.94 | 180.9 | 182.1 | 39134.0 |
| 2016-09-12 | FMWO | Futures | 5665.0 | 5718.5 | 5646.7 | 5710.0 | 1713.0 |
| 2016-09-12 | FOAT | Futures | 137.17 | 137.37 | 136.91 | 137.11 | 137876.0 |
| 2016-09-12 | FTDX | Futures | 1685.7 | 1699.4 | 1675.9 | 1699.4 | 3.0 |
| 2016-09-12 | FTI | Futures | 408.71 | 412.65 | 406.0 | 410.27 | 9318.0 |
| 2016-09-12 | FTUK | Futures | 5652.8 | 5678.1 | 5583.6 | 5624.5 | 289046.0 |
| 2016-09-12 | FVSA | Futures | 1748.14 | 1748.14 | 1651.62 | 1690.94 | 41659.0 |
| 2016-09-12 | FXXP | Futures | 279.5 | 283.2 | 278.1 | 280.9 | 108061.0 |
| 2016-09-12 | G | Futures | 114.79 | 115.14 | 114.62 | 115.06 | 192073.0 |
| 2016-09-12 | GF | Futures | 270.093 | 275.199 | 270.093 | 272.93 | 6221.0 |
> showing 50 of 109 rows — these rows as CSV