PREVIEW / futures_daily / 2016-06-07
file: by_date/futures_daily/2016/2016-06-07.parquet size: 9 KB rows: 111
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-07 | ES | Futures | 2263.67 | 2274.13 | 2261.79 | 2265.81 | 1125951.0 |
| 2016-06-07 | NQ | Futures | 5316.32 | 5340.99 | 5300.75 | 5304.28 | 155623.0 |
| 2016-06-07 | YM | Futures | 18627.2 | 18708.3 | 18614.7 | 18645.9 | 94989.0 |
| 2016-06-07 | CL | Futures | 58.27 | 59.23 | 57.96 | 59.03 | 542254.0 |
| 2016-06-07 | GC | Futures | 1605.6 | 1606.9 | 1591.3 | 1604.3 | 120505.0 |
| 2016-06-07 | ZN | Futures | 126.279349 | 126.520743 | 126.173739 | 126.43022 | 35285.0 |
| 2016-06-07 | A6 | Futures | 0.745 | 0.75533 | 0.7447 | 0.75442 | 99498.0 |
| 2016-06-07 | AD | Futures | 0.79721 | 0.80294 | 0.79639 | 0.801 | 69407.0 |
| 2016-06-07 | ALI | Futures | 2081.44 | 2085.94 | 2081.44 | 2084.01 | 8.0 |
| 2016-06-07 | B | Futures | 40.9 | 41.78 | 40.75 | 41.69 | 208823.0 |
| 2016-06-07 | B6 | Futures | 1.522 | 1.5446 | 1.5209 | 1.5323 | 143958.0 |
| 2016-06-07 | BFX | Futures | 4151.2 | 4168.2 | 4151.2 | 4168.2 | 9.0 |
| 2016-06-07 | BR | Futures | 0.18506 | 0.18835 | 0.18506 | 0.18835 | 155.0 |
| 2016-06-07 | BZ | Futures | 40.79 | 41.67 | 40.68 | 41.59 | 21088.0 |
| 2016-06-07 | C | Futures | 2359.0 | 2364.0 | 2341.0 | 2361.0 | 7622.0 |
| 2016-06-07 | CB | Futures | 262.017 | 263.483 | 261.988 | 261.988 | 11.0 |
| 2016-06-07 | CC | Futures | 2250.0 | 2264.0 | 2236.0 | 2253.0 | 18984.0 |
| 2016-06-07 | CNH | Futures | 7.1433 | 7.145 | 7.1336 | 7.1336 | 97.0 |
| 2016-06-07 | CSC | Futures | 3.487 | 3.487 | 3.397 | 3.405 | 95.0 |
| 2016-06-07 | CT | Futures | 74.57 | 75.26 | 74.16 | 74.9 | 28413.0 |
| 2016-06-07 | DC | Futures | 27.54 | 27.54 | 26.85 | 26.98 | 385.0 |
| 2016-06-07 | DX | Futures | 87.619 | 87.707 | 87.4 | 87.481 | 20414.0 |
| 2016-06-07 | E1 | Futures | 1.29492 | 1.30296 | 1.29379 | 1.30208 | 29354.0 |
| 2016-06-07 | E6 | Futures | 1.32479 | 1.32747 | 1.32258 | 1.32537 | 174732.0 |
| 2016-06-07 | E7 | Futures | 1.3177 | 1.3202 | 1.3155 | 1.3182 | 3028.0 |
| 2016-06-07 | EBM | Futures | 205.09 | 205.69 | 202.99 | 203.59 | 15415.0 |
| 2016-06-07 | ED | Futures | 95.7473 | 95.7545 | 95.7449 | 95.7521 | 109775.0 |
| 2016-06-07 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.269 | 12558.0 |
| 2016-06-07 | EW | Futures | 1598.8 | 1608.7 | 1597.0 | 1604.4 | 11583.0 |
| 2016-06-07 | FBON | Futures | 119.46 | 119.87 | 119.43 | 119.77 | 654.0 |
| 2016-06-07 | FBTP | Futures | 107.24 | 107.66 | 107.1 | 107.48 | 154454.0 |
| 2016-06-07 | FBTS | Futures | 101.158 | 101.203 | 101.15 | 101.176 | 28957.0 |
| 2016-06-07 | FCE | Futures | 3814.2 | 3859.4 | 3811.6 | 3849.1 | 73754.0 |
| 2016-06-07 | FDAX | Futures | 10915.0 | 11084.7 | 10909.6 | 11051.9 | 88141.0 |
| 2016-06-07 | FDIV | Futures | 133.82 | 133.86 | 133.82 | 133.86 | 45.0 |
| 2016-06-07 | FDXM | Futures | 10515.4 | 10671.6 | 10506.1 | 10641.6 | 14472.0 |
| 2016-06-07 | FESX | Futures | 2345.4 | 2379.8 | 2344.7 | 2370.4 | 1235757.0 |
| 2016-06-07 | FEU3 | Futures | 98.922 | 98.922 | 98.917 | 98.917 | 1.0 |
| 2016-06-07 | FGBL | Futures | 147.52 | 148.04 | 147.43 | 147.97 | 1030057.0 |
| 2016-06-07 | FGBM | Futures | 127.83 | 127.96 | 127.81 | 127.94 | 694429.0 |
| 2016-06-07 | FGBS | Futures | 111.703 | 111.713 | 111.693 | 111.708 | 422649.0 |
| 2016-06-07 | FGBX | Futures | 176.78 | 178.63 | 176.41 | 178.39 | 62581.0 |
| 2016-06-07 | FMWO | Futures | 5774.5 | 5788.2 | 5774.5 | 5784.5 | 215.0 |
| 2016-06-07 | FOAT | Futures | 134.93 | 135.39 | 134.74 | 135.32 | 152144.0 |
| 2016-06-07 | FTDX | Futures | 1615.6 | 1617.1 | 1610.9 | 1615.2 | 573.0 |
| 2016-06-07 | FTI | Futures | 401.38 | 406.23 | 401.29 | 405.64 | 23439.0 |
| 2016-06-07 | FTUK | Futures | 5166.2 | 5211.6 | 5161.6 | 5172.8 | 132401.0 |
| 2016-06-07 | FVSA | Futures | 2369.06 | 2396.99 | 2313.21 | 2355.1 | 11051.0 |
| 2016-06-07 | FXXP | Futures | 276.0 | 278.8 | 276.0 | 277.8 | 36453.0 |
| 2016-06-07 | G | Futures | 110.21 | 110.34 | 109.9 | 110.3 | 210790.0 |
> showing 50 of 111 rows — these rows as CSV