PREVIEW / futures_daily / 2015-03-02
file: by_date/futures_daily/2015/2015-03-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-03-02 | ES | Futures | 2205.26 | 2217.32 | 2201.59 | 2215.74 | 1075660.0 |
| 2015-03-02 | NQ | Futures | 5159.82 | 5201.88 | 5158.95 | 5194.62 | 185330.0 |
| 2015-03-02 | YM | Futures | 18479.2 | 18607.6 | 18457.8 | 18585.2 | 97423.0 |
| 2015-03-02 | CL | Futures | 91.5 | 94.44 | 90.13 | 91.76 | 427177.0 |
| 2015-03-02 | GC | Futures | 1587.0 | 1599.1 | 1574.5 | 1579.7 | 133100.0 |
| 2015-03-02 | ZN | Futures | 120.983033 | 121.071364 | 120.305835 | 120.379443 | 169818.0 |
| 2015-03-02 | A6 | Futures | 0.76408 | 0.76427 | 0.75918 | 0.76075 | 60142.0 |
| 2015-03-02 | AD | Futures | 0.81412 | 0.81626 | 0.81036 | 0.81188 | 47552.0 |
| 2015-03-02 | ALI | Futures | 2675.2 | 2675.2 | 2675.2 | 2675.2 | 5.0 |
| 2015-03-02 | B | Futures | 61.83 | 61.96 | 59.09 | 59.23 | 173291.0 |
| 2015-03-02 | B6 | Futures | 1.6218 | 1.6223 | 1.6139 | 1.6152 | 75267.0 |
| 2015-03-02 | BFX | Futures | 4482.6 | 4486.8 | 4471.7 | 4482.0 | 40.0 |
| 2015-03-02 | BR | Futures | 0.1937 | 0.19395 | 0.19196 | 0.19261 | 42.0 |
| 2015-03-02 | BZ | Futures | 61.42 | 61.42 | 58.61 | 58.72 | 34505.0 |
| 2015-03-02 | C | Futures | 2219.0 | 2224.0 | 2203.0 | 2224.0 | 11023.0 |
| 2015-03-02 | CB | Futures | 148.883 | 148.883 | 147.669 | 147.669 | 6.0 |
| 2015-03-02 | CC | Futures | 2220.0 | 2227.0 | 2195.0 | 2219.0 | 12187.0 |
| 2015-03-02 | CNH | Futures | 7.1647 | 7.1647 | 7.1466 | 7.1524 | 15.0 |
| 2015-03-02 | CSC | Futures | 4.644 | 4.644 | 4.583 | 4.583 | 8.0 |
| 2015-03-02 | CT | Futures | 82.71 | 83.35 | 82.03 | 83.12 | 13742.0 |
| 2015-03-02 | DC | Futures | 38.19 | 38.46 | 37.38 | 37.72 | 102.0 |
| 2015-03-02 | DX | Futures | 90.279 | 90.45 | 90.019 | 90.378 | 20475.0 |
| 2015-03-02 | E1 | Futures | 1.33821 | 1.34025 | 1.3308 | 1.33119 | 15241.0 |
| 2015-03-02 | E6 | Futures | 1.3154 | 1.32234 | 1.31282 | 1.31599 | 154022.0 |
| 2015-03-02 | E7 | Futures | 1.3076 | 1.3146 | 1.3051 | 1.3081 | 2832.0 |
| 2015-03-02 | EBM | Futures | 305.76 | 306.16 | 299.27 | 299.68 | 8654.0 |
| 2015-03-02 | ED | Futures | 95.457 | 95.4618 | 95.457 | 95.4594 | 139247.0 |
| 2015-03-02 | ER | Futures | 98.068 | 98.068 | 98.058 | 98.063 | 26160.0 |
| 2015-03-02 | EW | Futures | 1576.0 | 1586.6 | 1572.9 | 1583.6 | 15273.0 |
| 2015-03-02 | FBTP | Futures | 102.88 | 103.25 | 102.78 | 102.84 | 134196.0 |
| 2015-03-02 | FBTS | Futures | 99.608 | 99.643 | 99.581 | 99.581 | 30059.0 |
| 2015-03-02 | FCE | Futures | 4017.5 | 4026.5 | 3985.0 | 3999.3 | 76963.0 |
| 2015-03-02 | FDAX | Futures | 12660.1 | 12719.4 | 12617.3 | 12656.7 | 83045.0 |
| 2015-03-02 | FDIV | Futures | 162.18 | 162.6 | 162.18 | 162.6 | 4.0 |
| 2015-03-02 | FESX | Futures | 2589.6 | 2601.1 | 2578.8 | 2587.4 | 815431.0 |
| 2015-03-02 | FGBL | Futures | 139.6 | 139.77 | 139.22 | 139.33 | 733045.0 |
| 2015-03-02 | FGBM | Futures | 124.72 | 124.74 | 124.53 | 124.55 | 595960.0 |
| 2015-03-02 | FGBS | Futures | 111.223 | 111.228 | 111.178 | 111.188 | 576051.0 |
| 2015-03-02 | FGBX | Futures | 166.82 | 167.16 | 165.72 | 166.2 | 38526.0 |
| 2015-03-02 | FMWO | Futures | 5838.8 | 5852.4 | 5832.6 | 5851.2 | 1199.0 |
| 2015-03-02 | FOAT | Futures | 128.32 | 128.47 | 128.0 | 128.03 | 97118.0 |
| 2015-03-02 | FTDX | Futures | 1478.2 | 1491.3 | 1473.5 | 1486.6 | 63.0 |
| 2015-03-02 | FTI | Futures | 417.71 | 420.64 | 417.36 | 419.3 | 23637.0 |
| 2015-03-02 | FTUK | Futures | 5405.5 | 5413.7 | 5374.0 | 5382.9 | 81678.0 |
| 2015-03-02 | FVSA | Futures | 1700.93 | 1700.93 | 1638.26 | 1665.12 | 10020.0 |
| 2015-03-02 | FXXP | Futures | 296.1 | 296.9 | 294.2 | 295.4 | 9699.0 |
| 2015-03-02 | G | Futures | 103.11 | 103.54 | 103.02 | 103.12 | 153593.0 |
| 2015-03-02 | GF | Futures | 341.695 | 344.816 | 341.695 | 344.31 | 2756.0 |
| 2015-03-02 | GSCI | Futures | 715.62 | 721.64 | 708.32 | 709.18 | 107.0 |
| 2015-03-02 | HE | Futures | 91.763 | 92.366 | 90.253 | 90.79 | 17940.0 |
> showing 50 of 107 rows — these rows as CSV