PREVIEW / futures_daily / 2019-10-15
file: by_date/futures_daily/2019/2019-10-15.parquet size: 10 KB rows: 120
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-10-15 | ES | Futures | 3211.71 | 3251.22 | 3211.44 | 3245.27 | 1181207.0 |
| 2019-10-15 | NQ | Futures | 9060.62 | 9186.81 | 9057.74 | 9172.98 | 347657.0 |
| 2019-10-15 | YM | Futures | 28083.0 | 28427.3 | 28081.9 | 28346.5 | 153083.0 |
| 2019-10-15 | CL | Futures | 54.72 | 55.0 | 53.59 | 54.02 | 239809.0 |
| 2019-10-15 | GC | Futures | 1847.5 | 1854.0 | 1826.6 | 1830.0 | 317991.0 |
| 2019-10-15 | ZN | Futures | 129.109028 | 129.372263 | 128.536104 | 128.598042 | 1439696.0 |
| 2019-10-15 | A6 | Futures | 0.6965 | 0.69783 | 0.69322 | 0.69424 | 82449.0 |
| 2019-10-15 | AD | Futures | 0.76176 | 0.76368 | 0.76116 | 0.76322 | 67276.0 |
| 2019-10-15 | ALI | Futures | 2079.84 | 2105.34 | 2079.84 | 2103.52 | 105.0 |
| 2019-10-15 | B | Futures | 46.98 | 47.28 | 45.95 | 46.53 | 305682.0 |
| 2019-10-15 | B6 | Futures | 1.2867 | 1.3047 | 1.2832 | 1.3023 | 290106.0 |
| 2019-10-15 | BR | Futures | 0.1959 | 0.1959 | 0.19311 | 0.19376 | 49.0 |
| 2019-10-15 | BTC | Futures | 11995.1 | 12131.8 | 11628.4 | 11750.6 | 2752.0 |
| 2019-10-15 | BZ | Futures | 46.31 | 46.62 | 45.3 | 45.88 | 49695.0 |
| 2019-10-15 | C | Futures | 1683.0 | 1717.0 | 1671.0 | 1703.0 | 9997.0 |
| 2019-10-15 | CB | Futures | 247.983 | 248.928 | 247.983 | 248.928 | 37.0 |
| 2019-10-15 | CC | Futures | 1614.0 | 1666.0 | 1609.0 | 1655.0 | 20899.0 |
| 2019-10-15 | CNH | Futures | 7.0631 | 7.0836 | 7.057 | 7.0779 | 714.0 |
| 2019-10-15 | CSC | Futures | 3.231 | 3.24 | 3.207 | 3.231 | 79.0 |
| 2019-10-15 | CT | Futures | 60.5 | 61.99 | 60.08 | 61.84 | 22278.0 |
| 2019-10-15 | DC | Futures | 26.97 | 27.11 | 26.84 | 27.08 | 623.0 |
| 2019-10-15 | DX | Futures | 94.903 | 95.082 | 94.637 | 94.723 | 28438.0 |
| 2019-10-15 | E1 | Futures | 1.1591 | 1.16002 | 1.15611 | 1.15726 | 28089.0 |
| 2019-10-15 | E6 | Futures | 1.20017 | 1.20223 | 1.19626 | 1.20103 | 232135.0 |
| 2019-10-15 | E7 | Futures | 1.1938 | 1.1959 | 1.1901 | 1.1948 | 4664.0 |
| 2019-10-15 | EBM | Futures | 197.01 | 197.55 | 194.54 | 195.09 | 30077.0 |
| 2019-10-15 | ED | Futures | 95.3423 | 95.3666 | 95.318 | 95.3277 | 316822.0 |
| 2019-10-15 | ER | Futures | 98.426 | 98.435 | 98.411 | 98.421 | 126551.0 |
| 2019-10-15 | EW | Futures | 2004.8 | 2027.9 | 2004.8 | 2021.2 | 10146.0 |
| 2019-10-15 | FBON | Futures | 145.69 | 145.69 | 145.07 | 145.13 | 449.0 |
| 2019-10-15 | FBTP | Futures | 131.69 | 131.93 | 131.19 | 131.33 | 77463.0 |
| 2019-10-15 | FBTS | Futures | 108.462 | 108.539 | 108.394 | 108.452 | 41099.0 |
| 2019-10-15 | FCE | Futures | 5129.6 | 5194.1 | 5129.6 | 5172.3 | 166432.0 |
| 2019-10-15 | FDAX | Futures | 13167.3 | 13374.1 | 13160.4 | 13330.8 | 111338.0 |
| 2019-10-15 | FDIV | Futures | 151.24 | 152.82 | 151.15 | 152.73 | 190.0 |
| 2019-10-15 | FDXM | Futures | 12990.2 | 13198.4 | 12990.2 | 13156.8 | 47329.0 |
| 2019-10-15 | FESX | Futures | 3109.7 | 3157.9 | 3108.8 | 3150.1 | 1209728.0 |
| 2019-10-15 | FGBL | Futures | 166.7 | 166.95 | 165.8 | 166.05 | 742153.0 |
| 2019-10-15 | FGBM | Futures | 134.59 | 134.61 | 134.29 | 134.38 | 387787.0 |
| 2019-10-15 | FGBS | Futures | 112.875 | 112.875 | 112.82 | 112.84 | 280191.0 |
| 2019-10-15 | FGBX | Futures | 219.8 | 220.57 | 216.56 | 217.19 | 50123.0 |
| 2019-10-15 | FMWO | Futures | 7277.8 | 7344.9 | 7273.2 | 7336.9 | 1580.0 |
| 2019-10-15 | FOAT | Futures | 153.92 | 154.14 | 153.33 | 153.44 | 136822.0 |
| 2019-10-15 | FTDX | Futures | 2771.8 | 2775.8 | 2719.5 | 2766.9 | 176.0 |
| 2019-10-15 | FTI | Futures | 548.64 | 552.7 | 548.12 | 551.59 | 40147.0 |
| 2019-10-15 | FTUK | Futures | 6683.7 | 6690.7 | 6627.2 | 6670.7 | 119918.0 |
| 2019-10-15 | FVSA | Futures | 170.43 | 170.43 | 162.47 | 164.06 | 43492.0 |
| 2019-10-15 | FXXP | Futures | 352.5 | 356.3 | 352.2 | 355.6 | 54699.0 |
| 2019-10-15 | G | Futures | 121.44 | 121.84 | 120.64 | 120.84 | 289850.0 |
| 2019-10-15 | GF | Futures | 306.501 | 307.339 | 304.041 | 305.821 | 4057.0 |
> showing 50 of 120 rows — these rows as CSV