PREVIEW / futures_daily / 2024-11-05
file: by_date/futures_daily/2024/2024-11-05.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-05 | ES | Futures | 5884.8 | 5957.44 | 5867.15 | 5946.18 | 1198797.0 |
| 2024-11-05 | NQ | Futures | 20648.45 | 20909.75 | 20557.16 | 20864.88 | 450115.0 |
| 2024-11-05 | YM | Futures | 42441.4 | 42906.3 | 42357.5 | 42826.4 | 95861.0 |
| 2024-11-05 | CL | Futures | 69.32 | 70.33 | 69.0 | 69.67 | 247311.0 |
| 2024-11-05 | GC | Futures | 2803.8 | 2817.6 | 2790.9 | 2807.5 | 151434.0 |
| 2024-11-05 | ZN | Futures | 110.655224 | 110.670868 | 110.076368 | 110.545711 | 1911100.0 |
| 2024-11-05 | A6 | Futures | 0.65849 | 0.66404 | 0.65784 | 0.66344 | 71058.0 |
| 2024-11-05 | AD | Futures | 0.72183 | 0.72594 | 0.72158 | 0.72499 | 72931.0 |
| 2024-11-05 | ALI | Futures | 2656.27 | 2720.99 | 2656.27 | 2717.66 | 4086.0 |
| 2024-11-05 | B | Futures | 74.42 | 75.65 | 74.32 | 74.94 | 296478.0 |
| 2024-11-05 | B6 | Futures | 1.2954 | 1.3037 | 1.2942 | 1.3015 | 63605.0 |
| 2024-11-05 | BFX | Futures | 4277.5 | 4277.5 | 4277.5 | 4277.5 | 0.0 |
| 2024-11-05 | BR | Futures | 0.16791 | 0.16942 | 0.16757 | 0.16903 | 17690.0 |
| 2024-11-05 | BTC | Futures | 73787.2 | 76738.7 | 73235.8 | 75527.8 | 8871.0 |
| 2024-11-05 | BZ | Futures | 73.13 | 74.13 | 72.86 | 73.45 | 40233.0 |
| 2024-11-05 | C | Futures | 5688.0 | 5689.0 | 5438.0 | 5562.0 | 4999.0 |
| 2024-11-05 | CB | Futures | 282.61 | 284.27 | 282.558 | 283.751 | 8.0 |
| 2024-11-05 | CC | Futures | 6019.0 | 6105.0 | 5896.0 | 6032.0 | 9674.0 |
| 2024-11-05 | CNH | Futures | 7.0607 | 7.0652 | 7.0538 | 7.0552 | 719.0 |
| 2024-11-05 | CSC | Futures | 1.981 | 1.981 | 1.964 | 1.968 | 488.0 |
| 2024-11-05 | CT | Futures | 76.66 | 76.94 | 76.1 | 76.68 | 20299.0 |
| 2024-11-05 | DC | Futures | 19.36 | 19.36 | 19.12 | 19.16 | 763.0 |
| 2024-11-05 | DX | Futures | 103.536 | 103.586 | 103.003 | 103.042 | 11330.0 |
| 2024-11-05 | E1 | Futures | 1.17327 | 1.17691 | 1.17201 | 1.17484 | 20370.0 |
| 2024-11-05 | E6 | Futures | 1.09429 | 1.10012 | 1.09364 | 1.09957 | 146449.0 |
| 2024-11-05 | E7 | Futures | 1.094 | 1.0997 | 1.0933 | 1.0993 | 2067.0 |
| 2024-11-05 | EBM | Futures | 234.96 | 234.96 | 231.96 | 233.87 | 33930.0 |
| 2024-11-05 | ER | Futures | 97.775 | 97.775 | 97.765 | 97.765 | 154411.0 |
| 2024-11-05 | ESG | Futures | 506.78 | 511.21 | 506.1 | 510.99 | 271.0 |
| 2024-11-05 | EW | Futures | 3157.2 | 3214.2 | 3137.1 | 3203.9 | 7931.0 |
| 2024-11-05 | FBON | Futures | 124.12 | 124.15 | 123.74 | 123.98 | 217.0 |
| 2024-11-05 | FBTP | Futures | 118.89 | 119.01 | 118.44 | 118.82 | 244163.0 |
| 2024-11-05 | FBTS | Futures | 106.87 | 106.95 | 106.79 | 106.84 | 148779.0 |
| 2024-11-05 | FCE | Futures | 7384.3 | 7431.3 | 7353.8 | 7412.3 | 30678.0 |
| 2024-11-05 | FDAX | Futures | 19397.1 | 19581.9 | 19374.9 | 19529.4 | 28207.0 |
| 2024-11-05 | FDIV | Futures | 188.37 | 188.37 | 187.67 | 188.37 | 12.0 |
| 2024-11-05 | FDXM | Futures | 19352.1 | 19540.5 | 19334.0 | 19487.1 | 26138.0 |
| 2024-11-05 | FDXS | Futures | 19330.9 | 19495.7 | 19290.7 | 19443.5 | 19296.0 |
| 2024-11-05 | FESX | Futures | 4868.8 | 4904.8 | 4858.8 | 4892.8 | 484699.0 |
| 2024-11-05 | FEU3 | Futures | 97.77 | 97.775 | 97.765 | 97.77 | 31555.0 |
| 2024-11-05 | FGBL | Futures | 133.46 | 133.58 | 132.95 | 133.16 | 1015191.0 |
| 2024-11-05 | FGBM | Futures | 117.59 | 117.59 | 117.32 | 117.38 | 634221.0 |
| 2024-11-05 | FGBS | Futures | 106.899 | 106.904 | 106.798 | 106.823 | 660020.0 |
| 2024-11-05 | FGBX | Futures | 133.1 | 133.9 | 131.6 | 132.28 | 107689.0 |
| 2024-11-05 | FMWO | Futures | 12060.8 | 12185.2 | 12049.4 | 12146.8 | 3952.0 |
| 2024-11-05 | FOAT | Futures | 123.85 | 124.19 | 123.47 | 123.73 | 180530.0 |
| 2024-11-05 | FSMX | Futures | 26552.8 | 26693.8 | 26552.8 | 26690.8 | 6.0 |
| 2024-11-05 | FTDX | Futures | 3389.8 | 3396.4 | 3389.8 | 3395.4 | 2.0 |
| 2024-11-05 | FTI | Futures | 887.51 | 890.23 | 885.19 | 888.88 | 6328.0 |
| 2024-11-05 | FTUK | Futures | 8202.2 | 8247.2 | 8178.6 | 8206.2 | 57153.0 |
> showing 50 of 130 rows — these rows as CSV