PREVIEW / futures_daily / 2014-05-07
file: by_date/futures_daily/2014/2014-05-07.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-05-07 | ES | Futures | 1928.56 | 1940.72 | 1918.74 | 1939.17 | 1999538.0 |
| 2014-05-07 | NQ | Futures | 4087.57 | 4105.42 | 4025.99 | 4075.49 | 447227.0 |
| 2014-05-07 | YM | Futures | 16427.1 | 16547.6 | 16371.8 | 16535.5 | 210445.0 |
| 2014-05-07 | CL | Futures | 180.82 | 182.92 | 180.73 | 182.52 | 291271.0 |
| 2014-05-07 | GC | Futures | 1723.3 | 1732.6 | 1695.2 | 1698.2 | 173803.0 |
| 2014-05-07 | ZN | Futures | 115.576644 | 115.866383 | 115.402801 | 115.779461 | 1497808.0 |
| 2014-05-07 | A6 | Futures | 0.89549 | 0.89625 | 0.89289 | 0.89481 | 59910.0 |
| 2014-05-07 | AD | Futures | 0.93002 | 0.93144 | 0.9287 | 0.92982 | 39864.0 |
| 2014-05-07 | ALI | Futures | 2735.27 | 2735.27 | 2727.32 | 2731.13 | 35.0 |
| 2014-05-07 | B | Futures | 110.29 | 111.52 | 110.21 | 111.4 | 191634.0 |
| 2014-05-07 | B6 | Futures | 1.7833 | 1.7848 | 1.7811 | 1.782 | 60482.0 |
| 2014-05-07 | BFX | Futures | 3740.5 | 3751.0 | 3739.0 | 3751.0 | 75.0 |
| 2014-05-07 | BR | Futures | 0.23452 | 0.236 | 0.2341 | 0.23571 | 128.0 |
| 2014-05-07 | BZ | Futures | 112.57 | 113.74 | 112.4 | 113.62 | 10206.0 |
| 2014-05-07 | C | Futures | 1888.0 | 1888.0 | 1869.0 | 1875.0 | 10463.0 |
| 2014-05-07 | CB | Futures | 106.361 | 106.488 | 105.587 | 105.854 | 53.0 |
| 2014-05-07 | CC | Futures | 2147.0 | 2151.0 | 2126.0 | 2138.0 | 13814.0 |
| 2014-05-07 | CNH | Futures | 7.1467 | 7.1573 | 7.1467 | 7.1524 | 18.0 |
| 2014-05-07 | CSC | Futures | 4.524 | 4.622 | 4.524 | 4.6 | 32.0 |
| 2014-05-07 | CT | Futures | 105.83 | 106.04 | 103.9 | 104.21 | 13151.0 |
| 2014-05-07 | DC | Futures | 36.59 | 37.47 | 36.46 | 37.23 | 359.0 |
| 2014-05-07 | DX | Futures | 75.209 | 75.328 | 75.171 | 75.283 | 16460.0 |
| 2014-05-07 | E1 | Futures | 1.46844 | 1.46985 | 1.46484 | 1.46561 | 32079.0 |
| 2014-05-07 | E6 | Futures | 1.6439 | 1.64544 | 1.6419 | 1.64272 | 130709.0 |
| 2014-05-07 | E7 | Futures | 1.6331 | 1.6344 | 1.631 | 1.6318 | 2690.0 |
| 2014-05-07 | ED | Futures | 95.4186 | 95.4186 | 95.4138 | 95.4138 | 62122.0 |
| 2014-05-07 | ER | Futures | 97.842 | 97.847 | 97.837 | 97.842 | 75979.0 |
| 2014-05-07 | EW | Futures | 1392.6 | 1400.6 | 1378.2 | 1399.1 | 21924.0 |
| 2014-05-07 | FBTP | Futures | 89.32 | 89.56 | 89.24 | 89.32 | 53136.0 |
| 2014-05-07 | FBTS | Futures | 97.619 | 97.619 | 97.531 | 97.557 | 7524.0 |
| 2014-05-07 | FCE | Futures | 3475.8 | 3511.5 | 3467.9 | 3503.2 | 123386.0 |
| 2014-05-07 | FDAX | Futures | 10414.8 | 10561.6 | 10382.2 | 10518.6 | 140242.0 |
| 2014-05-07 | FESX | Futures | 2226.9 | 2252.1 | 2223.3 | 2244.2 | 1060790.0 |
| 2014-05-07 | FGBL | Futures | 124.94 | 125.03 | 124.51 | 124.74 | 637961.0 |
| 2014-05-07 | FGBM | Futures | 120.11 | 120.16 | 119.87 | 119.99 | 486369.0 |
| 2014-05-07 | FGBS | Futures | 110.568 | 110.583 | 110.533 | 110.563 | 238638.0 |
| 2014-05-07 | FGBX | Futures | 129.45 | 129.71 | 128.86 | 129.24 | 16831.0 |
| 2014-05-07 | FMWO | Futures | 5563.3 | 5569.6 | 5560.7 | 5565.8 | 92.0 |
| 2014-05-07 | FOAT | Futures | 114.34 | 114.5 | 114.0 | 114.14 | 51312.0 |
| 2014-05-07 | FTDX | Futures | 1148.4 | 1158.7 | 1145.2 | 1149.8 | 202.0 |
| 2014-05-07 | FTI | Futures | 339.53 | 343.2 | 338.79 | 342.34 | 31072.0 |
| 2014-05-07 | FTUK | Futures | 5153.4 | 5166.0 | 5135.1 | 5155.7 | 105988.0 |
| 2014-05-07 | FVSA | Futures | 1808.88 | 1827.92 | 1751.75 | 1761.27 | 4785.0 |
| 2014-05-07 | FXXP | Futures | 249.4 | 251.1 | 249.1 | 249.9 | 6996.0 |
| 2014-05-07 | G | Futures | 94.25 | 94.42 | 94.02 | 94.2 | 172967.0 |
| 2014-05-07 | GF | Futures | 292.328 | 293.482 | 290.577 | 291.293 | 1440.0 |
| 2014-05-07 | GSCI | Futures | 1075.28 | 1081.16 | 1073.29 | 1080.58 | 2188.0 |
| 2014-05-07 | HE | Futures | 136.961 | 137.156 | 134.841 | 135.231 | 29529.0 |
| 2014-05-07 | HG | Futures | 3.9049 | 3.9126 | 3.8532 | 3.8749 | 40396.0 |
| 2014-05-07 | HH | Futures | 60.973 | 61.1 | 59.743 | 60.086 | 1794.0 |
> showing 50 of 104 rows — these rows as CSV