D as ( select date_trunc('day', block_timestamp) as day,

sum(amount_deposited) as eth_amount,

sum(amount_deposited) * avg(price) as eth_amount_usd,

count(distinct TX_HASH) as d_txCount,

count(distinct DEPOSITOR) as Depositors

from ethereum.maker.ez_deposits a

join ethereum.core.fact_hourly_token_prices b

on date_trunc('day', a.block_timestamp) = date_trunc('day', b.hour)

where a.symbol = 'WETH'

and b.symbol = 'WETH'

and day >= CURRENT_DATE - 90

group by 1),

W as ( select date_trunc('day', block_timestamp) as day,

sum(amount_withdrawn) as eth_amount,

sum(amount_withdrawn) * avg(price) as eth_amount_usd,

count(distinct TX_HASH) as w_txCount,

count(distinct WITHDRAWER) as Withdrawers

from ethereum.maker.ez_withdrawals a

join ethereum.core.fact_hourly_token_prices b

on date_trunc('day', a.block_timestamp) = date_trunc('day', b.hour)

where a.symbol = 'WETH'

and b.symbol = 'WETH'

and day >= CURRENT_DATE -90

group by 1),

F as (select D.day,

D.eth_amount AS Deposit_eth_amount,

W.eth_amount AS Withdraw_eth_amount,

D.eth_amount - W.eth_amount as Net_eth_amount,

case when Net_eth_amount<0 then '-' else '+' end as Net_Amount_status,

W.w_txCount AS "Withdraw TX number", D.d_txCount AS "Deposit TX number",

W.Withdrawers, D.Depositors