PREVIEW / futures_daily / 2021-10-22
file: by_date/futures_daily/2021/2021-10-22.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-10-22 | ES | Futures | 5095.76 | 5119.94 | 5079.17 | 5103.07 | 1315668.0 |
| 2021-10-22 | NQ | Futures | 17738.84 | 17831.66 | 17612.86 | 17690.4 | 545390.0 |
| 2021-10-22 | YM | Futures | 38599.0 | 38782.9 | 38529.4 | 38687.2 | 175484.0 |
| 2021-10-22 | CL | Futures | 61.21 | 62.4 | 60.58 | 62.06 | 465355.0 |
| 2021-10-22 | GC | Futures | 2081.0 | 2118.1 | 2080.6 | 2095.7 | 312812.0 |
| 2021-10-22 | ZN | Futures | 132.20827 | 132.716763 | 132.192379 | 132.557859 | 1938170.0 |
| 2021-10-22 | A6 | Futures | 0.76566 | 0.77028 | 0.76423 | 0.76546 | 93624.0 |
| 2021-10-22 | AD | Futures | 0.82059 | 0.82394 | 0.81932 | 0.8209 | 63416.0 |
| 2021-10-22 | ALI | Futures | 3279.64 | 3347.74 | 3225.44 | 3235.45 | 164.0 |
| 2021-10-22 | B | Futures | 57.26 | 58.21 | 56.78 | 57.94 | 298347.0 |
| 2021-10-22 | B6 | Futures | 1.4003 | 1.4024 | 1.3942 | 1.3965 | 90400.0 |
| 2021-10-22 | BFX | Futures | 4286.1 | 4286.1 | 4280.5 | 4280.5 | 10.0 |
| 2021-10-22 | BR | Futures | 0.14264 | 0.14329 | 0.13996 | 0.14272 | 2501.0 |
| 2021-10-22 | BTC | Futures | 83620.5 | 85029.9 | 80057.1 | 81213.9 | 10125.0 |
| 2021-10-22 | BZ | Futures | 56.01 | 56.87 | 55.47 | 56.6 | 41174.0 |
| 2021-10-22 | C | Futures | 1517.0 | 1525.0 | 1505.0 | 1517.0 | 7475.0 |
| 2021-10-22 | CB | Futures | 143.966 | 144.873 | 143.966 | 144.36 | 7.0 |
| 2021-10-22 | CC | Futures | 1644.0 | 1670.0 | 1617.0 | 1659.0 | 17196.0 |
| 2021-10-22 | CNH | Futures | 6.1492 | 6.1503 | 6.1304 | 6.1372 | 334.0 |
| 2021-10-22 | CSC | Futures | 2.655 | 2.665 | 2.634 | 2.648 | 121.0 |
| 2021-10-22 | CT | Futures | 99.2 | 101.78 | 99.16 | 101.04 | 13639.0 |
| 2021-10-22 | DC | Futures | 25.14 | 25.2 | 24.95 | 25.05 | 458.0 |
| 2021-10-22 | DX | Futures | 90.578 | 90.612 | 90.351 | 90.462 | 23481.0 |
| 2021-10-22 | E1 | Futures | 1.2209 | 1.22549 | 1.22079 | 1.22404 | 20627.0 |
| 2021-10-22 | E6 | Futures | 1.23635 | 1.23959 | 1.23587 | 1.23751 | 149031.0 |
| 2021-10-22 | E7 | Futures | 1.2294 | 1.2328 | 1.2292 | 1.2308 | 3495.0 |
| 2021-10-22 | EBM | Futures | 408.91 | 412.59 | 408.54 | 411.48 | 18206.0 |
| 2021-10-22 | ED | Futures | 96.5344 | 96.5441 | 96.5296 | 96.5392 | 248985.0 |
| 2021-10-22 | ER | Futures | 98.475 | 98.48 | 98.475 | 98.475 | 24229.0 |
| 2021-10-22 | ESG | Futures | 423.54 | 424.25 | 421.43 | 423.36 | 216.0 |
| 2021-10-22 | EW | Futures | 3003.2 | 3021.6 | 2989.6 | 3004.1 | 12541.0 |
| 2021-10-22 | FBON | Futures | 147.49 | 148.05 | 147.49 | 147.86 | 1118.0 |
| 2021-10-22 | FBTP | Futures | 137.2 | 137.62 | 136.98 | 137.29 | 141008.0 |
| 2021-10-22 | FBTS | Futures | 110.128 | 110.157 | 110.089 | 110.118 | 72320.0 |
| 2021-10-22 | FCE | Futures | 6799.5 | 6840.0 | 6788.4 | 6807.1 | 47192.0 |
| 2021-10-22 | FDAX | Futures | 16541.4 | 16671.8 | 16532.9 | 16608.8 | 64212.0 |
| 2021-10-22 | FDIV | Futures | 183.19 | 183.58 | 183.19 | 183.24 | 20.0 |
| 2021-10-22 | FDXM | Futures | 16588.5 | 16719.3 | 16582.1 | 16656.1 | 48798.0 |
| 2021-10-22 | FDXS | Futures | 16464.2 | 16564.1 | 16430.3 | 16501.4 | 16637.0 |
| 2021-10-22 | FESX | Futures | 3976.6 | 4014.9 | 3973.7 | 4002.4 | 659581.0 |
| 2021-10-22 | FGBL | Futures | 165.42 | 166.06 | 165.36 | 165.79 | 758775.0 |
| 2021-10-22 | FGBM | Futures | 133.58 | 133.86 | 133.54 | 133.75 | 544834.0 |
| 2021-10-22 | FGBS | Futures | 112.473 | 112.539 | 112.463 | 112.514 | 380832.0 |
| 2021-10-22 | FGBX | Futures | 219.98 | 221.97 | 219.92 | 221.43 | 101272.0 |
| 2021-10-22 | FMWO | Futures | 11181.2 | 11235.5 | 11155.3 | 11182.4 | 5403.0 |
| 2021-10-22 | FOAT | Futures | 153.26 | 153.93 | 153.23 | 153.61 | 155608.0 |
| 2021-10-22 | FTDX | Futures | 3896.9 | 3911.8 | 3888.7 | 3898.5 | 217.0 |
| 2021-10-22 | FTI | Futures | 773.65 | 779.05 | 772.98 | 775.06 | 16105.0 |
| 2021-10-22 | FTUK | Futures | 7090.7 | 7125.8 | 7079.3 | 7105.0 | 82229.0 |
| 2021-10-22 | FVSA | Futures | 67.73 | 69.45 | 66.87 | 68.24 | 21753.0 |
> showing 50 of 125 rows — these rows as CSV