PREVIEW / futures_daily / 2013-06-04
file: by_date/futures_daily/2013/2013-06-04.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 |
|---|---|---|---|---|---|---|---|
| 2013-06-04 | ES | Futures | 1679.36 | 1689.62 | 1664.73 | 1674.74 | 2173999.0 |
| 2013-06-04 | NQ | Futures | 3449.68 | 3473.35 | 3420.22 | 3436.1 | 283605.0 |
| 2013-06-04 | YM | Futures | 14987.2 | 15064.0 | 14857.2 | 14946.8 | 205077.0 |
| 2013-06-04 | CL | Futures | 162.79 | 164.64 | 161.1 | 162.72 | 301136.0 |
| 2013-06-04 | GC | Futures | 1873.4 | 1878.2 | 1842.7 | 1854.8 | 117534.0 |
| 2013-06-04 | ZN | Futures | 116.321038 | 116.321038 | 115.94536 | 116.070586 | 125984.0 |
| 2013-06-04 | A6 | Futures | 0.90079 | 0.90088 | 0.88621 | 0.88861 | 159062.0 |
| 2013-06-04 | AD | Futures | 0.97713 | 0.97733 | 0.96939 | 0.9707 | 67886.0 |
| 2013-06-04 | B | Futures | 98.4 | 99.84 | 97.87 | 99.49 | 189862.0 |
| 2013-06-04 | B6 | Futures | 1.6028 | 1.6054 | 1.598 | 1.6014 | 104833.0 |
| 2013-06-04 | BR | Futures | 0.22925 | 0.23037 | 0.22643 | 0.22777 | 65.0 |
| 2013-06-04 | BZ | Futures | 98.8 | 100.32 | 98.37 | 100.0 | 8436.0 |
| 2013-06-04 | C | Futures | 1617.0 | 1644.0 | 1609.0 | 1639.0 | 5908.0 |
| 2013-06-04 | CB | Futures | 78.933 | 78.957 | 78.694 | 78.933 | 63.0 |
| 2013-06-04 | CC | Futures | 1684.0 | 1709.0 | 1671.0 | 1707.0 | 15806.0 |
| 2013-06-04 | CNH | Futures | 7.153 | 7.153 | 7.1502 | 7.1502 | 11.0 |
| 2013-06-04 | CSC | Futures | 3.524 | 3.534 | 3.524 | 3.534 | 14.0 |
| 2013-06-04 | CT | Futures | 99.11 | 103.52 | 98.04 | 101.34 | 34363.0 |
| 2013-06-04 | DC | Futures | 27.13 | 27.13 | 26.99 | 27.0 | 172.0 |
| 2013-06-04 | DX | Futures | 79.51 | 79.77 | 79.414 | 79.579 | 25272.0 |
| 2013-06-04 | E1 | Futures | 1.35831 | 1.36089 | 1.35137 | 1.35844 | 38608.0 |
| 2013-06-04 | E6 | Futures | 1.54124 | 1.54478 | 1.53771 | 1.54231 | 225479.0 |
| 2013-06-04 | E7 | Futures | 1.531 | 1.5346 | 1.5277 | 1.5322 | 3529.0 |
| 2013-06-04 | ED | Futures | 95.2683 | 95.2707 | 95.2683 | 95.2683 | 48823.0 |
| 2013-06-04 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.827 | 67135.0 |
| 2013-06-04 | EW | Futures | 1202.3 | 1211.2 | 1188.9 | 1196.1 | 22099.0 |
| 2013-06-04 | FBTP | Futures | 78.79 | 79.14 | 78.68 | 79.05 | 65939.0 |
| 2013-06-04 | FBTS | Futures | 92.852 | 93.074 | 92.835 | 93.031 | 19337.0 |
| 2013-06-04 | FCE | Futures | 3045.7 | 3062.3 | 3008.2 | 3033.7 | 99942.0 |
| 2013-06-04 | FDAX | Futures | 9279.4 | 9326.1 | 9160.5 | 9224.4 | 99111.0 |
| 2013-06-04 | FDIV | Futures | 125.27 | 125.56 | 125.27 | 125.56 | 20.0 |
| 2013-06-04 | FESX | Futures | 1933.0 | 1942.0 | 1908.5 | 1925.3 | 819026.0 |
| 2013-06-04 | FGBL | Futures | 120.17 | 120.31 | 119.96 | 120.15 | 1236053.0 |
| 2013-06-04 | FGBM | Futures | 117.41 | 117.5 | 117.24 | 117.43 | 1108675.0 |
| 2013-06-04 | FGBS | Futures | 110.337 | 110.362 | 110.303 | 110.323 | 803981.0 |
| 2013-06-04 | FGBX | Futures | 124.88 | 125.22 | 124.5 | 124.84 | 62119.0 |
| 2013-06-04 | FMWO | Futures | 4839.5 | 4839.5 | 4839.5 | 4839.5 | 0.0 |
| 2013-06-04 | FOAT | Futures | 107.4 | 107.84 | 107.4 | 107.69 | 135297.0 |
| 2013-06-04 | FTDX | Futures | 907.0 | 907.0 | 902.7 | 904.6 | 55.0 |
| 2013-06-04 | FTI | Futures | 315.44 | 316.36 | 311.14 | 313.44 | 24901.0 |
| 2013-06-04 | FTUK | Futures | 4847.5 | 4873.5 | 4823.0 | 4859.4 | 77414.0 |
| 2013-06-04 | FVSA | Futures | 3082.19 | 3127.96 | 3074.56 | 3112.7 | 5198.0 |
| 2013-06-04 | FXXP | Futures | 220.8 | 220.9 | 219.5 | 219.9 | 3337.0 |
| 2013-06-04 | G | Futures | 97.39 | 97.45 | 97.16 | 97.3 | 175348.0 |
| 2013-06-04 | GF | Futures | 243.635 | 246.247 | 243.298 | 245.278 | 2009.0 |
| 2013-06-04 | GSCI | Futures | 1008.74 | 1017.89 | 1003.96 | 1014.09 | 163.0 |
| 2013-06-04 | HE | Futures | 93.258 | 94.603 | 93.208 | 94.379 | 23035.0 |
| 2013-06-04 | HG | Futures | 4.2469 | 4.3029 | 4.2322 | 4.2921 | 54894.0 |
| 2013-06-04 | HH | Futures | 44.946 | 45.182 | 44.912 | 44.923 | 5.0 |
| 2013-06-04 | HO | Futures | 2.289 | 2.3171 | 2.2753 | 2.3082 | 14935.0 |
> showing 50 of 103 rows — these rows as CSV