PREVIEW / futures_daily / 2025-07-31
file: by_date/futures_daily/2025/2025-07-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 |
|---|---|---|---|---|---|---|---|
| 2025-07-31 | ES | Futures | 6435.5 | 6468.5 | 6357.5 | 6374.25 | 1857020.0 |
| 2025-07-31 | NQ | Futures | 23705.0 | 23845.0 | 23290.5 | 23365.0 | 739642.0 |
| 2025-07-31 | YM | Futures | 44725.0 | 44852.0 | 44208.0 | 44305.0 | 106830.0 |
| 2025-07-31 | CL | Futures | 70.3 | 70.41 | 68.56 | 69.26 | 247031.0 |
| 2025-07-31 | GC | Futures | 3327.5 | 3366.7 | 3324.4 | 3348.6 | 158029.0 |
| 2025-07-31 | ZN | Futures | 111.015625 | 111.3125 | 110.921875 | 111.0625 | 2076804.0 |
| 2025-07-31 | A6 | Futures | 0.64385 | 0.64815 | 0.6429 | 0.64365 | 78471.0 |
| 2025-07-31 | AD | Futures | 0.72455 | 0.7256 | 0.7232 | 0.72385 | 66780.0 |
| 2025-07-31 | ALI | Futures | 2544.0 | 2557.5 | 2483.5 | 2493.0 | 294.0 |
| 2025-07-31 | B | Futures | 72.78 | 72.82 | 71.0 | 71.7 | 357391.0 |
| 2025-07-31 | B6 | Futures | 1.3237 | 1.3288 | 1.3191 | 1.3224 | 103240.0 |
| 2025-07-31 | BFX | Futures | 4639.5 | 4639.5 | 4639.5 | 4639.5 | 0.0 |
| 2025-07-31 | BR | Futures | 0.17784 | 0.17904 | 0.17718 | 0.17804 | 19636.0 |
| 2025-07-31 | BTC | Futures | 117985.0 | 119785.0 | 117095.0 | 117435.0 | 8517.0 |
| 2025-07-31 | BZ | Futures | 72.6 | 72.81 | 71.01 | 71.7 | 56020.0 |
| 2025-07-31 | C | Futures | 5446.0 | 5723.0 | 5430.0 | 5658.0 | 3578.0 |
| 2025-07-31 | CB | Futures | 258.25 | 258.25 | 257.225 | 257.25 | 51.0 |
| 2025-07-31 | CC | Futures | 7608.0 | 7888.0 | 7549.0 | 7846.0 | 7056.0 |
| 2025-07-31 | CNH | Futures | 7.179 | 7.195 | 7.1715 | 7.187 | 1893.0 |
| 2025-07-31 | CSC | Futures | 1.799 | 1.83 | 1.792 | 1.826 | 379.0 |
| 2025-07-31 | CT | Futures | 67.52 | 68.34 | 67.52 | 67.63 | 65.0 |
| 2025-07-31 | DC | Futures | 17.38 | 17.71 | 17.3 | 17.67 | 1153.0 |
| 2025-07-31 | DX | Futures | 99.58 | 99.885 | 99.31 | 99.743 | 23582.0 |
| 2025-07-31 | E1 | Futures | 1.2335 | 1.23935 | 1.2335 | 1.23775 | 22663.0 |
| 2025-07-31 | E6 | Futures | 1.14375 | 1.1494 | 1.1437 | 1.14605 | 185716.0 |
| 2025-07-31 | E7 | Futures | 1.1431 | 1.1493 | 1.1431 | 1.1461 | 5303.0 |
| 2025-07-31 | EBM | Futures | 198.75 | 199.5 | 196.0 | 196.25 | 42514.0 |
| 2025-07-31 | ER | Futures | 98.0 | 98.01 | 98.0 | 98.01 | 132841.0 |
| 2025-07-31 | ESG | Futures | 557.88 | 559.22 | 551.38 | 552.58 | 766.0 |
| 2025-07-31 | EW | Futures | 3175.4 | 3203.5 | 3158.6 | 3165.1 | 13170.0 |
| 2025-07-31 | FBON | Futures | 123.47 | 123.47 | 123.26 | 123.42 | 13.0 |
| 2025-07-31 | FBTP | Futures | 120.8 | 120.94 | 120.57 | 120.76 | 284329.0 |
| 2025-07-31 | FBTS | Futures | 107.735 | 107.77 | 107.69 | 107.735 | 140260.0 |
| 2025-07-31 | FCE | Futures | 7903.0 | 7920.0 | 7753.5 | 7778.5 | 50813.0 |
| 2025-07-31 | FDAX | Futures | 24376.0 | 24510.0 | 24041.0 | 24161.0 | 31826.0 |
| 2025-07-31 | FDIV | Futures | 204.2 | 204.2 | 203.0 | 203.0 | 20.0 |
| 2025-07-31 | FDXM | Futures | 24385.0 | 24509.0 | 24041.0 | 24161.0 | 24309.0 |
| 2025-07-31 | FDXS | Futures | 24400.0 | 24510.0 | 24040.0 | 24161.0 | 19782.0 |
| 2025-07-31 | FESX | Futures | 5418.0 | 5439.0 | 5314.0 | 5340.0 | 715742.0 |
| 2025-07-31 | FEU3 | Futures | 98.005 | 98.01 | 98.005 | 98.01 | 3277.0 |
| 2025-07-31 | FGBL | Futures | 129.51 | 129.83 | 129.46 | 129.7 | 907925.0 |
| 2025-07-31 | FGBM | Futures | 117.2 | 117.34 | 117.15 | 117.27 | 724597.0 |
| 2025-07-31 | FGBS | Futures | 107.05 | 107.075 | 107.015 | 107.05 | 630640.0 |
| 2025-07-31 | FGBX | Futures | 116.66 | 117.58 | 116.64 | 117.38 | 118480.0 |
| 2025-07-31 | FMWO | Futures | 13204.0 | 13271.0 | 13053.0 | 13154.0 | 10791.0 |
| 2025-07-31 | FOAT | Futures | 123.08 | 123.44 | 123.06 | 123.29 | 224216.0 |
| 2025-07-31 | FSMX | Futures | 31135.0 | 31310.0 | 30955.0 | 31135.0 | 328.0 |
| 2025-07-31 | FTDX | Futures | 3932.0 | 3945.5 | 3864.0 | 3864.5 | 28.0 |
| 2025-07-31 | FTI | Futures | 909.6 | 912.7 | 894.85 | 898.17 | 9000.0 |
| 2025-07-31 | FTUK | Futures | 9144.0 | 9182.5 | 9099.0 | 9124.0 | 77489.0 |
> showing 50 of 130 rows — these rows as CSV