PREVIEW / futures_daily / 2019-11-25
file: by_date/futures_daily/2019/2019-11-25.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2019-11-25 | ES | Futures | 3376.53 | 3392.22 | 3373.82 | 3391.41 | 947831.0 |
| 2019-11-25 | NQ | Futures | 9568.84 | 9656.42 | 9561.06 | 9653.25 | 259485.0 |
| 2019-11-25 | YM | Futures | 29317.5 | 29441.4 | 29293.4 | 29435.1 | 96942.0 |
| 2019-11-25 | CL | Futures | 59.14 | 59.38 | 58.42 | 59.23 | 420642.0 |
| 2019-11-25 | GC | Futures | 1805.4 | 1807.1 | 1797.1 | 1800.9 | 126740.0 |
| 2019-11-25 | ZN | Futures | 128.272869 | 128.427713 | 128.087056 | 128.350291 | 2878708.0 |
| 2019-11-25 | A6 | Futures | 0.69691 | 0.69804 | 0.69476 | 0.69558 | 60501.0 |
| 2019-11-25 | AD | Futures | 0.75763 | 0.75829 | 0.75632 | 0.75693 | 45681.0 |
| 2019-11-25 | ALI | Futures | 2147.23 | 2151.79 | 2144.8 | 2144.8 | 97.0 |
| 2019-11-25 | B | Futures | 50.56 | 50.61 | 49.93 | 50.5 | 228754.0 |
| 2019-11-25 | B6 | Futures | 1.3072 | 1.3137 | 1.3065 | 1.3129 | 91567.0 |
| 2019-11-25 | BR | Futures | 0.19295 | 0.19295 | 0.19149 | 0.19182 | 2036.0 |
| 2019-11-25 | BTC | Futures | 10585.0 | 11119.1 | 9825.1 | 10818.2 | 1227.0 |
| 2019-11-25 | BZ | Futures | 49.87 | 49.93 | 49.26 | 49.83 | 20540.0 |
| 2019-11-25 | C | Futures | 1801.0 | 1805.0 | 1795.0 | 1804.0 | 3917.0 |
| 2019-11-25 | CC | Futures | 1716.0 | 1718.0 | 1697.0 | 1699.0 | 16998.0 |
| 2019-11-25 | CNH | Futures | 7.0238 | 7.0267 | 7.0185 | 7.0212 | 460.0 |
| 2019-11-25 | CSC | Futures | 3.377 | 3.407 | 3.377 | 3.379 | 43.0 |
| 2019-11-25 | CT | Futures | 61.73 | 62.68 | 61.59 | 62.59 | 16023.0 |
| 2019-11-25 | DC | Futures | 28.19 | 28.27 | 28.15 | 28.25 | 100.0 |
| 2019-11-25 | DX | Futures | 94.903 | 95.005 | 94.797 | 94.95 | 8188.0 |
| 2019-11-25 | E1 | Futures | 1.15438 | 1.15657 | 1.15335 | 1.1553 | 25125.0 |
| 2019-11-25 | E6 | Futures | 1.1961 | 1.19735 | 1.19415 | 1.1948 | 136427.0 |
| 2019-11-25 | E7 | Futures | 1.1898 | 1.191 | 1.188 | 1.1887 | 2502.0 |
| 2019-11-25 | EBM | Futures | 197.01 | 198.65 | 197.01 | 198.65 | 12337.0 |
| 2019-11-25 | ED | Futures | 95.3132 | 95.3205 | 95.3059 | 95.3107 | 221876.0 |
| 2019-11-25 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 24246.0 |
| 2019-11-25 | ESG | Futures | 278.46 | 278.88 | 278.46 | 278.88 | 10.0 |
| 2019-11-25 | EW | Futures | 2093.3 | 2114.3 | 2092.1 | 2111.2 | 12486.0 |
| 2019-11-25 | FBON | Futures | 143.13 | 143.35 | 142.84 | 143.21 | 395.0 |
| 2019-11-25 | FBTP | Futures | 129.28 | 129.46 | 128.91 | 129.38 | 77222.0 |
| 2019-11-25 | FBTS | Futures | 108.201 | 108.25 | 108.095 | 108.24 | 46171.0 |
| 2019-11-25 | FCE | Futures | 5358.8 | 5365.2 | 5341.2 | 5356.6 | 35245.0 |
| 2019-11-25 | FDAX | Futures | 13943.4 | 14001.4 | 13934.4 | 13976.6 | 66580.0 |
| 2019-11-25 | FDIV | Futures | 161.91 | 161.91 | 161.73 | 161.73 | 40.0 |
| 2019-11-25 | FDXM | Futures | 13759.7 | 13818.1 | 13752.4 | 13794.1 | 25054.0 |
| 2019-11-25 | FESX | Futures | 3242.1 | 3250.9 | 3239.5 | 3249.2 | 533969.0 |
| 2019-11-25 | FGBL | Futures | 165.33 | 165.42 | 165.13 | 165.28 | 474354.0 |
| 2019-11-25 | FGBM | Futures | 133.89 | 133.93 | 133.82 | 133.89 | 226378.0 |
| 2019-11-25 | FGBS | Futures | 112.694 | 112.699 | 112.679 | 112.684 | 190010.0 |
| 2019-11-25 | FGBX | Futures | 215.98 | 216.21 | 214.78 | 215.42 | 33393.0 |
| 2019-11-25 | FMWO | Futures | 7595.1 | 7638.3 | 7595.1 | 7630.4 | 1462.0 |
| 2019-11-25 | FOAT | Futures | 152.71 | 152.75 | 152.44 | 152.63 | 71200.0 |
| 2019-11-25 | FTDX | Futures | 2984.5 | 3005.8 | 2982.1 | 3003.8 | 88.0 |
| 2019-11-25 | FTI | Futures | 569.61 | 572.39 | 569.13 | 571.13 | 14816.0 |
| 2019-11-25 | FTUK | Futures | 6806.5 | 6856.6 | 6802.3 | 6851.9 | 74211.0 |
| 2019-11-25 | FVSA | Futures | 136.33 | 136.33 | 131.26 | 132.27 | 23742.0 |
| 2019-11-25 | FXXP | Futures | 367.3 | 369.3 | 366.9 | 369.1 | 28672.0 |
| 2019-11-25 | G | Futures | 120.97 | 121.25 | 120.8 | 121.09 | 535084.0 |
| 2019-11-25 | GF | Futures | 294.645 | 301.859 | 294.118 | 299.068 | 8935.0 |
> showing 50 of 119 rows — these rows as CSV