PREVIEW / futures_daily / 2024-10-31
file: by_date/futures_daily/2024/2024-10-31.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-31 | ES | Futures | 5974.57 | 5978.67 | 5865.36 | 5870.73 | 1973513.0 |
| 2024-10-31 | NQ | Futures | 21008.74 | 21022.84 | 20523.06 | 20536.65 | 686677.0 |
| 2024-10-31 | YM | Futures | 42776.9 | 42802.2 | 42313.1 | 42387.9 | 154927.0 |
| 2024-10-31 | CL | Futures | 66.88 | 68.53 | 66.1 | 67.03 | 311055.0 |
| 2024-10-31 | GC | Futures | 2858.0 | 2860.1 | 2799.5 | 2807.1 | 242571.0 |
| 2024-10-31 | ZN | Futures | 110.592645 | 110.764737 | 110.27975 | 110.608289 | 3372923.0 |
| 2024-10-31 | A6 | Futures | 0.65729 | 0.65839 | 0.65395 | 0.65744 | 83955.0 |
| 2024-10-31 | AD | Futures | 0.72193 | 0.72253 | 0.71968 | 0.72158 | 89901.0 |
| 2024-10-31 | ALI | Futures | 2657.8 | 2687.99 | 2642.71 | 2652.43 | 516.0 |
| 2024-10-31 | B | Futures | 71.95 | 73.7 | 71.26 | 72.24 | 391906.0 |
| 2024-10-31 | B6 | Futures | 1.296 | 1.2994 | 1.2838 | 1.2876 | 164794.0 |
| 2024-10-31 | BFX | Futures | 4225.9 | 4225.9 | 4225.9 | 4225.9 | 0.0 |
| 2024-10-31 | BR | Futures | 0.16884 | 0.16889 | 0.16738 | 0.16816 | 15745.0 |
| 2024-10-31 | BTC | Futures | 79236.1 | 79571.3 | 75765.7 | 76181.9 | 11205.0 |
| 2024-10-31 | BZ | Futures | 70.53 | 72.25 | 69.84 | 70.81 | 36772.0 |
| 2024-10-31 | C | Futures | 5800.0 | 5817.0 | 5713.0 | 5732.0 | 4155.0 |
| 2024-10-31 | CB | Futures | 283.18 | 285.8 | 282.195 | 284.425 | 19.0 |
| 2024-10-31 | CC | Futures | 6031.0 | 6106.0 | 5898.0 | 6006.0 | 6597.0 |
| 2024-10-31 | CNH | Futures | 7.0762 | 7.0826 | 7.0717 | 7.0737 | 511.0 |
| 2024-10-31 | CSC | Futures | 2.0 | 2.027 | 1.987 | 1.987 | 401.0 |
| 2024-10-31 | CT | Futures | 76.87 | 76.87 | 75.93 | 76.27 | 24518.0 |
| 2024-10-31 | DC | Futures | 19.65 | 19.79 | 19.39 | 19.42 | 1331.0 |
| 2024-10-31 | DX | Futures | 103.716 | 103.826 | 103.422 | 103.594 | 27933.0 |
| 2024-10-31 | E1 | Futures | 1.1705 | 1.17489 | 1.1705 | 1.17373 | 28720.0 |
| 2024-10-31 | E6 | Futures | 1.09244 | 1.0954 | 1.09098 | 1.09359 | 227720.0 |
| 2024-10-31 | E7 | Futures | 1.0919 | 1.0949 | 1.0906 | 1.0932 | 3967.0 |
| 2024-10-31 | EBM | Futures | 238.79 | 240.97 | 237.15 | 238.24 | 28619.0 |
| 2024-10-31 | ER | Futures | 97.79 | 97.805 | 97.76 | 97.78 | 326157.0 |
| 2024-10-31 | ESG | Futures | 510.85 | 510.85 | 505.13 | 505.46 | 609.0 |
| 2024-10-31 | EW | Futures | 3186.3 | 3197.7 | 3133.8 | 3144.7 | 10788.0 |
| 2024-10-31 | FBON | Futures | 124.07 | 124.46 | 123.77 | 124.29 | 207.0 |
| 2024-10-31 | FBTP | Futures | 118.98 | 119.24 | 118.44 | 119.04 | 470125.0 |
| 2024-10-31 | FBTS | Futures | 106.89 | 106.98 | 106.67 | 106.88 | 326239.0 |
| 2024-10-31 | FCE | Futures | 7408.8 | 7435.3 | 7322.8 | 7357.8 | 44562.0 |
| 2024-10-31 | FDAX | Futures | 19507.2 | 19511.2 | 19283.0 | 19338.5 | 49126.0 |
| 2024-10-31 | FDIV | Futures | 189.48 | 189.48 | 188.68 | 189.13 | 4.0 |
| 2024-10-31 | FDXM | Futures | 19475.0 | 19476.0 | 19240.3 | 19296.7 | 34504.0 |
| 2024-10-31 | FDXS | Futures | 19435.4 | 19436.4 | 19199.2 | 19253.5 | 29677.0 |
| 2024-10-31 | FESX | Futures | 4897.8 | 4902.8 | 4825.7 | 4841.7 | 945836.0 |
| 2024-10-31 | FEU3 | Futures | 97.795 | 97.795 | 97.765 | 97.785 | 6021.0 |
| 2024-10-31 | FGBL | Futures | 133.2 | 133.65 | 132.86 | 133.52 | 1862063.0 |
| 2024-10-31 | FGBM | Futures | 117.32 | 117.61 | 117.05 | 117.52 | 1386930.0 |
| 2024-10-31 | FGBS | Futures | 106.828 | 106.899 | 106.688 | 106.853 | 1348940.0 |
| 2024-10-31 | FGBX | Futures | 131.1 | 132.84 | 130.62 | 132.66 | 201478.0 |
| 2024-10-31 | FMWO | Futures | 12135.4 | 12158.2 | 12016.2 | 12050.4 | 10684.0 |
| 2024-10-31 | FOAT | Futures | 123.78 | 124.2 | 123.5 | 124.07 | 295634.0 |
| 2024-10-31 | FSMX | Futures | 26637.8 | 26686.8 | 26365.7 | 26413.7 | 516.0 |
| 2024-10-31 | FTDX | Futures | 3381.2 | 3389.3 | 3344.2 | 3356.9 | 36.0 |
| 2024-10-31 | FTI | Futures | 883.72 | 885.08 | 876.21 | 880.61 | 8385.0 |
| 2024-10-31 | FTUK | Futures | 8192.6 | 8202.2 | 8104.0 | 8142.5 | 129004.0 |
> showing 50 of 130 rows — these rows as CSV