PREVIEW / futures_daily / 2022-11-28
file: by_date/futures_daily/2022/2022-11-28.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-28 | ES | Futures | 4480.88 | 4485.06 | 4414.01 | 4425.15 | 1481503.0 |
| 2022-11-28 | NQ | Futures | 13294.44 | 13359.32 | 13117.65 | 13164.11 | 506250.0 |
| 2022-11-28 | YM | Futures | 37323.7 | 37346.5 | 36785.0 | 36856.8 | 177639.0 |
| 2022-11-28 | CL | Futures | 66.15 | 67.81 | 64.12 | 67.29 | 405033.0 |
| 2022-11-28 | GC | Futures | 2004.3 | 2012.7 | 1984.2 | 1986.5 | 128551.0 |
| 2022-11-28 | ZN | Futures | 116.380472 | 116.798413 | 116.123278 | 116.171502 | 1819031.0 |
| 2022-11-28 | A6 | Futures | 0.68782 | 0.68828 | 0.67974 | 0.6802 | 88757.0 |
| 2022-11-28 | AD | Futures | 0.75737 | 0.75737 | 0.75108 | 0.75189 | 81776.0 |
| 2022-11-28 | ALI | Futures | 2680.22 | 2703.18 | 2677.1 | 2687.87 | 464.0 |
| 2022-11-28 | B | Futures | 73.4 | 73.99 | 70.62 | 73.31 | 341921.0 |
| 2022-11-28 | B6 | Futures | 1.2193 | 1.224 | 1.206 | 1.2073 | 89437.0 |
| 2022-11-28 | BR | Futures | 0.16363 | 0.16363 | 0.16363 | 0.16363 | 0.0 |
| 2022-11-28 | BTC | Futures | 22399.3 | 22454.1 | 21432.5 | 21926.2 | 6804.0 |
| 2022-11-28 | BZ | Futures | 72.37 | 73.18 | 69.86 | 72.54 | 34226.0 |
| 2022-11-28 | C | Futures | 1497.0 | 1519.0 | 1494.0 | 1518.0 | 8351.0 |
| 2022-11-28 | CB | Futures | 238.828 | 240.786 | 238.828 | 238.828 | 7.0 |
| 2022-11-28 | CC | Futures | 1444.0 | 1455.0 | 1430.0 | 1450.0 | 14423.0 |
| 2022-11-28 | CNH | Futures | 6.8133 | 6.8528 | 6.7903 | 6.8332 | 2152.0 |
| 2022-11-28 | CSC | Futures | 2.531 | 2.546 | 2.523 | 2.546 | 20.0 |
| 2022-11-28 | CT | Futures | 105.13 | 105.74 | 101.63 | 103.53 | 16264.0 |
| 2022-11-28 | DC | Futures | 24.31 | 24.82 | 24.31 | 24.82 | 83.0 |
| 2022-11-28 | DX | Futures | 102.966 | 103.524 | 102.127 | 103.463 | 42073.0 |
| 2022-11-28 | E1 | Futures | 1.16056 | 1.16801 | 1.15661 | 1.157 | 15320.0 |
| 2022-11-28 | E6 | Futures | 1.08181 | 1.09409 | 1.07666 | 1.07749 | 220977.0 |
| 2022-11-28 | E7 | Futures | 1.0809 | 1.0922 | 1.0749 | 1.0757 | 10422.0 |
| 2022-11-28 | EBM | Futures | 460.32 | 472.38 | 455.0 | 461.74 | 4468.0 |
| 2022-11-28 | ED | Futures | 94.1812 | 94.2184 | 94.1664 | 94.1961 | 156944.0 |
| 2022-11-28 | ER | Futures | 97.736 | 97.751 | 97.726 | 97.741 | 120148.0 |
| 2022-11-28 | ESG | Futures | 383.58 | 385.42 | 380.16 | 380.95 | 387.0 |
| 2022-11-28 | EW | Futures | 2764.8 | 2767.4 | 2712.8 | 2719.1 | 10579.0 |
| 2022-11-28 | FBON | Futures | 126.05 | 126.05 | 125.09 | 125.46 | 50.0 |
| 2022-11-28 | FBTP | Futures | 113.29 | 113.57 | 111.75 | 112.37 | 151666.0 |
| 2022-11-28 | FBTS | Futures | 106.677 | 106.767 | 106.438 | 106.537 | 137490.0 |
| 2022-11-28 | FCE | Futures | 7264.6 | 7277.1 | 7218.9 | 7245.5 | 53824.0 |
| 2022-11-28 | FDAX | Futures | 15834.1 | 15858.2 | 15664.9 | 15729.3 | 49820.0 |
| 2022-11-28 | FDIV | Futures | 168.27 | 168.27 | 168.12 | 168.12 | 10.0 |
| 2022-11-28 | FDXM | Futures | 15600.9 | 15622.4 | 15432.1 | 15495.5 | 34421.0 |
| 2022-11-28 | FDXS | Futures | 15509.4 | 15544.7 | 15355.3 | 15418.5 | 22107.0 |
| 2022-11-28 | FESX | Futures | 3905.0 | 3916.9 | 3881.3 | 3897.1 | 716327.0 |
| 2022-11-28 | FEU3 | Futures | 97.812 | 97.812 | 97.807 | 97.807 | 40.0 |
| 2022-11-28 | FGBL | Futures | 140.59 | 141.21 | 139.57 | 140.21 | 612214.0 |
| 2022-11-28 | FGBM | Futures | 121.59 | 121.89 | 121.17 | 121.55 | 542947.0 |
| 2022-11-28 | FGBS | Futures | 108.958 | 109.06 | 108.886 | 108.993 | 345706.0 |
| 2022-11-28 | FGBX | Futures | 160.5 | 162.3 | 158.6 | 159.66 | 46410.0 |
| 2022-11-28 | FMWO | Futures | 9594.0 | 9619.6 | 9490.6 | 9567.3 | 5715.0 |
| 2022-11-28 | FOAT | Futures | 131.47 | 132.09 | 130.45 | 131.04 | 127702.0 |
| 2022-11-28 | FSMX | Futures | 27315.7 | 27398.2 | 27059.8 | 27096.8 | 104.0 |
| 2022-11-28 | FTDX | Futures | 3285.1 | 3292.6 | 3272.9 | 3277.1 | 121.0 |
| 2022-11-28 | FTI | Futures | 737.12 | 740.7 | 733.07 | 738.63 | 17793.0 |
| 2022-11-28 | FTUK | Futures | 7540.7 | 7575.5 | 7497.8 | 7558.8 | 91809.0 |
> showing 50 of 128 rows — these rows as CSV