PREVIEW / futures_daily / 2024-09-18
file: by_date/futures_daily/2024/2024-09-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-09-18 | ES | Futures | 5832.37 | 5888.38 | 5806.03 | 5810.89 | 1735285.0 |
| 2024-09-18 | NQ | Futures | 20193.03 | 20411.77 | 20060.97 | 20084.05 | 559587.0 |
| 2024-09-18 | YM | Futures | 42491.9 | 42861.8 | 42289.8 | 42349.5 | 136244.0 |
| 2024-09-18 | CL | Futures | 66.56 | 66.88 | 65.23 | 66.47 | 367191.0 |
| 2024-09-18 | GC | Futures | 2650.6 | 2682.5 | 2626.6 | 2653.3 | 233128.0 |
| 2024-09-18 | ZN | Futures | 115.442513 | 115.677184 | 114.988816 | 115.223487 | 2413012.0 |
| 2024-09-18 | A6 | Futures | 0.67614 | 0.68248 | 0.67459 | 0.67913 | 103859.0 |
| 2024-09-18 | AD | Futures | 0.73877 | 0.74187 | 0.73726 | 0.73997 | 103442.0 |
| 2024-09-18 | ALI | Futures | 2506.22 | 2535.79 | 2477.68 | 2529.37 | 11633.0 |
| 2024-09-18 | B | Futures | 72.33 | 72.73 | 70.98 | 72.29 | 290808.0 |
| 2024-09-18 | B6 | Futures | 1.3156 | 1.3293 | 1.3153 | 1.3244 | 120602.0 |
| 2024-09-18 | BFX | Futures | 4252.5 | 4252.5 | 4252.5 | 4252.5 | 0.0 |
| 2024-09-18 | BR | Futures | 0.17615 | 0.17786 | 0.17615 | 0.17786 | 2.0 |
| 2024-09-18 | BTC | Futures | 66498.2 | 67709.3 | 65259.5 | 66217.4 | 10263.0 |
| 2024-09-18 | BZ | Futures | 70.78 | 71.18 | 69.47 | 70.75 | 35693.0 |
| 2024-09-18 | C | Futures | 5170.0 | 5304.0 | 5164.0 | 5290.0 | 3358.0 |
| 2024-09-18 | CB | Futures | 307.094 | 307.094 | 302.944 | 305.797 | 59.0 |
| 2024-09-18 | CC | Futures | 6243.0 | 6426.0 | 6210.0 | 6399.0 | 11843.0 |
| 2024-09-18 | CNH | Futures | 7.0194 | 7.0214 | 6.9831 | 7.0129 | 640.0 |
| 2024-09-18 | CSC | Futures | 2.274 | 2.285 | 2.245 | 2.245 | 19.0 |
| 2024-09-18 | CT | Futures | 79.76 | 79.76 | 78.27 | 78.27 | 12.0 |
| 2024-09-18 | DC | Futures | 21.95 | 22.06 | 21.61 | 21.61 | 232.0 |
| 2024-09-18 | DX | Futures | 100.32 | 100.559 | 99.612 | 100.008 | 43466.0 |
| 2024-09-18 | E1 | Futures | 1.20421 | 1.21496 | 1.20209 | 1.20901 | 27478.0 |
| 2024-09-18 | E6 | Futures | 1.1203 | 1.12743 | 1.11809 | 1.12337 | 187611.0 |
| 2024-09-18 | E7 | Futures | 1.1198 | 1.1276 | 1.1178 | 1.123 | 5979.0 |
| 2024-09-18 | EBM | Futures | 240.7 | 243.16 | 238.51 | 238.79 | 31350.0 |
| 2024-09-18 | ER | Futures | 97.599 | 97.614 | 97.564 | 97.584 | 289940.0 |
| 2024-09-18 | ESG | Futures | 502.45 | 505.13 | 500.48 | 500.54 | 923.0 |
| 2024-09-18 | EW | Futures | 3133.2 | 3188.9 | 3124.0 | 3134.8 | 14460.0 |
| 2024-09-18 | FBON | Futures | 126.11 | 126.15 | 125.38 | 125.49 | 909.0 |
| 2024-09-18 | FBTP | Futures | 120.5 | 120.56 | 119.78 | 119.83 | 349820.0 |
| 2024-09-18 | FBTS | Futures | 107.4 | 107.42 | 107.25 | 107.27 | 130495.0 |
| 2024-09-18 | FCE | Futures | 7513.5 | 7544.1 | 7451.9 | 7475.4 | 48965.0 |
| 2024-09-18 | FDAX | Futures | 19073.0 | 19288.1 | 19059.9 | 19082.1 | 26433.0 |
| 2024-09-18 | FDIV | Futures | 191.75 | 191.75 | 191.75 | 191.75 | 0.0 |
| 2024-09-18 | FDXM | Futures | 19042.8 | 19238.2 | 19017.6 | 19040.8 | 4969.0 |
| 2024-09-18 | FDXS | Futures | 18966.0 | 19191.1 | 18950.9 | 18998.1 | 2264.0 |
| 2024-09-18 | FESX | Futures | 4899.8 | 4937.9 | 4865.8 | 4875.8 | 606414.0 |
| 2024-09-18 | FEU3 | Futures | 97.599 | 97.604 | 97.584 | 97.584 | 1966.0 |
| 2024-09-18 | FGBL | Futures | 136.51 | 136.62 | 135.87 | 136.07 | 941301.0 |
| 2024-09-18 | FGBM | Futures | 119.04 | 119.09 | 118.76 | 118.83 | 609708.0 |
| 2024-09-18 | FGBS | Futures | 107.225 | 107.26 | 107.129 | 107.159 | 453288.0 |
| 2024-09-18 | FGBX | Futures | 138.11 | 138.39 | 135.99 | 136.69 | 112305.0 |
| 2024-09-18 | FMWO | Futures | 12085.7 | 12135.4 | 12023.5 | 12048.3 | 9985.0 |
| 2024-09-18 | FOAT | Futures | 126.94 | 127.05 | 126.12 | 126.36 | 208344.0 |
| 2024-09-18 | FSMX | Futures | 25995.6 | 26134.6 | 25983.6 | 26061.6 | 925.0 |
| 2024-09-18 | FTDX | Futures | 3386.8 | 3387.3 | 3384.8 | 3386.3 | 3.0 |
| 2024-09-18 | FTI | Futures | 908.45 | 910.92 | 901.79 | 902.85 | 9057.0 |
| 2024-09-18 | FTUK | Futures | 8374.5 | 8382.5 | 8313.9 | 8328.4 | 113801.0 |
> showing 50 of 130 rows — these rows as CSV