PREVIEW / futures_daily / 2020-08-31
file: by_date/futures_daily/2020/2020-08-31.parquet size: 10 KB rows: 115
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-08-31 | ES | Futures | 3949.12 | 3967.13 | 3928.3 | 3938.43 | 1439600.0 |
| 2020-08-31 | NQ | Futures | 13930.87 | 14119.18 | 13914.04 | 14059.99 | 480979.0 |
| 2020-08-31 | YM | Futures | 30735.0 | 30846.5 | 30364.2 | 30453.2 | 187254.0 |
| 2020-08-31 | CL | Futures | 31.03 | 31.51 | 30.78 | 30.81 | 236877.0 |
| 2020-08-31 | GC | Futures | 2331.2 | 2345.3 | 2317.5 | 2336.7 | 245105.0 |
| 2020-08-31 | ZN | Futures | 138.047674 | 138.202523 | 137.846371 | 138.156069 | 87139.0 |
| 2020-08-31 | A6 | Futures | 0.75732 | 0.76164 | 0.75516 | 0.76009 | 95778.0 |
| 2020-08-31 | AD | Futures | 0.77586 | 0.77961 | 0.77464 | 0.77926 | 82969.0 |
| 2020-08-31 | ALI | Futures | 2145.98 | 2145.98 | 2145.98 | 2145.98 | 0.0 |
| 2020-08-31 | B | Futures | 29.2 | 29.66 | 28.82 | 28.86 | 174307.0 |
| 2020-08-31 | B6 | Futures | 1.3559 | 1.3603 | 1.3508 | 1.3585 | 83187.0 |
| 2020-08-31 | BR | Futures | 0.14321 | 0.14352 | 0.14317 | 0.14333 | 5.0 |
| 2020-08-31 | BTC | Futures | 15844.3 | 16087.3 | 15803.8 | 15979.3 | 4865.0 |
| 2020-08-31 | BZ | Futures | 28.5 | 29.0 | 28.2 | 28.24 | 18967.0 |
| 2020-08-31 | CB | Futures | 170.246 | 170.246 | 170.246 | 170.246 | 6.0 |
| 2020-08-31 | CC | Futures | 1724.0 | 1755.0 | 1724.0 | 1743.0 | 13977.0 |
| 2020-08-31 | CNH | Futures | 6.7656 | 6.7656 | 6.7472 | 6.7517 | 721.0 |
| 2020-08-31 | CSC | Futures | 3.304 | 3.304 | 3.304 | 3.304 | 42.0 |
| 2020-08-31 | CT | Futures | 65.33 | 65.33 | 65.14 | 65.14 | 1.0 |
| 2020-08-31 | DC | Futures | 26.8 | 26.84 | 26.71 | 26.74 | 65.0 |
| 2020-08-31 | DX | Futures | 89.156 | 89.339 | 88.856 | 88.992 | 29089.0 |
| 2020-08-31 | E1 | Futures | 1.25681 | 1.2626 | 1.25499 | 1.25783 | 28895.0 |
| 2020-08-31 | E6 | Futures | 1.27839 | 1.28435 | 1.27555 | 1.28113 | 200188.0 |
| 2020-08-31 | E7 | Futures | 1.2716 | 1.2779 | 1.2692 | 1.2748 | 9811.0 |
| 2020-08-31 | EBM | Futures | 226.04 | 227.24 | 224.24 | 224.84 | 3270.0 |
| 2020-08-31 | ED | Futures | 96.4427 | 96.4451 | 96.4378 | 96.4403 | 90633.0 |
| 2020-08-31 | ER | Futures | 98.406 | 98.406 | 98.396 | 98.401 | 28189.0 |
| 2020-08-31 | ESG | Futures | 320.41 | 320.79 | 319.88 | 319.88 | 29.0 |
| 2020-08-31 | EW | Futures | 2072.9 | 2081.7 | 2045.4 | 2048.2 | 13529.0 |
| 2020-08-31 | FBON | Futures | 146.09 | 146.28 | 145.72 | 145.78 | 490.0 |
| 2020-08-31 | FBTP | Futures | 132.65 | 132.88 | 132.13 | 132.26 | 84894.0 |
| 2020-08-31 | FBTS | Futures | 108.929 | 108.987 | 108.871 | 108.9 | 48628.0 |
| 2020-08-31 | FCE | Futures | 4900.0 | 4929.7 | 4800.7 | 4812.3 | 64181.0 |
| 2020-08-31 | FDAX | Futures | 13919.9 | 13973.6 | 13703.2 | 13732.4 | 74924.0 |
| 2020-08-31 | FDXM | Futures | 13871.3 | 13920.0 | 13654.3 | 13682.9 | 33254.0 |
| 2020-08-31 | FESX | Futures | 3076.7 | 3092.4 | 3009.3 | 3014.9 | 891661.0 |
| 2020-08-31 | FGBL | Futures | 167.81 | 167.95 | 167.42 | 167.74 | 629222.0 |
| 2020-08-31 | FGBM | Futures | 134.66 | 134.7 | 134.49 | 134.58 | 367231.0 |
| 2020-08-31 | FGBS | Futures | 112.709 | 112.709 | 112.669 | 112.679 | 372411.0 |
| 2020-08-31 | FGBX | Futures | 222.79 | 223.76 | 221.8 | 223.67 | 86683.0 |
| 2020-08-31 | FMWO | Futures | 8663.0 | 8671.3 | 8593.1 | 8601.4 | 1065.0 |
| 2020-08-31 | FOAT | Futures | 155.52 | 155.59 | 155.16 | 155.44 | 156319.0 |
| 2020-08-31 | FTDX | Futures | 3194.7 | 3228.4 | 3173.2 | 3173.2 | 20.0 |
| 2020-08-31 | FTI | Futures | 522.83 | 523.48 | 510.53 | 511.51 | 23861.0 |
| 2020-08-31 | FVSA | Futures | 205.83 | 217.03 | 202.51 | 213.71 | 21678.0 |
| 2020-08-31 | FXXP | Futures | 342.1 | 343.3 | 336.9 | 337.3 | 39818.0 |
| 2020-08-31 | GF | Futures | 265.201 | 269.103 | 264.011 | 267.057 | 968.0 |
| 2020-08-31 | GSCI | Futures | 353.32 | 353.32 | 349.81 | 350.39 | 110.0 |
| 2020-08-31 | HE | Futures | 38.439 | 39.159 | 38.295 | 38.601 | 13110.0 |
| 2020-08-31 | HG | Futures | 3.364 | 3.4078 | 3.364 | 3.4012 | 46102.0 |
> showing 50 of 115 rows — these rows as CSV