uni_cte as (

select

BLOCK_TIMESTAMP::date date

, LIQUIDITY_PROVIDER depositor

, tx_hash

, case

when token0_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then AMOUNT0_ADJUSTED

when token1_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then AMOUNT1_ADJUSTED

end amount

from ethereum.uniswapv3.ez_lp_actions

where 1=1

and action = 'INCREASE_LIQUIDITY'

and (

token0_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- WETH

or token1_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- WETH

)

)

, aave_cte as (

select

BLOCK_TIMESTAMP::date date

, DEPOSITOR_ADDRESS depositor

, tx_hash

, ISSUED_TOKENS amount

from ethereum.aave.ez_deposits

where 1=1

and AAVE_MARKET = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- WETH

)

, comp_cte as (

select

BLOCK_TIMESTAMP::date date

, SUPPLIER depositor

, tx_hash

, SUPPLIED_BASE_ASSET amount

from ethereum.compound.ez_deposits

where 1=1