PREVIEW / futures_daily / 2015-12-14
file: by_date/futures_daily/2015/2015-12-14.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-14 | ES | Futures | 2137.88 | 2157.1 | 2118.38 | 2146.42 | 2652781.0 |
| 2015-12-14 | NQ | Futures | 5307.33 | 5361.55 | 5241.68 | 5346.31 | 423297.0 |
| 2015-12-14 | YM | Futures | 17765.5 | 17918.6 | 17646.5 | 17854.5 | 263763.0 |
| 2015-12-14 | CL | Futures | 55.02 | 56.47 | 53.69 | 55.92 | 234759.0 |
| 2015-12-14 | GC | Futures | 1383.8 | 1389.4 | 1364.6 | 1371.5 | 121860.0 |
| 2015-12-14 | ZN | Futures | 122.393292 | 122.438417 | 121.656255 | 121.701379 | 1078215.0 |
| 2015-12-14 | A6 | Futures | 0.71642 | 0.72504 | 0.71392 | 0.72284 | 77093.0 |
| 2015-12-14 | AD | Futures | 0.74445 | 0.74762 | 0.7419 | 0.74425 | 76808.0 |
| 2015-12-14 | ALI | Futures | 2147.63 | 2147.63 | 2147.63 | 2147.63 | 0.0 |
| 2015-12-14 | B | Futures | 33.46 | 33.71 | 32.03 | 33.26 | 290180.0 |
| 2015-12-14 | B6 | Futures | 1.5989 | 1.5999 | 1.5896 | 1.5932 | 71865.0 |
| 2015-12-14 | BR | Futures | 0.15636 | 0.15821 | 0.15636 | 0.15821 | 23.0 |
| 2015-12-14 | BZ | Futures | 33.03 | 33.41 | 31.76 | 32.96 | 27283.0 |
| 2015-12-14 | C | Futures | 2400.0 | 2423.0 | 2395.0 | 2421.0 | 9595.0 |
| 2015-12-14 | CB | Futures | 238.424 | 243.372 | 238.424 | 241.145 | 12.0 |
| 2015-12-14 | CC | Futures | 2475.0 | 2496.0 | 2460.0 | 2488.0 | 11984.0 |
| 2015-12-14 | CNH | Futures | 7.282 | 7.2822 | 7.2739 | 7.2739 | 7.0 |
| 2015-12-14 | CSC | Futures | 3.9 | 3.91 | 3.893 | 3.893 | 51.0 |
| 2015-12-14 | CT | Futures | 74.75 | 74.86 | 73.77 | 74.24 | 15304.0 |
| 2015-12-14 | DC | Futures | 30.96 | 31.05 | 30.88 | 30.9 | 90.0 |
| 2015-12-14 | DX | Futures | 91.332 | 91.537 | 90.902 | 91.222 | 25958.0 |
| 2015-12-14 | E1 | Futures | 1.28799 | 1.29569 | 1.28407 | 1.28723 | 20480.0 |
| 2015-12-14 | E6 | Futures | 1.28636 | 1.29525 | 1.28309 | 1.2894 | 225101.0 |
| 2015-12-14 | E7 | Futures | 1.2795 | 1.2881 | 1.276 | 1.2822 | 4657.0 |
| 2015-12-14 | EBM | Futures | 249.31 | 249.31 | 247.54 | 247.9 | 10503.0 |
| 2015-12-14 | ED | Futures | 95.6313 | 95.6313 | 95.6121 | 95.6217 | 302711.0 |
| 2015-12-14 | ER | Futures | 98.215 | 98.215 | 98.205 | 98.21 | 90111.0 |
| 2015-12-14 | EW | Futures | 1458.8 | 1468.8 | 1441.7 | 1449.7 | 54317.0 |
| 2015-12-14 | FBON | Futures | 116.01 | 116.08 | 115.39 | 115.56 | 320.0 |
| 2015-12-14 | FBTP | Futures | 104.95 | 104.99 | 104.24 | 104.43 | 66442.0 |
| 2015-12-14 | FBTS | Futures | 100.588 | 100.606 | 100.526 | 100.561 | 21251.0 |
| 2015-12-14 | FCE | Futures | 3802.0 | 3860.5 | 3730.1 | 3735.9 | 57414.0 |
| 2015-12-14 | FDAX | Futures | 11399.2 | 11505.4 | 11145.3 | 11172.8 | 178143.0 |
| 2015-12-14 | FDXM | Futures | 10740.4 | 10836.8 | 10498.8 | 10518.5 | 1276.0 |
| 2015-12-14 | FESX | Futures | 2426.3 | 2460.5 | 2374.6 | 2380.7 | 1582337.0 |
| 2015-12-14 | FEU3 | Futures | 98.868 | 98.873 | 98.868 | 98.873 | 4.0 |
| 2015-12-14 | FGBL | Futures | 140.19 | 140.33 | 139.71 | 139.9 | 549568.0 |
| 2015-12-14 | FGBM | Futures | 125.83 | 125.89 | 125.68 | 125.77 | 355015.0 |
| 2015-12-14 | FGBS | Futures | 111.453 | 111.468 | 111.418 | 111.438 | 193765.0 |
| 2015-12-14 | FGBX | Futures | 158.89 | 159.18 | 157.54 | 158.24 | 24272.0 |
| 2015-12-14 | FMWO | Futures | 5511.1 | 5511.1 | 5422.1 | 5422.1 | 2112.0 |
| 2015-12-14 | FOAT | Futures | 128.66 | 128.66 | 127.89 | 128.19 | 63999.0 |
| 2015-12-14 | FTDX | Futures | 1709.4 | 1712.3 | 1672.9 | 1672.9 | 3483.0 |
| 2015-12-14 | FTI | Futures | 375.14 | 379.16 | 366.66 | 367.63 | 19862.0 |
| 2015-12-14 | FTUK | Futures | 4802.6 | 4862.6 | 4742.3 | 4752.0 | 178379.0 |
| 2015-12-14 | FVSA | Futures | 2470.34 | 2682.09 | 2451.52 | 2663.26 | 23055.0 |
| 2015-12-14 | FXXP | Futures | 279.8 | 281.8 | 273.2 | 273.8 | 110074.0 |
| 2015-12-14 | G | Futures | 104.77 | 105.11 | 104.54 | 104.9 | 134650.0 |
| 2015-12-14 | GF | Futures | 291.761 | 294.077 | 284.957 | 285.97 | 3994.0 |
| 2015-12-14 | GSCI | Futures | 484.57 | 492.02 | 484.57 | 490.61 | 687.0 |
> showing 50 of 108 rows — these rows as CSV