PREVIEW / futures_daily / 2011-11-10
file: by_date/futures_daily/2011/2011-11-10.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-10 | ES | Futures | 1224.1 | 1242.82 | 1216.11 | 1235.33 | 2584328.0 |
| 2011-11-10 | NQ | Futures | 2639.33 | 2675.57 | 2609.94 | 2629.34 | 301449.0 |
| 2011-11-10 | YM | Futures | 11273.3 | 11454.9 | 11202.2 | 11388.6 | 149818.0 |
| 2011-11-10 | CL | Futures | 179.63 | 184.51 | 178.6 | 183.44 | 347730.0 |
| 2011-11-10 | GC | Futures | 2391.1 | 2399.1 | 2344.7 | 2375.7 | 172534.0 |
| 2011-11-10 | ZN | Futures | 112.193161 | 112.313828 | 111.455754 | 111.844569 | 1104435.0 |
| 2011-11-10 | A6 | Futures | 0.8865 | 0.89389 | 0.88017 | 0.88694 | 145744.0 |
| 2011-11-10 | AD | Futures | 0.97634 | 0.98364 | 0.97384 | 0.98084 | 88243.0 |
| 2011-11-10 | B | Futures | 98.61 | 100.0 | 97.63 | 99.61 | 173780.0 |
| 2011-11-10 | B6 | Futures | 1.6601 | 1.6678 | 1.6556 | 1.6595 | 115225.0 |
| 2011-11-10 | BFX | Futures | 2488.2 | 2488.2 | 2459.1 | 2459.1 | 40.0 |
| 2011-11-10 | BR | Futures | 0.2548 | 0.2548 | 0.2548 | 0.2548 | 111.0 |
| 2011-11-10 | BZ | Futures | 103.75 | 105.29 | 103.64 | 105.18 | 1568.0 |
| 2011-11-10 | C | Futures | 1708.0 | 1719.0 | 1672.0 | 1676.0 | 4971.0 |
| 2011-11-10 | CB | Futures | 91.505 | 91.505 | 90.409 | 91.505 | 18.0 |
| 2011-11-10 | CC | Futures | 2014.0 | 2030.0 | 1975.0 | 1984.0 | 20096.0 |
| 2011-11-10 | CT | Futures | 125.29 | 129.93 | 124.81 | 128.28 | 18235.0 |
| 2011-11-10 | DC | Futures | 30.67 | 30.99 | 30.63 | 30.9 | 230.0 |
| 2011-11-10 | DX | Futures | 76.785 | 76.986 | 76.206 | 76.547 | 25385.0 |
| 2011-11-10 | E1 | Futures | 1.44126 | 1.45569 | 1.43365 | 1.44651 | 22869.0 |
| 2011-11-10 | E6 | Futures | 1.61676 | 1.63182 | 1.61162 | 1.62334 | 340140.0 |
| 2011-11-10 | E7 | Futures | 1.6037 | 1.6179 | 1.5981 | 1.6095 | 6415.0 |
| 2011-11-10 | ED | Futures | 94.9268 | 94.9459 | 94.8934 | 94.9173 | 324360.0 |
| 2011-11-10 | ER | Futures | 97.273 | 97.297 | 97.253 | 97.278 | 167989.0 |
| 2011-11-10 | EW | Futures | 870.1 | 883.2 | 862.5 | 871.7 | 31786.0 |
| 2011-11-10 | FBTP | Futures | 54.68 | 57.27 | 54.46 | 56.55 | 28617.0 |
| 2011-11-10 | FBTS | Futures | 75.049 | 78.797 | 75.049 | 78.396 | 6352.0 |
| 2011-11-10 | FCE | Futures | 2158.0 | 2242.0 | 2140.4 | 2199.3 | 120749.0 |
| 2011-11-10 | FDAX | Futures | 6183.7 | 6449.2 | 6152.2 | 6374.8 | 215081.0 |
| 2011-11-10 | FESX | Futures | 1460.0 | 1523.2 | 1455.3 | 1498.6 | 1677627.0 |
| 2011-11-10 | FEU3 | Futures | 97.831 | 97.841 | 97.831 | 97.836 | 8.0 |
| 2011-11-10 | FGBL | Futures | 112.87 | 112.93 | 111.57 | 112.1 | 862383.0 |
| 2011-11-10 | FGBM | Futures | 112.45 | 112.5 | 111.76 | 112.09 | 473820.0 |
| 2011-11-10 | FGBS | Futures | 109.442 | 109.447 | 109.307 | 109.422 | 507092.0 |
| 2011-11-10 | FGBX | Futures | 117.68 | 117.79 | 114.93 | 115.9 | 9384.0 |
| 2011-11-10 | FTDX | Futures | 627.0 | 636.2 | 622.4 | 626.5 | 293.0 |
| 2011-11-10 | FTI | Futures | 243.33 | 250.14 | 243.16 | 247.28 | 157.0 |
| 2011-11-10 | FTUK | Futures | 3852.6 | 3938.3 | 3823.1 | 3894.5 | 145412.0 |
| 2011-11-10 | FVSA | Futures | 17439.07 | 17605.75 | 16230.63 | 17126.54 | 3298.0 |
| 2011-11-10 | FXXP | Futures | 162.3 | 165.9 | 162.3 | 163.8 | 5245.0 |
| 2011-11-10 | G | Futures | 93.02 | 93.07 | 92.35 | 92.65 | 117346.0 |
| 2011-11-10 | GF | Futures | 313.256 | 317.618 | 312.987 | 313.795 | 2638.0 |
| 2011-11-10 | GSCI | Futures | 1029.52 | 1029.52 | 1018.05 | 1024.09 | 1777.0 |
| 2011-11-10 | HE | Futures | 109.451 | 111.957 | 109.322 | 110.222 | 30693.0 |
| 2011-11-10 | HG | Futures | 4.5005 | 4.5375 | 4.3907 | 4.4648 | 44449.0 |
| 2011-11-10 | HO | Futures | 2.4892 | 2.5495 | 2.4763 | 2.5311 | 69303.0 |
| 2011-11-10 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-10 | J1 | Futures | 0.0161652 | 0.0162205 | 0.0161451 | 0.0161903 | 58010.0 |
| 2011-11-10 | J7 | Futures | 0.016066 | 0.016122 | 0.016047 | 0.016092 | 316.0 |
| 2011-11-10 | JB | Futures | 124.69 | 124.83 | 124.67 | 124.68 | 3071.0 |
> showing 50 of 97 rows — these rows as CSV