PREVIEW / futures_daily / 2014-05-21
file: by_date/futures_daily/2014/2014-05-21.parquet size: 9 KB rows: 105
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-21 | ES | Futures | 1933.22 | 1951.84 | 1931.15 | 1950.29 | 1358710.0 |
| 2014-05-21 | NQ | Futures | 4142.83 | 4185.13 | 4136.21 | 4182.54 | 257181.0 |
| 2014-05-21 | YM | Futures | 16409.0 | 16588.7 | 16392.9 | 16566.6 | 143972.0 |
| 2014-05-21 | CL | Futures | 187.28 | 189.7 | 186.95 | 189.3 | 272127.0 |
| 2014-05-21 | GC | Futures | 1705.2 | 1708.0 | 1690.3 | 1697.2 | 126006.0 |
| 2014-05-21 | ZN | Futures | 116.779059 | 116.923928 | 116.416886 | 116.648676 | 1303774.0 |
| 2014-05-21 | A6 | Futures | 0.88645 | 0.88742 | 0.88309 | 0.88569 | 75636.0 |
| 2014-05-21 | AD | Futures | 0.92911 | 0.93022 | 0.92607 | 0.9283 | 45846.0 |
| 2014-05-21 | ALI | Futures | 2669.57 | 2669.57 | 2669.57 | 2669.57 | 0.0 |
| 2014-05-21 | B | Futures | 113.62 | 114.63 | 113.56 | 114.44 | 219999.0 |
| 2014-05-21 | B6 | Futures | 1.7695 | 1.7782 | 1.7688 | 1.7755 | 100805.0 |
| 2014-05-21 | BFX | Futures | 3748.6 | 3759.8 | 3748.6 | 3759.8 | 7.0 |
| 2014-05-21 | BR | Futures | 0.23681 | 0.23795 | 0.23681 | 0.23776 | 425.0 |
| 2014-05-21 | BZ | Futures | 115.87 | 116.91 | 115.83 | 116.72 | 7242.0 |
| 2014-05-21 | C | Futures | 1928.0 | 1942.0 | 1922.0 | 1935.0 | 8977.0 |
| 2014-05-21 | CB | Futures | 106.895 | 108.075 | 106.895 | 107.123 | 5.0 |
| 2014-05-21 | CC | Futures | 2194.0 | 2209.0 | 2183.0 | 2198.0 | 13124.0 |
| 2014-05-21 | CNH | Futures | 7.1572 | 7.1589 | 7.153 | 7.1537 | 21.0 |
| 2014-05-21 | CSC | Futures | 4.343 | 4.377 | 4.332 | 4.332 | 24.0 |
| 2014-05-21 | CT | Futures | 100.22 | 102.05 | 100.14 | 100.54 | 12367.0 |
| 2014-05-21 | DC | Futures | 35.22 | 35.53 | 35.01 | 35.04 | 222.0 |
| 2014-05-21 | DX | Futures | 76.073 | 76.354 | 75.945 | 76.145 | 17891.0 |
| 2014-05-21 | E1 | Futures | 1.43892 | 1.44277 | 1.4316 | 1.4361 | 31715.0 |
| 2014-05-21 | E6 | Futures | 1.61711 | 1.61994 | 1.60931 | 1.61474 | 175669.0 |
| 2014-05-21 | E7 | Futures | 1.6066 | 1.6091 | 1.5985 | 1.604 | 2755.0 |
| 2014-05-21 | ED | Futures | 95.4138 | 95.4162 | 95.4114 | 95.4138 | 84294.0 |
| 2014-05-21 | ER | Futures | 97.876 | 97.876 | 97.867 | 97.871 | 37886.0 |
| 2014-05-21 | EW | Futures | 1385.4 | 1397.7 | 1383.1 | 1394.6 | 14926.0 |
| 2014-05-21 | FBTP | Futures | 87.63 | 88.32 | 87.2 | 88.1 | 139525.0 |
| 2014-05-21 | FBTS | Futures | 97.056 | 97.284 | 96.897 | 97.232 | 22124.0 |
| 2014-05-21 | FCE | Futures | 3526.6 | 3551.3 | 3512.2 | 3547.3 | 85020.0 |
| 2014-05-21 | FDAX | Futures | 10633.4 | 10728.9 | 10585.9 | 10705.7 | 89827.0 |
| 2014-05-21 | FESX | Futures | 2260.0 | 2285.1 | 2250.6 | 2280.1 | 770614.0 |
| 2014-05-21 | FEU3 | Futures | 98.492 | 98.492 | 98.488 | 98.492 | 68.0 |
| 2014-05-21 | FGBL | Futures | 126.23 | 126.27 | 125.77 | 125.86 | 640580.0 |
| 2014-05-21 | FGBM | Futures | 120.83 | 120.86 | 120.61 | 120.66 | 392327.0 |
| 2014-05-21 | FGBS | Futures | 110.718 | 110.728 | 110.698 | 110.698 | 321744.0 |
| 2014-05-21 | FGBX | Futures | 131.22 | 131.28 | 130.46 | 130.57 | 22391.0 |
| 2014-05-21 | FMWO | Futures | 5570.8 | 5602.4 | 5570.8 | 5596.1 | 474.0 |
| 2014-05-21 | FOAT | Futures | 115.36 | 115.38 | 115.14 | 115.19 | 68159.0 |
| 2014-05-21 | FTDX | Futures | 1160.2 | 1167.7 | 1156.9 | 1165.3 | 100.0 |
| 2014-05-21 | FTI | Futures | 345.15 | 347.95 | 344.07 | 347.61 | 22342.0 |
| 2014-05-21 | FTUK | Futures | 5167.5 | 5197.6 | 5163.3 | 5190.0 | 71311.0 |
| 2014-05-21 | FVSA | Futures | 1629.71 | 1634.38 | 1587.68 | 1620.37 | 13854.0 |
| 2014-05-21 | FXXP | Futures | 252.9 | 254.9 | 252.0 | 254.6 | 7821.0 |
| 2014-05-21 | G | Futures | 94.77 | 94.87 | 94.27 | 94.42 | 184600.0 |
| 2014-05-21 | GF | Futures | 300.848 | 302.611 | 300.58 | 301.193 | 1847.0 |
| 2014-05-21 | GSCI | Futures | 1090.1 | 1090.77 | 1089.28 | 1089.28 | 68.0 |
| 2014-05-21 | HE | Futures | 133.585 | 134.673 | 132.944 | 133.836 | 12342.0 |
| 2014-05-21 | HG | Futures | 4.0167 | 4.0225 | 3.9592 | 3.9905 | 40527.0 |
> showing 50 of 105 rows — these rows as CSV