select
balance_date day,
sum(amount_usd) as dai_balance_usd,
dai_balance_usd - lag(dai_balance_usd,1) OVER (ORDER BY balance_date) daily_balance_change,
sum(dai_balance_usd) OVER (ORDER BY balance_date) AS cumulative_dai_balance_usd
from flipside_prod_db.ethereum.erc20_balances
WHERE symbol='DAI' and BALANCE_DATE>=dateadd('year',-1,current_date)
GROUP BY day order by day