SELECT YEAR("date"), "open"
FROM @kaggle.rprkh15_sp500_stock_prices.mmm
WHERE
EXTRACT(month FROM "date") = 1 AND
EXTRACT(day FROM "date") = 3
ORDER BY "date" DESC
SELECT YEAR("date"), "open"
FROM @kaggle.rprkh15_sp500_stock_prices.mmm
WHERE
EXTRACT(month FROM "date") = 1 AND
EXTRACT(day FROM "date") = 3
ORDER BY "date" DESC
Anyone who has the link will be able to view this.