PREVIEW / futures_daily / 2014-12-15
file: by_date/futures_daily/2014/2014-12-15.parquet size: 9 KB rows: 106
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-15 | ES | Futures | 2086.3 | 2109.1 | 2069.53 | 2078.7 | 2811936.0 |
| 2014-12-15 | NQ | Futures | 4855.53 | 4912.67 | 4804.77 | 4827.1 | 549934.0 |
| 2014-12-15 | YM | Futures | 17504.6 | 17664.5 | 17366.0 | 17441.4 | 261002.0 |
| 2014-12-15 | CL | Futures | 111.44 | 115.55 | 108.54 | 110.19 | 194955.0 |
| 2014-12-15 | GC | Futures | 1599.5 | 1603.4 | 1559.3 | 1580.8 | 152383.0 |
| 2014-12-15 | ZN | Futures | 120.246948 | 120.482495 | 119.83474 | 119.893627 | 1391355.0 |
| 2014-12-15 | A6 | Futures | 0.80267 | 0.80473 | 0.79807 | 0.80003 | 76057.0 |
| 2014-12-15 | AD | Futures | 0.87839 | 0.88002 | 0.87055 | 0.87269 | 58881.0 |
| 2014-12-15 | ALI | Futures | 2894.22 | 2894.22 | 2894.22 | 2894.22 | 0.0 |
| 2014-12-15 | B | Futures | 63.9 | 65.59 | 62.41 | 63.25 | 258141.0 |
| 2014-12-15 | B6 | Futures | 1.6524 | 1.6548 | 1.6391 | 1.6436 | 97091.0 |
| 2014-12-15 | BR | Futures | 0.20226 | 0.20226 | 0.20044 | 0.20132 | 92.0 |
| 2014-12-15 | BZ | Futures | 64.61 | 66.14 | 62.99 | 63.81 | 20995.0 |
| 2014-12-15 | C | Futures | 2063.0 | 2089.0 | 2062.0 | 2082.0 | 3476.0 |
| 2014-12-15 | CB | Futures | 136.124 | 136.37 | 135.549 | 135.549 | 18.0 |
| 2014-12-15 | CC | Futures | 2112.0 | 2128.0 | 2105.0 | 2120.0 | 7532.0 |
| 2014-12-15 | CNH | Futures | 7.1143 | 7.1144 | 7.105 | 7.1144 | 6.0 |
| 2014-12-15 | CSC | Futures | 4.58 | 4.58 | 4.484 | 4.484 | 169.0 |
| 2014-12-15 | CT | Futures | 77.4 | 78.07 | 77.28 | 77.46 | 6961.0 |
| 2014-12-15 | DC | Futures | 35.55 | 35.81 | 34.85 | 34.95 | 492.0 |
| 2014-12-15 | DX | Futures | 83.739 | 84.122 | 83.644 | 83.944 | 37802.0 |
| 2014-12-15 | E1 | Futures | 1.32723 | 1.32812 | 1.32136 | 1.32353 | 37097.0 |
| 2014-12-15 | E6 | Futures | 1.46796 | 1.46879 | 1.46114 | 1.46373 | 254091.0 |
| 2014-12-15 | E7 | Futures | 1.4589 | 1.4599 | 1.4524 | 1.455 | 2665.0 |
| 2014-12-15 | EBM | Futures | 307.79 | 311.44 | 305.76 | 311.03 | 16529.0 |
| 2014-12-15 | ED | Futures | 95.4402 | 95.445 | 95.4306 | 95.4306 | 236780.0 |
| 2014-12-15 | ER | Futures | 98.004 | 98.009 | 97.999 | 98.009 | 64370.0 |
| 2014-12-15 | EW | Futures | 1457.4 | 1472.2 | 1445.6 | 1452.7 | 43654.0 |
| 2014-12-15 | FBTP | Futures | 97.6 | 98.12 | 97.24 | 97.92 | 60817.0 |
| 2014-12-15 | FBTS | Futures | 98.296 | 98.402 | 98.207 | 98.366 | 25388.0 |
| 2014-12-15 | FCE | Futures | 3353.7 | 3385.2 | 3265.2 | 3270.9 | 82243.0 |
| 2014-12-15 | FDAX | Futures | 10484.0 | 10606.1 | 10185.5 | 10230.9 | 207881.0 |
| 2014-12-15 | FESX | Futures | 2191.7 | 2226.3 | 2135.5 | 2145.6 | 1096262.0 |
| 2014-12-15 | FEU3 | Futures | 98.621 | 98.621 | 98.621 | 98.621 | 45.0 |
| 2014-12-15 | FGBL | Futures | 135.45 | 135.47 | 135.14 | 135.4 | 472300.0 |
| 2014-12-15 | FGBM | Futures | 123.42 | 123.43 | 123.33 | 123.4 | 221712.0 |
| 2014-12-15 | FGBS | Futures | 110.863 | 110.908 | 110.853 | 110.883 | 146274.0 |
| 2014-12-15 | FGBX | Futures | 153.47 | 153.65 | 152.6 | 153.47 | 23966.0 |
| 2014-12-15 | FMWO | Futures | 5579.6 | 5588.4 | 5505.6 | 5505.6 | 3521.0 |
| 2014-12-15 | FOAT | Futures | 125.03 | 125.03 | 124.72 | 124.95 | 48936.0 |
| 2014-12-15 | FTDX | Futures | 1250.1 | 1257.1 | 1223.4 | 1225.7 | 22.0 |
| 2014-12-15 | FTI | Futures | 351.3 | 354.2 | 342.43 | 343.17 | 10542.0 |
| 2014-12-15 | FTUK | Futures | 4853.2 | 4909.7 | 4730.4 | 4779.5 | 93416.0 |
| 2014-12-15 | FVSA | Futures | 1807.84 | 1963.02 | 1792.33 | 1959.14 | 24304.0 |
| 2014-12-15 | FXXP | Futures | 247.9 | 250.8 | 242.4 | 243.2 | 51998.0 |
| 2014-12-15 | G | Futures | 102.46 | 102.61 | 102.04 | 102.42 | 137550.0 |
| 2014-12-15 | GF | Futures | 358.763 | 358.763 | 357.159 | 357.159 | 2309.0 |
| 2014-12-15 | GSCI | Futures | 761.01 | 761.01 | 746.61 | 749.76 | 111.0 |
| 2014-12-15 | HE | Futures | 112.121 | 112.356 | 110.477 | 111.718 | 12510.0 |
| 2014-12-15 | HG | Futures | 3.715 | 3.7435 | 3.6375 | 3.6565 | 41488.0 |
> showing 50 of 106 rows — these rows as CSV