PREVIEW / futures_daily / 2015-01-29
file: by_date/futures_daily/2015/2015-01-29.parquet size: 9 KB rows: 104
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-01-29 | ES | Futures | 2089.44 | 2117.22 | 2077.39 | 2115.65 | 2124643.0 |
| 2015-01-29 | NQ | Futures | 4786.2 | 4872.93 | 4752.26 | 4856.69 | 358572.0 |
| 2015-01-29 | YM | Futures | 17443.4 | 17760.2 | 17377.2 | 17754.1 | 232611.0 |
| 2015-01-29 | CL | Futures | 85.38 | 86.4 | 83.75 | 85.57 | 300732.0 |
| 2015-01-29 | GC | Futures | 1678.8 | 1682.2 | 1637.1 | 1642.1 | 243648.0 |
| 2015-01-29 | ZN | Futures | 122.882134 | 122.985186 | 122.396318 | 122.661309 | 1282574.0 |
| 2015-01-29 | A6 | Futures | 0.77015 | 0.77231 | 0.75399 | 0.75751 | 110936.0 |
| 2015-01-29 | AD | Futures | 0.81209 | 0.81351 | 0.80292 | 0.80669 | 69958.0 |
| 2015-01-29 | ALI | Futures | 2827.5 | 2827.5 | 2827.5 | 2827.5 | 0.0 |
| 2015-01-29 | B | Futures | 49.0 | 49.77 | 48.95 | 49.65 | 133674.0 |
| 2015-01-29 | B6 | Futures | 1.5918 | 1.5938 | 1.5786 | 1.5817 | 88774.0 |
| 2015-01-29 | BR | Futures | 0.21208 | 0.21208 | 0.2093 | 0.20966 | 1149.0 |
| 2015-01-29 | BZ | Futures | 49.14 | 49.63 | 48.83 | 49.52 | 21416.0 |
| 2015-01-29 | C | Futures | 2077.0 | 2082.0 | 2066.0 | 2074.0 | 9191.0 |
| 2015-01-29 | CB | Futures | 142.963 | 145.838 | 142.963 | 145.838 | 7.0 |
| 2015-01-29 | CC | Futures | 2000.0 | 2003.0 | 1980.0 | 1982.0 | 19274.0 |
| 2015-01-29 | CSC | Futures | 4.31 | 4.515 | 4.282 | 4.515 | 133.0 |
| 2015-01-29 | CT | Futures | 75.49 | 76.35 | 75.48 | 76.08 | 18048.0 |
| 2015-01-29 | DC | Futures | 34.43 | 36.14 | 34.43 | 36.14 | 481.0 |
| 2015-01-29 | DX | Futures | 89.806 | 90.17 | 89.47 | 89.935 | 48156.0 |
| 2015-01-29 | E1 | Futures | 1.41355 | 1.41444 | 1.3829 | 1.38354 | 17563.0 |
| 2015-01-29 | E6 | Futures | 1.32681 | 1.33764 | 1.32517 | 1.33117 | 222102.0 |
| 2015-01-29 | E7 | Futures | 1.3191 | 1.3297 | 1.3174 | 1.3232 | 4835.0 |
| 2015-01-29 | EBM | Futures | 302.92 | 306.57 | 302.51 | 304.54 | 21794.0 |
| 2015-01-29 | ED | Futures | 95.4546 | 95.4546 | 95.4498 | 95.4546 | 91668.0 |
| 2015-01-29 | ER | Futures | 98.043 | 98.043 | 98.028 | 98.038 | 92334.0 |
| 2015-01-29 | EW | Futures | 1505.2 | 1521.8 | 1496.2 | 1521.3 | 23816.0 |
| 2015-01-29 | FBTP | Futures | 100.84 | 101.01 | 100.32 | 100.84 | 128262.0 |
| 2015-01-29 | FBTS | Futures | 99.014 | 99.085 | 98.872 | 99.049 | 30964.0 |
| 2015-01-29 | FCE | Futures | 3724.1 | 3811.4 | 3711.9 | 3780.0 | 127799.0 |
| 2015-01-29 | FDAX | Futures | 11773.6 | 12025.6 | 11766.9 | 11918.4 | 119868.0 |
| 2015-01-29 | FESX | Futures | 2392.8 | 2453.4 | 2384.9 | 2430.3 | 1296008.0 |
| 2015-01-29 | FGBL | Futures | 139.17 | 139.31 | 138.75 | 138.97 | 578317.0 |
| 2015-01-29 | FGBM | Futures | 124.28 | 124.35 | 124.2 | 124.26 | 460535.0 |
| 2015-01-29 | FGBS | Futures | 111.128 | 111.143 | 111.113 | 111.133 | 268909.0 |
| 2015-01-29 | FGBX | Futures | 167.24 | 167.58 | 165.74 | 166.32 | 26985.0 |
| 2015-01-29 | FMWO | Futures | 5527.1 | 5540.7 | 5519.7 | 5525.9 | 75.0 |
| 2015-01-29 | FOAT | Futures | 127.74 | 127.86 | 127.42 | 127.56 | 66795.0 |
| 2015-01-29 | FTDX | Futures | 1399.8 | 1403.1 | 1395.1 | 1398.9 | 54.0 |
| 2015-01-29 | FTI | Futures | 386.61 | 392.97 | 385.49 | 390.59 | 38951.0 |
| 2015-01-29 | FTUK | Futures | 5234.8 | 5292.1 | 5217.3 | 5265.2 | 123140.0 |
| 2015-01-29 | FVSA | Futures | 2040.25 | 2104.81 | 2010.12 | 2066.07 | 16059.0 |
| 2015-01-29 | FXXP | Futures | 276.3 | 279.7 | 276.1 | 278.1 | 12186.0 |
| 2015-01-29 | G | Futures | 105.96 | 106.31 | 105.86 | 106.08 | 186322.0 |
| 2015-01-29 | GF | Futures | 343.382 | 347.769 | 337.773 | 343.425 | 5360.0 |
| 2015-01-29 | GSCI | Futures | 650.47 | 651.67 | 641.68 | 648.14 | 177.0 |
| 2015-01-29 | HE | Futures | 100.248 | 101.053 | 97.464 | 98.202 | 20700.0 |
| 2015-01-29 | HG | Futures | 3.1179 | 3.137 | 3.0741 | 3.1141 | 55912.0 |
| 2015-01-29 | HH | Futures | 35.691 | 36.529 | 33.438 | 34.026 | 5479.0 |
| 2015-01-29 | HO | Futures | 1.3019 | 1.3172 | 1.2959 | 1.3035 | 65620.0 |
> showing 50 of 104 rows — these rows as CSV