PREVIEW / futures_daily / 2024-11-18
file: by_date/futures_daily/2024/2024-11-18.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-18 | ES | Futures | 6035.7 | 6069.72 | 6022.14 | 6056.42 | 1332326.0 |
| 2024-11-18 | NQ | Futures | 21031.3 | 21257.22 | 21002.58 | 21164.13 | 525474.0 |
| 2024-11-18 | YM | Futures | 44039.0 | 44112.8 | 43854.1 | 43997.6 | 100133.0 |
| 2024-11-18 | CL | Futures | 64.91 | 67.44 | 64.67 | 67.24 | 300552.0 |
| 2024-11-18 | GC | Futures | 2625.6 | 2674.6 | 2622.5 | 2669.6 | 195294.0 |
| 2024-11-18 | ZN | Futures | 109.560092 | 109.826053 | 109.278487 | 109.763474 | 1430816.0 |
| 2024-11-18 | A6 | Futures | 0.6458 | 0.651 | 0.64465 | 0.6503 | 72722.0 |
| 2024-11-18 | AD | Futures | 0.71201 | 0.71632 | 0.71126 | 0.71557 | 73075.0 |
| 2024-11-18 | ALI | Futures | 2645.82 | 2675.53 | 2581.07 | 2605.44 | 2440.0 |
| 2024-11-18 | B | Futures | 70.25 | 72.9 | 70.15 | 72.73 | 333852.0 |
| 2024-11-18 | B6 | Futures | 1.2613 | 1.2681 | 1.2604 | 1.2664 | 80471.0 |
| 2024-11-18 | BFX | Futures | 4138.6 | 4138.6 | 4138.6 | 4138.6 | 0.0 |
| 2024-11-18 | BR | Futures | 0.16781 | 0.16967 | 0.16772 | 0.16962 | 12866.0 |
| 2024-11-18 | BTC | Futures | 97512.6 | 100777.6 | 97036.9 | 99528.9 | 12505.0 |
| 2024-11-18 | BZ | Futures | 68.93 | 71.44 | 68.75 | 71.28 | 30425.0 |
| 2024-11-18 | C | Futures | 7018.0 | 7018.0 | 6719.0 | 6855.0 | 1473.0 |
| 2024-11-18 | CB | Futures | 278.979 | 278.979 | 273.117 | 273.117 | 21.0 |
| 2024-11-18 | CC | Futures | 7391.0 | 7425.0 | 7043.0 | 7221.0 | 16526.0 |
| 2024-11-18 | CNH | Futures | 7.2041 | 7.2201 | 7.1957 | 7.1991 | 2205.0 |
| 2024-11-18 | CSC | Futures | 1.902 | 1.961 | 1.898 | 1.958 | 237.0 |
| 2024-11-18 | CT | Futures | 73.26 | 73.56 | 72.81 | 73.03 | 12221.0 |
| 2024-11-18 | DC | Futures | 18.83 | 19.37 | 18.76 | 19.29 | 955.0 |
| 2024-11-18 | DX | Futures | 106.413 | 106.458 | 105.775 | 105.911 | 18105.0 |
| 2024-11-18 | E1 | Futures | 1.1392 | 1.14682 | 1.13895 | 1.14591 | 17252.0 |
| 2024-11-18 | E6 | Futures | 1.0594 | 1.06638 | 1.05859 | 1.06467 | 171990.0 |
| 2024-11-18 | E7 | Futures | 1.0589 | 1.066 | 1.0584 | 1.0643 | 3772.0 |
| 2024-11-18 | EBM | Futures | 236.88 | 239.33 | 236.33 | 238.24 | 24844.0 |
| 2024-11-18 | ER | Futures | 97.82 | 97.825 | 97.785 | 97.795 | 214335.0 |
| 2024-11-18 | ESG | Futures | 519.82 | 522.93 | 519.32 | 521.87 | 565.0 |
| 2024-11-18 | EW | Futures | 3255.1 | 3271.8 | 3247.6 | 3259.9 | 7028.0 |
| 2024-11-18 | FBON | Futures | 124.83 | 124.88 | 124.14 | 124.49 | 184.0 |
| 2024-11-18 | FBTP | Futures | 119.95 | 120.05 | 119.12 | 119.71 | 212038.0 |
| 2024-11-18 | FBTS | Futures | 107.29 | 107.31 | 107.1 | 107.23 | 115586.0 |
| 2024-11-18 | FCE | Futures | 7352.8 | 7352.8 | 7292.9 | 7338.2 | 30108.0 |
| 2024-11-18 | FDAX | Futures | 19506.2 | 19546.6 | 19337.5 | 19425.4 | 33428.0 |
| 2024-11-18 | FDIV | Futures | 183.68 | 183.68 | 183.68 | 183.68 | 0.0 |
| 2024-11-18 | FDXM | Futures | 19473.0 | 19505.2 | 19296.7 | 19383.3 | 27281.0 |
| 2024-11-18 | FDXS | Futures | 19417.3 | 19461.6 | 19252.5 | 19339.9 | 24186.0 |
| 2024-11-18 | FESX | Futures | 4813.7 | 4824.7 | 4774.6 | 4805.7 | 480639.0 |
| 2024-11-18 | FEU3 | Futures | 97.82 | 97.82 | 97.79 | 97.795 | 29612.0 |
| 2024-11-18 | FGBL | Futures | 134.0 | 134.13 | 133.22 | 133.66 | 823053.0 |
| 2024-11-18 | FGBM | Futures | 118.03 | 118.07 | 117.55 | 117.81 | 625949.0 |
| 2024-11-18 | FGBS | Futures | 107.114 | 107.139 | 106.959 | 107.034 | 654228.0 |
| 2024-11-18 | FGBX | Futures | 133.58 | 133.86 | 132.24 | 133.18 | 89490.0 |
| 2024-11-18 | FMWO | Futures | 12226.6 | 12291.9 | 12189.3 | 12273.3 | 5804.0 |
| 2024-11-18 | FOAT | Futures | 124.55 | 124.65 | 123.84 | 124.3 | 179594.0 |
| 2024-11-18 | FSMX | Futures | 26582.8 | 26628.8 | 26283.7 | 26336.7 | 193.0 |
| 2024-11-18 | FTDX | Futures | 3402.5 | 3402.5 | 3379.7 | 3388.3 | 14.0 |
| 2024-11-18 | FTI | Futures | 866.95 | 870.76 | 861.94 | 869.34 | 7116.0 |
| 2024-11-18 | FTUK | Futures | 8131.0 | 8165.6 | 8090.9 | 8140.5 | 69436.0 |
> showing 50 of 130 rows — these rows as CSV