PREVIEW / futures_daily / 2016-10-10
file: by_date/futures_daily/2016/2016-10-10.parquet size: 9 KB rows: 108
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-10 | ES | Futures | 2327.59 | 2340.03 | 2323.81 | 2335.17 | 952867.0 |
| 2016-10-10 | NQ | Futures | 5737.17 | 5776.66 | 5730.4 | 5766.93 | 159238.0 |
| 2016-10-10 | YM | Futures | 19092.0 | 19236.9 | 19080.4 | 19172.8 | 106058.0 |
| 2016-10-10 | CL | Futures | 54.66 | 56.9 | 54.2 | 56.62 | 686070.0 |
| 2016-10-10 | GC | Futures | 1614.7 | 1625.3 | 1614.7 | 1617.1 | 140762.0 |
| 2016-10-10 | ZN | Futures | 126.572477 | 126.633278 | 126.131669 | 126.268472 | 299171.0 |
| 2016-10-10 | A6 | Futures | 0.77387 | 0.77714 | 0.77214 | 0.77479 | 57655.0 |
| 2016-10-10 | AD | Futures | 0.77243 | 0.77985 | 0.77166 | 0.77781 | 62193.0 |
| 2016-10-10 | ALI | Futures | 2242.71 | 2243.66 | 2241.75 | 2243.66 | 15.0 |
| 2016-10-10 | B | Futures | 39.96 | 41.58 | 39.7 | 41.13 | 334274.0 |
| 2016-10-10 | B6 | Futures | 1.3105 | 1.3116 | 1.3009 | 1.3014 | 76376.0 |
| 2016-10-10 | BR | Futures | 0.2103 | 0.21068 | 0.2103 | 0.21047 | 263.0 |
| 2016-10-10 | BZ | Futures | 39.72 | 41.34 | 39.46 | 40.89 | 28796.0 |
| 2016-10-10 | C | Futures | 2469.0 | 2483.0 | 2349.0 | 2379.0 | 12600.0 |
| 2016-10-10 | CB | Futures | 237.448 | 237.479 | 237.293 | 237.293 | 4.0 |
| 2016-10-10 | CC | Futures | 2065.0 | 2070.0 | 1946.0 | 1965.0 | 32767.0 |
| 2016-10-10 | CNH | Futures | 7.2133 | 7.248 | 7.2133 | 7.248 | 13.0 |
| 2016-10-10 | CSC | Futures | 3.741 | 3.741 | 3.7 | 3.714 | 60.0 |
| 2016-10-10 | CT | Futures | 75.4 | 76.73 | 75.17 | 75.46 | 13771.0 |
| 2016-10-10 | DC | Futures | 29.44 | 29.44 | 29.0 | 29.11 | 111.0 |
| 2016-10-10 | DX | Futures | 89.833 | 90.247 | 89.801 | 90.218 | 16361.0 |
| 2016-10-10 | E1 | Futures | 1.27895 | 1.27945 | 1.2706 | 1.27197 | 14436.0 |
| 2016-10-10 | E6 | Futures | 1.30077 | 1.30199 | 1.29393 | 1.29475 | 88304.0 |
| 2016-10-10 | E7 | Futures | 1.2942 | 1.2947 | 1.2869 | 1.2877 | 1046.0 |
| 2016-10-10 | EBM | Futures | 185.35 | 186.52 | 185.05 | 185.64 | 15318.0 |
| 2016-10-10 | ED | Futures | 95.6345 | 95.6345 | 95.6104 | 95.6152 | 99664.0 |
| 2016-10-10 | ER | Futures | 98.269 | 98.269 | 98.259 | 98.264 | 77273.0 |
| 2016-10-10 | EW | Futures | 1631.4 | 1652.1 | 1629.1 | 1641.9 | 13771.0 |
| 2016-10-10 | FBON | Futures | 124.43 | 124.43 | 124.18 | 124.28 | 456.0 |
| 2016-10-10 | FBTP | Futures | 108.46 | 108.55 | 108.21 | 108.32 | 56403.0 |
| 2016-10-10 | FBTS | Futures | 101.239 | 101.257 | 101.23 | 101.248 | 9818.0 |
| 2016-10-10 | FCE | Futures | 3960.9 | 4004.5 | 3933.3 | 3995.6 | 84327.0 |
| 2016-10-10 | FDAX | Futures | 11091.6 | 11250.1 | 11035.1 | 11225.8 | 92296.0 |
| 2016-10-10 | FDIV | Futures | 142.15 | 142.15 | 142.15 | 142.15 | 2.0 |
| 2016-10-10 | FDXM | Futures | 11067.6 | 11222.7 | 11011.8 | 11201.6 | 37450.0 |
| 2016-10-10 | FESX | Futures | 2398.1 | 2427.0 | 2380.5 | 2423.8 | 838068.0 |
| 2016-10-10 | FEU3 | Futures | 98.947 | 98.947 | 98.947 | 98.947 | 4.0 |
| 2016-10-10 | FGBL | Futures | 149.79 | 149.9 | 149.11 | 149.21 | 584949.0 |
| 2016-10-10 | FGBM | Futures | 128.86 | 128.91 | 128.74 | 128.8 | 359533.0 |
| 2016-10-10 | FGBS | Futures | 111.932 | 111.942 | 111.907 | 111.937 | 202755.0 |
| 2016-10-10 | FGBX | Futures | 181.92 | 182.18 | 179.47 | 179.82 | 35129.0 |
| 2016-10-10 | FMWO | Futures | 5729.2 | 5752.1 | 5729.2 | 5749.7 | 100.0 |
| 2016-10-10 | FOAT | Futures | 137.44 | 137.54 | 136.84 | 136.93 | 84661.0 |
| 2016-10-10 | FTDX | Futures | 1760.7 | 1777.8 | 1758.7 | 1775.9 | 148.0 |
| 2016-10-10 | FTI | Futures | 412.65 | 416.75 | 412.19 | 416.75 | 51.0 |
| 2016-10-10 | FTUK | Futures | 5934.3 | 5966.8 | 5898.0 | 5960.1 | 94541.0 |
| 2016-10-10 | FVSA | Futures | 1526.5 | 1547.95 | 1451.42 | 1455.0 | 7555.0 |
| 2016-10-10 | FXXP | Futures | 279.2 | 281.5 | 277.6 | 281.4 | 18706.0 |
| 2016-10-10 | G | Futures | 114.1 | 114.12 | 113.4 | 113.64 | 150145.0 |
| 2016-10-10 | GF | Futures | 263.285 | 265.594 | 254.427 | 257.755 | 5803.0 |
> showing 50 of 108 rows — these rows as CSV