PREVIEW / futures_daily / 2020-10-23
file: by_date/futures_daily/2020/2020-10-23.parquet size: 10 KB rows: 119
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-10-23 | ES | Futures | 3882.47 | 3890.05 | 3855.22 | 3877.97 | 1216313.0 |
| 2020-10-23 | NQ | Futures | 13509.6 | 13535.64 | 13372.7 | 13502.94 | 501243.0 |
| 2020-10-23 | YM | Futures | 30481.2 | 30566.2 | 30192.7 | 30347.7 | 132127.0 |
| 2020-10-23 | CL | Futures | 28.95 | 29.17 | 28.21 | 28.41 | 268931.0 |
| 2020-10-23 | GC | Futures | 2251.6 | 2264.4 | 2238.3 | 2250.1 | 172958.0 |
| 2020-10-23 | ZN | Futures | 137.133421 | 137.334883 | 137.040439 | 137.226404 | 1190049.0 |
| 2020-10-23 | A6 | Futures | 0.73061 | 0.73502 | 0.72917 | 0.73245 | 88845.0 |
| 2020-10-23 | AD | Futures | 0.77169 | 0.77316 | 0.77017 | 0.77108 | 51168.0 |
| 2020-10-23 | ALI | Futures | 2202.2 | 2202.2 | 2202.2 | 2202.2 | 25.0 |
| 2020-10-23 | B | Futures | 26.75 | 27.01 | 26.19 | 26.36 | 205213.0 |
| 2020-10-23 | B6 | Futures | 1.3272 | 1.331 | 1.3203 | 1.3221 | 89364.0 |
| 2020-10-23 | BR | Futures | 0.14018 | 0.14112 | 0.13955 | 0.13963 | 1676.0 |
| 2020-10-23 | BTC | Futures | 17762.9 | 17816.7 | 17165.0 | 17427.0 | 3793.0 |
| 2020-10-23 | BZ | Futures | 26.26 | 26.48 | 25.68 | 25.84 | 26207.0 |
| 2020-10-23 | C | Futures | 1495.0 | 1519.0 | 1495.0 | 1506.0 | 4394.0 |
| 2020-10-23 | CB | Futures | 157.032 | 157.541 | 156.423 | 157.541 | 15.0 |
| 2020-10-23 | CC | Futures | 1633.0 | 1648.0 | 1621.0 | 1628.0 | 12821.0 |
| 2020-10-23 | CNH | Futures | 6.5507 | 6.5616 | 6.5306 | 6.5488 | 1269.0 |
| 2020-10-23 | CSC | Futures | 3.789 | 3.912 | 3.776 | 3.912 | 306.0 |
| 2020-10-23 | CT | Futures | 70.86 | 71.07 | 70.27 | 70.45 | 15318.0 |
| 2020-10-23 | DC | Futures | 30.96 | 32.11 | 30.8 | 32.11 | 820.0 |
| 2020-10-23 | DX | Futures | 89.806 | 89.96 | 89.492 | 89.608 | 17694.0 |
| 2020-10-23 | E1 | Futures | 1.24952 | 1.25519 | 1.24715 | 1.25337 | 15545.0 |
| 2020-10-23 | E6 | Futures | 1.2675 | 1.27232 | 1.26391 | 1.27168 | 169054.0 |
| 2020-10-23 | E7 | Futures | 1.2612 | 1.2658 | 1.2575 | 1.2653 | 6466.0 |
| 2020-10-23 | EBM | Futures | 252.26 | 254.06 | 251.65 | 252.86 | 37913.0 |
| 2020-10-23 | ED | Futures | 96.4987 | 96.4987 | 96.4842 | 96.489 | 190749.0 |
| 2020-10-23 | ER | Futures | 98.445 | 98.45 | 98.445 | 98.445 | 19667.0 |
| 2020-10-23 | ESG | Futures | 320.48 | 321.28 | 319.17 | 321.28 | 12.0 |
| 2020-10-23 | EW | Futures | 2145.0 | 2156.9 | 2128.4 | 2150.9 | 12168.0 |
| 2020-10-23 | FBON | Futures | 148.34 | 148.74 | 148.34 | 148.62 | 353.0 |
| 2020-10-23 | FBTP | Futures | 136.08 | 136.66 | 136.03 | 136.37 | 121401.0 |
| 2020-10-23 | FBTS | Futures | 109.605 | 109.691 | 109.595 | 109.653 | 70621.0 |
| 2020-10-23 | FCE | Futures | 4694.2 | 4768.6 | 4677.3 | 4743.5 | 55075.0 |
| 2020-10-23 | FDAX | Futures | 13383.7 | 13549.4 | 13320.2 | 13449.8 | 72298.0 |
| 2020-10-23 | FDIV | Futures | 145.36 | 145.36 | 144.93 | 144.98 | 50.0 |
| 2020-10-23 | FDXM | Futures | 13339.5 | 13480.6 | 13252.5 | 13381.9 | 45373.0 |
| 2020-10-23 | FESX | Futures | 2926.0 | 2968.6 | 2915.0 | 2943.6 | 806216.0 |
| 2020-10-23 | FGBL | Futures | 170.38 | 170.7 | 170.19 | 170.44 | 551138.0 |
| 2020-10-23 | FGBM | Futures | 135.48 | 135.58 | 135.4 | 135.48 | 303671.0 |
| 2020-10-23 | FGBS | Futures | 112.86 | 112.885 | 112.845 | 112.85 | 299529.0 |
| 2020-10-23 | FGBX | Futures | 234.6 | 235.73 | 234.04 | 235.02 | 52527.0 |
| 2020-10-23 | FMWO | Futures | 8505.4 | 8574.1 | 8504.2 | 8527.9 | 1062.0 |
| 2020-10-23 | FOAT | Futures | 158.35 | 158.64 | 158.21 | 158.46 | 121268.0 |
| 2020-10-23 | FTDX | Futures | 3117.2 | 3136.8 | 3109.5 | 3111.1 | 125.0 |
| 2020-10-23 | FTI | Futures | 513.74 | 516.66 | 509.79 | 512.92 | 17388.0 |
| 2020-10-23 | FTUK | Futures | 5513.3 | 5602.2 | 5501.3 | 5568.7 | 80127.0 |
| 2020-10-23 | FVSA | Futures | 184.3 | 189.31 | 181.8 | 187.88 | 17674.0 |
| 2020-10-23 | FXXP | Futures | 334.1 | 336.6 | 332.6 | 334.5 | 38845.0 |
| 2020-10-23 | G | Futures | 126.2 | 126.32 | 125.85 | 126.16 | 204287.0 |
> showing 50 of 119 rows — these rows as CSV