PREVIEW / futures_daily / 2014-04-10
file: by_date/futures_daily/2014/2014-04-10.parquet size: 9 KB rows: 103
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-04-10 | ES | Futures | 1930.38 | 1932.19 | 1886.92 | 1890.28 | 2378458.0 |
| 2014-04-10 | NQ | Futures | 4136.21 | 4143.4 | 3994.62 | 4005.85 | 528139.0 |
| 2014-04-10 | YM | Futures | 16433.1 | 16451.2 | 16143.9 | 16176.0 | 210431.0 |
| 2014-04-10 | CL | Futures | 184.59 | 185.25 | 183.99 | 184.52 | 222169.0 |
| 2014-04-10 | GC | Futures | 1728.5 | 1745.7 | 1727.4 | 1739.9 | 126709.0 |
| 2014-04-10 | ZN | Futures | 115.142037 | 115.808435 | 115.098576 | 115.620105 | 1752487.0 |
| 2014-04-10 | A6 | Futures | 0.8975 | 0.9049 | 0.89635 | 0.90154 | 88791.0 |
| 2014-04-10 | AD | Futures | 0.93043 | 0.93154 | 0.92576 | 0.92698 | 50227.0 |
| 2014-04-10 | B | Futures | 111.28 | 111.44 | 110.84 | 111.04 | 159110.0 |
| 2014-04-10 | B6 | Futures | 1.7638 | 1.767 | 1.76 | 1.7635 | 68371.0 |
| 2014-04-10 | BR | Futures | 0.23745 | 0.23797 | 0.23565 | 0.23758 | 523.0 |
| 2014-04-10 | BZ | Futures | 113.44 | 113.58 | 112.85 | 113.17 | 6858.0 |
| 2014-04-10 | C | Futures | 1956.0 | 1963.0 | 1947.0 | 1953.0 | 8477.0 |
| 2014-04-10 | CB | Futures | 93.542 | 93.542 | 93.212 | 93.415 | 18.0 |
| 2014-04-10 | CC | Futures | 2220.0 | 2227.0 | 2194.0 | 2201.0 | 25761.0 |
| 2014-04-10 | CNH | Futures | 7.1125 | 7.1298 | 7.1125 | 7.1285 | 111.0 |
| 2014-04-10 | CSC | Futures | 4.404 | 4.415 | 4.339 | 4.343 | 19.0 |
| 2014-04-10 | CT | Futures | 101.65 | 102.54 | 100.01 | 100.05 | 25151.0 |
| 2014-04-10 | DC | Futures | 35.08 | 35.22 | 34.32 | 34.49 | 329.0 |
| 2014-04-10 | DX | Futures | 75.636 | 75.665 | 75.418 | 75.48 | 22540.0 |
| 2014-04-10 | E1 | Futures | 1.45945 | 1.46741 | 1.4583 | 1.46549 | 24348.0 |
| 2014-04-10 | E6 | Futures | 1.63517 | 1.64072 | 1.63316 | 1.63965 | 137083.0 |
| 2014-04-10 | E7 | Futures | 1.6242 | 1.6298 | 1.6224 | 1.6287 | 3107.0 |
| 2014-04-10 | EBM | Futures | 293.11 | 293.81 | 292.4 | 293.46 | 10019.0 |
| 2014-04-10 | ED | Futures | 95.4091 | 95.4138 | 95.4043 | 95.4091 | 100245.0 |
| 2014-04-10 | ER | Futures | 97.842 | 97.852 | 97.837 | 97.852 | 46100.0 |
| 2014-04-10 | EW | Futures | 1404.8 | 1406.2 | 1370.2 | 1373.9 | 24425.0 |
| 2014-04-10 | FBTP | Futures | 88.06 | 88.35 | 88.05 | 88.24 | 47109.0 |
| 2014-04-10 | FBTS | Futures | 97.592 | 97.627 | 97.583 | 97.61 | 12842.0 |
| 2014-04-10 | FCE | Futures | 3463.3 | 3471.4 | 3390.6 | 3431.4 | 164401.0 |
| 2014-04-10 | FDAX | Futures | 10553.9 | 10602.5 | 10327.5 | 10451.8 | 145848.0 |
| 2014-04-10 | FESX | Futures | 2246.3 | 2251.3 | 2191.7 | 2218.3 | 1208723.0 |
| 2014-04-10 | FGBL | Futures | 123.89 | 124.31 | 123.84 | 124.17 | 695326.0 |
| 2014-04-10 | FGBM | Futures | 119.72 | 119.88 | 119.68 | 119.82 | 431202.0 |
| 2014-04-10 | FGBS | Futures | 110.503 | 110.543 | 110.493 | 110.528 | 254991.0 |
| 2014-04-10 | FGBX | Futures | 126.5 | 127.52 | 126.38 | 127.23 | 16182.0 |
| 2014-04-10 | FMWO | Futures | 5511.5 | 5511.5 | 5511.5 | 5511.5 | 0.0 |
| 2014-04-10 | FOAT | Futures | 113.0 | 113.43 | 113.0 | 113.32 | 42771.0 |
| 2014-04-10 | FTDX | Futures | 1170.0 | 1179.4 | 1134.4 | 1150.3 | 416.0 |
| 2014-04-10 | FTI | Futures | 344.24 | 345.49 | 339.53 | 342.6 | 1108.0 |
| 2014-04-10 | FTUK | Futures | 5040.6 | 5059.2 | 4966.2 | 5019.2 | 111476.0 |
| 2014-04-10 | FVSA | Futures | 1740.36 | 1795.53 | 1710.26 | 1760.42 | 7430.0 |
| 2014-04-10 | FXXP | Futures | 248.8 | 249.6 | 245.5 | 246.5 | 7055.0 |
| 2014-04-10 | G | Futures | 94.13 | 94.42 | 94.05 | 94.36 | 158214.0 |
| 2014-04-10 | GF | Futures | 286.359 | 286.837 | 285.166 | 285.962 | 3079.0 |
| 2014-04-10 | GSCI | Futures | 1081.0 | 1084.31 | 1079.92 | 1081.08 | 2199.0 |
| 2014-04-10 | HE | Futures | 138.639 | 140.709 | 138.639 | 140.709 | 200.0 |
| 2014-04-10 | HG | Futures | 3.8551 | 3.8652 | 3.8291 | 3.8589 | 48536.0 |
| 2014-04-10 | HH | Futures | 57.389 | 59.402 | 57.275 | 58.921 | 595.0 |
| 2014-04-10 | HO | Futures | 2.3509 | 2.3509 | 2.327 | 2.3379 | 24376.0 |
> showing 50 of 103 rows — these rows as CSV