PREVIEW / futures_daily / 2014-08-05
file: by_date/futures_daily/2014/2014-08-05.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-05 | ES | Futures | 2005.92 | 2008.25 | 1981.5 | 1987.22 | 2137277.0 |
| 2014-08-05 | NQ | Futures | 4493.68 | 4500.03 | 4444.07 | 4467.14 | 356543.0 |
| 2014-08-05 | YM | Futures | 16636.1 | 16648.3 | 16445.4 | 16513.0 | 208315.0 |
| 2014-08-05 | CL | Futures | 181.16 | 181.64 | 178.57 | 179.27 | 242237.0 |
| 2014-08-05 | GC | Futures | 1691.0 | 1698.6 | 1683.2 | 1685.9 | 105683.0 |
| 2014-08-05 | ZN | Futures | 117.119291 | 117.221413 | 116.798336 | 117.075524 | 1180650.0 |
| 2014-08-05 | A6 | Futures | 0.89953 | 0.9005 | 0.89576 | 0.89624 | 85792.0 |
| 2014-08-05 | AD | Futures | 0.93023 | 0.93053 | 0.92434 | 0.92515 | 60493.0 |
| 2014-08-05 | ALI | Futures | 2932.02 | 2932.02 | 2932.02 | 2932.02 | 2.0 |
| 2014-08-05 | B | Futures | 111.58 | 111.58 | 109.95 | 110.54 | 170633.0 |
| 2014-08-05 | B6 | Futures | 1.7716 | 1.7749 | 1.7703 | 1.7734 | 82318.0 |
| 2014-08-05 | BFX | Futures | 3721.4 | 3731.7 | 3715.6 | 3715.6 | 73.0 |
| 2014-08-05 | BR | Futures | 0.2311 | 0.2311 | 0.22883 | 0.22886 | 1650.0 |
| 2014-08-05 | BZ | Futures | 112.16 | 112.41 | 110.82 | 111.41 | 15838.0 |
| 2014-08-05 | C | Futures | 2116.0 | 2130.0 | 2097.0 | 2111.0 | 8345.0 |
| 2014-08-05 | CB | Futures | 130.795 | 130.795 | 130.795 | 130.795 | 12.0 |
| 2014-08-05 | CC | Futures | 2348.0 | 2365.0 | 2331.0 | 2347.0 | 14466.0 |
| 2014-08-05 | CNH | Futures | 7.1033 | 7.1033 | 7.0923 | 7.0923 | 48.0 |
| 2014-08-05 | CSC | Futures | 4.649 | 4.654 | 4.569 | 4.571 | 23.0 |
| 2014-08-05 | CT | Futures | 81.14 | 81.2 | 79.9 | 80.06 | 13.0 |
| 2014-08-05 | DC | Futures | 37.85 | 37.89 | 37.16 | 37.23 | 270.0 |
| 2014-08-05 | DX | Futures | 77.267 | 77.557 | 77.239 | 77.467 | 24495.0 |
| 2014-08-05 | E1 | Futures | 1.41391 | 1.41455 | 1.40725 | 1.40981 | 36824.0 |
| 2014-08-05 | E6 | Futures | 1.58394 | 1.5843 | 1.57639 | 1.57804 | 185064.0 |
| 2014-08-05 | E7 | Futures | 1.5736 | 1.5739 | 1.566 | 1.5678 | 1564.0 |
| 2014-08-05 | ED | Futures | 95.4115 | 95.4162 | 95.4115 | 95.4162 | 41855.0 |
| 2014-08-05 | ER | Futures | 97.886 | 97.891 | 97.886 | 97.886 | 10520.0 |
| 2014-08-05 | EW | Futures | 1423.7 | 1429.1 | 1411.3 | 1418.1 | 18390.0 |
| 2014-08-05 | FBTP | Futures | 92.79 | 92.79 | 92.09 | 92.17 | 47582.0 |
| 2014-08-05 | FBTS | Futures | 98.499 | 98.516 | 98.41 | 98.428 | 8628.0 |
| 2014-08-05 | FCE | Futures | 3360.8 | 3382.3 | 3328.2 | 3367.2 | 103502.0 |
| 2014-08-05 | FDAX | Futures | 10104.5 | 10175.5 | 10000.4 | 10123.2 | 127816.0 |
| 2014-08-05 | FESX | Futures | 2211.7 | 2226.1 | 2181.5 | 2209.5 | 1099761.0 |
| 2014-08-05 | FGBL | Futures | 129.04 | 129.11 | 128.56 | 128.7 | 550957.0 |
| 2014-08-05 | FGBM | Futures | 121.77 | 121.79 | 121.61 | 121.66 | 318927.0 |
| 2014-08-05 | FGBS | Futures | 110.768 | 110.768 | 110.753 | 110.763 | 135006.0 |
| 2014-08-05 | FGBX | Futures | 136.69 | 136.73 | 135.72 | 135.99 | 21471.0 |
| 2014-08-05 | FMWO | Futures | 5661.9 | 5661.9 | 5661.9 | 5661.9 | 0.0 |
| 2014-08-05 | FOAT | Futures | 119.17 | 119.23 | 118.67 | 118.79 | 44275.0 |
| 2014-08-05 | FTDX | Futures | 1108.4 | 1110.7 | 1097.6 | 1103.2 | 232.0 |
| 2014-08-05 | FTI | Futures | 342.46 | 344.58 | 341.34 | 344.11 | 28987.0 |
| 2014-08-05 | FTUK | Futures | 5114.6 | 5127.3 | 5071.9 | 5101.9 | 77893.0 |
| 2014-08-05 | FVSA | Futures | 1528.25 | 1540.98 | 1498.53 | 1511.27 | 9705.0 |
| 2014-08-05 | FXXP | Futures | 249.1 | 250.9 | 247.3 | 249.5 | 4580.0 |
| 2014-08-05 | G | Futures | 95.02 | 95.07 | 94.63 | 94.75 | 119855.0 |
| 2014-08-05 | GF | Futures | 339.776 | 342.114 | 338.282 | 339.087 | 2323.0 |
| 2014-08-05 | GSCI | Futures | 1034.63 | 1034.88 | 1028.52 | 1030.44 | 1020.0 |
| 2014-08-05 | HE | Futures | 125.006 | 125.61 | 122.376 | 122.92 | 19826.0 |
| 2014-08-05 | HG | Futures | 4.1503 | 4.1535 | 4.0851 | 4.096 | 49866.0 |
| 2014-08-05 | HH | Futures | 48.849 | 49.559 | 48.849 | 49.471 | 1750.0 |
> showing 50 of 104 rows — these rows as CSV