withdraw_list as (

select

a.block_timestamp::date as day,

count(distinct(withdrawer)) as withdrawers_count,

count(distinct(tx_hash)) as withdraw_tx_num,

sum(amount_withdrawn) as eth_amount,

avg(price) * sum(amount_withdrawn) as eth_price_usd

from ethereum.maker.ez_withdrawals a

join ethereum.core.fact_hourly_token_prices b

where 1 = 1

and a.block_timestamp::date = b.hour::date

and b.symbol = 'WETH'

and a.symbol = 'WETH'

and day >= '2022-09-01'

group by day

),

deposit_list as (

select

block_timestamp::date as day,

count(distinct(depositor)) as depositors_count,

count(distinct(tx_hash)) as deposit_tx_num,

sum(amount_deposited) as eth_amount,

avg(price) * sum(amount_deposited) as eth_price_usd

from ethereum.maker.ez_deposits a

join ethereum.core.fact_hourly_token_prices b

where 1 = 1

and a.block_timestamp::date = b.hour::date

and a.symbol = 'WETH'

and b.symbol = 'WETH'

and day >= '2022-09-01'

group by day

),