PREVIEW / futures_daily / 2014-06-03
file: by_date/futures_daily/2014/2014-06-03.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-06-03 | ES | Futures | 1988.06 | 1990.13 | 1982.37 | 1988.57 | 948001.0 |
| 2014-06-03 | NQ | Futures | 4291.32 | 4300.24 | 4275.2 | 4294.48 | 183988.0 |
| 2014-06-03 | YM | Futures | 16790.6 | 16795.6 | 16746.4 | 16781.5 | 82001.0 |
| 2014-06-03 | CL | Futures | 186.33 | 187.1 | 185.95 | 186.73 | 160208.0 |
| 2014-06-03 | GC | Futures | 1639.2 | 1644.2 | 1634.1 | 1639.7 | 90049.0 |
| 2014-06-03 | ZN | Futures | 116.590729 | 116.663163 | 116.0692 | 116.141634 | 111428.0 |
| 2014-06-03 | A6 | Futures | 0.88713 | 0.89145 | 0.88588 | 0.88857 | 62837.0 |
| 2014-06-03 | AD | Futures | 0.93002 | 0.93073 | 0.92799 | 0.92901 | 35541.0 |
| 2014-06-03 | ALI | Futures | 2764.31 | 2764.31 | 2764.31 | 2764.31 | 23.0 |
| 2014-06-03 | B | Futures | 113.22 | 113.37 | 112.72 | 113.17 | 144810.0 |
| 2014-06-03 | B6 | Futures | 1.7599 | 1.7638 | 1.7582 | 1.7598 | 63124.0 |
| 2014-06-03 | BFX | Futures | 3829.9 | 3829.9 | 3806.4 | 3806.4 | 1.0 |
| 2014-06-03 | BR | Futures | 0.2268 | 0.22767 | 0.22543 | 0.22575 | 163.0 |
| 2014-06-03 | BZ | Futures | 114.29 | 114.34 | 113.72 | 114.16 | 8767.0 |
| 2014-06-03 | C | Futures | 2015.0 | 2021.0 | 2008.0 | 2019.0 | 11013.0 |
| 2014-06-03 | CB | Futures | 108.716 | 109.666 | 108.562 | 109.666 | 10.0 |
| 2014-06-03 | CC | Futures | 2264.0 | 2267.0 | 2252.0 | 2264.0 | 14729.0 |
| 2014-06-03 | CNH | Futures | 7.1669 | 7.1725 | 7.1665 | 7.1665 | 10.0 |
| 2014-06-03 | CSC | Futures | 4.435 | 4.488 | 4.435 | 4.437 | 16.0 |
| 2014-06-03 | CT | Futures | 97.5 | 99.77 | 96.96 | 98.37 | 18875.0 |
| 2014-06-03 | DC | Futures | 35.2 | 35.43 | 34.94 | 35.18 | 89.0 |
| 2014-06-03 | DX | Futures | 76.658 | 76.681 | 76.453 | 76.566 | 13456.0 |
| 2014-06-03 | E1 | Futures | 1.42814 | 1.43404 | 1.4266 | 1.43122 | 27796.0 |
| 2014-06-03 | E6 | Futures | 1.60518 | 1.61132 | 1.60377 | 1.60825 | 167837.0 |
| 2014-06-03 | E7 | Futures | 1.5945 | 1.6005 | 1.5931 | 1.5975 | 1869.0 |
| 2014-06-03 | ED | Futures | 95.4114 | 95.4138 | 95.4114 | 95.4138 | 44500.0 |
| 2014-06-03 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 84608.0 |
| 2014-06-03 | EW | Futures | 1424.7 | 1427.9 | 1419.0 | 1425.2 | 12096.0 |
| 2014-06-03 | FBTP | Futures | 89.68 | 89.88 | 89.43 | 89.56 | 128179.0 |
| 2014-06-03 | FBTS | Futures | 97.575 | 97.654 | 97.539 | 97.575 | 44086.0 |
| 2014-06-03 | FCE | Futures | 3602.4 | 3604.0 | 3588.8 | 3593.2 | 59294.0 |
| 2014-06-03 | FDAX | Futures | 10992.3 | 11000.6 | 10918.3 | 10959.7 | 66136.0 |
| 2014-06-03 | FESX | Futures | 2333.2 | 2336.1 | 2321.0 | 2327.5 | 702833.0 |
| 2014-06-03 | FEU3 | Futures | 98.497 | 98.502 | 98.497 | 98.502 | 121.0 |
| 2014-06-03 | FGBL | Futures | 126.61 | 126.61 | 125.95 | 126.09 | 1283387.0 |
| 2014-06-03 | FGBM | Futures | 121.0 | 121.0 | 120.74 | 120.8 | 1000393.0 |
| 2014-06-03 | FGBS | Futures | 110.748 | 110.753 | 110.718 | 110.733 | 771898.0 |
| 2014-06-03 | FGBX | Futures | 131.28 | 131.42 | 130.06 | 130.49 | 68403.0 |
| 2014-06-03 | FMWO | Futures | 5690.7 | 5699.5 | 5690.7 | 5699.5 | 48.0 |
| 2014-06-03 | FOAT | Futures | 115.95 | 115.97 | 115.43 | 115.49 | 117945.0 |
| 2014-06-03 | FTDX | Futures | 1216.4 | 1216.4 | 1204.7 | 1208.4 | 243.0 |
| 2014-06-03 | FTI | Futures | 352.74 | 353.39 | 351.75 | 352.7 | 16469.0 |
| 2014-06-03 | FTUK | Futures | 5220.9 | 5221.3 | 5188.1 | 5197.6 | 72023.0 |
| 2014-06-03 | FVSA | Futures | 1569.0 | 1606.36 | 1569.0 | 1583.01 | 6214.0 |
| 2014-06-03 | FXXP | Futures | 258.3 | 258.5 | 256.9 | 257.2 | 3147.0 |
| 2014-06-03 | G | Futures | 94.08 | 94.08 | 93.6 | 93.77 | 150997.0 |
| 2014-06-03 | GF | Futures | 303.109 | 304.603 | 302.458 | 303.914 | 2861.0 |
| 2014-06-03 | GSCI | Futures | 1071.72 | 1073.29 | 1070.48 | 1073.04 | 174.0 |
| 2014-06-03 | HE | Futures | 127.656 | 129.129 | 127.262 | 128.682 | 15372.0 |
| 2014-06-03 | HG | Futures | 4.0474 | 4.0493 | 3.9963 | 4.0084 | 37571.0 |
> showing 50 of 106 rows — these rows as CSV