PREVIEW / futures_daily / 2015-04-06
file: by_date/futures_daily/2015/2015-04-06.parquet size: 8 KB rows: 81
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-04-06 | ES | Futures | 2144.46 | 2187.04 | 2143.67 | 2179.94 | 948447.0 |
| 2015-04-06 | NQ | Futures | 4951.8 | 5056.01 | 4951.22 | 5041.49 | 154026.0 |
| 2015-04-06 | YM | Futures | 17911.3 | 18266.2 | 17907.2 | 18212.0 | 102819.0 |
| 2015-04-06 | CL | Futures | 87.12 | 92.0 | 87.12 | 91.83 | 325282.0 |
| 2015-04-06 | GC | Futures | 1586.7 | 1602.2 | 1586.7 | 1594.5 | 106008.0 |
| 2015-04-06 | ZN | Futures | 123.048572 | 123.166974 | 122.515766 | 122.589767 | 517342.0 |
| 2015-04-06 | A6 | Futures | 0.75043 | 0.75329 | 0.74461 | 0.74905 | 47033.0 |
| 2015-04-06 | AD | Futures | 0.81894 | 0.82026 | 0.81567 | 0.81822 | 36546.0 |
| 2015-04-06 | ALI | Futures | 2613.9 | 2613.9 | 2613.9 | 2613.9 | 0.0 |
| 2015-04-06 | B | Futures | 54.23 | 57.34 | 54.23 | 57.21 | 90386.0 |
| 2015-04-06 | B6 | Futures | 1.5704 | 1.5762 | 1.5646 | 1.5698 | 41741.0 |
| 2015-04-06 | BR | Futures | 0.18163 | 0.18226 | 0.17964 | 0.18081 | 14.0 |
| 2015-04-06 | BZ | Futures | 54.0 | 56.81 | 54.0 | 56.71 | 11648.0 |
| 2015-04-06 | CB | Futures | 145.666 | 146.051 | 145.666 | 145.666 | 3.0 |
| 2015-04-06 | CC | Futures | 2043.0 | 2069.0 | 2029.0 | 2064.0 | 7525.0 |
| 2015-04-06 | CSC | Futures | 4.303 | 4.319 | 4.287 | 4.295 | 7.0 |
| 2015-04-06 | CT | Futures | 81.83 | 83.9 | 81.71 | 83.75 | 19047.0 |
| 2015-04-06 | DC | Futures | 35.0 | 35.16 | 34.86 | 35.07 | 46.0 |
| 2015-04-06 | DX | Futures | 90.925 | 91.507 | 90.601 | 91.043 | 31131.0 |
| 2015-04-06 | E1 | Futures | 1.34195 | 1.34539 | 1.33036 | 1.33673 | 10843.0 |
| 2015-04-06 | E6 | Futures | 1.29434 | 1.29905 | 1.28411 | 1.29199 | 108231.0 |
| 2015-04-06 | E7 | Futures | 1.2867 | 1.2915 | 1.2767 | 1.2845 | 4009.0 |
| 2015-04-06 | ED | Futures | 95.5477 | 95.5525 | 95.5381 | 95.5429 | 103279.0 |
| 2015-04-06 | ER | Futures | 98.048 | 98.048 | 98.048 | 98.048 | 0.0 |
| 2015-04-06 | EW | Futures | 1576.7 | 1609.7 | 1576.7 | 1606.6 | 17677.0 |
| 2015-04-06 | GF | Futures | 376.66 | 377.932 | 372.503 | 372.885 | 1779.0 |
| 2015-04-06 | GSCI | Futures | 698.69 | 712.82 | 698.69 | 710.75 | 34.0 |
| 2015-04-06 | HE | Futures | 79.347 | 80.07 | 79.26 | 80.041 | 177.0 |
| 2015-04-06 | HG | Futures | 3.4705 | 3.5969 | 3.4222 | 3.452 | 35735.0 |
| 2015-04-06 | HH | Futures | 33.151 | 33.151 | 32.497 | 32.694 | 1838.0 |
| 2015-04-06 | HO | Futures | 1.3739 | 1.4491 | 1.3738 | 1.4399 | 17974.0 |
| 2015-04-06 | HRC | Futures | 1898.1 | 1898.1 | 1877.9 | 1877.9 | 68.0 |
| 2015-04-06 | J1 | Futures | 0.0105281 | 0.0105343 | 0.0104555 | 0.0104855 | 67775.0 |
| 2015-04-06 | J7 | Futures | 0.010528 | 0.010531 | 0.010454 | 0.010483 | 547.0 |
| 2015-04-06 | JB | Futures | 133.86 | 134.09 | 133.86 | 133.97 | 743.0 |
| 2015-04-06 | KC | Futures | 235.84 | 246.64 | 234.67 | 244.71 | 23686.0 |
| 2015-04-06 | KE | Futures | 1857.25 | 1876.35 | 1816.67 | 1820.64 | 11225.0 |
| 2015-04-06 | LBS | Futures | 439.9 | 441.6 | 431.1 | 434.0 | 372.0 |
| 2015-04-06 | LE | Futures | 194.093 | 195.197 | 191.316 | 191.506 | 23182.0 |
| 2015-04-06 | MFS | Futures | 1848.6 | 1876.3 | 1848.6 | 1867.4 | 7247.0 |
| 2015-04-06 | MGC | Futures | 1555.4 | 1573.7 | 1555.4 | 1566.5 | 1175.0 |
| 2015-04-06 | MME | Futures | 989.1 | 1003.5 | 983.7 | 998.6 | 26667.0 |
| 2015-04-06 | MP | Futures | 0.04164 | 0.0417 | 0.04118 | 0.04132 | 33535.0 |
| 2015-04-06 | N6 | Futures | 0.69204 | 0.69443 | 0.68498 | 0.69012 | 9447.0 |
| 2015-04-06 | NG | Futures | 46.039 | 46.331 | 45.215 | 45.507 | 70629.0 |
| 2015-04-06 | NIY | Futures | 16314.4 | 16546.3 | 16242.7 | 16516.8 | 23913.0 |
| 2015-04-06 | NKD | Futures | 17762.8 | 18019.6 | 17684.9 | 17987.5 | 10227.0 |
| 2015-04-06 | NOK | Futures | 0.133339 | 0.133657 | 0.133042 | 0.13336 | 4.0 |
| 2015-04-06 | OJ | Futures | 104.18 | 104.3 | 99.38 | 100.69 | 1319.0 |
| 2015-04-06 | PA | Futures | 806.87 | 839.23 | 805.52 | 829.31 | 3813.0 |
> showing 50 of 81 rows — these rows as CSV