PREVIEW / futures_daily / 2020-09-25
file: by_date/futures_daily/2020/2020-09-25.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 |
|---|---|---|---|---|---|---|---|
| 2020-09-25 | ES | Futures | 3644.01 | 3703.27 | 3602.44 | 3693.16 | 1697090.0 |
| 2020-09-25 | NQ | Futures | 12635.53 | 12927.27 | 12519.18 | 12892.83 | 600725.0 |
| 2020-09-25 | YM | Futures | 28822.2 | 29200.1 | 28447.5 | 29113.9 | 213697.0 |
| 2020-09-25 | CL | Futures | 28.83 | 29.18 | 28.51 | 28.9 | 229025.0 |
| 2020-09-25 | GC | Futures | 2211.7 | 2219.5 | 2189.7 | 2204.1 | 230857.0 |
| 2020-09-25 | ZN | Futures | 138.40418 | 138.574647 | 138.326694 | 138.497162 | 774189.0 |
| 2020-09-25 | A6 | Futures | 0.72342 | 0.72763 | 0.71942 | 0.72126 | 101256.0 |
| 2020-09-25 | AD | Futures | 0.75867 | 0.75989 | 0.75543 | 0.75664 | 62071.0 |
| 2020-09-25 | ALI | Futures | 2105.3 | 2120.15 | 2105.3 | 2111.53 | 153.0 |
| 2020-09-25 | B | Futures | 26.73 | 27.01 | 26.5 | 26.76 | 192143.0 |
| 2020-09-25 | B6 | Futures | 1.293 | 1.299 | 1.2868 | 1.2913 | 102125.0 |
| 2020-09-25 | BR | Futures | 0.14124 | 0.14156 | 0.14124 | 0.14136 | 53.0 |
| 2020-09-25 | BTC | Futures | 14417.3 | 14639.0 | 14249.3 | 14544.9 | 6120.0 |
| 2020-09-25 | BZ | Futures | 26.15 | 26.49 | 25.99 | 26.24 | 17829.0 |
| 2020-09-25 | C | Futures | 1681.0 | 1694.0 | 1644.0 | 1659.0 | 4901.0 |
| 2020-09-25 | CB | Futures | 168.009 | 168.009 | 164.655 | 164.681 | 38.0 |
| 2020-09-25 | CC | Futures | 1719.0 | 1723.0 | 1673.0 | 1686.0 | 13443.0 |
| 2020-09-25 | CNH | Futures | 6.7209 | 6.7381 | 6.7052 | 6.7248 | 655.0 |
| 2020-09-25 | CSC | Futures | 3.351 | 3.405 | 3.351 | 3.405 | 54.0 |
| 2020-09-25 | CT | Futures | 64.57 | 65.4 | 64.39 | 65.18 | 12924.0 |
| 2020-09-25 | DC | Futures | 27.47 | 28.14 | 27.36 | 27.95 | 152.0 |
| 2020-09-25 | DX | Futures | 91.134 | 91.569 | 91.018 | 91.459 | 18880.0 |
| 2020-09-25 | E1 | Futures | 1.22473 | 1.22665 | 1.22076 | 1.22178 | 20828.0 |
| 2020-09-25 | E6 | Futures | 1.25197 | 1.25374 | 1.24586 | 1.24704 | 174269.0 |
| 2020-09-25 | E7 | Futures | 1.246 | 1.2473 | 1.2396 | 1.2407 | 6460.0 |
| 2020-09-25 | EBM | Futures | 231.46 | 232.67 | 231.46 | 231.76 | 15428.0 |
| 2020-09-25 | ED | Futures | 96.4648 | 96.4793 | 96.4648 | 96.4697 | 129373.0 |
| 2020-09-25 | ER | Futures | 98.431 | 98.44 | 98.431 | 98.435 | 49686.0 |
| 2020-09-25 | ESG | Futures | 300.58 | 306.46 | 299.5 | 305.7 | 54.0 |
| 2020-09-25 | EW | Futures | 1914.3 | 1941.1 | 1885.4 | 1936.7 | 11974.0 |
| 2020-09-25 | FBON | Futures | 147.71 | 148.14 | 147.71 | 148.01 | 462.0 |
| 2020-09-25 | FBTP | Futures | 135.09 | 135.38 | 134.97 | 135.04 | 111174.0 |
| 2020-09-25 | FBTS | Futures | 109.315 | 109.354 | 109.286 | 109.305 | 40068.0 |
| 2020-09-25 | FCE | Futures | 4634.7 | 4635.2 | 4522.2 | 4583.8 | 78989.0 |
| 2020-09-25 | FDAX | Futures | 13477.5 | 13532.4 | 13131.0 | 13243.4 | 98784.0 |
| 2020-09-25 | FDIV | Futures | 142.75 | 143.03 | 142.75 | 143.03 | 100.0 |
| 2020-09-25 | FDXM | Futures | 13413.7 | 13464.7 | 13065.8 | 13176.7 | 51720.0 |
| 2020-09-25 | FESX | Futures | 2920.5 | 2934.4 | 2853.0 | 2883.5 | 1096121.0 |
| 2020-09-25 | FGBL | Futures | 169.48 | 169.9 | 169.37 | 169.87 | 472607.0 |
| 2020-09-25 | FGBM | Futures | 135.04 | 135.17 | 135.0 | 135.16 | 271508.0 |
| 2020-09-25 | FGBS | Futures | 112.749 | 112.785 | 112.744 | 112.775 | 241310.0 |
| 2020-09-25 | FGBX | Futures | 230.68 | 232.72 | 230.38 | 232.66 | 41883.0 |
| 2020-09-25 | FMWO | Futures | 8134.6 | 8199.8 | 8009.1 | 8112.1 | 1453.0 |
| 2020-09-25 | FOAT | Futures | 157.49 | 157.87 | 157.48 | 157.84 | 125657.0 |
| 2020-09-25 | FTDX | Futures | 3078.6 | 3096.1 | 3040.1 | 3090.5 | 35.0 |
| 2020-09-25 | FTI | Futures | 507.0 | 507.88 | 498.28 | 503.82 | 27176.0 |
| 2020-09-25 | FTUK | Futures | 5566.3 | 5593.1 | 5486.0 | 5546.3 | 84627.0 |
| 2020-09-25 | FVSA | Futures | 210.24 | 218.04 | 203.56 | 210.62 | 14610.0 |
| 2020-09-25 | FXXP | Futures | 329.5 | 331.1 | 324.2 | 327.7 | 58487.0 |
| 2020-09-25 | G | Futures | 126.95 | 127.27 | 126.86 | 127.24 | 148565.0 |
> showing 50 of 120 rows — these rows as CSV