with

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 >= '2022-07-01' and day < CURRENT_DATE

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,