PREVIEW / futures_daily / 2014-11-14
file: by_date/futures_daily/2014/2014-11-14.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-11-14 | ES | Futures | 2123.64 | 2130.69 | 2122.6 | 2128.87 | 1047384.0 |
| 2014-11-14 | NQ | Futures | 4871.47 | 4897.54 | 4862.77 | 4893.2 | 218493.0 |
| 2014-11-14 | YM | Futures | 17847.5 | 17895.2 | 17832.3 | 17859.7 | 92898.0 |
| 2014-11-14 | CL | Futures | 143.25 | 147.03 | 141.15 | 146.16 | 151861.0 |
| 2014-11-14 | GC | Futures | 1523.9 | 1564.7 | 1503.2 | 1555.1 | 293650.0 |
| 2014-11-14 | ZN | Futures | 118.568672 | 118.788325 | 118.246515 | 118.729751 | 1170390.0 |
| 2014-11-14 | A6 | Futures | 0.84478 | 0.8511 | 0.83876 | 0.84925 | 104860.0 |
| 2014-11-14 | AD | Futures | 0.89264 | 0.90128 | 0.89102 | 0.89975 | 85663.0 |
| 2014-11-14 | ALI | Futures | 3066.06 | 3066.06 | 3066.06 | 3066.06 | 0.0 |
| 2014-11-14 | B | Futures | 80.3 | 82.45 | 79.36 | 82.1 | 267611.0 |
| 2014-11-14 | B6 | Futures | 1.6503 | 1.6508 | 1.6386 | 1.6479 | 112641.0 |
| 2014-11-14 | BR | Futures | 0.20745 | 0.20745 | 0.20459 | 0.20691 | 826.0 |
| 2014-11-14 | BZ | Futures | 81.35 | 83.29 | 80.2 | 82.94 | 15018.0 |
| 2014-11-14 | C | Futures | 2017.0 | 2023.0 | 1991.0 | 2003.0 | 3669.0 |
| 2014-11-14 | CB | Futures | 131.956 | 133.729 | 131.956 | 133.344 | 5.0 |
| 2014-11-14 | CC | Futures | 2085.0 | 2088.0 | 2054.0 | 2064.0 | 10405.0 |
| 2014-11-14 | CNH | Futures | 7.0452 | 7.0455 | 7.0404 | 7.0404 | 4.0 |
| 2014-11-14 | CSC | Futures | 4.854 | 4.893 | 4.854 | 4.864 | 33.0 |
| 2014-11-14 | CT | Futures | 75.72 | 76.5 | 75.52 | 75.78 | 15915.0 |
| 2014-11-14 | DC | Futures | 39.22 | 39.55 | 39.07 | 39.24 | 267.0 |
| 2014-11-14 | DX | Futures | 83.488 | 83.882 | 83.019 | 83.15 | 54439.0 |
| 2014-11-14 | E1 | Futures | 1.32699 | 1.33594 | 1.31983 | 1.33351 | 60840.0 |
| 2014-11-14 | E6 | Futures | 1.4688 | 1.47727 | 1.45961 | 1.47468 | 319049.0 |
| 2014-11-14 | E7 | Futures | 1.4594 | 1.468 | 1.4506 | 1.4654 | 6422.0 |
| 2014-11-14 | ED | Futures | 95.4374 | 95.4422 | 95.4374 | 95.4374 | 59965.0 |
| 2014-11-14 | ER | Futures | 97.999 | 98.004 | 97.994 | 97.999 | 37064.0 |
| 2014-11-14 | EW | Futures | 1488.3 | 1495.7 | 1486.4 | 1490.3 | 11713.0 |
| 2014-11-14 | FBTP | Futures | 95.51 | 95.57 | 95.36 | 95.45 | 35341.0 |
| 2014-11-14 | FBTS | Futures | 98.464 | 98.499 | 98.446 | 98.49 | 4919.0 |
| 2014-11-14 | FCE | Futures | 3394.3 | 3404.5 | 3366.8 | 3398.8 | 11861.0 |
| 2014-11-14 | FDAX | Futures | 10143.9 | 10176.7 | 10058.4 | 10125.2 | 106842.0 |
| 2014-11-14 | FESX | Futures | 2214.4 | 2221.6 | 2189.8 | 2210.1 | 865092.0 |
| 2014-11-14 | FGBL | Futures | 133.62 | 133.84 | 133.57 | 133.68 | 454086.0 |
| 2014-11-14 | FGBM | Futures | 123.3 | 123.31 | 123.23 | 123.27 | 217585.0 |
| 2014-11-14 | FGBS | Futures | 110.913 | 110.913 | 110.898 | 110.908 | 114264.0 |
| 2014-11-14 | FGBX | Futures | 146.34 | 147.06 | 146.26 | 146.66 | 18387.0 |
| 2014-11-14 | FMWO | Futures | 5706.2 | 5712.5 | 5697.4 | 5712.5 | 136.0 |
| 2014-11-14 | FOAT | Futures | 122.93 | 123.18 | 122.89 | 123.08 | 55416.0 |
| 2014-11-14 | FTDX | Futures | 1206.0 | 1209.8 | 1194.2 | 1195.6 | 65.0 |
| 2014-11-14 | FTI | Futures | 358.55 | 359.03 | 355.64 | 358.07 | 270.0 |
| 2014-11-14 | FTUK | Futures | 5135.6 | 5144.1 | 5106.6 | 5135.6 | 75058.0 |
| 2014-11-14 | FVSA | Futures | 1547.19 | 1599.94 | 1538.4 | 1577.96 | 3049.0 |
| 2014-11-14 | FXXP | Futures | 255.1 | 255.1 | 253.2 | 254.3 | 4258.0 |
| 2014-11-14 | G | Futures | 99.33 | 99.87 | 99.28 | 99.61 | 169405.0 |
| 2014-11-14 | GF | Futures | 376.292 | 379.02 | 375.811 | 378.86 | 3471.0 |
| 2014-11-14 | GSCI | Futures | 873.27 | 883.66 | 873.27 | 883.15 | 1238.0 |
| 2014-11-14 | HE | Futures | 123.016 | 125.438 | 122.578 | 124.732 | 16622.0 |
| 2014-11-14 | HG | Futures | 3.7913 | 3.8686 | 3.7862 | 3.8642 | 69826.0 |
| 2014-11-14 | HH | Futures | 47.59 | 48.103 | 46.994 | 47.912 | 998.0 |
| 2014-11-14 | HO | Futures | 1.889 | 1.9307 | 1.8693 | 1.9235 | 76506.0 |
> showing 50 of 104 rows — these rows as CSV