-- forked from forgash / ANC yield reserve balance [T33] @ https://flipsidecrypto.xyz/forgash/q/Sdjhuo62gIJi/anc-yield-reserve-balance-t33]
SELECT
date_trunc('d', date) as date,
balance as daily_ust_balance
FROM terra.classic.dim_daily_balances
WHERE address = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8'
AND currency = 'UST'
and date > '2021-06-16T23:59:59Z'
and date < '2022-05-14T23:59:59Z'