PREVIEW / futures_daily / 2019-02-27
file: by_date/futures_daily/2019/2019-02-27.parquet size: 10 KB rows: 116
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-02-27 | ES | Futures | 3018.48 | 3028.5 | 3004.41 | 3026.06 | 1138855.0 |
| 2019-02-27 | NQ | Futures | 8230.76 | 8256.81 | 8159.85 | 8245.23 | 367938.0 |
| 2019-02-27 | YM | Futures | 27433.5 | 27483.1 | 27289.0 | 27432.5 | 174322.0 |
| 2019-02-27 | CL | Futures | 57.84 | 59.32 | 57.6 | 58.86 | 577227.0 |
| 2019-02-27 | GC | Futures | 1663.7 | 1665.0 | 1648.0 | 1651.5 | 198038.0 |
| 2019-02-27 | ZN | Futures | 121.798271 | 121.876078 | 121.378116 | 121.4248 | 1627040.0 |
| 2019-02-27 | A6 | Futures | 0.74115 | 0.74198 | 0.73456 | 0.7359 | 98098.0 |
| 2019-02-27 | AD | Futures | 0.76896 | 0.77215 | 0.76871 | 0.77022 | 57343.0 |
| 2019-02-27 | B | Futures | 47.81 | 48.51 | 47.45 | 48.29 | 241211.0 |
| 2019-02-27 | B6 | Futures | 1.3627 | 1.3722 | 1.3601 | 1.3679 | 139003.0 |
| 2019-02-27 | BR | Futures | 0.21249 | 0.21353 | 0.21249 | 0.21353 | 254.0 |
| 2019-02-27 | BTC | Futures | 5811.1 | 5865.0 | 5565.2 | 5703.5 | 4843.0 |
| 2019-02-27 | BZ | Futures | 47.25 | 48.12 | 47.07 | 47.91 | 27754.0 |
| 2019-02-27 | C | Futures | 1518.0 | 1531.0 | 1512.0 | 1529.0 | 14891.0 |
| 2019-02-27 | CB | Futures | 276.031 | 276.929 | 276.031 | 276.57 | 54.0 |
| 2019-02-27 | CC | Futures | 1539.0 | 1564.0 | 1529.0 | 1561.0 | 14829.0 |
| 2019-02-27 | CNH | Futures | 6.698 | 6.7053 | 6.6881 | 6.6953 | 501.0 |
| 2019-02-27 | CSC | Futures | 2.835 | 2.835 | 2.813 | 2.817 | 55.0 |
| 2019-02-27 | CT | Futures | 76.44 | 77.24 | 76.33 | 76.82 | 11347.0 |
| 2019-02-27 | DC | Futures | 24.2 | 24.28 | 24.03 | 24.05 | 151.0 |
| 2019-02-27 | DX | Futures | 91.474 | 91.622 | 91.321 | 91.591 | 14213.0 |
| 2019-02-27 | E1 | Futures | 1.17772 | 1.1823 | 1.17595 | 1.17642 | 27235.0 |
| 2019-02-27 | E6 | Futures | 1.26083 | 1.26199 | 1.2574 | 1.25829 | 141669.0 |
| 2019-02-27 | E7 | Futures | 1.2547 | 1.2558 | 1.2513 | 1.2521 | 3270.0 |
| 2019-02-27 | EBM | Futures | 198.43 | 200.49 | 196.63 | 199.46 | 13263.0 |
| 2019-02-27 | ED | Futures | 95.1062 | 95.1087 | 95.1013 | 95.1038 | 223711.0 |
| 2019-02-27 | ER | Futures | 98.411 | 98.411 | 98.406 | 98.411 | 19383.0 |
| 2019-02-27 | EW | Futures | 2036.4 | 2047.3 | 2031.9 | 2043.2 | 13578.0 |
| 2019-02-27 | FBON | Futures | 133.01 | 133.06 | 132.66 | 132.67 | 693.0 |
| 2019-02-27 | FBTP | Futures | 112.78 | 112.82 | 111.82 | 111.89 | 168655.0 |
| 2019-02-27 | FBTS | Futures | 105.493 | 105.54 | 105.2 | 105.228 | 58382.0 |
| 2019-02-27 | FCE | Futures | 4660.7 | 4670.9 | 4647.3 | 4659.8 | 62275.0 |
| 2019-02-27 | FDAX | Futures | 12103.7 | 12132.6 | 12018.6 | 12067.5 | 92813.0 |
| 2019-02-27 | FDIV | Futures | 141.95 | 141.95 | 141.73 | 141.95 | 5.0 |
| 2019-02-27 | FDXM | Futures | 12080.5 | 12104.7 | 11988.3 | 12038.1 | 46809.0 |
| 2019-02-27 | FESX | Futures | 2803.0 | 2809.0 | 2792.7 | 2802.1 | 729951.0 |
| 2019-02-27 | FEU3 | Futures | 99.011 | 99.011 | 99.011 | 99.011 | 25.0 |
| 2019-02-27 | FGBL | Futures | 158.17 | 158.29 | 157.41 | 157.53 | 1038699.0 |
| 2019-02-27 | FGBM | Futures | 132.46 | 132.48 | 132.19 | 132.22 | 566824.0 |
| 2019-02-27 | FGBS | Futures | 112.638 | 112.658 | 112.623 | 112.628 | 517940.0 |
| 2019-02-27 | FGBX | Futures | 189.28 | 189.48 | 187.23 | 187.63 | 66824.0 |
| 2019-02-27 | FMWO | Futures | 7034.2 | 7034.2 | 6998.1 | 7014.4 | 4019.0 |
| 2019-02-27 | FOAT | Futures | 143.76 | 143.85 | 143.2 | 143.32 | 210850.0 |
| 2019-02-27 | FTDX | Futures | 2594.0 | 2594.0 | 2568.7 | 2575.6 | 102.0 |
| 2019-02-27 | FTI | Futures | 508.33 | 509.08 | 504.81 | 507.26 | 23710.0 |
| 2019-02-27 | FTUK | Futures | 6473.9 | 6492.1 | 6425.2 | 6449.3 | 114610.0 |
| 2019-02-27 | FVSA | Futures | 265.64 | 272.63 | 265.64 | 270.01 | 27332.0 |
| 2019-02-27 | FXXP | Futures | 326.3 | 327.2 | 325.5 | 326.4 | 35794.0 |
| 2019-02-27 | G | Futures | 117.04 | 117.06 | 116.14 | 116.19 | 291672.0 |
| 2019-02-27 | GF | Futures | 313.486 | 314.908 | 313.486 | 314.634 | 3354.0 |
> showing 50 of 116 rows — these rows as CSV