Skip to content

Instantly share code, notes, and snippets.

View alcheng10's full-sized avatar

Albert Cheng alcheng10

1 follower · 2 following
View GitHub Profile
@alcheng10
alcheng10 / ASX_200_Cumulative_Percentage_Growth_By_Quarter.md
Last active May 9, 2020 10:27
BigQuery SQL to get the Adjusted Closing Price for the Last Trading Day in every Quarter (via dimension date table)

BigQuery SQL to get the Adjusted Closing Price for the Last Trading Day in every Quarter (via dimension date table)

WITH 
ASX_DATA AS (
  SELECT 
    'ASX 200 (XJO)' AS Index
    ,DT.Date
    ,DT.Month
    ,DT.Year
    ,DT.Quarter