PREVIEW / futures_daily / 2026-07-31
file: by_date/futures_daily/2026/2026-07-31.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 |
|---|---|---|---|---|---|---|---|
| 2026-07-31 | ES | Futures | 7479.5 | 7541.0 | 7427.5 | 7519.25 | 1831952.0 |
| 2026-07-31 | NQ | Futures | 28317.0 | 28725.75 | 28079.75 | 28404.25 | 679547.0 |
| 2026-07-31 | YM | Futures | 52395.0 | 52772.0 | 52124.0 | 52635.0 | 89322.0 |
| 2026-07-31 | CL | Futures | 83.92 | 86.87 | 81.06 | 84.67 | 257851.0 |
| 2026-07-31 | GC | Futures | 4163.9 | 4170.7 | 4076.4 | 4107.0 | 110633.0 |
| 2026-07-31 | ZN | Futures | 108.484375 | 108.671875 | 107.984375 | 108.0 | 2744859.0 |
| 2026-07-31 | A6 | Futures | 0.7023 | 0.7039 | 0.69865 | 0.7032 | 112090.0 |
| 2026-07-31 | AD | Futures | 0.7153 | 0.71545 | 0.7126 | 0.71465 | 97735.0 |
| 2026-07-31 | ALI | Futures | 3360.75 | 3364.25 | 3338.0 | 3364.25 | 46.0 |
| 2026-07-31 | B | Futures | 87.25 | 91.36 | 84.62 | 87.93 | 375224.0 |
| 2026-07-31 | B6 | Futures | 1.3467 | 1.3494 | 1.34 | 1.3482 | 126679.0 |
| 2026-07-31 | BFX | Futures | 5692.0 | 5692.0 | 5692.0 | 5692.0 | 0.0 |
| 2026-07-31 | BR | Futures | 0.1958 | 0.19625 | 0.19515 | 0.19575 | 21108.0 |
| 2026-07-31 | BTC | Futures | 65080.0 | 65800.0 | 62400.0 | 63130.0 | 12001.0 |
| 2026-07-31 | BZ | Futures | 87.1 | 90.24 | 84.54 | 87.93 | 46811.0 |
| 2026-07-31 | C | Futures | 3810.0 | 4085.0 | 3810.0 | 4011.0 | 10311.0 |
| 2026-07-31 | CB | Futures | 156.975 | 162.5 | 156.975 | 160.75 | 108.0 |
| 2026-07-31 | CC | Futures | 5168.0 | 5510.0 | 5138.0 | 5397.0 | 19044.0 |
| 2026-07-31 | CNH | Futures | 6.7285 | 6.7355 | 6.723 | 6.7335 | 1161.0 |
| 2026-07-31 | CSC | Futures | 1.64 | 1.69 | 1.64 | 1.686 | 372.0 |
| 2026-07-31 | CT | Futures | 79.75 | 80.5 | 79.6 | 80.5 | 24.0 |
| 2026-07-31 | DC | Futures | 17.08 | 17.58 | 16.98 | 17.53 | 780.0 |
| 2026-07-31 | DX | Futures | 99.94 | 100.33 | 99.58 | 99.789 | 33552.0 |
| 2026-07-31 | E1 | Futures | 1.24795 | 1.24815 | 1.23585 | 1.243 | 47737.0 |
| 2026-07-31 | E6 | Futures | 1.15475 | 1.1567 | 1.14745 | 1.155 | 290474.0 |
| 2026-07-31 | E7 | Futures | 1.1548 | 1.1567 | 1.1474 | 1.155 | 4650.0 |
| 2026-07-31 | EBM | Futures | 227.5 | 228.75 | 222.5 | 222.75 | 53800.0 |
| 2026-07-31 | ER | Futures | 97.415 | 97.425 | 97.4 | 97.405 | 84646.0 |
| 2026-07-31 | ESG | Futures | 665.3 | 668.54 | 659.46 | 667.04 | 474.0 |
| 2026-07-31 | EW | Futures | 3783.3 | 3803.0 | 3742.2 | 3772.9 | 15201.0 |
| 2026-07-31 | FBON | Futures | 120.43 | 120.46 | 119.62 | 119.69 | 9.0 |
| 2026-07-31 | FBTP | Futures | 116.69 | 116.72 | 115.98 | 116.22 | 260552.0 |
| 2026-07-31 | FBTS | Futures | 106.47 | 106.485 | 106.3 | 106.345 | 170532.0 |
| 2026-07-31 | FCE | Futures | 8527.0 | 8589.5 | 8492.0 | 8521.0 | 33687.0 |
| 2026-07-31 | FDAX | Futures | 25800.0 | 25974.0 | 25628.0 | 25710.0 | 23629.0 |
| 2026-07-31 | FDIV | Futures | 223.95 | 223.95 | 222.15 | 222.15 | 35.0 |
| 2026-07-31 | FDXM | Futures | 25799.0 | 25976.0 | 25628.0 | 25710.0 | 21028.0 |
| 2026-07-31 | FDXS | Futures | 25780.0 | 25975.0 | 25628.0 | 25710.0 | 22408.0 |
| 2026-07-31 | FESX | Futures | 6389.0 | 6442.0 | 6350.0 | 6373.0 | 595922.0 |
| 2026-07-31 | FEU3 | Futures | 97.42 | 97.42 | 97.4 | 97.41 | 14481.0 |
| 2026-07-31 | FGBL | Futures | 124.76 | 124.94 | 124.12 | 124.36 | 1182981.0 |
| 2026-07-31 | FGBM | Futures | 114.05 | 114.15 | 113.72 | 113.84 | 910238.0 |
| 2026-07-31 | FGBS | Futures | 105.535 | 105.565 | 105.41 | 105.455 | 744250.0 |
| 2026-07-31 | FGBX | Futures | 106.38 | 106.78 | 105.4 | 105.82 | 186497.0 |
| 2026-07-31 | FMWO | Futures | 15733.0 | 15781.0 | 15575.0 | 15638.0 | 7822.0 |
| 2026-07-31 | FOAT | Futures | 117.51 | 117.73 | 116.88 | 117.13 | 287349.0 |
| 2026-07-31 | FSMX | Futures | 32490.0 | 32615.0 | 32090.0 | 32130.0 | 112.0 |
| 2026-07-31 | FTDX | Futures | 3844.0 | 3844.0 | 3844.0 | 3844.0 | 0.0 |
| 2026-07-31 | FTI | Futures | 1105.3 | 1107.9 | 1091.4 | 1094.72 | 8626.0 |
| 2026-07-31 | FTUK | Futures | 10936.0 | 10981.5 | 10818.0 | 10865.0 | 85942.0 |
> showing 50 of 129 rows — these rows as CSV