PREVIEW / futures_daily / 2016-03-11
file: by_date/futures_daily/2016/2016-03-11.parquet size: 9 KB rows: 107
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-03-11 | ES | Futures | 2123.99 | 2160.04 | 2122.92 | 2157.64 | 1220530.0 |
| 2016-03-11 | NQ | Futures | 5025.98 | 5112.73 | 5020.41 | 5102.76 | 156647.0 |
| 2016-03-11 | YM | Futures | 17581.2 | 17811.0 | 17561.4 | 17770.4 | 120835.0 |
| 2016-03-11 | CL | Futures | 47.73 | 49.03 | 47.64 | 48.37 | 564791.0 |
| 2016-03-11 | GC | Futures | 1634.4 | 1654.7 | 1604.9 | 1618.2 | 235781.0 |
| 2016-03-11 | ZN | Futures | 124.197324 | 124.318021 | 123.789971 | 123.925755 | 1102407.0 |
| 2016-03-11 | A6 | Futures | 0.75128 | 0.76423 | 0.75057 | 0.76322 | 106999.0 |
| 2016-03-11 | AD | Futures | 0.76654 | 0.77666 | 0.76623 | 0.77339 | 98513.0 |
| 2016-03-11 | ALI | Futures | 2116.1 | 2116.1 | 2116.1 | 2116.1 | 0.0 |
| 2016-03-11 | B | Futures | 33.59 | 34.17 | 33.33 | 33.64 | 276648.0 |
| 2016-03-11 | B6 | Futures | 1.5042 | 1.5206 | 1.5014 | 1.5152 | 106263.0 |
| 2016-03-11 | BR | Futures | 0.17566 | 0.17654 | 0.17508 | 0.17648 | 18.0 |
| 2016-03-11 | BZ | Futures | 33.18 | 33.81 | 33.0 | 33.3 | 22689.0 |
| 2016-03-11 | C | Futures | 2359.0 | 2376.0 | 2334.0 | 2347.0 | 21198.0 |
| 2016-03-11 | CB | Futures | 252.122 | 253.921 | 251.97 | 252.092 | 49.0 |
| 2016-03-11 | CC | Futures | 2239.0 | 2253.0 | 2232.0 | 2242.0 | 12800.0 |
| 2016-03-11 | CNH | Futures | 7.1168 | 7.1183 | 7.0845 | 7.0845 | 30.0 |
| 2016-03-11 | CSC | Futures | 3.544 | 3.58 | 3.541 | 3.58 | 24.0 |
| 2016-03-11 | CT | Futures | 64.96 | 65.98 | 64.88 | 65.64 | 14380.0 |
| 2016-03-11 | DC | Futures | 27.97 | 28.16 | 27.89 | 28.16 | 71.0 |
| 2016-03-11 | DX | Futures | 89.726 | 90.211 | 89.479 | 89.714 | 34800.0 |
| 2016-03-11 | E1 | Futures | 1.2821 | 1.28687 | 1.27557 | 1.28499 | 25132.0 |
| 2016-03-11 | E6 | Futures | 1.30759 | 1.31097 | 1.29587 | 1.30473 | 295404.0 |
| 2016-03-11 | E7 | Futures | 1.3006 | 1.3037 | 1.2888 | 1.2976 | 5156.0 |
| 2016-03-11 | EBM | Futures | 199.45 | 200.42 | 197.85 | 199.13 | 11309.0 |
| 2016-03-11 | ED | Futures | 95.6292 | 95.634 | 95.61 | 95.6196 | 210686.0 |
| 2016-03-11 | ER | Futures | 98.205 | 98.249 | 98.205 | 98.244 | 96411.0 |
| 2016-03-11 | EW | Futures | 1453.1 | 1482.2 | 1453.1 | 1481.8 | 52813.0 |
| 2016-03-11 | FBON | Futures | 117.46 | 118.03 | 117.46 | 117.9 | 366.0 |
| 2016-03-11 | FBTP | Futures | 106.03 | 107.18 | 105.93 | 107.13 | 136732.0 |
| 2016-03-11 | FBTS | Futures | 100.961 | 101.069 | 100.952 | 101.024 | 34788.0 |
| 2016-03-11 | FCE | Futures | 3673.4 | 3755.9 | 3671.8 | 3741.3 | 122982.0 |
| 2016-03-11 | FDAX | Futures | 10441.9 | 10729.8 | 10435.4 | 10661.0 | 134801.0 |
| 2016-03-11 | FDXM | Futures | 9986.9 | 10263.0 | 9986.9 | 10204.1 | 346.0 |
| 2016-03-11 | FESX | Futures | 2294.0 | 2347.0 | 2291.6 | 2335.3 | 715883.0 |
| 2016-03-11 | FEU3 | Futures | 98.897 | 98.902 | 98.897 | 98.897 | 917.0 |
| 2016-03-11 | FGBL | Futures | 144.27 | 144.86 | 144.03 | 144.58 | 667399.0 |
| 2016-03-11 | FGBM | Futures | 126.98 | 127.17 | 126.86 | 127.09 | 562080.0 |
| 2016-03-11 | FGBS | Futures | 111.588 | 111.618 | 111.558 | 111.588 | 315616.0 |
| 2016-03-11 | FGBX | Futures | 166.14 | 169.02 | 165.72 | 167.76 | 39791.0 |
| 2016-03-11 | FMWO | Futures | 5468.5 | 5510.8 | 5462.2 | 5505.8 | 3017.0 |
| 2016-03-11 | FOAT | Futures | 131.38 | 132.45 | 131.3 | 132.28 | 101730.0 |
| 2016-03-11 | FTDX | Futures | 1519.0 | 1541.9 | 1519.0 | 1541.9 | 1.0 |
| 2016-03-11 | FTI | Futures | 385.59 | 392.16 | 385.59 | 391.05 | 502.0 |
| 2016-03-11 | FTUK | Futures | 4964.0 | 5025.9 | 4944.2 | 5009.0 | 71143.0 |
| 2016-03-11 | FVSA | Futures | 3033.82 | 3033.82 | 2875.99 | 2887.68 | 20728.0 |
| 2016-03-11 | FXXP | Futures | 266.3 | 269.7 | 266.3 | 269.6 | 27482.0 |
| 2016-03-11 | G | Futures | 107.75 | 107.76 | 107.14 | 107.17 | 176489.0 |
| 2016-03-11 | GF | Futures | 318.189 | 325.305 | 317.649 | 319.465 | 6733.0 |
| 2016-03-11 | GSCI | Futures | 497.36 | 500.37 | 496.09 | 498.19 | 2096.0 |
> showing 50 of 107 rows — these rows as CSV