Baselight
SELECT EXTRACT(year FROM "date") as "year", avg("close")
FROM @kaggle.benjaminpo_s_and_p_500_with_dividends_and_splits_daily_updated.near_usd
GROUP BY EXTRACT(year FROM "date")
ORDER BY EXTRACT(year FROM "date")
yearavg("close")
20200.9361473412453374
20215.627414438822498
20226.932446078078388
20231.7416753760755879
20245.28067183885418
20255.289275190104609

Share link

Anyone who has the link will be able to view this.