PREVIEW / futures_daily / 2020-01-24
file: by_date/futures_daily/2020/2020-01-24.parquet size: 10 KB rows: 118
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-01-24 | ES | Futures | 3592.67 | 3604.01 | 3542.99 | 3557.03 | 2515168.0 |
| 2020-01-24 | NQ | Futures | 10612.22 | 10652.65 | 10448.77 | 10488.92 | 758796.0 |
| 2020-01-24 | YM | Futures | 30591.4 | 30709.0 | 30241.7 | 30385.6 | 301305.0 |
| 2020-01-24 | CL | Futures | 57.11 | 57.38 | 55.23 | 55.57 | 586195.0 |
| 2020-01-24 | GC | Futures | 1922.8 | 1938.3 | 1914.1 | 1933.9 | 427139.0 |
| 2020-01-24 | ZN | Futures | 128.66009 | 129.217597 | 128.443282 | 129.124679 | 2201734.0 |
| 2020-01-24 | A6 | Futures | 0.70204 | 0.70358 | 0.69948 | 0.70009 | 85442.0 |
| 2020-01-24 | AD | Futures | 0.76771 | 0.76831 | 0.7661 | 0.7668 | 68434.0 |
| 2020-01-24 | ALI | Futures | 2169.42 | 2169.42 | 2163.72 | 2163.72 | 35.0 |
| 2020-01-24 | B | Futures | 50.72 | 51.12 | 49.3 | 49.64 | 223340.0 |
| 2020-01-24 | B6 | Futures | 1.3327 | 1.3384 | 1.326 | 1.3284 | 111557.0 |
| 2020-01-24 | BR | Futures | 0.19421 | 0.19449 | 0.19344 | 0.19352 | 1822.0 |
| 2020-01-24 | BTC | Futures | 12687.8 | 12882.9 | 12515.2 | 12822.9 | 575.0 |
| 2020-01-24 | BZ | Futures | 50.01 | 50.35 | 48.55 | 48.91 | 30730.0 |
| 2020-01-24 | C | Futures | 1871.0 | 1884.0 | 1848.0 | 1850.0 | 7871.0 |
| 2020-01-24 | CB | Futures | 236.399 | 237.844 | 236.399 | 236.989 | 41.0 |
| 2020-01-24 | CC | Futures | 1821.0 | 1826.0 | 1785.0 | 1788.0 | 19016.0 |
| 2020-01-24 | CNH | Futures | 6.8997 | 6.9081 | 6.8946 | 6.9044 | 103.0 |
| 2020-01-24 | CSC | Futures | 3.536 | 3.573 | 3.513 | 3.532 | 162.0 |
| 2020-01-24 | CT | Futures | 66.56 | 66.82 | 65.96 | 66.01 | 16514.0 |
| 2020-01-24 | DC | Futures | 29.38 | 29.95 | 29.37 | 29.51 | 758.0 |
| 2020-01-24 | DX | Futures | 94.623 | 94.866 | 94.584 | 94.778 | 16245.0 |
| 2020-01-24 | E1 | Futures | 1.18232 | 1.18267 | 1.17947 | 1.18073 | 18828.0 |
| 2020-01-24 | E6 | Futures | 1.19462 | 1.19591 | 1.19052 | 1.19187 | 155251.0 |
| 2020-01-24 | E7 | Futures | 1.1885 | 1.1892 | 1.1844 | 1.1857 | 2187.0 |
| 2020-01-24 | EBM | Futures | 215.12 | 215.94 | 214.29 | 214.84 | 16972.0 |
| 2020-01-24 | ED | Futures | 95.3277 | 95.3423 | 95.3229 | 95.3423 | 244345.0 |
| 2020-01-24 | ER | Futures | 98.367 | 98.377 | 98.367 | 98.372 | 48477.0 |
| 2020-01-24 | ESG | Futures | 293.94 | 297.25 | 293.94 | 297.25 | 508.0 |
| 2020-01-24 | EW | Futures | 2198.2 | 2206.1 | 2162.3 | 2174.4 | 18434.0 |
| 2020-01-24 | FBON | Futures | 144.15 | 144.45 | 143.83 | 144.36 | 435.0 |
| 2020-01-24 | FBTP | Futures | 129.43 | 129.78 | 129.0 | 129.57 | 99190.0 |
| 2020-01-24 | FBTS | Futures | 108.249 | 108.288 | 108.143 | 108.24 | 64173.0 |
| 2020-01-24 | FCE | Futures | 5443.9 | 5495.6 | 5421.7 | 5458.5 | 93402.0 |
| 2020-01-24 | FDAX | Futures | 14263.9 | 14385.5 | 14248.0 | 14344.8 | 111118.0 |
| 2020-01-24 | FDIV | Futures | 159.73 | 159.92 | 159.31 | 159.31 | 135.0 |
| 2020-01-24 | FDXM | Futures | 14071.2 | 14204.9 | 14069.2 | 14164.7 | 55615.0 |
| 2020-01-24 | FESX | Futures | 3305.7 | 3335.6 | 3298.6 | 3318.0 | 1224265.0 |
| 2020-01-24 | FGBL | Futures | 165.07 | 165.76 | 164.86 | 165.51 | 812643.0 |
| 2020-01-24 | FGBM | Futures | 133.84 | 134.02 | 133.77 | 133.95 | 383331.0 |
| 2020-01-24 | FGBS | Futures | 112.629 | 112.679 | 112.629 | 112.664 | 285069.0 |
| 2020-01-24 | FGBX | Futures | 213.51 | 215.54 | 212.71 | 214.76 | 56929.0 |
| 2020-01-24 | FMWO | Futures | 8043.6 | 8059.5 | 7960.8 | 8006.2 | 1665.0 |
| 2020-01-24 | FOAT | Futures | 152.8 | 153.26 | 152.6 | 153.12 | 119615.0 |
| 2020-01-24 | FTDX | Futures | 3205.6 | 3253.9 | 3205.6 | 3238.3 | 119.0 |
| 2020-01-24 | FTI | Futures | 582.55 | 588.83 | 582.17 | 587.18 | 38117.0 |
| 2020-01-24 | FTUK | Futures | 7037.2 | 7110.4 | 7011.9 | 7061.1 | 113236.0 |
| 2020-01-24 | FVSA | Futures | 115.22 | 122.87 | 111.81 | 116.92 | 36506.0 |
| 2020-01-24 | FXXP | Futures | 384.2 | 386.6 | 382.6 | 384.8 | 60149.0 |
| 2020-01-24 | G | Futures | 122.1 | 122.7 | 121.81 | 122.54 | 261131.0 |
> showing 50 of 118 rows — these rows as CSV