PREVIEW / futures_daily / 2013-05-29
file: by_date/futures_daily/2013/2013-05-29.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-05-29 | ES | Futures | 1698.35 | 1700.92 | 1681.67 | 1690.91 | 2129262.0 |
| 2013-05-29 | NQ | Futures | 3470.76 | 3475.38 | 3440.15 | 3460.07 | 242455.0 |
| 2013-05-29 | YM | Futures | 15133.9 | 15154.6 | 14976.4 | 15056.1 | 192421.0 |
| 2013-05-29 | CL | Futures | 165.76 | 166.05 | 161.88 | 162.41 | 293461.0 |
| 2013-05-29 | GC | Futures | 1833.2 | 1852.4 | 1831.6 | 1847.6 | 131116.0 |
| 2013-05-29 | ZN | Futures | 115.917532 | 116.265382 | 115.402714 | 116.181898 | 3416985.0 |
| 2013-05-29 | A6 | Futures | 0.88565 | 0.89147 | 0.87827 | 0.88796 | 139510.0 |
| 2013-05-29 | AD | Futures | 0.96557 | 0.9712 | 0.96367 | 0.96949 | 87588.0 |
| 2013-05-29 | B | Futures | 100.5 | 100.69 | 98.61 | 98.85 | 86954.0 |
| 2013-05-29 | B6 | Futures | 1.5735 | 1.5848 | 1.5702 | 1.5824 | 131320.0 |
| 2013-05-29 | BFX | Futures | 3227.3 | 3227.3 | 3224.6 | 3224.6 | 1.0 |
| 2013-05-29 | BR | Futures | 0.23079 | 0.23079 | 0.23079 | 0.23079 | 2629.0 |
| 2013-05-29 | BZ | Futures | 100.97 | 101.19 | 99.15 | 99.34 | 6136.0 |
| 2013-05-29 | C | Futures | 1613.0 | 1617.0 | 1607.0 | 1614.0 | 6632.0 |
| 2013-05-29 | CB | Futures | 79.651 | 79.77 | 79.459 | 79.758 | 19.0 |
| 2013-05-29 | CC | Futures | 1654.0 | 1664.0 | 1643.0 | 1657.0 | 13607.0 |
| 2013-05-29 | CNH | Futures | 7.1545 | 7.1637 | 7.1545 | 7.1584 | 64.0 |
| 2013-05-29 | CSC | Futures | 3.56 | 3.576 | 3.559 | 3.559 | 23.0 |
| 2013-05-29 | CT | Futures | 97.82 | 97.93 | 96.61 | 96.72 | 14106.0 |
| 2013-05-29 | DC | Futures | 27.13 | 27.36 | 27.13 | 27.23 | 51.0 |
| 2013-05-29 | DX | Futures | 81.101 | 81.144 | 80.289 | 80.447 | 47176.0 |
| 2013-05-29 | E1 | Futures | 1.31754 | 1.34018 | 1.31406 | 1.33555 | 55833.0 |
| 2013-05-29 | E6 | Futures | 1.51566 | 1.53028 | 1.51366 | 1.52509 | 307771.0 |
| 2013-05-29 | E7 | Futures | 1.5054 | 1.5202 | 1.5039 | 1.5151 | 4382.0 |
| 2013-05-29 | ED | Futures | 95.2659 | 95.2707 | 95.2611 | 95.2635 | 222438.0 |
| 2013-05-29 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.827 | 80053.0 |
| 2013-05-29 | EW | Futures | 1215.5 | 1217.8 | 1199.8 | 1211.1 | 19863.0 |
| 2013-05-29 | FBTP | Futures | 79.17 | 79.2 | 78.46 | 78.61 | 43358.0 |
| 2013-05-29 | FBTS | Futures | 92.954 | 92.954 | 92.732 | 92.766 | 15450.0 |
| 2013-05-29 | FCE | Futures | 3113.0 | 3114.2 | 3063.9 | 3070.1 | 123648.0 |
| 2013-05-29 | FDAX | Futures | 9385.0 | 9395.0 | 9246.1 | 9269.4 | 123983.0 |
| 2013-05-29 | FESX | Futures | 1971.4 | 1972.8 | 1943.4 | 1946.9 | 1018645.0 |
| 2013-05-29 | FEU3 | Futures | 98.428 | 98.428 | 98.428 | 98.428 | 100.0 |
| 2013-05-29 | FGBL | Futures | 120.1 | 120.46 | 120.06 | 120.2 | 1058098.0 |
| 2013-05-29 | FGBM | Futures | 117.39 | 117.59 | 117.35 | 117.44 | 781828.0 |
| 2013-05-29 | FGBS | Futures | 110.407 | 110.442 | 110.357 | 110.387 | 584321.0 |
| 2013-05-29 | FGBX | Futures | 124.84 | 125.68 | 124.84 | 125.3 | 18174.0 |
| 2013-05-29 | FMWO | Futures | 4853.4 | 4853.4 | 4853.4 | 4853.4 | 0.0 |
| 2013-05-29 | FOAT | Futures | 108.13 | 108.28 | 107.85 | 107.97 | 63669.0 |
| 2013-05-29 | FTDX | Futures | 925.0 | 925.0 | 914.1 | 914.1 | 75.0 |
| 2013-05-29 | FTI | Futures | 321.66 | 321.88 | 318.05 | 318.75 | 28247.0 |
| 2013-05-29 | FTUK | Futures | 4996.8 | 4996.8 | 4905.8 | 4915.1 | 115345.0 |
| 2013-05-29 | FVSA | Futures | 2921.98 | 3036.41 | 2921.98 | 3028.78 | 7014.0 |
| 2013-05-29 | FXXP | Futures | 224.9 | 224.9 | 221.8 | 222.1 | 4950.0 |
| 2013-05-29 | G | Futures | 97.83 | 97.91 | 97.41 | 97.68 | 179790.0 |
| 2013-05-29 | GF | Futures | 245.067 | 246.541 | 244.73 | 245.362 | 2225.0 |
| 2013-05-29 | GSCI | Futures | 1018.14 | 1021.21 | 1008.34 | 1009.06 | 109.0 |
| 2013-05-29 | HE | Futures | 92.702 | 93.585 | 92.58 | 92.923 | 8281.0 |
| 2013-05-29 | HG | Futures | 4.2169 | 4.2348 | 4.1685 | 4.2004 | 51073.0 |
| 2013-05-29 | HH | Futures | 46.833 | 47.024 | 46.26 | 47.013 | 1272.0 |
> showing 50 of 104 rows — these rows as CSV