PREVIEW / futures_daily / 2024-10-18
file: by_date/futures_daily/2024/2024-10-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-10-18 | ES | Futures | 6023.93 | 6051.81 | 6011.66 | 6042.09 | 952612.0 |
| 2024-10-18 | NQ | Futures | 20908.21 | 21057.71 | 20843.34 | 21010.27 | 385566.0 |
| 2024-10-18 | YM | Futures | 43945.1 | 44039.0 | 43740.9 | 43975.4 | 87055.0 |
| 2024-10-18 | CL | Futures | 67.91 | 68.4 | 65.98 | 66.48 | 335560.0 |
| 2024-10-18 | GC | Futures | 2764.8 | 2795.4 | 2764.3 | 2787.4 | 178959.0 |
| 2024-10-18 | ZN | Futures | 112.250987 | 112.438724 | 112.06325 | 112.3605 | 1539530.0 |
| 2024-10-18 | A6 | Futures | 0.66969 | 0.67209 | 0.66949 | 0.67049 | 53471.0 |
| 2024-10-18 | AD | Futures | 0.72784 | 0.72824 | 0.72669 | 0.72699 | 50465.0 |
| 2024-10-18 | ALI | Futures | 2591.8 | 2660.1 | 2588.47 | 2653.71 | 4312.0 |
| 2024-10-18 | B | Futures | 73.93 | 74.29 | 71.86 | 72.41 | 320777.0 |
| 2024-10-18 | B6 | Futures | 1.3004 | 1.3065 | 1.3003 | 1.304 | 77567.0 |
| 2024-10-18 | BFX | Futures | 4341.2 | 4341.2 | 4341.2 | 4341.2 | 0.0 |
| 2024-10-18 | BR | Futures | 0.17142 | 0.17142 | 0.17045 | 0.17059 | 17.0 |
| 2024-10-18 | BTC | Futures | 73489.5 | 75686.1 | 73489.5 | 75172.5 | 12552.0 |
| 2024-10-18 | BZ | Futures | 72.29 | 72.7 | 70.32 | 70.88 | 34009.0 |
| 2024-10-18 | C | Futures | 5721.0 | 5867.0 | 5415.0 | 5468.0 | 5938.0 |
| 2024-10-18 | CB | Futures | 289.457 | 289.457 | 285.307 | 285.333 | 53.0 |
| 2024-10-18 | CC | Futures | 6414.0 | 6454.0 | 6065.0 | 6101.0 | 7653.0 |
| 2024-10-18 | CNH | Futures | 7.0796 | 7.0796 | 7.0523 | 7.0602 | 1313.0 |
| 2024-10-18 | CSC | Futures | 2.206 | 2.206 | 2.17 | 2.183 | 67.0 |
| 2024-10-18 | CT | Futures | 77.64 | 78.63 | 77.62 | 77.82 | 16221.0 |
| 2024-10-18 | DC | Futures | 21.56 | 21.63 | 21.18 | 21.31 | 215.0 |
| 2024-10-18 | DX | Futures | 103.307 | 103.337 | 102.998 | 103.025 | 16277.0 |
| 2024-10-18 | E1 | Futures | 1.17272 | 1.17484 | 1.17171 | 1.17383 | 13703.0 |
| 2024-10-18 | E6 | Futures | 1.09033 | 1.09414 | 1.08967 | 1.09374 | 143076.0 |
| 2024-10-18 | E7 | Futures | 1.0899 | 1.0938 | 1.0894 | 1.0934 | 2556.0 |
| 2024-10-18 | EBM | Futures | 252.45 | 252.72 | 246.98 | 247.53 | 33457.0 |
| 2024-10-18 | ER | Futures | 97.78 | 97.815 | 97.775 | 97.81 | 366392.0 |
| 2024-10-18 | ESG | Futures | 519.8 | 521.42 | 519.34 | 520.62 | 865.0 |
| 2024-10-18 | EW | Futures | 3250.2 | 3262.7 | 3241.4 | 3251.1 | 5165.0 |
| 2024-10-18 | FBON | Futures | 126.25 | 126.65 | 126.04 | 126.62 | 119.0 |
| 2024-10-18 | FBTP | Futures | 121.31 | 121.88 | 121.11 | 121.85 | 271916.0 |
| 2024-10-18 | FBTS | Futures | 107.63 | 107.72 | 107.55 | 107.66 | 146706.0 |
| 2024-10-18 | FCE | Futures | 7587.7 | 7662.7 | 7549.7 | 7630.2 | 37821.0 |
| 2024-10-18 | FDAX | Futures | 19866.6 | 19983.8 | 19788.9 | 19971.7 | 30753.0 |
| 2024-10-18 | FDIV | Futures | 196.95 | 196.95 | 196.7 | 196.7 | 1.0 |
| 2024-10-18 | FDXM | Futures | 19818.6 | 19938.5 | 19750.1 | 19928.4 | 19409.0 |
| 2024-10-18 | FDXS | Futures | 19801.4 | 19894.8 | 19703.8 | 19883.8 | 20818.0 |
| 2024-10-18 | FESX | Futures | 4972.0 | 5015.0 | 4950.9 | 5009.0 | 540763.0 |
| 2024-10-18 | FEU3 | Futures | 97.79 | 97.815 | 97.78 | 97.815 | 7732.0 |
| 2024-10-18 | FGBL | Futures | 135.76 | 136.0 | 135.41 | 135.94 | 896271.0 |
| 2024-10-18 | FGBM | Futures | 118.82 | 118.98 | 118.68 | 118.94 | 602836.0 |
| 2024-10-18 | FGBS | Futures | 107.275 | 107.34 | 107.23 | 107.32 | 654985.0 |
| 2024-10-18 | FGBX | Futures | 134.93 | 135.51 | 133.96 | 135.25 | 83807.0 |
| 2024-10-18 | FMWO | Futures | 12332.3 | 12406.9 | 12332.3 | 12389.3 | 2980.0 |
| 2024-10-18 | FOAT | Futures | 126.06 | 126.45 | 125.72 | 126.39 | 178088.0 |
| 2024-10-18 | FSMX | Futures | 27456.1 | 27560.1 | 27450.1 | 27505.1 | 84.0 |
| 2024-10-18 | FTDX | Futures | 3501.8 | 3501.8 | 3501.8 | 3501.8 | 0.0 |
| 2024-10-18 | FTI | Futures | 906.93 | 911.72 | 905.51 | 910.95 | 11259.0 |
| 2024-10-18 | FTUK | Futures | 8428.6 | 8430.1 | 8364.5 | 8407.0 | 78292.0 |
> showing 50 of 130 rows — these rows as CSV