PREVIEW / etf_daily / 2025-10-31
file: by_date/etf_daily/2025/2025-10-31.parquet size: 165 KB rows: 4,334
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-10-31 | SPY | ETF | 685.04 | 685.08 | 679.24 | 682.06 | 87735643.0 |
| 2025-10-31 | QQQ | ETF | 634.17 | 634.2 | 626.69 | 629.07 | 66305147.0 |
| 2025-10-31 | IWM | ETF | 244.99 | 246.79 | 243.69 | 246.23 | 37496148.0 |
| 2025-10-31 | DIA | ETF | 475.86 | 477.16 | 473.42 | 475.67 | 7986207.0 |
| 2025-10-31 | GLD | ETF | 370.47 | 370.6625 | 365.5 | 368.12 | 11075297.0 |
| 2025-10-31 | TLT | ETF | 90.56 | 90.66 | 90.2 | 90.29 | 38378230.0 |
| 2025-10-31 | AAA | ETF | 24.99 | 25.02 | 24.96 | 24.9851 | 8338.0 |
| 2025-10-31 | AAAU | ETF | 39.75 | 39.76 | 39.215 | 39.48 | 2562480.0 |
| 2025-10-31 | AADR | ETF | 84.42 | 85.0239 | 84.42 | 84.8402 | 828.0 |
| 2025-10-31 | AAPB | ETF | 34.96 | 35.1355 | 33.15 | 33.4903 | 331505.0 |
| 2025-10-31 | AAPD | ETF | 12.88 | 13.2512 | 12.86 | 13.19 | 3624816.0 |
| 2025-10-31 | AAPR | ETF | 28.05 | 28.1 | 28.03 | 28.0613 | 724.0 |
| 2025-10-31 | AAPU | ETF | 37.78 | 37.89 | 35.74 | 36.02 | 5572579.0 |
| 2025-10-31 | AAPW | ETF | 44.11 | 44.11 | 42.44 | 42.72 | 17991.0 |
| 2025-10-31 | AAPX | ETF | 32.65 | 32.65 | 30.93 | 31.23 | 352107.0 |
| 2025-10-31 | AAPY | ETF | 24.91 | 24.9648 | 24.82 | 24.89 | 3057.0 |
| 2025-10-31 | AAVM | ETF | 28.91 | 28.9388 | 28.86 | 28.9172 | 1402.0 |
| 2025-10-31 | AAXJ | ETF | 94.87 | 94.915 | 94.38 | 94.77 | 353660.0 |
| 2025-10-31 | ABCS | ETF | 29.275 | 29.3638 | 29.2275 | 29.3638 | 3389.0 |
| 2025-10-31 | ABEQ | ETF | 34.52 | 34.64 | 34.4885 | 34.615 | 7277.0 |
| 2025-10-31 | ABFL | ETF | 72.28 | 72.46 | 71.8971 | 72.25 | 56256.0 |
| 2025-10-31 | ABLD | ETF | 28.4 | 28.5732 | 28.4 | 28.5349 | 3804.0 |
| 2025-10-31 | ABLG | ETF | 31.39 | 31.4836 | 31.34 | 31.4836 | 3071.0 |
| 2025-10-31 | ABNY | ETF | 48.8 | 48.8 | 48.05 | 48.296 | 1286.0 |
| 2025-10-31 | ABOT | ETF | 40.63 | 40.65 | 40.6118 | 40.6118 | 1064.0 |
| 2025-10-31 | ABXB | ETF | 19.7006 | 19.715 | 19.7 | 19.7096 | 883.0 |
| 2025-10-31 | ACES | ETF | 34.62 | 35.21 | 34.6 | 35.15 | 16269.0 |
| 2025-10-31 | ACGR | ETF | 67.66 | 67.69 | 67.5199 | 67.5199 | 5807.0 |
| 2025-10-31 | ACIO | ETF | 44.33 | 44.33 | 43.94 | 44.04 | 110637.0 |
| 2025-10-31 | ACLC | ETF | 78.7801 | 78.94 | 78.65 | 78.7524 | 4665.0 |
| 2025-10-31 | ACSI | ETF | 66.4211 | 66.4211 | 66.4211 | 66.4211 | 67.0 |
| 2025-10-31 | ACVF | ETF | 49.66 | 49.66 | 49.35 | 49.4631 | 6447.0 |
| 2025-10-31 | ACWI | ETF | 141.61 | 141.89 | 140.82 | 141.41 | 3685249.0 |
| 2025-10-31 | ACWV | ETF | 118.1 | 118.37 | 117.87 | 118.17 | 178674.0 |
| 2025-10-31 | ACWX | ETF | 66.43 | 66.43 | 66.0735 | 66.35 | 1573014.0 |
| 2025-10-31 | ADBG | ETF | 9.88 | 10.0 | 9.7529 | 9.9537 | 479448.0 |
| 2025-10-31 | ADFI | ETF | 8.605 | 8.6199 | 8.59 | 8.605 | 28243.0 |
| 2025-10-31 | ADIV | ETF | 18.3 | 18.3499 | 18.27 | 18.29 | 5506.0 |
| 2025-10-31 | ADME | ETF | 51.89 | 51.9555 | 51.58 | 51.7932 | 10219.0 |
| 2025-10-31 | ADPV | ETF | 43.289 | 43.38 | 42.8606 | 43.3212 | 8883.0 |
| 2025-10-31 | ADVE | ETF | 38.94 | 39.0229 | 38.94 | 39.0229 | 364.0 |
| 2025-10-31 | AESR | ETF | 20.88 | 21.07 | 20.88 | 21.04 | 52116.0 |
| 2025-10-31 | AETH | ETF | 39.345 | 39.345 | 39.275 | 39.33 | 416.0 |
| 2025-10-31 | AFIF | ETF | 9.4184 | 9.45 | 9.4101 | 9.437 | 44703.0 |
| 2025-10-31 | AFIX | ETF | 25.3044 | 25.3044 | 25.3044 | 25.3044 | 49.0 |
| 2025-10-31 | AFK | ETF | 24.01 | 24.098 | 23.825 | 23.94 | 28251.0 |
| 2025-10-31 | AFLG | ETF | 39.26 | 39.26 | 38.92 | 39.09 | 47322.0 |
| 2025-10-31 | AFMC | ETF | 33.56 | 33.62 | 33.37 | 33.495 | 8256.0 |
| 2025-10-31 | AFSC | ETF | 29.62 | 29.66 | 29.55 | 29.5793 | 1808.0 |
| 2025-10-31 | AFSM | ETF | 32.08 | 32.12 | 31.74 | 31.9193 | 23830.0 |
> showing 50 of 4,334 rows — these rows as CSV