PREVIEW / futures_daily / 2015-12-09
file: by_date/futures_daily/2015/2015-12-09.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 |
|---|---|---|---|---|---|---|---|
| 2015-12-09 | ES | Futures | 2190.8 | 2212.34 | 2163.94 | 2172.18 | 2690846.0 |
| 2015-12-09 | NQ | Futures | 5484.17 | 5504.05 | 5370.47 | 5397.07 | 388709.0 |
| 2015-12-09 | YM | Futures | 18099.4 | 18326.4 | 17943.6 | 18010.7 | 244069.0 |
| 2015-12-09 | CL | Futures | 58.48 | 60.22 | 56.95 | 57.39 | 646166.0 |
| 2015-12-09 | GC | Futures | 1385.5 | 1399.3 | 1378.3 | 1388.3 | 140705.0 |
| 2015-12-09 | ZN | Futures | 121.716421 | 122.032294 | 121.400548 | 121.942045 | 1155916.0 |
| 2015-12-09 | A6 | Futures | 0.72183 | 0.72453 | 0.71713 | 0.72103 | 147975.0 |
| 2015-12-09 | AD | Futures | 0.75417 | 0.75775 | 0.75202 | 0.75335 | 112734.0 |
| 2015-12-09 | ALI | Futures | 2145.34 | 2145.34 | 2145.34 | 2145.34 | 0.0 |
| 2015-12-09 | B | Futures | 35.68 | 36.42 | 34.69 | 35.16 | 267927.0 |
| 2015-12-09 | B6 | Futures | 1.5808 | 1.6 | 1.5801 | 1.597 | 149244.0 |
| 2015-12-09 | BFX | Futures | 4393.6 | 4393.6 | 4359.0 | 4359.0 | 5.0 |
| 2015-12-09 | BR | Futures | 0.16283 | 0.1651 | 0.16173 | 0.16447 | 366.0 |
| 2015-12-09 | BZ | Futures | 35.45 | 36.07 | 34.38 | 34.84 | 30784.0 |
| 2015-12-09 | C | Futures | 2407.0 | 2417.0 | 2401.0 | 2414.0 | 5421.0 |
| 2015-12-09 | CB | Futures | 241.331 | 241.331 | 239.97 | 239.97 | 10.0 |
| 2015-12-09 | CC | Futures | 2449.0 | 2494.0 | 2449.0 | 2485.0 | 16360.0 |
| 2015-12-09 | CNH | Futures | 7.2042 | 7.2372 | 7.2042 | 7.2194 | 6.0 |
| 2015-12-09 | CSC | Futures | 3.966 | 3.966 | 3.944 | 3.944 | 99.0 |
| 2015-12-09 | CT | Futures | 75.48 | 76.41 | 75.0 | 75.92 | 20802.0 |
| 2015-12-09 | DC | Futures | 31.76 | 31.76 | 31.54 | 31.61 | 103.0 |
| 2015-12-09 | DX | Futures | 92.109 | 92.133 | 90.917 | 91.033 | 49354.0 |
| 2015-12-09 | E1 | Futures | 1.27833 | 1.29203 | 1.27567 | 1.29038 | 42968.0 |
| 2015-12-09 | E6 | Futures | 1.27628 | 1.29373 | 1.27452 | 1.29174 | 446556.0 |
| 2015-12-09 | E7 | Futures | 1.2692 | 1.2866 | 1.2675 | 1.2846 | 8507.0 |
| 2015-12-09 | EBM | Futures | 249.31 | 252.49 | 248.25 | 250.01 | 21775.0 |
| 2015-12-09 | ED | Futures | 95.603 | 95.6174 | 95.603 | 95.6126 | 287410.0 |
| 2015-12-09 | ER | Futures | 98.21 | 98.215 | 98.205 | 98.205 | 63810.0 |
| 2015-12-09 | EW | Futures | 1499.0 | 1513.2 | 1479.1 | 1479.9 | 30348.0 |
| 2015-12-09 | FBON | Futures | 116.58 | 116.63 | 116.27 | 116.27 | 252.0 |
| 2015-12-09 | FBTP | Futures | 104.95 | 105.06 | 104.63 | 104.68 | 61825.0 |
| 2015-12-09 | FBTS | Futures | 100.677 | 100.677 | 100.597 | 100.606 | 15693.0 |
| 2015-12-09 | FCE | Futures | 3917.3 | 3941.2 | 3819.6 | 3875.1 | 108708.0 |
| 2015-12-09 | FDAX | Futures | 11772.5 | 11806.1 | 11506.5 | 11686.1 | 122274.0 |
| 2015-12-09 | FDXM | Futures | 10994.9 | 11031.9 | 10752.0 | 10917.7 | 22261.0 |
| 2015-12-09 | FESX | Futures | 2475.5 | 2486.0 | 2420.0 | 2460.5 | 1790586.0 |
| 2015-12-09 | FEU3 | Futures | 98.863 | 98.863 | 98.858 | 98.858 | 2.0 |
| 2015-12-09 | FGBL | Futures | 139.91 | 139.99 | 139.38 | 139.49 | 508016.0 |
| 2015-12-09 | FGBM | Futures | 125.62 | 125.72 | 125.56 | 125.61 | 417166.0 |
| 2015-12-09 | FGBS | Futures | 111.393 | 111.418 | 111.373 | 111.398 | 241219.0 |
| 2015-12-09 | FGBX | Futures | 158.3 | 158.58 | 156.67 | 156.94 | 34725.0 |
| 2015-12-09 | FMWO | Futures | 5573.0 | 5628.6 | 5573.0 | 5607.6 | 1171.0 |
| 2015-12-09 | FOAT | Futures | 128.44 | 128.53 | 127.99 | 128.09 | 65395.0 |
| 2015-12-09 | FTDX | Futures | 1750.1 | 1756.7 | 1716.9 | 1740.1 | 158.0 |
| 2015-12-09 | FTI | Futures | 384.61 | 386.69 | 377.79 | 382.96 | 39117.0 |
| 2015-12-09 | FTUK | Futures | 4940.0 | 4965.3 | 4863.6 | 4933.5 | 126957.0 |
| 2015-12-09 | FVSA | Futures | 2181.66 | 2333.1 | 2162.73 | 2219.52 | 7506.0 |
| 2015-12-09 | FXXP | Futures | 285.1 | 286.4 | 279.5 | 283.9 | 43281.0 |
| 2015-12-09 | G | Futures | 104.86 | 104.88 | 104.26 | 104.36 | 164259.0 |
| 2015-12-09 | GF | Futures | 293.402 | 296.683 | 288.286 | 290.748 | 6495.0 |
> showing 50 of 110 rows — these rows as CSV