Where to Get Daily NAV History for US Mutual Funds in SQL

select date, close as nav, adjusted_close
from security_price_history_vw
where exchange_code = 'US' and code = 'VFINX'
order by date desc;

select s.code, s.name, min(p.date) as first_nav, max(p.date) as latest_nav
from security_vw s
join security_price_history_vw p
    on p.code = s.code and p.exchange_code = s.exchange_code
where s.asset_class = 'fund'
  and s.name ilike '%wellington%'
group by s.code, s.name
order by first_nav;

select last_day(date) as month_end, code, max_by(close, date) as nav
from security_price_history_vw
where exchange_code = 'US'
  and code in ('VFINX', 'DODGX')
  and date >= '2026-07-01'
group by 1, 2
order by code, month_end;

with px as (
    select code, date, close as nav, adjusted_close
    from security_price_history_vw
    where exchange_code = 'US'
      and code in ('VFINX', 'AGTHX', 'DODGX', 'PRWCX', 'FCNTX')
      and date >= '2006-11-06'
)
select code,
       min_by(nav, date) as start_nav,
       max_by(nav, date) as end_nav,
       round(max_by(nav, date) / min_by(nav, date) - 1, 3) as nav_change,
       round(max_by(adjusted_close, date) / min_by(adjusted_close, date) - 1, 3) as total_return
from px
group by code
order by code;