PREVIEW / futures_daily / 2016-03-30
file: by_date/futures_daily/2016/2016-03-30.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-03-30 | ES | Futures | 2199.51 | 2216.69 | 2197.63 | 2206.76 | 1627085.0 |
| 2016-03-30 | NQ | Futures | 5241.41 | 5299.58 | 5236.42 | 5266.38 | 222490.0 |
| 2016-03-30 | YM | Futures | 18240.4 | 18397.4 | 18233.1 | 18322.5 | 121178.0 |
| 2016-03-30 | CL | Futures | 46.76 | 48.37 | 46.3 | 46.52 | 542469.0 |
| 2016-03-30 | GC | Futures | 1602.1 | 1607.0 | 1578.8 | 1583.6 | 183333.0 |
| 2016-03-30 | ZN | Futures | 125.555166 | 125.630602 | 125.238337 | 125.540079 | 1123696.0 |
| 2016-03-30 | A6 | Futures | 0.7699 | 0.77759 | 0.76798 | 0.77385 | 95990.0 |
| 2016-03-30 | AD | Futures | 0.7828 | 0.792 | 0.78177 | 0.78873 | 72360.0 |
| 2016-03-30 | ALI | Futures | 2071.1 | 2071.1 | 2071.1 | 2071.1 | 0.0 |
| 2016-03-30 | B | Futures | 33.42 | 34.44 | 33.21 | 33.35 | 296150.0 |
| 2016-03-30 | B6 | Futures | 1.5154 | 1.5228 | 1.5125 | 1.5151 | 89779.0 |
| 2016-03-30 | BFX | Futures | 3985.1 | 4011.4 | 3985.1 | 4003.8 | 4.0 |
| 2016-03-30 | BR | Futures | 0.17696 | 0.17781 | 0.17605 | 0.17687 | 324.0 |
| 2016-03-30 | BZ | Futures | 33.1 | 34.08 | 32.87 | 33.02 | 24719.0 |
| 2016-03-30 | C | Futures | 2302.0 | 2316.0 | 2288.0 | 2290.0 | 7516.0 |
| 2016-03-30 | CB | Futures | 248.159 | 248.159 | 246.025 | 246.025 | 3.0 |
| 2016-03-30 | CC | Futures | 2186.0 | 2212.0 | 2167.0 | 2178.0 | 17213.0 |
| 2016-03-30 | CNH | Futures | 7.069 | 7.071 | 7.0579 | 7.0579 | 50.0 |
| 2016-03-30 | CSC | Futures | 3.625 | 3.654 | 3.625 | 3.644 | 22.0 |
| 2016-03-30 | CT | Futures | 65.8 | 66.52 | 65.79 | 66.23 | 15046.0 |
| 2016-03-30 | DC | Futures | 28.42 | 28.82 | 28.42 | 28.73 | 161.0 |
| 2016-03-30 | DX | Futures | 88.742 | 88.775 | 88.16 | 88.401 | 26869.0 |
| 2016-03-30 | E1 | Futures | 1.30434 | 1.31414 | 1.30359 | 1.30761 | 24120.0 |
| 2016-03-30 | E6 | Futures | 1.31983 | 1.32852 | 1.31914 | 1.32485 | 213624.0 |
| 2016-03-30 | E7 | Futures | 1.3131 | 1.3214 | 1.3121 | 1.3177 | 4256.0 |
| 2016-03-30 | EBM | Futures | 203.32 | 203.96 | 199.45 | 199.78 | 33667.0 |
| 2016-03-30 | ED | Futures | 95.6967 | 95.7208 | 95.6919 | 95.716 | 282758.0 |
| 2016-03-30 | ER | Futures | 98.259 | 98.264 | 98.254 | 98.259 | 31407.0 |
| 2016-03-30 | EW | Futures | 1524.1 | 1532.6 | 1518.8 | 1523.0 | 18642.0 |
| 2016-03-30 | FBON | Futures | 119.36 | 119.36 | 119.04 | 119.15 | 326.0 |
| 2016-03-30 | FBTP | Futures | 107.87 | 108.21 | 107.86 | 108.03 | 81342.0 |
| 2016-03-30 | FBTS | Futures | 101.024 | 101.042 | 101.006 | 101.024 | 16249.0 |
| 2016-03-30 | FCE | Futures | 3658.0 | 3721.7 | 3653.0 | 3702.6 | 87008.0 |
| 2016-03-30 | FDAX | Futures | 10729.1 | 10891.3 | 10703.4 | 10839.8 | 87151.0 |
| 2016-03-30 | FDXM | Futures | 10333.4 | 10486.5 | 10308.5 | 10436.8 | 17401.0 |
| 2016-03-30 | FESX | Futures | 2298.6 | 2330.6 | 2292.4 | 2315.0 | 1124706.0 |
| 2016-03-30 | FEU3 | Futures | 98.907 | 98.907 | 98.907 | 98.907 | 7.0 |
| 2016-03-30 | FGBL | Futures | 146.39 | 146.54 | 145.91 | 146.02 | 540365.0 |
| 2016-03-30 | FGBM | Futures | 127.51 | 127.55 | 127.4 | 127.45 | 432349.0 |
| 2016-03-30 | FGBS | Futures | 111.643 | 111.643 | 111.623 | 111.633 | 149812.0 |
| 2016-03-30 | FGBX | Futures | 174.69 | 174.96 | 173.0 | 173.29 | 32709.0 |
| 2016-03-30 | FMWO | Futures | 5609.1 | 5621.6 | 5604.2 | 5609.1 | 962.0 |
| 2016-03-30 | FOAT | Futures | 134.08 | 134.22 | 133.69 | 133.83 | 58913.0 |
| 2016-03-30 | FTDX | Futures | 1532.3 | 1558.0 | 1532.3 | 1549.9 | 256.0 |
| 2016-03-30 | FTI | Futures | 392.38 | 398.06 | 391.67 | 395.62 | 30588.0 |
| 2016-03-30 | FTUK | Futures | 5027.1 | 5086.5 | 5022.6 | 5073.3 | 117149.0 |
| 2016-03-30 | FVSA | Futures | 2666.82 | 2677.87 | 2589.52 | 2600.57 | 20455.0 |
| 2016-03-30 | FXXP | Futures | 266.9 | 270.1 | 266.7 | 269.0 | 31849.0 |
| 2016-03-30 | G | Futures | 108.79 | 108.92 | 108.26 | 108.35 | 148110.0 |
| 2016-03-30 | GF | Futures | 307.195 | 307.244 | 298.066 | 299.538 | 3358.0 |
> showing 50 of 110 rows — these rows as CSV