from ethereum.aave.ez_deposits

where block_timestamp::date >= current_date - {{N_Days}}

and symbol is not null

and symbol != 'AAVE'

group by 1

order by 2 DESC

limit 10)

,

aave as ( select symbol , sum(SUPPLIED_USD) as volume

from ethereum.aave.ez_deposits

where block_timestamp::date >= current_date - {{N_Days}}

and symbol is not null

and symbol = 'AAVE'

group by 1)

,

final as ( select *

from deposit

select *

from aave )

select case when symbol = 'AAVE' then 'AAVE Token' else 'Other Tokens' end as type, symbol, *

from final