PREVIEW / futures_daily / 2014-09-08
file: by_date/futures_daily/2014/2014-09-08.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-08 | ES | Futures | 2084.35 | 2084.6 | 2071.36 | 2078.11 | 1212909.0 |
| 2014-09-08 | NQ | Futures | 4714.92 | 4736.26 | 4702.23 | 4722.42 | 207652.0 |
| 2014-09-08 | YM | Futures | 17273.8 | 17283.9 | 17223.4 | 17253.6 | 109031.0 |
| 2014-09-08 | CL | Futures | 174.14 | 174.38 | 170.99 | 172.6 | 277990.0 |
| 2014-09-08 | GC | Futures | 1665.1 | 1669.2 | 1642.3 | 1645.2 | 112676.0 |
| 2014-09-08 | ZN | Futures | 117.206824 | 117.499695 | 117.016458 | 117.104319 | 1124745.0 |
| 2014-09-08 | A6 | Futures | 0.90494 | 0.90562 | 0.89634 | 0.8975 | 115496.0 |
| 2014-09-08 | AD | Futures | 0.93297 | 0.93307 | 0.92454 | 0.92616 | 66790.0 |
| 2014-09-08 | ALI | Futures | 3080.5 | 3080.5 | 3080.5 | 3080.5 | 11.0 |
| 2014-09-08 | B | Futures | 105.98 | 106.08 | 104.49 | 105.36 | 160665.0 |
| 2014-09-08 | B6 | Futures | 1.7013 | 1.7064 | 1.6923 | 1.694 | 182933.0 |
| 2014-09-08 | BFX | Futures | 3881.4 | 3889.1 | 3881.4 | 3889.1 | 1.0 |
| 2014-09-08 | BR | Futures | 0.23553 | 0.23553 | 0.23253 | 0.23278 | 1687.0 |
| 2014-09-08 | BZ | Futures | 106.75 | 106.82 | 105.23 | 106.11 | 14340.0 |
| 2014-09-08 | C | Futures | 2094.0 | 2120.0 | 2086.0 | 2112.0 | 4753.0 |
| 2014-09-08 | CB | Futures | 157.623 | 159.55 | 157.623 | 159.55 | 7.0 |
| 2014-09-08 | CC | Futures | 2274.0 | 2282.0 | 2257.0 | 2267.0 | 11517.0 |
| 2014-09-08 | CNH | Futures | 7.0373 | 7.0373 | 7.0329 | 7.0371 | 3.0 |
| 2014-09-08 | CSC | Futures | 5.006 | 5.093 | 4.99 | 5.069 | 28.0 |
| 2014-09-08 | CT | Futures | 83.64 | 84.51 | 82.94 | 83.97 | 11.0 |
| 2014-09-08 | DC | Futures | 40.53 | 41.16 | 40.45 | 41.09 | 163.0 |
| 2014-09-08 | DX | Futures | 79.626 | 80.096 | 79.564 | 79.964 | 43300.0 |
| 2014-09-08 | E1 | Futures | 1.37699 | 1.37738 | 1.36982 | 1.37174 | 47642.0 |
| 2014-09-08 | E6 | Futures | 1.52837 | 1.52919 | 1.51999 | 1.52306 | 249022.0 |
| 2014-09-08 | E7 | Futures | 1.5186 | 1.5191 | 1.5101 | 1.5131 | 2454.0 |
| 2014-09-08 | ED | Futures | 95.421 | 95.421 | 95.4162 | 95.4186 | 80124.0 |
| 2014-09-08 | ER | Futures | 98.014 | 98.014 | 98.004 | 98.009 | 46892.0 |
| 2014-09-08 | EW | Futures | 1495.7 | 1498.0 | 1486.7 | 1494.2 | 15188.0 |
| 2014-09-08 | FBTP | Futures | 95.66 | 95.83 | 95.31 | 95.48 | 66630.0 |
| 2014-09-08 | FBTS | Futures | 98.881 | 98.899 | 98.81 | 98.845 | 7592.0 |
| 2014-09-08 | FCE | Futures | 3578.2 | 3578.6 | 3546.0 | 3563.5 | 64724.0 |
| 2014-09-08 | FDAX | Futures | 10775.7 | 10775.7 | 10697.6 | 10740.0 | 81890.0 |
| 2014-09-08 | FESX | Futures | 2361.2 | 2362.0 | 2336.8 | 2349.0 | 822948.0 |
| 2014-09-08 | FGBL | Futures | 131.38 | 131.64 | 130.94 | 131.35 | 603103.0 |
| 2014-09-08 | FGBM | Futures | 122.8 | 122.88 | 122.63 | 122.76 | 347316.0 |
| 2014-09-08 | FGBS | Futures | 110.943 | 110.968 | 110.933 | 110.948 | 210715.0 |
| 2014-09-08 | FGBX | Futures | 140.43 | 141.49 | 139.95 | 140.83 | 28086.0 |
| 2014-09-08 | FMWO | Futures | 5805.3 | 5810.4 | 5805.3 | 5810.4 | 17.0 |
| 2014-09-08 | FOAT | Futures | 121.64 | 121.78 | 121.37 | 121.56 | 72990.0 |
| 2014-09-08 | FTDX | Futures | 1184.6 | 1187.4 | 1177.2 | 1184.6 | 90.0 |
| 2014-09-08 | FTI | Futures | 363.32 | 363.62 | 360.44 | 362.42 | 22177.0 |
| 2014-09-08 | FTUK | Futures | 5275.4 | 5283.5 | 5208.8 | 5254.2 | 118731.0 |
| 2014-09-08 | FVSA | Futures | 1378.05 | 1399.44 | 1365.21 | 1378.05 | 7043.0 |
| 2014-09-08 | FXXP | Futures | 262.3 | 262.3 | 259.5 | 261.0 | 8668.0 |
| 2014-09-08 | G | Futures | 96.36 | 96.69 | 96.27 | 96.52 | 155023.0 |
| 2014-09-08 | GF | Futures | 351.802 | 353.198 | 349.436 | 352.384 | 929.0 |
| 2014-09-08 | GSCI | Futures | 1000.26 | 1003.11 | 996.66 | 1001.35 | 1138.0 |
| 2014-09-08 | HE | Futures | 128.3 | 128.33 | 124.28 | 124.613 | 32182.0 |
| 2014-09-08 | HG | Futures | 4.0177 | 4.071 | 4.0113 | 4.019 | 38623.0 |
| 2014-09-08 | HH | Futures | 46.444 | 47.595 | 46.321 | 47.485 | 1564.0 |
> showing 50 of 105 rows — these rows as CSV