PREVIEW / futures_daily / 2016-05-31
file: by_date/futures_daily/2016/2016-05-31.parquet size: 9 KB rows: 109
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-31 | ES | Futures | 2254.81 | 2258.83 | 2239.78 | 2249.44 | 1631254.0 |
| 2016-05-31 | NQ | Futures | 5308.98 | 5320.73 | 5284.59 | 5316.03 | 209605.0 |
| 2016-05-31 | YM | Futures | 18583.5 | 18620.9 | 18411.9 | 18480.6 | 138981.0 |
| 2016-05-31 | CL | Futures | 58.07 | 58.73 | 57.22 | 57.56 | 476988.0 |
| 2016-05-31 | GC | Futures | 1563.2 | 1570.3 | 1545.7 | 1566.3 | 236147.0 |
| 2016-05-31 | ZN | Futures | 125.042204 | 125.328859 | 124.846071 | 125.328859 | 377106.0 |
| 2016-05-31 | A6 | Futures | 0.72638 | 0.73519 | 0.72314 | 0.73002 | 150468.0 |
| 2016-05-31 | AD | Futures | 0.78474 | 0.78545 | 0.7784 | 0.7786 | 90107.0 |
| 2016-05-31 | ALI | Futures | 2083.69 | 2083.69 | 2083.69 | 2083.69 | 3.0 |
| 2016-05-31 | B | Futures | 40.77 | 41.23 | 40.12 | 40.44 | 229126.0 |
| 2016-05-31 | B6 | Futures | 1.5382 | 1.5509 | 1.5231 | 1.5233 | 180422.0 |
| 2016-05-31 | BFX | Futures | 4144.1 | 4148.8 | 4128.8 | 4128.8 | 7.0 |
| 2016-05-31 | BR | Futures | 0.1784 | 0.1796 | 0.1784 | 0.17897 | 171.0 |
| 2016-05-31 | BZ | Futures | 40.56 | 41.12 | 40.06 | 40.34 | 22931.0 |
| 2016-05-31 | C | Futures | 2304.0 | 2346.0 | 2304.0 | 2341.0 | 13422.0 |
| 2016-05-31 | CB | Futures | 254.398 | 254.398 | 254.398 | 254.398 | 4.0 |
| 2016-05-31 | CC | Futures | 2208.0 | 2252.0 | 2208.0 | 2238.0 | 24348.0 |
| 2016-05-31 | CNH | Futures | 7.1597 | 7.1638 | 7.1571 | 7.1585 | 12.0 |
| 2016-05-31 | CSC | Futures | 3.327 | 3.327 | 3.31 | 3.31 | 75.0 |
| 2016-05-31 | CT | Futures | 73.12 | 73.32 | 71.55 | 72.73 | 17351.0 |
| 2016-05-31 | DC | Futures | 26.05 | 26.08 | 26.03 | 26.03 | 19.0 |
| 2016-05-31 | DX | Futures | 89.129 | 89.4 | 88.994 | 89.388 | 17721.0 |
| 2016-05-31 | E1 | Futures | 1.2635 | 1.27142 | 1.26262 | 1.26426 | 25055.0 |
| 2016-05-31 | E6 | Futures | 1.29663 | 1.30362 | 1.29482 | 1.29803 | 210972.0 |
| 2016-05-31 | E7 | Futures | 1.2897 | 1.2965 | 1.2878 | 1.291 | 4459.0 |
| 2016-05-31 | EBM | Futures | 200.28 | 201.78 | 197.87 | 198.17 | 12335.0 |
| 2016-05-31 | ED | Futures | 95.6678 | 95.6871 | 95.6654 | 95.6846 | 266502.0 |
| 2016-05-31 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.264 | 28352.0 |
| 2016-05-31 | EW | Futures | 1579.4 | 1583.8 | 1571.7 | 1576.9 | 22448.0 |
| 2016-05-31 | FBON | Futures | 119.28 | 119.42 | 119.14 | 119.32 | 302.0 |
| 2016-05-31 | FBTP | Futures | 107.4 | 107.4 | 107.05 | 107.22 | 85728.0 |
| 2016-05-31 | FBTS | Futures | 101.158 | 101.176 | 101.15 | 101.158 | 15562.0 |
| 2016-05-31 | FCE | Futures | 3881.4 | 3884.4 | 3841.8 | 3856.4 | 66363.0 |
| 2016-05-31 | FDAX | Futures | 11130.9 | 11144.3 | 10988.0 | 11025.1 | 80741.0 |
| 2016-05-31 | FDXM | Futures | 10717.1 | 10730.6 | 10581.6 | 10616.8 | 13819.0 |
| 2016-05-31 | FESX | Futures | 2408.6 | 2409.4 | 2372.0 | 2381.3 | 1182712.0 |
| 2016-05-31 | FGBL | Futures | 146.47 | 146.87 | 146.14 | 146.66 | 771355.0 |
| 2016-05-31 | FGBM | Futures | 127.7 | 127.79 | 127.59 | 127.71 | 746657.0 |
| 2016-05-31 | FGBS | Futures | 111.673 | 111.683 | 111.648 | 111.668 | 345114.0 |
| 2016-05-31 | FGBX | Futures | 172.59 | 174.03 | 171.95 | 173.47 | 51162.0 |
| 2016-05-31 | FMWO | Futures | 5717.3 | 5724.8 | 5697.4 | 5702.4 | 76.0 |
| 2016-05-31 | FOAT | Futures | 134.07 | 134.31 | 133.72 | 134.15 | 107943.0 |
| 2016-05-31 | FTDX | Futures | 1609.0 | 1611.8 | 1606.1 | 1610.9 | 154.0 |
| 2016-05-31 | FTI | Futures | 406.36 | 406.68 | 400.48 | 402.05 | 22842.0 |
| 2016-05-31 | FTUK | Futures | 5166.2 | 5181.0 | 5111.7 | 5132.7 | 125531.0 |
| 2016-05-31 | FVSA | Futures | 2234.08 | 2355.1 | 2234.08 | 2327.17 | 11627.0 |
| 2016-05-31 | FXXP | Futures | 281.4 | 281.7 | 277.2 | 278.6 | 41598.0 |
| 2016-05-31 | G | Futures | 108.35 | 108.77 | 108.13 | 108.62 | 206879.0 |
| 2016-05-31 | GF | Futures | 294.333 | 296.629 | 293.035 | 293.734 | 3866.0 |
| 2016-05-31 | GSCI | Futures | 539.48 | 541.87 | 533.56 | 535.0 | 404.0 |
> showing 50 of 109 rows — these rows as CSV