select

block_timestamp::date as date

,count(DEPOSITOR_ADDRESS) as wallets

,sum(WITHDRAWN_TOKENS) as eth_amount

,avg(WITHDRAWN_TOKENS) as avg_amount

,sum(eth_amount) over(order by date) as growth_amount

,sum(wallets) over(order by date) as growth_wallets

from ethereum.aave.ez_withdraws

where block_timestamp::date>=CURRENT_DATE-30

and symbol in( 'WETH','stETH')

group by 1

order by 1

,lst_uniswap as (

select

block_timestamp::date as date

,count(SENDER) as wallets

,sum(abs(AMOUNT0_ADJUSTED)) as eth_amount

,avg(abs(AMOUNT0_ADJUSTED)) as avg_amount

,sum(eth_amount) over(order by date) as growth_amount

,sum(wallets) over(order by date) as growth_wallets

from ethereum.uniswapv3.ez_swaps

where TOKEN0_SYMBOL = 'WETH'

and block_timestamp::date >=CURRENT_DATE-30

group by 1

order by 1

,lst_sushi as (

select

block_timestamp::date as date

,count(ORIGIN_FROM_ADDRESS) as wallets

,sum(AMOUNT_OUT) as eth_amount

,avg(AMOUNT_OUT) as avg_amount

,sum(eth_amount) over(order by date) as growth_amount

,sum(wallets) over(order by date) as growth_wallets