PREVIEW / futures_daily / 2019-06-13
file: by_date/futures_daily/2019/2019-06-13.parquet size: 10 KB rows: 114
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-06-13 | ES | Futures | 3113.06 | 3128.73 | 3097.13 | 3126.57 | 1437516.0 |
| 2019-06-13 | NQ | Futures | 8613.88 | 8683.01 | 8550.51 | 8667.75 | 396174.0 |
| 2019-06-13 | YM | Futures | 27333.2 | 27464.5 | 27192.5 | 27427.7 | 18937.0 |
| 2019-06-13 | CL | Futures | 52.49 | 54.9 | 52.35 | 53.75 | 277803.0 |
| 2019-06-13 | GC | Futures | 1665.1 | 1676.5 | 1662.7 | 1672.4 | 204827.0 |
| 2019-06-13 | ZN | Futures | 126.444965 | 126.84934 | 126.398306 | 126.771575 | 1333587.0 |
| 2019-06-13 | A6 | Futures | 0.71479 | 0.71561 | 0.7118 | 0.71345 | 65824.0 |
| 2019-06-13 | AD | Futures | 0.75723 | 0.75929 | 0.75707 | 0.75778 | 60082.0 |
| 2019-06-13 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-13 | B | Futures | 44.62 | 46.63 | 44.5 | 45.64 | 435419.0 |
| 2019-06-13 | B6 | Futures | 1.3008 | 1.3024 | 1.2978 | 1.2999 | 105547.0 |
| 2019-06-13 | BR | Futures | 0.20647 | 0.20647 | 0.20583 | 0.20583 | 29.0 |
| 2019-06-13 | BTC | Futures | 12569.8 | 12800.3 | 12400.8 | 12731.2 | 2079.0 |
| 2019-06-13 | BZ | Futures | 43.96 | 46.03 | 43.92 | 45.05 | 72728.0 |
| 2019-06-13 | C | Futures | 1798.0 | 1802.0 | 1769.0 | 1782.0 | 3426.0 |
| 2019-06-13 | CB | Futures | 287.661 | 287.661 | 287.136 | 287.427 | 54.0 |
| 2019-06-13 | CC | Futures | 1678.0 | 1690.0 | 1666.0 | 1672.0 | 27631.0 |
| 2019-06-13 | CNH | Futures | 6.9499 | 6.9509 | 6.944 | 6.9456 | 641.0 |
| 2019-06-13 | CSC | Futures | 3.023 | 3.047 | 3.023 | 3.045 | 30.0 |
| 2019-06-13 | CT | Futures | 69.68 | 70.68 | 69.13 | 69.96 | 19727.0 |
| 2019-06-13 | DC | Futures | 25.41 | 25.67 | 25.41 | 25.64 | 176.0 |
| 2019-06-13 | DX | Futures | 92.872 | 92.978 | 92.762 | 92.92 | 28939.0 |
| 2019-06-13 | E1 | Futures | 1.1749 | 1.17907 | 1.17408 | 1.1771 | 29584.0 |
| 2019-06-13 | E6 | Futures | 1.24093 | 1.24213 | 1.23842 | 1.23945 | 189280.0 |
| 2019-06-13 | E7 | Futures | 1.2347 | 1.2357 | 1.232 | 1.233 | 2337.0 |
| 2019-06-13 | EBM | Futures | 205.26 | 207.85 | 203.82 | 205.84 | 19093.0 |
| 2019-06-13 | ED | Futures | 95.3038 | 95.3817 | 95.2941 | 95.3671 | 414985.0 |
| 2019-06-13 | ER | Futures | 98.435 | 98.44 | 98.43 | 98.435 | 61854.0 |
| 2019-06-13 | EW | Futures | 2003.5 | 2016.8 | 2000.1 | 2012.6 | 12449.0 |
| 2019-06-13 | FBON | Futures | 141.01 | 141.27 | 140.96 | 141.15 | 197.0 |
| 2019-06-13 | FBTP | Futures | 117.43 | 118.08 | 117.25 | 117.95 | 103071.0 |
| 2019-06-13 | FBTS | Futures | 106.133 | 106.296 | 106.066 | 106.239 | 59733.0 |
| 2019-06-13 | FCE | Futures | 4890.1 | 4915.7 | 4883.7 | 4900.6 | 1678.0 |
| 2019-06-13 | FDAX | Futures | 12743.8 | 12845.9 | 12696.4 | 12804.3 | 99583.0 |
| 2019-06-13 | FDXM | Futures | 12572.7 | 12667.4 | 12546.7 | 12634.6 | 372.0 |
| 2019-06-13 | FESX | Futures | 2945.3 | 2959.3 | 2932.2 | 2948.8 | 330215.0 |
| 2019-06-13 | FGBL | Futures | 163.03 | 163.25 | 162.97 | 163.11 | 507649.0 |
| 2019-06-13 | FGBM | Futures | 134.05 | 134.1 | 134.0 | 134.04 | 313853.0 |
| 2019-06-13 | FGBS | Futures | 112.925 | 112.94 | 112.92 | 112.93 | 210995.0 |
| 2019-06-13 | FGBX | Futures | 204.77 | 205.71 | 204.66 | 205.36 | 37254.0 |
| 2019-06-13 | FMWO | Futures | 7161.7 | 7197.6 | 7161.7 | 7180.2 | 9273.0 |
| 2019-06-13 | FOAT | Futures | 149.87 | 150.1 | 149.79 | 149.89 | 115291.0 |
| 2019-06-13 | FTDX | Futures | 2791.5 | 2817.2 | 2791.5 | 2802.4 | 34.0 |
| 2019-06-13 | FTI | Futures | 521.3 | 523.52 | 521.26 | 522.31 | 3510.0 |
| 2019-06-13 | FTUK | Futures | 6735.4 | 6764.9 | 6712.8 | 6735.8 | 27199.0 |
| 2019-06-13 | FVSA | Futures | 214.58 | 216.66 | 210.43 | 211.12 | 19538.0 |
| 2019-06-13 | FXXP | Futures | 337.5 | 339.7 | 337.5 | 338.7 | 16392.0 |
| 2019-06-13 | G | Futures | 119.68 | 119.99 | 119.64 | 119.86 | 164316.0 |
| 2019-06-13 | GF | Futures | 268.947 | 269.633 | 264.286 | 267.328 | 6183.0 |
| 2019-06-13 | GSCI | Futures | 462.56 | 462.56 | 459.78 | 459.78 | 2486.0 |
> showing 50 of 114 rows — these rows as CSV