PREVIEW / futures_daily / 2014-10-29
file: by_date/futures_daily/2014/2014-10-29.parquet size: 9 KB rows: 106
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-10-29 | ES | Futures | 2064.1 | 2074.29 | 2049.48 | 2060.18 | 1895667.0 |
| 2014-10-29 | NQ | Futures | 4729.49 | 4747.46 | 4699.36 | 4719.64 | 340712.0 |
| 2014-10-29 | YM | Futures | 17164.7 | 17238.8 | 17064.3 | 17169.8 | 175425.0 |
| 2014-10-29 | CL | Futures | 156.57 | 159.13 | 156.36 | 157.82 | 283762.0 |
| 2014-10-29 | GC | Futures | 1610.4 | 1613.9 | 1584.7 | 1606.6 | 131448.0 |
| 2014-10-29 | ZN | Futures | 118.920117 | 119.037265 | 118.261158 | 118.510098 | 1158359.0 |
| 2014-10-29 | A6 | Futures | 0.85751 | 0.86315 | 0.84993 | 0.85275 | 116915.0 |
| 2014-10-29 | AD | Futures | 0.90849 | 0.91235 | 0.90392 | 0.90636 | 63992.0 |
| 2014-10-29 | ALI | Futures | 3092.16 | 3092.16 | 3092.16 | 3092.16 | 0.0 |
| 2014-10-29 | B | Futures | 89.57 | 91.39 | 89.53 | 90.56 | 111243.0 |
| 2014-10-29 | B6 | Futures | 1.695 | 1.6981 | 1.6814 | 1.6832 | 88230.0 |
| 2014-10-29 | BFX | Futures | 3778.9 | 3789.6 | 3772.4 | 3773.7 | 31.0 |
| 2014-10-29 | BR | Futures | 0.21701 | 0.22066 | 0.21679 | 0.21817 | 1160.0 |
| 2014-10-29 | BZ | Futures | 90.81 | 92.3 | 90.61 | 91.48 | 13922.0 |
| 2014-10-29 | C | Futures | 2028.0 | 2044.0 | 2010.0 | 2039.0 | 8202.0 |
| 2014-10-29 | CB | Futures | 130.877 | 133.922 | 130.877 | 133.151 | 32.0 |
| 2014-10-29 | CC | Futures | 2166.0 | 2178.0 | 2141.0 | 2168.0 | 18655.0 |
| 2014-10-29 | CNH | Futures | 7.0288 | 7.0335 | 7.0288 | 7.0335 | 1.0 |
| 2014-10-29 | CSC | Futures | 4.93 | 4.98 | 4.891 | 4.948 | 14.0 |
| 2014-10-29 | CT | Futures | 81.6 | 83.62 | 81.31 | 82.81 | 20547.0 |
| 2014-10-29 | DC | Futures | 39.99 | 40.49 | 39.8 | 40.3 | 234.0 |
| 2014-10-29 | DX | Futures | 81.101 | 81.761 | 80.921 | 81.672 | 35652.0 |
| 2014-10-29 | E1 | Futures | 1.35039 | 1.35473 | 1.33952 | 1.34118 | 36271.0 |
| 2014-10-29 | E6 | Futures | 1.49928 | 1.50376 | 1.48704 | 1.48892 | 192097.0 |
| 2014-10-29 | E7 | Futures | 1.4897 | 1.4942 | 1.4779 | 1.4796 | 2707.0 |
| 2014-10-29 | ED | Futures | 95.447 | 95.447 | 95.4374 | 95.4374 | 124270.0 |
| 2014-10-29 | ER | Futures | 97.979 | 97.984 | 97.974 | 97.979 | 33768.0 |
| 2014-10-29 | EW | Futures | 1454.0 | 1462.6 | 1442.0 | 1451.5 | 21051.0 |
| 2014-10-29 | FBTP | Futures | 94.17 | 94.5 | 94.13 | 94.32 | 61258.0 |
| 2014-10-29 | FBTS | Futures | 98.171 | 98.206 | 98.126 | 98.153 | 13513.0 |
| 2014-10-29 | FCE | Futures | 3332.8 | 3336.0 | 3298.1 | 3313.8 | 87349.0 |
| 2014-10-29 | FDAX | Futures | 9965.8 | 10034.3 | 9890.8 | 9940.6 | 102420.0 |
| 2014-10-29 | FDIV | Futures | 130.21 | 130.21 | 129.47 | 129.47 | 50.0 |
| 2014-10-29 | FESX | Futures | 2201.4 | 2205.0 | 2168.8 | 2181.8 | 837627.0 |
| 2014-10-29 | FGBL | Futures | 132.64 | 132.73 | 132.2 | 132.44 | 498391.0 |
| 2014-10-29 | FGBM | Futures | 122.92 | 122.94 | 122.74 | 122.84 | 230883.0 |
| 2014-10-29 | FGBS | Futures | 110.913 | 110.918 | 110.883 | 110.893 | 113086.0 |
| 2014-10-29 | FGBX | Futures | 144.68 | 144.8 | 143.55 | 144.1 | 16573.0 |
| 2014-10-29 | FMWO | Futures | 5609.7 | 5616.0 | 5595.9 | 5597.1 | 597.0 |
| 2014-10-29 | FOAT | Futures | 121.74 | 121.94 | 121.67 | 121.78 | 57108.0 |
| 2014-10-29 | FTDX | Futures | 1144.0 | 1155.4 | 1144.0 | 1148.3 | 164.0 |
| 2014-10-29 | FTI | Futures | 351.94 | 352.16 | 348.88 | 350.01 | 22892.0 |
| 2014-10-29 | FTUK | Futures | 4953.1 | 4990.2 | 4945.7 | 4968.5 | 86205.0 |
| 2014-10-29 | FVSA | Futures | 1633.32 | 1687.49 | 1620.82 | 1679.15 | 5506.0 |
| 2014-10-29 | FXXP | Futures | 249.8 | 250.3 | 248.6 | 248.7 | 12849.0 |
| 2014-10-29 | G | Futures | 98.8 | 98.86 | 98.48 | 98.61 | 109994.0 |
| 2014-10-29 | GF | Futures | 366.751 | 367.807 | 364.481 | 364.794 | 2253.0 |
| 2014-10-29 | GSCI | Futures | 920.47 | 932.53 | 920.47 | 928.12 | 139.0 |
| 2014-10-29 | HE | Futures | 121.131 | 121.804 | 118.372 | 119.247 | 18419.0 |
| 2014-10-29 | HG | Futures | 3.9194 | 3.9498 | 3.8972 | 3.9378 | 45392.0 |
> showing 50 of 106 rows — these rows as CSV