select sender,

currency,

contract_label,

sum (amount) as currency_withdrawals,

sum (amount_usd) as USD_withdrawals,

count (tx_id) as number_txs

from anchor.collateral where event_type = 'withdraw'

and block_timestamp > '2022-05-07'

and amount_usd > 100000

group by 1,2,3

order by 5 desc

),

Anchor_redeem as (

select sender,

currency,

contract_label,

sum (amount) as currency_withdrawals,

sum (amount_usd) as USD_withdrawals,

count (tx_id) as number_txs from anchor.redeem

where block_timestamp >= '2022-05-07'

and amount > 1000000

group by 1,2,3

order by 5 desc

)

select collateral.sender,

collateral.contract_label,

collateral.USD_withdrawals as collateral_withdrawal_USD,

redeem.currency_withdrawals as withdrawals_aUST

from Anchor_collateral collateral

inner join Anchor_redeem redeem

on collateral.sender = redeem.sender