1SELECT YEAR("date") AS "year", "open"
2FROM (SELECT "date", "open", 
3      ROW_NUMBER() OVER (partition by EXTRACT(YEAR FROM "date"), EXTRACT(MONTH FROM "date") ORDER BY EXTRACT(DAY FROM "date")) AS seq
4      FROM @kaggle.rprkh15_sp500_stock_prices.mmm
5     ) t
6WHERE 
7  seq = 1 AND 
8  MONTH("date")=1 AND 
9  "open" != 0
10ORDER BY "date"