PREVIEW / futures_daily / 2018-04-13
file: by_date/futures_daily/2018/2018-04-13.parquet size: 10 KB rows: 111
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-04-13 | ES | Futures | 2894.57 | 2914.96 | 2876.08 | 2889.67 | 1711823.0 |
| 2018-04-13 | NQ | Futures | 7805.33 | 7857.12 | 7732.18 | 7772.56 | 465366.0 |
| 2018-04-13 | YM | Futures | 25758.8 | 25942.1 | 25498.6 | 25635.6 | 276551.0 |
| 2018-04-13 | CL | Futures | 67.36 | 67.88 | 66.83 | 67.58 | 290829.0 |
| 2018-04-13 | GC | Futures | 1707.7 | 1723.9 | 1705.0 | 1720.8 | 265398.0 |
| 2018-04-13 | ZN | Futures | 119.571168 | 119.726254 | 119.447099 | 119.586677 | 1121633.0 |
| 2018-04-13 | A6 | Futures | 0.79802 | 0.80316 | 0.7973 | 0.79812 | 90766.0 |
| 2018-04-13 | AD | Futures | 0.80488 | 0.80701 | 0.80291 | 0.80321 | 61251.0 |
| 2018-04-13 | B | Futures | 52.29 | 52.97 | 52.02 | 52.76 | 328504.0 |
| 2018-04-13 | B6 | Futures | 1.4778 | 1.4846 | 1.4767 | 1.4784 | 94974.0 |
| 2018-04-13 | BR | Futures | 0.22292 | 0.22292 | 0.22163 | 0.2217 | 3252.0 |
| 2018-04-13 | BTC | Futures | 11063.0 | 11695.0 | 11020.4 | 11510.4 | 3045.0 |
| 2018-04-13 | BZ | Futures | 51.78 | 52.27 | 51.38 | 52.07 | 36895.0 |
| 2018-04-13 | C | Futures | 1613.0 | 1629.0 | 1605.0 | 1620.0 | 6947.0 |
| 2018-04-13 | CB | Futures | 289.895 | 291.563 | 289.895 | 290.791 | 8.0 |
| 2018-04-13 | CC | Futures | 1874.0 | 1890.0 | 1861.0 | 1878.0 | 20227.0 |
| 2018-04-13 | CNH | Futures | 6.3735 | 6.377 | 6.3735 | 6.3755 | 10.0 |
| 2018-04-13 | CSC | Futures | 3.375 | 3.383 | 3.354 | 3.383 | 45.0 |
| 2018-04-13 | CT | Futures | 96.36 | 97.07 | 95.47 | 95.88 | 26393.0 |
| 2018-04-13 | DC | Futures | 26.9 | 27.08 | 26.82 | 27.03 | 69.0 |
| 2018-04-13 | DX | Futures | 84.373 | 84.495 | 84.288 | 84.413 | 12803.0 |
| 2018-04-13 | E1 | Futures | 1.25741 | 1.26127 | 1.25597 | 1.25826 | 16495.0 |
| 2018-04-13 | E6 | Futures | 1.39488 | 1.3973 | 1.39285 | 1.39567 | 141211.0 |
| 2018-04-13 | E7 | Futures | 1.3876 | 1.3899 | 1.3855 | 1.3882 | 2069.0 |
| 2018-04-13 | EBM | Futures | 177.47 | 177.74 | 176.66 | 176.93 | 17998.0 |
| 2018-04-13 | ED | Futures | 94.9452 | 94.95 | 94.9306 | 94.9306 | 274242.0 |
| 2018-04-13 | ER | Futures | 98.342 | 98.342 | 98.337 | 98.342 | 22431.0 |
| 2018-04-13 | EW | Futures | 2001.0 | 2011.6 | 1988.9 | 1996.2 | 11383.0 |
| 2018-04-13 | FBON | Futures | 129.81 | 129.93 | 129.64 | 129.93 | 311.0 |
| 2018-04-13 | FBTP | Futures | 115.45 | 115.61 | 115.23 | 115.59 | 58516.0 |
| 2018-04-13 | FBTS | Futures | 104.167 | 104.204 | 104.158 | 104.186 | 18736.0 |
| 2018-04-13 | FCE | Futures | 4676.4 | 4699.2 | 4662.6 | 4678.2 | 7475.0 |
| 2018-04-13 | FDAX | Futures | 12910.7 | 13023.9 | 12887.3 | 12940.3 | 88534.0 |
| 2018-04-13 | FDXM | Futures | 12799.8 | 12908.0 | 12772.0 | 12825.1 | 28498.0 |
| 2018-04-13 | FESX | Futures | 2801.4 | 2823.1 | 2796.4 | 2806.4 | 850421.0 |
| 2018-04-13 | FEU3 | Futures | 99.021 | 99.021 | 99.021 | 99.021 | 14.0 |
| 2018-04-13 | FGBL | Futures | 149.9 | 149.97 | 149.58 | 149.95 | 600233.0 |
| 2018-04-13 | FGBM | Futures | 129.68 | 129.72 | 129.54 | 129.69 | 374244.0 |
| 2018-04-13 | FGBS | Futures | 112.512 | 112.532 | 112.487 | 112.512 | 182530.0 |
| 2018-04-13 | FGBX | Futures | 170.45 | 170.68 | 169.77 | 170.6 | 45111.0 |
| 2018-04-13 | FMWO | Futures | 6956.1 | 6974.8 | 6911.8 | 6939.8 | 2998.0 |
| 2018-04-13 | FOAT | Futures | 138.96 | 139.1 | 138.69 | 139.07 | 111986.0 |
| 2018-04-13 | FTDX | Futures | 2582.5 | 2595.9 | 2580.6 | 2587.0 | 279.0 |
| 2018-04-13 | FTI | Futures | 499.13 | 500.79 | 498.8 | 499.96 | 394.0 |
| 2018-04-13 | FTUK | Futures | 6353.2 | 6369.2 | 6338.7 | 6362.1 | 70776.0 |
| 2018-04-13 | FVSA | Futures | 383.45 | 386.9 | 368.53 | 375.42 | 14244.0 |
| 2018-04-13 | FXXP | Futures | 322.0 | 324.1 | 321.7 | 323.0 | 34344.0 |
| 2018-04-13 | G | Futures | 113.45 | 113.67 | 113.2 | 113.6 | 167631.0 |
| 2018-04-13 | GF | Futures | 302.733 | 304.239 | 300.043 | 302.087 | 7140.0 |
| 2018-04-13 | GSCI | Futures | 525.9 | 528.21 | 525.9 | 527.08 | 130.0 |
> showing 50 of 111 rows — these rows as CSV