PREVIEW / futures_daily / 2013-08-27
file: by_date/futures_daily/2013/2013-08-27.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-27 | ES | Futures | 1704.07 | 1705.1 | 1674.98 | 1677.04 | 2249547.0 |
| 2013-08-27 | NQ | Futures | 3613.11 | 3614.55 | 3530.98 | 3539.07 | 360118.0 |
| 2013-08-27 | YM | Futures | 14805.9 | 14810.9 | 14613.6 | 14627.5 | 176682.0 |
| 2013-08-27 | CL | Futures | 186.58 | 192.17 | 186.12 | 191.62 | 295934.0 |
| 2013-08-27 | GC | Futures | 1857.9 | 1883.3 | 1845.2 | 1878.3 | 160392.0 |
| 2013-08-27 | ZN | Futures | 112.436595 | 113.082299 | 112.324299 | 112.955965 | 1923633.0 |
| 2013-08-27 | A6 | Futures | 0.84612 | 0.84621 | 0.83711 | 0.84152 | 106170.0 |
| 2013-08-27 | AD | Futures | 0.95898 | 0.9616 | 0.95535 | 0.96018 | 49463.0 |
| 2013-08-27 | B | Futures | 108.51 | 112.64 | 108.34 | 111.8 | 190309.0 |
| 2013-08-27 | B6 | Futures | 1.6329 | 1.6346 | 1.6229 | 1.6291 | 105343.0 |
| 2013-08-27 | BR | Futures | 0.20739 | 0.21008 | 0.20739 | 0.21008 | 4300.0 |
| 2013-08-27 | BZ | Futures | 109.69 | 112.71 | 109.17 | 112.65 | 10734.0 |
| 2013-08-27 | C | Futures | 1736.0 | 1739.0 | 1727.0 | 1728.0 | 5142.0 |
| 2013-08-27 | CB | Futures | 69.778 | 70.018 | 69.659 | 69.898 | 23.0 |
| 2013-08-27 | CC | Futures | 1849.0 | 1851.0 | 1820.0 | 1828.0 | 8911.0 |
| 2013-08-27 | CNH | Futures | 7.0848 | 7.0848 | 7.0826 | 7.0826 | 1.0 |
| 2013-08-27 | CSC | Futures | 3.282 | 3.282 | 3.28 | 3.282 | 41.0 |
| 2013-08-27 | CT | Futures | 101.59 | 101.66 | 100.63 | 100.63 | 3.0 |
| 2013-08-27 | DC | Futures | 25.05 | 25.05 | 24.9 | 24.96 | 23.0 |
| 2013-08-27 | DX | Futures | 77.779 | 77.999 | 77.545 | 77.603 | 34093.0 |
| 2013-08-27 | E1 | Futures | 1.3929 | 1.40177 | 1.39278 | 1.39985 | 34466.0 |
| 2013-08-27 | E6 | Futures | 1.57793 | 1.58135 | 1.57226 | 1.5797 | 206068.0 |
| 2013-08-27 | E7 | Futures | 1.5679 | 1.571 | 1.562 | 1.5694 | 3312.0 |
| 2013-08-27 | ED | Futures | 95.306 | 95.3108 | 95.3012 | 95.3084 | 106859.0 |
| 2013-08-27 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.832 | 31118.0 |
| 2013-08-27 | EW | Futures | 1240.0 | 1240.5 | 1213.0 | 1214.5 | 23082.0 |
| 2013-08-27 | FBTP | Futures | 77.81 | 78.08 | 77.48 | 77.57 | 37111.0 |
| 2013-08-27 | FBTS | Futures | 93.186 | 93.255 | 93.04 | 93.057 | 5158.0 |
| 2013-08-27 | FCE | Futures | 3119.7 | 3133.2 | 3041.5 | 3060.8 | 137801.0 |
| 2013-08-27 | FDAX | Futures | 9310.1 | 9351.7 | 9090.3 | 9177.5 | 137652.0 |
| 2013-08-27 | FESX | Futures | 1968.8 | 1978.6 | 1916.2 | 1936.6 | 1250250.0 |
| 2013-08-27 | FEU3 | Futures | 98.443 | 98.443 | 98.443 | 98.443 | 4.0 |
| 2013-08-27 | FGBL | Futures | 117.22 | 118.02 | 117.16 | 117.68 | 658880.0 |
| 2013-08-27 | FGBM | Futures | 116.17 | 116.53 | 116.12 | 116.39 | 388200.0 |
| 2013-08-27 | FGBS | Futures | 110.168 | 110.223 | 110.153 | 110.203 | 242571.0 |
| 2013-08-27 | FGBX | Futures | 119.41 | 120.68 | 119.34 | 120.07 | 7669.0 |
| 2013-08-27 | FMWO | Futures | 4892.7 | 4892.7 | 4892.7 | 4892.7 | 255.0 |
| 2013-08-27 | FOAT | Futures | 105.07 | 105.48 | 105.06 | 105.31 | 35774.0 |
| 2013-08-27 | FTDX | Futures | 979.5 | 979.5 | 952.7 | 960.7 | 66.0 |
| 2013-08-27 | FTI | Futures | 324.23 | 325.15 | 316.73 | 318.56 | 37319.0 |
| 2013-08-27 | FTUK | Futures | 4859.3 | 4863.8 | 4790.7 | 4828.9 | 91785.0 |
| 2013-08-27 | FVSA | Futures | 2648.5 | 2888.06 | 2575.3 | 2848.13 | 15623.0 |
| 2013-08-27 | FXXP | Futures | 223.3 | 223.9 | 219.5 | 220.5 | 6422.0 |
| 2013-08-27 | G | Futures | 91.19 | 91.92 | 91.06 | 91.72 | 337196.0 |
| 2013-08-27 | GF | Futures | 254.37 | 255.685 | 253.589 | 255.315 | 1432.0 |
| 2013-08-27 | GSCI | Futures | 1077.38 | 1091.53 | 1077.38 | 1090.54 | 422.0 |
| 2013-08-27 | HE | Futures | 103.885 | 105.065 | 103.583 | 104.732 | 15648.0 |
| 2013-08-27 | HG | Futures | 4.2139 | 4.2779 | 4.1981 | 4.2234 | 33450.0 |
| 2013-08-27 | HH | Futures | 38.178 | 38.642 | 37.594 | 38.577 | 2215.0 |
| 2013-08-27 | HO | Futures | 2.475 | 2.531 | 2.4658 | 2.5283 | 16078.0 |
> showing 50 of 104 rows — these rows as CSV