case when date = '2021-08-31' then 'August'

when date = '2021-07-31' then 'July'

when date = '2021-06-30' then 'June'

when date = '2021-05-31' then 'May'

when date = '2021-04-30' then 'April'

when date = '2021-03-31' then 'March'

else 'none'

end as months

from terra.daily_balances

where balance_type = 'staked' and address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' and date in ('2021-08-31', '2021-07-31','2021-06-30','2021-05-31','2021-04-30','2021-03-31')

group by 1,3),

rewards as (select date_trunc('month', block_timestamp) as block_months,

case when block_months = '2021-08-01' then 'August'

when block_months = '2021-07-01' then 'July'

when block_months = '2021-06-01' then 'June'

when block_months = '2021-05-01' then 'May'

when block_months = '2021-04-01' then 'April'

when block_months = '2021-03-01' then 'March'

else 'nil'

end as months,

sum(event_amount_usd) as rewards

from terra.reward

where action = 'withdraw_delegator_rewards' and tx_status = 'SUCCEEDED' and block_months between '2021-03-01' and '2021-08-01'

group by 1,2)

select a.months, a.LUNA_staked, b.rewards, b.block_months, (b.rewards/a.LUNA_staked)*100 as APR

from stake a

join rewards b on a.months = b.months