PREVIEW / futures_daily / 2021-08-31
file: by_date/futures_daily/2021/2021-08-31.parquet size: 10 KB rows: 126
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-08-31 | ES | Futures | 5091.49 | 5105.82 | 5072.38 | 5081.38 | 1378199.0 |
| 2021-08-31 | NQ | Futures | 18003.86 | 18086.64 | 17902.63 | 17977.33 | 521129.0 |
| 2021-08-31 | YM | Futures | 38379.5 | 38484.7 | 38230.9 | 38319.8 | 141519.0 |
| 2021-08-31 | CL | Futures | 50.67 | 50.79 | 49.92 | 50.17 | 325853.0 |
| 2021-08-31 | GC | Futures | 2114.2 | 2125.5 | 2103.9 | 2121.1 | 170387.0 |
| 2021-08-31 | ZN | Futures | 135.765209 | 135.907537 | 135.591252 | 135.670324 | 153595.0 |
| 2021-08-31 | A6 | Futures | 0.74823 | 0.7529 | 0.74747 | 0.7508 | 83532.0 |
| 2021-08-31 | AD | Futures | 0.80425 | 0.80658 | 0.8012 | 0.80419 | 93932.0 |
| 2021-08-31 | ALI | Futures | 3097.05 | 3132.11 | 3095.05 | 3128.97 | 96.0 |
| 2021-08-31 | B | Futures | 48.58 | 48.72 | 48.05 | 48.23 | 269779.0 |
| 2021-08-31 | B6 | Futures | 1.397 | 1.402 | 1.3955 | 1.3969 | 90787.0 |
| 2021-08-31 | BFX | Futures | 4405.1 | 4405.1 | 4392.9 | 4400.0 | 2.0 |
| 2021-08-31 | BR | Futures | 0.15697 | 0.15697 | 0.15458 | 0.15498 | 26.0 |
| 2021-08-31 | BTC | Futures | 64727.2 | 64727.2 | 62177.2 | 63102.7 | 4056.0 |
| 2021-08-31 | BZ | Futures | 47.33 | 47.48 | 46.77 | 46.99 | 28933.0 |
| 2021-08-31 | C | Futures | 1534.0 | 1550.0 | 1510.0 | 1514.0 | 12141.0 |
| 2021-08-31 | CB | Futures | 140.263 | 140.263 | 140.263 | 140.263 | 6.0 |
| 2021-08-31 | CC | Futures | 1664.0 | 1678.0 | 1628.0 | 1631.0 | 20720.0 |
| 2021-08-31 | CNH | Futures | 6.2428 | 6.247 | 6.2258 | 6.23 | 604.0 |
| 2021-08-31 | CSC | Futures | 2.47 | 2.48 | 2.47 | 2.48 | 8.0 |
| 2021-08-31 | CT | Futures | 88.1 | 88.1 | 86.85 | 86.85 | 13.0 |
| 2021-08-31 | DC | Futures | 22.45 | 22.49 | 22.32 | 22.37 | 157.0 |
| 2021-08-31 | DX | Futures | 89.607 | 89.661 | 89.308 | 89.54 | 25296.0 |
| 2021-08-31 | E1 | Futures | 1.22527 | 1.23257 | 1.22448 | 1.22785 | 24267.0 |
| 2021-08-31 | E6 | Futures | 1.2552 | 1.26036 | 1.25499 | 1.2568 | 187033.0 |
| 2021-08-31 | E7 | Futures | 1.249 | 1.2539 | 1.2487 | 1.2505 | 4178.0 |
| 2021-08-31 | EBM | Futures | 367.77 | 373.29 | 361.15 | 365.93 | 1463.0 |
| 2021-08-31 | ED | Futures | 96.5466 | 96.549 | 96.5466 | 96.549 | 77607.0 |
| 2021-08-31 | ER | Futures | 98.475 | 98.475 | 98.47 | 98.47 | 17377.0 |
| 2021-08-31 | ESG | Futures | 421.89 | 421.89 | 419.59 | 420.26 | 325.0 |
| 2021-08-31 | EW | Futures | 2967.3 | 2976.2 | 2945.3 | 2955.8 | 9417.0 |
| 2021-08-31 | FBON | Futures | 151.01 | 151.07 | 150.2 | 150.27 | 1422.0 |
| 2021-08-31 | FBTP | Futures | 141.25 | 141.26 | 140.06 | 140.12 | 219340.0 |
| 2021-08-31 | FBTS | Futures | 110.507 | 110.516 | 110.429 | 110.438 | 86213.0 |
| 2021-08-31 | FCE | Futures | 6690.7 | 6696.7 | 6637.7 | 6668.2 | 62326.0 |
| 2021-08-31 | FDAX | Futures | 16998.3 | 17145.1 | 16877.3 | 16925.5 | 89970.0 |
| 2021-08-31 | FDIV | Futures | 187.3 | 187.3 | 186.27 | 186.32 | 80.0 |
| 2021-08-31 | FDXM | Futures | 16915.1 | 17059.0 | 16792.5 | 16841.5 | 60821.0 |
| 2021-08-31 | FDXS | Futures | 16803.4 | 16949.6 | 16687.9 | 16734.5 | 14190.0 |
| 2021-08-31 | FESX | Futures | 3971.7 | 4000.6 | 3955.1 | 3964.1 | 983349.0 |
| 2021-08-31 | FEU3 | Futures | 99.218 | 99.218 | 99.218 | 99.218 | 45.0 |
| 2021-08-31 | FGBL | Futures | 170.94 | 170.95 | 169.85 | 169.96 | 1001771.0 |
| 2021-08-31 | FGBM | Futures | 135.73 | 135.74 | 135.42 | 135.44 | 665560.0 |
| 2021-08-31 | FGBS | Futures | 112.744 | 112.749 | 112.699 | 112.704 | 818478.0 |
| 2021-08-31 | FGBX | Futures | 230.03 | 230.12 | 226.81 | 227.11 | 105066.0 |
| 2021-08-31 | FMWO | Futures | 11128.7 | 11158.1 | 11084.1 | 11101.7 | 6416.0 |
| 2021-08-31 | FOAT | Futures | 158.01 | 158.01 | 157.13 | 157.17 | 346384.0 |
| 2021-08-31 | FTDX | Futures | 4055.0 | 4069.9 | 3987.8 | 3998.6 | 193.0 |
| 2021-08-31 | FTI | Futures | 756.2 | 757.59 | 750.04 | 752.72 | 21289.0 |
| 2021-08-31 | FTUK | Futures | 7020.7 | 7053.7 | 6967.6 | 6987.8 | 108146.0 |
> showing 50 of 126 rows — these rows as CSV