PREVIEW / futures_daily / 2016-02-01
file: by_date/futures_daily/2016/2016-02-01.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-02-01 | ES | Futures | 2061.24 | 2072.18 | 2042.81 | 2062.84 | 1748062.0 |
| 2016-02-01 | NQ | Futures | 4997.84 | 5051.77 | 4957.1 | 5030.96 | 263363.0 |
| 2016-02-01 | YM | Futures | 16936.6 | 16997.6 | 16773.1 | 16908.6 | 178466.0 |
| 2016-02-01 | CL | Futures | 48.73 | 49.24 | 45.07 | 45.55 | 595612.0 |
| 2016-02-01 | GC | Futures | 1436.5 | 1452.2 | 1433.1 | 1449.4 | 118524.0 |
| 2016-02-01 | ZN | Futures | 124.754819 | 124.95036 | 124.333655 | 124.348697 | 1229545.0 |
| 2016-02-01 | A6 | Futures | 0.7067 | 0.71222 | 0.7043 | 0.70991 | 77370.0 |
| 2016-02-01 | AD | Futures | 0.73096 | 0.73515 | 0.72707 | 0.73382 | 85743.0 |
| 2016-02-01 | ALI | Futures | 2117.06 | 2117.06 | 2117.06 | 2117.06 | 0.0 |
| 2016-02-01 | B | Futures | 30.13 | 30.46 | 28.5 | 28.77 | 331872.0 |
| 2016-02-01 | B6 | Futures | 1.4983 | 1.52 | 1.4971 | 1.5196 | 109523.0 |
| 2016-02-01 | BFX | Futures | 4185.2 | 4191.9 | 4163.6 | 4191.9 | 4.0 |
| 2016-02-01 | BR | Futures | 0.15501 | 0.15771 | 0.15497 | 0.15674 | 1341.0 |
| 2016-02-01 | BZ | Futures | 29.93 | 30.28 | 28.29 | 28.56 | 36878.0 |
| 2016-02-01 | C | Futures | 2110.0 | 2181.0 | 2092.0 | 2175.0 | 17646.0 |
| 2016-02-01 | CB | Futures | 272.687 | 272.687 | 271.512 | 271.512 | 58.0 |
| 2016-02-01 | CC | Futures | 2039.0 | 2120.0 | 2023.0 | 2115.0 | 33122.0 |
| 2016-02-01 | CNH | Futures | 7.2764 | 7.3135 | 7.2764 | 7.3135 | 12.0 |
| 2016-02-01 | CSC | Futures | 3.755 | 3.76 | 3.738 | 3.738 | 49.0 |
| 2016-02-01 | CT | Futures | 71.28 | 72.63 | 71.28 | 72.38 | 22498.0 |
| 2016-02-01 | DC | Futures | 29.93 | 29.93 | 29.61 | 29.68 | 297.0 |
| 2016-02-01 | DX | Futures | 93.134 | 93.181 | 92.434 | 92.507 | 27833.0 |
| 2016-02-01 | E1 | Futures | 1.23471 | 1.24519 | 1.23357 | 1.24039 | 25626.0 |
| 2016-02-01 | E6 | Futures | 1.26765 | 1.27742 | 1.26578 | 1.27496 | 164237.0 |
| 2016-02-01 | E7 | Futures | 1.26 | 1.2702 | 1.2587 | 1.2678 | 3158.0 |
| 2016-02-01 | EBM | Futures | 230.59 | 230.59 | 227.06 | 227.41 | 21116.0 |
| 2016-02-01 | ED | Futures | 95.6602 | 95.665 | 95.6361 | 95.6458 | 229333.0 |
| 2016-02-01 | ER | Futures | 98.298 | 98.303 | 98.278 | 98.283 | 59708.0 |
| 2016-02-01 | EW | Futures | 1385.6 | 1393.6 | 1372.4 | 1383.5 | 24567.0 |
| 2016-02-01 | FBON | Futures | 117.82 | 118.0 | 117.27 | 117.29 | 546.0 |
| 2016-02-01 | FBTP | Futures | 106.61 | 106.75 | 105.92 | 105.98 | 105510.0 |
| 2016-02-01 | FBTS | Futures | 100.989 | 101.024 | 100.971 | 100.989 | 25212.0 |
| 2016-02-01 | FCE | Futures | 3721.4 | 3721.8 | 3650.8 | 3687.8 | 91150.0 |
| 2016-02-01 | FDAX | Futures | 10672.4 | 10676.7 | 10443.0 | 10561.2 | 96568.0 |
| 2016-02-01 | FDXM | Futures | 10212.6 | 10217.8 | 9985.6 | 10097.6 | 19621.0 |
| 2016-02-01 | FESX | Futures | 2326.7 | 2327.4 | 2271.2 | 2294.0 | 1168221.0 |
| 2016-02-01 | FGBL | Futures | 144.06 | 144.36 | 143.56 | 143.64 | 706484.0 |
| 2016-02-01 | FGBM | Futures | 127.13 | 127.2 | 126.94 | 126.98 | 514676.0 |
| 2016-02-01 | FGBS | Futures | 111.728 | 111.743 | 111.683 | 111.693 | 324399.0 |
| 2016-02-01 | FGBX | Futures | 167.75 | 168.2 | 166.21 | 166.49 | 38406.0 |
| 2016-02-01 | FMWO | Futures | 5266.7 | 5270.5 | 5235.6 | 5268.0 | 1358.0 |
| 2016-02-01 | FOAT | Futures | 131.38 | 131.57 | 130.79 | 130.87 | 88841.0 |
| 2016-02-01 | FTDX | Futures | 1624.0 | 1633.1 | 1618.7 | 1625.9 | 242.0 |
| 2016-02-01 | FTI | Futures | 382.7 | 382.79 | 374.91 | 378.76 | 34301.0 |
| 2016-02-01 | FTUK | Futures | 4945.4 | 4950.7 | 4844.2 | 4896.4 | 141837.0 |
| 2016-02-01 | FVSA | Futures | 2773.18 | 2838.02 | 2713.33 | 2743.26 | 11674.0 |
| 2016-02-01 | FXXP | Futures | 270.0 | 270.3 | 265.0 | 267.7 | 22076.0 |
| 2016-02-01 | G | Futures | 107.28 | 107.31 | 106.56 | 106.6 | 200103.0 |
| 2016-02-01 | GF | Futures | 308.47 | 312.152 | 304.052 | 309.796 | 4978.0 |
| 2016-02-01 | GSCI | Futures | 460.29 | 461.77 | 457.32 | 457.86 | 73.0 |
> showing 50 of 109 rows — these rows as CSV