PREVIEW / futures_daily / 2019-05-30
file: by_date/futures_daily/2019/2019-05-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-05-30 | ES | Futures | 3002.35 | 3023.41 | 2999.11 | 3014.23 | 1282029.0 |
| 2019-05-30 | NQ | Futures | 8312.87 | 8377.97 | 8305.67 | 8359.53 | 403475.0 |
| 2019-05-30 | YM | Futures | 26500.8 | 26619.0 | 26449.1 | 26589.5 | 202295.0 |
| 2019-05-30 | CL | Futures | 60.68 | 61.27 | 57.81 | 58.08 | 842281.0 |
| 2019-05-30 | GC | Futures | 1599.5 | 1610.4 | 1592.1 | 1608.6 | 284019.0 |
| 2019-05-30 | ZN | Futures | 124.688789 | 125.123894 | 124.517855 | 124.999579 | 1414607.0 |
| 2019-05-30 | A6 | Futures | 0.71333 | 0.71539 | 0.71158 | 0.71271 | 83902.0 |
| 2019-05-30 | AD | Futures | 0.74847 | 0.75003 | 0.74801 | 0.74867 | 64924.0 |
| 2019-05-30 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-30 | B | Futures | 50.62 | 50.87 | 48.35 | 48.63 | 407264.0 |
| 2019-05-30 | B6 | Futures | 1.2945 | 1.2958 | 1.2896 | 1.2926 | 81257.0 |
| 2019-05-30 | BTC | Futures | 13399.6 | 14106.5 | 12938.6 | 13338.1 | 3303.0 |
| 2019-05-30 | BZ | Futures | 49.9 | 50.23 | 47.73 | 48.01 | 60861.0 |
| 2019-05-30 | C | Futures | 1732.0 | 1750.0 | 1727.0 | 1744.0 | 5653.0 |
| 2019-05-30 | CB | Futures | 283.606 | 283.606 | 282.439 | 282.993 | 43.0 |
| 2019-05-30 | CC | Futures | 1645.0 | 1652.0 | 1619.0 | 1635.0 | 15262.0 |
| 2019-05-30 | CNH | Futures | 6.9402 | 6.9434 | 6.9322 | 6.9366 | 564.0 |
| 2019-05-30 | CSC | Futures | 2.978 | 3.003 | 2.976 | 3.0 | 87.0 |
| 2019-05-30 | CT | Futures | 72.03 | 72.75 | 71.37 | 72.58 | 12082.0 |
| 2019-05-30 | DC | Futures | 25.16 | 25.3 | 25.07 | 25.23 | 63.0 |
| 2019-05-30 | DX | Futures | 93.973 | 94.122 | 93.935 | 93.986 | 7341.0 |
| 2019-05-30 | E1 | Futures | 1.15967 | 1.16049 | 1.15734 | 1.16014 | 17014.0 |
| 2019-05-30 | E6 | Futures | 1.22367 | 1.2246 | 1.22158 | 1.22367 | 126119.0 |
| 2019-05-30 | E7 | Futures | 1.2176 | 1.2185 | 1.2156 | 1.2176 | 2276.0 |
| 2019-05-30 | EBM | Futures | 209.0 | 213.9 | 206.7 | 213.32 | 28546.0 |
| 2019-05-30 | ED | Futures | 95.1941 | 95.199 | 95.1892 | 95.1941 | 246687.0 |
| 2019-05-30 | ER | Futures | 98.426 | 98.43 | 98.426 | 98.43 | 21656.0 |
| 2019-05-30 | EW | Futures | 1942.4 | 1961.0 | 1930.7 | 1939.9 | 12719.0 |
| 2019-05-30 | FBON | Futures | 139.34 | 139.63 | 139.03 | 139.09 | 940.0 |
| 2019-05-30 | FBTP | Futures | 115.36 | 115.86 | 115.08 | 115.41 | 175639.0 |
| 2019-05-30 | FBTS | Futures | 105.665 | 105.808 | 105.56 | 105.693 | 79932.0 |
| 2019-05-30 | FCE | Futures | 4738.5 | 4756.7 | 4727.6 | 4745.8 | 75465.0 |
| 2019-05-30 | FDAX | Futures | 12484.3 | 12550.1 | 12472.7 | 12527.4 | 91452.0 |
| 2019-05-30 | FDIV | Futures | 142.52 | 142.52 | 142.33 | 142.33 | 9.0 |
| 2019-05-30 | FDXM | Futures | 12382.4 | 12441.8 | 12366.7 | 12418.9 | 30708.0 |
| 2019-05-30 | FESX | Futures | 2885.0 | 2901.6 | 2879.7 | 2895.5 | 619264.0 |
| 2019-05-30 | FGBL | Futures | 161.99 | 162.35 | 161.87 | 162.14 | 730627.0 |
| 2019-05-30 | FGBM | Futures | 133.78 | 133.9 | 133.71 | 133.83 | 503565.0 |
| 2019-05-30 | FGBS | Futures | 112.895 | 112.91 | 112.87 | 112.9 | 509655.0 |
| 2019-05-30 | FGBX | Futures | 200.17 | 201.01 | 199.64 | 200.36 | 45265.0 |
| 2019-05-30 | FMWO | Futures | 6948.8 | 6970.8 | 6946.5 | 6951.2 | 1499.0 |
| 2019-05-30 | FOAT | Futures | 148.47 | 148.59 | 148.29 | 148.45 | 137471.0 |
| 2019-05-30 | FTDX | Futures | 2754.0 | 2767.9 | 2748.1 | 2767.9 | 46.0 |
| 2019-05-30 | FTI | Futures | 511.35 | 515.55 | 511.12 | 514.15 | 24814.0 |
| 2019-05-30 | FTUK | Futures | 6587.6 | 6629.8 | 6576.1 | 6615.1 | 83335.0 |
| 2019-05-30 | FVSA | Futures | 238.8 | 238.8 | 230.96 | 235.23 | 17219.0 |
| 2019-05-30 | FXXP | Futures | 332.2 | 333.5 | 331.7 | 332.7 | 39564.0 |
| 2019-05-30 | G | Futures | 118.96 | 119.23 | 118.82 | 119.19 | 165133.0 |
| 2019-05-30 | GF | Futures | 280.132 | 281.506 | 271.252 | 271.252 | 7394.0 |
| 2019-05-30 | GSCI | Futures | 482.82 | 482.93 | 476.59 | 476.59 | 20.0 |
> showing 50 of 119 rows — these rows as CSV