PREVIEW / futures_daily / 2016-07-15
file: by_date/futures_daily/2016/2016-07-15.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 |
|---|---|---|---|---|---|---|---|
| 2016-07-15 | ES | Futures | 2328.35 | 2337.26 | 2314.05 | 2324.3 | 1518276.0 |
| 2016-07-15 | NQ | Futures | 5404.5 | 5426.31 | 5363.54 | 5397.72 | 171716.0 |
| 2016-07-15 | YM | Futures | 19241.1 | 19311.0 | 19161.7 | 19236.9 | 129046.0 |
| 2016-07-15 | CL | Futures | 52.43 | 53.33 | 51.89 | 52.88 | 265014.0 |
| 2016-07-15 | GC | Futures | 1719.3 | 1723.3 | 1701.5 | 1707.7 | 191831.0 |
| 2016-07-15 | ZN | Futures | 127.818569 | 127.984567 | 127.275302 | 127.365846 | 1236322.0 |
| 2016-07-15 | A6 | Futures | 0.77457 | 0.77945 | 0.76744 | 0.77121 | 98696.0 |
| 2016-07-15 | AD | Futures | 0.79357 | 0.79572 | 0.788 | 0.79081 | 57547.0 |
| 2016-07-15 | ALI | Futures | 2188.09 | 2188.09 | 2161.75 | 2176.03 | 25.0 |
| 2016-07-15 | B | Futures | 37.55 | 38.52 | 37.24 | 38.01 | 260430.0 |
| 2016-07-15 | B6 | Futures | 1.4059 | 1.4219 | 1.3851 | 1.3927 | 151196.0 |
| 2016-07-15 | BR | Futures | 0.20163 | 0.20163 | 0.20017 | 0.20127 | 11.0 |
| 2016-07-15 | BZ | Futures | 37.51 | 38.24 | 37.11 | 37.87 | 24450.0 |
| 2016-07-15 | C | Futures | 2633.0 | 2650.0 | 2603.0 | 2609.0 | 8527.0 |
| 2016-07-15 | CB | Futures | 280.157 | 282.414 | 280.157 | 281.915 | 14.0 |
| 2016-07-15 | CC | Futures | 2315.0 | 2321.0 | 2241.0 | 2247.0 | 22766.0 |
| 2016-07-15 | CNH | Futures | 7.2535 | 7.272 | 7.2535 | 7.272 | 4.0 |
| 2016-07-15 | CSC | Futures | 3.678 | 3.728 | 3.633 | 3.682 | 75.0 |
| 2016-07-15 | CT | Futures | 83.08 | 84.4 | 83.08 | 83.67 | 70.0 |
| 2016-07-15 | DC | Futures | 29.55 | 29.98 | 29.16 | 29.66 | 283.0 |
| 2016-07-15 | DX | Futures | 89.425 | 89.983 | 89.211 | 89.809 | 22806.0 |
| 2016-07-15 | E1 | Futures | 1.28018 | 1.28406 | 1.27567 | 1.2778 | 13388.0 |
| 2016-07-15 | E6 | Futures | 1.29702 | 1.30115 | 1.28666 | 1.29091 | 141796.0 |
| 2016-07-15 | E7 | Futures | 1.2903 | 1.294 | 1.2798 | 1.2841 | 3476.0 |
| 2016-07-15 | EBM | Futures | 191.56 | 192.76 | 185.54 | 191.86 | 14371.0 |
| 2016-07-15 | ED | Futures | 95.7666 | 95.7714 | 95.7377 | 95.7425 | 337583.0 |
| 2016-07-15 | ER | Futures | 98.318 | 98.318 | 98.303 | 98.313 | 40878.0 |
| 2016-07-15 | EW | Futures | 1633.5 | 1640.3 | 1623.4 | 1633.5 | 13239.0 |
| 2016-07-15 | FBON | Futures | 122.6 | 122.61 | 121.93 | 121.98 | 328.0 |
| 2016-07-15 | FBTP | Futures | 109.43 | 109.62 | 109.04 | 109.17 | 65330.0 |
| 2016-07-15 | FBTS | Futures | 101.266 | 101.284 | 101.248 | 101.266 | 13981.0 |
| 2016-07-15 | FCE | Futures | 3804.4 | 3827.1 | 3790.0 | 3816.6 | 87650.0 |
| 2016-07-15 | FDAX | Futures | 10668.0 | 10739.3 | 10603.1 | 10694.1 | 70113.0 |
| 2016-07-15 | FDXM | Futures | 10402.6 | 10469.0 | 10337.2 | 10423.8 | 20931.0 |
| 2016-07-15 | FESX | Futures | 2306.3 | 2321.2 | 2293.0 | 2309.5 | 1028699.0 |
| 2016-07-15 | FGBL | Futures | 150.07 | 150.12 | 149.32 | 149.42 | 482625.0 |
| 2016-07-15 | FGBM | Futures | 129.0 | 129.02 | 128.78 | 128.83 | 339802.0 |
| 2016-07-15 | FGBS | Futures | 111.952 | 111.962 | 111.907 | 111.922 | 176900.0 |
| 2016-07-15 | FGBX | Futures | 187.15 | 187.52 | 184.4 | 184.77 | 24072.0 |
| 2016-07-15 | FMWO | Futures | 5682.0 | 5692.9 | 5671.1 | 5675.9 | 198.0 |
| 2016-07-15 | FOAT | Futures | 138.03 | 138.09 | 137.39 | 137.49 | 66240.0 |
| 2016-07-15 | FTDX | Futures | 1567.2 | 1567.2 | 1548.4 | 1563.8 | 75.0 |
| 2016-07-15 | FTI | Futures | 399.21 | 400.65 | 397.19 | 399.48 | 31636.0 |
| 2016-07-15 | FTUK | Futures | 5510.6 | 5527.7 | 5470.9 | 5514.3 | 112215.0 |
| 2016-07-15 | FVSA | Futures | 2293.8 | 2352.36 | 2269.4 | 2279.16 | 16916.0 |
| 2016-07-15 | FXXP | Futures | 272.1 | 273.1 | 270.9 | 272.2 | 25728.0 |
| 2016-07-15 | G | Futures | 114.91 | 114.95 | 114.39 | 114.42 | 128828.0 |
| 2016-07-15 | GF | Futures | 283.75 | 285.048 | 278.059 | 278.708 | 3746.0 |
| 2016-07-15 | GSCI | Futures | 522.2 | 522.2 | 518.47 | 518.47 | 55.0 |
| 2016-07-15 | HE | Futures | 93.808 | 93.928 | 92.942 | 93.121 | 12829.0 |
> showing 50 of 108 rows — these rows as CSV