PREVIEW / futures_daily / 2012-02-10
file: by_date/futures_daily/2012/2012-02-10.parquet size: 9 KB rows: 98
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-02-10 | ES | Futures | 1352.81 | 1353.06 | 1338.51 | 1345.28 | 1713982.0 |
| 2012-02-10 | NQ | Futures | 2929.04 | 2929.04 | 2899.3 | 2914.46 | 228662.0 |
| 2012-02-10 | YM | Futures | 12418.2 | 12419.2 | 12285.7 | 12346.6 | 93783.0 |
| 2012-02-10 | CL | Futures | 186.69 | 186.69 | 181.88 | 184.41 | 307564.0 |
| 2012-02-10 | GC | Futures | 2318.2 | 2326.3 | 2285.1 | 2310.4 | 178134.0 |
| 2012-02-10 | ZN | Futures | 113.084237 | 113.637844 | 113.070735 | 113.543325 | 1023383.0 |
| 2012-02-10 | A6 | Futures | 0.95587 | 0.95614 | 0.94279 | 0.94502 | 112309.0 |
| 2012-02-10 | AD | Futures | 1.00784 | 1.00804 | 0.99901 | 1.00061 | 88903.0 |
| 2012-02-10 | B | Futures | 105.19 | 105.19 | 103.14 | 103.98 | 165238.0 |
| 2012-02-10 | B6 | Futures | 1.6531 | 1.6564 | 1.6438 | 1.6449 | 79641.0 |
| 2012-02-10 | BFX | Futures | 2727.6 | 2727.6 | 2726.9 | 2726.9 | 1.0 |
| 2012-02-10 | BR | Futures | 0.26999 | 0.27046 | 0.26978 | 0.27014 | 745.0 |
| 2012-02-10 | BZ | Futures | 110.46 | 111.08 | 109.93 | 110.81 | 623.0 |
| 2012-02-10 | C | Futures | 1463.0 | 1470.0 | 1431.0 | 1439.0 | 6388.0 |
| 2012-02-10 | CC | Futures | 1694.0 | 1700.0 | 1631.0 | 1644.0 | 16365.0 |
| 2012-02-10 | CSC | Futures | 3.744 | 3.747 | 3.744 | 3.744 | 6.0 |
| 2012-02-10 | CT | Futures | 117.36 | 117.8 | 115.9 | 116.7 | 14630.0 |
| 2012-02-10 | DC | Futures | 26.13 | 26.46 | 26.04 | 26.23 | 287.0 |
| 2012-02-10 | DX | Futures | 76.556 | 77.199 | 76.556 | 77.112 | 28260.0 |
| 2012-02-10 | E1 | Futures | 1.44035 | 1.44245 | 1.42722 | 1.43116 | 30981.0 |
| 2012-02-10 | E6 | Futures | 1.58832 | 1.58879 | 1.57266 | 1.57445 | 246746.0 |
| 2012-02-10 | E7 | Futures | 1.5737 | 1.5742 | 1.5583 | 1.5601 | 4090.0 |
| 2012-02-10 | EBM | Futures | 277.14 | 279.11 | 274.52 | 275.83 | 10011.0 |
| 2012-02-10 | ED | Futures | 95.1154 | 95.1154 | 95.0868 | 95.1059 | 229527.0 |
| 2012-02-10 | ER | Futures | 97.444 | 97.459 | 97.42 | 97.43 | 111104.0 |
| 2012-02-10 | EW | Futures | 980.7 | 981.0 | 966.0 | 970.8 | 19133.0 |
| 2012-02-10 | FBTP | Futures | 65.53 | 65.55 | 64.57 | 64.76 | 14439.0 |
| 2012-02-10 | FBTS | Futures | 84.657 | 84.737 | 84.16 | 84.328 | 1815.0 |
| 2012-02-10 | FCE | Futures | 2430.3 | 2430.6 | 2393.6 | 2401.1 | 88688.0 |
| 2012-02-10 | FDAX | Futures | 7470.7 | 7476.2 | 7344.8 | 7396.1 | 154106.0 |
| 2012-02-10 | FESX | Futures | 1680.7 | 1681.4 | 1651.3 | 1659.3 | 1054953.0 |
| 2012-02-10 | FEU3 | Futures | 97.994 | 97.994 | 97.984 | 97.984 | 10.0 |
| 2012-02-10 | FGBL | Futures | 111.24 | 112.31 | 111.16 | 111.86 | 722635.0 |
| 2012-02-10 | FGBM | Futures | 112.8 | 113.33 | 112.72 | 113.09 | 402431.0 |
| 2012-02-10 | FGBS | Futures | 109.77 | 109.845 | 109.745 | 109.795 | 348791.0 |
| 2012-02-10 | FGBX | Futures | 114.2 | 116.21 | 113.73 | 115.46 | 6472.0 |
| 2012-02-10 | FTDX | Futures | 712.5 | 721.3 | 710.6 | 714.3 | 183.0 |
| 2012-02-10 | FTI | Futures | 271.18 | 271.18 | 267.4 | 268.03 | 375.0 |
| 2012-02-10 | FTUK | Futures | 4222.0 | 4225.2 | 4179.4 | 4187.4 | 95362.0 |
| 2012-02-10 | FVSA | Futures | 10563.46 | 10851.56 | 10429.02 | 10813.15 | 3250.0 |
| 2012-02-10 | FXXP | Futures | 185.1 | 185.3 | 183.8 | 184.3 | 942.0 |
| 2012-02-10 | G | Futures | 93.32 | 94.04 | 93.25 | 93.79 | 128300.0 |
| 2012-02-10 | GF | Futures | 329.029 | 329.347 | 325.0 | 325.795 | 3756.0 |
| 2012-02-10 | GSCI | Futures | 1060.69 | 1064.55 | 1055.49 | 1063.05 | 1671.0 |
| 2012-02-10 | HE | Futures | 108.341 | 108.401 | 106.71 | 106.71 | 13951.0 |
| 2012-02-10 | HG | Futures | 5.241 | 5.2476 | 5.0682 | 5.094 | 63982.0 |
| 2012-02-10 | HO | Futures | 2.6059 | 2.6059 | 2.5695 | 2.5752 | 64732.0 |
| 2012-02-10 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-10 | J1 | Futures | 0.016174 | 0.0162041 | 0.0161414 | 0.0161878 | 76495.0 |
| 2012-02-10 | J7 | Futures | 0.016106 | 0.016133 | 0.016073 | 0.016121 | 298.0 |
> showing 50 of 98 rows — these rows as CSV