PREVIEW / futures_daily / 2016-04-15
file: by_date/futures_daily/2016/2016-04-15.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-15 | ES | Futures | 2230.92 | 2233.33 | 2222.06 | 2227.96 | 1230494.0 |
| 2016-04-15 | NQ | Futures | 5344.81 | 5351.57 | 5314.56 | 5332.77 | 171811.0 |
| 2016-04-15 | YM | Futures | 18558.5 | 18579.3 | 18486.8 | 18522.1 | 95930.0 |
| 2016-04-15 | CL | Futures | 50.78 | 51.08 | 49.07 | 49.69 | 387546.0 |
| 2016-04-15 | GC | Futures | 1583.5 | 1595.2 | 1581.3 | 1591.3 | 121270.0 |
| 2016-04-15 | ZN | Futures | 125.811648 | 126.234088 | 125.721125 | 126.143565 | 819010.0 |
| 2016-04-15 | A6 | Futures | 0.77648 | 0.78083 | 0.77537 | 0.77931 | 79595.0 |
| 2016-04-15 | AD | Futures | 0.79578 | 0.79905 | 0.79241 | 0.79639 | 56445.0 |
| 2016-04-15 | ALI | Futures | 2115.06 | 2115.06 | 2115.06 | 2115.06 | 0.0 |
| 2016-04-15 | B | Futures | 36.48 | 36.69 | 35.21 | 35.89 | 285166.0 |
| 2016-04-15 | B6 | Futures | 1.4902 | 1.4999 | 1.4884 | 1.4958 | 68463.0 |
| 2016-04-15 | BR | Futures | 0.18367 | 0.18412 | 0.18103 | 0.18171 | 25.0 |
| 2016-04-15 | BZ | Futures | 36.12 | 36.32 | 34.86 | 35.53 | 30288.0 |
| 2016-04-15 | C | Futures | 2308.0 | 2342.0 | 2294.0 | 2304.0 | 5329.0 |
| 2016-04-15 | CB | Futures | 259.896 | 259.896 | 259.896 | 259.896 | 11.0 |
| 2016-04-15 | CC | Futures | 2184.0 | 2217.0 | 2175.0 | 2185.0 | 18622.0 |
| 2016-04-15 | CNH | Futures | 7.0795 | 7.0795 | 7.0647 | 7.0675 | 21.0 |
| 2016-04-15 | CSC | Futures | 3.623 | 3.642 | 3.615 | 3.627 | 21.0 |
| 2016-04-15 | CT | Futures | 69.02 | 69.55 | 67.96 | 68.94 | 19013.0 |
| 2016-04-15 | DC | Futures | 28.59 | 28.96 | 28.55 | 28.75 | 107.0 |
| 2016-04-15 | DX | Futures | 88.486 | 88.607 | 88.09 | 88.277 | 16301.0 |
| 2016-04-15 | E1 | Futures | 1.30245 | 1.30534 | 1.29994 | 1.3012 | 16265.0 |
| 2016-04-15 | E6 | Futures | 1.31523 | 1.32205 | 1.31365 | 1.31838 | 131864.0 |
| 2016-04-15 | E7 | Futures | 1.3084 | 1.3149 | 1.3065 | 1.3113 | 2560.0 |
| 2016-04-15 | EBM | Futures | 197.85 | 197.85 | 193.34 | 194.63 | 28882.0 |
| 2016-04-15 | ED | Futures | 95.716 | 95.7256 | 95.7112 | 95.7256 | 122619.0 |
| 2016-04-15 | ER | Futures | 98.264 | 98.264 | 98.254 | 98.264 | 19161.0 |
| 2016-04-15 | EW | Futures | 1538.3 | 1546.3 | 1533.9 | 1544.6 | 17751.0 |
| 2016-04-15 | FBON | Futures | 118.72 | 118.85 | 118.48 | 118.6 | 429.0 |
| 2016-04-15 | FBTP | Futures | 106.86 | 107.19 | 106.83 | 107.0 | 54921.0 |
| 2016-04-15 | FBTS | Futures | 100.97 | 101.006 | 100.97 | 100.997 | 13682.0 |
| 2016-04-15 | FCE | Futures | 3762.1 | 3769.8 | 3745.6 | 3758.7 | 91182.0 |
| 2016-04-15 | FDAX | Futures | 10853.7 | 10876.3 | 10788.2 | 10833.9 | 83213.0 |
| 2016-04-15 | FDXM | Futures | 10461.6 | 10473.0 | 10386.1 | 10432.7 | 12615.0 |
| 2016-04-15 | FESX | Futures | 2325.2 | 2333.7 | 2318.1 | 2325.9 | 976600.0 |
| 2016-04-15 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.912 | 14.0 |
| 2016-04-15 | FGBL | Futures | 146.09 | 146.68 | 146.03 | 146.58 | 471145.0 |
| 2016-04-15 | FGBM | Futures | 127.55 | 127.75 | 127.55 | 127.72 | 330385.0 |
| 2016-04-15 | FGBS | Futures | 111.663 | 111.693 | 111.658 | 111.688 | 107606.0 |
| 2016-04-15 | FGBX | Futures | 173.35 | 174.83 | 173.12 | 174.57 | 22942.0 |
| 2016-04-15 | FMWO | Futures | 5655.2 | 5666.3 | 5651.4 | 5663.9 | 410.0 |
| 2016-04-15 | FOAT | Futures | 133.65 | 134.21 | 133.62 | 134.12 | 60561.0 |
| 2016-04-15 | FTDX | Futures | 1579.5 | 1579.5 | 1568.0 | 1569.5 | 56.0 |
| 2016-04-15 | FTI | Futures | 400.32 | 401.59 | 399.42 | 400.91 | 34243.0 |
| 2016-04-15 | FTUK | Futures | 5211.6 | 5223.9 | 5183.5 | 5196.7 | 110392.0 |
| 2016-04-15 | FVSA | Futures | 2565.73 | 2602.46 | 2555.23 | 2570.98 | 10385.0 |
| 2016-04-15 | FXXP | Futures | 272.1 | 272.4 | 270.6 | 271.4 | 19445.0 |
| 2016-04-15 | G | Futures | 108.44 | 108.77 | 108.39 | 108.66 | 128782.0 |
| 2016-04-15 | GF | Futures | 299.824 | 302.97 | 299.674 | 300.723 | 2612.0 |
| 2016-04-15 | GSCI | Futures | 488.99 | 495.74 | 488.99 | 493.61 | 242.0 |
> showing 50 of 109 rows — these rows as CSV