PREVIEW / futures_daily / 2016-05-11
file: by_date/futures_daily/2016/2016-05-11.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-05-11 | ES | Futures | 2230.38 | 2231.99 | 2209.17 | 2209.71 | 1471852.0 |
| 2016-05-11 | NQ | Futures | 5163.28 | 5173.56 | 5112.16 | 5113.04 | 208025.0 |
| 2016-05-11 | YM | Futures | 18536.7 | 18559.6 | 18357.9 | 18361.0 | 138964.0 |
| 2016-05-11 | CL | Futures | 53.13 | 55.23 | 52.37 | 55.07 | 869957.0 |
| 2016-05-11 | GC | Futures | 1633.5 | 1650.9 | 1632.2 | 1644.0 | 239700.0 |
| 2016-05-11 | ZN | Futures | 126.249175 | 126.581092 | 126.158652 | 126.400046 | 1105210.0 |
| 2016-05-11 | A6 | Futures | 0.7451 | 0.74844 | 0.74146 | 0.74571 | 91840.0 |
| 2016-05-11 | AD | Futures | 0.7919 | 0.79691 | 0.79006 | 0.79629 | 63971.0 |
| 2016-05-11 | ALI | Futures | 2124.75 | 2124.75 | 2113.44 | 2119.58 | 7.0 |
| 2016-05-11 | B | Futures | 37.84 | 39.64 | 37.19 | 39.51 | 381737.0 |
| 2016-05-11 | B6 | Futures | 1.5211 | 1.5258 | 1.516 | 1.522 | 68573.0 |
| 2016-05-11 | BR | Futures | 0.18568 | 0.18793 | 0.18568 | 0.18786 | 999.0 |
| 2016-05-11 | BZ | Futures | 37.67 | 39.5 | 37.09 | 39.38 | 40873.0 |
| 2016-05-11 | C | Futures | 2368.0 | 2384.0 | 2344.0 | 2346.0 | 20194.0 |
| 2016-05-11 | CB | Futures | 253.646 | 256.207 | 253.646 | 255.75 | 15.0 |
| 2016-05-11 | CC | Futures | 2253.0 | 2281.0 | 2243.0 | 2246.0 | 18368.0 |
| 2016-05-11 | CNH | Futures | 7.1022 | 7.1022 | 7.1004 | 7.1004 | 4.0 |
| 2016-05-11 | CSC | Futures | 3.305 | 3.384 | 3.305 | 3.362 | 86.0 |
| 2016-05-11 | CT | Futures | 69.46 | 70.24 | 68.88 | 68.93 | 19861.0 |
| 2016-05-11 | DC | Futures | 25.86 | 26.5 | 25.78 | 26.36 | 780.0 |
| 2016-05-11 | DX | Futures | 87.838 | 87.838 | 87.311 | 87.442 | 18917.0 |
| 2016-05-11 | E1 | Futures | 1.28889 | 1.29718 | 1.28876 | 1.29554 | 13701.0 |
| 2016-05-11 | E6 | Futures | 1.32753 | 1.33622 | 1.32712 | 1.33377 | 117879.0 |
| 2016-05-11 | E7 | Futures | 1.3202 | 1.3289 | 1.3201 | 1.3266 | 1724.0 |
| 2016-05-11 | EBM | Futures | 193.36 | 194.27 | 191.56 | 192.76 | 8955.0 |
| 2016-05-11 | ED | Futures | 95.7545 | 95.7642 | 95.7497 | 95.7545 | 141595.0 |
| 2016-05-11 | ER | Futures | 98.269 | 98.269 | 98.264 | 98.269 | 13277.0 |
| 2016-05-11 | EW | Futures | 1548.2 | 1550.4 | 1533.3 | 1533.8 | 12709.0 |
| 2016-05-11 | FBON | Futures | 117.6 | 118.11 | 117.6 | 118.11 | 214.0 |
| 2016-05-11 | FBTP | Futures | 105.97 | 106.36 | 105.71 | 106.32 | 107517.0 |
| 2016-05-11 | FBTS | Futures | 101.087 | 101.105 | 101.078 | 101.096 | 11335.0 |
| 2016-05-11 | FCE | Futures | 3678.8 | 3683.5 | 3636.8 | 3660.6 | 86678.0 |
| 2016-05-11 | FDAX | Futures | 10807.0 | 10815.1 | 10664.7 | 10718.9 | 92884.0 |
| 2016-05-11 | FDIV | Futures | 129.47 | 129.47 | 128.82 | 128.82 | 11.0 |
| 2016-05-11 | FDXM | Futures | 10407.8 | 10413.0 | 10269.2 | 10322.0 | 20782.0 |
| 2016-05-11 | FESX | Futures | 2297.1 | 2301.0 | 2267.4 | 2280.7 | 1203873.0 |
| 2016-05-11 | FGBL | Futures | 146.92 | 147.0 | 146.66 | 146.85 | 562603.0 |
| 2016-05-11 | FGBM | Futures | 127.8 | 127.82 | 127.72 | 127.79 | 448733.0 |
| 2016-05-11 | FGBS | Futures | 111.683 | 111.688 | 111.668 | 111.678 | 159891.0 |
| 2016-05-11 | FGBX | Futures | 174.61 | 174.69 | 173.74 | 174.22 | 41660.0 |
| 2016-05-11 | FMWO | Futures | 5621.6 | 5644.0 | 5621.6 | 5637.7 | 223.0 |
| 2016-05-11 | FOAT | Futures | 134.14 | 134.3 | 133.92 | 134.25 | 76578.0 |
| 2016-05-11 | FTDX | Futures | 1555.7 | 1562.8 | 1553.3 | 1561.8 | 83.0 |
| 2016-05-11 | FTI | Futures | 387.54 | 388.4 | 385.88 | 387.63 | 62.0 |
| 2016-05-11 | FTUK | Futures | 5050.6 | 5063.8 | 5027.9 | 5058.5 | 91246.0 |
| 2016-05-11 | FVSA | Futures | 2565.73 | 2639.18 | 2539.49 | 2555.23 | 10972.0 |
| 2016-05-11 | FXXP | Futures | 268.0 | 268.1 | 265.5 | 266.7 | 26720.0 |
| 2016-05-11 | G | Futures | 108.92 | 109.08 | 108.79 | 108.95 | 171962.0 |
| 2016-05-11 | GF | Futures | 300.373 | 303.918 | 296.28 | 298.077 | 5828.0 |
| 2016-05-11 | GSCI | Futures | 512.88 | 521.7 | 512.88 | 521.7 | 2118.0 |
> showing 50 of 108 rows — these rows as CSV