with Anchor_yield_reserve_external_transfer as (
select
date_trunc('quarter', block_timestamp) as blocktime,
sum(
case
when event_from = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' then -event_amount_usd
else event_amount_usd end
) as amount_received
from terra.transfers
where (event_from = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' or event_to = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8')
group by blocktime
)
select
*
from Anchor_yield_reserve_external_transfer
order by blocktime desc