PREVIEW / futures_daily / 2021-09-07
file: by_date/futures_daily/2021/2021-09-07.parquet size: 10 KB rows: 125
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-07 | ES | Futures | 5095.43 | 5112.29 | 5070.42 | 5079.97 | 1277938.0 |
| 2021-09-07 | NQ | Futures | 18062.12 | 18122.98 | 18005.3 | 18083.76 | 542055.0 |
| 2021-09-07 | YM | Futures | 38332.9 | 38467.3 | 37992.4 | 38049.9 | 198672.0 |
| 2021-09-07 | CL | Futures | 50.62 | 50.89 | 49.54 | 50.06 | 481704.0 |
| 2021-09-07 | GC | Futures | 2139.1 | 2139.1 | 2092.6 | 2098.2 | 252475.0 |
| 2021-09-07 | ZN | Futures | 135.591252 | 135.591252 | 135.148454 | 135.243339 | 17570.0 |
| 2021-09-07 | A6 | Futures | 0.76428 | 0.76593 | 0.75634 | 0.75777 | 161272.0 |
| 2021-09-07 | AD | Futures | 0.80921 | 0.80977 | 0.80105 | 0.80191 | 109488.0 |
| 2021-09-07 | ALI | Futures | 3175.15 | 3194.53 | 3167.45 | 3176.29 | 1144.0 |
| 2021-09-07 | B | Futures | 48.67 | 49.02 | 47.87 | 48.27 | 257397.0 |
| 2021-09-07 | B6 | Futures | 1.4072 | 1.4082 | 1.398 | 1.3999 | 129402.0 |
| 2021-09-07 | BFX | Futures | 4379.6 | 4385.7 | 4379.6 | 4385.7 | 1.0 |
| 2021-09-07 | BR | Futures | 0.15498 | 0.1562 | 0.1536 | 0.15429 | 55.0 |
| 2021-09-07 | BTC | Futures | 68914.9 | 70739.2 | 58195.9 | 62290.4 | 13967.0 |
| 2021-09-07 | BZ | Futures | 47.69 | 47.74 | 46.64 | 47.03 | 35294.0 |
| 2021-09-07 | C | Futures | 1560.0 | 1577.0 | 1551.0 | 1573.0 | 1111.0 |
| 2021-09-07 | CB | Futures | 141.839 | 143.415 | 141.839 | 141.839 | 10.0 |
| 2021-09-07 | CC | Futures | 1707.0 | 1741.0 | 1698.0 | 1736.0 | 26185.0 |
| 2021-09-07 | CNH | Futures | 6.2122 | 6.2376 | 6.2122 | 6.2312 | 789.0 |
| 2021-09-07 | CSC | Futures | 2.492 | 2.501 | 2.492 | 2.495 | 5.0 |
| 2021-09-07 | CT | Futures | 88.69 | 88.69 | 88.24 | 88.24 | 9.0 |
| 2021-09-07 | DC | Futures | 22.42 | 22.77 | 22.42 | 22.73 | 25.0 |
| 2021-09-07 | DX | Futures | 89.1 | 89.482 | 89.027 | 89.423 | 32577.0 |
| 2021-09-07 | E1 | Futures | 1.22875 | 1.22987 | 1.22089 | 1.22167 | 39969.0 |
| 2021-09-07 | E6 | Futures | 1.26382 | 1.26451 | 1.2593 | 1.26015 | 338657.0 |
| 2021-09-07 | E7 | Futures | 1.2577 | 1.2581 | 1.253 | 1.2538 | 8397.0 |
| 2021-09-07 | EBM | Futures | 358.58 | 358.58 | 354.54 | 356.01 | 23920.0 |
| 2021-09-07 | ED | Futures | 96.5514 | 96.5538 | 96.549 | 96.549 | 100783.0 |
| 2021-09-07 | ER | Futures | 98.475 | 98.475 | 98.465 | 98.47 | 45269.0 |
| 2021-09-07 | ESG | Futures | 421.72 | 421.72 | 419.63 | 420.16 | 169.0 |
| 2021-09-07 | EW | Futures | 2956.4 | 2972.0 | 2925.3 | 2929.2 | 10035.0 |
| 2021-09-07 | FBON | Futures | 150.37 | 150.37 | 149.69 | 149.76 | 411.0 |
| 2021-09-07 | FBTP | Futures | 140.26 | 140.31 | 139.31 | 139.44 | 196859.0 |
| 2021-09-07 | FBTS | Futures | 110.487 | 110.487 | 110.361 | 110.371 | 142182.0 |
| 2021-09-07 | FCE | Futures | 6731.1 | 6739.1 | 6692.7 | 6714.6 | 45488.0 |
| 2021-09-07 | FDAX | Futures | 17043.3 | 17061.5 | 16940.5 | 16970.5 | 69062.0 |
| 2021-09-07 | FDIV | Futures | 185.98 | 185.98 | 185.88 | 185.88 | 10.0 |
| 2021-09-07 | FDXM | Futures | 16958.8 | 16976.9 | 16858.6 | 16886.3 | 42268.0 |
| 2021-09-07 | FDXS | Futures | 16864.8 | 16869.1 | 16751.5 | 16779.0 | 8502.0 |
| 2021-09-07 | FESX | Futures | 4016.2 | 4023.3 | 3993.5 | 4004.8 | 682766.0 |
| 2021-09-07 | FEU3 | Futures | 99.218 | 99.218 | 99.213 | 99.213 | 50.0 |
| 2021-09-07 | FGBL | Futures | 169.63 | 169.74 | 168.96 | 169.08 | 885563.0 |
| 2021-09-07 | FGBM | Futures | 135.35 | 135.37 | 135.08 | 135.12 | 641419.0 |
| 2021-09-07 | FGBS | Futures | 112.694 | 112.699 | 112.649 | 112.659 | 436853.0 |
| 2021-09-07 | FGBX | Futures | 225.27 | 225.55 | 223.39 | 224.1 | 109593.0 |
| 2021-09-07 | FMWO | Futures | 11218.0 | 11223.9 | 11149.9 | 11158.1 | 2677.0 |
| 2021-09-07 | FOAT | Futures | 157.3 | 157.4 | 156.48 | 156.61 | 276482.0 |
| 2021-09-07 | FTDX | Futures | 4083.7 | 4090.4 | 4070.9 | 4081.7 | 66.0 |
| 2021-09-07 | FTI | Futures | 762.75 | 764.09 | 757.93 | 759.65 | 15940.0 |
| 2021-09-07 | FTUK | Futures | 7064.1 | 7069.5 | 7004.5 | 7041.4 | 84038.0 |
> showing 50 of 125 rows — these rows as CSV