PREVIEW / futures_daily / 2015-04-02
file: by_date/futures_daily/2015/2015-04-02.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-04-02 | ES | Futures | 2161.02 | 2171.01 | 2149.19 | 2165.49 | 1047174.0 |
| 2015-04-02 | NQ | Futures | 5011.89 | 5016.82 | 4979.09 | 5000.86 | 168845.0 |
| 2015-04-02 | YM | Futures | 18036.1 | 18136.3 | 17953.2 | 18080.1 | 108614.0 |
| 2015-04-02 | CL | Futures | 87.34 | 88.53 | 84.73 | 86.54 | 453394.0 |
| 2015-04-02 | GC | Futures | 1575.8 | 1579.9 | 1563.4 | 1571.4 | 115647.0 |
| 2015-04-02 | ZN | Futures | 122.589767 | 122.87097 | 122.264163 | 122.352964 | 871522.0 |
| 2015-04-02 | A6 | Futures | 0.74648 | 0.74776 | 0.74007 | 0.7451 | 114545.0 |
| 2015-04-02 | AD | Futures | 0.80811 | 0.8123 | 0.80607 | 0.81189 | 51768.0 |
| 2015-04-02 | ALI | Futures | 2613.9 | 2613.9 | 2613.9 | 2613.9 | 0.0 |
| 2015-04-02 | B | Futures | 55.72 | 56.27 | 53.18 | 54.12 | 187638.0 |
| 2015-04-02 | B6 | Futures | 1.5597 | 1.5644 | 1.5545 | 1.5596 | 81625.0 |
| 2015-04-02 | BFX | Futures | 4533.3 | 4554.4 | 4533.3 | 4554.4 | 26.0 |
| 2015-04-02 | BR | Futures | 0.17713 | 0.17972 | 0.17656 | 0.17924 | 485.0 |
| 2015-04-02 | BZ | Futures | 55.22 | 55.74 | 52.76 | 53.65 | 19913.0 |
| 2015-04-02 | C | Futures | 2100.0 | 2125.0 | 2096.0 | 2119.0 | 6163.0 |
| 2015-04-02 | CB | Futures | 145.707 | 145.849 | 145.646 | 145.666 | 15.0 |
| 2015-04-02 | CC | Futures | 2030.0 | 2058.0 | 2028.0 | 2043.0 | 23241.0 |
| 2015-04-02 | CNH | Futures | 7.0236 | 7.0281 | 7.0177 | 7.0177 | 1.0 |
| 2015-04-02 | CSC | Futures | 4.378 | 4.378 | 4.298 | 4.3 | 9.0 |
| 2015-04-02 | CT | Futures | 80.21 | 81.89 | 80.21 | 81.63 | 14049.0 |
| 2015-04-02 | DC | Futures | 35.2 | 35.49 | 34.91 | 34.95 | 71.0 |
| 2015-04-02 | DX | Futures | 92.428 | 92.55 | 91.601 | 91.712 | 40553.0 |
| 2015-04-02 | E1 | Futures | 1.32131 | 1.33673 | 1.32118 | 1.33278 | 17814.0 |
| 2015-04-02 | E6 | Futures | 1.26706 | 1.28364 | 1.2653 | 1.28235 | 225076.0 |
| 2015-04-02 | E7 | Futures | 1.2603 | 1.2762 | 1.2581 | 1.2749 | 5819.0 |
| 2015-04-02 | EBM | Futures | 306.89 | 311.31 | 306.49 | 310.9 | 17544.0 |
| 2015-04-02 | ED | Futures | 95.5237 | 95.5285 | 95.5237 | 95.5285 | 91495.0 |
| 2015-04-02 | ER | Futures | 98.053 | 98.058 | 98.043 | 98.048 | 29274.0 |
| 2015-04-02 | EW | Futures | 1590.1 | 1601.1 | 1581.6 | 1595.1 | 12873.0 |
| 2015-04-02 | FBTP | Futures | 103.98 | 103.99 | 103.56 | 103.58 | 51835.0 |
| 2015-04-02 | FBTS | Futures | 99.652 | 99.688 | 99.617 | 99.617 | 14371.0 |
| 2015-04-02 | FCE | Futures | 4125.7 | 4132.6 | 4113.5 | 4126.9 | 55504.0 |
| 2015-04-02 | FDAX | Futures | 13375.7 | 13377.9 | 13268.0 | 13291.3 | 72871.0 |
| 2015-04-02 | FESX | Futures | 2689.5 | 2693.9 | 2679.2 | 2684.4 | 609694.0 |
| 2015-04-02 | FEU3 | Futures | 98.69 | 98.69 | 98.69 | 98.69 | 10.0 |
| 2015-04-02 | FGBL | Futures | 141.19 | 141.32 | 140.92 | 141.04 | 399227.0 |
| 2015-04-02 | FGBM | Futures | 124.85 | 124.85 | 124.74 | 124.77 | 249932.0 |
| 2015-04-02 | FGBS | Futures | 111.263 | 111.278 | 111.253 | 111.268 | 152564.0 |
| 2015-04-02 | FGBX | Futures | 178.24 | 178.3 | 176.85 | 177.21 | 30777.0 |
| 2015-04-02 | FMWO | Futures | 5725.0 | 5764.5 | 5721.3 | 5760.8 | 168.0 |
| 2015-04-02 | FOAT | Futures | 129.91 | 129.97 | 129.59 | 129.71 | 102282.0 |
| 2015-04-02 | FTDX | Futures | 1515.7 | 1520.4 | 1514.8 | 1516.6 | 55.0 |
| 2015-04-02 | FTI | Futures | 424.36 | 426.79 | 423.41 | 425.53 | 18947.0 |
| 2015-04-02 | FTUK | Futures | 5321.0 | 5357.3 | 5309.2 | 5332.1 | 68199.0 |
| 2015-04-02 | FVSA | Futures | 1838.0 | 1838.0 | 1787.18 | 1795.65 | 8837.0 |
| 2015-04-02 | FXXP | Futures | 301.5 | 302.1 | 300.6 | 301.1 | 10998.0 |
| 2015-04-02 | G | Futures | 105.29 | 105.59 | 104.81 | 104.92 | 109843.0 |
| 2015-04-02 | GF | Futures | 372.673 | 374.2 | 371.655 | 373.861 | 1467.0 |
| 2015-04-02 | GSCI | Futures | 688.52 | 697.57 | 685.34 | 690.94 | 343.0 |
| 2015-04-02 | HE | Futures | 79.521 | 80.648 | 77.612 | 79.058 | 607.0 |
> showing 50 of 107 rows — these rows as CSV