PREVIEW / futures_daily / 2019-05-28
file: by_date/futures_daily/2019/2019-05-28.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-05-28 | ES | Futures | 3057.98 | 3069.05 | 3025.03 | 3029.89 | 1633540.0 |
| 2019-05-28 | NQ | Futures | 8428.95 | 8493.77 | 8388.34 | 8405.62 | 528983.0 |
| 2019-05-28 | YM | Futures | 27031.8 | 27145.8 | 26737.3 | 26778.4 | 262852.0 |
| 2019-05-28 | CL | Futures | 60.49 | 61.14 | 59.66 | 60.7 | 1020323.0 |
| 2019-05-28 | GC | Futures | 1604.6 | 1608.8 | 1594.1 | 1596.2 | 211067.0 |
| 2019-05-28 | ZN | Futures | 124.331381 | 124.766486 | 124.222605 | 124.704328 | 4279844.0 |
| 2019-05-28 | A6 | Futures | 0.71477 | 0.7157 | 0.71312 | 0.71395 | 109999.0 |
| 2019-05-28 | AD | Futures | 0.75256 | 0.75317 | 0.74923 | 0.74988 | 77990.0 |
| 2019-05-28 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-28 | B | Futures | 51.2 | 51.53 | 50.76 | 51.11 | 233556.0 |
| 2019-05-28 | B6 | Futures | 1.3043 | 1.3071 | 1.297 | 1.2976 | 113482.0 |
| 2019-05-28 | BR | Futures | 0.19732 | 0.19732 | 0.19732 | 0.19732 | 1192.0 |
| 2019-05-28 | BTC | Futures | 13307.4 | 13929.7 | 13215.2 | 13484.1 | 2145.0 |
| 2019-05-28 | BZ | Futures | 49.61 | 50.87 | 49.43 | 50.46 | 44836.0 |
| 2019-05-28 | C | Futures | 1736.0 | 1748.0 | 1725.0 | 1733.0 | 6315.0 |
| 2019-05-28 | CB | Futures | 286.085 | 286.494 | 285.56 | 286.202 | 12.0 |
| 2019-05-28 | CC | Futures | 1658.0 | 1668.0 | 1643.0 | 1649.0 | 21054.0 |
| 2019-05-28 | CNH | Futures | 6.9225 | 6.9415 | 6.9106 | 6.9324 | 1827.0 |
| 2019-05-28 | CSC | Futures | 2.966 | 2.971 | 2.959 | 2.959 | 119.0 |
| 2019-05-28 | CT | Futures | 71.66 | 72.75 | 71.66 | 72.72 | 17323.0 |
| 2019-05-28 | DC | Futures | 24.98 | 25.05 | 24.83 | 24.88 | 214.0 |
| 2019-05-28 | DX | Futures | 93.556 | 93.805 | 93.523 | 93.783 | 13138.0 |
| 2019-05-28 | E1 | Futures | 1.16738 | 1.16749 | 1.15769 | 1.15967 | 29303.0 |
| 2019-05-28 | E6 | Futures | 1.23228 | 1.233 | 1.22669 | 1.2274 | 206639.0 |
| 2019-05-28 | E7 | Futures | 1.2262 | 1.2269 | 1.2206 | 1.2214 | 4318.0 |
| 2019-05-28 | EBM | Futures | 212.75 | 213.32 | 210.73 | 212.75 | 42018.0 |
| 2019-05-28 | ED | Futures | 95.1868 | 95.1917 | 95.1819 | 95.1868 | 225828.0 |
| 2019-05-28 | ER | Futures | 98.416 | 98.426 | 98.416 | 98.426 | 35929.0 |
| 2019-05-28 | EW | Futures | 1981.2 | 1986.7 | 1955.6 | 1956.7 | 15729.0 |
| 2019-05-28 | FBON | Futures | 138.44 | 138.9 | 138.41 | 138.81 | 740.0 |
| 2019-05-28 | FBTP | Futures | 114.91 | 115.18 | 114.55 | 114.96 | 153974.0 |
| 2019-05-28 | FBTS | Futures | 105.636 | 105.684 | 105.427 | 105.627 | 114531.0 |
| 2019-05-28 | FCE | Futures | 4825.7 | 4831.2 | 4764.0 | 4789.8 | 91380.0 |
| 2019-05-28 | FDAX | Futures | 12701.1 | 12754.8 | 12594.8 | 12656.9 | 124356.0 |
| 2019-05-28 | FDIV | Futures | 143.59 | 143.59 | 143.17 | 143.45 | 190.0 |
| 2019-05-28 | FDXM | Futures | 12586.9 | 12643.2 | 12485.7 | 12547.2 | 49528.0 |
| 2019-05-28 | FESX | Futures | 2934.8 | 2940.9 | 2900.7 | 2917.3 | 922131.0 |
| 2019-05-28 | FGBL | Futures | 161.71 | 162.08 | 161.68 | 161.95 | 945496.0 |
| 2019-05-28 | FGBM | Futures | 133.69 | 133.82 | 133.68 | 133.78 | 499116.0 |
| 2019-05-28 | FGBS | Futures | 112.885 | 112.915 | 112.88 | 112.895 | 344403.0 |
| 2019-05-28 | FGBX | Futures | 198.95 | 199.97 | 198.86 | 199.6 | 42732.0 |
| 2019-05-28 | FMWO | Futures | 7063.4 | 7076.1 | 6992.8 | 7040.2 | 1789.0 |
| 2019-05-28 | FOAT | Futures | 148.1 | 148.34 | 148.06 | 148.24 | 117292.0 |
| 2019-05-28 | FTDX | Futures | 2826.1 | 2834.0 | 2817.7 | 2833.5 | 102.0 |
| 2019-05-28 | FTI | Futures | 518.81 | 519.8 | 514.89 | 517.63 | 28994.0 |
| 2019-05-28 | FTUK | Futures | 6691.2 | 6697.7 | 6626.6 | 6660.5 | 103226.0 |
| 2019-05-28 | FVSA | Futures | 225.25 | 234.52 | 224.54 | 228.1 | 28424.0 |
| 2019-05-28 | FXXP | Futures | 337.6 | 337.7 | 333.7 | 335.3 | 62190.0 |
| 2019-05-28 | G | Futures | 118.95 | 119.02 | 118.74 | 118.88 | 475148.0 |
| 2019-05-28 | GF | Futures | 282.88 | 282.978 | 277.728 | 279.102 | 7316.0 |
> showing 50 of 119 rows — these rows as CSV