PREVIEW / futures_daily / 2012-06-29
file: by_date/futures_daily/2012/2012-06-29.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-29 | ES | Futures | 1338.82 | 1376.79 | 1332.74 | 1373.75 | 2488982.0 |
| 2012-06-29 | NQ | Futures | 2901.83 | 3002.84 | 2890.93 | 2995.37 | 252211.0 |
| 2012-06-29 | YM | Futures | 12156.3 | 12451.2 | 12106.8 | 12426.0 | 143928.0 |
| 2012-06-29 | CL | Futures | 143.09 | 155.63 | 142.76 | 154.94 | 439010.0 |
| 2012-06-29 | GC | Futures | 2074.4 | 2149.3 | 2073.8 | 2144.5 | 190835.0 |
| 2012-06-29 | ZN | Futures | 116.685793 | 116.821981 | 116.032091 | 116.249992 | 1187188.0 |
| 2012-06-29 | A6 | Futures | 0.89667 | 0.91582 | 0.89451 | 0.91438 | 194650.0 |
| 2012-06-29 | AD | Futures | 0.96852 | 0.98466 | 0.96781 | 0.98416 | 154955.0 |
| 2012-06-29 | B | Futures | 82.77 | 88.35 | 82.56 | 87.93 | 141019.0 |
| 2012-06-29 | B6 | Futures | 1.6217 | 1.6422 | 1.6206 | 1.6384 | 132492.0 |
| 2012-06-29 | BFX | Futures | 2609.2 | 2673.6 | 2609.2 | 2672.4 | 84.0 |
| 2012-06-29 | BR | Futures | 0.22668 | 0.23539 | 0.22668 | 0.23499 | 69.0 |
| 2012-06-29 | BZ | Futures | 89.42 | 94.21 | 89.42 | 94.21 | 1709.0 |
| 2012-06-29 | C | Futures | 1589.0 | 1615.0 | 1577.0 | 1613.0 | 5533.0 |
| 2012-06-29 | CC | Futures | 1695.0 | 1738.0 | 1680.0 | 1726.0 | 23148.0 |
| 2012-06-29 | CSC | Futures | 3.845 | 3.845 | 3.834 | 3.845 | 22.0 |
| 2012-06-29 | CT | Futures | 91.86 | 95.17 | 91.86 | 94.28 | 179.0 |
| 2012-06-29 | DC | Futures | 28.17 | 28.2 | 27.79 | 28.17 | 111.0 |
| 2012-06-29 | DX | Futures | 80.449 | 80.469 | 79.163 | 79.351 | 40494.0 |
| 2012-06-29 | E1 | Futures | 1.34035 | 1.36708 | 1.33945 | 1.36359 | 66168.0 |
| 2012-06-29 | E6 | Futures | 1.46873 | 1.49845 | 1.46778 | 1.49432 | 388212.0 |
| 2012-06-29 | E7 | Futures | 1.4591 | 1.489 | 1.4587 | 1.485 | 5347.0 |
| 2012-06-29 | ED | Futures | 95.1083 | 95.1274 | 95.1035 | 95.1083 | 166137.0 |
| 2012-06-29 | ER | Futures | 97.597 | 97.611 | 97.587 | 97.607 | 88152.0 |
| 2012-06-29 | EW | Futures | 924.8 | 955.0 | 921.4 | 952.2 | 29214.0 |
| 2012-06-29 | FBTP | Futures | 64.54 | 66.33 | 64.54 | 65.97 | 29288.0 |
| 2012-06-29 | FBTS | Futures | 84.451 | 85.435 | 84.318 | 85.302 | 6395.0 |
| 2012-06-29 | FCE | Futures | 2315.4 | 2373.5 | 2302.4 | 2363.9 | 170795.0 |
| 2012-06-29 | FDAX | Futures | 6867.3 | 7029.4 | 6838.9 | 7000.0 | 170483.0 |
| 2012-06-29 | FESX | Futures | 1494.6 | 1534.5 | 1484.5 | 1525.1 | 1925332.0 |
| 2012-06-29 | FGBL | Futures | 116.17 | 116.49 | 115.41 | 116.38 | 857826.0 |
| 2012-06-29 | FGBM | Futures | 114.83 | 115.09 | 114.51 | 114.98 | 481519.0 |
| 2012-06-29 | FGBS | Futures | 110.108 | 110.158 | 110.014 | 110.133 | 372901.0 |
| 2012-06-29 | FGBX | Futures | 123.03 | 123.14 | 119.74 | 123.03 | 8586.0 |
| 2012-06-29 | FOAT | Futures | 98.19 | 98.19 | 97.7 | 98.03 | 14670.0 |
| 2012-06-29 | FTDX | Futures | 682.6 | 691.4 | 682.1 | 689.1 | 136.0 |
| 2012-06-29 | FTI | Futures | 259.14 | 262.28 | 256.71 | 261.26 | 47294.0 |
| 2012-06-29 | FTUK | Futures | 3978.0 | 4061.3 | 3973.6 | 4020.9 | 141480.0 |
| 2012-06-29 | FVSA | Futures | 8290.5 | 8290.5 | 7777.99 | 7898.58 | 2934.0 |
| 2012-06-29 | FXXP | Futures | 178.3 | 179.6 | 177.2 | 179.3 | 976.0 |
| 2012-06-29 | G | Futures | 98.51 | 98.75 | 97.78 | 98.49 | 170625.0 |
| 2012-06-29 | GF | Futures | 297.125 | 299.197 | 295.2 | 298.901 | 3632.0 |
| 2012-06-29 | GSCI | Futures | 917.39 | 953.83 | 917.39 | 953.83 | 362.0 |
| 2012-06-29 | HE | Futures | 101.688 | 102.056 | 100.925 | 101.714 | 9274.0 |
| 2012-06-29 | HG | Futures | 4.3067 | 4.5283 | 4.29 | 4.5045 | 75839.0 |
| 2012-06-29 | HO | Futures | 2.0954 | 2.223 | 2.0954 | 2.217 | 25446.0 |
| 2012-06-29 | HRC | Futures | 2429.9 | 2429.9 | 2429.9 | 2429.9 | 0.0 |
| 2012-06-29 | J1 | Futures | 0.015794 | 0.0158566 | 0.0156824 | 0.0157088 | 113206.0 |
| 2012-06-29 | J7 | Futures | 0.01575 | 0.015791 | 0.015623 | 0.015647 | 416.0 |
| 2012-06-29 | JB | Futures | 126.28 | 126.31 | 126.06 | 126.1 | 2439.0 |
> showing 50 of 97 rows — these rows as CSV