PREVIEW / futures_daily / 2013-06-07
file: by_date/futures_daily/2013/2013-06-07.parquet size: 9 KB rows: 102
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-07 | ES | Futures | 1665.24 | 1687.83 | 1661.14 | 1682.18 | 2382985.0 |
| 2013-06-07 | NQ | Futures | 3405.49 | 3456.03 | 3395.96 | 3442.74 | 266604.0 |
| 2013-06-07 | YM | Futures | 14801.1 | 15015.8 | 14766.6 | 14975.4 | 228396.0 |
| 2013-06-07 | CL | Futures | 165.18 | 168.09 | 163.44 | 167.46 | 330833.0 |
| 2013-06-07 | GC | Futures | 1875.4 | 1882.0 | 1828.1 | 1836.0 | 199054.0 |
| 2013-06-07 | ZN | Futures | 116.515834 | 116.752372 | 115.694908 | 115.889704 | 37429.0 |
| 2013-06-07 | A6 | Futures | 0.88215 | 0.88335 | 0.86978 | 0.87633 | 172873.0 |
| 2013-06-07 | AD | Futures | 0.97813 | 0.98808 | 0.97633 | 0.98366 | 96023.0 |
| 2013-06-07 | B | Futures | 100.02 | 101.34 | 99.26 | 100.92 | 158172.0 |
| 2013-06-07 | B6 | Futures | 1.631 | 1.6342 | 1.6205 | 1.628 | 185374.0 |
| 2013-06-07 | BR | Futures | 0.22777 | 0.22893 | 0.22777 | 0.22777 | 147.0 |
| 2013-06-07 | BZ | Futures | 100.51 | 101.81 | 99.77 | 101.43 | 7941.0 |
| 2013-06-07 | C | Futures | 1683.0 | 1685.0 | 1659.0 | 1677.0 | 4084.0 |
| 2013-06-07 | CB | Futures | 79.794 | 79.794 | 79.172 | 79.651 | 12.0 |
| 2013-06-07 | CC | Futures | 1767.0 | 1774.0 | 1742.0 | 1769.0 | 25151.0 |
| 2013-06-07 | CNH | Futures | 7.1628 | 7.1638 | 7.1582 | 7.1609 | 32.0 |
| 2013-06-07 | CSC | Futures | 3.574 | 3.574 | 3.574 | 3.574 | 6.0 |
| 2013-06-07 | CT | Futures | 101.63 | 103.06 | 101.04 | 101.7 | 22189.0 |
| 2013-06-07 | DC | Futures | 27.44 | 27.52 | 27.42 | 27.46 | 42.0 |
| 2013-06-07 | DX | Futures | 78.41 | 78.669 | 77.924 | 78.482 | 74327.0 |
| 2013-06-07 | E1 | Futures | 1.38288 | 1.39099 | 1.37234 | 1.37607 | 71007.0 |
| 2013-06-07 | E6 | Futures | 1.56105 | 1.56636 | 1.55516 | 1.55905 | 308499.0 |
| 2013-06-07 | E7 | Futures | 1.5507 | 1.5561 | 1.5445 | 1.5489 | 4788.0 |
| 2013-06-07 | ED | Futures | 95.2659 | 95.2683 | 95.2635 | 95.2683 | 90599.0 |
| 2013-06-07 | ER | Futures | 97.817 | 97.822 | 97.803 | 97.813 | 58321.0 |
| 2013-06-07 | EW | Futures | 1194.8 | 1206.1 | 1190.0 | 1201.1 | 21288.0 |
| 2013-06-07 | FBTP | Futures | 77.67 | 78.75 | 77.44 | 78.57 | 52820.0 |
| 2013-06-07 | FBTS | Futures | 92.61 | 92.851 | 92.481 | 92.799 | 11625.0 |
| 2013-06-07 | FCE | Futures | 2952.8 | 3007.8 | 2938.1 | 2993.8 | 159292.0 |
| 2013-06-07 | FDAX | Futures | 9039.8 | 9209.4 | 8932.6 | 9186.0 | 158703.0 |
| 2013-06-07 | FESX | Futures | 1874.9 | 1912.0 | 1861.6 | 1905.7 | 1389852.0 |
| 2013-06-07 | FGBL | Futures | 120.47 | 120.7 | 119.89 | 120.06 | 879773.0 |
| 2013-06-07 | FGBM | Futures | 117.59 | 117.66 | 117.13 | 117.29 | 631818.0 |
| 2013-06-07 | FGBS | Futures | 110.313 | 110.328 | 110.178 | 110.228 | 441157.0 |
| 2013-06-07 | FGBX | Futures | 126.11 | 126.66 | 125.45 | 125.66 | 12525.0 |
| 2013-06-07 | FMWO | Futures | 4779.9 | 4821.7 | 4779.9 | 4821.7 | 140.0 |
| 2013-06-07 | FOAT | Futures | 107.69 | 107.79 | 107.1 | 107.38 | 53029.0 |
| 2013-06-07 | FTDX | Futures | 895.6 | 908.4 | 891.4 | 906.1 | 62.0 |
| 2013-06-07 | FTI | Futures | 304.14 | 307.4 | 301.88 | 306.75 | 38580.0 |
| 2013-06-07 | FTUK | Futures | 4706.3 | 4760.9 | 4678.9 | 4752.0 | 115453.0 |
| 2013-06-07 | FVSA | Futures | 3356.84 | 3356.84 | 3097.45 | 3112.7 | 8684.0 |
| 2013-06-07 | FXXP | Futures | 214.8 | 217.5 | 213.5 | 217.1 | 4921.0 |
| 2013-06-07 | G | Futures | 97.53 | 97.93 | 96.87 | 97.03 | 198438.0 |
| 2013-06-07 | GF | Futures | 243.424 | 244.14 | 241.445 | 241.992 | 1760.0 |
| 2013-06-07 | GSCI | Futures | 1013.68 | 1027.69 | 1012.22 | 1024.45 | 1897.0 |
| 2013-06-07 | HE | Futures | 95.4 | 96.171 | 95.15 | 95.823 | 21740.0 |
| 2013-06-07 | HG | Futures | 4.2386 | 4.259 | 4.1418 | 4.1641 | 71913.0 |
| 2013-06-07 | HH | Futures | 43.013 | 43.013 | 43.013 | 43.013 | 2001.0 |
| 2013-06-07 | HO | Futures | 2.3175 | 2.3469 | 2.2997 | 2.3309 | 18490.0 |
| 2013-06-07 | HRC | Futures | 2091.8 | 2091.8 | 2091.8 | 2091.8 | 0.0 |
> showing 50 of 102 rows — these rows as CSV