PREVIEW / futures_daily / 2015-10-28
file: by_date/futures_daily/2015/2015-10-28.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 |
|---|---|---|---|---|---|---|---|
| 2015-10-28 | ES | Futures | 2193.46 | 2218.19 | 2186.54 | 2217.39 | 1890861.0 |
| 2015-10-28 | NQ | Futures | 5419.57 | 5469.85 | 5378.94 | 5464.59 | 306875.0 |
| 2015-10-28 | YM | Futures | 18069.5 | 18270.7 | 18026.2 | 18264.5 | 155703.0 |
| 2015-10-28 | CL | Futures | 68.97 | 73.39 | 68.37 | 72.94 | 521518.0 |
| 2015-10-28 | GC | Futures | 1506.1 | 1527.2 | 1487.2 | 1518.2 | 187307.0 |
| 2015-10-28 | ZN | Futures | 123.437093 | 123.481995 | 122.718652 | 122.808457 | 1285733.0 |
| 2015-10-28 | A6 | Futures | 0.71833 | 0.71913 | 0.70653 | 0.70663 | 117406.0 |
| 2015-10-28 | AD | Futures | 0.77189 | 0.78223 | 0.77097 | 0.77486 | 72601.0 |
| 2015-10-28 | ALI | Futures | 2037.41 | 2037.41 | 2037.41 | 2037.41 | 0.0 |
| 2015-10-28 | B | Futures | 42.05 | 44.11 | 41.78 | 43.96 | 127630.0 |
| 2015-10-28 | B6 | Futures | 1.6113 | 1.6158 | 1.6053 | 1.6056 | 76047.0 |
| 2015-10-28 | BFX | Futures | 4191.9 | 4345.0 | 4191.9 | 4345.0 | 4.0 |
| 2015-10-28 | BR | Futures | 0.15694 | 0.1578 | 0.15515 | 0.157 | 5879.0 |
| 2015-10-28 | BZ | Futures | 41.68 | 43.82 | 41.53 | 43.67 | 17485.0 |
| 2015-10-28 | C | Futures | 2333.0 | 2349.0 | 2331.0 | 2345.0 | 5521.0 |
| 2015-10-28 | CB | Futures | 202.727 | 206.639 | 202.727 | 205.68 | 8.0 |
| 2015-10-28 | CC | Futures | 2335.0 | 2371.0 | 2335.0 | 2360.0 | 20333.0 |
| 2015-10-28 | CNH | Futures | 7.1247 | 7.1352 | 7.1153 | 7.1283 | 82.0 |
| 2015-10-28 | CSC | Futures | 4.278 | 4.289 | 4.273 | 4.281 | 80.0 |
| 2015-10-28 | CT | Futures | 74.78 | 75.46 | 74.62 | 75.18 | 9469.0 |
| 2015-10-28 | DC | Futures | 34.5 | 34.5 | 34.3 | 34.37 | 87.0 |
| 2015-10-28 | DX | Futures | 90.767 | 91.557 | 90.262 | 91.526 | 47242.0 |
| 2015-10-28 | E1 | Futures | 1.28772 | 1.29356 | 1.27554 | 1.27668 | 23775.0 |
| 2015-10-28 | E6 | Futures | 1.29455 | 1.30076 | 1.27733 | 1.27792 | 292325.0 |
| 2015-10-28 | E7 | Futures | 1.2876 | 1.2936 | 1.2703 | 1.2709 | 5279.0 |
| 2015-10-28 | EBM | Futures | 261.24 | 261.24 | 259.42 | 260.15 | 15790.0 |
| 2015-10-28 | ED | Futures | 95.7496 | 95.7496 | 95.7111 | 95.7159 | 476436.0 |
| 2015-10-28 | ER | Futures | 98.2 | 98.22 | 98.195 | 98.205 | 102506.0 |
| 2015-10-28 | EW | Futures | 1499.2 | 1531.4 | 1498.5 | 1530.5 | 29202.0 |
| 2015-10-28 | FBON | Futures | 116.47 | 116.76 | 116.41 | 116.68 | 1038.0 |
| 2015-10-28 | FBTP | Futures | 105.0 | 105.37 | 104.96 | 105.27 | 82952.0 |
| 2015-10-28 | FBTS | Futures | 100.597 | 100.642 | 100.588 | 100.615 | 26474.0 |
| 2015-10-28 | FCE | Futures | 4055.0 | 4115.0 | 4042.9 | 4078.8 | 81108.0 |
| 2015-10-28 | FDAX | Futures | 11806.1 | 12034.6 | 11774.7 | 11940.5 | 93277.0 |
| 2015-10-28 | FDXM | Futures | 11042.2 | 11240.8 | 11003.1 | 11155.4 | 1796.0 |
| 2015-10-28 | FESX | Futures | 2539.2 | 2584.9 | 2533.2 | 2563.2 | 961365.0 |
| 2015-10-28 | FEU3 | Futures | 98.853 | 98.853 | 98.848 | 98.848 | 50.0 |
| 2015-10-28 | FGBL | Futures | 140.82 | 141.13 | 140.52 | 140.9 | 592808.0 |
| 2015-10-28 | FGBM | Futures | 125.89 | 126.03 | 125.8 | 125.97 | 348555.0 |
| 2015-10-28 | FGBS | Futures | 111.473 | 111.513 | 111.448 | 111.488 | 264305.0 |
| 2015-10-28 | FGBX | Futures | 162.85 | 163.58 | 161.91 | 162.79 | 31756.0 |
| 2015-10-28 | FMWO | Futures | 5674.3 | 5715.1 | 5674.3 | 5712.7 | 509.0 |
| 2015-10-28 | FOAT | Futures | 129.22 | 129.55 | 128.98 | 129.36 | 64638.0 |
| 2015-10-28 | FTDX | Futures | 1687.0 | 1715.9 | 1687.0 | 1709.3 | 171.0 |
| 2015-10-28 | FTI | Futures | 398.97 | 405.68 | 398.45 | 402.46 | 31613.0 |
| 2015-10-28 | FTUK | Futures | 5103.6 | 5174.4 | 5092.7 | 5163.9 | 87042.0 |
| 2015-10-28 | FVSA | Futures | 2040.24 | 2086.19 | 1998.88 | 2017.26 | 10958.0 |
| 2015-10-28 | FXXP | Futures | 289.9 | 295.8 | 289.1 | 292.5 | 12779.0 |
| 2015-10-28 | G | Futures | 105.48 | 105.49 | 105.01 | 105.2 | 115937.0 |
| 2015-10-28 | GF | Futures | 342.806 | 347.368 | 342.715 | 347.368 | 3196.0 |
> showing 50 of 109 rows — these rows as CSV