PREVIEW / futures_daily / 2015-03-25
file: by_date/futures_daily/2015/2015-03-25.parquet size: 9 KB rows: 107
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-03-25 | ES | Futures | 2192.56 | 2196.77 | 2157.86 | 2159.44 | 1777447.0 |
| 2015-03-25 | NQ | Futures | 5142.5 | 5153.24 | 5015.66 | 5019.72 | 320355.0 |
| 2015-03-25 | YM | Futures | 18355.2 | 18377.7 | 18031.0 | 18052.4 | 162709.0 |
| 2015-03-25 | CL | Futures | 84.04 | 87.11 | 82.77 | 86.67 | 398795.0 |
| 2015-03-25 | GC | Futures | 1559.2 | 1568.1 | 1550.8 | 1565.1 | 185925.0 |
| 2015-03-25 | ZN | Futures | 122.338164 | 122.560167 | 121.894159 | 122.012561 | 1008392.0 |
| 2015-03-25 | A6 | Futures | 0.77291 | 0.77597 | 0.76857 | 0.76956 | 72969.0 |
| 2015-03-25 | AD | Futures | 0.81618 | 0.81771 | 0.81332 | 0.81485 | 59342.0 |
| 2015-03-25 | ALI | Futures | 2617.43 | 2617.43 | 2617.43 | 2617.43 | 0.0 |
| 2015-03-25 | B | Futures | 54.23 | 56.1 | 53.86 | 55.42 | 160104.0 |
| 2015-03-25 | B6 | Futures | 1.5618 | 1.5732 | 1.5602 | 1.5639 | 88488.0 |
| 2015-03-25 | BFX | Futures | 4550.2 | 4550.2 | 4517.0 | 4520.0 | 5.0 |
| 2015-03-25 | BR | Futures | 0.1769 | 0.1769 | 0.17459 | 0.17493 | 146.0 |
| 2015-03-25 | BZ | Futures | 53.76 | 55.59 | 53.4 | 54.94 | 22109.0 |
| 2015-03-25 | C | Futures | 2125.0 | 2149.0 | 2114.0 | 2132.0 | 7562.0 |
| 2015-03-25 | CB | Futures | 142.814 | 143.219 | 142.814 | 142.814 | 5.0 |
| 2015-03-25 | CC | Futures | 2044.0 | 2082.0 | 2040.0 | 2057.0 | 18383.0 |
| 2015-03-25 | CNH | Futures | 7.0451 | 7.0515 | 7.0451 | 7.0452 | 2.0 |
| 2015-03-25 | CSC | Futures | 4.29 | 4.359 | 4.279 | 4.346 | 21.0 |
| 2015-03-25 | CT | Futures | 81.97 | 82.15 | 80.44 | 80.96 | 13314.0 |
| 2015-03-25 | DC | Futures | 34.73 | 35.36 | 34.5 | 35.29 | 103.0 |
| 2015-03-25 | DX | Futures | 91.578 | 91.606 | 90.775 | 91.265 | 43560.0 |
| 2015-03-25 | E1 | Futures | 1.33329 | 1.33826 | 1.32895 | 1.32934 | 16472.0 |
| 2015-03-25 | E6 | Futures | 1.28576 | 1.2967 | 1.28329 | 1.29023 | 225909.0 |
| 2015-03-25 | E7 | Futures | 1.2777 | 1.2892 | 1.2758 | 1.2828 | 6157.0 |
| 2015-03-25 | EBM | Futures | 308.9 | 309.7 | 306.09 | 306.89 | 14032.0 |
| 2015-03-25 | ED | Futures | 95.5141 | 95.5237 | 95.5094 | 95.5141 | 83904.0 |
| 2015-03-25 | ER | Futures | 98.048 | 98.058 | 98.048 | 98.053 | 30556.0 |
| 2015-03-25 | EW | Futures | 1602.6 | 1604.7 | 1572.5 | 1573.5 | 18350.0 |
| 2015-03-25 | FBTP | Futures | 103.12 | 103.18 | 102.72 | 103.03 | 71721.0 |
| 2015-03-25 | FBTS | Futures | 99.484 | 99.528 | 99.457 | 99.492 | 18997.0 |
| 2015-03-25 | FCE | Futures | 4125.7 | 4139.5 | 4072.4 | 4085.5 | 105095.0 |
| 2015-03-25 | FDAX | Futures | 13302.4 | 13369.0 | 13166.5 | 13230.9 | 109587.0 |
| 2015-03-25 | FESX | Futures | 2685.8 | 2696.9 | 2654.2 | 2667.4 | 980736.0 |
| 2015-03-25 | FEU3 | Futures | 98.7 | 98.7 | 98.695 | 98.695 | 1.0 |
| 2015-03-25 | FGBL | Futures | 140.66 | 140.87 | 140.49 | 140.66 | 454584.0 |
| 2015-03-25 | FGBM | Futures | 124.58 | 124.68 | 124.57 | 124.66 | 325210.0 |
| 2015-03-25 | FGBS | Futures | 111.208 | 111.233 | 111.203 | 111.218 | 150676.0 |
| 2015-03-25 | FGBX | Futures | 176.75 | 178.0 | 176.6 | 176.93 | 21776.0 |
| 2015-03-25 | FMWO | Futures | 5833.5 | 5837.2 | 5794.0 | 5794.0 | 95.0 |
| 2015-03-25 | FOAT | Futures | 129.44 | 129.6 | 129.2 | 129.38 | 56620.0 |
| 2015-03-25 | FTDX | Futures | 1541.0 | 1543.9 | 1511.0 | 1512.9 | 175.0 |
| 2015-03-25 | FTI | Futures | 429.43 | 432.02 | 423.76 | 425.27 | 29197.0 |
| 2015-03-25 | FTUK | Futures | 5485.8 | 5502.3 | 5451.1 | 5476.7 | 83073.0 |
| 2015-03-25 | FVSA | Futures | 1694.01 | 1791.41 | 1685.54 | 1753.3 | 13098.0 |
| 2015-03-25 | FXXP | Futures | 303.6 | 304.3 | 300.5 | 301.7 | 10015.0 |
| 2015-03-25 | G | Futures | 105.87 | 106.16 | 105.66 | 105.84 | 145262.0 |
| 2015-03-25 | GF | Futures | 371.358 | 371.952 | 367.796 | 368.559 | 2149.0 |
| 2015-03-25 | GSCI | Futures | 691.28 | 700.76 | 688.44 | 697.83 | 98.0 |
| 2015-03-25 | HE | Futures | 76.282 | 77.207 | 75.414 | 76.947 | 649.0 |
> showing 50 of 107 rows — these rows as CSV