PREVIEW / futures_daily / 2015-07-30
file: by_date/futures_daily/2015/2015-07-30.parquet size: 9 KB rows: 107
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-07-30 | ES | Futures | 2225.09 | 2230.12 | 2212.63 | 2229.59 | 1286157.0 |
| 2015-07-30 | NQ | Futures | 5327.1 | 5369.13 | 5289.74 | 5365.04 | 226285.0 |
| 2015-07-30 | YM | Futures | 18143.4 | 18178.3 | 18029.4 | 18163.9 | 115910.0 |
| 2015-07-30 | CL | Futures | 81.08 | 81.96 | 80.26 | 80.56 | 247662.0 |
| 2015-07-30 | GC | Futures | 1415.6 | 1417.7 | 1396.1 | 1405.4 | 169098.0 |
| 2015-07-30 | ZN | Futures | 120.884028 | 121.047969 | 120.511435 | 120.988354 | 1231278.0 |
| 2015-07-30 | A6 | Futures | 0.72058 | 0.72356 | 0.71682 | 0.71999 | 82591.0 |
| 2015-07-30 | AD | Futures | 0.78927 | 0.78978 | 0.78334 | 0.786 | 54404.0 |
| 2015-07-30 | ALI | Futures | 2246.93 | 2246.93 | 2246.93 | 2246.93 | 0.0 |
| 2015-07-30 | B | Futures | 50.19 | 50.91 | 49.72 | 49.97 | 125935.0 |
| 2015-07-30 | B6 | Futures | 1.6415 | 1.6462 | 1.6375 | 1.6414 | 62349.0 |
| 2015-07-30 | BFX | Futures | 4501.9 | 4506.2 | 4482.6 | 4505.6 | 9.0 |
| 2015-07-30 | BR | Futures | 0.17602 | 0.17707 | 0.17512 | 0.17542 | 1080.0 |
| 2015-07-30 | BZ | Futures | 50.2 | 50.85 | 49.68 | 49.92 | 23134.0 |
| 2015-07-30 | C | Futures | 2292.0 | 2302.0 | 2285.0 | 2298.0 | 7845.0 |
| 2015-07-30 | CB | Futures | 156.421 | 159.258 | 156.421 | 158.852 | 31.0 |
| 2015-07-30 | CC | Futures | 2357.0 | 2376.0 | 2357.0 | 2369.0 | 13195.0 |
| 2015-07-30 | CNH | Futures | 7.0088 | 7.0132 | 7.0088 | 7.0132 | 1.0 |
| 2015-07-30 | CSC | Futures | 4.407 | 4.45 | 4.407 | 4.437 | 19.0 |
| 2015-07-30 | CT | Futures | 78.18 | 78.58 | 77.9 | 77.9 | 5.0 |
| 2015-07-30 | DC | Futures | 35.3 | 35.88 | 35.3 | 35.71 | 460.0 |
| 2015-07-30 | DX | Futures | 91.049 | 91.634 | 91.039 | 91.45 | 35187.0 |
| 2015-07-30 | E1 | Futures | 1.31437 | 1.31475 | 1.30827 | 1.31069 | 15133.0 |
| 2015-07-30 | E6 | Futures | 1.29085 | 1.29179 | 1.2804 | 1.28333 | 220858.0 |
| 2015-07-30 | E7 | Futures | 1.2838 | 1.2845 | 1.2734 | 1.2762 | 4788.0 |
| 2015-07-30 | EBM | Futures | 294.71 | 297.99 | 294.71 | 297.58 | 10588.0 |
| 2015-07-30 | ED | Futures | 95.627 | 95.627 | 95.6031 | 95.6127 | 234880.0 |
| 2015-07-30 | ER | Futures | 98.112 | 98.117 | 98.107 | 98.117 | 13732.0 |
| 2015-07-30 | EW | Futures | 1564.5 | 1571.2 | 1557.2 | 1570.9 | 12994.0 |
| 2015-07-30 | FBTP | Futures | 100.48 | 101.14 | 100.28 | 101.03 | 98333.0 |
| 2015-07-30 | FBTS | Futures | 100.044 | 100.124 | 100.026 | 100.079 | 15559.0 |
| 2015-07-30 | FCE | Futures | 4192.5 | 4222.5 | 4170.4 | 4207.5 | 79158.0 |
| 2015-07-30 | FDAX | Futures | 12429.8 | 12507.7 | 12312.6 | 12434.2 | 103948.0 |
| 2015-07-30 | FESX | Futures | 2653.2 | 2665.0 | 2628.0 | 2648.0 | 809440.0 |
| 2015-07-30 | FEU3 | Futures | 98.759 | 98.759 | 98.759 | 98.759 | 124.0 |
| 2015-07-30 | FGBL | Futures | 136.91 | 137.84 | 136.86 | 137.73 | 528389.0 |
| 2015-07-30 | FGBM | Futures | 124.55 | 124.78 | 124.53 | 124.74 | 403197.0 |
| 2015-07-30 | FGBS | Futures | 111.233 | 111.253 | 111.228 | 111.238 | 153902.0 |
| 2015-07-30 | FGBX | Futures | 154.93 | 157.61 | 154.71 | 157.35 | 21075.0 |
| 2015-07-30 | FMWO | Futures | 5794.1 | 5815.0 | 5788.0 | 5815.0 | 522.0 |
| 2015-07-30 | FOAT | Futures | 125.42 | 126.19 | 125.3 | 126.13 | 54965.0 |
| 2015-07-30 | FTDX | Futures | 1684.3 | 1684.3 | 1641.9 | 1658.8 | 370.0 |
| 2015-07-30 | FTI | Futures | 421.84 | 425.95 | 421.71 | 424.92 | 30643.0 |
| 2015-07-30 | FTUK | Futures | 5234.8 | 5283.3 | 5228.9 | 5264.2 | 88289.0 |
| 2015-07-30 | FVSA | Futures | 1789.63 | 1851.04 | 1754.54 | 1789.63 | 5563.0 |
| 2015-07-30 | FXXP | Futures | 303.6 | 304.3 | 302.0 | 303.8 | 10759.0 |
| 2015-07-30 | G | Futures | 101.82 | 102.12 | 101.67 | 101.96 | 126632.0 |
| 2015-07-30 | GF | Futures | 359.591 | 361.928 | 357.423 | 359.123 | 2283.0 |
| 2015-07-30 | GSCI | Futures | 641.0 | 644.83 | 638.08 | 639.58 | 503.0 |
| 2015-07-30 | HE | Futures | 89.921 | 90.508 | 88.636 | 89.0 | 7220.0 |
> showing 50 of 107 rows — these rows as CSV