PREVIEW / futures_daily / 2018-02-16
file: by_date/futures_daily/2018/2018-02-16.parquet size: 8 KB rows: 82
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-16 | ES | Futures | 2971.53 | 2994.08 | 2958.76 | 2972.61 | 1738551.0 |
| 2018-02-16 | NQ | Futures | 7983.05 | 8034.0 | 7919.52 | 7948.5 | 445962.0 |
| 2018-02-16 | YM | Futures | 26607.7 | 26812.3 | 26484.3 | 26614.1 | 260426.0 |
| 2018-02-16 | CL | Futures | 61.71 | 62.31 | 61.19 | 61.99 | 524971.0 |
| 2018-02-16 | GC | Futures | 1732.8 | 1742.8 | 1721.0 | 1732.3 | 230899.0 |
| 2018-02-16 | ZN | Futures | 118.78196 | 119.244747 | 118.766534 | 119.044206 | 1325756.0 |
| 2018-02-16 | B | Futures | 46.4 | 46.8 | 46.06 | 46.53 | 239577.0 |
| 2018-02-16 | B6 | Futures | 1.4672 | 1.4727 | 1.4572 | 1.4599 | 98757.0 |
| 2018-02-16 | BTC | Futures | 13129.4 | 13357.2 | 12589.4 | 13038.4 | 1101.0 |
| 2018-02-16 | C | Futures | 1351.0 | 1364.0 | 1339.0 | 1357.0 | 6596.0 |
| 2018-02-16 | CB | Futures | 273.278 | 276.429 | 269.201 | 269.356 | 61.0 |
| 2018-02-16 | CC | Futures | 1570.0 | 1583.0 | 1548.0 | 1566.0 | 23436.0 |
| 2018-02-16 | CNH | Futures | 6.4092 | 6.4357 | 6.4092 | 6.4278 | 13.0 |
| 2018-02-16 | CSC | Futures | 3.28 | 3.312 | 3.244 | 3.291 | 73.0 |
| 2018-02-16 | CT | Futures | 87.99 | 88.61 | 87.75 | 88.44 | 8011.0 |
| 2018-02-16 | DX | Futures | 83.11 | 83.721 | 82.782 | 83.592 | 26169.0 |
| 2018-02-16 | E7 | Futures | 1.4133 | 1.4191 | 1.4005 | 1.4032 | 5180.0 |
| 2018-02-16 | EBM | Futures | 172.62 | 172.89 | 171.81 | 172.08 | 15844.0 |
| 2018-02-16 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 74936.0 |
| 2018-02-16 | EW | Futures | 2012.6 | 2025.5 | 2004.5 | 2016.0 | 13861.0 |
| 2018-02-16 | FBON | Futures | 126.08 | 126.58 | 126.08 | 126.49 | 209.0 |
| 2018-02-16 | FBTP | Futures | 110.89 | 111.74 | 110.84 | 111.63 | 68876.0 |
| 2018-02-16 | FBTS | Futures | 103.595 | 103.686 | 103.595 | 103.668 | 29136.0 |
| 2018-02-16 | FCE | Futures | 4619.2 | 4677.9 | 4614.3 | 4662.4 | 88221.0 |
| 2018-02-16 | FDAX | Futures | 12841.8 | 12999.0 | 12819.0 | 12914.0 | 99485.0 |
| 2018-02-16 | FDXM | Futures | 12865.7 | 13020.6 | 12841.8 | 12935.9 | 33805.0 |
| 2018-02-16 | FESX | Futures | 2776.7 | 2809.4 | 2771.8 | 2798.8 | 1250134.0 |
| 2018-02-16 | FEU3 | Futures | 99.011 | 99.011 | 99.006 | 99.006 | 502.0 |
| 2018-02-16 | FGBL | Futures | 146.21 | 147.16 | 146.11 | 147.0 | 575895.0 |
| 2018-02-16 | FGBM | Futures | 128.25 | 128.54 | 128.22 | 128.48 | 390166.0 |
| 2018-02-16 | FGBS | Futures | 112.266 | 112.311 | 112.261 | 112.291 | 183823.0 |
| 2018-02-16 | FGBX | Futures | 162.82 | 164.81 | 162.69 | 164.44 | 48915.0 |
| 2018-02-16 | FMWO | Futures | 7081.1 | 7096.2 | 7040.2 | 7074.1 | 1770.0 |
| 2018-02-16 | FOAT | Futures | 135.55 | 136.33 | 135.49 | 136.18 | 91341.0 |
| 2018-02-16 | FTDX | Futures | 2545.4 | 2575.3 | 2537.9 | 2565.8 | 322.0 |
| 2018-02-16 | FTI | Futures | 486.52 | 490.47 | 486.11 | 488.59 | 28104.0 |
| 2018-02-16 | FTUK | Futures | 6314.3 | 6351.8 | 6305.1 | 6341.8 | 114695.0 |
| 2018-02-16 | FVSA | Futures | 432.12 | 443.2 | 409.96 | 421.04 | 26347.0 |
| 2018-02-16 | FXXP | Futures | 321.1 | 324.8 | 321.1 | 323.8 | 46929.0 |
| 2018-02-16 | G | Futures | 111.21 | 112.0 | 111.19 | 111.85 | 173924.0 |
| 2018-02-16 | HG | Futures | 3.885 | 3.9148 | 3.8731 | 3.8886 | 48484.0 |
| 2018-02-16 | HRC | Futures | 1676.7 | 1676.7 | 1676.7 | 1676.7 | 0.0 |
| 2018-02-16 | J7 | Futures | 0.011473 | 0.011537 | 0.011445 | 0.011455 | 743.0 |
| 2018-02-16 | JB | Futures | 138.09 | 138.23 | 138.05 | 138.18 | 1163.0 |
| 2018-02-16 | KC | Futures | 152.12 | 152.62 | 146.87 | 147.25 | 19895.0 |
| 2018-02-16 | KE | Futures | 923.0 | 928.29 | 910.49 | 921.07 | 0.0 |
| 2018-02-16 | KRW | Futures | 0.0009081 | 0.0009111 | 0.0009064 | 0.0009064 | 16.0 |
| 2018-02-16 | L | Futures | 99.33 | 99.335 | 99.325 | 99.335 | 66794.0 |
| 2018-02-16 | MFC | Futures | 4672.7 | 4712.4 | 4672.7 | 4703.0 | 76.0 |
| 2018-02-16 | MFS | Futures | 2126.2 | 2132.8 | 2115.0 | 2123.0 | 19385.0 |
> showing 50 of 82 rows — these rows as CSV