PREVIEW / futures_daily / 2016-08-16
file: by_date/futures_daily/2016/2016-08-16.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-08-16 | ES | Futures | 2360.2 | 2360.47 | 2348.6 | 2350.22 | 1391768.0 |
| 2016-08-16 | NQ | Futures | 5684.75 | 5686.81 | 5653.8 | 5656.16 | 156061.0 |
| 2016-08-16 | YM | Futures | 19415.5 | 19416.5 | 19330.9 | 19348.7 | 103472.0 |
| 2016-08-16 | CL | Futures | 51.41 | 52.65 | 51.13 | 52.48 | 272462.0 |
| 2016-08-16 | GC | Futures | 1725.9 | 1750.4 | 1725.4 | 1740.9 | 221723.0 |
| 2016-08-16 | ZN | Futures | 127.697843 | 128.105293 | 127.365846 | 127.486572 | 1459939.0 |
| 2016-08-16 | A6 | Futures | 0.78026 | 0.78779 | 0.77792 | 0.78291 | 128010.0 |
| 2016-08-16 | AD | Futures | 0.79183 | 0.79966 | 0.79127 | 0.79695 | 75816.0 |
| 2016-08-16 | ALI | Futures | 2180.3 | 2180.93 | 2180.3 | 2180.93 | 2.0 |
| 2016-08-16 | B | Futures | 38.11 | 39.01 | 37.86 | 38.91 | 331860.0 |
| 2016-08-16 | B6 | Futures | 1.3585 | 1.3767 | 1.3585 | 1.375 | 105872.0 |
| 2016-08-16 | BFX | Futures | 4084.8 | 4084.8 | 4061.7 | 4061.7 | 20.0 |
| 2016-08-16 | BR | Futures | 0.20779 | 0.20982 | 0.20736 | 0.20806 | 456.0 |
| 2016-08-16 | BZ | Futures | 37.91 | 38.81 | 37.68 | 38.72 | 27839.0 |
| 2016-08-16 | C | Futures | 2635.0 | 2647.0 | 2614.0 | 2646.0 | 4866.0 |
| 2016-08-16 | CB | Futures | 273.124 | 274.296 | 268.787 | 270.78 | 74.0 |
| 2016-08-16 | CC | Futures | 2245.0 | 2266.0 | 2229.0 | 2262.0 | 21347.0 |
| 2016-08-16 | CNH | Futures | 7.182 | 7.182 | 7.1749 | 7.175 | 14.0 |
| 2016-08-16 | CSC | Futures | 3.847 | 3.889 | 3.843 | 3.889 | 67.0 |
| 2016-08-16 | CT | Futures | 77.13 | 77.13 | 75.02 | 77.04 | 51.0 |
| 2016-08-16 | DC | Futures | 31.1 | 31.39 | 30.94 | 31.28 | 224.0 |
| 2016-08-16 | DX | Futures | 88.923 | 88.923 | 87.779 | 88.136 | 29135.0 |
| 2016-08-16 | E1 | Futures | 1.28882 | 1.30872 | 1.28869 | 1.30321 | 27515.0 |
| 2016-08-16 | E6 | Futures | 1.30354 | 1.3199 | 1.30296 | 1.31442 | 207887.0 |
| 2016-08-16 | E7 | Futures | 1.2965 | 1.3128 | 1.2961 | 1.3075 | 4344.0 |
| 2016-08-16 | EBM | Futures | 195.77 | 196.67 | 195.17 | 196.37 | 11326.0 |
| 2016-08-16 | ED | Futures | 95.6702 | 95.6894 | 95.6533 | 95.6605 | 339055.0 |
| 2016-08-16 | ER | Futures | 98.308 | 98.313 | 98.303 | 98.308 | 37625.0 |
| 2016-08-16 | EW | Futures | 1659.6 | 1661.3 | 1644.3 | 1644.8 | 13802.0 |
| 2016-08-16 | FBON | Futures | 124.64 | 124.92 | 124.4 | 124.4 | 271.0 |
| 2016-08-16 | FBTP | Futures | 111.2 | 111.27 | 110.51 | 110.52 | 65768.0 |
| 2016-08-16 | FBTS | Futures | 101.365 | 101.365 | 101.311 | 101.32 | 16527.0 |
| 2016-08-16 | FCE | Futures | 3916.1 | 3931.0 | 3892.1 | 3896.5 | 158869.0 |
| 2016-08-16 | FDAX | Futures | 11396.9 | 11427.3 | 11312.3 | 11384.7 | 79625.0 |
| 2016-08-16 | FDXM | Futures | 11101.7 | 11138.0 | 11026.0 | 11097.0 | 20880.0 |
| 2016-08-16 | FESX | Futures | 2376.0 | 2380.7 | 2355.7 | 2366.6 | 917543.0 |
| 2016-08-16 | FEU3 | Futures | 98.966 | 98.966 | 98.961 | 98.961 | 1.0 |
| 2016-08-16 | FGBL | Futures | 150.63 | 150.82 | 149.96 | 150.0 | 556497.0 |
| 2016-08-16 | FGBM | Futures | 128.87 | 128.95 | 128.73 | 128.74 | 295341.0 |
| 2016-08-16 | FGBS | Futures | 111.867 | 111.877 | 111.847 | 111.852 | 109181.0 |
| 2016-08-16 | FGBX | Futures | 188.92 | 189.78 | 186.76 | 186.91 | 27857.0 |
| 2016-08-16 | FMWO | Futures | 5809.7 | 5814.5 | 5799.9 | 5804.8 | 154.0 |
| 2016-08-16 | FOAT | Futures | 138.66 | 138.79 | 137.94 | 137.95 | 74843.0 |
| 2016-08-16 | FTDX | Futures | 1681.4 | 1681.4 | 1667.9 | 1668.8 | 135.0 |
| 2016-08-16 | FTI | Futures | 408.12 | 409.48 | 406.23 | 406.68 | 25985.0 |
| 2016-08-16 | FTUK | Futures | 5777.1 | 5783.0 | 5740.0 | 5752.5 | 89185.0 |
| 2016-08-16 | FVSA | Futures | 1895.26 | 1964.5 | 1895.26 | 1951.51 | 21702.0 |
| 2016-08-16 | FXXP | Futures | 278.8 | 279.6 | 277.2 | 278.1 | 16967.0 |
| 2016-08-16 | G | Futures | 117.46 | 117.54 | 116.84 | 116.92 | 160913.0 |
| 2016-08-16 | GF | Futures | 295.397 | 296.202 | 292.127 | 292.932 | 3881.0 |
> showing 50 of 109 rows — these rows as CSV