from ethereum.core.fact_hourly_token_prices

where SYMBOL = 'WETH'

group by 1 )

select a.block_timestamp::date as dayy, count(distinct a.tx_hash) as txns,

count(distinct a.withdrawer) as users, sum(a.amount_withdrawn) as volume,

sum(amount_withdrawn * p.eth_price) as volume_usd ,sum(volume) over (order by dayy) as cum_volume ,

sum(volume_usd) over (order by dayy) as cum_volume_usd

from ethereum.maker.ez_withdrawals a

join price p on p.day = a.block_timestamp::date

where symbol ilike '%ETH%'

and day >= '2022-06-01'

and tx_status = 'SUCCESS'

and block_number <= 15537393 --last block mined.

group by 1