PREVIEW / futures_daily / 2015-05-29
file: by_date/futures_daily/2015/2015-05-29.parquet size: 9 KB rows: 108
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-05-29 | ES | Futures | 2230.94 | 2231.99 | 2210.44 | 2214.38 | 1692162.0 |
| 2015-05-29 | NQ | Futures | 5273.41 | 5277.18 | 5221.45 | 5237.42 | 197740.0 |
| 2015-05-29 | YM | Futures | 18542.4 | 18560.8 | 18361.3 | 18420.7 | 154965.0 |
| 2015-05-29 | CL | Futures | 97.42 | 102.01 | 97.0 | 101.34 | 452222.0 |
| 2015-05-29 | GC | Futures | 1551.6 | 1559.9 | 1548.9 | 1553.9 | 102168.0 |
| 2015-05-29 | ZN | Futures | 121.213352 | 121.553756 | 121.183751 | 121.538955 | 389444.0 |
| 2015-05-29 | A6 | Futures | 0.75398 | 0.75625 | 0.75181 | 0.75437 | 78236.0 |
| 2015-05-29 | AD | Futures | 0.82139 | 0.82241 | 0.81475 | 0.82026 | 77810.0 |
| 2015-05-29 | ALI | Futures | 2357.85 | 2357.85 | 2357.85 | 2357.85 | 5.0 |
| 2015-05-29 | B | Futures | 59.82 | 62.47 | 59.51 | 62.22 | 140491.0 |
| 2015-05-29 | B6 | Futures | 1.6119 | 1.6148 | 1.6036 | 1.6093 | 84891.0 |
| 2015-05-29 | BFX | Futures | 4499.5 | 4500.1 | 4477.1 | 4477.1 | 5.0 |
| 2015-05-29 | BR | Futures | 0.18462 | 0.18462 | 0.18138 | 0.18228 | 30.0 |
| 2015-05-29 | BZ | Futures | 60.02 | 62.58 | 59.65 | 62.35 | 14593.0 |
| 2015-05-29 | C | Futures | 2296.0 | 2299.0 | 2274.0 | 2277.0 | 16318.0 |
| 2015-05-29 | CB | Futures | 166.147 | 168.578 | 166.147 | 168.578 | 44.0 |
| 2015-05-29 | CC | Futures | 2298.0 | 2309.0 | 2273.0 | 2276.0 | 17924.0 |
| 2015-05-29 | CNH | Futures | 6.9759 | 6.9774 | 6.974 | 6.974 | 60.0 |
| 2015-05-29 | CSC | Futures | 4.599 | 4.635 | 4.599 | 4.617 | 54.0 |
| 2015-05-29 | CT | Futures | 81.57 | 83.88 | 80.96 | 81.06 | 36712.0 |
| 2015-05-29 | DC | Futures | 37.62 | 37.94 | 37.62 | 37.75 | 86.0 |
| 2015-05-29 | DX | Futures | 91.094 | 91.334 | 90.916 | 91.067 | 49476.0 |
| 2015-05-29 | E1 | Futures | 1.351 | 1.36387 | 1.34501 | 1.35635 | 26404.0 |
| 2015-05-29 | E6 | Futures | 1.2887 | 1.29446 | 1.28505 | 1.29152 | 244226.0 |
| 2015-05-29 | E7 | Futures | 1.2809 | 1.287 | 1.2776 | 1.2841 | 6310.0 |
| 2015-05-29 | EBM | Futures | 292.66 | 293.89 | 288.56 | 288.56 | 8808.0 |
| 2015-05-29 | ED | Futures | 95.5597 | 95.5621 | 95.5573 | 95.5597 | 112287.0 |
| 2015-05-29 | ER | Futures | 98.073 | 98.077 | 98.068 | 98.068 | 34802.0 |
| 2015-05-29 | EW | Futures | 1608.0 | 1611.3 | 1592.2 | 1597.4 | 21426.0 |
| 2015-05-29 | FBTP | Futures | 99.45 | 99.73 | 99.33 | 99.57 | 78375.0 |
| 2015-05-29 | FBTS | Futures | 99.759 | 99.786 | 99.741 | 99.777 | 12599.0 |
| 2015-05-29 | FCE | Futures | 4256.6 | 4262.0 | 4132.0 | 4141.1 | 166908.0 |
| 2015-05-29 | FDAX | Futures | 12977.9 | 13005.1 | 12649.5 | 12662.8 | 119927.0 |
| 2015-05-29 | FESX | Futures | 2691.0 | 2696.2 | 2619.5 | 2624.7 | 1501675.0 |
| 2015-05-29 | FEU3 | Futures | 98.715 | 98.715 | 98.715 | 98.715 | 4.0 |
| 2015-05-29 | FGBL | Futures | 137.95 | 138.33 | 137.76 | 138.09 | 638808.0 |
| 2015-05-29 | FGBM | Futures | 124.2 | 124.32 | 124.18 | 124.25 | 402600.0 |
| 2015-05-29 | FGBS | Futures | 111.213 | 111.233 | 111.198 | 111.203 | 326463.0 |
| 2015-05-29 | FGBX | Futures | 163.29 | 164.2 | 162.76 | 163.67 | 44968.0 |
| 2015-05-29 | FMWO | Futures | 5926.0 | 5929.7 | 5876.7 | 5876.7 | 840.0 |
| 2015-05-29 | FOAT | Futures | 126.55 | 126.92 | 126.41 | 126.74 | 85447.0 |
| 2015-05-29 | FTDX | Futures | 1615.7 | 1616.6 | 1587.0 | 1589.8 | 142.0 |
| 2015-05-29 | FTI | Futures | 437.82 | 438.69 | 429.58 | 430.14 | 41967.0 |
| 2015-05-29 | FTUK | Futures | 5549.2 | 5567.0 | 5479.1 | 5490.1 | 134081.0 |
| 2015-05-29 | FVSA | Futures | 1654.38 | 1716.22 | 1654.38 | 1704.63 | 7566.0 |
| 2015-05-29 | FXXP | Futures | 312.4 | 312.4 | 305.7 | 306.0 | 13388.0 |
| 2015-05-29 | G | Futures | 103.05 | 103.24 | 102.93 | 103.15 | 147129.0 |
| 2015-05-29 | GF | Futures | 383.393 | 383.393 | 378.633 | 379.058 | 5779.0 |
| 2015-05-29 | GSCI | Futures | 733.44 | 748.56 | 733.44 | 745.5 | 206.0 |
| 2015-05-29 | HE | Futures | 91.639 | 92.236 | 89.983 | 91.042 | 14610.0 |
> showing 50 of 108 rows — these rows as CSV