WITHDRAWER,

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 WITHDRAWER

HAVING volume_withdrawn IS NOT NULL

ORDER BY volume_withdrawn DESC