PREVIEW / futures_daily / 2014-08-06
file: by_date/futures_daily/2014/2014-08-06.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-08-06 | ES | Futures | 1989.04 | 1998.13 | 1976.83 | 1989.04 | 1705227.0 |
| 2014-08-06 | NQ | Futures | 4470.32 | 4489.64 | 4432.82 | 4463.68 | 292468.0 |
| 2014-08-06 | YM | Futures | 16516.1 | 16589.7 | 16418.2 | 16542.3 | 162864.0 |
| 2014-08-06 | CL | Futures | 179.71 | 180.65 | 178.0 | 178.42 | 263598.0 |
| 2014-08-06 | GC | Futures | 1690.6 | 1719.6 | 1690.1 | 1715.9 | 160366.0 |
| 2014-08-06 | ZN | Futures | 117.031758 | 117.425657 | 117.00258 | 117.177646 | 1226954.0 |
| 2014-08-06 | A6 | Futures | 0.89663 | 0.90369 | 0.89557 | 0.90127 | 90333.0 |
| 2014-08-06 | AD | Futures | 0.92576 | 0.92982 | 0.92362 | 0.92921 | 61116.0 |
| 2014-08-06 | ALI | Futures | 2935.13 | 2948.48 | 2935.13 | 2948.48 | 5.0 |
| 2014-08-06 | B | Futures | 110.73 | 111.33 | 110.5 | 110.56 | 206234.0 |
| 2014-08-06 | B6 | Futures | 1.7744 | 1.7744 | 1.7678 | 1.7703 | 91252.0 |
| 2014-08-06 | BFX | Futures | 3697.3 | 3699.2 | 3689.0 | 3699.2 | 19.0 |
| 2014-08-06 | BR | Futures | 0.22778 | 0.23039 | 0.22778 | 0.22989 | 1945.0 |
| 2014-08-06 | BZ | Futures | 111.54 | 112.2 | 111.36 | 111.43 | 14760.0 |
| 2014-08-06 | C | Futures | 2113.0 | 2131.0 | 2113.0 | 2129.0 | 4699.0 |
| 2014-08-06 | CC | Futures | 2347.0 | 2368.0 | 2347.0 | 2362.0 | 12082.0 |
| 2014-08-06 | CNH | Futures | 7.0932 | 7.0932 | 7.0805 | 7.0805 | 20.0 |
| 2014-08-06 | CSC | Futures | 4.602 | 4.602 | 4.571 | 4.571 | 13.0 |
| 2014-08-06 | CT | Futures | 80.57 | 80.95 | 80.5 | 80.7 | 20.0 |
| 2014-08-06 | DC | Futures | 37.3 | 37.64 | 37.07 | 37.33 | 218.0 |
| 2014-08-06 | DX | Futures | 77.471 | 77.623 | 77.329 | 77.369 | 27741.0 |
| 2014-08-06 | E1 | Futures | 1.40981 | 1.41353 | 1.40673 | 1.41225 | 39927.0 |
| 2014-08-06 | E6 | Futures | 1.57804 | 1.57993 | 1.57344 | 1.57863 | 199444.0 |
| 2014-08-06 | E7 | Futures | 1.5678 | 1.5696 | 1.5633 | 1.5683 | 1923.0 |
| 2014-08-06 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 105136.0 |
| 2014-08-06 | ER | Futures | 97.891 | 97.896 | 97.886 | 97.891 | 24465.0 |
| 2014-08-06 | EW | Futures | 1420.6 | 1426.9 | 1408.3 | 1419.1 | 17573.0 |
| 2014-08-06 | FBTP | Futures | 92.26 | 92.31 | 91.75 | 91.89 | 89201.0 |
| 2014-08-06 | FBTS | Futures | 98.401 | 98.436 | 98.356 | 98.392 | 14199.0 |
| 2014-08-06 | FCE | Futures | 3346.9 | 3358.4 | 3315.1 | 3345.3 | 135194.0 |
| 2014-08-06 | FDAX | Futures | 10037.3 | 10097.3 | 9945.9 | 10052.2 | 143385.0 |
| 2014-08-06 | FESX | Futures | 2192.3 | 2203.1 | 2170.0 | 2192.3 | 1539458.0 |
| 2014-08-06 | FGBL | Futures | 128.88 | 129.56 | 128.86 | 129.41 | 775145.0 |
| 2014-08-06 | FGBM | Futures | 121.7 | 122.0 | 121.7 | 121.91 | 430237.0 |
| 2014-08-06 | FGBS | Futures | 110.763 | 110.813 | 110.763 | 110.793 | 252124.0 |
| 2014-08-06 | FGBX | Futures | 136.39 | 137.97 | 136.39 | 137.64 | 24300.0 |
| 2014-08-06 | FMWO | Futures | 5604.0 | 5624.2 | 5599.0 | 5624.2 | 26.0 |
| 2014-08-06 | FOAT | Futures | 118.93 | 119.33 | 118.72 | 119.21 | 94917.0 |
| 2014-08-06 | FTDX | Futures | 1097.1 | 1099.0 | 1089.2 | 1092.9 | 418.0 |
| 2014-08-06 | FTI | Futures | 342.51 | 344.32 | 339.99 | 343.5 | 35805.0 |
| 2014-08-06 | FTUK | Futures | 5089.2 | 5090.4 | 5040.0 | 5072.3 | 103308.0 |
| 2014-08-06 | FVSA | Futures | 1570.7 | 1613.15 | 1515.51 | 1532.49 | 12365.0 |
| 2014-08-06 | FXXP | Futures | 247.7 | 248.5 | 245.8 | 247.4 | 10988.0 |
| 2014-08-06 | G | Futures | 94.89 | 95.41 | 94.89 | 95.32 | 153276.0 |
| 2014-08-06 | GF | Futures | 339.661 | 340.581 | 337.018 | 339.202 | 2304.0 |
| 2014-08-06 | GSCI | Futures | 1033.29 | 1038.47 | 1032.53 | 1034.21 | 331.0 |
| 2014-08-06 | HE | Futures | 122.709 | 125.429 | 122.346 | 123.555 | 15186.0 |
| 2014-08-06 | HG | Futures | 4.0928 | 4.0992 | 4.0353 | 4.0468 | 56322.0 |
| 2014-08-06 | HH | Futures | 49.928 | 49.928 | 49.928 | 49.928 | 392.0 |
| 2014-08-06 | HO | Futures | 2.2855 | 2.3041 | 2.2743 | 2.2965 | 68049.0 |
> showing 50 of 103 rows — these rows as CSV