PREVIEW / futures_daily / 2016-06-28
file: by_date/futures_daily/2016/2016-06-28.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-06-28 | ES | Futures | 2140.49 | 2191.5 | 2140.22 | 2190.15 | 2285755.0 |
| 2016-06-28 | NQ | Futures | 4922.69 | 5050.29 | 4922.4 | 5046.17 | 258268.0 |
| 2016-06-28 | YM | Futures | 17734.9 | 18077.5 | 17734.9 | 18071.2 | 191253.0 |
| 2016-06-28 | CL | Futures | 54.12 | 55.97 | 54.06 | 55.58 | 498851.0 |
| 2016-06-28 | GC | Futures | 1708.9 | 1710.4 | 1683.0 | 1695.5 | 195976.0 |
| 2016-06-28 | ZN | Futures | 128.87492 | 128.995646 | 128.482561 | 128.693831 | 1136545.0 |
| 2016-06-28 | A6 | Futures | 0.74404 | 0.75228 | 0.74384 | 0.7474 | 90308.0 |
| 2016-06-28 | AD | Futures | 0.78237 | 0.78933 | 0.78083 | 0.78421 | 54188.0 |
| 2016-06-28 | ALI | Futures | 2132.87 | 2132.87 | 2132.87 | 2132.87 | 10.0 |
| 2016-06-28 | B | Futures | 38.47 | 39.48 | 38.36 | 39.33 | 299226.0 |
| 2016-06-28 | B6 | Futures | 1.3954 | 1.4157 | 1.3945 | 1.4078 | 144532.0 |
| 2016-06-28 | BFX | Futures | 3799.2 | 3799.2 | 3771.5 | 3771.5 | 2.0 |
| 2016-06-28 | BR | Futures | 0.19558 | 0.198 | 0.19558 | 0.198 | 318.0 |
| 2016-06-28 | BZ | Futures | 38.35 | 39.33 | 38.22 | 39.18 | 29494.0 |
| 2016-06-28 | C | Futures | 2505.0 | 2512.0 | 2487.0 | 2505.0 | 9892.0 |
| 2016-06-28 | CB | Futures | 275.468 | 275.468 | 272.567 | 273.212 | 4.0 |
| 2016-06-28 | CC | Futures | 2206.0 | 2222.0 | 2192.0 | 2204.0 | 14513.0 |
| 2016-06-28 | CNH | Futures | 7.232 | 7.2482 | 7.232 | 7.2482 | 20.0 |
| 2016-06-28 | CSC | Futures | 3.625 | 3.733 | 3.625 | 3.714 | 44.0 |
| 2016-06-28 | CT | Futures | 73.53 | 75.19 | 73.53 | 74.92 | 53.0 |
| 2016-06-28 | DC | Futures | 29.12 | 30.04 | 29.1 | 29.77 | 212.0 |
| 2016-06-28 | DX | Futures | 89.811 | 89.816 | 89.211 | 89.593 | 20694.0 |
| 2016-06-28 | E1 | Futures | 1.28794 | 1.28844 | 1.2788 | 1.27967 | 14997.0 |
| 2016-06-28 | E6 | Futures | 1.28707 | 1.29737 | 1.28567 | 1.28986 | 150774.0 |
| 2016-06-28 | E7 | Futures | 1.2801 | 1.2902 | 1.279 | 1.283 | 3072.0 |
| 2016-06-28 | EBM | Futures | 194.27 | 194.57 | 191.56 | 192.16 | 10579.0 |
| 2016-06-28 | ED | Futures | 95.8631 | 95.8679 | 95.8486 | 95.8631 | 148053.0 |
| 2016-06-28 | ER | Futures | 98.298 | 98.308 | 98.293 | 98.303 | 57015.0 |
| 2016-06-28 | EW | Futures | 1491.0 | 1527.9 | 1491.0 | 1524.6 | 27659.0 |
| 2016-06-28 | FBON | Futures | 120.17 | 121.32 | 120.17 | 121.18 | 540.0 |
| 2016-06-28 | FBTP | Futures | 106.98 | 107.84 | 106.83 | 107.71 | 102634.0 |
| 2016-06-28 | FBTS | Futures | 100.97 | 101.15 | 100.97 | 101.141 | 33956.0 |
| 2016-06-28 | FCE | Futures | 3525.0 | 3592.1 | 3521.9 | 3559.4 | 110815.0 |
| 2016-06-28 | FDAX | Futures | 10022.6 | 10156.7 | 9999.7 | 10018.9 | 108551.0 |
| 2016-06-28 | FDXM | Futures | 9761.6 | 9899.5 | 9747.0 | 9765.7 | 25846.0 |
| 2016-06-28 | FESX | Futures | 2141.1 | 2177.9 | 2138.7 | 2148.1 | 1786274.0 |
| 2016-06-28 | FGBL | Futures | 150.01 | 150.18 | 149.61 | 150.14 | 531012.0 |
| 2016-06-28 | FGBM | Futures | 128.79 | 128.94 | 128.72 | 128.91 | 385815.0 |
| 2016-06-28 | FGBS | Futures | 111.917 | 111.957 | 111.902 | 111.952 | 153227.0 |
| 2016-06-28 | FGBX | Futures | 190.25 | 190.75 | 188.04 | 189.37 | 38027.0 |
| 2016-06-28 | FMWO | Futures | 5296.6 | 5328.2 | 5296.6 | 5299.0 | 846.0 |
| 2016-06-28 | FOAT | Futures | 136.58 | 137.38 | 136.58 | 137.35 | 98994.0 |
| 2016-06-28 | FTDX | Futures | 1494.4 | 1506.9 | 1487.2 | 1493.4 | 545.0 |
| 2016-06-28 | FTI | Futures | 374.43 | 378.93 | 374.43 | 375.15 | 33162.0 |
| 2016-06-28 | FTUK | Futures | 4967.5 | 5128.1 | 4940.0 | 5063.8 | 163004.0 |
| 2016-06-28 | FVSA | Futures | 3059.23 | 3089.56 | 2816.51 | 2907.53 | 35440.0 |
| 2016-06-28 | FXXP | Futures | 252.0 | 256.8 | 251.6 | 254.1 | 91735.0 |
| 2016-06-28 | G | Futures | 113.33 | 113.45 | 112.87 | 113.27 | 136556.0 |
| 2016-06-28 | GF | Futures | 280.255 | 282.302 | 279.706 | 280.904 | 2100.0 |
| 2016-06-28 | GSCI | Futures | 534.71 | 540.29 | 534.71 | 540.0 | 30.0 |
> showing 50 of 109 rows — these rows as CSV