PREVIEW / futures_daily / 2019-10-30
file: by_date/futures_daily/2019/2019-10-30.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-10-30 | ES | Futures | 3287.22 | 3307.24 | 3272.87 | 3299.39 | 1179153.0 |
| 2019-10-30 | NQ | Futures | 9285.34 | 9381.86 | 9242.99 | 9347.57 | 381307.0 |
| 2019-10-30 | YM | Futures | 28400.0 | 28585.8 | 28281.4 | 28482.9 | 146042.0 |
| 2019-10-30 | CL | Futures | 56.73 | 56.94 | 55.6 | 56.25 | 659328.0 |
| 2019-10-30 | GC | Futures | 1838.6 | 1849.5 | 1829.5 | 1846.3 | 353638.0 |
| 2019-10-30 | ZN | Futures | 128.071572 | 128.551589 | 127.947697 | 128.319323 | 1410254.0 |
| 2019-10-30 | A6 | Futures | 0.70502 | 0.70984 | 0.70358 | 0.70656 | 117889.0 |
| 2019-10-30 | AD | Futures | 0.76987 | 0.77068 | 0.76277 | 0.76443 | 146800.0 |
| 2019-10-30 | ALI | Futures | 2131.45 | 2142.98 | 2131.45 | 2142.98 | 2.0 |
| 2019-10-30 | B | Futures | 48.84 | 49.09 | 47.87 | 48.05 | 336903.0 |
| 2019-10-30 | B6 | Futures | 1.3097 | 1.3143 | 1.3079 | 1.3125 | 88061.0 |
| 2019-10-30 | BR | Futures | 0.2016 | 0.20261 | 0.2001 | 0.20168 | 5210.0 |
| 2019-10-30 | BTC | Futures | 13776.4 | 13812.5 | 13083.2 | 13386.5 | 3553.0 |
| 2019-10-30 | BZ | Futures | 48.11 | 48.42 | 47.22 | 47.39 | 38267.0 |
| 2019-10-30 | C | Futures | 1688.0 | 1690.0 | 1669.0 | 1670.0 | 11310.0 |
| 2019-10-30 | CB | Futures | 246.153 | 246.803 | 245.622 | 245.917 | 25.0 |
| 2019-10-30 | CC | Futures | 1628.0 | 1645.0 | 1605.0 | 1610.0 | 22328.0 |
| 2019-10-30 | CNH | Futures | 7.0591 | 7.0614 | 7.0373 | 7.0473 | 405.0 |
| 2019-10-30 | CSC | Futures | 3.406 | 3.503 | 3.405 | 3.503 | 80.0 |
| 2019-10-30 | CT | Futures | 62.93 | 64.23 | 62.92 | 63.95 | 22714.0 |
| 2019-10-30 | DC | Futures | 28.44 | 29.25 | 28.31 | 29.24 | 876.0 |
| 2019-10-30 | DX | Futures | 94.198 | 94.526 | 93.975 | 94.177 | 16507.0 |
| 2019-10-30 | E1 | Futures | 1.16117 | 1.16749 | 1.16059 | 1.16531 | 32077.0 |
| 2019-10-30 | E6 | Futures | 1.20797 | 1.21231 | 1.20456 | 1.20954 | 204065.0 |
| 2019-10-30 | E7 | Futures | 1.2019 | 1.2061 | 1.1984 | 1.2033 | 3052.0 |
| 2019-10-30 | EBM | Futures | 196.46 | 196.73 | 195.64 | 195.91 | 22706.0 |
| 2019-10-30 | ED | Futures | 95.3277 | 95.3618 | 95.318 | 95.3326 | 421612.0 |
| 2019-10-30 | ER | Futures | 98.401 | 98.411 | 98.396 | 98.401 | 57132.0 |
| 2019-10-30 | EW | Futures | 2075.3 | 2075.5 | 2056.6 | 2068.9 | 12899.0 |
| 2019-10-30 | FBON | Futures | 144.44 | 144.72 | 144.43 | 144.56 | 120.0 |
| 2019-10-30 | FBTP | Futures | 130.87 | 130.97 | 130.61 | 130.74 | 79647.0 |
| 2019-10-30 | FBTS | Futures | 108.317 | 108.327 | 108.269 | 108.288 | 22870.0 |
| 2019-10-30 | FCE | Futures | 5215.0 | 5241.7 | 5184.6 | 5230.9 | 79340.0 |
| 2019-10-30 | FDAX | Futures | 13644.2 | 13659.0 | 13528.2 | 13616.3 | 86176.0 |
| 2019-10-30 | FDIV | Futures | 158.9 | 158.9 | 157.46 | 157.78 | 107.0 |
| 2019-10-30 | FDXM | Futures | 13453.6 | 13481.7 | 13351.5 | 13438.5 | 31709.0 |
| 2019-10-30 | FESX | Futures | 3170.2 | 3176.4 | 3142.2 | 3165.8 | 754276.0 |
| 2019-10-30 | FGBL | Futures | 165.24 | 165.54 | 164.99 | 165.25 | 522873.0 |
| 2019-10-30 | FGBM | Futures | 133.93 | 134.04 | 133.81 | 133.92 | 364506.0 |
| 2019-10-30 | FGBS | Futures | 112.714 | 112.739 | 112.684 | 112.709 | 218644.0 |
| 2019-10-30 | FGBX | Futures | 215.13 | 216.05 | 214.49 | 215.19 | 66665.0 |
| 2019-10-30 | FMWO | Futures | 7431.3 | 7465.5 | 7410.9 | 7433.6 | 1141.0 |
| 2019-10-30 | FOAT | Futures | 152.8 | 153.0 | 152.57 | 152.78 | 144038.0 |
| 2019-10-30 | FTDX | Futures | 2773.8 | 2775.8 | 2754.0 | 2770.8 | 63.0 |
| 2019-10-30 | FTI | Futures | 552.51 | 554.75 | 549.5 | 553.07 | 22918.0 |
| 2019-10-30 | FTUK | Futures | 6741.2 | 6783.3 | 6721.7 | 6774.5 | 73479.0 |
| 2019-10-30 | FVSA | Futures | 159.81 | 161.93 | 152.91 | 158.75 | 21984.0 |
| 2019-10-30 | FXXP | Futures | 359.4 | 361.0 | 357.5 | 359.8 | 44949.0 |
| 2019-10-30 | G | Futures | 120.77 | 121.2 | 120.65 | 121.14 | 153409.0 |
| 2019-10-30 | GF | Futures | 304.512 | 310.008 | 304.303 | 309.589 | 2022.0 |
> showing 50 of 119 rows — these rows as CSV