PREVIEW / futures_daily / 2024-08-20
file: by_date/futures_daily/2024/2024-08-20.parquet size: 10 KB rows: 129
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-08-20 | ES | Futures | 5814.72 | 5829.44 | 5792.25 | 5804.65 | 1020393.0 |
| 2024-08-20 | NQ | Futures | 20579.88 | 20655.8 | 20460.96 | 20529.88 | 485435.0 |
| 2024-08-20 | YM | Futures | 41802.7 | 41896.5 | 41682.3 | 41757.8 | 93913.0 |
| 2024-08-20 | CL | Futures | 69.51 | 70.11 | 68.38 | 68.97 | 329276.0 |
| 2024-08-20 | GC | Futures | 2595.9 | 2624.5 | 2588.4 | 2604.3 | 191196.0 |
| 2024-08-20 | ZN | Futures | 113.810322 | 114.234402 | 113.700376 | 114.155869 | 1626916.0 |
| 2024-08-20 | A6 | Futures | 0.6747 | 0.67645 | 0.6728 | 0.6761 | 113865.0 |
| 2024-08-20 | AD | Futures | 0.73766 | 0.74007 | 0.7373 | 0.73836 | 92584.0 |
| 2024-08-20 | ALI | Futures | 2465.08 | 2502.7 | 2421.01 | 2499.35 | 2783.0 |
| 2024-08-20 | B | Futures | 75.63 | 76.3 | 74.55 | 75.18 | 367144.0 |
| 2024-08-20 | B6 | Futures | 1.2993 | 1.3053 | 1.2974 | 1.3031 | 117174.0 |
| 2024-08-20 | BFX | Futures | 4064.0 | 4064.0 | 4064.0 | 4064.0 | 0.0 |
| 2024-08-20 | BR | Futures | 0.17832 | 0.17847 | 0.17543 | 0.17576 | 21314.0 |
| 2024-08-20 | BTC | Futures | 66364.8 | 69140.5 | 65820.8 | 66919.9 | 10871.0 |
| 2024-08-20 | BZ | Futures | 74.16 | 74.74 | 73.02 | 73.65 | 39162.0 |
| 2024-08-20 | C | Futures | 6305.0 | 6416.0 | 6180.0 | 6360.0 | 2353.0 |
| 2024-08-20 | CB | Futures | 313.429 | 314.813 | 313.186 | 313.186 | 49.0 |
| 2024-08-20 | CC | Futures | 5937.0 | 6302.0 | 5911.0 | 6256.0 | 13282.0 |
| 2024-08-20 | CNH | Futures | 7.0199 | 7.0343 | 7.0037 | 7.0091 | 2888.0 |
| 2024-08-20 | CSC | Futures | 2.119 | 2.142 | 2.104 | 2.132 | 97.0 |
| 2024-08-20 | CT | Futures | 77.0 | 77.72 | 76.86 | 77.28 | 18.0 |
| 2024-08-20 | DC | Futures | 20.6 | 20.88 | 20.49 | 20.8 | 1092.0 |
| 2024-08-20 | DX | Futures | 101.194 | 101.339 | 100.707 | 100.78 | 13487.0 |
| 2024-08-20 | E1 | Futures | 1.18493 | 1.1968 | 1.18411 | 1.1945 | 26092.0 |
| 2024-08-20 | E6 | Futures | 1.11841 | 1.12295 | 1.11695 | 1.12194 | 182037.0 |
| 2024-08-20 | E7 | Futures | 1.118 | 1.1226 | 1.1166 | 1.1216 | 3055.0 |
| 2024-08-20 | EBM | Futures | 236.56 | 240.64 | 236.26 | 238.31 | 18002.0 |
| 2024-08-20 | ER | Futures | 97.629 | 97.639 | 97.624 | 97.634 | 72679.0 |
| 2024-08-20 | ESG | Futures | 501.43 | 501.91 | 499.12 | 499.34 | 318.0 |
| 2024-08-20 | EW | Futures | 3104.3 | 3115.7 | 3069.3 | 3075.8 | 5890.0 |
| 2024-08-20 | FBON | Futures | 124.78 | 125.3 | 124.78 | 125.3 | 46.0 |
| 2024-08-20 | FBTP | Futures | 118.79 | 119.16 | 118.78 | 119.14 | 186212.0 |
| 2024-08-20 | FBTS | Futures | 106.908 | 106.999 | 106.898 | 106.979 | 82157.0 |
| 2024-08-20 | FCE | Futures | 7650.5 | 7681.5 | 7615.5 | 7633.8 | 26446.0 |
| 2024-08-20 | FDAX | Futures | 18903.4 | 18983.1 | 18797.0 | 18837.9 | 29855.0 |
| 2024-08-20 | FDIV | Futures | 183.47 | 183.47 | 183.47 | 183.47 | 0.0 |
| 2024-08-20 | FDXM | Futures | 18826.6 | 18895.8 | 18709.5 | 18750.2 | 16293.0 |
| 2024-08-20 | FDXS | Futures | 18782.4 | 18846.4 | 18660.6 | 18701.2 | 13272.0 |
| 2024-08-20 | FESX | Futures | 4931.6 | 4954.8 | 4898.3 | 4912.5 | 482270.0 |
| 2024-08-20 | FEU3 | Futures | 97.634 | 97.644 | 97.634 | 97.644 | 1477.0 |
| 2024-08-20 | FGBL | Futures | 135.58 | 136.08 | 135.48 | 136.03 | 702033.0 |
| 2024-08-20 | FGBM | Futures | 118.48 | 118.7 | 118.43 | 118.68 | 517330.0 |
| 2024-08-20 | FGBS | Futures | 106.943 | 107.034 | 106.938 | 107.024 | 367372.0 |
| 2024-08-20 | FGBX | Futures | 136.77 | 138.02 | 136.63 | 137.96 | 63879.0 |
| 2024-08-20 | FMWO | Futures | 12016.5 | 12031.2 | 11968.3 | 11975.6 | 4821.0 |
| 2024-08-20 | FOAT | Futures | 125.86 | 126.25 | 125.8 | 126.23 | 123755.0 |
| 2024-08-20 | FSMX | Futures | 25262.9 | 25262.9 | 25042.0 | 25042.0 | 46.0 |
| 2024-08-20 | FTDX | Futures | 3439.2 | 3441.7 | 3396.9 | 3405.5 | 5.0 |
| 2024-08-20 | FTI | Futures | 920.33 | 921.44 | 910.05 | 913.38 | 5963.0 |
| 2024-08-20 | FTUK | Futures | 8384.1 | 8396.1 | 8283.8 | 8318.4 | 71964.0 |
> showing 50 of 129 rows — these rows as CSV