PREVIEW / futures_daily / 2014-05-14
file: by_date/futures_daily/2014/2014-05-14.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-05-14 | ES | Futures | 1960.38 | 1962.97 | 1947.45 | 1950.55 | 1186879.0 |
| 2014-05-14 | NQ | Futures | 4156.06 | 4161.24 | 4124.7 | 4139.66 | 234686.0 |
| 2014-05-14 | YM | Futures | 16748.4 | 16762.4 | 16624.9 | 16655.0 | 114270.0 |
| 2014-05-14 | CL | Futures | 184.21 | 185.5 | 184.02 | 185.06 | 128173.0 |
| 2014-05-14 | GC | Futures | 1704.8 | 1725.0 | 1701.8 | 1720.6 | 120327.0 |
| 2014-05-14 | ZN | Futures | 115.982278 | 116.648676 | 115.92433 | 116.474833 | 1597706.0 |
| 2014-05-14 | A6 | Futures | 0.89702 | 0.90192 | 0.89693 | 0.89904 | 56075.0 |
| 2014-05-14 | AD | Futures | 0.92891 | 0.93205 | 0.92769 | 0.93144 | 37415.0 |
| 2014-05-14 | ALI | Futures | 2726.05 | 2726.69 | 2681.57 | 2681.57 | 3.0 |
| 2014-05-14 | B | Futures | 112.47 | 113.4 | 112.45 | 113.16 | 258580.0 |
| 2014-05-14 | B6 | Futures | 1.768 | 1.7732 | 1.7602 | 1.7621 | 115702.0 |
| 2014-05-14 | BFX | Futures | 3804.6 | 3809.8 | 3798.1 | 3801.3 | 691.0 |
| 2014-05-14 | BR | Futures | 0.23753 | 0.23818 | 0.23181 | 0.23745 | 793.0 |
| 2014-05-14 | BZ | Futures | 114.71 | 115.65 | 114.68 | 115.41 | 8306.0 |
| 2014-05-14 | C | Futures | 1876.0 | 1882.0 | 1872.0 | 1880.0 | 4333.0 |
| 2014-05-14 | CB | Futures | 106.108 | 106.108 | 105.092 | 105.092 | 17.0 |
| 2014-05-14 | CC | Futures | 2137.0 | 2138.0 | 2118.0 | 2132.0 | 6107.0 |
| 2014-05-14 | CNH | Futures | 7.1475 | 7.154 | 7.1447 | 7.1447 | 4.0 |
| 2014-05-14 | CSC | Futures | 4.444 | 4.479 | 4.444 | 4.466 | 216.0 |
| 2014-05-14 | CT | Futures | 102.39 | 103.74 | 102.03 | 102.13 | 9983.0 |
| 2014-05-14 | DC | Futures | 35.82 | 36.36 | 35.77 | 36.27 | 415.0 |
| 2014-05-14 | DX | Futures | 76.164 | 76.178 | 76.05 | 76.13 | 15352.0 |
| 2014-05-14 | E1 | Futures | 1.44238 | 1.44508 | 1.44161 | 1.44238 | 18893.0 |
| 2014-05-14 | E6 | Futures | 1.61746 | 1.62088 | 1.61699 | 1.61793 | 146960.0 |
| 2014-05-14 | E7 | Futures | 1.6069 | 1.61 | 1.6062 | 1.6071 | 2538.0 |
| 2014-05-14 | ED | Futures | 95.4186 | 95.4186 | 95.4138 | 95.4186 | 77045.0 |
| 2014-05-14 | ER | Futures | 97.867 | 97.876 | 97.862 | 97.871 | 94226.0 |
| 2014-05-14 | EW | Futures | 1408.9 | 1411.3 | 1396.1 | 1398.2 | 16756.0 |
| 2014-05-14 | FBTP | Futures | 89.86 | 90.12 | 89.81 | 89.99 | 77442.0 |
| 2014-05-14 | FBTS | Futures | 97.539 | 97.601 | 97.539 | 97.566 | 11830.0 |
| 2014-05-14 | FCE | Futures | 3567.7 | 3567.7 | 3551.3 | 3561.7 | 150792.0 |
| 2014-05-14 | FDAX | Futures | 10799.6 | 10808.4 | 10742.7 | 10783.6 | 81851.0 |
| 2014-05-14 | FESX | Futures | 2293.7 | 2295.2 | 2282.2 | 2290.9 | 676624.0 |
| 2014-05-14 | FEU3 | Futures | 98.488 | 98.492 | 98.488 | 98.492 | 308.0 |
| 2014-05-14 | FGBL | Futures | 125.37 | 125.96 | 125.34 | 125.85 | 781335.0 |
| 2014-05-14 | FGBM | Futures | 120.42 | 120.69 | 120.41 | 120.64 | 515110.0 |
| 2014-05-14 | FGBS | Futures | 110.638 | 110.678 | 110.633 | 110.663 | 320879.0 |
| 2014-05-14 | FGBX | Futures | 129.31 | 130.67 | 129.31 | 130.51 | 22174.0 |
| 2014-05-14 | FMWO | Futures | 5632.7 | 5633.9 | 5630.1 | 5632.7 | 700.0 |
| 2014-05-14 | FOAT | Futures | 114.85 | 115.53 | 114.82 | 115.46 | 64548.0 |
| 2014-05-14 | FTDX | Futures | 1165.8 | 1168.1 | 1158.7 | 1160.2 | 227.0 |
| 2014-05-14 | FTI | Futures | 348.82 | 348.99 | 346.96 | 347.87 | 55745.0 |
| 2014-05-14 | FTUK | Futures | 5225.1 | 5238.8 | 5213.3 | 5232.7 | 65342.0 |
| 2014-05-14 | FVSA | Futures | 1662.4 | 1676.41 | 1653.06 | 1653.06 | 3255.0 |
| 2014-05-14 | FXXP | Futures | 255.6 | 255.7 | 254.5 | 255.1 | 5493.0 |
| 2014-05-14 | G | Futures | 94.1 | 94.95 | 94.05 | 94.83 | 213755.0 |
| 2014-05-14 | GF | Futures | 293.913 | 296.021 | 293.875 | 294.948 | 2229.0 |
| 2014-05-14 | GSCI | Futures | 1084.72 | 1086.29 | 1083.23 | 1084.64 | 425.0 |
| 2014-05-14 | HE | Futures | 133.753 | 136.794 | 133.167 | 134.562 | 27341.0 |
| 2014-05-14 | HG | Futures | 4.0071 | 4.0608 | 3.9899 | 4.0378 | 44938.0 |
> showing 50 of 106 rows — these rows as CSV