PREVIEW / futures_daily / 2015-03-27
file: by_date/futures_daily/2015/2015-03-27.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 |
|---|---|---|---|---|---|---|---|
| 2015-03-27 | ES | Futures | 2155.5 | 2163.65 | 2146.03 | 2158.13 | 1158856.0 |
| 2015-03-27 | NQ | Futures | 5007.53 | 5031.33 | 4989.25 | 5022.34 | 209529.0 |
| 2015-03-27 | YM | Futures | 18014.6 | 18082.1 | 17935.8 | 18028.9 | 113479.0 |
| 2015-03-27 | CL | Futures | 89.84 | 90.49 | 84.91 | 86.07 | 384092.0 |
| 2015-03-27 | GC | Futures | 1576.2 | 1578.8 | 1560.5 | 1571.1 | 134238.0 |
| 2015-03-27 | ZN | Futures | 121.612956 | 121.908959 | 121.479755 | 121.894159 | 949736.0 |
| 2015-03-27 | A6 | Futures | 0.76848 | 0.76926 | 0.76029 | 0.76187 | 87148.0 |
| 2015-03-27 | AD | Futures | 0.81689 | 0.81812 | 0.80832 | 0.80975 | 63208.0 |
| 2015-03-27 | ALI | Futures | 2622.26 | 2622.26 | 2622.26 | 2622.26 | 0.0 |
| 2015-03-27 | B | Futures | 57.83 | 57.83 | 54.85 | 55.27 | 145151.0 |
| 2015-03-27 | B6 | Futures | 1.5624 | 1.5698 | 1.5567 | 1.565 | 94806.0 |
| 2015-03-27 | BFX | Futures | 4477.7 | 4489.8 | 4476.5 | 4483.8 | 80.0 |
| 2015-03-27 | BR | Futures | 0.17561 | 0.17561 | 0.17342 | 0.17345 | 17.0 |
| 2015-03-27 | BZ | Futures | 57.07 | 57.18 | 54.39 | 54.78 | 18974.0 |
| 2015-03-27 | C | Futures | 2120.0 | 2120.0 | 2090.0 | 2099.0 | 5933.0 |
| 2015-03-27 | CB | Futures | 144.028 | 146.253 | 144.028 | 146.253 | 22.0 |
| 2015-03-27 | CC | Futures | 2027.0 | 2035.0 | 2010.0 | 2026.0 | 15115.0 |
| 2015-03-27 | CSC | Futures | 4.327 | 4.327 | 4.308 | 4.308 | 23.0 |
| 2015-03-27 | CT | Futures | 80.53 | 81.96 | 80.49 | 81.46 | 8060.0 |
| 2015-03-27 | DC | Futures | 34.82 | 35.11 | 34.82 | 34.98 | 76.0 |
| 2015-03-27 | DX | Futures | 91.62 | 92.216 | 91.259 | 91.568 | 56439.0 |
| 2015-03-27 | E1 | Futures | 1.32768 | 1.33775 | 1.31901 | 1.33112 | 19038.0 |
| 2015-03-27 | E6 | Futures | 1.28035 | 1.28894 | 1.27141 | 1.28364 | 279856.0 |
| 2015-03-27 | E7 | Futures | 1.2727 | 1.2815 | 1.2642 | 1.2762 | 6725.0 |
| 2015-03-27 | EBM | Futures | 302.08 | 303.68 | 300.88 | 302.88 | 16956.0 |
| 2015-03-27 | ED | Futures | 95.5094 | 95.5237 | 95.5094 | 95.5189 | 105075.0 |
| 2015-03-27 | ER | Futures | 98.053 | 98.063 | 98.043 | 98.053 | 60567.0 |
| 2015-03-27 | EW | Futures | 1569.9 | 1577.9 | 1563.8 | 1576.0 | 13635.0 |
| 2015-03-27 | FBTP | Futures | 103.22 | 103.48 | 102.85 | 102.95 | 89361.0 |
| 2015-03-27 | FBTS | Futures | 99.555 | 99.572 | 99.501 | 99.528 | 14122.0 |
| 2015-03-27 | FCE | Futures | 4076.1 | 4107.8 | 4066.7 | 4094.8 | 101003.0 |
| 2015-03-27 | FDAX | Futures | 13224.2 | 13295.8 | 13122.7 | 13190.4 | 104533.0 |
| 2015-03-27 | FESX | Futures | 2653.4 | 2669.6 | 2641.6 | 2656.4 | 986783.0 |
| 2015-03-27 | FGBL | Futures | 140.76 | 140.9 | 140.42 | 140.85 | 530938.0 |
| 2015-03-27 | FGBM | Futures | 124.79 | 124.81 | 124.69 | 124.79 | 313268.0 |
| 2015-03-27 | FGBS | Futures | 111.253 | 111.258 | 111.233 | 111.243 | 195935.0 |
| 2015-03-27 | FGBX | Futures | 176.85 | 177.05 | 175.55 | 176.89 | 24790.0 |
| 2015-03-27 | FMWO | Futures | 5728.7 | 5737.3 | 5727.5 | 5737.3 | 190.0 |
| 2015-03-27 | FOAT | Futures | 129.53 | 129.6 | 129.25 | 129.49 | 58866.0 |
| 2015-03-27 | FTDX | Futures | 1496.5 | 1511.9 | 1483.3 | 1499.7 | 128.0 |
| 2015-03-27 | FTI | Futures | 420.81 | 422.63 | 417.91 | 420.12 | 30160.0 |
| 2015-03-27 | FTUK | Futures | 5391.2 | 5406.2 | 5347.4 | 5356.9 | 99801.0 |
| 2015-03-27 | FVSA | Futures | 1774.47 | 1854.94 | 1749.06 | 1846.47 | 11224.0 |
| 2015-03-27 | FXXP | Futures | 298.9 | 300.9 | 298.5 | 299.0 | 9181.0 |
| 2015-03-27 | G | Futures | 105.04 | 105.4 | 104.46 | 105.38 | 181084.0 |
| 2015-03-27 | GF | Futures | 369.238 | 372.843 | 368.856 | 371.994 | 1693.0 |
| 2015-03-27 | GSCI | Futures | 706.62 | 706.96 | 690.59 | 692.66 | 25.0 |
| 2015-03-27 | HE | Futures | 78.595 | 79.231 | 78.277 | 78.855 | 201.0 |
| 2015-03-27 | HG | Futures | 3.5651 | 3.5696 | 3.5016 | 3.5162 | 51794.0 |
| 2015-03-27 | HH | Futures | 32.867 | 32.904 | 32.25 | 32.559 | 8471.0 |
> showing 50 of 105 rows — these rows as CSV