Baselight
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
"year"(date)open
2022174.84581658196225
2020162.19191172840348
2019166.88569809914108
2018202.97457668274043
2017150.870174718527
2014108.1507041026763
201372.11387228845084
201262.34653819122551
201162.93799706111401
200855.11007988251202
200750.406533795264544
200649.36888871068309
200551.05037951733654
200337.78510716408443
200234.293130042250525
200133.89263809163627
200026.9075248895102
199722.36197016443123
199616.626477394879636
199512.649107833703358
199412.37526521292346
199210.19150804720427
19918.752216678893495
19908.031961137797976
19895.902750968933106
19863.867364330480328
19853.272910025024414
19843.283848852822275
19832.832015639279076
19801.572107438978396
19791.978152148615869
19781.4517761153333328
19771.6292604970932003
19751.2465861288167663
19742.1447722054430365
19732.3059321441203573
19721.7925874153623886
19690
19680
19670
19660
19640
19630
19620

Share link

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