PREVIEW / futures_daily / 2014-05-15
file: by_date/futures_daily/2014/2014-05-15.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 |
|---|---|---|---|---|---|---|---|
| 2014-05-15 | ES | Futures | 1951.07 | 1953.91 | 1923.39 | 1931.93 | 2247238.0 |
| 2014-05-15 | NQ | Futures | 4143.11 | 4151.75 | 4075.2 | 4101.67 | 398709.0 |
| 2014-05-15 | YM | Futures | 16662.0 | 16687.1 | 16433.1 | 16488.3 | 211379.0 |
| 2014-05-15 | CL | Futures | 184.55 | 185.04 | 183.39 | 183.95 | 206997.0 |
| 2014-05-15 | GC | Futures | 1720.1 | 1722.5 | 1700.9 | 1704.4 | 147392.0 |
| 2014-05-15 | ZN | Futures | 116.431372 | 116.967389 | 116.257529 | 116.750085 | 2035636.0 |
| 2014-05-15 | A6 | Futures | 0.89894 | 0.90058 | 0.89414 | 0.89712 | 62914.0 |
| 2014-05-15 | AD | Futures | 0.93043 | 0.93367 | 0.93022 | 0.93154 | 43597.0 |
| 2014-05-15 | ALI | Futures | 2681.57 | 2681.57 | 2681.57 | 2681.57 | 0.0 |
| 2014-05-15 | B | Futures | 113.16 | 113.51 | 112.66 | 112.93 | 222800.0 |
| 2014-05-15 | B6 | Futures | 1.7617 | 1.7659 | 1.758 | 1.7648 | 81568.0 |
| 2014-05-15 | BFX | Futures | 3796.4 | 3796.4 | 3750.3 | 3750.3 | 20.0 |
| 2014-05-15 | BR | Futures | 0.2375 | 0.23766 | 0.2355 | 0.23618 | 226.0 |
| 2014-05-15 | BZ | Futures | 115.4 | 115.76 | 114.91 | 115.18 | 8991.0 |
| 2014-05-15 | C | Futures | 1878.0 | 1899.0 | 1875.0 | 1888.0 | 5805.0 |
| 2014-05-15 | CB | Futures | 105.6 | 105.841 | 105.6 | 105.841 | 2.0 |
| 2014-05-15 | CC | Futures | 2131.0 | 2156.0 | 2128.0 | 2144.0 | 9161.0 |
| 2014-05-15 | CSC | Futures | 4.415 | 4.421 | 4.395 | 4.404 | 27.0 |
| 2014-05-15 | CT | Futures | 102.13 | 102.79 | 101.45 | 101.75 | 11431.0 |
| 2014-05-15 | DC | Futures | 36.15 | 36.19 | 35.51 | 35.63 | 227.0 |
| 2014-05-15 | DX | Futures | 76.111 | 76.387 | 75.988 | 76.063 | 23001.0 |
| 2014-05-15 | E1 | Futures | 1.44251 | 1.44508 | 1.43263 | 1.44213 | 49626.0 |
| 2014-05-15 | E6 | Futures | 1.61876 | 1.621 | 1.61085 | 1.61899 | 232853.0 |
| 2014-05-15 | E7 | Futures | 1.608 | 1.6102 | 1.5995 | 1.6082 | 4622.0 |
| 2014-05-15 | ED | Futures | 95.4186 | 95.4234 | 95.4138 | 95.4186 | 135398.0 |
| 2014-05-15 | ER | Futures | 97.867 | 97.896 | 97.842 | 97.886 | 161645.0 |
| 2014-05-15 | EW | Futures | 1400.0 | 1400.9 | 1370.7 | 1386.9 | 23468.0 |
| 2014-05-15 | FBTP | Futures | 89.99 | 90.22 | 88.44 | 88.94 | 165088.0 |
| 2014-05-15 | FBTS | Futures | 97.575 | 97.619 | 97.179 | 97.372 | 26243.0 |
| 2014-05-15 | FCE | Futures | 3557.7 | 3571.7 | 3511.4 | 3518.2 | 91576.0 |
| 2014-05-15 | FDAX | Futures | 10763.7 | 10847.1 | 10641.1 | 10663.2 | 137655.0 |
| 2014-05-15 | FESX | Futures | 2289.4 | 2300.9 | 2252.1 | 2255.7 | 1260573.0 |
| 2014-05-15 | FGBL | Futures | 125.8 | 126.64 | 125.76 | 126.55 | 1068814.0 |
| 2014-05-15 | FGBM | Futures | 120.62 | 120.94 | 120.59 | 120.89 | 726376.0 |
| 2014-05-15 | FGBS | Futures | 110.663 | 110.708 | 110.653 | 110.703 | 443356.0 |
| 2014-05-15 | FGBX | Futures | 130.36 | 132.42 | 130.28 | 132.27 | 29879.0 |
| 2014-05-15 | FMWO | Futures | 5630.1 | 5630.1 | 5563.3 | 5563.3 | 125.0 |
| 2014-05-15 | FOAT | Futures | 115.39 | 116.01 | 115.34 | 115.92 | 107157.0 |
| 2014-05-15 | FTDX | Futures | 1163.9 | 1170.5 | 1149.8 | 1152.7 | 392.0 |
| 2014-05-15 | FTI | Futures | 347.26 | 349.29 | 344.24 | 345.15 | 15424.0 |
| 2014-05-15 | FTUK | Futures | 5227.8 | 5246.1 | 5187.3 | 5200.7 | 125610.0 |
| 2014-05-15 | FVSA | Futures | 1667.07 | 1718.43 | 1639.05 | 1713.76 | 10404.0 |
| 2014-05-15 | FXXP | Futures | 254.8 | 256.0 | 252.4 | 252.7 | 8294.0 |
| 2014-05-15 | G | Futures | 94.8 | 95.42 | 94.76 | 95.4 | 253239.0 |
| 2014-05-15 | GF | Futures | 295.791 | 297.822 | 294.335 | 294.91 | 3321.0 |
| 2014-05-15 | GSCI | Futures | 1085.71 | 1085.71 | 1078.84 | 1079.09 | 152.0 |
| 2014-05-15 | HE | Futures | 134.813 | 135.036 | 132.748 | 133.278 | 18161.0 |
| 2014-05-15 | HG | Futures | 4.0288 | 4.0518 | 4.0135 | 4.018 | 40397.0 |
| 2014-05-15 | HH | Futures | 55.041 | 57.043 | 55.015 | 56.65 | 414.0 |
| 2014-05-15 | HO | Futures | 2.3619 | 2.3681 | 2.3489 | 2.3514 | 35906.0 |
> showing 50 of 104 rows — these rows as CSV