date_trunc('day',BLOCK_TIMESTAMP) as day,

sum(AMOUNT_WITHDRAWN) as total_volume

from ethereum.maker.ez_withdrawals

where

symbol = 'WETH'

and TX_STATUS = 'SUCCESS'

and AMOUNT_WITHDRAWN > 0

and BLOCK_TIMESTAMP >= CURRENT_DATE - 30

group by 1