select POOL_ADDRESS

from ethereum.uniswapv3.ez_pools

where pool_name ilike '%ETH%'

group by 1

),

uniswap as (select block_timestamp::date daily,

count (DISTINCT tx_hash) num_transactions ,

count (DISTINCT LIQUIDITY_PROVIDER) num_wallets ,

sum (iff(TOKEN0_SYMBOL ilike '%ETH%',zeroifnull(AMOUNT0_ADJUSTED),zeroifnull(AMOUNT1_ADJUSTED))) volume,

sum (iff(TOKEN0_SYMBOL ilike '%ETH%',zeroifnull(AMOUNT0_USD),zeroifnull(AMOUNT1_USD))) volume_usd,

sum (volume) over (order by daily) cum_volume ,

sum (volume_usd) over (order by daily) cum_volume_usd

from ethereum.uniswapv3.ez_lp_actions

where POOL_ADDRESS in (select * from uni_ETH_pools)

and action ='DECREASE_LIQUIDITY'

and BLOCK_TIMESTAMP::date >= CURRENT_DATE - 21

group by 1

),

AAVE as (

select block_timestamp::date daily,

count (distinct tx_hash) as num_transactions,

count (distinct depositor_address) num_wallets,

sum (zeroifnull(withdrawn_tokens)) volume,

sum (zeroifnull(withdrawn_usd)) volume_usd,

sum (volume) over (order by daily) cum_volume ,

sum (volume_usd) over (order by daily) cum_volume_usd

from ethereum.aave.ez_withdraws

where symbol ilike '%ETH%'

and block_timestamp::date >= CURRENT_DATE - 21

group by 1

),

compound as (

select block_timestamp::date daily,

count (distinct tx_hash) num_transactions,

count (distinct redeemer) num_wallets,