BLOCK_TIMESTAMP::date AS "date",

COUNT (DISTINCT TX_HASH) AS withdraw_transactions,

COUNT (DISTINCT WITHDRAWER) AS distinct_withdrawer,

a.SYMBOL AS token_withdrawn,

SUM (AMOUNT_WITHDRAWN * PRICE) as volume_withdrawn

FROM ethereum.maker.ez_withdrawals a

LEFT JOIN ethereum.core.fact_hourly_token_prices b

ON HOUR = BLOCK_TIMESTAMP::date

AND a.symbol = b.symbol

WHERE BLOCK_TIMESTAMP >= '2022-01-01' AND TX_STATUS = 'SUCCESS'

GROUP BY "date", a.SYMBOL