select tx_hash

from ethereum.maker.ez_vault_creation),

tab2 as (

select date_trunc('month',BLOCK_TIMESTAMP) as month,tx_hash,AMOUNT_DEPOSITED

from ethereum.maker.ez_deposits

where TOKEN_DEPOSITED='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

)

select month,sum(AMOUNT_DEPOSITED) as weth_deposited

,avg(weth_deposited)over (order by month asc) as avg_deposit

,max(weth_deposited)over (order by month asc) as max_deposit

,min(weth_deposited)over (order by month asc) as min_deposit

from tab1

left join tab2

on tab1.tx_hash=tab2.tx_hash

group by 1

order by 1