PREVIEW / futures_daily / 2015-08-06
file: by_date/futures_daily/2015/2015-08-06.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-08-06 | ES | Futures | 2219.26 | 2224.82 | 2193.82 | 2203.89 | 1608876.0 |
| 2015-08-06 | NQ | Futures | 5360.96 | 5380.8 | 5257.05 | 5282.73 | 272055.0 |
| 2015-08-06 | YM | Futures | 17951.3 | 17986.2 | 17772.6 | 17844.5 | 131650.0 |
| 2015-08-06 | CL | Futures | 74.98 | 75.16 | 73.39 | 74.15 | 360977.0 |
| 2015-08-06 | GC | Futures | 1399.5 | 1411.3 | 1397.6 | 1407.2 | 94613.0 |
| 2015-08-06 | ZN | Futures | 120.898931 | 121.271524 | 120.809509 | 121.152295 | 834807.0 |
| 2015-08-06 | A6 | Futures | 0.72663 | 0.73128 | 0.72316 | 0.72544 | 60908.0 |
| 2015-08-06 | AD | Futures | 0.77567 | 0.78078 | 0.77465 | 0.77915 | 47160.0 |
| 2015-08-06 | ALI | Futures | 2186.34 | 2186.34 | 2186.34 | 2186.34 | 0.0 |
| 2015-08-06 | B | Futures | 46.37 | 46.61 | 45.76 | 46.36 | 176252.0 |
| 2015-08-06 | B6 | Futures | 1.6417 | 1.6453 | 1.6274 | 1.6328 | 148806.0 |
| 2015-08-06 | BFX | Futures | 4650.7 | 4658.0 | 4644.1 | 4644.1 | 7.0 |
| 2015-08-06 | BR | Futures | 0.1685 | 0.16976 | 0.16628 | 0.1676 | 1048.0 |
| 2015-08-06 | BZ | Futures | 46.52 | 46.52 | 45.74 | 46.32 | 22703.0 |
| 2015-08-06 | C | Futures | 2208.0 | 2215.0 | 2178.0 | 2179.0 | 14294.0 |
| 2015-08-06 | CB | Futures | 159.46 | 160.129 | 159.055 | 159.663 | 11.0 |
| 2015-08-06 | CC | Futures | 2284.0 | 2292.0 | 2250.0 | 2252.0 | 21708.0 |
| 2015-08-06 | CSC | Futures | 4.47 | 4.51 | 4.465 | 4.508 | 144.0 |
| 2015-08-06 | CT | Futures | 79.24 | 79.24 | 77.71 | 77.71 | 49.0 |
| 2015-08-06 | DC | Futures | 36.01 | 36.22 | 35.77 | 36.16 | 133.0 |
| 2015-08-06 | DX | Futures | 91.695 | 91.98 | 91.442 | 91.649 | 26781.0 |
| 2015-08-06 | E1 | Futures | 1.29773 | 1.30129 | 1.29075 | 1.2957 | 16683.0 |
| 2015-08-06 | E6 | Futures | 1.28122 | 1.28639 | 1.27805 | 1.28357 | 146531.0 |
| 2015-08-06 | E7 | Futures | 1.2746 | 1.2794 | 1.271 | 1.2765 | 3180.0 |
| 2015-08-06 | EBM | Futures | 292.66 | 299.22 | 291.84 | 295.53 | 16769.0 |
| 2015-08-06 | ED | Futures | 95.6079 | 95.6175 | 95.6031 | 95.6079 | 127528.0 |
| 2015-08-06 | ER | Futures | 98.117 | 98.122 | 98.117 | 98.117 | 7120.0 |
| 2015-08-06 | EW | Futures | 1574.1 | 1578.0 | 1549.5 | 1558.9 | 17103.0 |
| 2015-08-06 | FBTP | Futures | 100.39 | 100.74 | 100.26 | 100.65 | 58804.0 |
| 2015-08-06 | FBTS | Futures | 100.097 | 100.177 | 100.07 | 100.142 | 14686.0 |
| 2015-08-06 | FCE | Futures | 4317.5 | 4352.1 | 4310.5 | 4331.3 | 58820.0 |
| 2015-08-06 | FDAX | Futures | 12832.2 | 12904.6 | 12749.3 | 12812.3 | 72564.0 |
| 2015-08-06 | FESX | Futures | 2711.6 | 2729.4 | 2699.8 | 2715.3 | 659587.0 |
| 2015-08-06 | FGBL | Futures | 136.78 | 137.35 | 136.7 | 137.14 | 494946.0 |
| 2015-08-06 | FGBM | Futures | 124.58 | 124.7 | 124.54 | 124.63 | 305982.0 |
| 2015-08-06 | FGBS | Futures | 111.248 | 111.253 | 111.233 | 111.238 | 135769.0 |
| 2015-08-06 | FGBX | Futures | 154.34 | 155.5 | 153.8 | 154.91 | 25571.0 |
| 2015-08-06 | FMWO | Futures | 5837.2 | 5839.7 | 5797.8 | 5802.7 | 383.0 |
| 2015-08-06 | FOAT | Futures | 125.13 | 125.6 | 124.99 | 125.47 | 93624.0 |
| 2015-08-06 | FTDX | Futures | 1712.0 | 1712.5 | 1690.8 | 1692.7 | 219.0 |
| 2015-08-06 | FTI | Futures | 430.96 | 432.73 | 429.06 | 431.0 | 22160.0 |
| 2015-08-06 | FTUK | Futures | 5300.0 | 5341.3 | 5292.5 | 5326.6 | 71554.0 |
| 2015-08-06 | FVSA | Futures | 1662.42 | 1684.36 | 1618.56 | 1675.58 | 7367.0 |
| 2015-08-06 | FXXP | Futures | 308.4 | 309.4 | 306.6 | 307.4 | 10193.0 |
| 2015-08-06 | G | Futures | 102.19 | 102.48 | 101.87 | 102.4 | 148017.0 |
| 2015-08-06 | GF | Futures | 364.606 | 366.306 | 364.096 | 365.499 | 2515.0 |
| 2015-08-06 | GSCI | Futures | 613.93 | 614.26 | 610.51 | 612.84 | 747.0 |
| 2015-08-06 | HE | Futures | 91.687 | 91.824 | 87.721 | 88.131 | 16785.0 |
| 2015-08-06 | HG | Futures | 2.9347 | 2.9471 | 2.9153 | 2.9215 | 38605.0 |
| 2015-08-06 | HH | Futures | 34.01 | 34.734 | 33.41 | 34.488 | 3771.0 |
> showing 50 of 105 rows — these rows as CSV