PREVIEW / futures_daily / 2014-05-27
file: by_date/futures_daily/2014/2014-05-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 |
|---|---|---|---|---|---|---|---|
| 2014-05-27 | ES | Futures | 1963.74 | 1976.16 | 1962.71 | 1975.38 | 922499.0 |
| 2014-05-27 | NQ | Futures | 4234.92 | 4285.56 | 4233.19 | 4283.55 | 203564.0 |
| 2014-05-27 | YM | Futures | 16661.0 | 16734.3 | 16657.0 | 16722.3 | 93974.0 |
| 2014-05-27 | CL | Futures | 189.79 | 190.08 | 188.39 | 189.37 | 174387.0 |
| 2014-05-27 | GC | Futures | 1705.4 | 1705.9 | 1664.6 | 1667.7 | 90266.0 |
| 2014-05-27 | ZN | Futures | 116.590729 | 116.750085 | 116.460346 | 116.735598 | 1944336.0 |
| 2014-05-27 | A6 | Futures | 0.88597 | 0.8903 | 0.88549 | 0.88838 | 64128.0 |
| 2014-05-27 | AD | Futures | 0.93235 | 0.93529 | 0.93195 | 0.93337 | 44375.0 |
| 2014-05-27 | ALI | Futures | 2733.36 | 2733.36 | 2733.36 | 2733.36 | 0.0 |
| 2014-05-27 | B | Futures | 114.7 | 115.19 | 114.1 | 114.42 | 96458.0 |
| 2014-05-27 | B6 | Futures | 1.7689 | 1.7741 | 1.7636 | 1.7666 | 82661.0 |
| 2014-05-27 | BR | Futures | 0.23086 | 0.23086 | 0.22928 | 0.22928 | 1697.0 |
| 2014-05-27 | BZ | Futures | 115.37 | 116.19 | 115.12 | 115.42 | 12981.0 |
| 2014-05-27 | C | Futures | 1977.0 | 1993.0 | 1954.0 | 1985.0 | 10616.0 |
| 2014-05-27 | CB | Futures | 113.467 | 114.445 | 113.467 | 114.445 | 13.0 |
| 2014-05-27 | CC | Futures | 2231.0 | 2251.0 | 2208.0 | 2235.0 | 16614.0 |
| 2014-05-27 | CNH | Futures | 7.1565 | 7.1773 | 7.1558 | 7.1758 | 44.0 |
| 2014-05-27 | CSC | Futures | 4.426 | 4.511 | 4.426 | 4.511 | 10.0 |
| 2014-05-27 | CT | Futures | 97.4 | 97.4 | 95.54 | 95.68 | 13826.0 |
| 2014-05-27 | DC | Futures | 35.18 | 35.86 | 35.15 | 35.86 | 129.0 |
| 2014-05-27 | DX | Futures | 76.32 | 76.496 | 76.216 | 76.387 | 12488.0 |
| 2014-05-27 | E1 | Futures | 1.4325 | 1.4361 | 1.42904 | 1.43122 | 35630.0 |
| 2014-05-27 | E6 | Futures | 1.60825 | 1.61356 | 1.60695 | 1.60955 | 153882.0 |
| 2014-05-27 | E7 | Futures | 1.5977 | 1.6028 | 1.5964 | 1.5988 | 2422.0 |
| 2014-05-27 | ED | Futures | 95.4138 | 95.4138 | 95.4091 | 95.4114 | 81140.0 |
| 2014-05-27 | ER | Futures | 97.881 | 97.881 | 97.871 | 97.881 | 56457.0 |
| 2014-05-27 | EW | Futures | 1411.1 | 1424.4 | 1411.1 | 1421.5 | 11677.0 |
| 2014-05-27 | FBTP | Futures | 89.52 | 89.84 | 89.42 | 89.47 | 77793.0 |
| 2014-05-27 | FBTS | Futures | 97.592 | 97.654 | 97.504 | 97.548 | 18011.0 |
| 2014-05-27 | FCE | Futures | 3589.6 | 3604.8 | 3584.4 | 3600.0 | 58322.0 |
| 2014-05-27 | FDAX | Futures | 10916.1 | 10993.4 | 10912.8 | 10978.5 | 75408.0 |
| 2014-05-27 | FESX | Futures | 2319.6 | 2331.1 | 2316.0 | 2325.3 | 624844.0 |
| 2014-05-27 | FGBL | Futures | 126.01 | 126.46 | 125.9 | 126.34 | 545438.0 |
| 2014-05-27 | FGBM | Futures | 120.8 | 121.0 | 120.76 | 120.95 | 420429.0 |
| 2014-05-27 | FGBS | Futures | 110.748 | 110.768 | 110.743 | 110.753 | 297189.0 |
| 2014-05-27 | FGBX | Futures | 130.73 | 131.56 | 130.36 | 131.28 | 19080.0 |
| 2014-05-27 | FMWO | Futures | 5675.6 | 5686.9 | 5673.0 | 5673.0 | 187.0 |
| 2014-05-27 | FOAT | Futures | 115.36 | 115.84 | 115.31 | 115.73 | 55697.0 |
| 2014-05-27 | FTDX | Futures | 1195.3 | 1207.0 | 1195.3 | 1204.2 | 86.0 |
| 2014-05-27 | FTI | Futures | 351.1 | 352.1 | 350.58 | 351.32 | 15496.0 |
| 2014-05-27 | FTUK | Futures | 5195.4 | 5220.5 | 5195.4 | 5207.6 | 62789.0 |
| 2014-05-27 | FVSA | Futures | 1559.66 | 1583.01 | 1550.32 | 1569.0 | 7080.0 |
| 2014-05-27 | FXXP | Futures | 257.6 | 258.3 | 257.3 | 257.7 | 13867.0 |
| 2014-05-27 | G | Futures | 93.76 | 93.93 | 93.68 | 93.81 | 377071.0 |
| 2014-05-27 | GF | Futures | 296.557 | 297.783 | 296.289 | 296.557 | 1604.0 |
| 2014-05-27 | GSCI | Futures | 1088.28 | 1088.28 | 1084.39 | 1085.88 | 98.0 |
| 2014-05-27 | HE | Futures | 130.963 | 131.102 | 129.121 | 130.014 | 8460.0 |
| 2014-05-27 | HG | Futures | 4.0448 | 4.0793 | 4.0429 | 4.0602 | 37956.0 |
| 2014-05-27 | HH | Futures | 55.383 | 57.183 | 55.345 | 57.183 | 616.0 |
| 2014-05-27 | HO | Futures | 2.3588 | 2.3688 | 2.3461 | 2.3485 | 6695.0 |
> showing 50 of 104 rows — these rows as CSV