'Desposit' as type,

count(distinct tx_hash) as transactions,

count(distinct depositor_address) as users,

sum(supplied_usd) as volume_usd,

avg(supplied_usd) as average_volume_usd,

median(supplied_usd) as median_volume_usd,

max(supplied_usd) as maximum_volume_usd,

transactions / count(distinct block_timestamp::date) as daily_average_transactions,

users / count(distinct block_timestamp::date) as daily_average_users

from ethereum.aave.ez_deposits

where symbol = 'AAVE'

and block_timestamp::date >= current_date - interval '{{ days }} days'

group by 1

union all

'Withdraw' as type,

count(distinct tx_hash) as transactions,

count(distinct depositor_address) as users,

sum(withdrawn_usd) as volume_usd,

avg(withdrawn_usd) as average_volume_usd,

median(withdrawn_usd) as median_volume_usd,

max(withdrawn_usd) as maximum_volume_usd,

transactions / count(distinct block_timestamp::date) as daily_average_transactions,

users / count(distinct block_timestamp::date) as daily_average_users

from ethereum.aave.ez_withdraws

where symbol = 'AAVE'

and block_timestamp::date >= current_date - interval '{{ days }} days'

group by 1