-- Daily AAVE supplied and withdrawn on Aave protocol.
with dep as (select
'DEPOSIT' as actions,
count(distinct DEPOSITOR_ADDRESS) as users,
count(distinct TX_HASH) as transactions,
sum(SUPPLIED_USD) as value_usd,
sum(ISSUED_TOKENS) as value_aave,
value_aave / users as aave_per_user,
value_aave / transactions as aave_per_txn
from
ethereum.aave.ez_deposits
where
date(BLOCK_TIMESTAMP) >= current_date - {{days_back}}
and symbol ilike 'aave'
),
witd as(
select 'WITHDRAW' as actions,
count(distinct DEPOSITOR_ADDRESS) as users,
count(distinct TX_HASH) as transactions,
sum(WITHDRAWN_USD) as value_usd,
sum(withdrawn_TOKENS) as value_aave,
value_aave / users as aave_per_user,
value_aave / transactions as aave_per_txn
from
ethereum.aave.ez_withdraws
where
date(BLOCK_TIMESTAMP) >= current_date - {{days_back}}
and
symbol ilike 'aave'
)