PREVIEW / futures_daily / 2019-11-26
file: by_date/futures_daily/2019/2019-11-26.parquet size: 10 KB rows: 118
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-26 | ES | Futures | 3389.79 | 3404.67 | 3386.27 | 3403.32 | 1068011.0 |
| 2019-11-26 | NQ | Futures | 9650.66 | 9705.69 | 9641.44 | 9681.2 | 285726.0 |
| 2019-11-26 | YM | Futures | 29420.4 | 29550.6 | 29393.1 | 29530.6 | 118715.0 |
| 2019-11-26 | CL | Futures | 59.14 | 59.8 | 58.98 | 59.64 | 443816.0 |
| 2019-11-26 | GC | Futures | 1797.8 | 1808.5 | 1792.0 | 1805.3 | 285632.0 |
| 2019-11-26 | ZN | Futures | 128.38126 | 128.598042 | 128.195447 | 128.52062 | 2602268.0 |
| 2019-11-26 | A6 | Futures | 0.69578 | 0.69763 | 0.69465 | 0.69691 | 78459.0 |
| 2019-11-26 | AD | Futures | 0.75753 | 0.7592 | 0.75648 | 0.75879 | 56453.0 |
| 2019-11-26 | ALI | Futures | 2155.74 | 2166.67 | 2155.74 | 2166.67 | 137.0 |
| 2019-11-26 | B | Futures | 50.55 | 51.02 | 50.34 | 50.98 | 290590.0 |
| 2019-11-26 | B6 | Futures | 1.3122 | 1.3128 | 1.3056 | 1.3093 | 90614.0 |
| 2019-11-26 | BR | Futures | 0.19182 | 0.19182 | 0.18979 | 0.19007 | 2923.0 |
| 2019-11-26 | BTC | Futures | 10863.3 | 11081.5 | 10592.5 | 10720.4 | 721.0 |
| 2019-11-26 | BZ | Futures | 49.81 | 50.33 | 49.66 | 50.3 | 24888.0 |
| 2019-11-26 | C | Futures | 1804.0 | 1817.0 | 1797.0 | 1810.0 | 3461.0 |
| 2019-11-26 | CB | Futures | 249.723 | 249.723 | 249.693 | 249.693 | 11.0 |
| 2019-11-26 | CC | Futures | 1703.0 | 1750.0 | 1701.0 | 1737.0 | 19860.0 |
| 2019-11-26 | CNH | Futures | 7.018 | 7.0318 | 6.9999 | 7.0027 | 1123.0 |
| 2019-11-26 | CSC | Futures | 3.387 | 3.431 | 3.387 | 3.43 | 48.0 |
| 2019-11-26 | CT | Futures | 62.49 | 62.91 | 62.23 | 62.73 | 17057.0 |
| 2019-11-26 | DC | Futures | 27.99 | 28.8 | 27.99 | 28.67 | 206.0 |
| 2019-11-26 | DX | Futures | 94.961 | 95.019 | 94.86 | 94.884 | 7744.0 |
| 2019-11-26 | E1 | Futures | 1.15553 | 1.15611 | 1.15335 | 1.15519 | 24896.0 |
| 2019-11-26 | E6 | Futures | 1.19513 | 1.19643 | 1.19442 | 1.19599 | 110868.0 |
| 2019-11-26 | E7 | Futures | 1.189 | 1.1902 | 1.188 | 1.1898 | 2138.0 |
| 2019-11-26 | EBM | Futures | 198.37 | 199.2 | 197.55 | 199.2 | 15955.0 |
| 2019-11-26 | ED | Futures | 95.3132 | 95.3277 | 95.3107 | 95.3277 | 167856.0 |
| 2019-11-26 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 19102.0 |
| 2019-11-26 | EW | Futures | 2111.2 | 2123.2 | 2106.6 | 2119.6 | 11400.0 |
| 2019-11-26 | FBON | Futures | 143.16 | 143.52 | 143.15 | 143.49 | 114.0 |
| 2019-11-26 | FBTP | Futures | 129.36 | 129.64 | 129.05 | 129.17 | 103643.0 |
| 2019-11-26 | FBTS | Futures | 108.25 | 108.259 | 108.163 | 108.201 | 55765.0 |
| 2019-11-26 | FCE | Futures | 5362.0 | 5372.0 | 5343.0 | 5361.1 | 42385.0 |
| 2019-11-26 | FDAX | Futures | 13994.5 | 14049.4 | 13915.9 | 13971.3 | 71435.0 |
| 2019-11-26 | FDIV | Futures | 161.22 | 161.45 | 161.22 | 161.4 | 21.0 |
| 2019-11-26 | FDXM | Futures | 13808.7 | 13864.9 | 13733.7 | 13788.9 | 30023.0 |
| 2019-11-26 | FESX | Futures | 3250.9 | 3261.4 | 3236.0 | 3248.3 | 648458.0 |
| 2019-11-26 | FGBL | Futures | 165.23 | 165.66 | 165.07 | 165.62 | 497717.0 |
| 2019-11-26 | FGBM | Futures | 133.9 | 134.0 | 133.84 | 133.99 | 281035.0 |
| 2019-11-26 | FGBS | Futures | 112.684 | 112.699 | 112.679 | 112.689 | 240997.0 |
| 2019-11-26 | FGBX | Futures | 214.76 | 216.65 | 214.3 | 216.44 | 39592.0 |
| 2019-11-26 | FMWO | Futures | 7634.9 | 7653.1 | 7623.5 | 7645.2 | 3119.0 |
| 2019-11-26 | FOAT | Futures | 152.64 | 152.96 | 152.48 | 152.93 | 103872.0 |
| 2019-11-26 | FTDX | Futures | 3006.7 | 3025.5 | 2999.8 | 3024.5 | 98.0 |
| 2019-11-26 | FTI | Futures | 571.96 | 572.96 | 569.04 | 572.03 | 17908.0 |
| 2019-11-26 | FTUK | Futures | 6856.1 | 6881.6 | 6838.9 | 6862.6 | 83750.0 |
| 2019-11-26 | FVSA | Futures | 132.78 | 133.29 | 129.74 | 131.77 | 19643.0 |
| 2019-11-26 | FXXP | Futures | 369.4 | 369.7 | 367.9 | 369.4 | 41097.0 |
| 2019-11-26 | G | Futures | 121.14 | 121.85 | 121.05 | 121.81 | 391936.0 |
| 2019-11-26 | GF | Futures | 299.331 | 299.963 | 296.488 | 298.331 | 3768.0 |
> showing 50 of 118 rows — these rows as CSV