PREVIEW / futures_daily / 2016-05-24
file: by_date/futures_daily/2016/2016-05-24.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-24 | ES | Futures | 2195.75 | 2230.38 | 2191.73 | 2227.96 | 1603195.0 |
| 2016-05-24 | NQ | Futures | 5113.04 | 5227.31 | 5101.59 | 5223.2 | 239635.0 |
| 2016-05-24 | YM | Futures | 18163.4 | 18422.3 | 18129.1 | 18390.1 | 136098.0 |
| 2016-05-24 | CL | Futures | 56.36 | 57.76 | 55.85 | 56.99 | 475965.0 |
| 2016-05-24 | GC | Futures | 1610.5 | 1614.8 | 1580.5 | 1584.4 | 322961.0 |
| 2016-05-24 | ZN | Futures | 125.313772 | 125.419382 | 124.936594 | 125.102552 | 1721686.0 |
| 2016-05-24 | A6 | Futures | 0.73043 | 0.73114 | 0.72264 | 0.72618 | 107635.0 |
| 2016-05-24 | AD | Futures | 0.77768 | 0.78136 | 0.77523 | 0.77799 | 63783.0 |
| 2016-05-24 | ALI | Futures | 2093.02 | 2093.02 | 2088.84 | 2088.84 | 3.0 |
| 2016-05-24 | B | Futures | 40.13 | 40.87 | 39.68 | 40.35 | 211583.0 |
| 2016-05-24 | B6 | Futures | 1.5252 | 1.542 | 1.5246 | 1.5407 | 105308.0 |
| 2016-05-24 | BR | Futures | 0.18106 | 0.18324 | 0.18093 | 0.18103 | 1464.0 |
| 2016-05-24 | BZ | Futures | 40.01 | 40.75 | 39.56 | 40.22 | 27698.0 |
| 2016-05-24 | C | Futures | 2327.0 | 2345.0 | 2284.0 | 2295.0 | 10253.0 |
| 2016-05-24 | CB | Futures | 255.541 | 255.541 | 254.369 | 255.189 | 87.0 |
| 2016-05-24 | CC | Futures | 2193.0 | 2208.0 | 2145.0 | 2160.0 | 24407.0 |
| 2016-05-24 | CNH | Futures | 7.1369 | 7.1411 | 7.1369 | 7.1403 | 5.0 |
| 2016-05-24 | CSC | Futures | 3.269 | 3.315 | 3.269 | 3.31 | 57.0 |
| 2016-05-24 | CT | Futures | 69.82 | 71.89 | 69.56 | 71.67 | 25666.0 |
| 2016-05-24 | DC | Futures | 25.74 | 26.07 | 25.53 | 26.03 | 450.0 |
| 2016-05-24 | DX | Futures | 88.831 | 89.195 | 88.761 | 89.107 | 13642.0 |
| 2016-05-24 | E1 | Futures | 1.27042 | 1.27117 | 1.26539 | 1.26652 | 16354.0 |
| 2016-05-24 | E6 | Futures | 1.30928 | 1.3101 | 1.29908 | 1.30059 | 156259.0 |
| 2016-05-24 | E7 | Futures | 1.3019 | 1.3029 | 1.292 | 1.2935 | 2604.0 |
| 2016-05-24 | EBM | Futures | 194.57 | 197.57 | 194.57 | 196.67 | 8620.0 |
| 2016-05-24 | ED | Futures | 95.6702 | 95.6726 | 95.6557 | 95.6654 | 215128.0 |
| 2016-05-24 | ER | Futures | 98.259 | 98.264 | 98.259 | 98.264 | 10684.0 |
| 2016-05-24 | EW | Futures | 1528.0 | 1555.7 | 1524.1 | 1555.1 | 21691.0 |
| 2016-05-24 | FBON | Futures | 118.44 | 118.74 | 118.44 | 118.63 | 432.0 |
| 2016-05-24 | FBTP | Futures | 106.35 | 106.83 | 106.2 | 106.65 | 85704.0 |
| 2016-05-24 | FBTS | Futures | 101.105 | 101.141 | 101.105 | 101.132 | 13675.0 |
| 2016-05-24 | FCE | Futures | 3675.2 | 3797.4 | 3665.7 | 3780.7 | 121921.0 |
| 2016-05-24 | FDAX | Futures | 10539.0 | 10874.2 | 10491.7 | 10818.8 | 122770.0 |
| 2016-05-24 | FDXM | Futures | 10151.3 | 10475.1 | 10103.7 | 10418.2 | 22731.0 |
| 2016-05-24 | FESX | Futures | 2268.2 | 2348.6 | 2262.8 | 2339.2 | 1663432.0 |
| 2016-05-24 | FGBL | Futures | 146.41 | 146.48 | 146.16 | 146.25 | 582223.0 |
| 2016-05-24 | FGBM | Futures | 127.65 | 127.67 | 127.58 | 127.6 | 417241.0 |
| 2016-05-24 | FGBS | Futures | 111.658 | 111.663 | 111.653 | 111.653 | 114968.0 |
| 2016-05-24 | FGBX | Futures | 172.61 | 172.92 | 171.89 | 172.15 | 35749.0 |
| 2016-05-24 | FMWO | Futures | 5579.3 | 5644.0 | 5579.3 | 5642.7 | 123.0 |
| 2016-05-24 | FOAT | Futures | 134.02 | 134.14 | 133.86 | 133.93 | 85094.0 |
| 2016-05-24 | FTDX | Futures | 1594.7 | 1600.9 | 1586.1 | 1595.6 | 214.0 |
| 2016-05-24 | FTI | Futures | 387.18 | 398.32 | 386.2 | 396.35 | 39346.0 |
| 2016-05-24 | FTUK | Futures | 5049.0 | 5138.9 | 5027.5 | 5130.3 | 125558.0 |
| 2016-05-24 | FVSA | Futures | 2536.62 | 2536.62 | 2364.41 | 2378.37 | 18735.0 |
| 2016-05-24 | FXXP | Futures | 268.4 | 276.5 | 268.0 | 276.1 | 33426.0 |
| 2016-05-24 | G | Futures | 108.63 | 108.67 | 108.18 | 108.26 | 570381.0 |
| 2016-05-24 | GF | Futures | 284.449 | 285.247 | 279.107 | 283.75 | 6082.0 |
| 2016-05-24 | GSCI | Futures | 528.42 | 530.23 | 527.05 | 529.51 | 196.0 |
| 2016-05-24 | HE | Futures | 96.608 | 97.065 | 96.03 | 96.974 | 8724.0 |
> showing 50 of 108 rows — these rows as CSV