PREVIEW / futures_daily / 2020-06-29
file: by_date/futures_daily/2020/2020-06-29.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 |
|---|---|---|---|---|---|---|---|
| 2020-06-29 | ES | Futures | 3361.28 | 3434.45 | 3358.19 | 3430.51 | 1585146.0 |
| 2020-06-29 | NQ | Futures | 11357.44 | 11602.91 | 11291.57 | 11575.93 | 479544.0 |
| 2020-06-29 | YM | Futures | 26553.3 | 27374.2 | 26516.9 | 27324.9 | 225691.0 |
| 2020-06-29 | CL | Futures | 27.52 | 28.92 | 27.19 | 28.78 | 343913.0 |
| 2020-06-29 | GC | Futures | 2148.1 | 2149.6 | 2132.9 | 2138.5 | 130505.0 |
| 2020-06-29 | ZN | Futures | 137.985735 | 138.171553 | 137.830886 | 138.078644 | 876658.0 |
| 2020-06-29 | A6 | Futures | 0.70485 | 0.70907 | 0.70393 | 0.70588 | 71276.0 |
| 2020-06-29 | AD | Futures | 0.7418 | 0.74398 | 0.74073 | 0.7417 | 56683.0 |
| 2020-06-29 | ALI | Futures | 1964.65 | 1964.65 | 1964.65 | 1964.65 | 0.0 |
| 2020-06-29 | B | Futures | 26.39 | 27.36 | 26.07 | 27.27 | 273441.0 |
| 2020-06-29 | B6 | Futures | 1.2533 | 1.2585 | 1.2445 | 1.2479 | 79427.0 |
| 2020-06-29 | BR | Futures | 0.14421 | 0.14579 | 0.14421 | 0.14536 | 60.0 |
| 2020-06-29 | BTC | Futures | 12636.6 | 12726.1 | 12464.4 | 12671.0 | 2742.0 |
| 2020-06-29 | BZ | Futures | 25.78 | 26.76 | 25.48 | 26.66 | 27988.0 |
| 2020-06-29 | C | Futures | 1712.0 | 1713.0 | 1673.0 | 1675.0 | 4217.0 |
| 2020-06-29 | CB | Futures | 202.743 | 203.84 | 202.743 | 202.743 | 5.0 |
| 2020-06-29 | CC | Futures | 1495.0 | 1495.0 | 1458.0 | 1468.0 | 16846.0 |
| 2020-06-29 | CNH | Futures | 7.009 | 7.009 | 6.989 | 6.9977 | 169.0 |
| 2020-06-29 | CSC | Futures | 3.64 | 3.648 | 3.585 | 3.617 | 52.0 |
| 2020-06-29 | CT | Futures | 60.93 | 60.95 | 59.93 | 60.81 | 24.0 |
| 2020-06-29 | DC | Futures | 30.14 | 30.15 | 29.3 | 29.85 | 215.0 |
| 2020-06-29 | DX | Futures | 94.154 | 94.285 | 93.778 | 94.179 | 13588.0 |
| 2020-06-29 | E1 | Futures | 1.20093 | 1.2057 | 1.19491 | 1.1965 | 21480.0 |
| 2020-06-29 | E6 | Futures | 1.20607 | 1.21331 | 1.2057 | 1.20757 | 153410.0 |
| 2020-06-29 | E7 | Futures | 1.2 | 1.2072 | 1.1998 | 1.2015 | 5764.0 |
| 2020-06-29 | EBM | Futures | 210.77 | 215.26 | 210.77 | 214.66 | 12501.0 |
| 2020-06-29 | ED | Futures | 96.404 | 96.4088 | 96.3992 | 96.4088 | 199365.0 |
| 2020-06-29 | ER | Futures | 98.377 | 98.386 | 98.372 | 98.382 | 54802.0 |
| 2020-06-29 | ESG | Futures | 271.51 | 275.68 | 271.51 | 275.68 | 71.0 |
| 2020-06-29 | EW | Futures | 1814.3 | 1872.2 | 1809.6 | 1867.5 | 14730.0 |
| 2020-06-29 | FBON | Futures | 144.91 | 145.07 | 144.86 | 144.99 | 110.0 |
| 2020-06-29 | FBTP | Futures | 129.71 | 129.83 | 129.44 | 129.65 | 49212.0 |
| 2020-06-29 | FBTS | Futures | 108.357 | 108.425 | 108.328 | 108.396 | 21660.0 |
| 2020-06-29 | FCE | Futures | 4741.9 | 4856.1 | 4738.0 | 4823.2 | 56258.0 |
| 2020-06-29 | FDAX | Futures | 12783.7 | 13051.9 | 12680.1 | 13010.5 | 111483.0 |
| 2020-06-29 | FDIV | Futures | 140.28 | 141.99 | 140.28 | 141.99 | 200.0 |
| 2020-06-29 | FDXM | Futures | 12735.4 | 13004.3 | 12634.9 | 12963.6 | 58402.0 |
| 2020-06-29 | FESX | Futures | 2929.0 | 2987.2 | 2909.6 | 2975.2 | 852887.0 |
| 2020-06-29 | FGBL | Futures | 168.88 | 168.98 | 168.49 | 168.79 | 350341.0 |
| 2020-06-29 | FGBM | Futures | 135.01 | 135.03 | 134.86 | 134.95 | 239023.0 |
| 2020-06-29 | FGBS | Futures | 112.82 | 112.83 | 112.795 | 112.815 | 147498.0 |
| 2020-06-29 | FGBX | Futures | 228.15 | 228.35 | 226.58 | 227.59 | 33707.0 |
| 2020-06-29 | FMWO | Futures | 7540.8 | 7639.1 | 7531.3 | 7624.9 | 2944.0 |
| 2020-06-29 | FOAT | Futures | 155.59 | 155.68 | 155.36 | 155.67 | 82785.0 |
| 2020-06-29 | FTDX | Futures | 2972.9 | 2972.9 | 2930.5 | 2959.1 | 47.0 |
| 2020-06-29 | FTI | Futures | 515.04 | 521.67 | 514.25 | 518.84 | 24691.0 |
| 2020-06-29 | FTUK | Futures | 5763.4 | 5872.6 | 5734.6 | 5862.2 | 89793.0 |
| 2020-06-29 | FVSA | Futures | 299.14 | 304.07 | 285.69 | 288.82 | 10059.0 |
| 2020-06-29 | FXXP | Futures | 326.7 | 331.9 | 326.1 | 331.1 | 49606.0 |
| 2020-06-29 | G | Futures | 127.01 | 127.43 | 126.95 | 127.39 | 124694.0 |
> showing 50 of 119 rows — these rows as CSV