PREVIEW / futures_daily / 2014-05-05
file: by_date/futures_daily/2014/2014-05-05.parquet size: 9 KB rows: 98
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-05-05 | ES | Futures | 1940.46 | 1945.12 | 1924.94 | 1940.72 | 1176754.0 |
| 2014-05-05 | NQ | Futures | 4124.7 | 4141.68 | 4084.12 | 4133.33 | 235364.0 |
| 2014-05-05 | YM | Futures | 16516.4 | 16550.6 | 16373.9 | 16511.4 | 126416.0 |
| 2014-05-05 | CL | Futures | 181.05 | 181.92 | 179.15 | 180.19 | 190002.0 |
| 2014-05-05 | GC | Futures | 1714.1 | 1733.7 | 1712.5 | 1725.1 | 115634.0 |
| 2014-05-05 | ZN | Futures | 115.620105 | 115.793948 | 115.446262 | 115.50421 | 729086.0 |
| 2014-05-05 | A6 | Futures | 0.88905 | 0.88991 | 0.88636 | 0.88886 | 43386.0 |
| 2014-05-05 | AD | Futures | 0.92292 | 0.92515 | 0.92171 | 0.92495 | 29983.0 |
| 2014-05-05 | ALI | Futures | 2774.03 | 2774.03 | 2774.03 | 2774.03 | 0.0 |
| 2014-05-05 | B | Futures | 111.99 | 112.08 | 110.19 | 110.89 | 77954.0 |
| 2014-05-05 | B6 | Futures | 1.7731 | 1.7738 | 1.7708 | 1.7724 | 29818.0 |
| 2014-05-05 | BFX | Futures | 3721.9 | 3732.6 | 3721.9 | 3732.6 | 55.0 |
| 2014-05-05 | BR | Futures | 0.23502 | 0.2365 | 0.23155 | 0.23299 | 537.0 |
| 2014-05-05 | BZ | Futures | 114.02 | 114.3 | 112.39 | 113.1 | 7046.0 |
| 2014-05-05 | CB | Futures | 104.838 | 105.6 | 104.838 | 105.092 | 21.0 |
| 2014-05-05 | CC | Futures | 2153.0 | 2168.0 | 2149.0 | 2158.0 | 5164.0 |
| 2014-05-05 | CNH | Futures | 7.1755 | 7.1755 | 7.1639 | 7.1639 | 11.0 |
| 2014-05-05 | CSC | Futures | 4.578 | 4.611 | 4.578 | 4.596 | 75.0 |
| 2014-05-05 | CT | Futures | 106.19 | 106.71 | 105.94 | 106.69 | 5508.0 |
| 2014-05-05 | DC | Futures | 37.05 | 37.42 | 36.92 | 37.12 | 148.0 |
| 2014-05-05 | DX | Futures | 75.584 | 75.603 | 75.513 | 75.556 | 8125.0 |
| 2014-05-05 | E1 | Futures | 1.46266 | 1.46459 | 1.46202 | 1.46292 | 18067.0 |
| 2014-05-05 | E6 | Futures | 1.63776 | 1.63918 | 1.6367 | 1.63812 | 79782.0 |
| 2014-05-05 | E7 | Futures | 1.627 | 1.6283 | 1.6258 | 1.6272 | 1416.0 |
| 2014-05-05 | ED | Futures | 95.4138 | 95.4186 | 95.4138 | 95.4138 | 24941.0 |
| 2014-05-05 | ER | Futures | 97.837 | 97.847 | 97.832 | 97.847 | 15273.0 |
| 2014-05-05 | EW | Futures | 1401.5 | 1405.9 | 1385.7 | 1399.7 | 17061.0 |
| 2014-05-05 | FBTP | Futures | 89.16 | 89.2 | 89.08 | 89.13 | 12862.0 |
| 2014-05-05 | FBTS | Futures | 97.469 | 97.557 | 97.469 | 97.539 | 4115.0 |
| 2014-05-05 | FCE | Futures | 3506.3 | 3518.2 | 3461.9 | 3512.7 | 85889.0 |
| 2014-05-05 | FDAX | Futures | 10562.2 | 10562.2 | 10397.1 | 10530.7 | 76785.0 |
| 2014-05-05 | FESX | Futures | 2252.1 | 2254.9 | 2219.7 | 2250.6 | 613938.0 |
| 2014-05-05 | FGBL | Futures | 124.98 | 125.06 | 124.8 | 124.83 | 183804.0 |
| 2014-05-05 | FGBM | Futures | 120.18 | 120.24 | 120.12 | 120.13 | 124330.0 |
| 2014-05-05 | FGBS | Futures | 110.608 | 110.608 | 110.578 | 110.578 | 103343.0 |
| 2014-05-05 | FGBX | Futures | 129.63 | 129.69 | 129.14 | 129.16 | 6561.0 |
| 2014-05-05 | FMWO | Futures | 5588.5 | 5593.5 | 5559.5 | 5593.5 | 61.0 |
| 2014-05-05 | FOAT | Futures | 114.32 | 114.38 | 114.12 | 114.18 | 14606.0 |
| 2014-05-05 | FTDX | Futures | 1149.8 | 1157.3 | 1140.9 | 1156.4 | 179.0 |
| 2014-05-05 | FTI | Futures | 341.73 | 341.73 | 336.89 | 341.13 | 23244.0 |
| 2014-05-05 | FVSA | Futures | 1785.07 | 1827.92 | 1746.99 | 1780.31 | 7479.0 |
| 2014-05-05 | FXXP | Futures | 250.9 | 251.3 | 248.2 | 250.7 | 4604.0 |
| 2014-05-05 | GF | Futures | 292.049 | 292.129 | 289.94 | 290.696 | 1263.0 |
| 2014-05-05 | GSCI | Futures | 1077.6 | 1077.6 | 1072.55 | 1075.78 | 133.0 |
| 2014-05-05 | HE | Futures | 136.375 | 137.268 | 135.761 | 136.543 | 9788.0 |
| 2014-05-05 | HG | Futures | 3.9266 | 3.9381 | 3.8953 | 3.9017 | 18666.0 |
| 2014-05-05 | HH | Futures | 59.414 | 59.832 | 59.401 | 59.427 | 1609.0 |
| 2014-05-05 | HO | Futures | 2.3306 | 2.3336 | 2.3019 | 2.3162 | 51530.0 |
| 2014-05-05 | HRC | Futures | 2419.8 | 2419.8 | 2419.8 | 2419.8 | 0.0 |
| 2014-05-05 | J1 | Futures | 0.012287 | 0.0123322 | 0.0122857 | 0.0123021 | 64212.0 |
> showing 50 of 98 rows — these rows as CSV