PREVIEW / futures_daily / 2025-08-27
file: by_date/futures_daily/2025/2025-08-27.parquet size: 8 KB rows: 84
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-08-27 | ES | Futures | 6486.75 | 6505.5 | 6459.25 | 6496.0 | 957730.0 |
| 2025-08-27 | NQ | Futures | 23604.0 | 23689.0 | 23434.75 | 23628.75 | 436560.0 |
| 2025-08-27 | YM | Futures | 45510.0 | 45700.0 | 45446.0 | 45642.0 | 64387.0 |
| 2025-08-27 | ZN | Futures | 112.15625 | 112.453125 | 112.03125 | 112.40625 | 1549404.0 |
| 2025-08-27 | A6 | Futures | 0.6496 | 0.65155 | 0.64645 | 0.6512 | 64305.0 |
| 2025-08-27 | AD | Futures | 0.7235 | 0.72625 | 0.7223 | 0.72555 | 55813.0 |
| 2025-08-27 | B6 | Futures | 1.3479 | 1.3505 | 1.342 | 1.35 | 49567.0 |
| 2025-08-27 | BFX | Futures | 4842.5 | 4842.5 | 4842.5 | 4842.5 | 0.0 |
| 2025-08-27 | BR | Futures | 0.18085 | 0.18085 | 0.18085 | 0.18085 | 0.0 |
| 2025-08-27 | BTC | Futures | 112300.0 | 113460.0 | 111100.0 | 112880.0 | 6292.0 |
| 2025-08-27 | CB | Futures | 233.0 | 233.0 | 227.25 | 228.0 | 154.0 |
| 2025-08-27 | CC | Futures | 7695.0 | 7958.0 | 7675.0 | 7904.0 | 7690.0 |
| 2025-08-27 | CNH | Futures | 7.1425 | 7.155 | 7.137 | 7.142 | 1903.0 |
| 2025-08-27 | CSC | Futures | 1.815 | 1.815 | 1.802 | 1.803 | 109.0 |
| 2025-08-27 | CT | Futures | 67.3 | 67.43 | 66.77 | 67.43 | 211.0 |
| 2025-08-27 | DC | Futures | 18.01 | 18.03 | 17.73 | 17.74 | 89.0 |
| 2025-08-27 | DX | Futures | 98.175 | 98.64 | 98.055 | 98.127 | 16978.0 |
| 2025-08-27 | E1 | Futures | 1.2478 | 1.25065 | 1.2411 | 1.2491 | 17657.0 |
| 2025-08-27 | E6 | Futures | 1.16575 | 1.16625 | 1.15885 | 1.16455 | 141641.0 |
| 2025-08-27 | E7 | Futures | 1.1658 | 1.1662 | 1.1588 | 1.1646 | 3579.0 |
| 2025-08-27 | ESG | Futures | 563.78 | 565.4 | 563.34 | 564.88 | 56.0 |
| 2025-08-27 | EW | Futures | 3256.0 | 3280.5 | 3239.5 | 3273.6 | 10919.0 |
| 2025-08-27 | FBON | Futures | 123.28 | 123.32 | 122.91 | 123.13 | 74.0 |
| 2025-08-27 | FBTP | Futures | 120.44 | 120.61 | 120.06 | 120.33 | 419923.0 |
| 2025-08-27 | FGBL | Futures | 129.46 | 129.83 | 129.33 | 129.78 | 1064549.0 |
| 2025-08-27 | FGBM | Futures | 117.41 | 117.61 | 117.36 | 117.59 | 894255.0 |
| 2025-08-27 | FTI | Futures | 909.45 | 910.15 | 904.5 | 908.73 | 7378.0 |
| 2025-08-27 | GF | Futures | 365.0 | 370.0 | 363.775 | 365.4 | 10106.0 |
| 2025-08-27 | GSCI | Futures | 544.1 | 546.65 | 544.1 | 546.65 | 8.0 |
| 2025-08-27 | HE | Futures | 93.425 | 94.825 | 93.4 | 93.9 | 31428.0 |
| 2025-08-27 | HRC | Futures | 826.0 | 826.0 | 805.0 | 813.0 | 288.0 |
| 2025-08-27 | J1 | Futures | 0.0068015 | 0.0068035 | 0.0067625 | 0.0067985 | 120595.0 |
| 2025-08-27 | J7 | Futures | 0.006797 | 0.006803 | 0.006763 | 0.006799 | 170.0 |
| 2025-08-27 | JB | Futures | 135.53 | 135.73 | 135.52 | 135.69 | 1146.0 |
| 2025-08-27 | KC | Futures | 347.69 | 362.06 | 341.69 | 360.89 | 19179.0 |
| 2025-08-27 | KE | Futures | 518.49 | 518.99 | 510.73 | 513.73 | 39342.0 |
| 2025-08-27 | KRW | Futures | 0.000717 | 0.0007183 | 0.0007161 | 0.0007183 | 11.0 |
| 2025-08-27 | LBS | Futures | 573.5 | 576.5 | 556.0 | 560.0 | 768.0 |
| 2025-08-27 | LE | Futures | 238.225 | 242.075 | 237.65 | 239.525 | 41707.0 |
| 2025-08-27 | M2K | Futures | 2365.7 | 2382.9 | 2355.1 | 2379.7 | 46176.0 |
| 2025-08-27 | MBT | Futures | 112085.0 | 113430.0 | 111095.0 | 112880.0 | 10676.0 |
| 2025-08-27 | MES | Futures | 6486.75 | 6507.0 | 6459.0 | 6496.0 | 660826.0 |
| 2025-08-27 | MET | Futures | 4654.5 | 4702.5 | 4554.0 | 4604.5 | 25491.0 |
| 2025-08-27 | MFS | Futures | 2731.2 | 2731.2 | 2709.0 | 2727.8 | 19789.0 |
| 2025-08-27 | MME | Futures | 1275.9 | 1279.1 | 1259.8 | 1267.6 | 76566.0 |
| 2025-08-27 | MNQ | Futures | 23607.25 | 23685.0 | 23429.0 | 23628.75 | 1159053.0 |
| 2025-08-27 | MP | Futures | 0.0535 | 0.05353 | 0.05308 | 0.05347 | 52167.0 |
| 2025-08-27 | N6 | Futures | 0.5865 | 0.58695 | 0.5823 | 0.5865 | 25194.0 |
| 2025-08-27 | NIY | Futures | 42505.0 | 42610.0 | 42255.0 | 42565.0 | 10073.0 |
| 2025-08-27 | NKD | Futures | 42560.0 | 42635.0 | 42275.0 | 42580.0 | 2096.0 |
> showing 50 of 84 rows — these rows as CSV