PREVIEW / futures_daily / 2014-06-25
file: by_date/futures_daily/2014/2014-06-25.parquet size: 9 KB rows: 105
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-25 | ES | Futures | 2017.6 | 2029.03 | 2012.41 | 2025.13 | 1532088.0 |
| 2014-06-25 | NQ | Futures | 4375.42 | 4411.47 | 4364.74 | 4401.38 | 249821.0 |
| 2014-06-25 | YM | Futures | 16893.4 | 16954.0 | 16849.0 | 16921.7 | 129816.0 |
| 2014-06-25 | CL | Futures | 193.88 | 196.37 | 192.66 | 194.54 | 249064.0 |
| 2014-06-25 | GC | Futures | 1737.8 | 1746.6 | 1720.0 | 1742.6 | 136623.0 |
| 2014-06-25 | ZN | Futures | 116.331493 | 116.783747 | 116.287726 | 116.521148 | 1181032.0 |
| 2014-06-25 | A6 | Futures | 0.90021 | 0.90407 | 0.89885 | 0.9032 | 64009.0 |
| 2014-06-25 | AD | Futures | 0.94323 | 0.94597 | 0.94272 | 0.94505 | 43278.0 |
| 2014-06-25 | ALI | Futures | 2806.86 | 2806.86 | 2806.86 | 2806.86 | 0.0 |
| 2014-06-25 | B | Futures | 119.8 | 120.1 | 118.67 | 119.39 | 126177.0 |
| 2014-06-25 | B6 | Futures | 1.7842 | 1.7866 | 1.781 | 1.7839 | 79299.0 |
| 2014-06-25 | BFX | Futures | 3760.4 | 3776.1 | 3760.4 | 3776.1 | 53.0 |
| 2014-06-25 | BR | Futures | 0.23257 | 0.23505 | 0.23257 | 0.23437 | 1654.0 |
| 2014-06-25 | BZ | Futures | 120.85 | 120.85 | 119.43 | 120.15 | 15888.0 |
| 2014-06-25 | C | Futures | 2017.0 | 2028.0 | 2010.0 | 2023.0 | 1400.0 |
| 2014-06-25 | CB | Futures | 121.851 | 122.69 | 121.851 | 122.69 | 2.0 |
| 2014-06-25 | CC | Futures | 2236.0 | 2259.0 | 2234.0 | 2254.0 | 10917.0 |
| 2014-06-25 | CNH | Futures | 7.1748 | 7.1807 | 7.1739 | 7.1739 | 1.0 |
| 2014-06-25 | CSC | Futures | 4.716 | 4.716 | 4.687 | 4.689 | 25.0 |
| 2014-06-25 | CT | Futures | 96.18 | 96.18 | 94.05 | 94.49 | 64.0 |
| 2014-06-25 | DC | Futures | 37.87 | 37.87 | 37.4 | 37.54 | 168.0 |
| 2014-06-25 | DX | Futures | 76.304 | 76.327 | 76.071 | 76.19 | 27795.0 |
| 2014-06-25 | E1 | Futures | 1.43494 | 1.44032 | 1.43404 | 1.4366 | 30461.0 |
| 2014-06-25 | E6 | Futures | 1.60565 | 1.61132 | 1.60518 | 1.60837 | 150113.0 |
| 2014-06-25 | E7 | Futures | 1.5953 | 1.6008 | 1.5948 | 1.5979 | 1748.0 |
| 2014-06-25 | ED | Futures | 95.4115 | 95.4162 | 95.4067 | 95.4115 | 85847.0 |
| 2014-06-25 | ER | Futures | 97.916 | 97.925 | 97.911 | 97.916 | 74847.0 |
| 2014-06-25 | EW | Futures | 1465.5 | 1474.1 | 1458.3 | 1471.8 | 18305.0 |
| 2014-06-25 | FBTP | Futures | 91.34 | 91.58 | 91.12 | 91.52 | 53288.0 |
| 2014-06-25 | FBTS | Futures | 98.072 | 98.134 | 98.019 | 98.116 | 11665.0 |
| 2014-06-25 | FCE | Futures | 3587.2 | 3591.2 | 3550.1 | 3560.9 | 104728.0 |
| 2014-06-25 | FDAX | Futures | 10901.8 | 10928.3 | 10839.1 | 10887.5 | 90996.0 |
| 2014-06-25 | FESX | Futures | 2346.1 | 2353.3 | 2329.6 | 2339.7 | 912299.0 |
| 2014-06-25 | FEU3 | Futures | 98.537 | 98.542 | 98.537 | 98.537 | 550.0 |
| 2014-06-25 | FGBL | Futures | 127.26 | 127.76 | 127.14 | 127.69 | 576853.0 |
| 2014-06-25 | FGBM | Futures | 121.27 | 121.47 | 121.23 | 121.44 | 377667.0 |
| 2014-06-25 | FGBS | Futures | 110.743 | 110.768 | 110.738 | 110.758 | 223820.0 |
| 2014-06-25 | FGBX | Futures | 131.01 | 132.3 | 131.01 | 132.22 | 14646.0 |
| 2014-06-25 | FMWO | Futures | 5763.8 | 5770.1 | 5750.0 | 5770.1 | 212.0 |
| 2014-06-25 | FOAT | Futures | 117.07 | 117.59 | 116.91 | 117.52 | 54244.0 |
| 2014-06-25 | FTDX | Futures | 1229.6 | 1231.0 | 1218.3 | 1225.3 | 228.0 |
| 2014-06-25 | FTI | Futures | 357.62 | 357.88 | 354.72 | 356.24 | 28791.0 |
| 2014-06-25 | FTUK | Futures | 5163.1 | 5167.7 | 5128.1 | 5147.3 | 80365.0 |
| 2014-06-25 | FVSA | Futures | 1302.25 | 1340.93 | 1285.06 | 1319.44 | 10803.0 |
| 2014-06-25 | FXXP | Futures | 258.4 | 258.4 | 256.1 | 257.2 | 11116.0 |
| 2014-06-25 | G | Futures | 93.34 | 93.99 | 93.34 | 93.96 | 169083.0 |
| 2014-06-25 | GF | Futures | 322.765 | 327.324 | 322.458 | 325.102 | 4312.0 |
| 2014-06-25 | GSCI | Futures | 1111.58 | 1113.08 | 1106.83 | 1112.0 | 241.0 |
| 2014-06-25 | HE | Futures | 137.941 | 138.257 | 134.679 | 136.047 | 17285.0 |
| 2014-06-25 | HG | Futures | 4.011 | 4.0506 | 3.9918 | 4.0468 | 37566.0 |
> showing 50 of 105 rows — these rows as CSV