PREVIEW / futures_daily / 2014-12-19
file: by_date/futures_daily/2014/2014-12-19.parquet size: 9 KB rows: 105
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-12-19 | ES | Futures | 2159.41 | 2176.18 | 2155.48 | 2166.48 | 1765615.0 |
| 2014-12-19 | NQ | Futures | 4952.7 | 4994.47 | 4937.62 | 4969.24 | 290155.0 |
| 2014-12-19 | YM | Futures | 18044.3 | 18174.7 | 18012.8 | 18089.2 | 166032.0 |
| 2014-12-19 | CL | Futures | 107.96 | 114.42 | 106.58 | 111.89 | 383536.0 |
| 2014-12-19 | GC | Futures | 1568.1 | 1572.7 | 1561.8 | 1565.5 | 73333.0 |
| 2014-12-19 | ZN | Futures | 119.142819 | 119.451975 | 118.98088 | 119.31948 | 806138.0 |
| 2014-12-19 | A6 | Futures | 0.79562 | 0.79758 | 0.79072 | 0.79297 | 59557.0 |
| 2014-12-19 | AD | Futures | 0.87768 | 0.8788 | 0.8735 | 0.87615 | 38772.0 |
| 2014-12-19 | ALI | Futures | 2897.42 | 2897.42 | 2897.42 | 2897.42 | 14.0 |
| 2014-12-19 | B | Futures | 61.84 | 64.74 | 61.01 | 63.42 | 222067.0 |
| 2014-12-19 | B6 | Futures | 1.6466 | 1.648 | 1.6398 | 1.6428 | 67789.0 |
| 2014-12-19 | BFX | Futures | 3980.8 | 3980.8 | 3946.0 | 3972.9 | 21.0 |
| 2014-12-19 | BR | Futures | 0.20372 | 0.20383 | 0.20372 | 0.20383 | 33.0 |
| 2014-12-19 | BZ | Futures | 62.42 | 65.3 | 61.58 | 63.99 | 15698.0 |
| 2014-12-19 | C | Futures | 2156.0 | 2177.0 | 2145.0 | 2170.0 | 9585.0 |
| 2014-12-19 | CB | Futures | 135.549 | 137.192 | 135.159 | 135.549 | 33.0 |
| 2014-12-19 | CC | Futures | 2188.0 | 2207.0 | 2178.0 | 2199.0 | 13096.0 |
| 2014-12-19 | CNH | Futures | 7.1477 | 7.1555 | 7.1423 | 7.148 | 40.0 |
| 2014-12-19 | CSC | Futures | 4.518 | 4.557 | 4.475 | 4.557 | 101.0 |
| 2014-12-19 | CT | Futures | 77.42 | 77.86 | 77.03 | 77.77 | 7590.0 |
| 2014-12-19 | DC | Futures | 35.3 | 36.07 | 35.16 | 35.9 | 297.0 |
| 2014-12-19 | DX | Futures | 84.728 | 85.078 | 84.605 | 85.041 | 28393.0 |
| 2014-12-19 | E1 | Futures | 1.30501 | 1.30693 | 1.29875 | 1.29939 | 40670.0 |
| 2014-12-19 | E6 | Futures | 1.4462 | 1.4482 | 1.43844 | 1.43915 | 218920.0 |
| 2014-12-19 | E7 | Futures | 1.4379 | 1.4394 | 1.4299 | 1.4306 | 3214.0 |
| 2014-12-19 | EBM | Futures | 321.57 | 324.41 | 317.52 | 319.95 | 37696.0 |
| 2014-12-19 | ED | Futures | 95.4306 | 95.4354 | 95.4259 | 95.4306 | 133856.0 |
| 2014-12-19 | ER | Futures | 97.999 | 98.009 | 97.994 | 98.004 | 65339.0 |
| 2014-12-19 | EW | Futures | 1509.1 | 1518.2 | 1503.0 | 1515.0 | 19551.0 |
| 2014-12-19 | FBTP | Futures | 98.09 | 98.29 | 97.9 | 98.21 | 33243.0 |
| 2014-12-19 | FBTS | Futures | 98.491 | 98.553 | 98.384 | 98.526 | 21489.0 |
| 2014-12-19 | FCE | Futures | 3508.8 | 3516.6 | 3434.6 | 3467.6 | 152908.0 |
| 2014-12-19 | FDAX | Futures | 11020.9 | 11032.5 | 10773.8 | 10868.2 | 135763.0 |
| 2014-12-19 | FESX | Futures | 2302.7 | 2306.3 | 2238.6 | 2259.5 | 1503309.0 |
| 2014-12-19 | FGBL | Futures | 135.62 | 135.89 | 135.34 | 135.81 | 353954.0 |
| 2014-12-19 | FGBM | Futures | 123.52 | 123.62 | 123.49 | 123.59 | 208208.0 |
| 2014-12-19 | FGBS | Futures | 110.943 | 110.968 | 110.938 | 110.953 | 152343.0 |
| 2014-12-19 | FGBX | Futures | 153.75 | 153.77 | 152.56 | 153.31 | 21133.0 |
| 2014-12-19 | FMWO | Futures | 5649.6 | 5649.6 | 5634.7 | 5643.4 | 615.0 |
| 2014-12-19 | FOAT | Futures | 125.09 | 125.21 | 124.77 | 125.15 | 48426.0 |
| 2014-12-19 | FTDX | Futures | 1282.0 | 1287.6 | 1273.1 | 1280.1 | 254.0 |
| 2014-12-19 | FTI | Futures | 364.72 | 365.24 | 359.01 | 362.47 | 50903.0 |
| 2014-12-19 | FTUK | Futures | 5032.5 | 5099.6 | 5006.8 | 5072.3 | 132036.0 |
| 2014-12-19 | FVSA | Futures | 1718.62 | 1850.52 | 1710.86 | 1765.17 | 14374.0 |
| 2014-12-19 | FXXP | Futures | 257.9 | 258.7 | 254.3 | 256.5 | 21394.0 |
| 2014-12-19 | G | Futures | 102.01 | 102.26 | 101.53 | 102.13 | 111755.0 |
| 2014-12-19 | GF | Futures | 350.42 | 354.792 | 348.776 | 353.228 | 3152.0 |
| 2014-12-19 | GSCI | Futures | 745.41 | 759.99 | 745.07 | 753.68 | 148.0 |
| 2014-12-19 | HE | Futures | 109.84 | 110.679 | 108.733 | 109.874 | 9705.0 |
| 2014-12-19 | HG | Futures | 3.6152 | 3.6883 | 3.6152 | 3.6641 | 31829.0 |
> showing 50 of 105 rows — these rows as CSV