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")
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")
Anyone who has the link will be able to view this.