PREVIEW / futures_daily / 2016-07-07
file: by_date/futures_daily/2016/2016-07-07.parquet size: 9 KB rows: 110
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-07-07 | ES | Futures | 2258.71 | 2269.51 | 2247.65 | 2258.71 | 1666356.0 |
| 2016-07-07 | NQ | Futures | 5227.4 | 5258.63 | 5218.85 | 5248.02 | 184871.0 |
| 2016-07-07 | YM | Futures | 18618.5 | 18691.6 | 18515.1 | 18611.2 | 134784.0 |
| 2016-07-07 | CL | Futures | 55.62 | 56.05 | 52.12 | 52.43 | 710893.0 |
| 2016-07-07 | GC | Futures | 1757.0 | 1766.3 | 1739.4 | 1752.4 | 218463.0 |
| 2016-07-07 | ZN | Futures | 129.26728 | 129.357824 | 128.784376 | 129.116372 | 1171819.0 |
| 2016-07-07 | A6 | Futures | 0.76287 | 0.7651 | 0.75778 | 0.75859 | 98013.0 |
| 2016-07-07 | AD | Futures | 0.78963 | 0.79475 | 0.78585 | 0.78595 | 62865.0 |
| 2016-07-07 | ALI | Futures | 2138.26 | 2138.26 | 2138.26 | 2138.26 | 0.0 |
| 2016-07-07 | B | Futures | 39.21 | 39.59 | 36.84 | 37.04 | 328097.0 |
| 2016-07-07 | B6 | Futures | 1.3635 | 1.3766 | 1.3587 | 1.3606 | 106305.0 |
| 2016-07-07 | BFX | Futures | 3844.4 | 3845.0 | 3828.5 | 3828.5 | 4.0 |
| 2016-07-07 | BR | Futures | 0.19737 | 0.19737 | 0.19444 | 0.19511 | 19.0 |
| 2016-07-07 | BZ | Futures | 39.09 | 39.45 | 36.71 | 36.91 | 37267.0 |
| 2016-07-07 | C | Futures | 2647.0 | 2666.0 | 2633.0 | 2666.0 | 11141.0 |
| 2016-07-07 | CB | Futures | 276.67 | 281.359 | 276.67 | 281.359 | 29.0 |
| 2016-07-07 | CC | Futures | 2268.0 | 2285.0 | 2252.0 | 2280.0 | 17343.0 |
| 2016-07-07 | CNH | Futures | 7.2642 | 7.2683 | 7.2642 | 7.2683 | 1.0 |
| 2016-07-07 | CSC | Futures | 3.631 | 3.657 | 3.631 | 3.646 | 25.0 |
| 2016-07-07 | CT | Futures | 73.96 | 74.21 | 73.63 | 73.91 | 13.0 |
| 2016-07-07 | DC | Futures | 28.85 | 29.68 | 28.85 | 29.34 | 198.0 |
| 2016-07-07 | DX | Futures | 89.402 | 89.648 | 89.276 | 89.642 | 16059.0 |
| 2016-07-07 | E1 | Futures | 1.28944 | 1.29057 | 1.28356 | 1.28393 | 11182.0 |
| 2016-07-07 | E6 | Futures | 1.29533 | 1.29661 | 1.29003 | 1.29038 | 106400.0 |
| 2016-07-07 | E7 | Futures | 1.2884 | 1.2895 | 1.2833 | 1.2835 | 2743.0 |
| 2016-07-07 | EBM | Futures | 185.85 | 189.45 | 185.85 | 187.35 | 16290.0 |
| 2016-07-07 | ED | Futures | 95.8293 | 95.8293 | 95.8004 | 95.81 | 243971.0 |
| 2016-07-07 | ER | Futures | 98.337 | 98.337 | 98.328 | 98.332 | 40702.0 |
| 2016-07-07 | EW | Futures | 1574.8 | 1589.4 | 1571.7 | 1577.9 | 15320.0 |
| 2016-07-07 | FBON | Futures | 122.16 | 122.55 | 122.16 | 122.38 | 230.0 |
| 2016-07-07 | FBTP | Futures | 109.4 | 109.48 | 108.95 | 109.23 | 82768.0 |
| 2016-07-07 | FBTS | Futures | 101.302 | 101.302 | 101.23 | 101.257 | 20680.0 |
| 2016-07-07 | FCE | Futures | 3588.6 | 3631.3 | 3562.5 | 3587.3 | 83238.0 |
| 2016-07-07 | FDAX | Futures | 10029.5 | 10106.1 | 9951.3 | 10016.7 | 84715.0 |
| 2016-07-07 | FDXM | Futures | 9776.1 | 9850.8 | 9699.3 | 9763.6 | 21454.0 |
| 2016-07-07 | FESX | Futures | 2174.0 | 2194.3 | 2156.0 | 2172.4 | 1279775.0 |
| 2016-07-07 | FEU3 | Futures | 98.986 | 98.991 | 98.986 | 98.986 | 5.0 |
| 2016-07-07 | FGBL | Futures | 150.96 | 150.98 | 150.49 | 150.78 | 556051.0 |
| 2016-07-07 | FGBM | Futures | 129.16 | 129.17 | 129.05 | 129.16 | 439841.0 |
| 2016-07-07 | FGBS | Futures | 111.987 | 111.992 | 111.962 | 111.987 | 207241.0 |
| 2016-07-07 | FGBX | Futures | 191.83 | 192.06 | 189.49 | 190.52 | 37902.0 |
| 2016-07-07 | FMWO | Futures | 5494.7 | 5508.1 | 5481.4 | 5486.2 | 33.0 |
| 2016-07-07 | FOAT | Futures | 138.83 | 138.84 | 138.22 | 138.56 | 152216.0 |
| 2016-07-07 | FTDX | Futures | 1512.7 | 1530.5 | 1512.7 | 1522.3 | 102.0 |
| 2016-07-07 | FTI | Futures | 382.75 | 386.26 | 381.22 | 383.65 | 25502.0 |
| 2016-07-07 | FTUK | Futures | 5408.0 | 5445.9 | 5382.5 | 5414.6 | 143594.0 |
| 2016-07-07 | FVSA | Futures | 2679.98 | 2700.21 | 2578.85 | 2649.64 | 17858.0 |
| 2016-07-07 | FXXP | Futures | 258.6 | 261.6 | 258.0 | 259.8 | 37084.0 |
| 2016-07-07 | G | Futures | 115.11 | 115.19 | 114.63 | 114.88 | 184257.0 |
| 2016-07-07 | GF | Futures | 287.394 | 289.74 | 284.199 | 286.795 | 3776.0 |
> showing 50 of 110 rows — these rows as CSV