PREVIEW / futures_daily / 2015-04-20
file: by_date/futures_daily/2015/2015-04-20.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 |
|---|---|---|---|---|---|---|---|
| 2015-04-20 | ES | Futures | 2188.09 | 2205.44 | 2185.46 | 2198.61 | 1119881.0 |
| 2015-04-20 | NQ | Futures | 5058.33 | 5128.28 | 5053.1 | 5117.25 | 218236.0 |
| 2015-04-20 | YM | Futures | 18210.0 | 18427.8 | 18196.7 | 18353.2 | 132108.0 |
| 2015-04-20 | CL | Futures | 98.06 | 99.55 | 95.77 | 98.28 | 384481.0 |
| 2015-04-20 | GC | Futures | 1575.9 | 1582.0 | 1558.1 | 1561.9 | 137017.0 |
| 2015-04-20 | ZN | Futures | 122.752569 | 122.944971 | 122.604567 | 122.693368 | 789143.0 |
| 2015-04-20 | A6 | Futures | 0.76759 | 0.76936 | 0.75763 | 0.75871 | 82921.0 |
| 2015-04-20 | AD | Futures | 0.83476 | 0.83762 | 0.83221 | 0.83425 | 49514.0 |
| 2015-04-20 | ALI | Futures | 2531.86 | 2531.86 | 2531.86 | 2531.86 | 0.0 |
| 2015-04-20 | B | Futures | 61.61 | 62.14 | 59.92 | 61.22 | 239802.0 |
| 2015-04-20 | B6 | Futures | 1.5749 | 1.5766 | 1.5665 | 1.5679 | 55368.0 |
| 2015-04-20 | BFX | Futures | 4582.5 | 4584.9 | 4582.5 | 4584.9 | 1.0 |
| 2015-04-20 | BR | Futures | 0.18528 | 0.18625 | 0.18494 | 0.18614 | 86.0 |
| 2015-04-20 | BZ | Futures | 61.12 | 61.57 | 59.39 | 60.69 | 18561.0 |
| 2015-04-20 | C | Futures | 2119.0 | 2119.0 | 2079.0 | 2082.0 | 4110.0 |
| 2015-04-20 | CB | Futures | 153.333 | 153.758 | 152.119 | 152.929 | 73.0 |
| 2015-04-20 | CC | Futures | 2083.0 | 2085.0 | 2047.0 | 2051.0 | 17309.0 |
| 2015-04-20 | CNH | Futures | 7.007 | 7.0073 | 7.0043 | 7.0043 | 3.0 |
| 2015-04-20 | CSC | Futures | 4.378 | 4.484 | 4.378 | 4.455 | 27.0 |
| 2015-04-20 | CT | Futures | 81.13 | 81.66 | 80.39 | 80.8 | 3379.0 |
| 2015-04-20 | DC | Futures | 35.94 | 36.89 | 35.94 | 36.66 | 283.0 |
| 2015-04-20 | DX | Futures | 91.644 | 92.305 | 91.564 | 92.169 | 34995.0 |
| 2015-04-20 | E1 | Futures | 1.34183 | 1.34476 | 1.33061 | 1.33533 | 22629.0 |
| 2015-04-20 | E6 | Futures | 1.27235 | 1.27318 | 1.2606 | 1.26342 | 182729.0 |
| 2015-04-20 | E7 | Futures | 1.266 | 1.266 | 1.2533 | 1.2561 | 4406.0 |
| 2015-04-20 | EBM | Futures | 293.25 | 295.66 | 292.85 | 293.25 | 19241.0 |
| 2015-04-20 | ED | Futures | 95.5429 | 95.5525 | 95.5381 | 95.5477 | 260208.0 |
| 2015-04-20 | ER | Futures | 98.068 | 98.073 | 98.063 | 98.063 | 32085.0 |
| 2015-04-20 | EW | Futures | 1592.2 | 1602.9 | 1590.5 | 1598.9 | 13054.0 |
| 2015-04-20 | FBTP | Futures | 102.12 | 102.62 | 101.89 | 102.15 | 84571.0 |
| 2015-04-20 | FBTS | Futures | 99.537 | 99.635 | 99.537 | 99.555 | 21356.0 |
| 2015-04-20 | FCE | Futures | 4185.0 | 4219.2 | 4179.3 | 4217.1 | 87875.0 |
| 2015-04-20 | FDAX | Futures | 13025.6 | 13245.3 | 13000.1 | 13222.6 | 97151.0 |
| 2015-04-20 | FDIV | Futures | 163.8 | 164.17 | 163.8 | 164.17 | 2.0 |
| 2015-04-20 | FESX | Futures | 2666.7 | 2692.5 | 2658.6 | 2689.5 | 879614.0 |
| 2015-04-20 | FEU3 | Futures | 98.715 | 98.715 | 98.71 | 98.71 | 1055.0 |
| 2015-04-20 | FGBL | Futures | 142.45 | 142.6 | 142.36 | 142.47 | 353245.0 |
| 2015-04-20 | FGBM | Futures | 125.08 | 125.11 | 124.99 | 125.03 | 212848.0 |
| 2015-04-20 | FGBS | Futures | 111.298 | 111.303 | 111.278 | 111.288 | 141597.0 |
| 2015-04-20 | FGBX | Futures | 182.42 | 182.79 | 182.12 | 182.5 | 18204.0 |
| 2015-04-20 | FMWO | Futures | 5858.2 | 5873.0 | 5848.3 | 5869.3 | 593.0 |
| 2015-04-20 | FOAT | Futures | 130.86 | 131.05 | 130.77 | 130.93 | 53437.0 |
| 2015-04-20 | FTDX | Futures | 1526.5 | 1548.5 | 1526.5 | 1545.3 | 156.0 |
| 2015-04-20 | FTI | Futures | 427.48 | 432.58 | 427.48 | 431.67 | 25544.0 |
| 2015-04-20 | FTUK | Futures | 5494.5 | 5535.8 | 5488.2 | 5521.7 | 70985.0 |
| 2015-04-20 | FVSA | Futures | 1784.59 | 1784.59 | 1689.62 | 1729.19 | 14747.0 |
| 2015-04-20 | FXXP | Futures | 306.7 | 309.1 | 306.7 | 308.8 | 16803.0 |
| 2015-04-20 | G | Futures | 104.99 | 105.23 | 104.87 | 105.14 | 106312.0 |
| 2015-04-20 | GF | Futures | 357.105 | 357.664 | 351.52 | 352.551 | 4937.0 |
| 2015-04-20 | GSCI | Futures | 737.4 | 739.27 | 728.38 | 733.49 | 101.0 |
> showing 50 of 108 rows — these rows as CSV