PREVIEW / futures_daily / 2013-06-19
file: by_date/futures_daily/2013/2013-06-19.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 |
|---|---|---|---|---|---|---|---|
| 2013-06-19 | ES | Futures | 1695.83 | 1698.41 | 1668.8 | 1672.4 | 2369632.0 |
| 2013-06-19 | NQ | Futures | 3462.44 | 3469.09 | 3415.59 | 3419.64 | 298769.0 |
| 2013-06-19 | YM | Futures | 15112.2 | 15142.9 | 14892.1 | 14913.9 | 191134.0 |
| 2013-06-19 | CL | Futures | 172.15 | 172.81 | 170.32 | 171.54 | 247539.0 |
| 2013-06-19 | GC | Futures | 1815.1 | 1826.7 | 1789.9 | 1824.0 | 136468.0 |
| 2013-06-19 | ZN | Futures | 116.072186 | 116.226593 | 114.44389 | 114.907112 | 1812988.0 |
| 2013-06-19 | A6 | Futures | 0.88468 | 0.89134 | 0.86554 | 0.87079 | 145030.0 |
| 2013-06-19 | AD | Futures | 0.98447 | 0.98819 | 0.97731 | 0.97751 | 70336.0 |
| 2013-06-19 | B | Futures | 102.6 | 103.07 | 101.97 | 102.62 | 164861.0 |
| 2013-06-19 | B6 | Futures | 1.639 | 1.6429 | 1.619 | 1.6227 | 119256.0 |
| 2013-06-19 | BFX | Futures | 3145.3 | 3157.1 | 3133.8 | 3147.8 | 375.0 |
| 2013-06-19 | BR | Futures | 0.224 | 0.22499 | 0.21873 | 0.2221 | 198.0 |
| 2013-06-19 | BZ | Futures | 103.06 | 103.59 | 102.49 | 103.14 | 4520.0 |
| 2013-06-19 | C | Futures | 1549.0 | 1555.0 | 1538.0 | 1541.0 | 3753.0 |
| 2013-06-19 | CB | Futures | 78.455 | 78.455 | 78.263 | 78.275 | 30.0 |
| 2013-06-19 | CC | Futures | 1660.0 | 1666.0 | 1651.0 | 1656.0 | 10345.0 |
| 2013-06-19 | CNH | Futures | 7.1517 | 7.1542 | 7.1469 | 7.1499 | 60.0 |
| 2013-06-19 | CSC | Futures | 3.518 | 3.524 | 3.518 | 3.524 | 29.0 |
| 2013-06-19 | CT | Futures | 101.89 | 102.99 | 101.15 | 102.35 | 3778.0 |
| 2013-06-19 | DC | Futures | 27.08 | 27.12 | 26.96 | 27.09 | 91.0 |
| 2013-06-19 | DX | Futures | 77.278 | 78.047 | 77.043 | 77.98 | 47803.0 |
| 2013-06-19 | E1 | Futures | 1.39805 | 1.40126 | 1.37979 | 1.38288 | 35566.0 |
| 2013-06-19 | E6 | Futures | 1.58135 | 1.58418 | 1.56577 | 1.5666 | 224135.0 |
| 2013-06-19 | E7 | Futures | 1.5712 | 1.574 | 1.5556 | 1.5564 | 5134.0 |
| 2013-06-19 | ED | Futures | 95.2869 | 95.2869 | 95.2725 | 95.2821 | 162097.0 |
| 2013-06-19 | ER | Futures | 97.822 | 97.832 | 97.803 | 97.822 | 85144.0 |
| 2013-06-19 | EW | Futures | 1208.0 | 1210.1 | 1187.5 | 1189.4 | 30496.0 |
| 2013-06-19 | FBTP | Futures | 78.11 | 78.39 | 77.88 | 78.33 | 28876.0 |
| 2013-06-19 | FBTS | Futures | 92.516 | 92.731 | 92.447 | 92.713 | 12227.0 |
| 2013-06-19 | FCE | Futures | 2987.8 | 2997.1 | 2950.9 | 2973.8 | 113213.0 |
| 2013-06-19 | FDAX | Futures | 9142.5 | 9202.4 | 9033.7 | 9108.1 | 28790.0 |
| 2013-06-19 | FDIV | Futures | 124.02 | 124.02 | 124.02 | 124.02 | 35.0 |
| 2013-06-19 | FESX | Futures | 1892.3 | 1897.3 | 1861.5 | 1880.4 | 827186.0 |
| 2013-06-19 | FEU3 | Futures | 98.438 | 98.438 | 98.433 | 98.433 | 14.0 |
| 2013-06-19 | FGBL | Futures | 120.03 | 120.36 | 119.19 | 120.1 | 658279.0 |
| 2013-06-19 | FGBM | Futures | 117.25 | 117.42 | 116.74 | 117.29 | 416171.0 |
| 2013-06-19 | FGBS | Futures | 110.218 | 110.278 | 110.123 | 110.253 | 331132.0 |
| 2013-06-19 | FGBX | Futures | 124.78 | 125.53 | 124.13 | 124.99 | 9311.0 |
| 2013-06-19 | FMWO | Futures | 4863.5 | 4863.5 | 4863.5 | 4863.5 | 0.0 |
| 2013-06-19 | FOAT | Futures | 107.46 | 107.63 | 107.31 | 107.51 | 28105.0 |
| 2013-06-19 | FTDX | Futures | 902.3 | 903.7 | 897.6 | 900.9 | 43.0 |
| 2013-06-19 | FTI | Futures | 306.31 | 307.79 | 304.44 | 306.14 | 36298.0 |
| 2013-06-19 | FTUK | Futures | 4751.3 | 4757.7 | 4701.4 | 4730.7 | 130505.0 |
| 2013-06-19 | FVSA | Futures | 3180.9 | 3232.69 | 3106.93 | 3106.93 | 8081.0 |
| 2013-06-19 | FXXP | Futures | 215.7 | 215.8 | 214.0 | 214.9 | 10960.0 |
| 2013-06-19 | G | Futures | 96.79 | 97.06 | 96.7 | 96.81 | 121396.0 |
| 2013-06-19 | GF | Futures | 242.624 | 244.351 | 242.329 | 243.719 | 2125.0 |
| 2013-06-19 | GSCI | Futures | 1044.28 | 1048.97 | 1042.39 | 1048.15 | 201.0 |
| 2013-06-19 | HE | Futures | 98.711 | 100.928 | 98.687 | 99.583 | 14574.0 |
| 2013-06-19 | HG | Futures | 4.0146 | 4.04 | 3.9759 | 3.9987 | 22005.0 |
> showing 50 of 104 rows — these rows as CSV