PREVIEW / futures_daily / 2015-04-15
file: by_date/futures_daily/2015/2015-04-15.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-15 | ES | Futures | 2199.4 | 2213.85 | 2194.67 | 2207.81 | 1045308.0 |
| 2015-04-15 | NQ | Futures | 5108.83 | 5142.21 | 5095.48 | 5133.8 | 170496.0 |
| 2015-04-15 | YM | Futures | 18383.8 | 18496.4 | 18345.0 | 18434.0 | 111457.0 |
| 2015-04-15 | CL | Futures | 93.41 | 98.35 | 93.19 | 97.96 | 333568.0 |
| 2015-04-15 | GC | Futures | 1560.0 | 1575.9 | 1554.9 | 1571.9 | 129198.0 |
| 2015-04-15 | ZN | Futures | 122.515766 | 122.782169 | 122.426965 | 122.604567 | 762083.0 |
| 2015-04-15 | A6 | Futures | 0.74924 | 0.75684 | 0.74412 | 0.75516 | 120151.0 |
| 2015-04-15 | AD | Futures | 0.81689 | 0.83078 | 0.81158 | 0.82925 | 125478.0 |
| 2015-04-15 | ALI | Futures | 2570.83 | 2570.83 | 2570.83 | 2570.83 | 0.0 |
| 2015-04-15 | B | Futures | 57.95 | 61.24 | 57.92 | 61.09 | 344269.0 |
| 2015-04-15 | B6 | Futures | 1.555 | 1.563 | 1.5467 | 1.562 | 94660.0 |
| 2015-04-15 | BFX | Futures | 4669.6 | 4676.9 | 4654.4 | 4676.9 | 219.0 |
| 2015-04-15 | BR | Futures | 0.18254 | 0.18565 | 0.18186 | 0.18537 | 79.0 |
| 2015-04-15 | BZ | Futures | 57.34 | 60.69 | 57.31 | 60.56 | 28727.0 |
| 2015-04-15 | C | Futures | 2148.0 | 2150.0 | 2123.0 | 2125.0 | 2212.0 |
| 2015-04-15 | CB | Futures | 148.074 | 148.074 | 148.074 | 148.074 | 4.0 |
| 2015-04-15 | CC | Futures | 2097.0 | 2102.0 | 2072.0 | 2082.0 | 25157.0 |
| 2015-04-15 | CNH | Futures | 7.0223 | 7.0223 | 7.0077 | 7.0087 | 4.0 |
| 2015-04-15 | CSC | Futures | 4.279 | 4.311 | 4.252 | 4.255 | 99.0 |
| 2015-04-15 | CT | Futures | 82.85 | 83.47 | 82.48 | 82.79 | 16034.0 |
| 2015-04-15 | DC | Futures | 34.73 | 35.27 | 34.53 | 34.71 | 238.0 |
| 2015-04-15 | DX | Futures | 92.963 | 93.503 | 92.404 | 92.512 | 76199.0 |
| 2015-04-15 | E1 | Futures | 1.31328 | 1.32577 | 1.30716 | 1.32513 | 23801.0 |
| 2015-04-15 | E6 | Futures | 1.25389 | 1.25954 | 1.24401 | 1.25742 | 343237.0 |
| 2015-04-15 | E7 | Futures | 1.2463 | 1.2524 | 1.2369 | 1.2501 | 8588.0 |
| 2015-04-15 | EBM | Futures | 299.67 | 300.88 | 296.86 | 297.27 | 23071.0 |
| 2015-04-15 | ED | Futures | 95.5429 | 95.5477 | 95.5429 | 95.5477 | 45665.0 |
| 2015-04-15 | ER | Futures | 98.073 | 98.082 | 98.073 | 98.077 | 54796.0 |
| 2015-04-15 | EW | Futures | 1603.2 | 1615.7 | 1601.4 | 1609.2 | 12043.0 |
| 2015-04-15 | FBTP | Futures | 103.5 | 104.0 | 103.24 | 103.85 | 105370.0 |
| 2015-04-15 | FBTS | Futures | 99.643 | 99.732 | 99.608 | 99.679 | 22203.0 |
| 2015-04-15 | FCE | Futures | 4252.9 | 4284.5 | 4241.0 | 4270.6 | 156472.0 |
| 2015-04-15 | FDAX | Futures | 13639.7 | 13714.0 | 13568.1 | 13613.1 | 81219.0 |
| 2015-04-15 | FESX | Futures | 2748.5 | 2765.4 | 2741.1 | 2752.9 | 759377.0 |
| 2015-04-15 | FEU3 | Futures | 98.72 | 98.72 | 98.715 | 98.72 | 554.0 |
| 2015-04-15 | FGBL | Futures | 141.68 | 142.19 | 141.65 | 142.11 | 491173.0 |
| 2015-04-15 | FGBM | Futures | 124.99 | 125.08 | 124.98 | 125.05 | 268414.0 |
| 2015-04-15 | FGBS | Futures | 111.318 | 111.333 | 111.298 | 111.308 | 170511.0 |
| 2015-04-15 | FGBX | Futures | 178.54 | 180.69 | 178.38 | 180.24 | 27606.0 |
| 2015-04-15 | FMWO | Futures | 5858.2 | 5885.3 | 5858.2 | 5880.4 | 1636.0 |
| 2015-04-15 | FOAT | Futures | 130.47 | 131.11 | 130.41 | 131.04 | 56519.0 |
| 2015-04-15 | FTDX | Futures | 1577.2 | 1586.6 | 1569.7 | 1575.8 | 108.0 |
| 2015-04-15 | FTI | Futures | 436.84 | 440.72 | 435.36 | 437.11 | 33438.0 |
| 2015-04-15 | FTUK | Futures | 5539.0 | 5566.2 | 5522.4 | 5555.9 | 78376.0 |
| 2015-04-15 | FVSA | Futures | 1606.53 | 1606.53 | 1563.0 | 1574.87 | 17798.0 |
| 2015-04-15 | FXXP | Futures | 312.2 | 315.0 | 312.2 | 314.2 | 11894.0 |
| 2015-04-15 | G | Futures | 105.5 | 105.52 | 105.09 | 105.19 | 124516.0 |
| 2015-04-15 | GF | Futures | 363.335 | 366.6 | 363.335 | 365.053 | 2857.0 |
| 2015-04-15 | GSCI | Futures | 713.15 | 736.12 | 713.15 | 732.97 | 375.0 |
| 2015-04-15 | HE | Futures | 82.933 | 82.933 | 79.81 | 80.33 | 718.0 |
> showing 50 of 107 rows — these rows as CSV