PREVIEW / futures_daily / 2016-06-01
file: by_date/futures_daily/2016/2016-06-01.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-01 | ES | Futures | 2248.36 | 2254.0 | 2236.82 | 2252.66 | 1317565.0 |
| 2016-06-01 | NQ | Futures | 5313.38 | 5331.59 | 5290.76 | 5312.79 | 194470.0 |
| 2016-06-01 | YM | Futures | 18479.5 | 18520.1 | 18349.6 | 18485.8 | 119690.0 |
| 2016-06-01 | CL | Futures | 57.23 | 57.73 | 55.97 | 57.45 | 568839.0 |
| 2016-06-01 | GC | Futures | 1566.8 | 1573.3 | 1554.4 | 1562.7 | 159621.0 |
| 2016-06-01 | ZN | Futures | 125.193075 | 125.540079 | 125.132727 | 125.177988 | 139871.0 |
| 2016-06-01 | A6 | Futures | 0.73154 | 0.73842 | 0.73114 | 0.73397 | 119738.0 |
| 2016-06-01 | AD | Futures | 0.78075 | 0.78382 | 0.77912 | 0.78198 | 66050.0 |
| 2016-06-01 | ALI | Futures | 2095.27 | 2095.27 | 2095.27 | 2095.27 | 0.0 |
| 2016-06-01 | B | Futures | 40.24 | 40.53 | 39.43 | 40.3 | 265995.0 |
| 2016-06-01 | B6 | Futures | 1.5251 | 1.5277 | 1.5149 | 1.5169 | 130964.0 |
| 2016-06-01 | BR | Futures | 0.1784 | 0.18033 | 0.1784 | 0.18033 | 4.0 |
| 2016-06-01 | BZ | Futures | 40.14 | 40.44 | 39.33 | 40.2 | 25507.0 |
| 2016-06-01 | C | Futures | 2342.0 | 2351.0 | 2313.0 | 2340.0 | 8461.0 |
| 2016-06-01 | CB | Futures | 256.713 | 256.713 | 256.127 | 256.127 | 1.0 |
| 2016-06-01 | CC | Futures | 2222.0 | 2241.0 | 2192.0 | 2228.0 | 20794.0 |
| 2016-06-01 | CNH | Futures | 7.1565 | 7.1594 | 7.1565 | 7.1587 | 21.0 |
| 2016-06-01 | CSC | Futures | 3.316 | 3.321 | 3.301 | 3.31 | 97.0 |
| 2016-06-01 | CT | Futures | 72.89 | 72.89 | 71.59 | 71.86 | 19763.0 |
| 2016-06-01 | DC | Futures | 26.03 | 26.17 | 25.97 | 26.17 | 53.0 |
| 2016-06-01 | DX | Futures | 89.316 | 89.414 | 88.887 | 88.995 | 19508.0 |
| 2016-06-01 | E1 | Futures | 1.26539 | 1.27469 | 1.26325 | 1.27104 | 22017.0 |
| 2016-06-01 | E6 | Futures | 1.29855 | 1.30596 | 1.29663 | 1.30462 | 182534.0 |
| 2016-06-01 | E7 | Futures | 1.2916 | 1.2989 | 1.2896 | 1.2976 | 2592.0 |
| 2016-06-01 | EBM | Futures | 198.48 | 199.38 | 197.57 | 198.17 | 7242.0 |
| 2016-06-01 | ED | Futures | 95.6846 | 95.6967 | 95.6798 | 95.6871 | 202647.0 |
| 2016-06-01 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.264 | 24048.0 |
| 2016-06-01 | EW | Futures | 1574.7 | 1584.5 | 1566.2 | 1584.2 | 17631.0 |
| 2016-06-01 | FBON | Futures | 119.4 | 119.43 | 119.15 | 119.2 | 453.0 |
| 2016-06-01 | FBTP | Futures | 107.36 | 107.38 | 106.94 | 107.06 | 131509.0 |
| 2016-06-01 | FBTS | Futures | 101.167 | 101.176 | 101.141 | 101.158 | 29605.0 |
| 2016-06-01 | FCE | Futures | 3856.0 | 3861.1 | 3815.5 | 3830.6 | 86512.0 |
| 2016-06-01 | FDAX | Futures | 11013.3 | 11051.4 | 10914.4 | 10951.5 | 95368.0 |
| 2016-06-01 | FDIV | Futures | 133.12 | 133.12 | 133.03 | 133.03 | 30.0 |
| 2016-06-01 | FDXM | Futures | 10607.5 | 10640.6 | 10510.2 | 10545.4 | 17605.0 |
| 2016-06-01 | FESX | Futures | 2379.8 | 2384.4 | 2352.5 | 2360.3 | 1449002.0 |
| 2016-06-01 | FGBL | Futures | 146.82 | 147.06 | 146.73 | 146.82 | 884869.0 |
| 2016-06-01 | FGBM | Futures | 127.77 | 127.83 | 127.74 | 127.78 | 791127.0 |
| 2016-06-01 | FGBS | Futures | 111.678 | 111.693 | 111.668 | 111.688 | 359944.0 |
| 2016-06-01 | FGBX | Futures | 173.97 | 174.73 | 173.68 | 174.07 | 51497.0 |
| 2016-06-01 | FMWO | Futures | 5682.5 | 5692.5 | 5660.1 | 5683.8 | 226.0 |
| 2016-06-01 | FOAT | Futures | 134.32 | 134.51 | 134.2 | 134.29 | 135496.0 |
| 2016-06-01 | FTDX | Futures | 1610.9 | 1617.5 | 1610.4 | 1616.6 | 177.0 |
| 2016-06-01 | FTI | Futures | 401.38 | 402.64 | 398.68 | 401.11 | 29742.0 |
| 2016-06-01 | FTUK | Futures | 5124.9 | 5134.8 | 5063.8 | 5091.1 | 127184.0 |
| 2016-06-01 | FVSA | Futures | 2331.83 | 2448.18 | 2331.83 | 2415.6 | 25692.0 |
| 2016-06-01 | FXXP | Futures | 277.6 | 278.3 | 274.7 | 275.5 | 26704.0 |
| 2016-06-01 | G | Futures | 108.78 | 109.44 | 108.74 | 109.22 | 240049.0 |
| 2016-06-01 | GF | Futures | 292.536 | 293.384 | 287.893 | 292.386 | 3735.0 |
| 2016-06-01 | GSCI | Futures | 529.8 | 538.47 | 529.65 | 537.75 | 86.0 |
> showing 50 of 110 rows — these rows as CSV