PREVIEW / futures_daily / 2014-04-09
file: by_date/futures_daily/2014/2014-04-09.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-04-09 | ES | Futures | 1908.91 | 1931.15 | 1907.61 | 1929.34 | 1414210.0 |
| 2014-04-09 | NQ | Futures | 4061.96 | 4137.36 | 4059.08 | 4133.62 | 332705.0 |
| 2014-04-09 | YM | Futures | 16244.3 | 16438.1 | 16240.3 | 16427.1 | 152558.0 |
| 2014-04-09 | CL | Futures | 182.65 | 185.18 | 182.08 | 184.88 | 324660.0 |
| 2014-04-09 | GC | Futures | 1724.1 | 1733.3 | 1714.3 | 1720.6 | 125580.0 |
| 2014-04-09 | ZN | Futures | 114.982681 | 115.214471 | 114.707429 | 115.156524 | 1259609.0 |
| 2014-04-09 | A6 | Futures | 0.89481 | 0.89894 | 0.8927 | 0.89837 | 65306.0 |
| 2014-04-09 | AD | Futures | 0.92668 | 0.93235 | 0.92515 | 0.93225 | 51390.0 |
| 2014-04-09 | B | Futures | 111.06 | 111.66 | 110.61 | 111.48 | 181647.0 |
| 2014-04-09 | B6 | Futures | 1.7592 | 1.765 | 1.7569 | 1.7641 | 77408.0 |
| 2014-04-09 | BFX | Futures | 3770.0 | 3772.1 | 3750.9 | 3756.1 | 115.0 |
| 2014-04-09 | BR | Futures | 0.23563 | 0.23758 | 0.23434 | 0.23631 | 159.0 |
| 2014-04-09 | BZ | Futures | 113.18 | 113.78 | 112.74 | 113.62 | 8048.0 |
| 2014-04-09 | C | Futures | 1966.0 | 1978.0 | 1961.0 | 1972.0 | 5485.0 |
| 2014-04-09 | CB | Futures | 93.669 | 93.669 | 93.415 | 93.669 | 9.0 |
| 2014-04-09 | CC | Futures | 2212.0 | 2239.0 | 2207.0 | 2231.0 | 27720.0 |
| 2014-04-09 | CNH | Futures | 7.1113 | 7.1199 | 7.1095 | 7.1095 | 10.0 |
| 2014-04-09 | CSC | Futures | 4.421 | 4.426 | 4.421 | 4.426 | 17.0 |
| 2014-04-09 | CT | Futures | 103.02 | 103.76 | 101.5 | 101.65 | 23679.0 |
| 2014-04-09 | DC | Futures | 35.6 | 35.65 | 35.03 | 35.3 | 220.0 |
| 2014-04-09 | DX | Futures | 75.883 | 75.959 | 75.56 | 75.578 | 20307.0 |
| 2014-04-09 | E1 | Futures | 1.45316 | 1.46099 | 1.45162 | 1.45997 | 26836.0 |
| 2014-04-09 | E6 | Futures | 1.62856 | 1.63623 | 1.62655 | 1.63505 | 158264.0 |
| 2014-04-09 | E7 | Futures | 1.6175 | 1.6252 | 1.6158 | 1.6242 | 3883.0 |
| 2014-04-09 | EBM | Futures | 295.22 | 298.04 | 293.11 | 294.52 | 16488.0 |
| 2014-04-09 | ED | Futures | 95.4091 | 95.4138 | 95.4043 | 95.4091 | 132032.0 |
| 2014-04-09 | ER | Futures | 97.837 | 97.852 | 97.837 | 97.842 | 80923.0 |
| 2014-04-09 | EW | Futures | 1390.6 | 1406.3 | 1389.2 | 1403.9 | 18096.0 |
| 2014-04-09 | FBTP | Futures | 87.91 | 88.11 | 87.78 | 88.01 | 50270.0 |
| 2014-04-09 | FBTS | Futures | 97.531 | 97.575 | 97.504 | 97.548 | 7092.0 |
| 2014-04-09 | FCE | Futures | 3436.4 | 3468.3 | 3434.9 | 3453.9 | 87970.0 |
| 2014-04-09 | FDAX | Futures | 10493.7 | 10571.6 | 10488.8 | 10515.8 | 79337.0 |
| 2014-04-09 | FESX | Futures | 2231.9 | 2250.6 | 2231.2 | 2238.4 | 706402.0 |
| 2014-04-09 | FGBL | Futures | 123.83 | 123.87 | 123.53 | 123.63 | 519078.0 |
| 2014-04-09 | FGBM | Futures | 119.64 | 119.69 | 119.5 | 119.54 | 359035.0 |
| 2014-04-09 | FGBS | Futures | 110.478 | 110.498 | 110.458 | 110.473 | 252807.0 |
| 2014-04-09 | FGBX | Futures | 126.36 | 126.56 | 126.05 | 126.24 | 12732.0 |
| 2014-04-09 | FMWO | Futures | 5522.9 | 5522.9 | 5516.6 | 5516.6 | 79.0 |
| 2014-04-09 | FOAT | Futures | 112.94 | 113.04 | 112.69 | 112.78 | 41224.0 |
| 2014-04-09 | FTDX | Futures | 1152.2 | 1171.4 | 1152.2 | 1165.3 | 247.0 |
| 2014-04-09 | FTI | Futures | 343.73 | 345.82 | 343.56 | 344.24 | 19432.0 |
| 2014-04-09 | FTUK | Futures | 4980.3 | 5042.1 | 4980.3 | 5014.3 | 88084.0 |
| 2014-04-09 | FVSA | Futures | 1775.47 | 1785.5 | 1745.37 | 1760.42 | 4652.0 |
| 2014-04-09 | FXXP | Futures | 247.6 | 248.9 | 247.3 | 247.9 | 5151.0 |
| 2014-04-09 | G | Futures | 93.61 | 93.81 | 93.58 | 93.7 | 105834.0 |
| 2014-04-09 | GF | Futures | 284.759 | 286.56 | 284.759 | 286.359 | 1043.0 |
| 2014-04-09 | GSCI | Futures | 1074.3 | 1083.23 | 1074.3 | 1081.0 | 1609.0 |
| 2014-04-09 | HE | Futures | 137.501 | 141.293 | 134.294 | 141.293 | 810.0 |
| 2014-04-09 | HG | Futures | 3.8703 | 3.8747 | 3.8107 | 3.8488 | 57882.0 |
| 2014-04-09 | HH | Futures | 57.592 | 58.048 | 56.972 | 58.048 | 317.0 |
> showing 50 of 104 rows — these rows as CSV