PREVIEW / futures_daily / 2015-05-11
file: by_date/futures_daily/2015/2015-05-11.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-11 | ES | Futures | 2218.59 | 2222.27 | 2203.6 | 2205.71 | 1147278.0 |
| 2015-05-11 | NQ | Futures | 5169.5 | 5183.43 | 5139.6 | 5144.83 | 170514.0 |
| 2015-05-11 | YM | Futures | 18543.4 | 18566.9 | 18437.0 | 18453.4 | 112003.0 |
| 2015-05-11 | CL | Futures | 100.91 | 101.63 | 99.76 | 100.61 | 332694.0 |
| 2015-05-11 | GC | Futures | 1555.8 | 1558.3 | 1541.4 | 1547.9 | 128097.0 |
| 2015-05-11 | ZN | Futures | 121.05055 | 121.242952 | 120.103339 | 120.19214 | 1329172.0 |
| 2015-05-11 | A6 | Futures | 0.78011 | 0.781 | 0.77538 | 0.77804 | 58702.0 |
| 2015-05-11 | AD | Futures | 0.84436 | 0.84589 | 0.84038 | 0.84385 | 42610.0 |
| 2015-05-11 | ALI | Futures | 2548.96 | 2548.96 | 2548.96 | 2548.96 | 0.0 |
| 2015-05-11 | B | Futures | 62.97 | 63.33 | 61.88 | 62.46 | 192324.0 |
| 2015-05-11 | B6 | Futures | 1.6264 | 1.6431 | 1.6198 | 1.6406 | 119348.0 |
| 2015-05-11 | BFX | Futures | 4428.2 | 4439.0 | 4418.5 | 4439.0 | 218.0 |
| 2015-05-11 | BR | Futures | 0.19196 | 0.19196 | 0.1844 | 0.18514 | 1089.0 |
| 2015-05-11 | BZ | Futures | 62.35 | 62.69 | 61.31 | 61.86 | 15213.0 |
| 2015-05-11 | C | Futures | 2163.0 | 2183.0 | 2152.0 | 2179.0 | 12007.0 |
| 2015-05-11 | CB | Futures | 166.805 | 169.921 | 166.805 | 167.149 | 50.0 |
| 2015-05-11 | CC | Futures | 2168.0 | 2220.0 | 2164.0 | 2218.0 | 17872.0 |
| 2015-05-11 | CNH | Futures | 6.9959 | 6.9968 | 6.9959 | 6.9968 | 2.0 |
| 2015-05-11 | CSC | Futures | 4.732 | 4.743 | 4.612 | 4.626 | 88.0 |
| 2015-05-11 | CT | Futures | 83.34 | 83.53 | 81.44 | 82.37 | 15548.0 |
| 2015-05-11 | DC | Futures | 39.11 | 39.29 | 38.21 | 38.3 | 510.0 |
| 2015-05-11 | DX | Futures | 89.09 | 89.526 | 89.075 | 89.296 | 27362.0 |
| 2015-05-11 | E1 | Futures | 1.36923 | 1.37241 | 1.36413 | 1.36642 | 15228.0 |
| 2015-05-11 | E6 | Futures | 1.31775 | 1.31833 | 1.30951 | 1.31245 | 214954.0 |
| 2015-05-11 | E7 | Futures | 1.31 | 1.3105 | 1.3019 | 1.3049 | 5210.0 |
| 2015-05-11 | EBM | Futures | 285.28 | 287.74 | 283.64 | 284.46 | 7119.0 |
| 2015-05-11 | ED | Futures | 95.5621 | 95.5669 | 95.5573 | 95.5573 | 100433.0 |
| 2015-05-11 | ER | Futures | 98.077 | 98.077 | 98.068 | 98.073 | 20574.0 |
| 2015-05-11 | EW | Futures | 1586.9 | 1595.3 | 1582.2 | 1587.2 | 13800.0 |
| 2015-05-11 | FBTP | Futures | 100.38 | 100.39 | 99.54 | 99.76 | 78878.0 |
| 2015-05-11 | FBTS | Futures | 99.679 | 99.688 | 99.643 | 99.679 | 14574.0 |
| 2015-05-11 | FCE | Futures | 4160.4 | 4161.2 | 4113.9 | 4133.2 | 170296.0 |
| 2015-05-11 | FDAX | Futures | 13010.6 | 13015.6 | 12883.1 | 12951.3 | 78929.0 |
| 2015-05-11 | FESX | Futures | 2658.6 | 2660.8 | 2634.3 | 2646.1 | 762159.0 |
| 2015-05-11 | FGBL | Futures | 137.5 | 137.73 | 136.28 | 136.93 | 720301.0 |
| 2015-05-11 | FGBM | Futures | 124.01 | 124.1 | 123.72 | 123.89 | 453777.0 |
| 2015-05-11 | FGBS | Futures | 111.203 | 111.218 | 111.188 | 111.208 | 181819.0 |
| 2015-05-11 | FGBX | Futures | 162.74 | 163.57 | 158.6 | 161.07 | 30812.0 |
| 2015-05-11 | FMWO | Futures | 5913.7 | 5922.3 | 5913.7 | 5921.1 | 145.0 |
| 2015-05-11 | FOAT | Futures | 126.25 | 126.4 | 125.47 | 125.75 | 75155.0 |
| 2015-05-11 | FTDX | Futures | 1564.0 | 1572.5 | 1558.4 | 1570.1 | 240.0 |
| 2015-05-11 | FTI | Futures | 425.26 | 428.31 | 424.7 | 427.7 | 13256.0 |
| 2015-05-11 | FTUK | Futures | 5535.5 | 5563.8 | 5499.6 | 5516.9 | 106142.0 |
| 2015-05-11 | FVSA | Futures | 1673.8 | 1709.41 | 1661.93 | 1669.84 | 9537.0 |
| 2015-05-11 | FXXP | Futures | 305.3 | 307.2 | 304.9 | 306.5 | 16502.0 |
| 2015-05-11 | G | Futures | 102.51 | 102.52 | 101.83 | 102.12 | 150421.0 |
| 2015-05-11 | GF | Futures | 370.982 | 372.64 | 368.857 | 369.664 | 4692.0 |
| 2015-05-11 | GSCI | Futures | 754.85 | 758.07 | 750.43 | 753.83 | 2531.0 |
| 2015-05-11 | HE | Futures | 92.318 | 92.318 | 91.123 | 91.53 | 20128.0 |
| 2015-05-11 | HG | Futures | 3.6744 | 3.6756 | 3.6336 | 3.6424 | 35908.0 |
> showing 50 of 105 rows — these rows as CSV